CN1862538A

CN1862538A - Data configuration system and method for implementing data configuration

Info

Publication number: CN1862538A
Application number: CN 200610057791
Authority: CN
Inventors: 陈丹博; 宋涛; 张宏
Original assignee: Huawei Technologies Co Ltd
Current assignee: Huawei Technologies Co Ltd
Priority date: 2006-02-27
Filing date: 2006-02-27
Publication date: 2006-11-15
Anticipated expiration: 2026-02-27
Also published as: CN100433012C

Abstract

The present invention relates to a data configuration system and method for implementing data configuration. Said system includes data base and data conversion portion. Said data base is used for storing entity data of different versions: and the data conversion portion is used for making data conversion between entity data of different versions in data base and user's configuration interface, creating mutual reading/writing conversion of data base data and user's configuration interface and implementing conversion between entity data of different versions in data base and correspondent user data file.

Description

The method of a kind of data collocation system and realization data configuration

Technical field

The present invention relates to a kind of data collocation system and collocation method, relate in particular to and a kind ofly need not to revise code and can realize system and method that the arbitrary data storehouse is configured.

Background technology

Emulation tool is the same testing tool that operational trials is provided for IN service, in emulation tool, not only to simulate single SSP (Service Switching Point Service Switching Point) main frame, also to simulate the networking situation of real network, therefore to simulate multiple main frame on the cover emulation tool, also will simulate the data configuration of multiple main frame simultaneously.

The data file that the database data of SSP main frame and actual loaded are used is different, and intermediate demand transforms.The data file that actual loaded is used is simply simple and direct, data need compression as far as possible, and visuality and ease for use in order to improve data, it is clear that data in the database are looked like again as far as possible, must cause data and data of database in the data file to have bigger difference, the past emulation tool expends many manpowers always in order to satisfy these othernesses, revises demonstration and data conversion that code is finished data.

Summary of the invention

Purpose of the present invention just provides a kind of data collocation system and collocation method, under the situation of not revising code, data are separated from code logic, only depended on data configuration to finish the demonstration of data from the database to the interface, the conversion from the database to the data file.For realizing the invention provides following technical scheme:

The invention provides a kind of data collocation system, comprise, database and data conversion portion;

Database is used to preserve the solid data of different editions;

Data conversion portion, the solid data and data-switching between user's configuration interface and the explicit user configuration interface that are used for the database different editions, set up the mutual read-write conversion of database data and user's configuration interface, and be used for the solid data of each different editions of fulfillment database and the conversion between the corresponding subscriber data file.

The solid data of described different editions is the solid data of Service Switching Point.

Said system also comprises the subscriber data file storage unit, storage is by the subscriber data file of data conversion portion conversion, this user data is the solid data with each Service Switching Point of Service Switching Point host data form preservation, is to be used for providing loaded data to Service Switching Point.

Described data conversion portion comprises database description DBS module, database conversion DBC module and data base administration DBM module, wherein,

The DBS module is used for the conversion between each Service Switching Point solid data of fulfillment database and the user's configuration interface usefulness data;

The DBC module is used for the conversion between each Service Switching Point solid data of fulfillment database and the subscriber data file;

The DBM module is used for described DBS module and DBC module are managed.

Described DBS module comprises,

The DBS file of storage has write down the corresponding relation between each Service Switching Point solid data of database and the user's configuration interface display message, and has described the display properties of each database table on the interface;

The DBS resolution unit is used to resolve the DBS file, and provides the DBS that calls for the data presentation converting unit to resolve interface, is used for the conversion between each Service Switching Point solid data of fulfillment database and the user's configuration interface data;

The data presentation converting unit, can call DBS and resolve interface, will be by the data in database access interface sense data storehouse, conversion generates the information that shows for user's configuration interface, and the data that data presentation and dispensing unit are sent, conversion generates database data;

Data presentation and dispensing unit call the transfer function in the data presentation converting unit, the conversion between fulfillment database data and the user's configuration interface data.

Described DBC module comprises,

The DBC file of storage, the corresponding relation between the solid data of each Service Switching Point of database of record and the described Service Switching Point host data form;

The DBC resolution unit is resolved the DBC file, generates the table information chained list dynamic structure corresponding with the main frame form, this structure correspondence the data layout of entity main frame; Be used for changing between database data and each SSP/MSC entity main frame formatted data, and provide the DBC that calls for the data file generation unit to resolve interface;

The data file generation unit is used to call the data access interface of database data accessing operation unit, reading of data from database, and according to data of database, call DBC and resolve interface, generate entity main frame formatted data file according to analysis result;

Database data accessing operation unit, the data that are used to visit the sense data storehouse provide the interface of unified SQLServer database access, and this part externally provides the data access interface for other cell call.

Result after described DBC resolution unit will be resolved is persisted in the permanent media.

Described DBM module comprises,

The DBM file is used for the one or more of all Service Switching Points of descriptive system support and tables of data that host entity version, version number, the DBS filename of software, category of language, entity version are comprised and interface display packet mode;

The DBM module provides calling interface, can obtain corresponding DBC, DBS filename according to version number, thereby realizes the correct conversion and the realization of different editions solid data.

