CN102065413B - Database updating method and system, and base station self-starting method and system - Google Patents
Database updating method and system, and base station self-starting method and system Download PDFInfo
- Publication number
- CN102065413B CN102065413B CN201010548223.3A CN201010548223A CN102065413B CN 102065413 B CN102065413 B CN 102065413B CN 201010548223 A CN201010548223 A CN 201010548223A CN 102065413 B CN102065413 B CN 102065413B
- Authority
- CN
- China
- Prior art keywords
- data table
- field
- data
- database
- legacy
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
The method discloses a database updating method. The method is characterized by comprising the following steps of: receiving configuration file information of a new database comprising new data tables; for all the original data tables in the original database, searching whether the new database has the new data tables which have the same attribute as the original data tables in the original database; and if so, merging data in the new data tables into the original data tables according to the preset characteristics of all fields in the original data tables to generate the updated date tables. The invention also discloses a database updating system, a base station self-starting method and a base station self-starting system. Through the method and the system, the database is updated smoothly, so that the efficiency of database updating is improved further, human resources are saved and the operating cost of a communication network is reduced.
Description
Technical field
The present invention relates to the communications field, particularly relate to a kind of database upgrade method and system, base station self-starting method and system.
Background technology
Along with the development of 3G (Third Generation) Moblie technology, industry constantly proposes various new wireless access technologys, in order to improve the professional ability of communication system.In addition, operator can propose for some specific network environments the customization demand of some customizations in actual networking process.Above-mentioned application scenario all needs base station (eNodeB) system according to specifically carrying out upgrade database.
In prior art, to the database upgrade in base station, be mainly to cover original data base configuration file with new data base configuration file.In this manner, the total data in new data base configuration file (comprising various parameters) all needs staff to carry out manual configuration in operation maintenance center (Operate Maintain Center, OMC).
But in practical application, because the data that need staff manually to input are very many, therefore cause the inefficiency of database upgrade, consumed a large amount of human resources simultaneously, improved the operation cost of communication network.
Summary of the invention
The object of this invention is to provide a kind of database upgrade method and system, base station self-starting method and system, can carry out in conjunction with the data of original database in base station the smooth upgrade of database.
For achieving the above object, the invention provides following scheme:
A database upgrade method, comprises step:
The new database profile information that reception comprises new data table;
For each legacy data table in legacy data storehouse, search in described new database, whether to there is the new data table identical with its attribute;
If had, according to the preset features of each field in legacy data table, the data in described new data table are merged in described legacy data table, generate the tables of data after upgrading.
Preferably, described in search in described new database, whether to there is the new data table identical with the attribute of the legacy data table in legacy data storehouse, comprising:
Be respectively in advance each new data table and each legacy data table generating identification; The attribute information that described sign comprises tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge that whether described legacy data table is identical with the attribute of described new data table.
Preferably, described attribute information comprises: the title of each field, length, type in tables of data;
In the following manner for each tables of data generates described sign:
The title of each field in tables of data, length, type are formed to character string by preset mode;
Utilize MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as to described sign.
Preferably, also comprise: for each field in described legacy data table and new data table increases field identification, described field identification is for representing whether described field needs to adopt the data of described new data table in advance; Described data in described new data table are merged in described legacy data table, comprising:
Obtain the field identification of each field in described legacy data table, for the field that need to adopt the data of described new data table, adopt the data of this field of legacy data table described in the data replacement of described new data table respective field; For the field that does not need to adopt the data of described new data table, retain the data of described this field of legacy data table.
Preferably, for the field that need to adopt the data of described new data table, before the data of this field of legacy data table, also comprise described in the data replacement of the described new data table of described employing respective field:
If described, need to adopt the field of the data of described new data table to meet prerequisite,,
In increase legacy data table, this field can be held the maximum magnitude of data;
Or,
The request that reduces this field in legacy data table and can hold the maximum magnitude of data is sent to operation maintenance center, after receiving the confirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in legacy data table can be held data.
Preferably, also comprise:
Other parameters in tables of data after adopting self-optimizing technology to described upgrading are carried out additional configurations.
Preferably, also comprise:
The parameter information of described additional configurations is sent to described operation maintenance center.
A base station self-starting method, comprising:
Form with broadcast sends startup request;
The message of the described startup request of response that reception operation maintenance center issues, creates and connects to described operation maintenance center;
By described connection upgrade software and the firmware of described base station;
Receive the database version information that described operation maintenance center sends;
According to described database version information judge whether the to upgrade database of described base station;
If so, also comprise the database upgrade method described in aforementioned any one; And
To described operation maintenance center return data qurush level success message;
Start described base station.
A database upgrade system, comprising:
Configuration information receiver module, for receiving the new database profile information that comprises new data table;
Attribute matching module, for each legacy data table to legacy data storehouse, searches in described new database, whether to have the new data table identical with its attribute;
Data merge module, for according to the preset features of each field of legacy data table, the data in the described new data table identical with described legacy data Table Properties are merged in described legacy data table, generate the tables of data after upgrading.
A base station self-starting system, comprising:
Start request sending module, for the form with broadcast, send and start request;
Connect creation module, for receiving the message of the described startup request of response that operation maintenance center issues, to described operation maintenance center, create and connect;
Software firmware upgrade module, for software and the firmware of the described base station of upgrading by described connection;
Database version information receiving module, the database version information sending for receiving described operation maintenance center;
Database upgrade judge module, for the database of the described base station that judges whether according to described database version information to upgrade;
And aforesaid database upgrade system, for when judgment result is that of database upgrade judge module need to be upgraded, the database of the described base station of upgrading;
Upgrade successfully message and return to module, for to described operation maintenance center return data qurush level success message;
Base station initiated module, for starting described base station.
Adopt method and system of the present invention, in carrying out the process of database upgrade, can be according to the preset features of each field in legacy data table, data in described new data table are merged in described legacy data table, rather than adopt the mode all covering, realized the smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in tables of data to carry out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficiency of database upgrade, has saved human resources, has reduced the operation cost of communication network.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the database upgrade method flow diagram that the embodiment of the present invention provides;
Fig. 2 is the base station self-starting method flow chart that the embodiment of the present invention provides;
Fig. 3 is the database upgrade system schematic that the embodiment of the present invention provides;
Fig. 4 is the base station self-starting system schematic diagram that the embodiment of the present invention provides.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
Referring to Fig. 1, it is database upgrade method flow diagram described in the embodiment of the present invention.As shown in Figure 1, the method comprising the steps of:
S101: receive the new database profile information that comprises new data table;
Wherein, a database can comprise a plurality of new data tables.Each tables of data can comprise a plurality of fields, and the data in tables of data are stored in corresponding field.For example in the tables of data of certain " base station frequency " by name, have as next record: Beijing 1,1500,500.Wherein field name corresponding to " Beijing 1 " is " base station name ", and field name corresponding to " 1500 " is " peak frequency ", and field name corresponding to " 500 " is " minimum frequency ".
S102: for each legacy data table in legacy data storehouse, search whether there is the new data table identical with its attribute in described new database;
So-called attribute is identical, can refer to that new data table is identical with the table name of legacy data table; Also can refer to that two tables have identical field number, and the field name of each Related fields is identical, also new table is compared with male cousin, there is no field newly-increased or deletion, and the meaning of each field do not change (variation be only the concrete data under each field).
For the latter, the attribute of tables of data described in step S102 just can comprise the attribute information of each field of this tables of data.The attribute information of field can comprise field: title, type, length.In above-mentioned example, " base station name " is exactly field name, and the type of this field can be text-type, and length can be 8 bytes.
S103: according to the preset features of each field in legacy data table, the data in described new data table are merged in described legacy data table, generate the tables of data after upgrading.
Wherein, the preset features of field can represent whether the data of this field need to adopt the data of the data replacement legacy data table respective field in new data table.This is because a part of data in new data base configuration file may be identical with legacy data, for this part data, just can retain the data of legacy data table respective field, needn't replace, and also needn't carry out human configuration; Some data (for example neighboring BS relationship parameter), system, according to the actual adjacent area situation of this base station, can configure automatically, for this part data, can allow system automatically generate according to actual conditions, does not also need to be manually configured.
Adopt database upgrade method of the present invention, in carrying out the process of database upgrade, can be according to the preset features of each field in legacy data table, data in described new data table are merged in described legacy data table, rather than adopt the mode all covering, realized the smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in tables of data to carry out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficiency of database upgrade, has saved human resources, has reduced the operation cost of communication network.
Concrete, in step S102, for each legacy data table in legacy data storehouse, search in described new database, whether to there is the new data table identical with its attribute, can be in the following ways:
Be respectively in advance each new data table and each legacy data table generating identification; The attribute information that described sign comprises tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge that whether described legacy data table is identical with the attribute of described new data table.
Described sign can be the table name of tables of data, in practical application, can, only by comparing the table name of new data table and legacy data table, judge that whether two tables are identical.But, in some cases, the table name of tables of data does not change, but may increase or reduce some field in this tables of data, or change has occurred the implication of some field (is for example " 1500 " these data equally, may in legacy data table, represent peak frequency, in new data table, represent minimum frequency).Now, by comparing the table name of new data table and legacy data table, judge that the whether identical meeting of two tables causes database upgrade mistake.
Therefore in another embodiment of the present invention, described sign can comprise other attribute information of tables of data, concrete, and described attribute information can comprise: the title of each field, length, type in tables of data.Described sign can generate in the following manner:
The title of each field in tables of data, length, type are formed to character string by preset mode;
Utilize MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as to described sign.
Wherein, the described preset mode that the title of each field in each tables of data, length, type is formed to character string is identical, can guarantee that like this character string forming according to the field of same names, length, type is identical.
MD5 algorithm is a kind of widely used digital digest algorithm.Adopt this algorithm, no matter there is any type of change in the attribute information of tables of data, all can cause the digital digest of this tables of data to change.Therefore, as long as the digital digest of two tables of data that employing MD5 algorithm generates is identical, just can represent that these two tables of data have identical field number, and in two tables, title, length, the type of corresponding each field is also identical.
Hold intelligible, the attribute information of tables of data described in the present invention also can, only comprise title and the type of each field in tables of data, or comprise other attribute of this field.
In step S103 according to the preset features of each field in legacy data table, data in described new data table are merged in described legacy data table, the preset features of each field can be original certain attribute of this field, can be to be also certain newly-increased attribute of this field.
Preset features for field is original certain attribute of this field, might as well continue to describe with precedent: in previous examples, mention, the title of some field is " base station name ", in practical application, the title of base station may can change hardly, so, can judge the title of field, if the title of this field is " base station name ", think that this field is the field that does not need to adopt the data of described new data table, retains the data of described this field of legacy data table.
In original attribute due to each field, not necessarily there is one can be used for representing whether this field needs to adopt the data of described new data table, so in another embodiment of the present invention, provide a step for the newly-increased attribute of this field:
Be that in described legacy data table and new data table, each field increases field identification in advance, described field identification is for representing whether described field needs to adopt the data of described new data table;
Obtain the field identification of each field in described legacy data table, for the field that need to adopt the data of described new data table, adopt the data of this field of legacy data table described in the data replacement of described new data table respective field; For the field that does not need to adopt the data of described new data table, retain the data of described this field of legacy data table.
Wherein, described field identification is to be the newly-increased attribute of this field, can be defined as " template " or " non-template "." template " represents that the data of this field in legacy data table need to adopt the data replacement of described new data table respective field; " non-template " represents that the data of this field in legacy data table can retain.
Get after described field identification, can judge this field identification, if " template " adopts the data of this field of legacy data table described in the data replacement of described new data table respective field; If " non-template ", retains the data of described this field of legacy data table.
For the ease of operating personnel, the data in new data table are configured, the method for the invention also comprises:
On the configuration interface of new data table, do not need to adopt the field of new data table data to be set to hide or read states only.
When this field is set to after described hidden state, on the configuration interface of tables of data, will not show this field; When this field is set to, after a described read states, on the configuration interface of tables of data, can not input data in this field.These two kinds of methods, can make operating personnel adopt the field of new data table data to be configured to not needing, and also avoided the mistake that may cause due to human configuration.
In practical application, may there is this situation: certain field in new data table, with the respective field in corresponding legacy data table, both field names, type are all identical, but it is different in two fields, can to hold the maximum magnitude of data.In this case, just need to, according to prerequisite, to this field in legacy data table, can hold the maximum magnitude of data and change.
The maximum magnitude conversion that can hold data to this field in legacy data table comprises: in increase legacy data table, this field can be held the maximum magnitude of data; Or, reduce the maximum magnitude that this field in legacy data table can be held data.
Described prerequisite can be: judge that this field in new data table can hold the maximum magnitude of data and whether be greater than the maximum magnitude that this field in legacy data table can be held data.If so, increase the maximum magnitude that this field in legacy data table can be held data.Accordingly, if the maximum magnitude that in new data table, this field can be held data is less than the maximum magnitude that this field in legacy data table can be held data, reduce the maximum magnitude that this field in legacy data table can be held data.
It is pointed out that owing to reducing when this field in legacy data table can be held the maximum magnitude of data to cause the data that under this field, other length is larger to store.So, reduce this field in legacy data table and can hold the detailed process of the maximum magnitude of data and comprise:
The request that reduces this field in legacy data table and can hold the maximum magnitude of data is sent to operation maintenance center, after receiving the confirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in legacy data table can be held data.
Operation maintenance center (OMC) can judge according to the physical length of data, if under this field the physical length of all data all in the legacy data table after reducing this field can hold in the maximum magnitude of data, send and confirm conversion instruction; Otherwise, this field is not carried out to scope conversion.
It should be noted that, when simultaneously, adopt of the present invention: " be respectively in advance each new data table and each legacy data table generating identification; The attribute information that described sign comprises tables of data; By the sign of more described new data table and the sign of described legacy data table, judge that whether described legacy data table is identical with the attribute of described new data table " when " maximum magnitude that can hold data to this field in legacy data table is changed " this two steps; after carrying out scope conversion; the information such as the length attribute of field may change; and then cause the attribute-bit of corresponding tables of data to change, two identical tables of data of attribute become the tables of data that attribute is not identical originally.
For fear of above-mentioned condition, occur, the method for the invention also comprises:
The length attribute that can carry out the field of scope conversion, represents by unified title.
Can avoid like this some field owing to having carried out scope conversion, and cause the attribute-bit of this tables of data to change.For example: U8 indicates without symbol 8 bit value types, U16 indicates without symbol 16 bit value types, just can be both representing with NUM, and can avoid like this attribute-bit of tables of data to carry out scope conversion because of some field and change.
Adopt the method for the invention, also comprise: for each legacy data table in legacy data storehouse, after searching and whether thering is the new data table identical with its attribute in described new database, if certain legacy data table does not have the new data table identical with this legacy data Table Properties in described new database: delete this legacy data table.
Because if certain legacy data table new data table identical with this legacy data Table Properties not in described new database, can think practical function useless after this legacy data table upgrading, so by its deletion.
In like manner, if certain the new data table in described new database does not have the legacy data table identical with this new data Table Properties in described legacy data table, this new data table is written in described legacy data storehouse.
After executing above-mentioned steps, completed for the field that need to adopt the data of described new data table, adopt the data of this field of legacy data table described in the data replacement of described new data table respective field; For the field that does not need to adopt the data of described new data table, retain the data of described this field of legacy data table.
Wherein, for the field that does not need to adopt the data of described new data table, also there are two kinds of situations: a kind of is the data that can directly retain this field of legacy data table, and another kind needs system automatically to configure according to the actual conditions of self.
So database upgrade method of the present invention, also comprises:
Other parameters in tables of data after adopting self-optimizing technology to described upgrading are carried out additional configurations.
Described self-optimizing technology, refers to the correlation technique of self-optimizing network (self-optimizing network, SON).Name, just can find out, the main function of SON is for reducing unnecessary and a large amount of waste of human resource.
A kind of technology in self-optimizing technology is: Automatic Neighboring Relation (ANR automatic neighborrelation) technology.Adopt ANR technology to generate neighboring BS relationship parameter according to the actual adjacent area situation of base station.
Therefore, other parameters in the tables of data of employing self-optimizing technology of the present invention after to described upgrading are carried out additional configurations and are comprised:
Adopt the neighboring BS relationship parameter in Automatic Neighboring Relation ANR technical configuration tables of data.
In practical application, adopt other parameters of self-optimizing technique complementary configuration for base station self, OMC is ignorant.Because OMC is when being configured the database of other base stations, may need aforementioned base station self to adopt the parameter of self-optimizing technique complementary configuration, according to the parameter of aforementioned base station self additional configurations, could unify configuration to other base stations.So the method for the invention also comprises:
The parameter information of described additional configurations is sent to described operation maintenance center.
The parameter information of described additional configurations is sent to after described operation maintenance center (OMC), and OMC just can obtain the parameter information of this base station additional configurations, and then according to the parameter of this base station self additional configurations, configuration is unified in other base stations.
The invention also discloses a kind of base station self-starting method, as shown in Figure 2, the method comprising the steps of:
S201: the form with broadcast sends startup request;
Upgrade request and initial configuration information are all to be initiated by base station (eNodeB) end, and give basic parameter configuration by OMC end.ENodeB does not also know the specific address of OMC, so what send out is broadcast.
S202: the message of the described startup request of response that reception operation maintenance center issues, creates and connect to described operation maintenance center;
S203: by described connection upgrade software and the firmware of described base station;
S204: receive the database version information that described operation maintenance center sends;
S205: according to described database version information judge whether the to upgrade database of described base station;
Concrete, according to described database version information judge whether the to upgrade database of described base station, can be in the following way: the database version information that the OMC relatively receiving sends and the database version information of base station self, if both versions are identical, do not upgrade; For example, if self version is compared comparatively legacy version (version sequence number is less) with the version that OMC sends, carry out the upgrading of database.
S206: if also comprise database upgrade method of the present invention; And
S207: to described operation maintenance center return data qurush level success message;
S208: start described base station.
Adopt base station self-starting method of the present invention, one side can realize base station automatically and OMC connects, and owing to having adopted database upgrade method of the present invention, can also realize the smooth upgrade to database on the other hand.
Corresponding with database upgrade method of the present invention, the invention also discloses a kind of database upgrade system.Referring to Fig. 3, it is database upgrade system construction drawing described in the embodiment of the present invention.As shown in Figure 3, this system comprises:
Configuration information receiver module 301, for receiving the new database profile information that comprises new data table;
Wherein, a database can comprise a plurality of new data tables.Each tables of data can comprise a plurality of fields, and the data in tables of data are stored in corresponding field.
So-called attribute is identical, can refer to that new data table is identical with the table name of legacy data table; Also can refer to that two tables have identical field number, and the field name of each Related fields is identical, also new table is compared with male cousin, there is no field newly-increased or deletion, and the meaning of each field do not change (variation be only the concrete data under each field).
For the latter, the attribute of described tables of data just can comprise the attribute information of each field of this tables of data.The attribute information of field can comprise field: title, type, length.
Data merge module 303, for according to the preset features of each field of legacy data table, the data in the described new data table identical with described legacy data Table Properties are merged in described legacy data table, generate the tables of data after upgrading.
Wherein, the preset features of field can represent whether the data of this field need to adopt the data of the data replacement legacy data table respective field in new data table.This is because a part of data in new data base configuration file may be identical with legacy data, for this part data, just can retain the data of legacy data table respective field, needn't replace, and also needn't carry out human configuration; Some data (for example neighboring BS relationship parameter), system, according to the actual adjacent area situation of this base station, can configure automatically, for this part data, can allow system automatically generate according to actual conditions, does not also need to be manually configured.
Adopt database upgrade system of the present invention, in carrying out the process of database upgrade, can be according to the preset features of each field in legacy data table, data in described new data table are merged in described legacy data table, rather than adopt the mode all covering, realized the smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in tables of data to carry out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficiency of database upgrade, has saved human resources, has reduced the operation cost of communication network.
In practical application, database upgrade system of the present invention, can also comprise:
Tables of data sign generation module, for being respectively each new data table and each legacy data table generating identification; The attribute information that described sign comprises tables of data;
Accordingly, described attribute matching module 302 comprises:
Tables of data sign comparing unit, for by the sign of more described new data table and the sign of described legacy data table, judges that whether described legacy data table is identical with the attribute of described new data table.
Described tables of data sign generation module can generate described sign in the following manner:
The title of each field in tables of data, length, type are formed to character string by preset mode;
Utilize MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as to described sign.
Wherein, the described preset mode that the title of each field in each tables of data, length, type is formed to character string is identical, can guarantee that like this character string forming according to the field of same names, length, type is identical.
Hold intelligible, the attribute information of tables of data described in the present invention also can, only comprise title and the type of each field in tables of data, or comprise other attribute of this field.
In practical application, database upgrade system of the present invention can also comprise:
Field identification generation module, is used to each field in described legacy data table and new data table to increase field identification, and described field identification is for representing whether described field needs to adopt the data of described new data table;
Accordingly, described data merging module 303 comprises:
Field identification recognition unit, for obtaining the field identification of described each field of legacy data table, judges whether respective field needs to adopt the data of described new data table;
Data replacement unit, for the field for adopting the data of described new data table, adopts the data of this field of legacy data table described in the data replacement of described new data table respective field.
Wherein, the described field identification that field identification generation module generates is to be the newly-increased attribute of this field, can be defined as " template " or " non-template "." template " represents that the data of this field in legacy data table need to adopt the data replacement of described new data table respective field; " non-template " represents that the data of this field in legacy data table can retain.
Field identification recognition unit gets after described field identification, can judge this field identification, if " template " adopts the data of this field of legacy data table described in the data replacement of described new data table respective field; If " non-template ", retains the data of described this field of legacy data table.
For the ease of operating personnel, the data in new data table are configured, in database upgrade system of the present invention, described field identification generation module also comprises:
Field status setting unit, for the configuration interface at new data table, does not need to adopt the field of new data table data to be set to hide or read states only.
In practical application, may there is this situation: certain field in new data table, with the respective field in corresponding legacy data table, both field names, type are all identical, but it is different in two fields, can to hold the maximum magnitude of data.In this case, just need to, according to prerequisite, to this field in legacy data table, can hold the maximum magnitude of data and change.
Accordingly, in database upgrade system of the present invention described data merge module 303 and also comprise:
Scope converting unit, for judging that whether the described field of the data of described new data table that need to adopt meets prerequisite, can hold the maximum magnitude of data and change to this field in qualified legacy data table.
The maximum magnitude conversion that can hold data to this field in legacy data table comprises: in increase legacy data table, this field can be held the maximum magnitude of data; Or, reduce the maximum magnitude that this field in legacy data table can be held data.
Accordingly, described scope converting unit comprises:
Scope increases subelement, can hold the maximum magnitude of data for increasing this field of legacy data table;
Scope reduces subelement, for the request that reduces this field of legacy data table and can hold the maximum magnitude of data is sent to operation maintenance center, after receiving the confirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in legacy data table can be held data.
Corresponding to database upgrade method of the present invention, database upgrade system of the present invention can also comprise:
Tables of data removing module, for judging whether certain legacy data table has the new data table identical with this legacy data Table Properties in described new database, if there is no the new data table identical with this legacy data Table Properties, deletes this legacy data table.
Tables of data writing module, for judging certain new data table of described new database, in described legacy data table, whether there is the legacy data table identical with this new data Table Properties, if the legacy data table identical with this new data Table Properties, is not written to this new data table in described legacy data storehouse.
Additional configurations module, carries out additional configurations for other parameters of the tables of data after adopting self-optimizing technology to described upgrading.
Wherein, additional configurations module can comprise: neighboring BS relationship dispensing unit, and for adopting the neighboring BS relationship parameter of Automatic Neighboring Relation ANR technical configuration tables of data.
Additional configurations information sending module, for being sent to described operation maintenance center by the parameter information of described additional configurations.
The invention also discloses a kind of base station self-starting system, as shown in Figure 4, comprising:
Start request sending module 401, for the form with broadcast, send and start request;
Connect creation module 402, for receiving the message of the described startup request of response that operation maintenance center issues, to described operation maintenance center, create and connect;
Software firmware upgrade module 403, for software and the firmware of the described base station of upgrading by described connection;
Database version information receiving module 404, the database version information sending for receiving described operation maintenance center;
Database upgrade judge module 405, for the database of the described base station that judges whether according to described database version information to upgrade;
And the database upgrade system described in claim 14 to 24 any one, for when judgment result is that of database upgrade judge module need to be upgraded, the database of the described base station of upgrading;
Upgrade successfully message and return to module 406, for to described operation maintenance center return data qurush level success message;
Base station initiated module 407, for starting described base station.
Adopt base station of the present invention self-starting system, one side can realize base station automatically and OMC connects, and owing to having adopted database upgrade system of the present invention, can also realize the smooth upgrade to database on the other hand.
In this specification, each embodiment adopts the mode of going forward one by one to describe, and each embodiment stresses is the difference with other embodiment, between each embodiment identical similar part mutually referring to.For the disclosed system of embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part partly illustrates referring to method.
Applied specific case herein principle of the present invention and execution mode are set forth, the explanation of above embodiment is just for helping to understand method of the present invention and core concept thereof; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications.In sum, this description should not be construed as limitation of the present invention.
Claims (8)
1. a database upgrade method, is characterized in that, comprises step:
In self-optimizing network, be that in legacy data table and new data table, each field increases field identification in advance, described field identification is for representing whether described field needs to adopt the data of described new data table;
The new database profile information that reception comprises new data table;
For each legacy data table in legacy data storehouse, search in described new database, whether to there is the new data table identical with its attribute;
If had, according to the preset features of each field in legacy data table, the data in described new data table are merged in described legacy data table, generate the tables of data after upgrading;
Described data in described new data table are merged in described legacy data table, comprising:
Obtain the field identification of each field in described legacy data table, for the field that need to adopt the data of described new data table, if described, need to adopt the field of the data of described new data table to meet prerequisite,,
In increase legacy data table, this field can be held the maximum magnitude of data;
Or,
The request that reduces this field in legacy data table and can hold the maximum magnitude of data is sent to operation maintenance center, after receiving the confirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in legacy data table can be held data;
Adopt the data of this field of legacy data table described in the data replacement of described new data table respective field; For the field that does not need to adopt the data of described new data table, retain the data of described this field of legacy data table.
2. method according to claim 1, is characterized in that, described in search in described new database, whether to there is the new data table identical with the attribute of the legacy data table in legacy data storehouse, comprising:
Be respectively in advance each new data table and each legacy data table generating identification; The attribute information that described sign comprises tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge that whether described legacy data table is identical with the attribute of described new data table.
3. method according to claim 2, is characterized in that, described attribute information comprises: the title of each field, length, type in tables of data;
In the following manner for each tables of data generates described sign:
The title of each field in tables of data, length, type are formed to character string by preset mode;
Utilize MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as to described sign.
4. according to the method described in claims 1 to 3 any one, it is characterized in that, also comprise:
Other parameters in tables of data after adopting self-optimizing technology to described upgrading are carried out additional configurations.
5. method according to claim 4, is characterized in that, also comprises:
The parameter information of described additional configurations is sent to described operation maintenance center.
6. a base station self-starting method, is characterized in that, comprising:
Form with broadcast sends startup request;
The message of the described startup request of response that reception operation maintenance center issues, creates and connects to described operation maintenance center;
By described connection upgrade software and the firmware of described base station;
Receive the database version information that described operation maintenance center sends;
According to described database version information judge whether the to upgrade database of described base station;
If so, also comprise the database upgrade method described in claim 1 to 5 any one; And
To described operation maintenance center return data qurush level success message;
Start described base station.
7. a database upgrade system, is characterized in that, comprising:
Configuration information receiver module, for receiving the new database profile information that comprises new data table;
Attribute matching module, for each legacy data table to legacy data storehouse, searches in described new database, whether to have the new data table identical with its attribute;
Data merge module, for according to the preset features of each field of legacy data table, the data in the described new data table identical with described legacy data Table Properties are merged in described legacy data table, generate the tables of data after upgrading;
Described data in described new data table are merged in described legacy data table, comprising:
Obtain the field identification of each field in described legacy data table, for the field that need to adopt the data of described new data table, if described, need to adopt the field of the data of described new data table to meet prerequisite,,
In increase legacy data table, this field can be held the maximum magnitude of data;
Or,
The request that reduces this field in legacy data table and can hold the maximum magnitude of data is sent to operation maintenance center, after receiving the confirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in legacy data table can be held data;
Adopt the data of this field of legacy data table described in the data replacement of described new data table respective field; For the field that does not need to adopt the data of described new data table, retain the data of described this field of legacy data table;
Wherein, described field identification is in self-optimizing network, is that in described legacy data table and new data table, each field increases in advance, for representing whether described field needs to adopt the data of described new data table.
8. a base station self-starting system, is characterized in that, comprising:
Start request sending module, for the form with broadcast, send and start request;
Connect creation module, for receiving the message of the described startup request of response that operation maintenance center issues, to described operation maintenance center, create and connect;
Software firmware upgrade module, for software and the firmware of the described base station of upgrading by described connection;
Database version information receiving module, the database version information sending for receiving described operation maintenance center;
Database upgrade judge module, for the database of the described base station that judges whether according to described database version information to upgrade;
And database upgrade system claimed in claim 7, for when judgment result is that of database upgrade judge module need to be upgraded, the database of the described base station of upgrading;
Upgrade successfully message and return to module, for to described operation maintenance center return data qurush level success message;
Base station initiated module, for starting described base station.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010548223.3A CN102065413B (en) | 2010-11-17 | 2010-11-17 | Database updating method and system, and base station self-starting method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010548223.3A CN102065413B (en) | 2010-11-17 | 2010-11-17 | Database updating method and system, and base station self-starting method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102065413A CN102065413A (en) | 2011-05-18 |
| CN102065413B true CN102065413B (en) | 2014-03-12 |
Family
ID=44000465
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010548223.3A Active CN102065413B (en) | 2010-11-17 | 2010-11-17 | Database updating method and system, and base station self-starting method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102065413B (en) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102855305B (en) * | 2012-08-20 | 2015-05-27 | 大唐移动通信设备有限公司 | Data upgrading method and device |
| CN102902818A (en) * | 2012-10-26 | 2013-01-30 | 杭州迪普科技有限公司 | Method and device for upgrading database |
| CN104750774A (en) * | 2014-12-15 | 2015-07-01 | 北京星网锐捷网络技术有限公司 | Database upgrading method and device |
| CN106372857A (en) * | 2016-08-31 | 2017-02-01 | 上海锐鸿通信技术有限公司 | Method and system for automatically establishing project |
| CN106777025B (en) * | 2016-12-08 | 2020-10-27 | 北京国电通网络技术有限公司 | Analysis method and system of database physical model |
| CN107368513B (en) * | 2017-04-25 | 2020-08-14 | 阿里巴巴集团控股有限公司 | Method and device for updating client database |
| CN110019111B (en) * | 2017-08-15 | 2021-11-23 | 北京国双科技有限公司 | Data processing method, data processing device, storage medium and processor |
| CN107679245A (en) * | 2017-10-30 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of organizational structure method of adjustment and device |
| CN108572845B (en) * | 2018-03-15 | 2022-05-31 | 华为技术有限公司 | Upgrading method of distributed micro-service cluster and related system |
| CN109559808A (en) * | 2018-11-07 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN109902078B (en) * | 2019-01-10 | 2021-01-26 | 杭州迪普科技股份有限公司 | Method, device, equipment and storage medium for database upgrading compatibility |
| CN111488340B (en) * | 2019-01-29 | 2023-09-12 | 菜鸟智能物流控股有限公司 | Data processing method and device and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1477546A (en) * | 2002-08-19 | 2004-02-25 | 万达信息股份有限公司 | Method for duplicating data of identical data table between two data bases |
| CN101110788A (en) * | 2006-07-20 | 2008-01-23 | 阿里巴巴公司 | Method and system for updating client software |
| CN101183361A (en) * | 2006-11-13 | 2008-05-21 | 中兴通讯股份有限公司 | Method of relation data base applications automatic upgrade |
| CN101188519A (en) * | 2007-12-04 | 2008-05-28 | 上海华为技术有限公司 | Automatic management method, system, resource management center and base station of base station resource |
| CN101499011A (en) * | 2008-01-29 | 2009-08-05 | 中兴通讯股份有限公司 | Method and apparatus for implementing USB booting and updating of mobile communication base station system |
-
2010
- 2010-11-17 CN CN201010548223.3A patent/CN102065413B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1477546A (en) * | 2002-08-19 | 2004-02-25 | 万达信息股份有限公司 | Method for duplicating data of identical data table between two data bases |
| CN101110788A (en) * | 2006-07-20 | 2008-01-23 | 阿里巴巴公司 | Method and system for updating client software |
| CN101183361A (en) * | 2006-11-13 | 2008-05-21 | 中兴通讯股份有限公司 | Method of relation data base applications automatic upgrade |
| CN101188519A (en) * | 2007-12-04 | 2008-05-28 | 上海华为技术有限公司 | Automatic management method, system, resource management center and base station of base station resource |
| CN101499011A (en) * | 2008-01-29 | 2009-08-05 | 中兴通讯股份有限公司 | Method and apparatus for implementing USB booting and updating of mobile communication base station system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102065413A (en) | 2011-05-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102065413B (en) | Database updating method and system, and base station self-starting method and system | |
| CN102799473B (en) | A kind of method and device managing intelligent display device third-party application | |
| CN104104591A (en) | Message pushing method and system | |
| CN104899325A (en) | APP (application) acquired data collection method, terminal, server and system | |
| CN104168123A (en) | Data push method, data server, client and data push system | |
| CN103068070A (en) | Negotiation method, mobile terminal, base station and communication system of protocol version | |
| CN102647701B (en) | A kind of method and device upgrading the application message of mobile terminal | |
| CN102790727B (en) | A kind of method and system of dynamic propelling movement individual subscriber label | |
| CN102081537A (en) | Method for upgrading software | |
| CN103701913A (en) | Data synchronization method and device | |
| CN102387042B (en) | Automatic configuration method and system as well as network node | |
| CN105187475A (en) | Method and system for data synchronization | |
| US20160241635A1 (en) | M2m data querying and invoking methods, querying and invoking devices, and system | |
| CN105100144A (en) | Application updating method and device | |
| CN110333876A (en) | A kind of data clearing method and control equipment | |
| CN101390410B (en) | Icon transforming system, and service method for the same | |
| CN103559198A (en) | Data synchronizing method and equipment | |
| CN106101250A (en) | The method for customizing of application function and device | |
| CN102811272A (en) | Updating method, updating apparatus and communication terminal | |
| CN104298757A (en) | Method and system allowing compatibility with mobile clients and databases different in version | |
| CN104063377A (en) | Information processing method and electronic equipment using same | |
| US8489838B2 (en) | Method and terminal device for erasing data of terminal | |
| CN100525208C (en) | Data synchronization method | |
| CN104394220A (en) | Upgrading method for smart power grid and smart power grid | |
| CN109614442B (en) | Data table maintenance method and device for data synchronization, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200122 Address after: 430073 Hubei province Wuhan Dongxin East Lake high tech Development Zone, Road No. 5 Patentee after: Wuhan Hongxin Telecommunication Technologies Co.,Ltd. Address before: 100085, building 1, tower 5, East Road, Haidian District, Beijing Patentee before: Beifang Fenghuo Tech Co., Ltd., Beijing |
|
| TR01 | Transfer of patent right | ||
| CP03 | Change of name, title or address |
Address after: 430205 Hubei city of Wuhan province Jiangxia Hidden Dragon Island Tan lake two Road No. 1 Patentee after: CITIC Mobile Communication Technology Co., Ltd Address before: 430073 Hubei province Wuhan Dongxin East Lake high tech Development Zone, Road No. 5 Patentee before: Wuhan Hongxin Telecommunication Technologies Co.,Ltd. |
|
| CP03 | Change of name, title or address | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 430205 No.1 tanhu 2nd Road, Canglong Island, Jiangxia District, Wuhan City, Hubei Province Patentee after: CITIC Mobile Communication Technology Co.,Ltd. Address before: 430205 No.1 tanhu 2nd Road, Canglong Island, Jiangxia District, Wuhan City, Hubei Province Patentee before: CITIC Mobile Communication Technology Co., Ltd |
|
| CP01 | Change in the name or title of a patent holder |