CN102065413A - 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
- CN102065413A CN102065413A CN2010105482233A CN201010548223A CN102065413A CN 102065413 A CN102065413 A CN 102065413A CN 2010105482233 A CN2010105482233 A CN 2010105482233A CN 201010548223 A CN201010548223 A CN 201010548223A CN 102065413 A CN102065413 A CN 102065413A
- 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.)
- Granted
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-start 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 the customization demand of some customizations at some particular network environment in the networking process of reality.Above-mentioned application scenario all needs base station (eNodeB) system to come upgrade database according to specific needs.
In the prior art, mainly be to cover original data base configuration file with new data base configuration file to the database upgrade in the base station.In this manner, the total data in the new data base configuration file (comprising various parameters) all needs the staff (Operate Maintain Center OMC) carries out manual configuration in operation maintenance center.
But in the practical application,, therefore cause the inefficiency of database upgrade, consumed the great amount of manpower resource simultaneously, improved the operation cost of communication network because the data that need the staff manually to import are very many.
Summary of the invention
The purpose of this invention is to provide a kind of database upgrade method and system, base station self-start method and system, can carry out the smooth upgrade of database in conjunction with original data of database in the base station.
For achieving the above object, the invention provides following scheme:
A kind of database upgrade method comprises step:
Reception comprises the new database profile information of new data table;
For each legacy data table in the legacy data storehouse, search whether have the new data table identical in the described new database with its attribute;
If have, then, the data in the described new data table are merged in the described legacy data table according to the preset features of each field in the legacy data table, generate the tables of data after upgrading.
Preferably, the described identical new data table of attribute that whether has in the described new database with the legacy data table in legacy data storehouse of searching comprises:
Be respectively each new data table and each legacy data table in advance and generate sign; Described sign comprises the attribute information of tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge 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 the tables of data;
Generate described sign for each tables of data in the following manner:
Title, length, the type of each field in the tables of data are formed character string by the mode that presets;
Utilize the MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as described sign.
Preferably, also comprise: for each field in described legacy data table and the new data table increases field identification, described field identification is used to represent whether described field needs to adopt the data of described new data table in advance; Described data in the described new data table are merged in the described legacy data table, comprising:
Obtain the field identification of each field in the described legacy data table, adopt the field of the data of described new data table, adopt described new data epiphase to answer the data of field to replace the data of described this field of legacy data table for needs; For the field of the data that do not need to adopt described new data table, keep the data of described this field of legacy data table.
Preferably, adopt the field of the data of described new data table, the described new data epiphase of described employing to answer the data of field also to comprise before replacing the data of described this field of legacy data table for needs:
If the described field of the data of the described new data table of employing that needs meets prerequisite, then,
This field can be held the maximum magnitude of data in the increase legacy data table;
Perhaps,
To reduce this field in the legacy data table and can hold the request of the maximum magnitude of data and send to operation maintenance center, after waiting to receive the affirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in the legacy data table can be held data.
Preferably, also comprise:
Other parameters in the tables of data after adopting the 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 kind of base station self-start method comprises:
Form with broadcast sends the startup request;
The message of the described startup request of response that reception operation maintenance center issues is created connection to described operation maintenance center;
By described connection the 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 also comprise aforementioned each described database upgrade method; And
To described operation maintenance center return data qurush level success message;
Start described base station.
A kind of database upgrade system comprises:
The configuration information receiver module is used to receive the new database profile information that comprises the new data table;
Attribute matching module is used for each legacy data table to the legacy data storehouse, searches whether have the new data table identical with its attribute in the described new database;
Data merge module, are used for the preset features according to each field of legacy data table, and the data in the described new data table that will be identical with described legacy data Table Properties merge in the described legacy data table, generate the tables of data after upgrading.
A kind of base station self-starting system comprises:
Start request sending module, be used for sending the startup request with the form of broadcast;
Connect creation module, be used to receive the message of the described startup request of response that operation maintenance center issues, create to described operation maintenance center and connect;
Software firmware upgrade module is used for by described connection the upgrade software and the firmware of described base station;
The database version information receiving module is used to receive the database version information that described operation maintenance center sends;
The database upgrade judge module is used for according to described database version information judge whether the to upgrade database of described base station;
And aforesaid database upgrade system, be used for when the judged result of database upgrade judge module is upgraded for needs the database of the described base station of upgrading;
The upgrading success message returns module, is used for the return data qurush level success message to described operation maintenance center;
Base station initiated module is used to start described base station.
Adopt method and system of the present invention, in the process of carrying out database upgrade, can be according to the preset features of each field in the legacy data table, data in the described new data table are merged in the described legacy data table, rather than adopt the mode that all covers, realized smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in the tables of data is carried out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficient of database upgrade, has saved human resources, has reduced the operation cost of communication network.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use among the embodiment below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the database upgrade method flow diagram that the embodiment of the invention provides;
Fig. 2 is the base station self-start method flow chart that the embodiment of the invention provides;
Fig. 3 is the database upgrade system schematic that the embodiment of the invention provides;
Fig. 4 is the base station self-starting system schematic diagram that the embodiment of the invention provides.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
Referring to Fig. 1, be the described database upgrade method flow diagram of the embodiment of the invention.As shown in Figure 1, the method comprising the steps of:
S101: receive the new database profile information that comprises the 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 storage in the tables of data is in the field of correspondence.For example have as next bar record in the tables of data of certain " base station frequency " by name: Beijing 1,1500,500.Wherein " Beijing 1 " corresponding field name is " a base station name ", and " 1500 " corresponding field name is " peak frequency ", and " 500 " corresponding field name is " minimum frequency ".
S102:, search whether have the new data table identical in the described new database with its attribute for each legacy data table in the legacy data storehouse;
So-called attribute is identical, can be meant that the new data table is identical with the table name of legacy data table; Can be meant that also two tables have identical field number, and the field name of each field correspondence is identical, also promptly new table is compared with the male cousin, not have field newly-increased or that delete, and the meaning of each field do not change (variation only be concrete data under each field).
For the latter, the attribute of tables of data described in the 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 the text type, and length can be 8 bytes.
S103: according to the preset features of each field in the legacy data table, the data in the described new data table are merged in the 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 in the new data table to replace the data that the legacy data epiphase is answered field.This is because a part of data in the new data base configuration file may be identical with legacy data, for this part data, just can keep the data that the legacy data epiphase is answered field, needn't replace, and also needn't carry out human configuration; Some data (for example neighboring BS relationship parameter), system can dispose automatically according to the actual adjacent area situation of this base station, for this part data, can allow system generate automatically according to actual conditions, does not also need manually to be configured.
Adopt database upgrade method of the present invention, in the process of carrying out database upgrade, can be according to the preset features of each field in the legacy data table, data in the described new data table are merged in the described legacy data table, rather than adopt the mode that all covers, realized smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in the tables of data is carried out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficient of database upgrade, has saved human resources, has reduced the operation cost of communication network.
Concrete, for each legacy data table in the legacy data storehouse, search whether have the new data table identical in the described new database among the step S102 with its attribute, can be in the following ways:
Be respectively each new data table and each legacy data table in advance and generate sign; Described sign comprises the attribute information of tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge 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 the practical application, can judge whether two tables are identical only by comparing the table name of new data table and legacy data table.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, perhaps change has taken place (for example is " 1500 " these data to the implication of some field equally, may in the legacy data table, represent peak frequency, in the new data table, represent minimum frequency).Judge by comparing the table name of new data table and legacy data table whether identical meeting causes the database upgrade mistake to two tables this moment.
Therefore in another embodiment of the present invention, described sign can comprise other attribute information of tables of data, and is concrete, and described attribute information can comprise: the title of each field, length, type in the tables of data.Described sign can generate in the following manner:
Title, length, the type of each field in the tables of data are formed character string by the mode that presets;
Utilize the MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as described sign.
Wherein, the described mode that presets of title, length, the type of each field in each tables of data being formed character string all is identical, can guarantee that like this character string of forming according to the field of same names, length, type is identical.
The MD5 algorithm is a kind of widely used digital digest algorithm.Adopt this algorithm, no matter any type of change has taken place in the attribute information of tables of data, all can cause the digital digest of this tables of data to change.Therefore,, just can represent that these two tables of data have identical field number, and title, length, the type of corresponding each field also is identical in two tables as long as the digital digest of two tables of data that employing MD5 algorithm generates is identical.
Be understood that easily, the attribute information of tables of data described in the present invention also can, only comprise the title and the type of each field in the tables of data, perhaps comprise other attribute of this field.
Among the step S103 according to the preset features of each field in the legacy data table, data in the described new data table are merged in the described legacy data table, the preset features of each field can be original certain attribute of this field, also can be to be certain newly-increased attribute of this field.
Preset features for field is original certain attribute of this field, might as well continue to describe: mention in the previous examples with precedent, the title of some field is " a base station name ", in the 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 " a base station name ", think that then this field is the field that does not need to adopt the data of described new data table, keeps the data of described this field of legacy data table.
Owing in original attribute of each field, not necessarily have one can be used for representing whether this field needs to adopt the data of described new data table, in the another embodiment of the present invention, provide a step for the newly-increased attribute of this field:
Be that each field increases field identification in described legacy data table and the new data table in advance, described field identification is used to represent whether described field needs to adopt the data of described new data table;
Obtain the field identification of each field in the described legacy data table, adopt the field of the data of described new data table, adopt described new data epiphase to answer the data of field to replace the data of described this field of legacy data table for needs; For the field of the data that do not need to adopt described new data table, keep the data of described this field of legacy data table.
Wherein, described field identification promptly is for the newly-increased attribute of this field, can be defined as " template " or " non-template ".The data of this field need adopt described new data epiphase to answer the data of field to replace in " template " expression legacy data table; The data of this field can keep in " non-template " expression legacy data table.
After getting access to described field identification, can judge, if " template " then adopts described new data epiphase to answer the data of field to replace the data of described this field of legacy data table this field identification; If " non-template " then keeps the data of described this field of legacy data table.
For the ease of operating personnel the data in the 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.
After this field is set to described hidden state, on the configuration interface of tables of data, will not show this field; After this field is set to described read states, on the configuration interface of tables of data, can not in this field, import data.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 having avoided may be because the mistake that human configuration causes.
In the practical application, may have this situation: certain field in the new data table, with the respective field in the corresponding legacy data table, both field names, type are all identical, but can hold the maximum magnitude difference of data in two fields.In this case, just need can hold the maximum magnitude of data to this field in the legacy data table and change according to prerequisite.
The maximum magnitude conversion that can hold data to this field in the legacy data table comprises: this field can be held the maximum magnitude of data in the increase legacy data table; Perhaps, reduce the maximum magnitude that this field in the legacy data table can be held data.
Described prerequisite can be: judge that this field in the new data table can hold whether the maximum magnitude of data can hold data greater than this field in the legacy data table maximum magnitude.If then increase the maximum magnitude that this field in the legacy data table can be held data.Accordingly, if the maximum magnitude that this field can be held data in the new data table can hold the maximum magnitude of data less than this field in the legacy data table, then reduce the maximum magnitude that this field in the legacy data table can be held data.
It is pointed out that owing to reduce to cause the data that other length is bigger under this field to store when this field in the legacy data table can be held the maximum magnitude of data.So, reduce this field in the legacy data table and can hold the detailed process of the maximum magnitude of data and comprise:
To reduce this field in the legacy data table and can hold the request of the maximum magnitude of data and send to operation maintenance center, after waiting to receive the affirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in the 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, then send and confirm conversion instruction; Otherwise, this field is not carried out the scope conversion.
Of particular note, adopt when simultaneously of the present invention: " be respectively each new data table and each legacy data table in advance and generate sign; Described sign comprises the attribute information of tables of data; By the sign of more described new data table and the sign of described legacy data table, judge 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 the legacy data table is changed " these two steps; after carrying out the scope conversion; 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 attribute tables of data inequality originally.
Take place for fear of above-mentioned condition, the method for the invention also comprises:
Can carry out the length attribute of the field of scope conversion, represent with unified title.
Can avoid some field like this owing to carried out the scope conversion, and cause the attribute-bit of this tables of data to change.For example: U8 represents not have symbol 8 bit value types, and U16 represents not have symbol 16 bit value types, just can represent the both with NUM, and the attribute-bit that can avoid tables of data has like this carried out the scope conversion because of some field and changed.
Adopt the method for the invention, also comprise: for each legacy data table in the legacy data storehouse, search and whether have in the described new database after the new data table identical with its attribute, if certain legacy data table does not have the new data table identical with this legacy data Table Properties in described new database, then: delete this legacy data table.
Because if certain legacy data table new data table identical not in described new database, then can think this legacy data table upgrading back practical function useless, so with its deletion with this legacy data Table Properties.
In like manner, if certain the new data table in the described new database does not have the legacy data table identical with this new data Table Properties in described legacy data table, then this new data table is written in the described legacy data storehouse.
After executing above-mentioned steps, finished the field that adopts the data of described new data table for needs, adopt described new data epiphase to answer the data of field to replace the data of described this field of legacy data table; For the field of the data that do not need to adopt described new data table, keep the data of described this field of legacy data table.
Wherein for the field of the data that do not need to adopt described new data table, also have two kinds of situations: a kind of is the data that can directly keep this field of legacy data table, and another kind needs system to dispose automatically according to the actual conditions of self.
So database upgrade method of the present invention also comprises:
Other parameters in the tables of data after adopting the self-optimizing technology to described upgrading are carried out additional configurations.
Described self-optimizing technology refers to self-optimizing network (self-optimizing network, correlation technique SON).Just as can be seen, the main function of SON is to be used to reduce unnecessary and the great amount of manpower wasting of resources on the name.
A kind of technology in the self-optimizing technology is: Automatic Neighboring Relation (ANR automatic neighborrelation) technology.Adopt the ANR technology to generate the 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 the Automatic Neighboring Relation ANR technical configuration tables of data.
In the practical application, for other parameters that base station self adopts the self-optimizing technique complementary to dispose, OMC is ignorant.Because OMC when the database to other base stations is configured, may need aforementioned base station self to adopt the parameter of self-optimizing technique complementary configuration, could unify configuration to other base stations according to the parameter of aforementioned base station self additional configurations.So the method for the invention also comprises:
The parameter information of described additional configurations is sent to described operation maintenance center.
After the parameter information of described additional configurations was sent to described operation maintenance center (OMC), 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-start method, as shown in Figure 2, the method comprising the steps of:
S201: the form with broadcast sends the startup request;
Upgrade request and initial configuration information all are to be initiated by base station (eNodeB) end, and give basic parameter configuration by the 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, create connection to described operation maintenance center;
S203: by described connection the 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: database version information and base station self database version information that the OMC that relatively receives sends, if both versions are identical, then do not upgrade; If self version is compared comparatively legacy version (for example the version sequence number is less) with the version that OMC sends, then 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 of the present invention self-start method, can realize that on the one hand the base station connects with OMC automatically, 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, be the described database upgrade system construction drawing of the embodiment of the invention.As shown in Figure 3, this system comprises:
Configuration information receiver module 301 is used to receive the new database profile information that comprises the 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 storage in the tables of data is in the field of correspondence.
So-called attribute is identical, can be meant that the new data table is identical with the table name of legacy data table; Can be meant that also two tables have identical field number, and the field name of each field correspondence is identical, also promptly new table is compared with the male cousin, not have field newly-increased or that delete, and the meaning of each field do not change (variation only be 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, are used for the preset features according to each field of legacy data table, and the data in the described new data table that will be identical with described legacy data Table Properties merge in the 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 in the new data table to replace the data that the legacy data epiphase is answered field.This is because a part of data in the new data base configuration file may be identical with legacy data, for this part data, just can keep the data that the legacy data epiphase is answered field, needn't replace, and also needn't carry out human configuration; Some data (for example neighboring BS relationship parameter), system can dispose automatically according to the actual adjacent area situation of this base station, for this part data, can allow system generate automatically according to actual conditions, does not also need manually to be configured.
Adopt database upgrade of the present invention system, in the process of carrying out database upgrade, can be according to the preset features of each field in the legacy data table, data in the described new data table are merged in the described legacy data table, rather than adopt the mode that all covers, realized smooth upgrade to database.Therefore, the staff of OMC only needs the partial data in the tables of data is carried out manual configuration, thereby has saved the process of a large amount of artificial inputs, and then has improved the efficient of database upgrade, has saved human resources, has reduced the operation cost of communication network.
In the practical application, database upgrade of the present invention system can also comprise:
Tables of data sign generation module is used to be respectively each new data table and each legacy data table and generates sign; Described sign comprises the attribute information of tables of data;
Accordingly, described attribute matching module 302 comprises:
Tables of data sign comparing unit is used for by the sign of more described new data table and the sign of described legacy data table, judges 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:
Title, length, the type of each field in the tables of data are formed character string by the mode that presets;
Utilize the MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as described sign.
Wherein, the described mode that presets of title, length, the type of each field in each tables of data being formed character string all is identical, can guarantee that like this character string of forming according to the field of same names, length, type is identical.
Be understood that easily, the attribute information of tables of data described in the present invention also can, only comprise the title and the type of each field in the tables of data, perhaps comprise other attribute of this field.
In the practical application, database upgrade of the present invention system can also comprise:
The field identification generation module is used to each field increase field identification in described legacy data table and the new data table, and described field identification is used to represent whether described field needs to adopt the data of described new data table;
Accordingly, described data merging module 303 comprises:
The field identification recognition unit is used 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 are replaced the unit, are used for adopting for needs the field of the data of described new data table, adopt described new data epiphase to answer the data of field to replace the data of described this field of legacy data table.
Wherein, the described field identification that the field identification generation module generates promptly is for the newly-increased attribute of this field, can be defined as " template " or " non-template ".The data of this field need adopt described new data epiphase to answer the data of field to replace in " template " expression legacy data table; The data of this field can keep in " non-template " expression legacy data table.
After the field identification recognition unit gets access to described field identification, can judge, if " template " then adopts described new data epiphase to answer the data of field to replace the data of described this field of legacy data table this field identification; If " non-template " then keeps the data of described this field of legacy data table.
For the ease of operating personnel the data in the new data table are configured, in the database upgrade of the present invention system, described field identification generation module also comprises:
Field status is provided with the unit, is used for the configuration interface at the 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 the practical application, may have this situation: certain field in the new data table, with the respective field in the corresponding legacy data table, both field names, type are all identical, but can hold the maximum magnitude difference of data in two fields.In this case, just need can hold the maximum magnitude of data to this field in the legacy data table and change according to prerequisite.
Accordingly, in the database upgrade of the present invention system described data merge module 303 and also comprise:
The scope converting unit is used to judge described needs adopt the field of the data of described new data table whether to meet prerequisite, can hold the maximum magnitude of data to this field in the qualified legacy data table and change.
The maximum magnitude conversion that can hold data to this field in the legacy data table comprises: this field can be held the maximum magnitude of data in the increase legacy data table; Perhaps, reduce the maximum magnitude that this field in the legacy data table can be held data.
Accordingly, described scope converting unit comprises:
Scope increases subelement, is used for increasing the maximum magnitude that this field of legacy data table can be held data;
Scope reduces subelement, being used for reducing this field of legacy data table can hold the request of the maximum magnitude of data and send to operation maintenance center, after waiting to receive the affirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in the legacy data table can be held data.
Corresponding to database upgrade method of the present invention, database upgrade of the present invention system can also comprise:
The tables of data removing module is used 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 be not the new data table identical with this legacy data Table Properties, then deletes this legacy data table.
The tables of data writing module, be used for judging certain new data table of described new database, in described legacy data table, whether have the legacy data table identical with this new data Table Properties, if the legacy data table identical with this new data Table Properties then is not written to this new data table in the described legacy data storehouse.
The additional configurations module, other parameters of the tables of data after being used for adopting the self-optimizing technology to described upgrading are carried out additional configurations.
Wherein, the additional configurations module can comprise: the neighboring BS relationship dispensing unit is used for adopting the neighboring BS relationship parameter of Automatic Neighboring Relation ANR technical configuration tables of data.
The additional configurations information sending module is used for the parameter information of described additional configurations is sent to described operation maintenance center.
The invention also discloses a kind of base station self-starting system, as shown in Figure 4, comprising:
Start request sending module 401, be used for sending the startup request with the form of broadcast;
Software firmware upgrade module 403 is used for by described connection the upgrade software and the firmware of described base station;
Database version information receiving module 404 is used to receive the database version information that described operation maintenance center sends;
Database upgrade judge module 405 is used for according to described database version information judge whether the to upgrade database of described base station;
And each described database upgrade system of claim 14 to 24, be used for when the judged result of database upgrade judge module is upgraded for needs the database of the described base station of upgrading;
The upgrading success message returns module 406, is used for the return data qurush level success message to described operation maintenance center;
Base station initiated module 407 is used to start described base station.
Adopt base station of the present invention self-starting system, can realize that on the one hand the base station connects with OMC automatically, owing to having adopted database upgrade of the present invention system, can also realize smooth upgrade on the other hand database.
Each embodiment adopts the mode of going forward one by one to describe in this specification, and what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For the disclosed system of embodiment, because it is corresponding with the embodiment disclosed method, so description is fairly simple, relevant part partly illustrates referring to method and gets final product.
Used specific case herein principle of the present invention and execution mode are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, part in specific embodiments and applications all can change.In sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a database upgrade method is characterized in that, comprises step:
Reception comprises the new database profile information of new data table;
For each legacy data table in the legacy data storehouse, search whether have the new data table identical in the described new database with its attribute;
If have, then, the data in the described new data table are merged in the described legacy data table according to the preset features of each field in the legacy data table, generate the tables of data after upgrading.
2. method according to claim 1 is characterized in that, the described identical new data table of attribute that whether has in the described new database with the legacy data table in legacy data storehouse of searching comprises:
Be respectively each new data table and each legacy data table in advance and generate sign; Described sign comprises the attribute information of tables of data;
By the sign of more described new data table and the sign of described legacy data table, judge 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 the tables of data;
Generate described sign for each tables of data in the following manner:
Title, length, the type of each field in the tables of data are formed character string by the mode that presets;
Utilize the MD5 algorithm, described character string is converted to the digital digest of presetting length, described digital digest is defined as described sign.
4. method according to claim 1 is characterized in that, also comprises: for each field in described legacy data table and the new data table increases field identification, described field identification is used to represent whether described field needs to adopt the data of described new data table in advance; Described data in the described new data table are merged in the described legacy data table, comprising:
Obtain the field identification of each field in the described legacy data table, adopt the field of the data of described new data table, adopt described new data epiphase to answer the data of field to replace the data of described this field of legacy data table for needs; For the field of the data that do not need to adopt described new data table, keep the data of described this field of legacy data table.
5. method according to claim 4 is characterized in that, adopts the field of the data of described new data table, the described new data epiphase of described employing to answer the data of field also to comprise before replacing the data of described this field of legacy data table for needs:
If the described field of the data of the described new data table of employing that needs meets prerequisite, then,
This field can be held the maximum magnitude of data in the increase legacy data table;
Perhaps,
To reduce this field in the legacy data table and can hold the request of the maximum magnitude of data and send to operation maintenance center, after waiting to receive the affirmation conversion instruction of operation maintenance center, reduce the maximum magnitude that this field in the legacy data table can be held data.
6. according to each described method of claim 1 to 5, it is characterized in that, also comprise:
Other parameters in the tables of data after adopting the self-optimizing technology to described upgrading are carried out additional configurations.
7. method according to claim 6 is characterized in that, also comprises:
The parameter information of described additional configurations is sent to described operation maintenance center.
8. a base station self-start method is characterized in that, comprising:
Form with broadcast sends the startup request;
The message of the described startup request of response that reception operation maintenance center issues is created connection to described operation maintenance center;
By described connection the 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 also comprise each described database upgrade method of claim 1 to 7; And
To described operation maintenance center return data qurush level success message;
Start described base station.
9. a database upgrade system is characterized in that, comprising:
The configuration information receiver module is used to receive the new database profile information that comprises the new data table;
Attribute matching module is used for each legacy data table to the legacy data storehouse, searches whether have the new data table identical with its attribute in the described new database;
Data merge module, are used for the preset features according to each field of legacy data table, and the data in the described new data table that will be identical with described legacy data Table Properties merge in the described legacy data table, generate the tables of data after upgrading.
10. a base station self-starting system is characterized in that, comprising:
Start request sending module, be used for sending the startup request with the form of broadcast;
Connect creation module, be used to receive the message of the described startup request of response that operation maintenance center issues, create to described operation maintenance center and connect;
Software firmware upgrade module is used for by described connection the upgrade software and the firmware of described base station;
The database version information receiving module is used to receive the database version information that described operation maintenance center sends;
The database upgrade judge module is used for according to described database version information judge whether the to upgrade database of described base station;
And the described database upgrade of claim 9 system, be used for when the judged result of database upgrade judge module is upgraded for needs the database of the described base station of upgrading;
The upgrading success message returns module, is used for the return data qurush level success message to described operation maintenance center;
Base station initiated module is used to start 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 true CN102065413A (en) | 2011-05-18 |
| CN102065413B 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) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102855305A (en) * | 2012-08-20 | 2013-01-02 | 大唐移动通信设备有限公司 | 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 |
| CN106777025A (en) * | 2016-12-08 | 2017-05-31 | 北京中电普华信息技术有限公司 | A kind of analysis method and system of database physical model |
| CN107368513A (en) * | 2017-04-25 | 2017-11-21 | 阿里巴巴集团控股有限公司 | The method and device of client database renewal |
| CN107679245A (en) * | 2017-10-30 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of organizational structure method of adjustment and device |
| CN108572845A (en) * | 2018-03-15 | 2018-09-25 | 华为技术有限公司 | The upgrade method and related system of distributed micro services cluster |
| CN109559808A (en) * | 2018-11-07 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN109902078A (en) * | 2019-01-10 | 2019-06-18 | 杭州迪普科技股份有限公司 | Database upgrade compatible method, apparatus, equipment and storage medium |
| CN110019111A (en) * | 2017-08-15 | 2019-07-16 | 北京国双科技有限公司 | Data processing method, device, storage medium and processor |
| CN111488340A (en) * | 2019-01-29 | 2020-08-04 | 菜鸟智能物流控股有限公司 | 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 |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102855305A (en) * | 2012-08-20 | 2013-01-02 | 大唐移动通信设备有限公司 | Data upgrading method and device |
| 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 |
| CN106777025A (en) * | 2016-12-08 | 2017-05-31 | 北京中电普华信息技术有限公司 | A kind of analysis method and system of database physical model |
| CN107368513A (en) * | 2017-04-25 | 2017-11-21 | 阿里巴巴集团控股有限公司 | The method and device of client database renewal |
| CN107368513B (en) * | 2017-04-25 | 2020-08-14 | 阿里巴巴集团控股有限公司 | Method and device for updating client database |
| CN110019111A (en) * | 2017-08-15 | 2019-07-16 | 北京国双科技有限公司 | Data processing method, device, storage medium and processor |
| CN107679245A (en) * | 2017-10-30 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of organizational structure method of adjustment and device |
| CN108572845A (en) * | 2018-03-15 | 2018-09-25 | 华为技术有限公司 | The upgrade method and related system of distributed micro services cluster |
| CN109559808A (en) * | 2018-11-07 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, equipment and storage medium |
| CN109902078A (en) * | 2019-01-10 | 2019-06-18 | 杭州迪普科技股份有限公司 | Database upgrade compatible method, apparatus, equipment and storage medium |
| CN111488340A (en) * | 2019-01-29 | 2020-08-04 | 菜鸟智能物流控股有限公司 | Data processing method and device and electronic equipment |
| CN111488340B (en) * | 2019-01-29 | 2023-09-12 | 菜鸟智能物流控股有限公司 | Data processing method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102065413B (en) | 2014-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102065413B (en) | Database updating method and system, and base station self-starting method and system | |
| CN101335722B (en) | Method for implementing same user interface and operation convention on different terminals | |
| CN102799473B (en) | A kind of method and device managing intelligent display device third-party application | |
| CN102724657B (en) | The mobile terminal parameter automatic configuration method of android system and system | |
| CN104104591A (en) | Message pushing method and system | |
| CN102790727B (en) | A kind of method and system of dynamic propelling movement individual subscriber label | |
| CN101552692B (en) | Operating and maintenance system and parameter configuration method of network element device | |
| CN102647701B (en) | A kind of method and device upgrading the application message of mobile terminal | |
| CN104899325A (en) | APP (application) acquired data collection method, terminal, server and system | |
| CN1980144A (en) | Method for quickly configurating large data-quantity network management data | |
| CN102668642A (en) | Network selection mechanisms | |
| CN104168123A (en) | Data push method, data server, client and data push system | |
| CN102546708A (en) | Plug-in obtaining method and system as well as relevant devices | |
| CN101252702A (en) | Mobile terminal, system and control method of unstructured supplementary data traffic | |
| CN106569863B (en) | Resource and code modularization-based android app resource updating and repairing method | |
| CN105100144A (en) | Application updating method and device | |
| CN101390410B (en) | Icon transforming system, and service method for the same | |
| CN101179580B (en) | Method for implementing encoding/decoding of WiMAX system information | |
| CN102761443A (en) | Collocation method and device of command lines | |
| CN102811272A (en) | Updating method, updating apparatus and communication terminal | |
| CN105530269A (en) | Data exchange method, data exchange system and server | |
| CN104298757A (en) | Method and system allowing compatibility with mobile clients and databases different in version | |
| CN101771557A (en) | Method for managing object instance and alias and equipment | |
| CN104063377A (en) | Information processing method and electronic equipment using same | |
| CN100525208C (en) | Data synchronization method |
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 |