The present invention also provides a kind of method that realizes the database with at least two different editions solid datas is carried out data configuration, and this method is as follows:

1) utilizes the solid data of each different editions of DBS file logging database and the corresponding relation between user's configuration interface display message;

2) provide DBS to resolve interface, this parsing interface is used for the solid data of each different editions of fulfillment database and the conversion between user's configuration interface data;

3) provide the data presentation converting unit, this data presentation converting unit can be called DBS and resolve interface, generates the information that shows for user's configuration interface, and the data that data presentation and dispensing unit are sent, and conversion generates database data;

4) provide data presentation and dispensing unit, this data presentation and dispensing unit can call the data presentation converting unit, the conversion between fulfillment database data and the user's configuration interface data.

Described DBS file is described conversion by key word grammer fulfillment database to the demonstration at data configuration interface.

Realize the demonstration of data by following steps:

1) when the user opened a UserData table on software interface, data presentation and dispensing unit called the transfer function in the data presentation converting unit according to the operation information that interface control passes over;

2) the data presentation converting unit is at first opened UserData table in the database, obtains the Field Count of table; Call the analytical function of DBS resolution unit then;

3) the DBS resolution unit is obtained the sort field and the ordering attribute of table according to the ORDERBY key word of DBS file, obtains the edit properties of table according to the TABLEATTRIBUTE key word; And obtain display properties and other field attribute from the DBS file;

4) the data presentation converting unit judges whether to exist the field of display properties requirement demonstration, if exist, data presentation and dispensing unit also insert gauge outfit according to the judged result operation interface control establishment of returning and be listed as; Have automatic index field row if the data presentation converting unit is judged, then data presentation and dispensing unit insert the gauge outfit of creating automatic index column according to the judged result operation interface control that returns;

5) data presentation converting unit UserData table from database reads table record one by one, and by the definition of DBS resolution unit according to the DBS file, by data presentation and dispensing unit operation interface control display line and field row is set.

Realize the editor of data by following steps:

1) when the user edited a UserData table on software interface, data presentation and dispensing unit were revised message according to the field that interface control passes over, and call the transfer function of data presentation converting unit;

2) the data presentation converting unit is called the interface of DBS resolution unit, according to the descriptor of UserData table in the DBS file, the demonstration regular data of initial table editing dialog frame control;

3) the DBS resolution unit is obtained the basic default data of UserData literary name section from database, comprises field name, field type, field value etc.;

4) the data presentation converting unit is that index is converted into corresponding interface display value with the field value that database reads in from character string with table, field;

5) data presentation and dispensing unit copy the basic default data of the field obtained and suggestion content to field and show control; Field show control can finish field demonstration;

6) user is when intact data of user's configuration interface editor and preservation submission, and data presentation and dispensing unit convert the data of interface display/input control input the Database field form to by the data presentation converting unit and are saved in the database.

Realize the interpolation of data by following steps:

1) as user when UserData table adds data on software interface, data presentation and dispensing unit are revised message according to the field that interface control passes over, and call the transfer function of data presentation converting unit;

2) the data presentation converting unit is called the descriptor that the DBS resolution unit is obtained the table of UserData in the DBS file, according to the demonstration regular data of the descriptor initial table editing dialog frame of this UserData table;

3) the data presentation converting unit is called the basic default data that DBS resolution unit UserData table from the DBS file obtains field, comprises field name, field type, field value etc.; The master data of the field that data presentation and dispensing unit will obtain from the DBS file and suggestion content (as the ToolTip suggestion content) copy is to field demonstration/input control;

4) user is when user's configuration interface has added data and preserved submission, and data presentation becomes the Database field form to be saved in the database with the data-switching that dispensing unit is imported interface display/input control.

Technical scheme of the present invention goes for any needs and carries out data compression, data conversion and data configuration, and the changeable again data support system of data, is a kind of effective ways with data and logical separation.Technical scheme of the present invention also has following advantage: the simplification of data configuration, realize the data configuration to the several data entity on same interface; The friendly of data configuration realizes the several data configuration mode, as edit box, drop-down option, digital scope etc., provides visual and understandable configuration item for drop-down option, and providing option as user type is " domestic consumer ", " intelligent subscriber " etc.; The simple and direct property that data are preserved shows friendly config option on the interface, but only preserves corresponding numeral in database, and for example option " domestic consumer " corresponding " UserType " field in database is the data of a byte, and respective value is 0; The accuracy of data-switching for each emulation SSP/MSC assembly, can be carried out data-switching exactly according to the data in the database, obtains meeting the data file of emulation SSP/MSC operation needs; The realization Data Dynamic loads, and in emulation SSP/MSC operational process, changes as data, can allow the data of interface modification come into force immediately by database update, data-switching.

By below in conjunction with the accompanying drawing description of the preferred embodiment of the present invention, other characteristics of the present invention, purpose and effect will become clear more and easy to understand.

Description of drawings

Preferred implementation of the present invention is described below with reference to the accompanying drawings, wherein:

Fig. 1 is the structural drawing of data collocation system among the present invention;

