CN106933888A - Database configuration management system - Google Patents
Database configuration management system Download PDFInfo
- Publication number
- CN106933888A CN106933888A CN201511030215.9A CN201511030215A CN106933888A CN 106933888 A CN106933888 A CN 106933888A CN 201511030215 A CN201511030215 A CN 201511030215A CN 106933888 A CN106933888 A CN 106933888A
- Authority
- CN
- China
- Prior art keywords
- configuration
- modified
- table structure
- information
- database
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present invention provides a kind of database configuration management system, is applied to relevant database, and the database configuration management system includes：Platform and configuration management platform are logged in, logging in platform is used to receive the configuration modification information of user's importing, and to configuration management platform send configuration modification information；Wherein, configuration modification information includes the mark of table structure to be modified and the replacement attribute information of table structure to be modified；Configuration management platform is used to receive the configuration modification information that platform sends that logs in, replacement attribute information in configuration modification information is verified, and when replacement attribute information is proved to be successful, obtain relevant database in table structure to be modified configuration information, in configuration information by the initial attribute information updating of table structure to be modified for replace attribute information.It is used to improve the availability of relevant database.
Description
Technical field
The present embodiments relate to database technical field, more particularly to a kind of database configuration management system.
Background technology
At present, relevant database (such as MySQL database) be using relatively broad database,
In relevant database, by table structure storing data, each table structure correspondence multiple attribute information.
In actual application, multiple portion in a project may be store in a relevant database
The data of door, the attribute information of table structure is repaiied in any one department needs to relevant database
When changing, for example, increasing or deleting the part attribute information in table structure, owner in the project is required to
Member's pause uses the relevant database, and table structure to be modified, root are then searched in relevant database
The attribute information of table structure to be modified is modified according to being actually needed, and to repairing in relevant database
The attribute information of the table structure after changing carries out legitimacy and compatibility verification, if authentication failed, continues
Attribute information to the table structure is modified, until the attribute information of table structure meets legitimacy after modification
And compatibility verification.
However, due to business demand, it may be necessary to frequently to the attribute of table structure in relevant database
Information is modified, or even needs the long period to the modification of the attribute information of table structure so that relationship type
Database can not be used frequently, for a long time, cause the availability of relevant database poor.
The content of the invention
The embodiment of the present invention provides a kind of database configuration management system, is used to improve relevant database
Availability.
The embodiment of the present invention provides a kind of database configuration management system, is applied to relevant database, institute
Relevant database is stated for storing the configuration information of multiple table structures and each table structure, the number
Include according to storehouse configuration management system：Platform and configuration management platform are logged in, wherein,
The login platform, the configuration modification information for receiving user's importing, and to the configuration management
Platform sends the configuration modification information；Wherein, the configuration modification information includes table structure to be modified
The replacement attribute information of mark and table structure to be modified；
The configuration management platform, for receiving the configuration modification information that the login platform sends,
Replacement attribute information in the configuration modification information is verified, and is tested in the replacement attribute information
Demonstrate,prove when successfully, the configuration information of the table structure described to be modified in the relevant database is obtained, in institute
It is the replacement attribute letter to state the initial attribute information updating of the table structure to be modified in configuration information
Breath.
Database configuration management system provided in an embodiment of the present invention, including login platform and configuration management are put down
Platform, wherein, logging in platform is used to receive the configuration modification information of user's importing, and to configuration management platform
Send configuration modification information, configuration modification information includes the mark and table knot to be modified of table structure to be modified
The replacement attribute information of structure；Configuration management platform is used to receive the configuration modification information that platform sends that logs in,
Replacement attribute information in configuration modification information is verified, and when replacement attribute information is proved to be successful,
The configuration information of the table structure to be modified in relevant database is obtained, by table to be modified in configuration information
The initial attribute information updating of structure is replacement attribute information；In above process, when needing to relationship type
When the attribute information of the table structure in database is modified, by the database configuration management system to be repaired
The replacement attribute information for changing table structure is verified and changed, it is not necessary to which pause uses relevant database,
And then improve the availability of relevant database.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to reality
The accompanying drawing to be used needed for example or description of the prior art is applied to be briefly described, it should be apparent that, under
Accompanying drawing in the description of face is some embodiments of the present invention, for those of ordinary skill in the art,
On the premise of not paying creative labor, other accompanying drawings can also be obtained according to these accompanying drawings.
The structural representation one of the database configuration management system that Fig. 1 is provided for the present invention；
The structural representation two of the database configuration management system that Fig. 2 is provided for the present invention.
Specific embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with this hair
Accompanying drawing in bright embodiment, is clearly and completely described to the technical scheme in the embodiment of the present invention,
Obviously, described embodiment is a part of embodiment of the invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained under the premise of creative work is not made
The every other embodiment for obtaining, belongs to the scope of protection of the invention.
Database configuration management system involved by the embodiment of the present invention is applied to relevant database, relation
Type database is used to storing the configuration information of multiple table structures and each table structure, each table structure with confidence
The attribute information of table structure is included in breath, the data in relevant database are believed according to the attribute of table structure
Breath is stored；In embodiments of the present invention, on the premise of not suspending using relevant database, can
The attribute information of table structure in relevant database is modified with by database configuration management system；
The embodiment of the present invention aims to solve the problem that the attribute letter of the table structure in needing to relevant database in the prior art
Breath is when modifying, due to need pause using caused by relevant database relevant database can
With the problem that property is poor.Database configuration management system is described in detail below by specific embodiment.
The structural representation one of the database configuration management system that Fig. 1 is provided for the present invention, refer to Fig. 1,
The database configuration management system can include：Platform 101 and configuration management platform 102 are logged in, wherein,
Platform 101 is logged in, the configuration modification information for receiving user's importing, and to configuration management platform
Send configuration modification information；Wherein, the mark of configuration modification information including table structure to be modified and to be repaired
Change the replacement attribute information of table structure；
Configuration management platform 102, for receiving the configuration modification information that 101 platforms send that logs in, to matching somebody with somebody
The replacement attribute information put in modification information is verified, and when replacement attribute information is proved to be successful, is obtained
The configuration information of the table structure to be modified in relevant database is taken, by table knot to be modified in configuration information
The initial attribute information updating of structure is replacement attribute information.
In embodiments of the present invention, log in platform and be located at client, in order that obtaining the database configuration management
System can be used for multiple users simultaneously, and multiple client can be included in database configuration management system,
And each function phase for logging in platform is together, optionally, the login platform can be realized by Web page, be stepped on
Record platform provides a user with interactive interface, with the information exchange between realization and user；Configuration management platform
Positioned at relevant database end, the configuration management platform can be interacted with relevant database, with reality
Now the attribute information to table structure to be modified in relevant database is modified.
Below as a example by logging in interaction of the platform with configuration management platform, to the database shown in Fig. 1
Configuration management system is described in detail.
In actual application, when user needs the attribute information to the table structure in relevant database
When modifying, enter in client-side and log in platform, and configuration modification information is imported in platform is logged in,
The configuration modification information includes the replacement attribute letter of the mark of table structure to be modified and table structure to be modified
Breath, replacing attribute information is used to replace the current attribute information of table structure to be modified, is received when platform is logged in
To after the configuration modification information of user input, the configuration modification information for receiving is sent to configuration management platform.
After configuration management platform receives the configuration modification information for logging in platform transmission, in order to ensure configuration
The correctness of the replacement attribute information in modification information is, it is necessary to first to the replacement attribute in configuration modification information
Information verified, optionally, legitimacy and compatibility that replace attribute information can be verified,
For example, whether the corresponding data form of property value for judging to replace in attribute information is correct, attribute letter is replaced
Whether indispensable attributes value etc. is lacked in breath；If replacing attribute information to be proved to be successful, believed according to configuration modification
The mark of the table structure to be modified in breath, obtains the configuration information of table structure to be modified in relevant database,
And in configuration information by the initial attribute information updating of table structure to be modified for replace attribute information.
Below, by specific example, the database configuration management system shown in Fig. 1 is described in detail.
Assuming that relevant database includes multiple table structures, it is different that the plurality of table structure is respectively used to storage
The data of user, it is further assumed that user 1 needs to include the initial attribute information of the table structure 1 of user 1
4 property values, respectively " message identification, time, place, total size ".
Be revised as when the property value in the initial attribute information that user 1 is needed table structure 1 " message identification,
During time, place, validity date ", user 1 enters login platform in client, and flat by logging in
Platform imports configuration modification information, and the configuration modification information of importing is：" ' table structure 1 ', ' information mark
Knowledge, time, place, validity date ' ", log in the above-mentioned configuration modification letter that platform receives user's importing
After breath, above-mentioned configuration modification information is sent to configuration management platform.
After configuration management platform receives above-mentioned configuration modification information, to above-mentioned configuration modification information in replace
Change attribute information " message identification, time, place, validity date " to be verified, it is assumed that the replacement belongs to
Property Information Authentication success, then configuration relation platform obtain relevant database in table structure 1 configuration information,
And in the configuration information of table structure 1 by the initial attribute information of table structure 1 " message identification, the time,
Place, total size " is updated to replace attribute information " message identification, time, place, validity date ".
In above process, when user needs to carry out the attribute information of the table structure in relevant database
During modification, user in client-side log database configuration management system, and can import configuration modification letter
Breath, and there is database configuration management system to verify the replacement attribute information in configuration modification information,
And when replacement attribute information is proved to be successful, by the initial category of the table structure to be modified in relevant database
Property information be revised as replace attribute information, due to table structure to be modified replacement attribute information it is authenticated
Journey and modification process are performed by the database configuration management system, therefore, needing to relational data
When the attribute information of the table structure in storehouse is modified, it is not necessary to which pause uses relevant database, and then
Improve the availability of relevant database.
Database configuration management system provided in an embodiment of the present invention, including login platform and configuration management are put down
Platform, wherein, logging in platform is used to receive the configuration modification information of user's importing, and to configuration management platform
Send configuration modification information, configuration modification information includes the mark and table knot to be modified of table structure to be modified
The replacement attribute information of structure；Configuration management platform is used to receive the configuration modification information that platform sends that logs in,
Replacement attribute information in configuration modification information is verified, and when replacement attribute information is proved to be successful,
The configuration information of the table structure to be modified in relevant database is obtained, by table to be modified in configuration information
The initial attribute information updating of structure is replacement attribute information；In above process, when needing to relationship type
When the attribute information of the table structure in database is modified, by the database configuration management system to be repaired
The replacement attribute information for changing table structure is verified and changed, it is not necessary to which pause uses relevant database,
And then improve the availability of relevant database.
On the basis of embodiment illustrated in fig. 1, database configuration management system can also have login authentication
The functions such as function, generation error report, further, the configuration pipe in the database configuration management system
Platform and login platform can be realized by multiple functional units respectively, specifically, refer to Fig. 2
Shown embodiment.
The structural representation two of the database configuration management system that Fig. 2 is provided for the present invention, shown in Fig. 1
On the basis of embodiment, with reference to Fig. 2, respectively to configuration management platform and log in the structure of platform with
And function describes in detail.
For the ease of the understanding to database configuration management system, first in configuration management platform 102
The function of each functional unit in portion's structure and configuration management platform 102 describes in detail.
Configuration management platform 102 includes service management unit 1021, the first receiver module 1022, configuration number
According to storehouse 1023, detection module 1024 and modified module 1025, wherein, the first receiver module 1022,
Detection module 1024 and modified module 1025 are connected respectively at configuration database 1023, detection module
1024 are connected with modified module 1025.
Service management unit 1021, stores user name and the corresponding login password of user name, for connecing
Receive and log in the logging request including user name and login password that platform sends, and in logging request
User name and login password verified, when verifying that user name is matched with login password, receives login
Request, optionally, after logging request is received, the prompt message for logining successfully is sent to login platform；
In actual application, when service management unit receives logging request, but verify user name and step on
When record password is mismatched, login failure prompt message is sent to platform is logged in, point out user name or login
Password bad.
In actual application, the different table knots of different user may be store in relevant database
Structure, each user can only modify to the attribute information of one's own table structure, therefore, can set
The corresponding relation of user name and table structure is put, the user logged in using a user name can only be to the use
The attribute information of the corresponding table structure of name in an account book is modified.For example, the corresponding table structure 1- table knots of user name 1
Structure 3, user name corresponding table structure 5- tables structure 10, then when being logged in using user name 1, can only be to table knot
The attribute information of structure 1- tables structure 3 is modified, when being logged in using user name 2, can only be to table structure 5-
The attribute information of table structure 10 is modified.
First receiver module 1022, for receiving the configuration modification information that platform sends that logs in, and will configuration
Modification information is stored to configuration database.
Detection module 1024, for obtaining configuration modification information in configuration database, and to configuration modification
The legitimacy and/or compatibility of the replacement attribute information in information are verified, it is determined that replacing attribute information
When being proved to be successful, the mark of table structure to be modified is sent to modified module；In actual application, inspection
Surveying module can be entered by following two feasible implementations to the configuration modification information in configuration database
Row checking：
A kind of feasible implementation：
In this kind of feasible implementation, whether detection module is deposited in periodically detecting configuration database
In configuration modification information, when storage configuration modification information in configuration database, then configuration database is obtained
In configuration modification information, and the configuration modification information in configuration database is verified.
Another feasible implementation：
In this kind of feasible implementation, the configuration that the first receiver module receives login platform transmission is repaiied
After converting to breath, by configuration modification information Store to configuration database, and sent to detection module and notified
Information, to cause that detection module, according to announcement information, obtains configuration modification information in configuration database,
And the configuration modification information in configuration database is verified.
In actual use, detection module can be also used for：Lost it is determined that replacing attribute information checking
When losing, generation error report, and send error reporting to platform is logged in；Wherein, can be with error reporting
Including replace attribute information authentication failed the reason for so that user can according to error reporting to replace belong to
Property value carries out further modification.
Modified module 1025, the mark of the table structure to be modified for receiving detection module transmission, according to treating
The mark of table structure is changed, the corresponding replacement of mark that table structure to be modified is obtained in configuration database belongs to
Property information, obtain relevant database in table structure to be modified configuration information, in configuration information will
The initial attribute information updating of table structure to be modified is replacement attribute information.
Optionally, modified module 1025 can include issuance unit 10251 and the corresponding clothes of each table structure
Business node 10252A-10252N, wherein, the service corresponding with each table structure respectively of issuance unit 10251
Node 10252A-10252N connect, issuance unit 10251 respectively with detection module 1024 and configuration
Database 1023 is connected, specifically：
Issuance unit 10251, the mark of the table structure to be modified for receiving detection module transmission, according to
The mark of table structure to be modified, obtains the corresponding replacement of mark of table structure to be modified in configuration database
Attribute information, and according to the mark of table structure to be modified, determine the corresponding clothes of mark of table structure to be modified
Business node, sends to the corresponding service node of the mark of table structure to be modified and replaces attribute information；Further
, issuance unit can be also used for, and is sent in the corresponding service node of mark to table structure to be modified and replaced
Change after attribute information, the configuration information of table structure to be modified is deleted in configuration database.Actually should
The mark of table structure that is stored with during, in issuance unit and the corresponding relation of service node, instantly
After bill unit receives the mark of table structure to be modified, can according to the mark of table structure to be modified, it is determined that
The corresponding service node of mark of table structure to be modified, issuance unit can also be according to table structure to be modified
Mark, obtains the corresponding replacement attribute information of mark of table structure to be modified, under in configuration database
Bill unit determines to obtain the corresponding service node of table structure to be modified and the mark of table structure to be modified is right
After the replacement attribute information answered, sent to the corresponding service node of the mark of table structure to be modified and replace attribute
Information.
Service node 10252, the replacement attribute information for receiving issuance unit transmission, obtains relationship type
The configuration information of the table structure to be modified in database, by the initial of table structure to be modified in configuration information
Attribute information is updated to replace attribute information；In actual application, each table structure has its right
The configuration information answered, includes the attribute information of table structure, in service node in the configuration information of table structure
After receiving the replacement attribute information of issuance unit transmission, the corresponding table knot to be modified of the service node is obtained
The configuration information of structure, and in configuration information by the initial attribute information updating of table structure to be modified for replace
Attribute information.
Further, service node 10252 can be also used for：To the initial attribute letter of table structure to be modified
The attribute type in attribute type and replacement attribute information in breath is compared, and judges table structure to be modified
Initial attribute information in whether there is the corresponding property value of attribute type to be deleted, if so, will then treat
The corresponding data of property value of deletion are set to invalid data.For example, the initial attribute of table structure to be modified
The property value that information includes is respectively：" message identifier, time, place ", if table structure to be modified
Replacement attribute information in property value be respectively：" message identifier, time, size ", then treat this
The attribute type in attribute type and replacement attribute information in the initial attribute information of modification table structure is carried out
Compare, there is property value " place " to be deleted in the initial attribute value for determining table structure to be modified, then
The corresponding data of " place " attribute in the table structure are set to invalid data.
Below, to each function list in the internal structure and login platform 101 that log in platform 101
The function of unit describes in detail.
Log in platform 101 include login module 1011, import modul 1012, sending module 1013 and
Second receiver module 1014, wherein, login module 1011 is connected with service management unit 1021, imports
Module 1012 is connected with sending module 1013, and sending module 1013 is connected with the first receiver module, and second
Receiver module is connected with detection module.
Login module 1011 is with service management unit by network connection, the user for receiving user input
Name and login password, and include the login of user name and login password to the transmission of service management unit 1021
Request, when service management unit 1021 is to user name and login password authentication success, receives to log in and asks
Ask, so that User logs in success.
Import modul 1012, the configuration modification information for receiving user's importing, and sent to sending module
Configuration modification information；Optionally, configuration information can be textual form, or database configuration pipe
The document form that reason system can be recognized.
Sending module 1013, the configuration modification information for receiving the transmission of import modul 1012, and to matching somebody with somebody
Put the send configuration modification information of the first receiver module 1022 in management platform 102.
Second receiver module 1014, wherein, the second receiver module is used to receive the mistake of detection module transmission
Report.In actual application, error reporting is checked for the ease of developer, developer may be used also
Error reporting is derived with from the second receiving unit.
Below, by specific example to logging in the tool of platform and configuration management platform in embodiment illustrated in fig. 2
Body running process is described in detail.
Management for the ease of manager to relevant database and database configuration management system, can be with
The database configuration management system is licensed to its user for trusting, specifically, can be authorized to user
User name and login password, user are only input into the user being mutually matched in the login platform of client
After name and login password, just can be by the database configuration management system to table in relevant database
The property value of structure is modified.
Assuming that user has the user name and login password being authorized to use, then when user is being needed to closing
When being that the property value of table structure in type database is modified, can be defeated in the login unit for logging in platform
Access customer name and login password, log in unit and send bag to the user management module in configuration management platform
Include the logging request of user name and login password, user management module to the user name in logging request with
And login password is verified, if checking user name and login password matching, the login for receiving user please
Ask.
After User logs in success, it is assumed that user needs the attribute in the initial attribute information by table structure 1
Value " name, sex, age, the length of service " is revised as " name, sex, age, educational background ", user
Configuration modification information 1 is imported by import modul, the configuration modification information 1 includes table structure to be modified
Mark (table structure 1) and table structure to be modified replacement attribute information (name, sex, the age,
Educational background), after the configuration modification information 1 that import modul receives user's importing, by configuration modification information
1 sends to sending module, and is sent to configuration management platform configuration modification information 1 by sending module
First receiver module.
After the first receiver module receives configuration modification information 1, configuration modification information 1 is stored to matching somebody with somebody
Database is put, meanwhile, announcement information is sent to detection module, with notifying detection module configuration database
Untreated configuration modification information is increased, detection module then obtains configuration modification letter in configuration database
Breath 1, and to the replacement attribute information " name, sex, age, educational background " in configuration modification information 1
Verified, it is assumed that detection module is proved to be successful to the replacement attribute information, then issuing to modified module
Unit sends the mark (table structure 1) of table structure to be modified.
When issuance unit receives table structure 1, according to the table structure 1, obtained in configuration database
Table structure 1 is corresponding to replace attribute information " name, sex, age, educational background ", and according to table structure
Mark and service node corresponding relation, determine the corresponding service node of table structure 1 be service node
1, then issuance unit by table structure 1 it is corresponding replace attribute information " name, sex, age, educational background "
Send to service node 1.
Service node 1 receive table structure 1 it is corresponding replace attribute information " name, sex, the age,
After educational background ", the corresponding configuration information of table structure 1 in relevant database is obtained, and in configuration information
The initial attribute information " name, sex, age, the length of service " of table structure 1 is replaced with into " name, property
Not, age, educational background ".
In above process, when user needs to carry out the attribute information of the table structure in relevant database
During modification, user in client-side log database configuration management system, and can import configuration modification letter
Breath, and there is database configuration management system to verify the replacement attribute information in configuration modification information,
And when replacement attribute information is proved to be successful, by the initial category of the table structure to be modified in relevant database
Property information be revised as replace attribute information, due to table structure to be modified replacement attribute information it is authenticated
Journey and modification process are performed by the database configuration management system, therefore, needing to relational data
When the attribute information of the table structure in storehouse is modified, it is not necessary to which pause uses relevant database, and then
Improve the availability of relevant database.
One of ordinary skill in the art will appreciate that：Realize all or part of step of above-mentioned each method embodiment
Suddenly can be completed by the related hardware of programmed instruction.Foregoing program can be stored in a computer can
In reading storage medium.The program upon execution, performs the step of including above-mentioned each method embodiment；And
Foregoing storage medium includes：ROM, RAM, magnetic disc or CD etc. are various can be with store program codes
Medium.
Finally it should be noted that：Various embodiments above is merely illustrative of the technical solution of the present invention, rather than right
Its limitation；Although being described in detail to the present invention with reference to foregoing embodiments, this area it is common
Technical staff should be understood：It can still modify to the technical scheme described in foregoing embodiments,
Or equivalent is carried out to which part or all technical characteristic；And these modifications or replacement, and
The scope of the essence disengaging various embodiments of the present invention technical scheme of appropriate technical solution is not made.
Claims (9)
1. a kind of database configuration management system, it is characterised in that be applied to relevant database, it is described
Relevant database is used to store the configuration information of multiple table structures and each table structure, the data
Storehouse configuration management system includes：Platform and configuration management platform are logged in, wherein,
The login platform, the configuration modification information for receiving user's importing, and to the configuration management
Platform sends the configuration modification information；Wherein, the configuration modification information includes table structure to be modified
The replacement attribute information of mark and table structure to be modified；
The configuration management platform, for receiving the configuration modification information that the login platform sends,
Replacement attribute information in the configuration modification information is verified, and is tested in the replacement attribute information
Demonstrate,prove when successfully, the configuration information of the table structure described to be modified in the relevant database is obtained, in institute
It is the replacement attribute letter to state the initial attribute information updating of the table structure to be modified in configuration information
Breath.
2. database configuration management system according to claim 1, it is characterised in that the configuration
Management platform includes the first receiver module, detection module, modified module and configuration database, wherein,
First receiver module, the detection module and the modified module are respectively at the configuration number
Connected according to storehouse, the detection module is connected with the modified module；
First receiver module, for receiving the configuration modification information that the login platform sends,
And by the configuration modification information Store to the configuration database；
The detection module for obtaining the configuration modification information and right in the configuration database
The legitimacy and/or compatibility of the replacement attribute information in the configuration modification information verified, it is determined that
When the replacement attribute information is proved to be successful, the mark of the table structure to be modified is sent to the modified module
Know；
The modified module, the mark for receiving the table structure to be modified that the detection module sends, root
According to the mark of the table structure to be modified, the table structure to be modified is obtained in the configuration database
Corresponding replacement attribute information is identified, the table structure described to be modified in the acquisition relevant database
Configuration information, by the initial attribute information updating of the table structure to be modified is institute in the configuration information
State replacement attribute information.
3. database configuration management system according to claim 2, it is characterised in that the modification
Module includes issuance unit and the corresponding service node of each table structure, wherein,
Issuance unit service node connection corresponding with each table structure, the issuance unit respectively
It is connected with the detection module and the configuration database respectively；
The issuance unit, the mark for receiving the table structure to be modified that the detection module sends, root
According to the mark of the table structure to be modified, the table structure to be modified is obtained in the configuration database
Corresponding replacement attribute information is identified, and according to the mark of the table structure to be modified, is determined described to be repaired
Change the corresponding service node of mark of table structure, to the corresponding service section of the mark of the table structure to be modified
Point sends the replacement attribute information；
The service node, for receiving the replacement attribute information that the issuance unit sends, obtains described
The configuration information of the table structure described to be modified in relevant database, will be described in the configuration information
The initial attribute information updating of table structure to be modified is the replacement attribute information.
4. database configuration management system according to claim 3, it is characterised in that described to issue
Unit is additionally operable to, and sending described replacement in the corresponding service node of mark to the table structure to be modified belongs to
After property information, the configuration information of the table structure to be modified is deleted in the configuration database.
5. the database configuration management system according to claim 3 or 4, it is characterised in that described
Service node is additionally operable to：
To attribute type and the replacement attribute information in the initial attribute information of the table structure to be modified
In attribute type be compared, whether there is in the initial attribute information for judging the table structure to be modified
The corresponding property value of attribute type to be deleted, if so, then by the corresponding number of the property value to be deleted
According to being set to invalid data.
6. the database configuration management system according to claim any one of 2-4, it is characterised in that
The login platform includes import modul and sending module, wherein,
The import modul, the configuration modification information for receiving user's importing, and to the transmission
Module sends the configuration modification information；
The sending module, the configuration modification information for receiving the import modul transmission, and to
First receiver module sends the configuration modification information.
7. the database configuration management system according to claim any one of 2-4, it is characterised in that
The detection module is additionally operable to：
It is determined that during the replacement attribute information authentication failed, generation error report, and to it is described log in it is flat
Platform sends the error reporting.
8. database configuration management system according to claim 6, it is characterised in that the login
Platform also includes the second receiver module, wherein, second receiver module is used to receive the detection module
The error reporting of transmission.
9. the database configuration management system according to claim any one of 1-4, it is characterised in that
The configuration management platform also includes service management unit, and user name is store in the service management unit
And the corresponding login password of the user name；
Accordingly, the login platform also includes login module, the login module and the user management
Unit by network connection, user name and login password for receiving user input, and to the user
Administrative unit sends includes the logging request of the user name and the login password, so that the user
Administrative unit receives the logging request when verifying that the user name is matched with the login password.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511030215.9A CN106933888B (en) | 2015-12-31 | 2015-12-31 | Database configuration management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511030215.9A CN106933888B (en) | 2015-12-31 | 2015-12-31 | Database configuration management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106933888A true CN106933888A (en) | 2017-07-07 |
| CN106933888B CN106933888B (en) | 2020-07-17 |
Family
ID=59444295
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511030215.9A Active CN106933888B (en) | 2015-12-31 | 2015-12-31 | Database configuration management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933888B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112446196A (en) * | 2020-10-23 | 2021-03-05 | 锐捷网络股份有限公司 | File revision method, device and equipment |
| CN112800034A (en) * | 2021-03-23 | 2021-05-14 | 杭州沃趣科技股份有限公司 | Database replacement method, device, medium and equipment based on grammar compatible conversion |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080091707A1 (en) * | 2004-12-10 | 2008-04-17 | Aoki-Rice Companies | Method and medium for managing data |
| US20120150547A1 (en) * | 2010-12-09 | 2012-06-14 | Microsoft Corporation | Integration of crm applications to ecs application user interface |
| CN104376237A (en) * | 2013-08-13 | 2015-02-25 | 中国科学院沈阳自动化研究所 | Safety control method and safety control system for information in production procedures |
| CN104951527A (en) * | 2015-06-12 | 2015-09-30 | 深圳互娱网络科技有限公司 | System and method for rapid configuration of database management background |
-
2015
- 2015-12-31 CN CN201511030215.9A patent/CN106933888B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080091707A1 (en) * | 2004-12-10 | 2008-04-17 | Aoki-Rice Companies | Method and medium for managing data |
| US20120150547A1 (en) * | 2010-12-09 | 2012-06-14 | Microsoft Corporation | Integration of crm applications to ecs application user interface |
| CN104376237A (en) * | 2013-08-13 | 2015-02-25 | 中国科学院沈阳自动化研究所 | Safety control method and safety control system for information in production procedures |
| CN104951527A (en) * | 2015-06-12 | 2015-09-30 | 深圳互娱网络科技有限公司 | System and method for rapid configuration of database management background |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112446196A (en) * | 2020-10-23 | 2021-03-05 | 锐捷网络股份有限公司 | File revision method, device and equipment |
| CN112800034A (en) * | 2021-03-23 | 2021-05-14 | 杭州沃趣科技股份有限公司 | Database replacement method, device, medium and equipment based on grammar compatible conversion |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106933888B (en) | 2020-07-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210049715A1 (en) | Blockchain-based data procesing method, apparatus, and electronic device | |
| CN110782251B (en) | Method for automatically deploying blockchain network based on intelligent contracts | |
| CN109165170B (en) | Method and system for automatic request test | |
| CN104468553A (en) | Method, device and system for login of public account | |
| CN105337925A (en) | User account management method and apparatus | |
| CN106230602B (en) | The integrity detection system and method for the certificate chain of digital certificate | |
| CN112905437B (en) | Method, device and storage medium for testing cases | |
| CN107832602B (en) | Unified electronic seal system based on identification | |
| CN112190951B (en) | Method, device, equipment and storage medium for migrating operation data | |
| CN110088744A (en) | A kind of database maintenance method and its system | |
| CN109165209A (en) | The data verification method, device of object type, equipment and medium in database | |
| CN110324344A (en) | The method and device of account information certification | |
| CN112052033A (en) | Power distribution automation master station version management method and system based on process and block chain | |
| CN115730935A (en) | Data processing method, device and equipment based on block chain and readable storage medium | |
| WO2022206439A1 (en) | Method and apparatus for providing cross-chain message | |
| CN113037505B (en) | Method and system for realizing trusted Web application | |
| CN103440460A (en) | Application system change validation method and system | |
| CN110336813A (en) | A kind of access control method, device, equipment and storage medium | |
| CN109241712A (en) | A kind of method and apparatus for accessing file system | |
| US7962789B2 (en) | Method and apparatus for automated testing of a utility computing system | |
| CN113326500B (en) | Information verification method combining edge computing and cloud edge fusion and central cloud platform | |
| CN106933888A (en) | Database configuration management system | |
| CN113468509B (en) | User authentication migration method, device, equipment and storage medium | |
| CN107295078A (en) | A kind of patch distribution tracking and control system and method | |
| CN115017512A (en) | Unauthorized access vulnerability testing method and device based on block chain |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |