CN101094144A - Data collocation method and system of wireless access network - Google Patents
Data collocation method and system of wireless access network Download PDFInfo
- Publication number
- CN101094144A CN101094144A CN 200710119530 CN200710119530A CN101094144A CN 101094144 A CN101094144 A CN 101094144A CN 200710119530 CN200710119530 CN 200710119530 CN 200710119530 A CN200710119530 A CN 200710119530A CN 101094144 A CN101094144 A CN 101094144A
- Authority
- CN
- China
- Prior art keywords
- data
- base station
- configuration
- database
- mapping relations
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The method comprises: the configuration tool configures the base station data; using the mapping relation between the configuration tool model and the base station configuration file model to convert the data in the format of database into the base station configuration file; sending the base station configuration files to said base station.
Description
Technical field
The present invention relates to the data configuration of wireless access network (RAN:Radio Access Network), particularly a kind of data configuration method and system in the WCDMA wireless access network.
Background technology
Fig. 1 is that the system of universal mobile telecommunications system UMTS constitutes schematic diagram.Universal mobile telecommunications system (UMTS:Universal Mobile Telecommunications System) is to adopt the third generation wireless communication system of WCDMA technology, and RAN is the Radio Access Network of UMTS system.The position of RAN in the UMTS system as shown in Figure 1.
As shown in Figure 1, NodeB is the base station of RAN, can be used to finish wireless coverage to subscriber equipment (UE:User Equipment) emitting radio frequency signal and from the user equipment (UE) received RF signal.
Wireless access network RAN data configuration is meant after radio network controller (RNC:Radio NetworkController) and NodeB installation, according to the installation of actual hardware equipment, the planning of network and data preparation and the configuration of carrying out with the actual demands such as negotiation of miscellaneous equipment.After configuration finishes, obtain all kinds of configuration files, comprise RNC initial configuration file (txt form) and NodeB Configuration File (can be extension markup language (XML:Extensible Markup Language) form).
Because will carry out wireless signal covers, NodeB often will be distributed in each corner in city, and for the consideration of equipment cost, NodeB does not often have background data base, its configuration data generally is stored in inside of base station data center with the form of file, and the form of file is generally the XML file format.Configuration tool for current graphic user interface (GUI:Graphicai User Interfaces), the data configuration file of XML form be it with the mutual main interface of NodeB, the importing of NodeB XML formatted file is its most basic function that should provide with deriving.
At present, the XML lasting data is turned to configuration tool its data library format, perhaps the configuration tool database format is converted to NodeB network element XML formatted data, all be the process of numerous and complicated all the time.
In the middle of prior art, adopt the mode of hard coded to shine upon relation between configuration tool database model and the NodeB network element XML Archive sit usually, all logics are realized by writing code by the programmer.But adopt the shortcoming of said method to be:
The cost height: NodeB network element family release is more, for example, if a version with BTS3812E and two site types of DBS3800, configuration tool in the past realizes that the code of this part function has surpassed more than the 40K, and when increasing new site type and edition upgrading, all can increase code to a great extent, development and maintenance cost is very high;
Do not have versatility: between a plurality of versions of a plurality of series of NodeB network element, it is less to share code, and versatility is not strong.
Summary of the invention
The embodiment of the invention provides a kind of data configuration method and system of wireless access network.By the embodiment of the invention, make that data configuration becomes convenient, efficient, realization is simple and cost is low.
The embodiment of the invention provides a kind of data configuration method of wireless access network, comprises step:
Configuration tool is configured base station data;
Utilize the mapping relations between configuration tool database model and the base station configuration file model, the data of database format of configuration are converted to the base station configuration file;
This base station configuration file is sent to described base station.
The embodiment of the invention also provides a kind of data collocation system, comprising:
The base station comprises first memory cell at least, is used for the storage configuration file;
Configuration tool, at least comprise the data configuration unit and second converting unit, wherein, described data configuration unit is used for base station data is configured, described second converting unit is used to utilize the mapping relations table between configuration tool database model and the base station configuration file model, and the data of database format of configuration are converted to the base station configuration file; And this base station configuration file is sent to described base station;
The terminal of operation configuration tool is connected with described base station, comprises second memory cell at least, is used for the base station data after the storage configuration; Store described mapping relations table;
Described base station also is used to receive the configuration file that described configuration tool transmits, and is stored to described first memory cell.
The beneficial effect of the embodiment of the invention is, by the mapping relations of configuration, makes that data configuration becomes convenient, efficient, realization is simple and cost is low; Make the conversion between the XML formatted data of configuration tool database format data and base station network element become convenient, efficient; Greatly reduce the size of code that program realizes; Exploitation composition and maintenance cost that XML and database in the RAN configuration tool carry out exchanges data have been reduced.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, does not constitute limitation of the invention.In the accompanying drawings:
Fig. 1 is the formation schematic diagram of universal mobile telecommunications system;
Fig. 2 is that the data collocation system of the embodiment of the invention one constitutes schematic diagram;
Fig. 3 is for being converted to RAN configuration tool database data the flow chart of base station XML formatted data;
Fig. 4 is for being converted to RAN configuration tool database data the flow chart of base station XML formatted data;
Fig. 5 is for being converted to base station XML formatted data the flow chart of RAN configuration tool database data;
Fig. 6 is for being converted to base station XML formatted data the flow chart of RAN configuration tool database data;
Fig. 7 is the data configuration method flow chart of the embodiment of the invention two;
Fig. 8 is a data collocation method flow chart of the embodiment of the invention three;
Fig. 9 is another data configuration method flow chart of the embodiment of the invention three.
Embodiment
For the purpose, technical scheme and the advantage that make the embodiment of the invention is clearer,, the embodiment of the invention is described in further detail below in conjunction with embodiment and accompanying drawing.At this, illustrative examples of the present invention and explanation thereof are used to explain the present invention, but not as a limitation of the invention.
The embodiment of the invention provides a kind of data configuration method and system thereof of wireless access network.Below in conjunction with accompanying drawing the embodiment of the invention is elaborated.
Embodiment one
The embodiment of the invention provides a kind of data collocation system, and 2 pairs of embodiment of the invention are elaborated with reference to the accompanying drawings.
Fig. 2 constitutes schematic diagram for embodiment of the invention data collocation system.As shown in Figure 2, this data collocation system comprises at least: base station 201, comprise the first memory cell 201a at least, and be used for the storage configuration file; Configuration tool 202, at least comprise the data configuration unit and second converting unit, wherein, the data configuration unit is used for base station data is configured, second converting unit is used to utilize the mapping relations table between configuration tool database model and the base station configuration file model, and the base station data of database format of configuration is converted to the base station configuration file; And this base station configuration file is sent to described base station 201; The terminal 202 of operation configuration tool is connected with base station 201, comprises the second memory cell 202b at least, is used for the base station data after the storage configuration; Store the mapping relations table; Base station 201 also is used to receive the configuration file that configuration tool transmits, and is stored to the first memory cell 201a.
By the foregoing description, by mapping relations or mapped file make conversion between the XML formatted data of configuration tool database format data and base station network element become convenient, efficient, realize simple and cost low; Make data configuration simple, convenient, efficient; Greatly reduce the size of code that program realizes; Exploitation composition and maintenance cost that XML and database in the RAN configuration tool carry out exchanges data have been reduced.
In the present embodiment, the form of the configuration file that the base station is stored is generally the XML form.
In the present embodiment,, at first set up the mapping relations between configuration tool database model and the base station configuration file model reading before the base station configuration file carries out data configuration.
In the present embodiment, configuration tool can be adopted the RAN configuration tool, the database model of this RAN configuration tool inside is set up according to the configuration service logic of reality, comprise the relation between some configuration object entities and each configuration object, these database models may there are differences with the model of base station (NodeB) XML formatted data file, but the both is based on the service logic of network element and realizes, so difference is not too large.Putting before this,, setting up the mapping relations between RAN configuration tool database model and XML data file model promptly according to the consistency on this service logic.
In the present embodiment, mapping relations mainly comprise the mapping relations of mapping relations, literary name section and the leaf node of database table and XML node, wherein, a configuration object that stores in each XML node respective base station internal storage, each leaf node is to a configuration parameter that should configuration object.
The mapping relations of above-mentioned database table and XML node are used at synchronization, and the literary name section belongs to than database table and other mapping relations of the littler level of XML node with the mapping relations of leaf node.For example, only know the mapping relations of database table (Table1) with XML node (Node1), the field (Field1) of database table (Table1) just can work with the mapping relations of the leaf node (LeafNode1) of XML node (Node1).
Wherein, the mapping relations of database table and XML node can be to shine upon one by one, also can be the relations of many-one or one-to-many.The data of each XML leaf node have just had direct correlation with a field of certain table in the database like this.Below for example mapping one by one, many-one and one-to-many mapping relations are described respectively.
Table 1 is a database table.Shown in the database table of table 1, the interfield of the same database table of leaf node (Employee_PersonTable) of " Person " node is set up the relation of mapping one by one in the XML format configuration file.
Table 1
<employee>
<Person>
＜personname〉Rose＜/personname〉＜!-be mapped to the name field of database table Employee_PersonTable--
＜age〉25＜/age〉＜!-be mapped to the age field of database table Employee_PersonTable--
＜accountNum〉100＜/accountNum〉＜!--be mapped to the accountNum field of database table Employee_PersonTable
-->
＜indication〉Male＜/indication〉＜!-be mapped to the indication field of database table Employee_PersonTable
-->
</Person>
<Dept>Marketing</name>
<Telephone>82956888</Telephone>
</employee>
Except that above-mentioned mapping relations one by one, because the data model of RAN configuration tool can not be in full accord with base station XML format configuration file data model, the situation that might have the corresponding XML node of a plurality of database tables, at this time just need set up the mapping relations of the corresponding XML node of a plurality of database tables, for example:
RAN configuration tool model:
CREATE TABLE [dbo].[Table1](
[Field_A] [int] NOT NULL，
[Field_B] [int] NOT NULL，
[Field_C] [int] NOT NULL，
)
CREATE TABLE [dbo].[Table2](
[Field_D] [int] NOT NULL，
[Field_E] [int] NOT NULL，
[Field_F] [int] NOT NULL，
)
Base station XML nodal analysis method:
<Node1>
＜Field_A〉1＜/Field_A〉--the Field_A of corresponding Table1
＜Field_B〉1＜/Field_B〉--the Field_B of corresponding Table1
＜Field_C〉1＜/Field_C〉--the Field_C of corresponding Table1
＜Field_D〉1＜/Field_D〉--the Field_D of corresponding Table2
＜Field_E〉1＜/Field_E〉--the Field_E of corresponding Table2
＜Field_F〉1＜/Field_F〉--the Field_F of corresponding Table2
</Node1>
From the above, in the RAN configuration tool two of database table Table1 and database table Table2 table corresponding a node Node1 in the XML node, when at this moment carrying out data transaction, just need set up in the RAN configuration tool mapping relations of a node among a plurality of table respective base station XML.Conversely, when the corresponding a plurality of XML node of database table, will set up the mapping relations of one-to-many.
In the present embodiment, the mapping relations between RAN configuration tool database model and the base station XML format configuration file model are to realize by aid Microsoft Excel, are not limited to this kind situation, also can adopt other aid.
Below to use Microsoft Excel to carry out the configuration mode that example is described the mapping relations of the embodiment of the invention in detail that is configured to of mapping relations.
In the present embodiment, need the mapping relations of an XML leaf node, therefore need utilize outside aid to dispose such mapping relations table to the database table interfield because the data of database format and XML form are changed mutually, as shown in table 2.
As shown in table 2, the Excel worksheet is divided into XML and two zones of database (DB).
Table 2
| XML | DB | |||||||
| ObjName | TagName | Layer | ViewName | FieldName | FieldHandler | DefaultValue | TableName | TableHandler |
| employee | employee | 0 | employee_View | |||||
| Person | 1 | |||||||
| personname | 2 | Name | TransHandler | employee_Tb11 | ||||
| age | 2 | Agc | employee_Tb11 | |||||
| accountNum | 2 | AccountNum | employee_Tb11 | |||||
| indication | 2 | Indication | employee_Tb11 | TableEnd | ||||
| Dept | 1 | 0 | ||||||
| Telephone | 1 | Telephone | employee_Tb12 | PersonHandler | ||||
In Excel table 2, XML partly inserts the complete or collected works of XML node, it is the XML node of all kinds, wherein, in object oriented (ObjName) row, fill in the title that certain has the complete meaning node, wherein have the complete meaning node and be meant that a plurality of leaf nodes are organized in together, can characterize an entire arrangement object, as the configuration object " employee " in the table; In sign XML, fill in the title of all child nodes in this node in title (TagName) row of node, comprise leaf node and non-leaf node; As " employee, Person " in the table 2 etc.; In level (Layer) row, fill in child node set membership in the XML file, wherein, in the present embodiment, regard the tree of XML node as planar structure, with the hierarchical relationship between level (Layer) identification nodes, for example, this hierarchical relationship is represented with set membership, in the present embodiment, " 0 " in the table 2 is an outermost layer, " 0 " layer is the father of " 1 " layer, and " 1 " layer is again the father of " 2 " layer, and the like.
In Excel table 2, in field name (FieldName) row of DB partial data storehouse view name (ViewName) row, View, fill in View title, the field name of certain node of XML correspondence in database, point out the title of this node corresponding data table simultaneously in two parts in the back of DB; Field level special processing (FieldHandler), database table level special processing (TableHandler) are listed as a handle in each corresponding computer program code, certain special circumstances of field level when FieldHandler handles by database to the XML format conversion, the TableHandler processing is by the special circumstances of XML data-base recording level when database is changed.
Because the core of base station 201 operate as normal is exactly the data in the configuration file, the newly-built and professional regular maintenance of base station 201 all will realize by the data in the new configuration file more.Configuration tool is the graphical tools of base station maintenance, but the model of configuration tool is not quite similar with the model of base station configuration file, therefore needs to realize data transaction described herein.
For example, under the situation of newly-built base station, configuring base station data in the data configuration unit in configuration tool 202a at first, and the base station data that will dispose is stored among the second memory cell 202b of this configuration tool place terminal, then, second converting unit of configuration tool 202a is converted to the base station configuration file according to above-mentioned mapping relations with this base station data, i.e. the XML file, and this configuration file is issued to base station 201, make base station 201 operate as normal.
In the present embodiment, second converting unit of configuration tool 202a is converted to the base station configuration file according to above-mentioned mapping relations with this base station data, i.e. XML file can adopt the mode shown in Fig. 3 or 4:
As shown in Figure 3, when utilizing mapping relations to carry out data transaction, in the following way,
Step 301 reads the data item in the mapping relations table in order; Wherein, data item refers to the mapping relations of each database table field with the XML leaf node;
Step 303,304 judges successively whether described FieldHandler, DefaultValue, FieldName are empty;
If judged result is FieldHandler is not empty, then carry out corresponding special processing, promptly call the special processing of this handle correspondence; If DefaultValue is not empty, then give this node default value DefaultValue among the XML; If field name FieldName is not empty, then from View, reads the database value of described field name FieldName field correspondence, and this database value is composed the node to XML.
In step 303, if judged result is that described FieldHandler, DefaultValue, field name FieldName are sky, then continue step 301, read next data item, then this data item is handled.
Step 305 has judged whether to travel through all data item in the corresponding relation, if the result who judges then finishes transfer process for being, if judged result then carry out step 301 for not.
Another kind of situation, above-mentioned mapping relations can be mapped file, can utilize this mapped file to carry out data transaction like this.When utilizing mapped file to carry out data transaction, at first the mapping relations in the above-mentioned Excel table are carried out grand processing, export as a mapped file, this mapped file is the file CfgFile of XML form in the present embodiment; Mapped file CfgFile is read in the internal storage 202b of this configuration tool place terminal, in the present embodiment, be instantiated as the data structure XMLMap of tabular form.Can be in the following way when like this, carrying out data transaction:
As shown in Figure 4, step 401, order reads each data item among the XMLMap; Wherein, data item refers to the mapping relations of each database table field with the XML leaf node; Step 402 reads corresponding wide area information server view name (ViewName), field level special processing (FieldHandler), field default value (DefaultValue), the field name (FieldName) of TagName (being the title of NodeB XML back end) in the XMLMap data item; Other step and Fig. 3 are similar, repeat no more herein.
By above-mentioned dual mode, when data configuration is carried out in newly-built base station, the data of RAN configuration tool database format can be converted to NobeB XML form, but above-mentioned dual mode is embodiments of the invention only, is not limited to this dual mode.
In addition, in this enforcement, above-mentioned data configuration instrument also comprises first converting unit, is used to read the configuration file that base station 201 stores, and utilizes described mapping relations table or mapped file base station configuration file format data to be converted to the base station data of database format; The second memory cell 202b also is used for storage and is converted to the database format base station data.
Like this, at the configuration file with certain base station is under template establishment another one base station data, the situations such as modification base station data, base station configuration parameter adjustment and upgrading service, 201 the first memory cell 201a reads configuration file to first converting unit that also needs configuration tool from the base station, carry out depositing among the second memory cell 202b after the data transaction, utilize the data configuration unit that base station data is configured then, promptly make amendment, adjust configuration parameter or business datum.
In the present embodiment, the base station data that base station configuration file format data is converted to database format also can adopt dual mode to carry out, and as shown in Figure 5, utilizes mapping relations conversion.As shown in Figure 6, utilize mapped file conversion.
As shown in Figure 5, when utilizing mapping relations to carry out data transaction when base station (NobeB) XML formatted data is converted to RAN configuration tool database data, can be in the following way:
Step 501 reads the value FieldVal of each leaf node in the XML format configuration file of base station, is the value FieldVal that reads each leaf node in order in the present embodiment;
In the present embodiment, in step 503,, then continue from the base station configuration file, to read next leaf node, thereby carry out the processing of next leaf node if judged result is last field of correspondence table in the non-correspondence database of leaf node.
In addition, in some cases, the needs that above-mentioned mapping relations can not satisfy data transaction fully may occur, therefore may need the data of reading in are carried out special processing.At this moment, can at certain database table before importing database, increase a Handler function that carries out special processing, data are carried out special processing.
As shown in Figure 6, when utilizing mapped file that base station (NobeB) XML formatted data is converted to RAN configuration tool database data, can adopt following steps:
Step 601 reads the value FieldVal of the leaf node in the XML formatted data file of base station in order;
In the present embodiment, in step 603,, then continue from the base station configuration file, to read next leaf node, thereby carry out the processing of next leaf node if judged result is last field of correspondence table in the non-correspondence database of leaf node.
By above-mentioned dual mode, when base station XML formatted data is converted to the data of RAN configuration tool database format, can easily the XML formatted data be inserted in the database table by the mapping relations of above-mentioned configuration.
Embodiment two
The embodiment of the invention provides a kind of data configuration method of wireless access network, is elaborated below in conjunction with 2,7 pairs of present embodiments of accompanying drawing.
As shown in Figure 7, the method comprising the steps of: the data configuration unit of configuration tool 202a is configured base station data, and the base station data after will disposing is stored among the second memory cell 202b (seeing step 701); Second converting unit is utilized the mapping relations between configuration tool database model and the base station configuration file model, and the data of database format of configuration are converted to base station configuration file (seeing step 702); This base station configuration file is sent to described base station 201, and the base station is stored in this configuration file among the first memory cell 201a (seeing step 703).
For example, under the situation of newly-built base station, configuration tool configures base station data, and is converted into base station configuration file data form, is handed down to base station 201, makes the base station operate as normal.
In Fig. 7, in step 702, can directly utilize above-mentioned mapping relations to carry out mutual conversion between database format data and the base station XML formatted data.The step of this data transaction comprises as shown in Figure 3:
Step 301 reads the data item in the mapping relations table in order; Wherein, data item refers to the mapping relations of each database table field with the XML leaf node;
Step 303,304 judges successively whether described FieldHandler, DefaultValue, FieldName are empty;
If judged result is FieldHandler is not empty, then carry out corresponding special processing, promptly call the special processing of this handle correspondence; In the present embodiment, the field level special processing can be handled following situation: the value of a certain leaf node is " 1 " in the XML file of base station, and this value is shown as " ENABLE " to the user in the corresponding RAN configuration tool, and can define a field level special processing this moment, and this field is carried out special processing.Again for example: be logical slot number for the veneer groove of base station in the XML file of base station, it is not the physical slot item, logical slot number " 0 " corresponding physics slot number " 10 ", only write down the physical slot item in the RAN configuration tool database, therefore when with base station XML data conversion being the data of RAN configuration tool, must increase a field level special processing, change this field of slot number.
If DefaultValue is not empty, then give this node default value DefaultValue among the XML; If field name FieldName is not empty, then from View, reads the database value of described field name FieldName field correspondence, and this database value is composed the node to XML.
In step 303, if judged result is that described FieldHandler, DefaultValue, field name FieldName are sky, then continue step 301, read next data item, then this data item is handled.Promptly, when the XML file is derived in configuration tool (database model is to the conversion of XML model), for reading of mapping relations is the data item that reads in order in the mapping relations table, if FieldHandler, DefaultValue, field name FieldName are sky, show that this Database field of configuration tool does not have corresponding relation with the leaf node in the XML file, promptly this Database field need not be derived.So, continue to read next the bar mapping relations in the mapping relations table, database value in next bar mapping relations is composed the node to XM1.
Wherein, in transfer process, for reading of mapping relations is the data item that reads in order in the mapping relations table, in step 303, if FieldHandler, DefaultValue, field name FieldName are sky, show that this Database field of configuration tool does not have corresponding relation with the leaf node in the XML file, promptly this Database field need not be derived.So, continue to read next each data item in the mapping relations table, wherein database value is composed the node to XMl.
Step 305 has judged whether to travel through all data item in the corresponding relation, if the result who judges then finishes transfer process for being, if judged result then carry out step 301 for not.
In addition, in Fig. 7, in step 702, also can directly utilize above-mentioned mapped file to carry out mutual conversion between database format data and the base station XML formatted data.The step of this data transaction comprises as shown in Figure 4:
By above-mentioned dual mode, when data configuration is carried out in newly-built base station, the data of RAN configuration tool database format can be converted to NobeB XML form, but above-mentioned dual mode is embodiments of the invention only, is not limited to this dual mode.
By the foregoing description, by mapping relations or mapped file make conversion between the XML formatted data of configuration tool database format data and base station network element become convenient, efficient, realize simple and cost low; Make data configuration simple, convenient, efficient; Greatly reduce the size of code that program realizes; Exploitation composition and maintenance cost that XML and database in the RAN configuration tool carry out exchanges data have been reduced.
Embodiment three
The embodiment of the invention also provides a kind of data configuration method of wireless access network, and the method comprising the steps of: the configuration file that stores in the base station is read in configuration tool; Utilize the mapping relations between configuration tool database model and the base station configuration file model, base station configuration file format data are converted to the database format data; Base station data is carried out data configuration; Utilize the mapping relations between configuration tool database model and the base station configuration file model, the configuration file of database format is converted to the configuration file of base station configuration file format; This base station configuration file is sent to the base station.For example, at the configuration file with certain base station is under template establishment another one base station data, the situations such as modification base station data, base station configuration parameter adjustment and upgrading service, 201 the first memory cell 201a reads configuration file to first converting unit that at first needs configuration tool from the base station, carry out depositing among the second memory cell 202b after the data transaction, utilize the data configuration unit that base station data is configured then, promptly make amendment, adjust configuration parameter or business datum; At last, the data with database format in second converting unit are converted to configuration file, are issued to the base station.
Below, with reference to accompanying drawing 8, Fig. 9 the data configuration method of the embodiment of the invention is elaborated.
Fig. 8 is for directly to utilize mapping relations to carry out the data configuration method flow chart of data transaction.As shown in Figure 8, the method comprising the steps of:
Step 803 is utilized the configuration tool database model of foundation in advance and the mapping relations between the base station configuration file model, and base station configuration file format data are converted to the database format data;
Step 804 is carried out data configuration to base station data, and the data after will disposing deposit among the memory cell 202b;
Step 805 is utilized the mapping relations between configuration tool database model and the base station configuration file model, and the configuration file of database format is converted to the base station configuration file;
Step 806 is issued to the base station with this base station configuration file.
In the foregoing description, in step 803, utilize mapping relations that base station XML formatted data is converted to the database format data and can adopt as shown in Figure 5 mode, comprise the steps:
Step 501 reads the value FieldVal of each leaf node in the XML format configuration file of base station, is the value FieldVal that reads each leaf node in order in the present embodiment;
In the present embodiment,, then continue from the base station configuration file, to read next leaf node, thereby carry out the processing of next leaf node if judged result is last field of correspondence table in the non-correspondence database of leaf node.
By said method, when base station XML formatted data is converted to the data of RAN configuration tool database format, can easily the XML formatted data be inserted in the database table by the mapping relations of above-mentioned configuration.
In addition, in some cases, the needs that above-mentioned mapping relations can not satisfy data transaction fully may occur, therefore may need the data of reading in are carried out special processing.At this moment, can at certain database table before importing database, increase a Handler function that carries out special processing, data are carried out special processing.
In the present embodiment, with numerical value to (FieldName, FieldVal) insert before the database, also can comprise step: judge whether to carry out special processing, whether " the database table level special processing (TableHandler) " of promptly judging the correspondence of leaf node described in the mapped file is empty, if judged result is not empty, certain configuration object of expression base station need carry out special processing when importing the RAN configuration tool, then carries out corresponding special processing this moment.For example, when the tables of two the corresponding RAN configuration tool of different node databases in the XML formatted data file of base station, need special processing that the value of two nodes is merged to one and be inserted in the database.
Utilize mapping relations that the database format data are converted to base station XML formatted data in step 805 and can adopt mode shown in 3, its idiographic flow repeats no more as described in embodiment one and two herein.
The mapped file that Fig. 9 is derived by mapping relations for embodiment of the invention utilization carries out the data configuration method flow chart of data transaction.In this case, at first need mapping relations are handled, derive mapped file.When carrying out data configuration then, can utilize the mapped file of derivation to carry out mutual conversion between database format data and the base station XML formatted data.
If when adopting aid Microsoft Excel, mapping relations in the above-mentioned Excel table are carried out grand processing, export as a mapped file, this mapped file is the file CfgFile of XML form in the present embodiment, when concrete data transaction, can easily this mapped file be read in the internal storage of RAN configuration tool place terminal, be instantiated as computer program and realize the convenient data structure of using.But the form of above-mentioned mapped file is not limited to the XML form, also can be the file format that other high level language conveniently reads and operates, in order to the auxiliary conversion of carrying out between XML form and the database format data.Like this, can greatly reduce the size of code that program realizes; And when RAN configuration tool database model or the change of XML configuration file node, only need to revise the mapping relations among the Excel, and need not to revise or only revise code on a small scale, thereby reduced the maintenance cost of configuration tool to a great extent.
As shown in Figure 9, this data configuration method comprises step:
Step 902 is carried out grand processing to the mapping relations in the above-mentioned Excel table, exports as a mapped file, and this mapped file is the file CfgFile of XML form in the present embodiment; Mapped file CfgFile is read in the internal storage of this configuration tool place terminal, in the present embodiment, be instantiated as the data structure XMLMap of tabular form;
Step 904 is utilized the data structure XMLMap of mapped file CfgFile instantiation tabular form, and base station configuration file format data are converted to the database format data;
Step 905 is carried out data configuration, and to obtain configuration file, this configuration file is a database format;
Step 906 is utilized the data structure XMLMap of mapped file CfgFile instantiation tabular form, and the configuration file of database format is converted to the base station configuration file;
Step 907 is issued to base station 201 with this base station configuration file.
In step step 904, when utilizing mapped file that base station (NobeB) XML formatted data is converted to RAN configuration tool database data, can adopt mode as shown in Figure 6, comprise step:
Step 601 reads the value FieldVal of each leaf node in the XML formatted data file of base station in order;
In the present embodiment,, then continue from the base station configuration file, to read next leaf node, thereby carry out the processing of next leaf node if judged result is last field of correspondence table in the non-correspondence database of leaf node.
By said method, when NobeB XML formatted data is converted to the data of RAN configuration tool database format, can easily the XML data be inserted in the database table by the mapping relations of above-mentioned configuration and the mapped file of generation.
In addition, in some cases, the needs that above-mentioned mapping relations can not satisfy data transaction fully may occur, therefore may need the data of reading in are carried out special processing.At this moment, can at certain database table before importing database, increase a Handler function that carries out special processing, data are carried out special processing.This kind situation and the foregoing description type repeat no more herein.
Utilize mapped file that the database format data are converted to base station XML formatted data in step 906 and can adopt mode shown in 4, its idiographic flow repeats no more as described in embodiment one and two herein.
For example, utilize the application of said method and system as follows:
The modification of base station data: in the regular maintenance of base station, need be according to practical application, revise the part configuration parameter, this moment, needs read in the configuration file of base station in the configuration tool earlier, then this configuration file is converted to the database format data, after being converted to the base station configuration file, is issued to the base station behind the modification configuration parameter.
Browse the base station configuration parameter: in the regular maintenance of base station, often need check a lot of configuration parameters of base station, just need read the base station configuration file and be converted into the database format data this moment, intuitively browses on the gui interface of configuration tool.
Configuration file with certain base station is a template, creates the data of another one base station: the configuration file of operate as normal base station in the existing network can be read in the configuration tool, carry out minor modifications, export to configuration file again and be issued in the other base station and come into force.
Newly-built base station: what a base station data of configuration in configuration tool, and be stored among the database D B, be converted into the base station configuration file, issue the base station, make the base station operate as normal.
Base station configuration parameter adjustment and upgrading service: base station configuration parameter or business datum need be adjusted according to user's requirement, requirement of actual application.After formerly finishing the transfer process first time, data have been transformed among the database D B of configuration tool from the XML form of configuration file, at this moment just can adjust at the enterprising line parameter of gui interface.Having adjusted, is the XML file of base station with data conversion new in the configuration tool, issues the base station.
By the foregoing description, by mapping relations or mapped file make conversion between the XML formatted data of configuration tool database format data and base station network element become convenient, efficient, realize simple and cost low; Make data configuration simple, convenient, efficient; Greatly reduce the size of code that program realizes; Exploitation composition and maintenance cost that XML and database in the RAN configuration tool carry out exchanges data have been reduced.
Above-described specific embodiment; purpose of the present invention, technical scheme and beneficial effect are further described; institute is understood that; the above only is specific embodiments of the invention; and be not intended to limit the scope of the invention; within the spirit and principles in the present invention all, any modification of being made, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (14)
1. the data configuration method of a wireless access network is characterized in that, comprises step:
Configuration tool is configured base station data;
Utilize the mapping relations between configuration tool database model and the base station configuration file model, the data of database format of configuration are converted to the base station configuration file;
This base station configuration file is sent to the base station.
2. data configuration method according to claim 1 is characterized in that, before the arrangements of steps instrument is configured base station data, also comprises step:
The configuration file that stores in the base station is read in configuration tool;
Utilize the configuration tool database model of foundation in advance and the mapping relations between the base station configuration file model, base station configuration file format data are converted to the database format data.
3. data configuration method according to claim 1 and 2 is characterized in that, the form of described base station configuration file is for can be the extension markup language form.
4. data configuration method according to claim 3, described mapping relations comprise database table at least and can be the mapping relations of mapping relations, database table field and the leaf node of extension markup language node; Wherein, the described configuration object that stores in the extension markup language node respective base station that can be, described leaf node is to a configuration parameter that should configuration object.
5. data configuration method according to claim 4 is characterized in that: described database table is mapping or many-one or one-to-many mapping one by one with the mapping relations that can be the extension markup language node.
6. data configuration method according to claim 4 is characterized in that, utilizes described mapping relations, and base station configuration file format data are converted to the database format data, comprises step:
Order reads the value of each leaf node;
In described mapping relations or mapped file, search the respective items of described leaf node, obtain the table name and the field name of the database table of described leaf node correspondence, and it is right to generate the numerical value of value of the field name comprise database table and leaf node;
Judge whether described leaf node is last field of correspondence database table, if the result who judges is for being, then with described numerical value to inserting described database.
7. data configuration method according to claim 6, it is characterized in that, with described numerical value to before inserting described database, also comprise step: judge whether leaf node described in the mapping relations needs to carry out special processing, if judged result is for being then to carry out corresponding special processing.
8. data configuration method according to claim 4 is characterized in that, utilizes described mapping relations, and the data of database format are converted to the base station configuration file, comprises step:
Order reads each data item in the described mapping relations;
Read data base view title, field level special processing, the default value of field, field name that base station in the described data item can be the title correspondence of extension markup language node;
Whether default value, the field name of judging described field level special processing, field successively are empty, are not empty if judged result is the field level special processing, then carry out corresponding special processing; If the default value of field is not empty, then give this node default value; If field name is not empty, then from data base view, reads the database value of described field name field correspondence, and this database value is composed to can be the extension markup language node.
9. data configuration method according to claim 1 is characterized in that, being disposed by aid Microsoft Excel of described mapping relations.
10. a data collocation system is characterized in that, comprising:
The base station comprises first memory cell at least, is used for the storage configuration file;
Configuration tool, at least comprise the data configuration unit and second converting unit, wherein, described data configuration unit is used for base station data is configured, described second converting unit is used to utilize the mapping relations table between configuration tool database model and the base station configuration file model, and the data of database format of configuration are converted to the base station configuration file; And this base station configuration file is sent to described base station;
The terminal of operation configuration tool is connected with described base station, comprises second memory cell at least, is used for the base station data after the storage configuration; Store described mapping relations table;
Described base station also is used to receive the configuration file that described configuration tool transmits, and is stored to described first memory cell.
11. data collocation system according to claim 10, it is characterized in that, described configuration tool also comprises first converting unit, is used to read the configuration file that described base station stores, and utilizes described mapping relations table base station configuration file format data to be converted to the base station data of database format;
Described second memory cell also is used for storage and is converted to the database format base station data.
12. data collocation system according to claim 11 is characterized in that, described base station configuration file format is for can be the extension markup language form.
13. data collocation system according to claim 12, described mapping relations comprise database table at least and can be the mapping relations of mapping relations, database table field and the leaf node of extension markup language node; Wherein, a described configuration object that can be in the extension markup language node respective base station memory, described leaf node is to a configuration parameter that should configuration object.
14. data collocation system according to claim 13 is characterized in that: described database table is mapping or many-one or one-to-many mapping one by one with the mapping relations that can be the extension markup language node.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200710119530 CN101094144A (en) | 2007-07-26 | 2007-07-26 | Data collocation method and system of wireless access network |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200710119530 CN101094144A (en) | 2007-07-26 | 2007-07-26 | Data collocation method and system of wireless access network |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101094144A true CN101094144A (en) | 2007-12-26 |
Family
ID=38992187
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200710119530 Pending CN101094144A (en) | 2007-07-26 | 2007-07-26 | Data collocation method and system of wireless access network |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101094144A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101901267A (en) * | 2010-08-02 | 2010-12-01 | 中兴通讯股份有限公司 | Method and device for managing configuration files |
| WO2014101887A1 (en) * | 2012-12-31 | 2014-07-03 | 华为技术有限公司 | Method and apparatus for performing communications in wireless software defined network |
| CN104753696A (en) * | 2013-12-26 | 2015-07-01 | 成都鼎桥通信技术有限公司 | User premises equipment station-opening method and device |
| CN109906628A (en) * | 2016-11-28 | 2019-06-18 | 华为技术有限公司 | The method, apparatus automatically configured and base station |
| CN111026451A (en) * | 2019-10-31 | 2020-04-17 | 许昌许继软件技术有限公司 | Parameter configuration method and configuration tool for transformer substation terminal interval |
| CN115203176A (en) * | 2022-09-15 | 2022-10-18 | 太平金融科技服务(上海)有限公司深圳分公司 | Database operation method, database operation device, database operation equipment, storage medium and program product |
-
2007
- 2007-07-26 CN CN 200710119530 patent/CN101094144A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101901267A (en) * | 2010-08-02 | 2010-12-01 | 中兴通讯股份有限公司 | Method and device for managing configuration files |
| WO2014101887A1 (en) * | 2012-12-31 | 2014-07-03 | 华为技术有限公司 | Method and apparatus for performing communications in wireless software defined network |
| US10278159B2 (en) | 2012-12-31 | 2019-04-30 | Huawei Technologies Co., Ltd. | Method for preforming communications in wireless software defined network and apparatus thereof |
| CN104753696A (en) * | 2013-12-26 | 2015-07-01 | 成都鼎桥通信技术有限公司 | User premises equipment station-opening method and device |
| CN109906628A (en) * | 2016-11-28 | 2019-06-18 | 华为技术有限公司 | The method, apparatus automatically configured and base station |
| CN109906628B (en) * | 2016-11-28 | 2020-12-15 | 华为技术有限公司 | Automatic configuration method, device and base station |
| US11201786B2 (en) | 2016-11-28 | 2021-12-14 | Huawei Technologies Co., Ltd. | Auto-configuration method and apparatus, and base station |
| CN111026451A (en) * | 2019-10-31 | 2020-04-17 | 许昌许继软件技术有限公司 | Parameter configuration method and configuration tool for transformer substation terminal interval |
| CN115203176A (en) * | 2022-09-15 | 2022-10-18 | 太平金融科技服务(上海)有限公司深圳分公司 | Database operation method, database operation device, database operation equipment, storage medium and program product |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100388675C (en) | A method for implementing foreground data configuration in network management system | |
| CN100547583C (en) | Database automatically and the method that dynamically provides | |
| CN106164865B (en) | The method and system of the affairs batch processing of dependence perception for data duplication | |
| CN100596353C (en) | Method and system for providing log service | |
| CN101799826B (en) | Networking data sharing system and method based on virtual view | |
| CN101136783B (en) | Backup, recovery method and apparatus for network management system to configure data | |
| CN101094144A (en) | Data collocation method and system of wireless access network | |
| CN105740411B (en) | A kind of data migration method based on SOA and WebService | |
| CN100484039C (en) | Network management apparatus and network management method | |
| CN101409614A (en) | Data synchronization method, system and equipment | |
| CN106649378A (en) | Data synchronizing method and device | |
| CN106599104A (en) | Mass data association method based on redis cluster | |
| CN102054032A (en) | Medical data information processing method and system | |
| CN104142930A (en) | Universal Delta data loading technology | |
| CN102254029A (en) | View-based data access system and method | |
| CN102402526A (en) | Geographic information database management method and system | |
| CN101714157A (en) | Method, device and heterogeneous database system for generating heterogeneous database report | |
| CN101552701A (en) | Method, system and device for recording parameter maintenance variation | |
| CN108764683A (en) | Operation of power networks data analysis assessment and reporting system | |
| CN103218402A (en) | General database data structure, data migratory system and method thereof | |
| CN103020093A (en) | Method and system for recording and displaying extensible business reporting language (XBRL) information disclosure report | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN101615176A (en) | A kind of data monitoring system and implementation method | |
| CN105468793A (en) | Automated management method for simulation model data | |
| CN110825718A (en) | Information system data architecture model and construction method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |