KR100205076B1 - The db management method for sm service center in cellular system - Google Patents

Abstract

The present invention relates to a structure of a database system for a short service center applied to a cellular system and data management techniques used in the database system. The purpose is to allow a subscriber with a mobile terminal to send and receive a limited size message anytime, anywhere. Its characteristics are classified and managed for the basic functions of the short service center, but the short service service application that performs the kernel role of the short service center, the operation maintenance application for operating and maintaining the short service center, and PSTN ( Public Switched Telephone Network) It is divided into call control application that handles short message reception from subscriber and signal matching application that performs all signal matching functions related to short message service. Another feature is to separate data to be managed in short service center into real-time data and non-real-time data according to its characteristics to operate data management scheme separately, but to keep real-time data in main memory and minimize operation disk input / output The goal is to implement a separate database application to separate it from the non-real-time data management scheme.

Description

Method for managing database for short message service center in cellular system

The present invention relates to a structure of a database system for a short service center applied to a cellular system and data management techniques used in the database system.

In general, most commercial database management systems are developed to provide more convenient and various services for complex types of data management requirements in a distributed business environment. It is also evolving so that its use or scope can be applied to all fields, including computers. However, most communication systems in the communication field have their own characteristics, such as requiring serious real-time processing or changing the amount of data to be stored in the database with time, and dealing with huge data. . It is also characterized by relatively simple and repetitive data characteristics or types of transactions that have a significant impact on determining the functionality of a database management system. The characteristics of this communication field are not an exception for the mobile subscriber to implement a short message service for the purpose of message delivery, and various transactions in various types of information storage, user interface, complex client / server environment, or distributed system environment. Rather than simply managing functions, it should be able to quickly store and retrieve the data delivered according to the protocol of the teleservice layer and maintain the reliability of the stored data. It additionally requires some functions necessary to provide short service.

When using a commercially available database system, there is a problem that it does not satisfy the unnecessary overhead and the number of transactions that can be processed per unit time.

Disclosure of Invention The present invention devised to solve the above problems has an object of allowing a subscriber carrying a mobile terminal to send and receive a limited size message anytime, anywhere. In addition, the message delivery service should ensure that the message of the originating subscriber is correctly delivered anytime, anywhere, so that the present invention is directed to the subscriber even if any called party exists outside the service area or the terminal is powered off to receive the message. Another purpose is to ensure that the messages to be delivered are not lost. In addition, another object of the present invention is to enable a time-based service that can be delivered to a called subscriber at a specific point in time or a delayed period of time.

A characteristic of the present invention for achieving the above object is to manage the application for the basic functions of the short-service service center, the short-service service application to perform the kernel role of the short-service service center, and to operate the short service center and It is divided into a management maintenance application program, a call control application that handles short message reception, and a signal matching application program that performs all signal matching functions related to the short message service.

Another feature of the present invention for achieving the above object is to separate the data to be managed in the short service center into real-time data and non-real-time data according to its characteristics to operate a data management scheme separately, real-time data in the main memory It is to separate from the non-real time data management scheme by implementing a separate database application program to reside and minimize disk I / O during operation.

Another feature of the present invention for achieving the above object is to utilize the disk when the amount of data exceeds the memory resources limited to the system due to the increase in the amount of short message call.

Short service center has a function to store messages to be delivered to unreceivable subscribers in a database in the center and deliver them when they are recognized as receivable. There is a need to develop a database system that can efficiently support the development of operational maintenance software while satisfying the performance of the entire system. The short message service center in the mobile communication network is a system for relaying to exchange character information of a limited length between end terminals called Short Message Entity (SME). In the present invention, a new on-demand database system capable of handling the requirements of a short message service center is developed and applied to a short message service center of a CDMA digital cellular system. In particular, the database of the short service center should be provided with a variable-length text data management function capable of quickly retrieving and storing and managing messages of various lengths while managing a large amount of messages. In addition, the data items that compose the message have a complex structure including nested structure, so that various data types must be supported to express managed objects. In addition, it must be able to describe and manage an efficient physical structure for quick retrieval and storage, and support time-based triggering function to enable message delivery at the time required by subscribers. In addition, the data activation function associated with the operation of the application service that manages the message delivery function should be provided. In addition, databases for operational data management such as system configuration data management, billing data management, and various statistical data management are required, and these databases can be referred to each other and can be reused in preparation for future service functions or database addition. It must be configured to have a structure. Based on these requirements, we describe the structure of the short service center database system and techniques for managing the database to develop an on-demand database system that can satisfy the characteristics and performance of the short service center system in a digital cellular system.

1 is a structural diagram of a CMS network to which the present invention is applied.

2 is a block diagram of a short message service center used in the present invention.

3 is a block diagram of a data management system proposed in the present invention.

4 is a structural diagram of short message data management.

Hereinafter, with reference to the accompanying drawings will be described in detail one of the preferred embodiments according to the present invention.

As a result of comparing the suitability of database systems already commercialized according to the criteria described above, it is possible to improve the memory performance through the efficient management of the large amount of variable length data, to define the efficient physical storage structure using clustering, and the occurrence of events. It is judged that the application of object-oriented data model is more advantageous than the existing relational data model in terms of performance of specific routines, expansion and addition of effective services. Using object-oriented databases, unlike relational databases, developers who develop database applications define their own schema and transactions. This is because in the object-oriented data model, the database schema not only includes data but also stores operations to operate the data together, thereby reflecting the nature or operation rules of the data. Therefore, relational databases cannot dynamically respond to operational changes such as changing the access method applied or adjusting the physical location of tuples according to the amount of tuples performed in an online transaction. However, in an object-oriented database, data and the program that manages the data are managed together so that the program knows the state of the data so that the parameters of the system can be tuned during operation. Apply management strategies to help improve performance. For this reason, in the present invention, based on the commercialized object-oriented database system ObjectStore, we develop software modules that can handle the requirements of the database of the short-service service center described above and integrate them to develop an optimal database system. .

1 is a structural diagram of a CMS network to which the present invention is applied. Referring to Figure 1 describes the structure of a CMS network to which the present invention is applied.

This is a form of adding an SMS-MC 106 node to a CDMA digital cellular system in a CMS (CDMA Mobile System) network structure. MS (Mobile Station) 101 is a mobile subscriber station that supports protocol processing for IS-637 short service, EIA-232-E I / F function with PC, and MMI (Man-Machine Interface) function for short service. BTS (Basestation Transceiver System) supports short message transmission and reception through access / paging channel, and BSC (Base Station Controller) supports short message transmission and reception through traffic channel and converts and converts data burst messages into short messages. Function, and service option processing function (102). MSC (Mobile Switching Center) 103 is a transport protocol processing function for IS-637 short message service, representative number identification and access function of short message service center, public switched telephone network (hereinafter abbreviated as PSTN) (107) It provides relay call processing and trunk access function to short message service center. Visitor Location Register (VLR) 104 provides a short message subscriber authentication function, a short service subscriber information search function for incoming and outgoing short messages, routing to an incoming short service center, and incoming and outgoing subscribers whose location is not registered. Performs the location registration function. The home location register / authentication center (abbreviated as HLR / AC) 105 is a mobile subscriber information management function, routing information management function, short message service billing function, short service authentication function, incoming call Supports a short message receiving notification function of the terminal. The SMS-MC 106 is a system that performs a short message service that delivers a simple character string in a limited size message between the mobile station and the mobile station and between the mobile station and the short message entity (SME). It is connected by 7 signaling schemes and based on this, the SMS MAP protocol 109 is used to support the store-and-forward function, which is a non-real-time message delivery characteristic. In addition, for matching with the short-term service provider (hereinafter, referred to as SP) 110, it is referred to as a Public Switched Packet Data Network (hereinafter referred to as PSPDN) using X.25 or Ethernet protocol. It provides additional services that can be expressed in short messages, such as weather, travel, road traffic information, credit card authentication and inquiry, remote monitoring, and automatic vehicle navigation.

2 is a block diagram of a short message service center used in the present invention. Referring to Figure 2 describes the configuration of a short message service center used in the present invention as follows.

This is the platform structure of SMS-MC. The short message service center connects four computer systems with UNIX System V as the LAN and is designed to be easy to add depending on the capacity. Intelligent Peripheral (IP) provides users with special resources such as customized announcement devices, voice / language synthesis and recognition devices, DTMF digit receivers, tone generators, MF tone generators, etc. to support input and output of various information to PSTN subscribers. It provides a flexible interaction between and the network (202). IN (Intelligent Network) provides No.7 protocol stack and No.7 operation management for accessing No.7 signaling network and processes CMS (CDMA Mobile System) MAP protocol and teleservice layer protocol using TCAP API. Transmit and receive data with the MC connected via LAN (203). The Message Center (MC) that processes the SMS Service Logic is composed of SMS application functions using a short message database, and provides X.25 and Ethernet interfaces to support PSPDN external service provider matching (201). SMS OAM (Operating and Maintenance) performs the operation maintenance functions such as state management and configuration management of these systems (204).

Hereinafter, with reference to the accompanying drawings will be described in detail one of the preferred embodiments according to the present invention.

3 is a block diagram of a data management system proposed in the present invention. The configuration of the data management system proposed in the present invention with reference to FIG. 3 is as follows.