Fig. 2 is the fundamental diagram of DBS module among the present invention;

Fig. 3 is the fundamental diagram of DBC module among the present invention;

Fig. 4 is DB physical arrangement figure among the present invention;

Fig. 5 resolves and DB generating principle figure for DBC among the present invention;

Fig. 6 is DBC initialization flow process among the present invention;

Fig. 7 is for reading table descriptor processing procedure among the present invention;

Fig. 8 reads the field information processing procedure among the present invention;

Fig. 9 is for being mounted with the tree type figure of corresponding table name among the present invention;

In all above-mentioned accompanying drawings, identical label represents to have identical, similar or corresponding feature or function.

Embodiment

The present invention is described further below in conjunction with accompanying drawing.

As shown in Figure 1, data collocation system is made up of following components:

(1) SQL specification data storehouse such as SQL Server: be used to preserve each SSP/MSC solid data; Use SQL specification data storehouses such as stablizing SQL Server, safety, data type is flexible, is easy to set up the association between the various tables of data, and can provide powerful, is easy to the query function that expands and revise.

(2) data conversion portion: comprise DBM module, DBS (DATABASESCRIPT) module and DBC module; Wherein, the DBS module is by the conversion between DBS configuration file realization SQL Server database each SSP/MSC (mobile switching centre) solid data and the user's configuration interface; The DBC module is by the conversion between DBC configuration file realization SQL Server each SSP/MSC solid data of database and the subscriber data file storage unit.The DBM module is used to realize the management to the DBS module and the DBC module of different editions entity.

(3) user configuration module: interface control is provided, comprise and show control, input control and demonstration/input control, can the explicit user configuration interface, be used to show the user's configuration interface data that obtain through behind each SSP/MSC solid data of conversion, and output user configuration interface data are to described data conversion portion; Various controls in the user configuration module all have application as showing control, input control and demonstration/input control in existing most softwares, as medium, in practical operation, can directly use the various controls that Microsoft provides in WINDOWS operating system and word software.

(4) subscriber data file storage unit: preserve each SSP/MSC solid data with the host data form, be used for providing loaded data to the SSP/MSC entity.

The core of system is exactly a data conversion portion, and this part has realized that by DBM, DBS, three configuration files of DBC the different entities version finishes the demonstration of data from database to user's configuration interface, the conversion from the database to the data file.Realized host computer control logic data the separating on code required (be that the host computer control logic is revised and realization by a software subsystem, realize that the required data of host computer control logic are by another software subsystem input, modification, storage and realization) with realization host computer control logic.

Principle of work to each functional module is described in detail below.

At first database of descriptions is introduced the structural principle of DBS module to the demonstration conversion at data configuration interface:

DBS is the abbreviation of DATABASESCRIPT (database description), how the DBS module is used for describing at user interface clear, directly perceived, succinct demonstration and configuration data database data, changes between each SSP/MSC solid data of fulfillment database and the user's configuration interface.

The inner structure of DBS module such as Fig. 2 comprise following ingredient:

The DBS file, the DBS file is an editable text of ASCII, the DBS file logging corresponding relation between each SSP/MSC solid data of database and the user's configuration interface video data, the display properties of each SQL-SERVER table on the interface described; The SSP/MSC solid data of a corresponding version of DBS file;

The DBS resolution unit, be responsible for resolving the DBS file, and providing the DBS that calls for the data presentation converting unit to resolve interface, this parsing interface also can be regarded as analytical function, is used for the mutual conversion between each SSP/MSC solid data of fulfillment database and the user's configuration interface data;

The data presentation converting unit can provide one group of transfer function, and this transfer function can call a series of analytical function; And can be according to the data in database access interface sense data storehouse, can call DBS and resolve interface, generate the information that shows for user's configuration interface, and the data that data presentation and dispensing unit are sent, conversion generates database data; This data presentation converting unit need be called the conversion that a series of analytical functions just can be finished data usually;

Communicating by letter between data presentation and dispensing unit and the user's configuration interface module can be adopted the form of message or directly be called, and this means between two modules are ripe prior aries, no longer describe in detail here.

Introduce DBS file description form below:

The DBS file is described conversion by key word grammer fulfillment database to the demonstration at data configuration interface, is DBS with DATABASESCRIPT key word sign.The demonstration of concrete each table and field is described with following several sections key word guiding and is finished:

(1) TABLE and END TABLE key word guiding description list information

To each table in the storehouse, one group of table information is described: comprise table name, edit properties, sortord, TIPS prompting with key word TABLE and the guiding of END TABLE key word.Form is as follows for example:

Table name in TABLE scp_addr // database

TABLEATTRIBUTE (" SCP Physical Address Description Table ", ENABLED) //SCP physical address Table Properties, describe the table name of interface display, and show whether to show

//ORDERBY (" SCP number ", AUTOIDX) // with which field (field name, sortord) ASCEND/DESCEND/AUTOIDX (AUTOINX represents automatic index, this moment field name be display name) that sorts

The prompting descriptor of TIPS (" SCP physical address description table.Config SCP DPC and GTwhich you want to access. ") // this table

