KR970011900B1 - Database structure - Google Patents

Abstract

Disclosed is a structure of a database to vicariously execute receiving information charge in an intellectual network service control/management system. The structure comprises a main table, a receiving number table, a local routing table, a house distribution table and a levy table. The receiving number table and local routing table stores data which are commonly related to members. The local routing table stores a data list which is necessary for local prior routing. The house distribution table stores data which is necessary for house distributing. The levy table stores a data list which is necessary for changing levy ratio per day. Thereby, the structure can be a slave portion with in a master/slave database structure, and be a various utilization structure to provide house processing logic data.

Description

Information charge agency service processing database structure

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 an information charge storage service processing database (PSDB) according to the present invention;

3 is a configuration diagram of an information charge storage agent service processing main table according to the present invention;

4 is a structural diagram of an information charge receiving service processing called party number table according to the present invention;

5 is a structural diagram of a routing table for each information charge storage service processing region according to the present invention;

6 is a structural diagram of an information charge storage service processing call distribution table according to the present invention;

7 is a structural diagram of an information charge storage service processing date and time billing table according to the present invention.

* Explanation of symbols for main parts of the drawings

1: CMP (CCS7 MTP Processor)

2,3: Common Channel signaling Processor (CCP)

4: MAP (Maintenance Processor)

5,6: SLP (Service Logic Processor)

7: Operation and Administration Processor (OAP)

8: Service Management Processor (SMP)

9,10: LAN (Local Area Network) device

11,12: service processing memory database

13,14: service subscriber database

15: system node database

16: service subscriber master database

The present invention relates to an information charge storage agent service processing database structure.

Information charge storage agency service is a service that network operator, a network provider, handles the receipt of information charge that is the price of service to the service user. (IP: Information Provider) is a service that refunds the balance provided with a predetermined fee and a call charge.

In the conventional voice information service, a simple structured database is provided by using the function of an electronic exchange, but it is difficult to accommodate various complex service functions. Therefore, in order to provide an intelligent network information charge storage agent service having various service functions, a new database structure suitable for this is required. That is, the conventional technology may include a database structure of the 700 voice information service currently being provided, but it is provided as a simple database structure and thus cannot provide various service functions such as an information charge storage agent service. Therefore, in order to provide an information fee storage service having various service functions in an intelligent network to satisfy complex subscriber requirements, a service processing database structure suitable for this is required.

Disclosure of Invention The present invention devised to solve the problems of the prior art has an object of the present invention is to provide a service processing database structure for providing a service information storage agency service using a common line signaling network.