The application programs for the basic functions of the short service center are divided into short service application programs, application programs for system maintenance, call control applications, and signal matching applications. The short message service application (301) performs the kernel role of the short message service center, and if the short message received from the calling terminal cannot transmit to the called terminal or the called terminal cannot receive the message, the message is sent to the database. It is stored and transmitted when the called terminal is informed that it is in a receivable state. When the PSTN caller wants to send a short message to the mobile network receiver, the call control application program 302 sets up an attestation signal and a simulated incoming signal via the mobile communication switch, and transmits a short message using an announcement broadcast and a DTMF signal. It performs the role of processing. The operation maintenance application program 303 is a program for performing functions for operating a short service center such as billing and statistics, and resource and maintenance management functions for maintaining the reliability and efficiency of the center. The signal matching application 304 includes all signal matching functions related to the short service between the short service center and the MSC, between the short service center and the HLR, between the short service center and the SME, and between the short service center and the short service center. Do this. The database system of the short message service center is constructed based on the ObjectStore 305, an object-oriented database developed by Object Design. ObjectStore 305 supports a client / server architecture. Processes in server 306 manage physical data on disk 307, coordinate / arbiter client processes that require data, provide locking tables, deadlock detection, checkpointing, buffer management, and license management. The client 308 is a system that executes an application process that accesses a server on a network. The client 308 is an environment in which various software blocks performing a function of a short service center are performed. The short-term service center's database system implements a number of databases for permanent data by application software characteristics and stores them on a server, allowing multiple clients to access them by usage. Since this configuration depends on the functions to be executed by the type of data or transactions to be managed by each application software, the management goals of each database are independent and the performance objectives to be satisfied are different. These characteristics make it very effective to maintain different management systems to efficiently utilize limited system resources to provide optimal performance. In the present invention, data to be managed is divided into real-time data and non-real-time data so that real-time data is stored in main memory and non-real-time data is stored in a disk-based database to improve performance for real-time data management. To this end, a separate database application 309 having a library form between the application program and the database is managed to manage main memory resident of real-time data. In general, as a communication service uses the main memory database for real-time applications such as call processing and location information management, the short message service center promptly sends all short messages to the subscriber as soon as it is notified that the incapacitation state of a particular terminal is released. In principle, the main memory database is used for searching and delivering. On the other hand, a disk-based database is implemented for non-real-time data management such as system configuration information and billing information such as temporary data or call control and signal matching equipment, such as status management and periodic statistical information for the operation maintenance function of the center. This allows the system to utilize the limited main memory area for real-time access. The database application program of short service center is composed of interface module, clustering module, segment management module, and event management module. The interface module 310 is a module for receiving a data access request from an application program and providing a result. The interface module 310 analyzes the parameters of the input request to call a necessary module and configures the result after the operation on the database in the form desired by the application program. do. Clustering module 311 is a module for adjusting the physical location of the data in order to minimize the number of disk input and output during operation. When the traffic volume increases, the amount of messages to be stored in the short message center increases, and if the limited main memory resources are exceeded, all data cannot be stored in the main memory and the disk can only be used. In this state, in the worst case, all kinds of stored messages are physically clustered and stored to perform one disk operation, and pointers to them are always in main memory to support real-time access. Such clustering reflects the transaction characteristics of the database application program and stores a plurality of data retrieved at the same time as possible in one area that becomes the disk I / O unit. The segment management module 312 is a segment management module that is a reference area for clustering objects stored in a database. The segment management module 312 stores a limited number of cloners in one segment and manages each segment to be sequentially filled during operation. It supports efficient management of memory. The access module 313 is a module that searches for, inputs, and deletes messages. The access technique for data in the database depends on the type and size of the data to be searched and the number of objects that can be input. This data retrieval technique affects the transaction processing time of the database. In general, once a database access method is determined, it uses a fixed method until a new schema is applied. For example, if a relation in a relational database chooses an access scheme that is appropriate for the nature of the key attribute, all transactions that access that relation will use it. In the case of a short message database, data retrieval is performed by the identification number of the calling / receiving subscriber or the time when the message is stored. In addition, since the number of objects to be searched is very wide and the input / output of objects is frequent, the hash method is more suitable than the indexing method or the access using the tree structure. However, the application of this hash technique also occurs when the input / output of data is frequently changed and the amount of data stored in the database at any time is large, so if one hash function is applied, continuous and stable performance cannot be provided. This is because the hash function that enables the fastest searching can be different depending on the number of tuples or objects. Therefore, in the short service center's database, it is possible to apply an appropriate hash function according to the amount of data stored during operation, thereby providing optimum access performance. Event management module 314 is a module for managing events over time for time-based triggering. Service requests that need to deliver a message at a subscriber-specified time or at any point in time for a specified time require triggering capabilities based on time events, which are related to the types of services that a short service center must provide. This is done by activating the delivery action to the children. It uses the data abstraction and object encapsulation, which are the basis of object-oriented concepts, to connect a series of data to be delivered to the called subscriber and to activate it according to the occurrence of time events. To be.

4 is a structural diagram of short message data management. Referring to FIG. 4, the structure of short message data management will be described as follows.

This is a structure of data for efficient management of short message data. When a core transaction of a short service application using a short message database is informed at any point in time that any called subscriber is in a state capable of receiving a message from the present subscriber locator that oversees registration and location information for all subscribers of the cellular network. It searches all messages stored in the database and delivers the message for the called party. In addition, such a transaction is preceded by a transaction that stores the message in the database when the called party is out of the service area or when the mobile terminal is powered off. It is assumed that a transaction is executed. In this case, the storage and deletion operation of a message requires processing of one specific message, and thus takes a random access form. In some cases, a query is made based on a calling party number, a called party number, a time when a message is stored, and a message ID. Is performed. However, the message retrieval operation takes the form of a range query that requires retrieval of multiple messages at the same time based on a particular called party. The messages to be managed in the short service center can be divided into basic service message and supplementary service message. The messages for basic service are CPT message, CMT message, VMN message, EMN message, FMN message, UserAck message, DeliveryAck message, and The message for the supplementary service is divided into a CancellationAck message and includes message information received from service providers connected to the short service center.