(2) FIELD and END FIELD key word guiding description field attribute

To each field of each table in the storehouse, all use FIELD and END FIELD key word guiding description field attribute.Form is as follows for example:

Field name (PrimaryKey, ForeignKey, Show, Title, Enable, Default, EditType, FieldType, FieldLen, RangeIdx, FieldCtrl, ToolTip)

Wherein each attribute implication and value are respectively:

//PrimaryKey, major key, value is (TRUE/FALSE), is that TRUE represents the associating major key as a plurality of fields

//ForeignKey, external key, value is (related table name), as then not being NULL

Whether //Show shows, value is (TRUE/FALSE)

//Title shows title, character string, (is that FALSE then is NULL as the show attribute)

Whether //Enable can edit, value (TRUE/FALSE) // and can not be FALSE simultaneously with the show field

//Default, default value, character string is not as then being NULL

//EditType, edit mode, value (NONE/TEXT/LIST/BOOL)

//FieldType, field type, value (BIT/DEC/HEX/STRING/BOOL)

//FieldLen, field length, (if DEC/HEX then is a byte number, if BIT then is a figure place, if STRING then is a string length, if BOOL then is fixed as 1)

//RangeIdx, span, (as then being NULL without limits, otherwise being the index-name of a span)

//FieldCtrl, the field control relation (restricted as this field to other fields, then fill in the index-name of field restriction, otherwise be NULL, can be for a plurality of, with | the symbol connection)

//ToolTip, the information content, character string is not as then being NULL

(3) control information of each field described in FIELDCTRL and END FIELDCTRL key word

Describe the control information of each field with FIELDCTRL and END FIELDCTRL key word, comprise: the demonstration of field, with the Numerical Control relation of other fields (realization) without the constraint of field and related

(4) concrete each field span of VALRANGE and END VALRANGE key word control

With VALRANGE and concrete each the field span of END VALRANGE key word control.

The for example demonstration of user data table, explicit user " the phone type " that need check only, " telephone number ", " DN set ", " device number ", fields such as " call source codes ", so only the Show territory of these fields be described as " TRUE " wherein " device number " in the DBS file, be described as " TRUE " by the PrimaryKey territory, show with blue font on the interface.In addition, this is shown except " call source code ", and other fields all are (the disposing in number segment table) that can not revise, so only the Enable territory of this field in the DBS file is described as " TRUE ", all the other all are " FALSE ", both can only check, can not edit.

The configuration of data need realize three kinds of functions usually, that is: video data, editing data and interpolation data, and the process that system carries out when at first describing video data below in conjunction with data presentation converting unit, DBS resolution unit, data presentation and dispensing unit:

It is the process of a keyword analyses, text resolution that DBS resolves actual.This part has encapsulated some parsing interfaces by class, calls for the data presentation converting unit.The data presentation converting unit can be called different interfaces easily, obtains the display message of each table and field, realizes the format of data presentation.

In conjunction with the table of the UserData in the DBS file of a version, the flow process that the DBS module is carried out when video data is described:

3) the DBS resolution unit is obtained the sort field and the ordering attribute of table according to the ORDERBY key word of DBS file, obtains the edit properties of table according to the TABLEATTRIBUTE key word; (referring to front DBS file description form for example) also obtains display properties and other field attribute from the DBS file;

4) the data presentation converting unit judges whether to exist the display properties requirement to show the field of (Show is TRUE), if exist, data presentation and dispensing unit create and insert the gauge outfit row according to the judged result operation interface control that returns; Have automatic index field row if the data presentation converting unit is judged, then data presentation and dispensing unit insert the gauge outfit (generally there is not automatic index field in most tables) of creating automatic index column according to the judged result operation interface control that returns;

5) data presentation converting unit UserData table from database reads table record one by one, and by the definition of DBS resolution unit according to the DBS file, by data presentation and dispensing unit operation interface control display line and field row is set;

For the field that needs to show (the Show field of UserData table is TRUE in the DBS file), according to UserData table index field value in the database, in List View, create earlier and add a display line, show other field value according to UserData in the database then each field value that newly adds line is set one by one.If UserData shows each field value for empty in the database, the Default field initial value according to UserData table in the DBS file is provided with each field value that newly adds line.

In conjunction with the table of the UserData in the DBS file of a version, the flow process that the DBS module is carried out when editing data is described:

5) data presentation and dispensing unit show control with the basic default data and suggestion content (as the ToolTip suggestion content) copy of the field obtained to field; Field show control can finish field demonstration;

6) user is when intact data of user's configuration interface editor and preservation submission, and data presentation and dispensing unit convert the data of interface display/input control input the Database field form to by the data presentation converting unit and are saved in the database;

In conjunction with the table of the UserData in the DBS file of a version, the flow process that the DBS module is carried out when adding data is described:

Described the principle of work of DBS module above, the principle of work of DBC module has been described below.

The principle of work of DBC module is described below

DBC is the abbreviation of DBConvert (database conversion), and the DBC module is used to realize change between each SSP/MSC solid data of SQL Server database and the SSP/MSC host data formatted file.

The DBC module comprises following several sections (referring to Fig. 3):

