CN110019517A - A kind of database middleware Dynamic Configuration, system, equipment, storage medium - Google Patents
A kind of database middleware Dynamic Configuration, system, equipment, storage medium Download PDFInfo
- Publication number
- CN110019517A CN110019517A CN201711120226.5A CN201711120226A CN110019517A CN 110019517 A CN110019517 A CN 110019517A CN 201711120226 A CN201711120226 A CN 201711120226A CN 110019517 A CN110019517 A CN 110019517A
- Authority
- CN
- China
- Prior art keywords
- configuration
- database middleware
- sql command
- command
- preset
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24561—Intermediate data storage techniques for performance improvement
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of database middleware Dynamic Configuration, system, equipment, storage medium.The database middleware Dynamic Configuration, comprising: S1, database middleware receive the sql command for configuration file processing operation that client issues；S2, the sql command is parsed, and thens follow the steps S3 if matching with preset sql command syntactic match；S3, corresponding configuration file is handled according to the processing type parsed.Realize different classes of dynamic configuration operation processing.By online modification configuration mode, modification configuration can be allowed to come into force in time without the service of restarting, operation system can accomplish unaware to the change of database middleware.It supports remote operation, removes modification configuration file without login service device, greatly lowering operation maintenance personnel craft modification file leads to the probability of maloperation, and maximizing reduces O&M cost.
Description
Technical field
The present invention relates to database more particularly to a kind of database middleware Dynamic Configuration, system, equipment, storage
Medium.
Background technique
As use of the MyCAT-X in formal production environment is more and more wider, it is some on O&M to expose MyCAT-X
It is insufficient: in MyCAT-X use process, frequently encounters and need to adjust some parameter options in change window, it can only be by stepping on
Server is recorded, removes modification configuration file in a manual manner, is serviced finally by MyCAT-X is restarted to reach the mesh for updating configuration
's.Manual amendment's configuration, the service of restarting, while operation system cooperation also being needed to change, substantially increase O&M manpower
Cost.
Further, operation system iteration updates, and MyCAT-X, which needs that operation system is cooperated to increase corresponding data fragmentation, to be matched
It sets.
Summary of the invention
In order to solve the above-mentioned technical problem, the purpose of the present invention is to provide a kind of database middleware dynamic configuration sides
Method, system, equipment, storage medium.
According to an aspect of the invention, there is provided a kind of database middleware Dynamic Configuration, comprising the following steps:
S1, database middleware receive the sql command for configuration file processing operation that client issues；
S2, the sql command is parsed, and is thened follow the steps with preset sql command syntactic match if matching
S3；
S3, corresponding configuration file is handled according to the processing type parsed.
Database middleware is MyCAT-X.
MyCAT-X is that one kind closes source distribution formula database middleware, comprising:
Parsing module: sql by the druid parser of mycat-x parse each object in sql sentence (table, arrange, point
Piece field A value)；
Routing module: it is corresponding (using A as algorithm parameter) that the routing module of mycat-x uses the slicing algorithm of definition to calculate
Routing node；
Node judgment module: judging whether routing is multinode, and if being fragment table and sql statement type is
INSERT/UPDATE/DELETE executes distributed formula thing if then the affairs across multiple nodes, that is, distributed transaction switch is opened
Business intercepts, and affairs interrupt identification is arranged, and otherwise then sends rear end for sql and executes, if not, as single node then sends out sql
It is sent to rear end execution；
Rollback judgment module: it according to affairs interrupt identification, determines whether to execute rollback operation；
Administration order module: increase an administration order checktable structure in management port (9066 port)
consistency for[schemaName]；, for detecting the consistency for dividing table (including global table and fragment table) table structure.
And the detailed prompt that inconsistent part will be returned to, client is returned to, related personnel is facilitated to position；
SQL firewall module: the mode based on druid parser included rule and blacklist passes through SQL firewall pair
SQL progress sql into mycat-x parses each object, is judged with druidparser rule, legal,
Sql character is judged whether inside black and white lists, and interception meets rule or the SQL inside blacklist；
Memory management module: using out-pile memory+disk file mode, and ETL is supported to pull mass data ability, entire interior
It deposits region and is divided into two pieces, one piece is stored the complete binary data of all objects, and it is complete that another region is used to store direction
Key (key+pointer) after the serializing of the pointer and fixed length 8byte of binary data.If necessary to the key of serializing
It is an elongated type, such as String can then take its prefix sequence；
H2DB low profile edge database: allowing information in MyCAT-X operational process, writes direct or timed writing
H2DB database is forwarded to H2DB database query engine in this way by 9066 port input inquiry orders (standard sql sentence)
In, finally return result to user.
Further, corresponding configuration file is handled, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
Further, the database middleware Dynamic Configuration, further includes: the original before refreshing is locally configured
File backup is to being locally configured in the warehouse backup.
Further, the database middleware Dynamic Configuration, further includes: local when processing operation mistake
Configuration file is rolled back to former configuration file.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S201, it parses the viewing command issued by client and checks syntactic match with preset；
S202, the metadata configurations for needing to check according to parsing result matching；
S203, encapsulation data to be viewed；
S204, by data feedback to be viewed to client.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Creation/modification order that S211, parsing are issued by client and with preset creation/modification syntactic match；
S212, according to parsing content, check it is to be created/modification configuration it is whether legal, if legal, then backup configuration text
Part；
S213, to be created/covering configuration item to be modified is added for configuration file, if success, by creation/modification
Configuration, which synchronizes, to be appended in database middleware metadata configurations.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Delete command that S221, parsing are issued by client and with preset deletion syntactic match；
S222, according to parsing result, check whether configuration to be deleted legal, if legal, then backed-up config file；
S223, it is deleted for configuration file and needs the configuration item deleted, if success, by the configuration for needing to delete from data
It is cleaned up in the middleware metadata configurations of library.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Backup command that S231, parsing are issued by client and with preset backup syntactic match；
S232, all configuration files of database middleware are stored under backup directory.
Further, include: in the step S232
It configures operating time node finally with configuration file as mark, marks all configuration files.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S241, it parses the rollback order issued by client and is matched with preset rollback command syntax；
S242, according to parsing result, whether judgement needs the time point of rollback legal, if legal, then rollback as needed
Time point, the configuration file before finding corresponding update；
S243, it re-reads the configuration file and updates relevant metadata configurations.
Further, described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S251, it parses the export (swf) command issued by client and is matched with preset derived syntax；
S252, according to parsing result, matching needs derived configuration, if the derived configuration of request is legal, according to configuration
De-parsing is at creation syntax instructions format.
Further, the database middleware Dynamic Configuration, further includes:
If handling successfully corresponding configuration file, feedback result to client；
If or processing failure illegal to corresponding configuration file processing operation, feeds back illegal reason or failure cause
To client.
According to another aspect of the present invention, a kind of database middleware dynamic configuration system is provided, comprising:
Network layer receives the sql command for configuration file processing operation that client issues, and transmits it to SQL
Analytic sheaf；
SQL analytic sheaf parses the sql command, and with preset sql command syntactic match；
Dynamic configuration process layer is handled corresponding configuration file according to the processing type parsed.
Further, corresponding configuration file is handled, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
Further, the database middleware dynamic configuration system, further includes: the original before refreshing is locally configured
File is saved to being locally configured in the warehouse backup.
According to another aspect of the present invention, a kind of equipment is provided, the equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of places
It manages device and executes method as described in any one of the above embodiments.
According to another aspect of the present invention, a kind of computer-readable storage medium for being stored with computer program is provided
Matter, characterized in that the program realizes method as described in any one of the above embodiments when being executed by processor.
Compared with prior art, the invention has the following advantages:
1, the exemplary database middleware Dynamic Configuration of the present invention, database middleware receive the needle that client issues
To the sql command of configuration file processing operation；The sql command is parsed, and with preset sql command syntactic match；
Corresponding configuration file is handled according to the processing type parsed, realizes different classes of dynamic configuration operation processing.
By online modification configuration mode, modification configuration can be allowed to come into force in time without the service of restarting, operation system to database among
The change of part can accomplish unaware.It supports remote operation, removes modification configuration file, greatly attenuating O&M without login service device
Personnel modify file by hand leads to the probability of maloperation, and maximizing reduces O&M cost.
2, the exemplary database middleware Dynamic Configuration of the present invention, support database middleware online modification parameter and
Data fragmentation configuration；Configuration file multi version management provides the backup and rollback function of configuration modification, when allowing configuration to malfunction
It can timely rollback.Support configuration file de-parsing at SQL statement, the operational order of unified each environment；Export function is provided,
Greatly reducing multiple database middlewares is the probability for keeping configuration consistency and configuring error.
3, the exemplary database middleware dynamic configuration system of the present invention receives the needle that client issues by network layer
To the sql command of configuration file processing operation, and transmit it to SQL analytic sheaf；By SQL analytic sheaf, to the sql command
Parsed, and with preset sql command syntactic match；By dynamic configuration process layer, according to the processing type pair parsed
Corresponding configuration file is handled.Said units cooperative cooperating, the common operation processing realized to corresponding configuration file, nothing
Need to the service of restarting can allow modification configuration come into force in time, operation system can accomplish unaware to the change of database middleware.
4, the exemplary equipment of the present invention, realizes different classes of dynamic configuration operation processing.Pass through online modification configuration side
Formula can allow modification configuration to come into force in time without the service of restarting.
5, the exemplary computer readable storage medium for being stored with computer program of the present invention, the program are executed by processor
Shi Shixian method as described in any one of the above embodiments, realizes different classes of dynamic configuration operation processing, maximize reduce O&M at
This, can allow modification configuration to come into force in time, be worthy to be popularized without the service of restarting.
Detailed description of the invention
Fig. 1 is flow chart of the present invention；
Fig. 2 is the architecture diagram of database middleware of the present invention.
Specific embodiment
In order to be better understood by technical solution of the present invention, combined with specific embodiments below, Figure of description is to the present invention
It is described further.
Embodiment one:
As shown in Figure 1, present embodiments providing a kind of database middleware Dynamic Configuration, comprising the following steps:
S1, database middleware receive the sql command for configuration file processing operation that client issues.
It specifically includes:
1) client logs in 9066 port MyCAT-X by MySQL client；
2) sql command of request configuration dynamic change is issued, such as: mycat_config create schema`testdb
`；
3) MyCAT-X receives the order by network layer.
Dynamic configuration function is realized in MyCAT-X, is supported the form issued with sql command, is realized online configuration
Modification.The module belongs to a submodule inside MyCAT-X, and architecture diagram is illustrated in fig. 2 shown below (note that MyCAT-X also includes it
His module, the architecture diagram only show module associated with dynamic configuration module).
S2, the sql command is parsed, and is thened follow the steps with preset sql command syntactic match if matching
S3。
It specifically includes:
SQL analytic sheaf by extension, parsing obtain customized dynamic configuration more sql command.
S3, corresponding configuration file is handled according to the processing type parsed.Wherein, to corresponding configuration file
It is handled, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
The step specifically includes:
1) according to statement type, the SQL that upper figure is issued is needed by " dynamic configuration process layer " module receiving processing
Metadata configurations when MyCAT-X operation are updated simultaneously, while also needing synchronous refresh local profile schema.xml；
2) for this modification operate, can be saved in and be locally configured in the warehouse backup, so as to user find mistake when
The original configuration of rollback is waited, is in simple terms here exactly the rollback function of realizing the configuration of a version.
On this basis, " dynamic configuration process layer " is realized.The SQL type parsed according to SQL resolver, judges SQL
Whether customized SQL syntax is met, if it is satisfied, can be captured and be handled by " dynamic configuration process layer ".
For request dynamic change configure, need to update simultaneously run mode in MyCAT-X (i.e. memory state) metadata and
The configuration file of localization, to ensure that configuration is able to maintain newest after MyCAT-X server resets.In inside, by the two steps
Atomization, it is ensured that the localization configuration file of the configuration of refreshing memory state and refreshing is to maintain consistent always.
Further, it with reference to the theory of Version Control, realizes and Version Control simply is locally configured, for realizing difference
The rollback of version configuration, primarily to can be rolled back to after user has issued the dynamic configuration change of mistake
Originally correctly configuration.Meanwhile with reference to mysqldump tool, the export function for realizing configuration SQL (is equivalent to be previously noted
Be SQL statement by configuration file de-parsing), user can choose to export and these SQL and quote in another MyCAT-X
This part configures SQL, and the configuration for servicing two MyCAT-X is consistent.
The technical solution mainly passes through the extension original SQL resolver of MyCAT-X, realizes customized sql command grammer,
It is changed for realizing different classes of dynamic configuration, the process flow of order is as described below:
1, class command process process is checked
1) instruction that client issues is received；
2) syntactic match is checked with preset, according to the metadata configurations that parsing result matching needs to check, encapsulate to be checked
The data seen；
3) by data feedback to be viewed to client, flow processing terminates.
Wherein, class grammer is checked are as follows:
Mycat_config list schemas: all schema information are listed；
Mycat_config list tables: listing all table information under current schema, cooperates use
[schema], which is ordered, determines schema；
Mycat_config list datanodes: all datanode information are listed；
Mycat_config list datahosts: all datahost information are listed；
Mycat_config list users: all user information are listed；
Mycat_config list rules: all fragment Rule Informations are listed；
Mycat_config list functions: all slicing algorithm information are listed；
Mycat_config list system variables [like'%xxx%']: listing all system variables, can
To use like to carry out matching inquiry；
Mycat_config list sqlwall variables [like'%xxx%']: all sql firewalls are listed
Variable can be used like and carry out matching inquiry；
Mycat_config list mapfiles: all mapfile files are listed；
Mycat_config show mapfile $ { mapfile_name }: the content of specified mapfile is checked；
Mycat_config list backups: all backups are listed.
2, creation/modification class command process process
1) receive the instruction of client sending；
2) check whether the configuration of to be created/modification closes according to parsing content with preset creation/modification syntactic match
3) method then enters if legal, otherwise directly jumps 7)；
3) backed-up config file；
4) the additional to be created/covering configuration item to be modified of configuration file, it is successful then continue 5), unsuccessfully then jump 7)；
5) finally creation/modification configuration is synchronized in the system of being appended to (database middleware) metadata configurations；
6) it creates successfully, feedback result terminates to client, flow processing；
7) creation failure, feeding back unsuccessful reason terminate to client, flow processing.
Wherein, class grammer is created are as follows:
Mycat_config create schema [...]: creation schema；
Mycat_config create table [...]: creation table, including fragment table, global table and common table；
Mycat_config create childtable [...]: creation sublist；
Mycat_config create user [...]: creation user；
Mycat_config create rule [...]: creation fragment rule；
Mycat_config create function [...]: creation slicing algorithm；
Mycat_config create datanode [...]: creation datanode；
Mycat_config create datahost [...]: creation datahost；
Mycat_config create mapfile [...]: creation mapfile.
The modification class grammer are as follows:
Mycat_config alter user [...]: modification user information；
Mycat_config set system variable [...]: setting system variable；
Mycat_config set firewall variable [...]: setting firewall variable.
3, class command process process is deleted
1) instruction that client issues is received；
2) check whether configuration to be deleted is legal, if legal then according to parsing result with preset deletion syntactic match
Into 3)；
3) backed-up config file；
4) configuration file, which is deleted, needs the configuration item deleted, successful then continue 5), unsuccessfully then jumps 7)；
5) finally the configuration deleted will be needed to clean up from system metadata configuration；
6) it deletes successfully, feedback result terminates to client, flow processing；
7) failure is deleted, feeding back unsuccessful reason terminates to client, flow processing.
The deletion class grammer are as follows:
Mycat_config drop schema [schemaName]: specified schema is deleted；
Mycat_config drop table [tableName]: specified table is deleted；
Mycat_config drop user [userName]: specified user is deleted；
Mycat_config drop rule [ruleName]: specified fragment rule is deleted；
Mycat_config drop function [functionName]: specified slicing algorithm is deleted；
Mycat_config drop datanode [datanodeName]: specified datanode is deleted；
Mycat_config drop datahost [datahostName]: specified datahost is deleted；
Mycat_config drop mapfile [mapfileName]: specified mapfile is deleted.
4, backup command process flow
1) receive the instruction of client sending；
2) compressed package of all configuration file uniform packings of system to zip format is protected with preset backup syntactic match
There are under unified backup directory, file designation is avoided repeating, success by the format name of " finally configuration operation "+" time "
Into 3), 4) failure then jumps；
3) it backs up successfully, feedback result terminates to client, flow processing；
4) backup failure, feeding back unsuccessful reason terminate to client, flow processing.
5, rollback command process process
1) receive the instruction of client sending；
2) it is matched with preset rollback command syntax, whether judgement needs the time point of rollback legal, and it is legal, it carries out 3),
Do not conform to rule to jump 5)；
The time point of rollback as needed finds corresponding backup compression zip formatted file, is decompressed, covered original
Configuration file, then system re-reads these configuration files, updates relevant metadata configurations in memory；
3) rollback success, feedback result terminate to client, flow processing；
4) rollback fails, and feeding back unsuccessful reason terminates to client, flow processing.
The backup and rollback order are as follows:
Mycat_config list backups: all backup informations are enumerated；
Mycat_config backup: the backup of configuration information is actively triggered；
Mycat_config rollback to $ { index }: rollback configuration information, by configuration information recovery to some spy
Fixed version.
6, dump (export) command process process
1) receive the instruction of client sending；
2) it is matched with preset dump command syntax；
3) configuration of dump out is needed as a result, matching according to dump command analysis, if the configuration of request dump is legal,
Into 4), otherwise jump 6)；
4) according to configuration de-parsing at creation syntax instructions format；
5) 4) result in is fed back into client, flow processing terminates；
6) dump executes failure, and feeding back unsuccessful reason terminates to client, flow processing.
The dump order are as follows:
Mycat_config dump all [into'$ { file } ']: full dose, which exports, creates sql required for all configurations；
mycat_config dump schemas${schema_list_split_by_comma}[into'$
{ file } ']: it realizes the configuration sql export of library rank, multiple libraries can be exported, use `, ` to separate between multiple library names；
Mycat_config dump all_tables [into'$ { file } ']: the other configuration export of table level, export are realized
The relevant configuration of all table under some schema needs that use order is cooperated to specify schema；
mycat_config dump tables${table_list_split_by_comma}[into'${file}']:
It realizes the other configuration export of table level, multiple tables can be exported, use `, ` to separate between multiple tables, need to cooperate use order specified
schema。
The present embodiment supports MyCAT-X online modification parameter and data fragmentation configuration；
By online modification configuration mode, modification configuration can be allowed to come into force in time without the service of restarting, operation system pair
The change of MyCAT-X can accomplish unaware；
Remote command operation, greatly attenuating operation maintenance personnel modifies file by hand leads to the probability of maloperation, maximizes drop
Low O&M cost；
Configuration file multi version management provides the backup and rollback function of configuration modification, allows configuration can be with when error
Timely rollback；
Support configuration file de-parsing at SQL statement, the operational order of unified each environment；
Dump export function is provided, greatly reducing multiple MyCAT-X is the probability for keeping configuration consistency and configuring error.
Present embodiments provide a kind of database middleware dynamic configuration system, comprising:
Network layer receives the sql command for configuration file processing operation that client issues, and transmits it to SQL
Analytic sheaf；
SQL analytic sheaf parses the sql command, and with preset sql command syntactic match；
Dynamic configuration process layer is handled corresponding configuration file according to the processing type parsed.
Wherein, corresponding configuration file is handled, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
Former local profile before refreshing is saved to being locally configured in the warehouse backup
A kind of equipment is present embodiments provided, the equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of places
It manages device and executes method as described in any one of the above embodiments.
Present embodiments provide a kind of computer readable storage medium for being stored with computer program, characterized in that the journey
Method as described in any one of the above embodiments is realized when sequence is executed by processor.
The computer readable storage medium can be computer-readable included in equipment described in above-described embodiment deposit
Storage media；It is also possible to individualism, without the computer readable storage medium in supplying equipment.Computer readable storage medium
Be stored with one perhaps more than one program described program be used to execute by one or more than one processor.
Embodiment two
The feature that the present embodiment is the same as example 1 repeats no more, and the present embodiment feature different from embodiment one exists
In:
4, backup command process flow
1) receive the instruction of client sending；
2) compressed package of all configuration file uniform packings of system to zip format is protected with preset backup syntactic match
There are under unified backup directory, being successfully entered 3), 4) failure then jumps；
3) it backs up successfully, feedback result terminates to client, flow processing；
4) backup failure, feeding back unsuccessful reason terminate to client, flow processing.
Above description is only the preferred embodiment of the application and the explanation to institute's application technology principle.Those skilled in the art
Member is it should be appreciated that invention scope involved in the application, however it is not limited to technology made of the specific combination of above-mentioned technical characteristic
Scheme, while should also cover in the case where not departing from the inventive concept, it is carried out by above-mentioned technical characteristic or its equivalent feature
Any combination and the other technical solutions formed.Such as features described above has similar function with (but being not limited to) disclosed herein
Energy.
Claims (17)
1. a kind of database middleware Dynamic Configuration, characterized in that the following steps are included:
S1, database middleware receive the sql command for configuration file processing operation that client issues；
S2, the sql command is parsed, and thens follow the steps S3 if matching with preset sql command syntactic match；
S3, corresponding configuration file is handled according to the processing type parsed.
2. database middleware Dynamic Configuration according to claim 1, characterized in that corresponding configuration file into
Row processing, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
3. database middleware Dynamic Configuration according to claim 2, characterized in that further include: before refreshing
Former local profile back up to and be locally configured in the warehouse backup.
4. database middleware Dynamic Configuration according to claim 3, characterized in that further include: work as processing operation
When mistake, local profile is rolled back to former configuration file.
5. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S201, it parses the viewing command issued by client and checks syntactic match with preset；
S202, the metadata configurations for needing to check according to parsing result matching；
S203, encapsulation data to be viewed；
S204, by data feedback to be viewed to client.
6. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Creation/modification order that S211, parsing are issued by client and with preset creation/modification syntactic match；
S212, according to parsing content, check whether the configuration of to be created/modification legal, if legal, then backed-up config file；
S213, to be created/covering configuration item to be modified is added for configuration file, if success, by creation/modification configuration
It synchronizes and is appended in database middleware metadata configurations.
7. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Delete command that S221, parsing are issued by client and with preset deletion syntactic match；
S222, according to parsing result, check whether configuration to be deleted legal, if legal, then backed-up config file；
S223, the configuration item for needing to delete is deleted for configuration file, if success, will need the configuration deleted from database
Between clean up in part metadata configurations.
8. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
Backup command that S231, parsing are issued by client and with preset backup syntactic match；
S232, all configuration files of database middleware are stored under backup directory.
9. database middleware Dynamic Configuration according to claim 8, characterized in that wrapped in the step S232
It includes:
It configures operating time node finally with configuration file as mark, marks all configuration files.
10. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S241, it parses the rollback order issued by client and is matched with preset rollback command syntax；
S242, according to parsing result, whether judgement needs the time point of rollback legal, if legal, then rollback as needed when
Between point, the configuration file before finding corresponding update；
S243, it re-reads the configuration file and updates relevant metadata configurations.
11. database middleware Dynamic Configuration according to claim 1, characterized in that
It is described that the sql command is parsed, and with preset sql command syntactic match, comprising:
S251, it parses the export (swf) command issued by client and is matched with preset derived syntax；
S252, according to parsing result, matching needs derived configuration, if the derived configuration of request is legal, according to the anti-solution of configuration
Analyse into creation syntax instructions format.
12. according to any database middleware Dynamic Configuration of claim 6-11, characterized in that further include:
If handling successfully corresponding configuration file, feedback result to client；
If or processing failure illegal to corresponding configuration file processing operation, feeds back illegal reason or failure cause to visitor
Family end.
13. a kind of database middleware dynamic configuration system, characterized in that include:
Network layer receives the sql command for configuration file processing operation that client issues, and transmits it to SQL parsing
Layer；
SQL analytic sheaf parses the sql command, and with preset sql command syntactic match；
Dynamic configuration process layer is handled corresponding configuration file according to the processing type parsed.
14. database middleware dynamic configuration system according to claim 13, characterized in that
Corresponding configuration file is handled, comprising:
Update the configuration file of database middleware metadata；
Refresh local profile.
15. database middleware dynamic configuration system according to claim 14, characterized in that further include: it will be refreshed
Preceding former local profile is saved to being locally configured in the warehouse backup.
16. a kind of equipment, characterized in that the equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors
Execute such as method of any of claims 1-12.
17. a kind of computer readable storage medium for being stored with computer program, characterized in that when the program is executed by processor
Realize such as method of any of claims 1-12.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711120226.5A CN110019517A (en) | 2017-11-14 | 2017-11-14 | A kind of database middleware Dynamic Configuration, system, equipment, storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711120226.5A CN110019517A (en) | 2017-11-14 | 2017-11-14 | A kind of database middleware Dynamic Configuration, system, equipment, storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110019517A true CN110019517A (en) | 2019-07-16 |
Family
ID=67186495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711120226.5A Pending CN110019517A (en) | 2017-11-14 | 2017-11-14 | A kind of database middleware Dynamic Configuration, system, equipment, storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019517A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110543627A (en) * | 2019-09-10 | 2019-12-06 | 北京搜狐新媒体信息技术有限公司 | Method and system for storing report configuration information |
| CN110750313A (en) * | 2019-10-21 | 2020-02-04 | 北京百度网讯科技有限公司 | Hot loading method and device of middleware, electronic equipment and storage medium |
| CN111104548A (en) * | 2019-12-18 | 2020-05-05 | 腾讯科技（深圳）有限公司 | Data feedback method, system and storage medium |
| CN111241064A (en) * | 2020-01-10 | 2020-06-05 | 深圳震有科技股份有限公司 | Database configuration file processing method and device and storage medium |
| CN111897872A (en) * | 2020-07-03 | 2020-11-06 | 杭州浮云网络科技有限公司 | Large-scale MSSQL management method, system and computer equipment based on service center |
| CN112069239A (en) * | 2020-08-27 | 2020-12-11 | 苏州浪潮智能科技有限公司 | Method, system, device and storage medium for using database based on HTTP request |
| CN112541006A (en) * | 2019-09-23 | 2021-03-23 | 拉扎斯网络科技（上海）有限公司 | Database command request processing method and device, electronic equipment and storage medium |
| CN112860686A (en) * | 2019-11-28 | 2021-05-28 | 中兴通讯股份有限公司 | Data processing method, data processing device, computer equipment and computer readable medium |
| CN113204600A (en) * | 2021-07-05 | 2021-08-03 | 浩鲸云计算科技股份有限公司 | InfluxDB distributed clustering method based on table routing fragmentation engine |
| CN113434228A (en) * | 2021-06-21 | 2021-09-24 | 青岛海尔科技有限公司 | Page request method and device, storage medium and electronic device |
| CN113835786A (en) * | 2021-09-30 | 2021-12-24 | 四川新网银行股份有限公司 | Data docking system, method and computer-readable storage medium |
| CN114025008A (en) * | 2021-09-30 | 2022-02-08 | 苏州浪潮智能科技有限公司 | Method, system, device and storage medium for ND proxy configuration of white box switch |
| CN114237699A (en) * | 2022-02-24 | 2022-03-25 | 四川信用通数字科技股份有限公司 | Configuration script exporting method and device and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050091273A1 (en) * | 2003-10-24 | 2005-04-28 | International Business Machines Corporation | Integrated control and data manager for i2 demand manager |
| CN105159986A (en) * | 2015-08-31 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Optimal configuration method and system of ORACLE database |
| CN105354671A (en) * | 2015-11-06 | 2016-02-24 | 中国南方电网有限责任公司 | Universal configuration management system and enterprise-level information system comprising same |
| CN106325951A (en) * | 2016-08-30 | 2017-01-11 | 广西电网有限责任公司 | Automatic deployment method for application system supporting multiple databases and multiple middleware types |
| CN106372176A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Method for supporting uniform SQL (Structured Query Language) query of embedded document |
| CN106503087A (en) * | 2016-10-12 | 2017-03-15 | 郑州云海信息技术有限公司 | A kind of database middleware for Distributed Data Visits |
| CN106919612A (en) * | 2015-12-25 | 2017-07-04 | 中国移动通信集团浙江有限公司 | A kind of processing method and processing device of SQL script of reaching the standard grade |
-
2017
- 2017-11-14 CN CN201711120226.5A patent/CN110019517A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050091273A1 (en) * | 2003-10-24 | 2005-04-28 | International Business Machines Corporation | Integrated control and data manager for i2 demand manager |
| CN105159986A (en) * | 2015-08-31 | 2015-12-16 | 浪潮(北京)电子信息产业有限公司 | Optimal configuration method and system of ORACLE database |
| CN105354671A (en) * | 2015-11-06 | 2016-02-24 | 中国南方电网有限责任公司 | Universal configuration management system and enterprise-level information system comprising same |
| CN106919612A (en) * | 2015-12-25 | 2017-07-04 | 中国移动通信集团浙江有限公司 | A kind of processing method and processing device of SQL script of reaching the standard grade |
| CN106325951A (en) * | 2016-08-30 | 2017-01-11 | 广西电网有限责任公司 | Automatic deployment method for application system supporting multiple databases and multiple middleware types |
| CN106372176A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Method for supporting uniform SQL (Structured Query Language) query of embedded document |
| CN106503087A (en) * | 2016-10-12 | 2017-03-15 | 郑州云海信息技术有限公司 | A kind of database middleware for Distributed Data Visits |
Non-Patent Citations (1)
| Title |
|---|
| HUIYE: "SQL Server中对XML数据的五种基本你操作", 《新浪博客》 * |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110543627B (en) * | 2019-09-10 | 2023-08-11 | 北京搜狐新媒体信息技术有限公司 | Report configuration information storage method and system |
| CN110543627A (en) * | 2019-09-10 | 2019-12-06 | 北京搜狐新媒体信息技术有限公司 | Method and system for storing report configuration information |
| CN112541006A (en) * | 2019-09-23 | 2021-03-23 | 拉扎斯网络科技（上海）有限公司 | Database command request processing method and device, electronic equipment and storage medium |
| CN110750313A (en) * | 2019-10-21 | 2020-02-04 | 北京百度网讯科技有限公司 | Hot loading method and device of middleware, electronic equipment and storage medium |
| CN110750313B (en) * | 2019-10-21 | 2023-07-25 | 北京百度网讯科技有限公司 | Middleware hot loading method and device, electronic equipment and storage medium |
| CN112860686A (en) * | 2019-11-28 | 2021-05-28 | 中兴通讯股份有限公司 | Data processing method, data processing device, computer equipment and computer readable medium |
| CN112860686B (en) * | 2019-11-28 | 2023-03-10 | 金篆信科有限责任公司 | Data processing method, data processing device, computer equipment and computer readable medium |
| CN111104548B (en) * | 2019-12-18 | 2021-09-14 | 腾讯科技（深圳）有限公司 | Data feedback method, system and storage medium |
| CN111104548A (en) * | 2019-12-18 | 2020-05-05 | 腾讯科技（深圳）有限公司 | Data feedback method, system and storage medium |
| CN111241064B (en) * | 2020-01-10 | 2023-11-03 | 深圳震有科技股份有限公司 | Database configuration file processing method, device and storage medium |
| CN111241064A (en) * | 2020-01-10 | 2020-06-05 | 深圳震有科技股份有限公司 | Database configuration file processing method and device and storage medium |
| CN111897872A (en) * | 2020-07-03 | 2020-11-06 | 杭州浮云网络科技有限公司 | Large-scale MSSQL management method, system and computer equipment based on service center |
| CN112069239B (en) * | 2020-08-27 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Method, system, device and storage medium for using database based on HTTP request |
| CN112069239A (en) * | 2020-08-27 | 2020-12-11 | 苏州浪潮智能科技有限公司 | Method, system, device and storage medium for using database based on HTTP request |
| CN113434228A (en) * | 2021-06-21 | 2021-09-24 | 青岛海尔科技有限公司 | Page request method and device, storage medium and electronic device |
| CN113204600B (en) * | 2021-07-05 | 2021-09-28 | 浩鲸云计算科技股份有限公司 | InfluxDB distributed clustering method based on table routing fragmentation engine |
| CN113204600A (en) * | 2021-07-05 | 2021-08-03 | 浩鲸云计算科技股份有限公司 | InfluxDB distributed clustering method based on table routing fragmentation engine |
| CN114025008A (en) * | 2021-09-30 | 2022-02-08 | 苏州浪潮智能科技有限公司 | Method, system, device and storage medium for ND proxy configuration of white box switch |
| CN113835786B (en) * | 2021-09-30 | 2023-04-28 | 四川新网银行股份有限公司 | Data docking system, method and computer readable storage medium |
| CN114025008B (en) * | 2021-09-30 | 2023-06-02 | 苏州浪潮智能科技有限公司 | White box switch ND proxy configuration method, system, device and storage medium |
| CN113835786A (en) * | 2021-09-30 | 2021-12-24 | 四川新网银行股份有限公司 | Data docking system, method and computer-readable storage medium |
| CN114237699B (en) * | 2022-02-24 | 2022-05-03 | 四川信用通数字科技股份有限公司 | Configuration script exporting method and device and storage medium |
| CN114237699A (en) * | 2022-02-24 | 2022-03-25 | 四川信用通数字科技股份有限公司 | Configuration script exporting method and device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019517A (en) | A kind of database middleware Dynamic Configuration, system, equipment, storage medium | |
| US10754828B2 (en) | Systems and methods for in-place records management and content lifecycle management | |
| US11263268B1 (en) | Recommending query parameters based on the results of automatically generated queries | |
| US20200242135A1 (en) | Recognizing unknown data objects | |
| US11269871B1 (en) | Displaying multiple editable queries in a graphical user interface | |
| US9519700B2 (en) | Automatically synchronizing production data of a source system and a target system | |
| US11216511B1 (en) | Executing a child query based on results of a parent query | |
| US20230031327A1 (en) | Recommending Query Parameters Based on Tenant Information | |
| US10762075B2 (en) | Database interface agent for a tenant-based upgrade system | |
| US10579634B2 (en) | Apparatus and method for operating a distributed database with foreign tables | |
| CA2858680C (en) | Systems and methods for improving database performance | |
| US8745076B2 (en) | Structured query language syntax rewriting | |
| CA2688509C (en) | Distributed system for monitoring information events | |
| KR20200093596A (en) | Resynchronization of metadata in content management system | |
| US8997041B2 (en) | Method of managing script, server performing the same and storage media storing the same | |
| EP3173951B1 (en) | Integrated framework for secured data provisioning and management | |
| US9542467B2 (en) | Efficiently firing mapping and transform rules during bidirectional synchronization | |
| US20210390103A1 (en) | Federated search of heterogeneous data sources | |
| US20170139891A1 (en) | Shared elements for business information documents | |
| US11644955B1 (en) | Assigning a global parameter to queries in a graphical user interface | |
| CN111680041B (en) | Safety high-efficiency access method for heterogeneous data | |
| CN102682035A (en) | Data management method and system | |
| CN112015722A (en) | Database management method, data blood relationship analysis method and related device | |
| Varga et al. | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud | |
| US20040167905A1 (en) | Content management portal and method for managing digital assets |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190716 |
|
| RJ01 | Rejection of invention patent application after publication |