Method of creating meta data and processor load data in a mobile switching center

• US 5,995,968 A
• Filed: 12/02/1997
• Issued: 11/30/1999
• Est. Priority Date: 12/16/1996
• Status: Expired due to Fees

• Current Assignee: Electronics and Telecommunications Research Institute, Korea Telecommunication Authority
• Original Assignee: Electronics and Telecommunications Research Institute, Korea Telecommunication Authority
• Inventors: Shin, Jae Wook, Park, Kwang Roh
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US08/982,512
• Time in Patent Office: 728 Days
• Field of Search: 707/100, 707/200, 707/10, 707/4, 455/445, 455/439, 455/428, 455/432, 455/517, 455/560, 455/95, 379/9, 379/84, 379/165, 379/308
• US Class Current: 455/439
• CPC Class Codes: H04Q 3/54591 Supervision, e.g. fault localisation, traffic measurements, avoiding errors, failure recovery, monitoring, statistical analysis
• CPC Class Codes: H04W 4/18 Information format or content conversion, e.g. adaptation by the network of the transmitted or received information for the purpose of wireless delivery to users or terminals
• CPC Class Codes: H04W 88/14 Backbone network devices
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/96 Object-relational

Abstract

A method for directly performing a data analysis, a logical design and a physical design processes on an EDIF file and an initial data, without utilizing Troll relational Database system, to create an optimized schema, a meta data and a processor load (PLD) without any overlapped process. First, the EDIF file and the initial data file are received and an initial system environment is set for creating the meta data and the processor load data. Further, a DBMS_-- MODE.sp file and a DBMS_-- REL.sp file are created such that the database mode specification file represent a recorded definition of a SET mode defined in all the EDIF files, and such that the database relation specification file represent a recorded definition of the relation in all the EDIF files which are being converted into Chill Syntax Structure. Various meta data corresponding to each processor are created based on the catalogue of transaction files. Additionally, the data format specification files and link data files are used in creating the PLD.

Claims

1. A method of directly creating meta data and processor load data in a mobile switching center, which comprising the following steps:

(a) receiving an Exchange Data Input Form("EDIF") file and an initial data file, and setting an initial system environment for creating the meta data and the processor load data, wherein each of EDIF files is comprised of a multiplicity of relations, each of which being provided with a number of attributes;

(b) setting a directory environment containing a data base common file, and creating a data base mode specification file and a data base relation specification file, wherein the data base mode specification file represents that is recorded definition of SET mode defined at all the EDIF files, and the data base relation specification file represents that is recorded definition of the relation in all the EDIF files which being converted into Chill syntax structure;

(c) creating various meta data corresponding to each processor, based on catalogue of the EDIF files and catalogue of transaction files obtained at the step(a);

(d) setting an environment for creating LOCK, duplicating, a partial distribution and Index information according to relation storage forms, and creating a plurality of data format specification files to be used in creating the processor load data; and

(e) setting an environment for creating files of the processor load data in concordance with system types of the mobile switching center, creating a multiplicity of files for use in link during the creation of the processor load data, and creating the processor load data through the use of the multiplicity of files.

2. The method according to claim 1, wherein said step (a) of setting the initial system environment, which includes:

(a1) creating catalogue of the EDIF files, catalogue of the transaction file, catalogue of the initial data file, catalogue of the processors defined on the system types, and catalogue of an unique relation identifier, wherein the catalogue of the initial data file are created based on the catalogue of the EDIF files; and

(a2) checking whether an error is generated at the above step (a1), wherein if the error is generated thereon, an error message containing an error message code is notified to an administrator; and

if there is no the error, a data base common file necessary for compiling a source program is created.

3. The method according to claim 1, wherein said step (b) of creating the data base mode specification file and the data base relation specification file, which includes:

(b1) checking whether an include directory exists or not, the include directory being utilized for storing therein the database common file necessary for compiling the source program, wherein in case of the absence of the include directory, the include directory is created and the catalogue of the EDIF files obtained at the step (a) is then inputted;

(b2) extracting a relation from the catalogue of the inputted EDIF file and creating a storage file of relation name;

(b3) extracting an attribute from the relations and creating a storage file with Chill syntax form;

(b4) checking whether the extracted attribute has been set as the SET mode, and creating the data base mode specification file and a SET mode storage file, if the extracted attribute has been set as the SET mode;

(b5) checking whether a current attribute is final, and iterately performing the above steps (b3) to (b4) with respect to all the attributes in the relation corresponding thereto until the final attribute is determined, if the current attribute is not final;

(b6) checking whether a current relation is final or not, and iterately performing the above steps (b2) to (b5) with respect to all the relations until the final attribute is determined, if the current relation is not final;

(b7) checking whether a current EDIF file is final, and iterately performing the above steps (b1) to (b6) with respect to sequent EDIF files until the final EDIF file is determined, if the current EDIF file is not final; and

(b8) creating, after being performed the step (b7) until the final EDIF file is determined, the data base 10 relation specification file by combining the relation name storage file obtained at the step (b2), the SET mode storage file obtained at the step (b4) and the Chill syntax storage file obtained at the step (b3).

4. The method according to claim 1, wherein said step (c) of creating the meta data, which includes:

(c1) checking whether a catalog directory and processor directories exist or not, and creating the catalog directory and the processor directory if there is no both, wherein the catalog directory stores the catalogue of the meta data created from each of the processors, the processor directories being created with respect to each of the processors defined in the system types;

(c2) inputting the catalogue of the EDIF files obtained at the step (a);

(c3) extracting a relation and a corresponding relation identifier from the catalogue of the inputted EDIF file and the catalogue of the relation identifier, respectively;

(c4) creating, based on the extracted relation and the extracted identifier, a G_-- CAT file having relation associated information, an R_-- A_-- CAT file having attribute associated information, an L_-- CAT file having the attribute associated information corresponding to each of the processors, an ACM_-- CAT file having information involved in access method of the attributes in the relation, an ACR_-- CAT file having access right information for each of the relations, and an SOR_-- DIR_-- INFORM file having information involved in direct access relation;

(c5) checking, after being terminated the above step (c4), whether a current relation is final or not, and iterately performing the above steps (c3) to (c4) with respect to all the relations until the final relation is determined, if the current relation is not final;

(c6) checking whether a current EDIF file is final or not, and iterately performing the above steps (c2) to (c5) with respect to all the EDIF files until the final EDIF file is determined, if the current EDIF file is not final;

(c7) after being performed the above step (c6) until the final EDIF file is determined, inputting the catalogue of the transaction files obtained at the step (a);

(c8) extracting a transaction from the catalogue of the transaction file, and creating an SOR_-- TRCONF_-- INFORM file and an SOR_-- TRPREL_-- INFORM file, wherein the SOR_-- TRCONF_-- INFORM file includes a name of the extracted transaction, an identifier of the transaction, a maximum performance time of the transaction and the number of performed processors, and the SOR_-- TRPREL_-- INFORM file includes the extracted transaction name, the transaction identifier, the number of the transaction relations and the number of processors to be performed;

(c9) checking whether a current transaction is final or not, performing the above step (c8) with respect to all the transactions until the final transaction is determined, if the current transaction is not final; and

(c10) checking whether a current transaction file is final or not, and performing the above steps (c7) to (c9) with respect to all the transaction files until the final transaction file is determined, if the current transaction file is not final.

5. The method according to claim 1, wherein said step (d) of creating the data format specification files, which includes:

(d1) checking whether the data format specification file directory exists or not, and creating the data format specification file directory in case of the absence of the directory;

(d2) inputting the catalogue of the EDIF file obtained at the step (a);

(d3) extracting a relation and a processor from the catalogue of the inputted EDIF file and the field of the processors, respectively;

(d4) checking whether the extracted processor is contained in the processor catalogue obtained at the step (a);

creating an SOR LOCK_-- INFORM file containing the relation identifiers corresponding to each of the processors with respect to the relation whose the access right field is defined as LOCK, a PDIS_-- INFORM file containing the relation identifier, the number of distributed processors and name of the processors with respect to the relation whose the storage form field is defined as PDIS, an REP_-- INFORM file containing the relation identifier, the number of duplicated processors and the catalogue thereof with respect to the processors with the duplicated relations, an SYS_-- INFORM file containing system associated information, and an INDEX_-- INFORM file containing the relation identifier and a size of subindex with respect to the relation whose the access method of the key attribute is defined as INDEX, If the extracted processor is contained in the processor catalogue; and

notifying the error message to the administrator if the extracted processor is offset from the processor catalogue;

(d5) checking whether a current relation is final or not, and iterately performing the above steps (d3) to (d4) with respect to all the relations until the final relation is determined, if the current relation is not final; and

(d6) checking whether a current EDIF file is final or not, and iterately performing the above steps (d2) to (d5) with respect to all the EDIF files until the final EDIF file is determined, if the current EDIF file is not final.

6. The method according to claim 1, wherein said step (e) of creating the processor load data, which includes:

(e1) checking whether a dgpool directory exists or not, and creating the dgpool directory in case of the absence of the dgpool directory, wherein the dgpool directory creates a multiplicity of program load data according to the system types;

(e2) inputting the catalogue of the EDIF file obtained at the step (a);

(e3) extracting a relation from the catalogue of the inputted EDIF file, converting the relation definition of the EDIF file into a DIL(Data Input Language) format which being the Chill syntax pattern, and creating an Hdr.dil file containing all converted data derived at the above step (e3) and an Xref.dil file containing the relation identifier, the number of tuples, a type of the data, catalogue of a local and a global processors, wherein the Hdr.dil file is used to create an Initialized Relation Object File("IROF") to be contained in the processor load data, and the Xref.dil file is utilized for linking the IROF during the creation of the processor load data;

(e4) checking whether a current relation is final or not, and performing the above step (e3) with respect to all the relations until the final relation is determined, if the current relation is not final;

(e5) checking whether a current EDIF file is final or not, and iterately performing the above steps (e2) to (e4) with respect to all the EDIF files until the final EDIF file is determined, if the current EDIF file is not final;

(e6) inputting the catalogue of the processors derived at the step (a) and the Xref.dil file derived at the above step (e3);

(e7) extracting a processor from the inputted Xref.dil file;

(e8) checking whether the extracted processor corresponds a processor to be employed to creating the processor load data, extracting corresponding relation information, information for various meta data stored at the catalogue directory, and the dfsf information containing the PDIS_-- INFORM, the REP_-- INFROM and the SYS_-- INFORM files, if the extracted processor corresponds thereto, creating a head file, inputting the initial data file from the catalogue of the initial data file defined according to the system types, to thereby create a data file;

(e9) receiving sequentially the Xref.dil file with respect to all the relations, extracting a processor to be employed to creating the processor load data, and performing the above step (e8) on the extracted processor;

(e10) after being performed the above step (e9) on the final relation, creating the processor load data to be loaded to the corresponding processor by combining the head file and the data file; and

(e11) repeating the above steps (e6) to (e10) until the final processor to be employed to creating the processor load data is determined.