1) DBC file, the DBC file logging corresponding relation between each SSP/MSC solid data of database and the SSP/MSC host data form;

2) DBC resolution unit, be responsible for resolving the DBC file, generate the table information chained list dynamic structure corresponding with the main frame form, this structure correspondence the data layout of entity main frame, be used for changing between database data and each SSP/MSC entity main frame formatted data, and the parsing interface that calls for the data file generation unit is provided.

3) data file generation unit, be used to call the data access interface of database data accessing operation unit, reading of data from database, and according to data of database, call DBC and resolve interface, generate entity main frame formatted data file according to analysis result, this entity main frame formatted data file can be stored in the subscriber data file storage unit.

4) data in visit sense data storehouse are responsible in database data accessing operation unit.This part is carried out simple package on the ADO interface basis, the interface of unified SQLServer database access is provided, and this part externally provides the data access interface for other cell calls.

Because emulation Monitor part (the interface management part of emulation) itself is OO program, take all factors into consideration, use the ADO interface.And on the ADO basis that Microsoft provides, encapsulated this interface, the ADO interface is under C: Program Files Common Files System ado msado15.dll (in June, 2003 version of WINDOW operating system) catalogue, and this program is provided in the installation kit.

DBC file description form is described below

The DBC file divides two parts: mapping relations part, table and the field information of table name are described part

1) the mapping relations part of table name

This part description be the mapping relations of table name in the table name that defines in the main machine structure and the SQLServer database, by the guiding of [TableMap] key word (RelDescTbl and FieldDescTbl exception).

Be exemplified below and show:

[TableMap]

RelDescTbl＝RelDescTbl

FieldDescTbl＝FieldDescTbl

soft_para_OVSV610R106B09D022＝SOFT_PARAMETER

lang_kind＝DBLANGKindTbl

Number_seg_OVSV610R106B09D022=DBDialNoSegTbl // database table name, main frame table name

When DBC changes, be exactly mapping relations according to table name, find corresponding main frame table name from the database table name.Such as: according to the database table name of number_seg_OVSV610R106B09D022, just can find the corresponding main frame table name DBDialNoSegTbl of getting.

2) table and field information are described part

This part is gauge outfit information description (by [table name] key word guiding), and this part has described the information such as gauge outfit, field name, index, record number of each table.This part is actually table and the field structure of having described main frame, and wherein showing information description is consistent with host machine part.The data generating portion is changed to main machine structure according to this part fulfillment database structure.

Be exemplified below and show:

[table name] // number segment table descriptor

FieldName=DNSetID, minDialNo, maxDialNo, userIndex//table field name

Fieldnum=4 // Field Count

Rid＝20 //rid

TblType=GENERAL_TBL // table type

IndexType=ORDER INDEX // index type

OnlineModAllow=2 // whether allow online modification

indexField＝DNSetID，minDialNo，maxDialNo

MaxTupleNum=16 // maximum number of tuples

ActTupleNum1=0 // actual number of tuples keeps

actTupleNum2＝0

IndexedFieldNum=0 // index word hop count

DefaultTuple=0 // default tuple

LockFlag=NONE LOCK // lock sign

versionNo1＝0

versionNo2＝0

checkSum1＝0

checkSum2＝0

Type＝struct

To each field of each table, all there is one section field information to describe, by [table name. field name] guiding.Correspondence mappings relation between field description information description database and the host field data type.Be exemplified below and show:

[table name. field name]

Type=UC // host field data type

DataType=DB_UNSIGNED_BYTE // host data type

IndexInd=0x0 // ordering priority, 0x0 represent the override ordering

Wildcard=0 // asterisk wildcard

The field type of correspondence in field name, figure place, the database in value=DNSetID|8|0|tinyint // database

The array of array=1 // whether

…

Above-mentioned form just can be finished the conversion between host data type UC and the database field type tinyint, and has indicated that this field is 8bit position (i.e. byte) in database.

Describe according to top DBC to certain version, divide into groups according to the description of Section field on the interface, program is loaded corresponding table name and is shown to tree type figure.As " Section2=SCCP Config Tables; Table Counts2=4 ", represent that promptly second group is shown as SCCP Config Tables, wherein contain the table of " 4 " individual needs configuration, the name of these 4 tables is called " Tables total=... " the 4th to the 7th table name character string in the field.Be shown as following tree type figure, use when editing for the user.

DBC is described below describes principle

The DBC file is in fact at each SSP/MSC solid data of database with shining upon between the SSP/MSC host data form.What in fact describe in the DBC file is the host memory data structure.

The host entity data are divided into three parts in the Memory Mapping File and its of solid data, gauge outfit descriptor, a field descriptor, table data.Wherein preceding two parts are data dictionaries, comprise table relationship description table (No. 0 table) and field domain description list (No. 1 table).