In the present invention, the message buffers 402, 403, 404 are defined for each of these message types. The message buffers are CPT message buffers, CMT message buffers, VMN message buffers, EMN message buffers, FMN message buffers, and UserAck message buffers for one called subscriber. Eight message buffers are allocated, such as a DeliveryAck message buffer and a CancellationAck message buffer, and these message buffers are configured to facilitate retrieval of information by being grouped for the same called subscriber. One or more message buffers exist in the group of message buffers 408, and are dynamically allocated or released according to message input and delete operations. The group of message buffers for the called subscriber necessarily excludes disk operations during information retrieval by storing all clusters in the cache, i.e., main memory, that are stored in the same cluster 405, 406 and that the cache area allocated for the short database is available. The address of each of these groups is also stored in the called party message buffer 401 with each called party number so that all messages for that subscriber can be retrieved when retrieving data for any called party. In order to retrieve data through a calling party number having a random access form, a message buffer is configured for each type of message, and the message buffers for the same calling party are grouped and stored in the calling party message buffer 407 as in the called subscriber operating method. However, only message buffers for a particular originating subscriber can be stored in different clusters, and this structure does not degrade data access performance during operation. In addition, for fast data retrieval, incoming / outgoing message buffers are stored separately in a specific cluster so that they always reside in main memory.

The database system for short service center proposed in the present invention applies a separate management system for real-time data and non-real-time data using an object-oriented database, and implements a variable access method according to the clustering of data and the amount of stored objects. The application enables high performance access under limited memory resources. In addition, since the program that controls the data flow is stored together in the database, we have built a database system that satisfies the requirements such as triggering according to time events or activation of the procedure required for short message service. Database applications are implemented so that fields can operate effectively on an object-oriented database management system. The developed database must control both real-time and non-real-time data simultaneously and can be applied to many applications in the communication field with requirements such as activation of time-dependent actions. It can be used to build a satisfying on-demand database.

Claims (7)

A single-part service application program that manages applications for basic functions of a short-term service center, and performs a kernel role of the short-service service center; An operation maintenance application program for operating and maintaining the short service center; A call control application that handles the receipt of short messages from PSTN subscribers; And a signal matching application program that performs all signal matching functions related to the short message service. The system of claim 1, wherein the short service application program comprises: an interface module for receiving a data access request from the application program and providing a result; Clustering module for adjusting the physical location of the data to minimize the number of disk input and output during operation; A segment management module supporting efficient management of fragmented main memory; An access module for searching, inputting, and deleting the messages; And an event management module, the database management method for a short service center of a cellular system. 3. The apparatus of claim 2, wherein the clustering module stores all kinds of messages to perform one disk operation when the amount of messages to be stored in the short message center increases due to the bursting of the call volume and exceeds a limited main memory resource. A method for managing a database for a short service center of a cellular system, characterized by supporting real-time access by physically clustering and storing messages and locating pointers thereof in main memory. According to claim 3, wherein the clustering reflects the transaction characteristics of the database application program in the worst case by storing a plurality of data retrieved in the same time zone as possible as a disk I / O unit in one worst case disk I / O Database management method for a short service center of a cellular system, characterized in that to complete the transaction. The method of claim 2, wherein the segment management module supports efficient management of fragmented main memory by storing a limited number of clusters in one segment and managing each segment to be sequentially filled during operation. Database management method for short service center of cellular system. In the short service center, the data to be managed is divided into real-time data and non-real-time data according to its characteristics to operate a data management scheme separately, wherein the real-time data resides in main memory; A database management method for a short service center of a cellular system, characterized by separating a non-real time data management scheme by implementing a separate database application program to minimize disk I / O during operation. Short message Database management method for a short service center of a cellular system, characterized in that the disk is utilized when the amount of data exceeds the memory resources limited to the system due to the increase in the call volume.