KR100228404B1 - Method for generating database driving environment in intelligent network service controlling/managing system - Google Patents

Abstract

1. TECHNICAL FIELD OF THE INVENTION

Database Driven Environment Creation Method in Intelligent Network Service Control / Management System

2. The technical problem to be solved by the invention

Integrate and automate the entire process required to create the database driving environment, systematize source code management using source code configuration management tool provided by computer system operation system, which is the execution environment of intelligent network service control / management system, and execute remote command To provide a method of creating a database operating environment that enables remote installation of executable code using a tool.

3. Summary of Solution to Invention

The present invention compiles the source code to generate the execution code, and then sequentially generates the initial operating environment, tables, and indexes, and gives access to the user, so that anyone can easily create a database driving environment and systematically manage source code. It can be used to remotely install executable code.

4. Important uses of the invention

Used for intelligent network service control / management system.

Description

Database Driven Environment Creation Method in Intelligent Network Service Control / Management System

The present invention relates to a method for creating a database operating environment of an intelligent network service control / management system (NICS), and in particular, a broadband call service and a credit call service provided by an intelligent network service control / management system (NICS). Network service for initial management of disk-based database, table creation, index creation and user access authority A method for creating a database operating environment in a control / management system (NICS).

Intelligent Network Service Control / Management System (NICS) is a core device of intelligent network components. It separates the intelligence needed to provide special services from the switch and implements it on a general-purpose computer, making it easier and faster to implement and provide communication network services. It is a system that makes it convenient.

Conventionally, in the method of creating a disk-based database driving environment, a series of generation procedures are not integrated and automated, so that the data definition language (DDL) of the database management system (DBMS) is not available. Without sufficient prior knowledge, it was difficult to create a database operating environment. In addition, the systematic management of source code written in a series of data definition language (DDL) and the remote installation of executable code has been difficult.

In order to solve the above problems, the present invention integrates and automates all processes necessary for creating a database driving environment, and provides a computer system operating system (UNIX) which is an execution environment of an intelligent network service control / management system (NICS). Create source code management system using source code control system (SCCS) and create database operating environment that enables remote installation of executable code using remote command execution tool (REMSH). The purpose is to provide a method.

1 is a block diagram of an intelligent network service control / management system to which the present invention is applied,

2 is a structural diagram of a database driving environment generation block to which the present invention is applied;

3 is a flowchart of a database driving environment generation execution code installation process according to an embodiment of the present invention;

4 is a flowchart of a database driving environment creation process according to an embodiment of the present invention.

* Explanation of symbols for the main parts of the drawings

1: CMP (CCS7 MTP Processor)

2,3: CCP (CCS Processor)

4: MAP (Maintenance Processor)

5,6: SLP (Service Logic Processor)

7: Operation and Administration Processor (OAP)

8: Service Management Processor (SMP)

9,10: LAN (ALN)

11,12 service memory database

13,14: service subscriber database

15: system node database

16: service subscriber master database

In order to achieve the above object, the present invention provides a method for generating a database driving environment applied to an intelligent network service control / management system, comprising: a first step of compiling source code to generate execution code; A second step of generating an initial driving environment by reading an initial driving environment setting file including initial driving environment setting information; A third step of reading a table creation file and creating a storage space for storing data; A fourth step of generating an index for the data storage space generated by reading the index generation file; And a fifth step of reading a security generation file including user authority information and granting user access authority.

Hereinafter, with reference to the accompanying drawings will be described an embodiment according to the present invention;

1 is a configuration diagram of an intelligent network service control / management system to which the present invention is applied. In the drawing, "1" is CMP (CCS7 MTP Processor), "2,3" is CCP (CCS Processor), and "4" is MAP ( "5,6" is a Service Logic Processor (SLP), "7" is an Operation and Administration Processor (OAP), "8" is a Service Management Processor (SMP), and "9,10" is a LAN. "11, 12" represents a service processing memory database, "13, 14" represents a service subscriber database, "15" represents a system node database, and "16" represents a service subscriber master database.

The intelligent network service control / management system (NICS) combines SCP (Service Control Point), a service control node, and Service Management System (SMS), from the perspective of a network providing intelligent network services. It accommodates the complex.

The intelligent network service control / management system is a system that controls various communication network services by providing an appropriate response when a query is input from a service exchanger, and through a CMP (CCS7 Message Transfer Part Processor) (1) connected to a signaling network. The transaction is entered.

The input transaction is in the form of a signal protocol message, and the CCP processor (2, 3), which is a front end processor, performs signal connection control and transaction handler processing in protocol layer processing, and the result is again a LAN device. Service Logic Processor (SLP) (5,6), which is a downstream processor, processes the dialogue handler on the protocol through (9,10), and the service processing memory database of SLP (5,6) is used to respond to each service. The response is generated according to the service-specific logic data in (11, 12), and the result is transmitted in the reverse order.

Here, the redundancy of each processing device is composed for the purpose of pursuing high performance and high reliability of the intelligent network service control / management system. Under normal circumstances, transaction processing is balanced between the front and back processors (2, 3, 5, 6), and if one factor is abnormal, all the load sharing is performed by the normal processor.

In addition, the OAP (Operation and Administration Processor) (7) is the processor that manages the operation and maintenance of the system, and when the system is first started or initialized, system configuration and operation data management, processor monitoring and switching, restart, etc. Perform the functions necessary for the overall operation of the system. For this purpose, the system node database 15 is placed in the OAP 7. There is a MAP (Maintenance Processor) (4) to replace the function of the OAP (7) so that the system operation can be performed without interruption.

In the SLP 5 and 6, service logic data exists in the form of service processing memory databases 11 and 12 and service subscriber databases 13 and 14 for service processing. In this redundant management, since service call processing requires a response in real time, a service processing memory database (11, 12) is configured as a memory resident database, and the service logic data backup and Service subscriber databases 13 and 14 are placed for recovery.

The service subscriber data is distributed and stored in SMP (8), SLP1 (5), and SLP2 (6) to provide wide area incoming billing service, credit call service, and information charge storage service in intelligent network service control / management system. The place where the subscriber data is stored is the subscriber base database 16, the service processing memory databases 11 and 12 and the service subscriber databases 13 and 14, respectively. The service processing memory databases 11 and 12 and the service subscriber databases 13 and 14 have substantially the same format and contents.

The SMP 8 is a processor for managing subscriber data management and service operation status of an intelligent network service. The SMP 8 has a service subscriber master database 16 in the SMP 8 to minimize the influence on real-time service call processing.

The database of the intelligent network service control / management system (NICS) is composed of various forms according to the type of data and the characteristics of the database. Among the various types of databases, the databases directly related to the present invention are the system node database 15 and the service subscriber master database 16. The system node database 15 and the service subscriber master database 16 are built on the OAP 7 and the SMP 8, respectively, and the hardware is Hewlett Packard's "HP9000 Series 835 System". The base management system (DBMS) software is Hewlett Packard (HP) 's "ALLBASE / SQL" relational database.

2 is a structural diagram of a database driving environment generation block to which the present invention is applied.

The operator creates a database driving environment in the work seat 31 to create a driving environment of a database for storing, retrieving, and managing data required for operation management and service data management of an intelligent network service control / management system (NICS). Enter the command. The driving environment generation consists of four functions (32).

The first function is the initial configuration function. The parameters of the database configuration file size, the log file size, the number of concurrently executed transactions, and the data buffer and log buffer size are related to the initial operation environment of all users who access the database. Set the value.

The second function is to create a data / index tablespace in which the data will be stored in the database environment.

The third function is to create an index of each table for efficient and fast data search and access.

The fourth feature is to grant permissions only to users with the appropriate credentials.

These functions are processed sequentially in the database drive environment generation block 33, and outputs the drive environment generation details to the operator's work seat 31.

In the intelligent network service control / management system (NICS), a system node database (35) consisting of a system configuration management database, a measurement management database, and a failure management database in the OAP (7) for system operation management and maintenance. The subscriber master configured for each service, such as a wide area incoming billing service master database, a credit call service master database, and an information payment storage service master database, to the SMP (8) for service subscriber data management. Establish and use the database 36, and manage the operation data for each service, such as the wide area incoming and outgoing billing service operation management database, the credit call service operation management database, and the information payment storage service operation management database, to the SMP (8). And global incoming and outgoing billing service traffic database, credit calling service Pick database uses the information to build a fuel storage agency services such as traffic database service is configured to manage specific traffic data service operation management database (37). All these databases use a disk based database management system (ALLBASE / SQL) 34.

3 is a flowchart illustrating a process of installing a database driving environment generation execution code according to an embodiment of the present invention.

In order to generate a command (MMC: Man Machine Command) to be used to execute the creation of a database driving environment, an installation command is started at the OAP 7 in which the source code is located (51). In case of remote installation to SMP (8) rather than installation on OAP (7) (52), it is checked whether a directory to copy and install source code exists in SMP (53) (53). After generating (54) copy the source code in OAP (7) to the directory that created it (55), and if the directory exists, copy the source code in OAP (7) directly to the directory where it was created ( 55) Perform the following procedure.

On the other hand, if the remote installation (52) does not perform the process of generating the directory and the source code. The source code is compiled (56) to generate executable code, that is, a database driving environment generation instruction (MMC) (57). In case of remote installation to SMP (8) (58), after deleting source code that was copied for centralized source code management in OAP (59) (59), the execution code installation is terminated (60). If not (58), the installation is terminated immediately after generation of the executable code (60).

4 is a flowchart of a database driving environment creation process according to an embodiment of the present invention.

The driving environment generation is started by the input of the database driving environment generation command (71). First, after reading the initial operating environment setting file including relevant information for initial driving environment setting (72), the initial driving environment is created, and the database configuration file of the size specified in the directory where the database driving environment is created is created. Creates and registers the log method information and the number of transactions that can be executed simultaneously in the configuration file. It also creates a log file corresponding to the specified log method (Dual or Single) and its size. The data buffer and log buffer sizes can also be set. If not set, the default value (default) is set (73).

After that, a process of creating a storage space for data is performed. That is, after reading the table creation file containing the relevant information (74), a database file set (substantial data storage in a Unix file) is created on disk. Next, create a database file, which is a logical collection concept, and create a table to store data in it for management of each table's relevance and characteristics. After the table file is included in the database file set, the table is ended (75).

Next, create an index for the created table. That is, after reading the index creation file containing the relevant information (76), an index is created on each table requiring the index, and the generated index information is reflected in the system catalog, indicating that the information of the created table has changed. (77).

Finally, after reading the security creation file containing the user's credentials (78), grant the user level access to the database administrator and the users who have access to the data, and then operate the table-by-table to the authorized user again. After granting (search, insert, delete, change) permission (79), all driving environment creation is terminated (80).

The present invention described above is capable of various substitutions, modifications, and changes without departing from the spirit of the present invention for those skilled in the art to which the present invention pertains, and the above-described embodiments and accompanying It is not limited to the drawing.

As described above, the present invention integrates and automates a series of creation procedures to create a database driving environment in a disk based intelligent network service control / management system (NICS). A source code configuration management tool (SCCS) provided by the computer system operating system (UNIX), which can create a database operating environment without sufficient prior knowledge of Definition Language, and is an execution environment of an intelligent network service control / management system (NICS). Source code control system) can be used to systematically manage source code, and remote command execution tool (REMSH: Remote Shell) can be used to remotely install executable code.

Claims (6)

A method for generating a database driving environment applied to an intelligent network service control / management system, comprising: a first step of compiling source code to generate execution code; A second step of generating an initial driving environment by reading an initial driving environment setting file including initial driving environment setting information; A third step of reading a table creation file and creating a storage space for storing data; A fourth step of generating an index for the data storage space generated by reading the index generation file; And a fifth step of granting a user access authority by reading a security generation file including user authority information. The method of claim 1, wherein the first step comprises: determining whether a remote installation is performed when an installation command is started in a processor in which a source code is located; As a result of the determination step, in case of remote installation, it is checked whether a directory for installing the source code exists. If the directory does not exist, the directory is created and then copied to the directory where the source code is generated. Copying the code to the directory where the code was generated, and then compiling the source code to generate the execution code (database driving environment generation command), and then deleting the copied source code and ending the installation of the execution code; And a step of terminating the execution code installation after generating the execution code (database driving environment generation command) by compiling the source code if the remote installation is not determined as a result of the determination step. Way. The method of claim 1, wherein the second step comprises: generating an initial driving environment by reading an initial driving environment setting file including initial driving environment setting information when the driving environment generation starts; Generating a database shape file and registering information on a log method and information on the number of transactions that can be executed at the same time; And generating a log file. 4. The method of claim 3, wherein the third step comprises: reading a table creation file to create a database fileset on disk; Creating a database file which is a logical collection concept for management according to the relevance and characteristics of each table; And after creating a table to store data in the created database file, including the database file in the database file set. 5. The method of claim 4, wherein the fourth step comprises: reading an index generation file to create an index on each table for which the need for an index is required; And reflecting the generated index information in the system catalog to inform that the information of the pre-generated table has been changed. The method of claim 5, wherein the fifth step comprises: reading a security generation file including user authority information and granting a user level access authority to a database administrator and a user who allows access to data; And terminating the driving environment by granting the table-specific operation authority to the user who has been given the use authority.