The actual physical structure that main frame DB exists in internal memory for any host data database data, all has two special description list: RelDescTb table relation tables, FieldDescTbl field description table as shown in Figure 4 in the DBC file.RelDescTb table relation table (being exactly the record in " table 1 description " zone in last figure) has been described the format information and the gauge outfit information of all table description records in the table definition district, FieldDescTbl field description table (being exactly the record in " field 1 is described " zone in last figure) has been described format information and gauge outfit information that all field descriptions write down in the Field Definition district.These two tables instruct other concrete main frame tables of back (i.e. table 2 among the figure～N) and the visit of field description and form.The tables of data that other concrete main frame tables are exactly particular user configuration store data (i.e. table 2 among the figure～N), and RelDescTb table relation table, FieldDescTbl field description table are the index of organizing to other tables of data.

The DBC Analytic principle is described below

DBC resolves and DB generating principle such as Fig. 5, under the control of DBM module, the result that the DBC resolution unit reads behind the * .DBC document analysis is an internal memory list structure, this structure constitutes DBC and resolves interface, the result after resolving is added .dat by DBC file prefix name form whole filename it is persisted in the permanent media (disk).Result after only needing when opening engineering later on will resolve from permanent media (disk) is read in internal memory.When needs carried out data-switching, the DBC that utilization obtains above resolved interface, will convert the host data formatted file to by the database datafile that database data accessing operation unit obtains.

* .DBC document analysis is become internal memory chained list tree construction, be for dynamic translation database data faster, because the inquiry velocity of chained list tree wants fast more than text resolution, and persistence is saved in the permanent media (disk), can also reuse analysis result, need not all reanalyse the DBC file at every turn, improve the DBC analyzing efficiency.

DBC initialization process of analysis is described below

When opening an engineering storehouse, the DBC module can be from the DBC file of respective version or * .dat file the reading of data transformation rule, carry out the conversion logic initial work.Its initialization flow process following (with reference to figure 6):

1) reading software config catalogue;

2) preserve the DBC file path;

3) storage SQL table name character string;

4) DBC that at first judges this version persistence whether, promptly whether the * .dat file of the corresponding version of entity exists, if * .dat file does not exist, then enters step 6); If * .dat file exists, open the analysis result * .dat file on the disk;

5) also can obtain file size if correctly open file, then the content with * .dat file is read in the internal memory chained list, and flow process finishes; Otherwise enter step 6);

6) opening the DBC file resolves;

7) analysis result is persisted to disk, promptly generates a * .dat file, be saved in disk;

8) close the DBC file, finish.

DBC table descriptor and field description information analysis flow process are described below

The parsing of DBC is carried out keyword analyses, text resolution according to the description of DBC file in fact exactly, the interface method that above-mentioned main frame form visit is provided and calculates.It is the process of a keyword analyses, text resolution that DBC resolves actual.

Because what the DBC file was mainly described is table information and field information, it in fact mainly is exactly resolution table descriptor and field description information that DBC resolves.

Its table descriptor and field description information analysis flow process are respectively with reference to figure 7 and Fig. 8:

With reference to figure 7, at first describe and read table descriptor processing procedure:

1) judges whether table name is empty; If table name is empty, process ends; If be not empty, enter step 2);

2) the table descriptor that reads in the * .DBC file saves content;

3) judge whether mistake of table descriptor form; If mistake, reporting errors, process ends; If correct, insert in the table descriptor chained list node process ends.

With reference to figure 8, describe below and read the field information processing procedure:

1) judges whether to run through whole field informations in the * .DBC file; If run through whole field informations, process ends; If do not run through whole field informations, judge further whether field name is empty; If field is by name empty, process ends; If field name is not empty, enter step 2);

2) read field information in the * .DBC file;

3) judge whether the field information form is correct; If incorrect, finish; If correct, enter step 4);

4) judge whether the field information form is simple types, if, be read in the leaf node of DBC parsing interface (internal memory chained list tree construction), enter step 7); Otherwise, enter step 5);

5) judge whether the field information form is the Struct type, if, be read in the non-leaf node of DBC parsing interface (internal memory chained list tree construction), enter step 7); Otherwise, enter step 6);

6) judge whether the field information form is the Union type, if, be read in the non-leaf node of DBC parsing interface (internal memory chained list tree construction), enter step 7); Otherwise, must be read in the leaf node of DBC parsing interface (internal memory chained list tree construction) for decomposing field type, enter step 7);

7) insert the field information structure; And return step 1) and continue to read next field information.

DBC resolves the conversion between the bit field in Database field and the main machine structure

Represent owing to have the field of a lot of bit fields in the structure of main frame, such as

_US LI：7；

_US ISUP_Spare：1；

And bit field can not directly be represented in database, and to each bit field field, we use the field of a byte to represent in database.When DBC resolves, can the corresponding field in the database be made up according to bit field situation in the data structure of main frame, again with the pairing data type of host data structure bit field (such as, be exactly above _ US) doubly read and write main frame DB by byte integer.

The DBC module generates the DB data according to the DBC file

The DB file of host access form is followed following flow process: if a Table A is arranged in DB, Table I D is ID_A, and this table has two field a and b, and 1 record is arranged.The flow process of reading this record is:

1) from No. 0 table, obtains the description ReldescTbl[ID_A of Table A according to ID_A], from ReldescTal[ID_A] obtain the following information of this table: this table has two fields, the actual storage address of data of field description fieldescTbl reference position, Table A in No. 1 table;