In order to achieve the above object, the present invention is an information charge storage agent service processing database applied to an intelligent network service control / management system, comprising: an information charge storage agent service processing main table storing data items common to service subscribers; Information fee storage agent service processing called number table; A routing table for each region for processing the information fee storage service, which stores data items necessary for short-range priority routing; An information charge storage agent service processing call distribution table for storing data necessary for a call distribution function; And an information charge storage agent service processing date and time billing table that stores data items necessary for the date and time rate change function.

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 drawings, "1" is 1: CCS7 MTP Processor (CMP), "2,3" is Common Channel Signaling Processor (CCP), and "4". Is a maintenance processor (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. (Local Area Network) device, "11, 12" is a service processing memory database, "13, 14" is a service subscriber database, "15" is a system node database, "16" is a service subscriber master database Represent each.

As shown in the figure, an intelligent network service control / management system is a form of a combination of a service controller (SCP) and a service management system (SMS) for providing an intelligent network service from a network standpoint. The function of the complex is accommodated. This system is a system that serves to provide various communication network services by providing an appropriate response when a query is input from the service exchanger, and a transaction is input through the CMP 1 connected to the signal network. The input transaction is in the form of a signal protocol message so that the first and second CCPs 2 and 3, which are the front end processors, process the signal connection control and the transaction handler in the protocol layer processing, and the result is returned to the LAN device 9 and 10. The first and second SLPs 5 and 6, which are the subsequent processors, process the dialogue handler on the protocol and process the first and second services of the first and second SLPs 5 and 6 in order to respond to each service. The response is generated by the service-specific logic data in the memory databases 11 and 12, and the results are transmitted in the reverse order.

Here, the redundancy of each processing device is composed for the purpose of pursuing the high performance and high reliability of the system. Under normal circumstances, the transaction processing is balanced between the front and back processors (2, 3, 5, 6), and if one component is abnormal, all the loads are handled by the normal processor.

In addition, the processor OAP (7), which is in charge of the operation management and maintenance of the system, is installed to perform the functions necessary for the overall operation of the system such as initial startup or initialization of the system, system configuration and operation data management, processor monitoring and transfer, and restart. . For this purpose, the system node database 15 is placed in the OAP 7. There is a MAP (4) to perform the function of the OAP (7) to ensure that the system operation is performed without interruption.

The first and second SLPs 5 and 6 have service logic data in the form of first and second service processing memory databases 11 and 12 and first and second service subscriber databases 13 and 14 for service processing. Exists as. The redundant management of service logic data in memory and disk is characterized by the fact that service call processing requires a response in real time. 11 and 12, and have first and second service subscriber databases 13 and 14 for backup and recovery of service logic data.

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 in order to minimize the influence on real-time service call processing.

FIG. 2 is a schematic diagram of an information charge storage service processing database according to the present invention. In order to provide information charge storage service among intelligent network services, FIG. Figure shows the structure of the database.

Information fee storage service functions include basic functions such as information fee storage service and voice guidance function, and optional features such as rate change per day, national representative number, local priority routing, mass call, call distribution, call restriction, and measurement. And a subscriber function and subscriber control function. Among these functions, the features that need to be stored in the form of a database in the intelligent network service control / management system include national representative number, near field priority routing, call distribution, and date / time rate change.

In the present invention, only the structure of the information charge storing service processing databases 11, 12, 13, and 14 is intended.

The information charge storage agent service processing database is a general term for the service processing memory databases 11 and 12 and the service subscriber databases 13 and 14. Among them, the service processing memory databases 11 and 12 refer to portions stored in a memory in order to satisfy a characteristic that service call processing requires a response in real time, and the service subscriber databases 13 and 14 represent service logic. The part stored on disk for data backup and recovery.

The information charge storage agent processing database includes information charge storage agent service processing main table 21, information charge storage service processing called party number table 22, information charge storage service processing region-specific routing table 23, information charge storage It consists of five tables, such as the agency service processing call distribution table 24 and the information charge storage agent service processing temporary billing table 25. The data items that the service subscribers have in common are the information charge storage agent service processing main table ( 21) and the information charge storage service processing called party number table 22, and the data items necessary for short-range priority routing are stored in the information charge storage service processing area-specific routing table 23, and the data necessary for the call distribution function The data item required for the rate change function by date and time is stored in the information fee storage service processing call distribution table 24, and the information fee It stores in the storage agency service process date and time billing table 25.

3 is a structural diagram of an information charge storage service processing main table according to the present invention, wherein the information charge storage service subscription number is a character (CHAR: character) type 4 byte (PR) PR subscriber field (pr_no) field; (filed) 31, service status / validation field 32 of integer type (INT), service function type (svc_type) field 33 of character type 4 bytes, and total of integer type It consists of the number of called lines (num_of_lines) 34.

At this time, the PR subscriber number field 31 is defined as an index key. Here, the service status / billing verification information field 32 stores service status information and billing verification information. The service function subscription field 33 includes information on whether to subscribe to the service function, the billing method, the information fee grade, and the temporary rate subscription. In addition, the total incoming call player field 34 stores the number of called numbers and the number of lines that can be actually called. Here each field of character type has its own length. Integer type fields do not need to be specified separately. The service status / billing verification information field 32 and the total incoming line count field 34 define an integer type.

4 is a structural diagram of an information fee receiving service processing called party number table according to the present invention. As shown in the drawing, the PR subscriber number (pr_no) field 41 of character type 4 bytes, which is a service subscription number, and the order of called party numbers. Is composed of an integer type index field 42 representing a symbol type, and a called type (called_line_num) field 43 of a character type 8 byte for storing a called number. At this time, the PR subscriber number field 41 and the index field 42 are defined as index keys.

FIG. 5 is a structural diagram of a routing table for each region for information charge storage service processing according to the present invention. As shown in the figure, a PR subscriber number (pr_no) field 51 of a character type 4 byte, which is a service subscription number, and a character type 4 byte, as shown in the figure. In the area code (area_code) field 52 of the character field, the line_index_list field 53 of character type 8 bytes for specifying a specific called number, and the routing_rate_list field 54 of character type 8 bytes. It is composed. At this time, the PR subscriber number field 51 and the area code field 52 are defined as index keys.

6 is a structural diagram of an information charge storage service processing call distribution table according to the present invention, and as shown in the figure, a PR subscriber number (pr_no) field 61 of character type 4 bytes, which is a service subscription number, and character type 16; A routing_rate_list field 62 of bytes. At this time, the PR subscriber number field 61 is defined as an index key.

7 is a structure of the information charge storage service processing date and time billing table according to the present invention. As shown in the figure, a PR subscriber number (pr_no) field 71 of character type 4 bytes, which is a service subscription number, and an integer type. Date and time fields (time_info) field 72, the integer type start_from field (73), and the discount rate of the character type 4 bytes to distinguish the specified date, specific day, time zone, and legal holiday (charge_rate) field 74.

At this time, the PR subscriber number field 71 and the temporary information field 72 are defined as index keys. Here, the start end time 73 stores a start time and an end time to which the discount rate is applied. In addition, the discount rate field 74 stores the discount rate on the designated date or time zone and the discount rate to be applied to the rest.

Accordingly, the present invention as described above can be applied to a database structure corresponding to a species in a system having a database structure of a master / slave relationship, and a service process for providing call processing logic data of a telephone service having various functions. Can be applied to the structure of a database.

Claims (11)

1. An information charge storage agent service processing database applied to an intelligent network service control / management system, comprising: an information charge storing service processing main table and an information charge storing service processing called party number table for storing data items commonly shared by service subscribers; A routing table for each region for processing the information fee storage service, which stores data items necessary for short-range priority routing; An information charge storage agent service processing call distribution table for storing data necessary for a call distribution function; And an information fee storage agent service processing database structure for storing the data items necessary for the date-to-date rate changing function. 2. The service information storage service processing main table according to claim 1, further comprising: a PR subscriber number field of a character type that is an information service storage service subscription number; An integer type service status / billing verification information field for storing service status information and billing verification information; A service function subscription field of a character type including information on whether to subscribe to a service function, a charging method, an information fee level, and a temporary rate subscription; And an integer-type total incoming line number field for storing the number of called numbers and the actual number of incoming lines. 3. The information fee storage agency service processing database structure according to claim 2, wherein said PR subscriber number field is defined by an index key. 2. The terminal of claim 1, wherein the information charge storage agent service processing called number table comprises: a PR subscriber number field of a character type which is an information charge storage agent service subscription number; An index field of an integer type indicating an order of a called number; And a called number field of a character type storing a called number. 5. The information fee storage agency service processing database structure according to claim 4, wherein said PR subscriber number field and index field are defined by an index key. 2. The system of claim 1, wherein the routing table for each information charge storage service processing region comprises: a PR subscriber number field of a character type, which is an information charge storage service subscription number; Area code field of character type; A called number index field 53 of a character type for specifying a specific called number; And a routing_rate_list field of the character type. 7. The information fee storage agency service processing database structure according to claim 6, wherein said PR subscriber number field and area code field are defined by an index key. 2. The service information distribution table service of claim 1, further comprising: a PR subscriber number field of a character type which is an information fee storage agency service subscription number; And a routing_rate_list field of the character type. 9. The information fee storage agency service processing database structure according to claim 8, wherein said PR subscriber number field is defined by an index key. 2. The method of claim 1, wherein the information fee storage service processing date and time billing table comprises: a PR subscriber number field of a character type which is an information fee storage agency service subscription number; A date and time information field of an integer type for distinguishing a specific designated day, a specific day of the week, a specific time zone, and a legal holiday; A start end time field of an integer type for storing a start time and an end time for applying a discount rate; And a discount rate field of a character type for storing a discount rate at a specified date or time and a discount rate to be applied in other cases. The information fee storage agency service processing database structure according to claim 10, wherein said PR subscriber number, field, and date and time information are defined by an index key.