2) information of character sensing strip a and field b from No. 1 is shown;

3) can draw the length of a record of Table A according to the data type of the number of field and each field, then from the address playback record of Table A;

The data file generation unit must be in strict accordance with this form padding data memory file.The data file generation unit calls the parsing interface of DBC according to database data, obtains corresponding table and field address, field format from the internal memory list structure, writes in the internal memory by the form and the address of resolving appointment, fills and generates the host data record.

1) at first, initialization asterisk wildcard table; Asterisk wildcard is meant the field value that satisfies any querying condition.

2) write the table relation table again; From CDBConvert (the parsing part of DBC module), obtain table and field conversion described chain list index when writing the table relation table;

3) " gauge outfit information description (RelDescTbl) " in the in store DBC file in the chained list.Circulation is filled and is got final product.

4) fill in all literary name sections then.

5) last padding data storehouse content.

The DBM part of management DB C and DBS

DBM is the abbreviation of DBManager (data base administration).

Because the analogue system of Emulnet framework can the multiple different host entity SSP/MSC of combine analog, need be at different host entity, with different DBS, its consummation of DBC file description and data conversion rule.Therefore just need a realization to the DBS of different editions entity, the administrative section of DBC--DBM part.

DBM file description form

The DBM file has two parts content,

1) entity version, the language message of system's support

This part is to describe analogue system to support several SSP (SERVICE SWITCHING POINT Service Switching Point) and SAU entity version, version number, the DBS filename of SoftPhone, category of language, here SAU is a host name, and SoftPhone is a software among the main frame SAU.

[SSP_VERSION] //version of SSP (SERVICE SWITCHING POINT Service Switching Point) entity

VersionCounts＝2

SSPVersion1＝SSPV610R105M8008

SSPVersion2＝OVSV610R106B09D022

[SAU_VERSION] //version of SAU entity

VersionCounts＝1

SAUVersion1＝SAUV200R002.1D431

[SOFT_PHONE] //the demonstration description document of softphone related data

DBSFile＝softPhone.DBS

[Language] // category of language

LanguageCounts＝2

Language1＝Chinese

Language2＝English

2) the concrete descriptor of each entity version

This part is tables of data and interface display packet mode that certain entity version of refinement is comprised, and the description shown in below every kind of entity has is the entity description of SSPV610R105M8008 as version number:

[SSPV610R105M8008]

The DBS filename of DBSFileChn=SSPV610R105M8008.DBS // correspondence

The DBC filename of DBCFile=SSPV610R105M8008.DBC // correspondence

Being presented in the view list window of SectionCounts=9 // all tables divides 9 groups

TableCounts=34 // all show number

Section1=SCP Config Tables //Section field description demonstration grouping: first group

Table_Counts1＝3

Section2＝SCCP?Config?Tables

Table_Counts2＝4

Section3＝Office?Tables

Table_Counts3＝2

Section4＝Trunk?Tables

Table_Counts4＝2

Section5＝MTP?Tables

Table_Counts5＝1

Section6＝User?Info?Tables

Table_Counts6＝1

Section7＝Call?Number?Analysis?Tables

Table_Counts7＝9

Section8＝IN?Service?Tables

Table_Counts8＝4

Section9＝Charge?Tables

Table_Counts9＝8

// all table names

Tables_total＝

scp_cfg，scp_addr，ssp_addr，sccp_ssn，gt_table，newgt_able，sccp_dpc，local_office，number_seg，route_analysis，trunk_group，mtp_dsp，user_data，call_source，callee_Analysis，callee_dn_Special，caller_Analysis，dn_change，national_code，area_code，toll_code，call_forward，in_servicekey，tdp_config，in_conf，1ang_kind，credit_table，free_charge_service，chargeclass_to_rate，holiday_discount，week_discount，normalday_discount，duration_discount，soft_para

The management of DBM realizes

DBM mainly realizes the conversion and the display management of the file of different editions.Management and initialization DBC and DBS.

1) DBM is to the DBC of different editions, the management of DBS description document

DBM provides calling interface, according to version number, can obtain corresponding DBC, DBS description document name, thereby realizes the correct conversion and the demonstration of different editions solid data.

[SSPV610R105M8008]

The DBS filename of DBSFileChn=SSPV610R105M8008.DBS // correspondence

The DBC filename of DBCFile=SSPV610R105M8008.DBC // correspondence

2) management of DBM to showing

According to top description to the SSPV610R105M8008 version, on the interface, to divide into groups according to the description of Section field, program is loaded corresponding table name and is shown to tree type figure.As " Section2=SCCPConfig Tables; Table Counts2=4 ", represent that promptly second group is shown as SCCP Config Tables, wherein contain the table of " 4 " individual needs configuration, the name of these 4 tables is called " Tables total=... " the 4th to the 7th table name character string in the field.Be shown as tree type figure shown in Figure 9, use when editing for the user.

Above-mentioned processing, by all information that chained list is preserved each table of management, comprise the sum of table, packet type number that can editor's table, single table the database table name, show index informations such as table name, Tips.When tree type view is directly visited,,, can obtain the information that all interfaces need according to entity version number by chained list access function interface.

Method of the present invention is not restricted to analogue system, can be applied to any needs and carry out different pieces of information data converted configuration-system.

In the present invention, by in analogue system, increasing format text files such as DBC, DBS, DBM, the arbitrary data database data is realized demonstration and the format of changing, the following beneficial effect that brings:

Effectively and flexibly decompose and isolated storage, demonstration, visit and the use of data, satisfied the different characteristics requirement of data storage, demonstration and use.Can bring into play the efficient of relation data library storage data, the strong constraint function of data, the dirigibility of data association.What association, the data effect between the realization data checked, data are preserved is succinct.For example option " domestic consumer " corresponding " UserType " field in database is the data of a byte, and respective value is 0, has so just saved storage space.The characteristics such as access efficiency, interface, effect, Data Dynamic loading that can keep host memory form DB.Be convenient to follow in the future true main frame upgrading.In emulation SSP/MSC operational process, change as data, can allow the data of interface modification come into force immediately by database update, data-switching.

Demonstration and configuration interface that can reduced data.More directly perceived on same interface, succinct, clear, friendly and realize data configuration to the several data entity, and realize the several data configuration mode, as edit box, drop-down option, digital scope etc.Provide visual and understandable configuration item for drop-down option, providing option as user type is " domestic consumer ", " intelligent subscriber " etc.The unwanted data of user are then shielded.With the relation between the storage of data, demonstration, the visit with format text files such as DBC, DBS, DBM with succinct rule description directly perceived, can be very easily directly revise satisfying the variation demand of data storage, demonstration and visit, and do not need to revise once more code, release process with the text edit tool.

The description thought of format text files such as DBC, DBS, DBM has very big dirigibility and retractility.Can expand the relation between storage, demonstration and the visit of expressing data arbitrarily very easily, realize the relationship description between the storage, demonstration, visit of arbitrary data.

The above only is a preferred implementation of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.

Claims

1. a data collocation system comprises, database and data conversion portion;

Database is used to preserve the solid data of different editions;

Data conversion portion, be used for the solid data of database different editions and the data-switching between user's configuration interface, set up the mutual read-write conversion of database data and user's configuration interface, and be used for the solid data of each different editions of fulfillment database and the conversion between the corresponding subscriber data file.

2. a kind of data collocation system according to claim 1 is characterized in that, the solid data of described different editions is the solid data of Service Switching Point.

3. a kind of data collocation system according to claim 2 is characterized in that, also comprises,

Subscriber data file storage unit, storage are by the subscriber data file of data conversion portion conversion, and this user data is the solid data with each Service Switching Point of Service Switching Point host data form preservation, is to be used for providing loaded data to Service Switching Point.

4. a kind of data collocation system according to claim 3 is characterized in that, described data conversion portion comprises database description DBS module, database conversion DBC module and data base administration DBM module, wherein,

The DBM module is used for described DBS module and DBC module are managed.

5. a kind of data collocation system according to claim 4 is characterized in that, described DBS module comprises,

6. according to claim 4 or 5 described a kind of data collocation systems, it is characterized in that described DBC module comprises,

7. a kind of data collocation system according to claim 6 is characterized in that, the result after described DBC resolution unit will be resolved is persisted in the permanent media.

8. according to claim 4 or 5 described a kind of data collocation systems, it is characterized in that described DBM module comprises,

9. a kind of data collocation system according to claim 6 is characterized in that, described DBM module comprises,

The DBM module provides calling interface, can obtain corresponding DBC, DBS filename according to version number, thereby realizes the correct conversion and the reality of different editions solid data.

10. a realization is carried out the method for data configuration to the database with at least two different editions solid datas, and this method is as follows:

11. realization according to claim 10 is carried out the method for data configuration to the database with at least two different editions solid datas, it is characterized in that the solid data of described different editions is the solid data of Service Switching Point.

12. the method for data configuration is carried out in realization according to claim 11 to the database with at least two different editions solid datas, it is characterized in that described DBS file is described conversion by key word grammer fulfillment database to the demonstration at data configuration interface.

13. the database with at least two different editions solid datas is carried out the method for data configuration according to each described realization in the claim 10 to 12, it is characterized in that, realize the demonstration of data by following steps:

14. the database with at least two different editions solid datas is carried out the method for data configuration according to each described realization in the claim 10 to 12, it is characterized in that, realize the editor of data by following steps:

15. realization according to claim 13 is carried out the method for data configuration to the database with at least two different editions solid datas, it is characterized in that, is realized the editor of data by following steps:

16. the database with at least two different editions solid datas is carried out the method for data configuration according to each described realization in the claim 10 to 12, it is characterized in that, realize the interpolation of data by following steps:

17. realization according to claim 13 is carried out the method for data configuration to the database with at least two different editions solid datas, it is characterized in that, is realized the interpolation of data by following steps:

18. realization according to claim 14 is carried out the method for data configuration to the database with at least two different editions solid datas, it is characterized in that, is realized the interpolation of data by following steps: