CN110968569B - Database management method, database management device, and storage medium - Google Patents
Database management method, database management device, and storage medium Download PDFInfo
- Publication number
- CN110968569B CN110968569B CN201911322188.0A CN201911322188A CN110968569B CN 110968569 B CN110968569 B CN 110968569B CN 201911322188 A CN201911322188 A CN 201911322188A CN 110968569 B CN110968569 B CN 110968569B
- Authority
- CN
- China
- Prior art keywords
- database
- version
- terminal
- preset requirement
- stored
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000007726 management method Methods 0.000 title claims abstract description 41
- 238000012550 audit Methods 0.000 claims abstract description 12
- 238000000034 method Methods 0.000 claims description 21
- 230000008859 change Effects 0.000 claims description 20
- 230000004044 response Effects 0.000 claims description 11
- 238000012790 confirmation Methods 0.000 claims description 6
- 238000004519 manufacturing process Methods 0.000 description 6
- 238000012360 testing method Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 239000000470 constituent Substances 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
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/21—Design, administration or maintenance of 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
- G06F16/219—Managing data history or versioning
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 invention discloses a database management method, which comprises the following steps: after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database; changing the first database according to the database operation to obtain a second database; and updating the second database to the latest version database. The invention also discloses a database management device and a computer readable storage medium. The invention improves the efficiency of database management.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a database management method, a database management device, and a computer readable storage medium.
Background
In an actual production environment, since the number of databases is huge, the risk of DDL (Data Definition Language ) change is high, and therefore, in order to effectively manage DDL, approval and execution scene flows are generally added to a database management system for production business. However, in the existing database management, there are problems of high approval cost, slow flow and the like, which results in low database management efficiency.
The foregoing is provided merely for the purpose of facilitating understanding of the technical solutions of the present invention and is not intended to represent an admission that the foregoing is prior art.
Disclosure of Invention
The main object of the present invention is to provide a database management method, a database management device, and a computer-readable storage medium, which improve the efficiency of database management.
In order to achieve the above object, the present invention provides a method for managing a database, the method for managing a database comprising the steps of:
after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database;
changing the first database according to the database operation to obtain a second database;
and updating the second database to the latest version database.
Optionally, after the step of changing the first database according to the database operation to obtain the second database, the method further includes:
detecting whether the second database meets preset requirements or not;
and when the second database meets the preset requirement, executing the step of updating the second database into the latest version database.
Optionally, after the step of detecting whether the second database meets the preset requirement, the method further includes:
and when the second database does not meet the preset requirement, restoring the second database into the first database.
Optionally, the step of detecting whether the second database meets a preset requirement includes:
outputting the second database to an associated terminal of a tester so that the tester can detect whether the second database meets the preset requirement or not;
when a confirmation response sent by the association terminal is received, judging that the second database meets preset requirements;
and when a cancellation response sent by the associated terminal is received, judging that the second database does not meet the preset requirement.
Optionally, after the step of detecting whether the second database meets the preset requirement, the method further includes:
when the second database does not meet the preset requirement and when a data definition language data packet sent by the associated terminal is received, updating the second database according to the data definition language data packet to obtain a third database;
and updating the third database to the latest version database.
Optionally, after the step of changing the first database according to the database operation to obtain the second database, the method further includes:
when the database of the latest version is generated, the database of the previous version is stored, and the storage time is recorded;
when a database version change instruction is received, acquiring a database corresponding to the time for which the database version change instruction aims from a stored database;
and updating the acquired database into the latest version database.
Optionally, after the step of changing the first database according to the database operation to obtain the second database, the method further includes:
when the database of the latest version is generated, the database of the previous version is stored;
providing a stored database in a database version selection interface;
and loading the database aimed at by the database selection instruction when the database selection instruction generated based on the database version selection interface is detected.
In order to achieve the above object, the present invention also provides a management apparatus for a database, the management apparatus for a database including:
the database management device comprises a memory, a processor and a database management program stored on the memory and capable of running on the processor, wherein the database management program realizes the steps of the database management method when being executed by the processor.
In order to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a management program of a database, which when executed by a processor, implements the steps of the above-described management method of a database.
The invention provides a database management method, a database management device and a computer readable storage medium, wherein after detecting that the database operation audit initiated based on a data definition language is completed, a database aimed at by the database operation is obtained as a first database; changing the first database according to the database operation to obtain a second database; and updating the second database to the latest version database. In this way, the efficiency of database management is improved.
Drawings
FIG. 1 is a schematic diagram of a hardware operating environment of an embodiment terminal according to an embodiment of the present invention;
FIG. 2 is a flowchart of a first embodiment of a database management method according to the present invention;
FIG. 3 is a flowchart of a second embodiment of a database management method according to the present invention;
fig. 4 is a flowchart of a third embodiment of a database management method according to the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The invention provides a database management method, which improves the efficiency of database management.
As shown in fig. 1, fig. 1 is a schematic diagram of a hardware running environment of an embodiment terminal according to an embodiment of the present invention;
the terminal of the embodiment of the invention can be a management device of a database, and can also be a database management system.
As shown in fig. 1, the terminal may include: a processor 1001, such as a CPU central processing unit (central processing unit), a memory 1002, and a communication bus 1003. The communication bus 1003 is used to implement connection communication between the constituent elements in the terminal. The memory 1002 may be a high-speed RAM Random Access Memory (RAM) or a stable memory (non-volatile memory), such as a disk memory. The memory 1002 may alternatively be a storage device separate from the processor 1001 described above.
It will be appreciated by those skilled in the art that the configuration of the terminal shown in fig. 1 is not limiting of the terminal of the embodiments of the present invention, and may include more or less components than those illustrated, or may combine certain components, or may be arranged in different components.
As shown in fig. 1, a management program of a database may be included in a memory 1002 as a kind of computer storage medium.
In the terminal shown in fig. 1, the processor 1001 may be used to call a management program of a database stored in the memory 1002 and perform the following operations:
after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database;
changing the first database according to the database operation to obtain a second database;
and updating the second database to the latest version database.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
detecting whether the second database meets preset requirements or not;
and when the second database meets the preset requirement, executing the step of updating the second database into the latest version database.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
and when the second database does not meet the preset requirement, restoring the second database into the first database.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
outputting the second database to an associated terminal of a tester so that the tester can detect whether the second database meets the preset requirement or not;
when a confirmation response sent by the association terminal is received, judging that the second database meets preset requirements;
and when a cancellation response sent by the associated terminal is received, judging that the second database does not meet the preset requirement.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
when the second database does not meet the preset requirement and when a data definition language data packet sent by the associated terminal is received, updating the second database according to the data definition language data packet to obtain a third database;
and updating the third database to the latest version database.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
when the database of the latest version is generated, the database of the previous version is stored, and the storage time is recorded;
when a database version change instruction is received, acquiring a database corresponding to the time for which the database version change instruction aims from a stored database;
and updating the acquired database into the latest version database.
Further, the processor 1001 may call a management program of the database stored in the memory 1002, and further perform the following operations:
when the database of the latest version is generated, the database of the previous version is stored;
providing a stored database in a database version selection interface;
and loading the database aimed at by the database selection instruction when the database selection instruction generated based on the database version selection interface is detected.
Referring to fig. 2, in an embodiment, the method for managing a database includes:
and step S10, after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database.
And step S20, changing the first database according to the database operation to obtain a second database.
In this embodiment, the embodiment terminal may be a database management device or a database management system. The following will describe an example of a management device using an embodiment terminal as a database.
The structured query language (Structured Query Language), abbreviated as SQL, is a special purpose programming language, a database query and programming language, for accessing data and querying, updating and managing relational database systems. SQL is a standard language used to perform data manipulation, retrieval and maintenance on relational databases, and can be used to query data, manipulate data, define data, control data, all in the same or similar language. Among them, DDL data definition language (also called database schema definition language) is a component of SQL language, defining a table structure of a database, and the like.
Alternatively, upon submitting the DDL change requirements, a developer of the database may create a corresponding database operation based on the data definition language and submit the created database operation to a corporate manager or DBA database administrator (Database Administrator) for approval. Among other things, DDL change requirements include creating a database, creating a database table, modifying a database table, deleting data table contents, and so forth.
Optionally, an approval terminal of the database manager is associated with the terminal, and when the database manager considers that the database operation is not problematic, a notification of completion of the database operation audit can be sent to the terminal through the approval terminal. And after receiving the notification of the completion of the database operation audit, the terminal judges that the database operation audit is completed. In this way, the approval process of database operations can be expedited.
Optionally, after detecting that the database operation audit initiated based on the data definition language is completed, the terminal acquires all databases aimed at by the database operation as the first database in the database system. And extracting DDL sentences from Schema information of database operation, and performing operations such as adding, deleting and the like on the first database by using the DDL sentences so as to change the first database into the second database. When the database operation aims at a plurality of databases, the terminal searches all databases needing automatic change from the database system to change. Therefore, after the database is operated and audited, the terminal automatically executes DDL sentences without manual intervention.
Therefore, the DDL checked by the production system is automatically executed, the random execution of the DDL which is not in accordance with the specification is avoided, and the need of changing rollback of a pre-generated database (namely a second database) is avoided.
And step S30, updating the second database into the latest version database.
Optionally, the testers of the company or the unit may pre-design the preset requirement of the database according to the use requirement of the company or the unit on the database, and upload the preset requirement to the terminal. The preset requirements define a table format, a table structure, types of undeletable sensitive data, undeletable sensitive data and the like of the database.
Optionally, after the second database is generated, the terminal compares the second database with the preset requirement, checks whether the second database meets the preset requirement, and issues the second database to the database production system when the contents such as the table format and the table structure of the second database meet the preset requirement are checked, so as to update the second database into the latest version database, namely, the second database is used as the database of the practical application.
Optionally, if the terminal detects that the second database does not meet the preset requirement, the terminal may restore the second database to the first database and keep the database of the current version. At this time, the developer needs to walk the process again to resubmit a new DDL change application.
Thus, the efficiency of database management is improved by realizing intelligent audit of database generation.
Optionally, the terminal may also be an association terminal associated with a tester, and after the second database is generated, the terminal sends the second database to the association terminal, so that the tester can detect whether the second database meets the preset requirement. Optionally, when the tester detects that the second database meets the preset requirement, the tester can send a confirmation response of the second database to the terminal through the associated terminal, and after receiving the confirmation response of the second database, the terminal determines that the second database meets the preset requirement and issues the second database to the database production system so as to update the second database into the latest version of database.
Optionally, when the tester detects that the second database does not meet the preset requirement, the tester may send a cancellation response of the second database to the terminal through the associated terminal, and the terminal determines that the second database does not meet the preset requirement when receiving the cancellation response of the second database, restores the second database to the first database, and reserves the database of the current version.
Optionally, when the tester detects that the second database does not meet the preset requirement, the tester may modify DDL sentences corresponding to the database operation, create a data definition language data packet based on the modified DDL sentences, then send the data definition language data packet of the second database to the terminal through the association terminal, after receiving the data definition language data packet, the terminal determines that the second database does not meet the preset requirement, and at the same time, extract DDL sentences in the data definition language data packet, and modify, i.e. cover, modify or delete errors of the second database based on the extracted DDL sentences, so as to modify the second database into the third database. The third database is then released to the database production system to update the third database to the most current version of the database.
Thus, the flow approval cost caused by the separation of the change flow between the pre-generated database and the database of the practical application can be reduced.
Before sending the data definition language data packet (namely the DDL data packet) to the terminal, the associated terminal can submit the auditing node of the data definition language data packet to the testing DBA end for testing and approving by the testing DBA, and sends a confirmation response of the data definition language data packet to the associated terminal after the testing DBA confirms that the data definition language data packet has no problem, and then the associated terminal sends the data definition language data packet to the terminal. Thus, by providing approval control of non-standard DDLs, the overlay test link inevitably experiences DDL modification or rollback scenarios.
In one embodiment, after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database; changing the first database according to the database operation to obtain a second database; and updating the second database to the latest version database. In this way, the efficiency of database management is improved.
In a second embodiment, as shown in fig. 3, on the basis of the embodiment shown in fig. 2, after the step of changing the first database according to the database operation to obtain the second database, the method further includes:
and step S40, when the database of the latest version is generated, the database of the previous version is stored, and the storage time is recorded.
Step S41, when receiving a database version change instruction, acquiring a database with the preservation time corresponding to the time pointed by the database version change instruction from the preserved database.
Step S42, updating the acquired database into the latest version database.
In this embodiment, each time the terminal detects that the database with the latest version is generated, the terminal performs the normalized DDL storage of the database with the last version of the latest version, and records the storage time of the stored database. When the tester considers that the database which is currently applied needs to be restored to the database with the old version currently exists, a database version change instruction can be sent to the terminal through the associated terminal. The method comprises the steps that a set time is set in a database version changing instruction, when the terminal receives the database version changing instruction, the terminal inquires the databases of all the versions stored before the set time, acquires the databases with the latest storage time (namely, the databases with the latest storage time are taken as the databases corresponding to the time aimed by the database version changing instruction in the databases of all the versions), and updates the acquired databases into the databases with the latest version, namely, the currently acquired databases are taken as the databases of practical application.
Therefore, a tester can fall back to the DDL version at the designated time at any time, and the complicated work of manually writing SQL sentences to fall back on the change of the database is reduced.
In a third embodiment, as shown in fig. 4, based on the embodiments of fig. 2 to 3, the step of changing the first database according to the database operation to obtain a second database further includes:
and step S50, when the database of the latest version is generated, the database of the previous version is stored.
Step S51, a stored database is provided in a database version selection interface.
And step S52, loading the database aimed at by the database selection instruction when the database selection instruction generated based on the database version selection interface is detected.
In this embodiment, the terminal performs the normalized DDL save of the database of the last version of the latest version whenever detecting that the database of the latest version is generated.
Optionally, the terminal is provided with a database version selection interface, and the database version selection interface is displayed through a display device in communication with the terminal. The database version selection interface displays all versions of databases stored by the terminal. The user may perform a selection operation of the database (e.g., click on a desired selected database using a cursor) based on the database version selection interface, and the terminal generates a database selection instruction based on the selected database by the selection operation when detecting the selection operation of the user.
Optionally, when the generation of the database selection instruction is detected, the database aimed by the database selection instruction is loaded and is loaded as the database of the current application.
Therefore, the DDL database with the appointed version can be rapidly deployed, and parallel development work of databases with different versions of the same application is better supported.
In addition, the invention also provides a database management device, which comprises a memory, a processor and a database management program stored on the memory and capable of running on the processor, wherein the processor realizes the steps of the database management method according to the embodiment when executing the database management program.
Furthermore, the present invention also proposes a computer-readable storage medium comprising a management program of a database, which when executed by a processor implements the steps of the management method of a database as described in the above embodiments.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of embodiments, it will be clear to a person skilled in the art that the above embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course also by means of hardware, but in many cases the former is an alternative embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a television, a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description of the invention and the accompanying drawings is only illustrative, and is not intended to limit the scope of the invention, but rather is to be construed in any way in view of the following description, the accompanying drawings and the like.
Claims (7)
1. A method of managing a database, the method comprising the steps of:
receiving DDL change requirements, and creating corresponding database operations based on a data definition language, wherein the DDL change requirements comprise creating a database, creating a database table, modifying the database table, deleting the database table and deleting the contents of the database table;
after detecting that the database operation audit initiated based on the data definition language is completed, acquiring a database aimed at by the database operation as a first database;
changing the first database according to the database operation to obtain a second database;
outputting the second database to an associated terminal of a tester so that the tester can detect whether the second database meets a preset requirement, wherein the preset requirement is defined by a table format, a table structure, a type of undeletable sensitive data and undeletable sensitive data of the database;
when a confirmation response sent by the association terminal is received, judging that the second database meets preset requirements;
when a cancellation response sent by the associated terminal is received, judging that the second database does not meet preset requirements;
when the second database does not meet the preset requirement and when a data definition language data packet sent by the associated terminal is received, DDL sentences in the data definition language data packet are extracted, and the second database is changed based on the extracted DDL sentences to obtain a third database;
and updating the third database to the latest version database.
2. The method for managing databases according to claim 1, wherein after the step of detecting whether the second database meets a preset requirement, further comprising:
and when the second database meets the preset requirement, executing the step of updating the second database into the latest version database.
3. The method for managing databases according to claim 2, wherein after the step of detecting whether the second database meets a preset requirement, further comprising:
and when the second database does not meet the preset requirement, restoring the second database into the first database.
4. The method for managing databases according to claim 1 or 2, characterized in that after the step of modifying the first database according to the database operation to obtain a second database, further comprising:
when the database of the latest version is generated, the database of the previous version is stored, and the storage time is recorded;
when a database version change instruction is received, acquiring a database corresponding to the time for which the database version change instruction aims from a stored database;
and updating the acquired database into the latest version database.
5. The method for managing databases according to claim 1 or 2, characterized in that after the step of modifying the first database according to the database operation to obtain a second database, further comprising:
when the database of the latest version is generated, the database of the previous version is stored;
providing a stored database in a database version selection interface;
and loading the database aimed at by the database selection instruction when the database selection instruction generated based on the database version selection interface is detected.
6. A database management device, characterized in that the database management device comprises a memory, a processor and a database management program stored on the memory and executable on the processor, the database management program implementing the steps of the database management method according to any one of claims 1 to 5 when being executed by the processor.
7. A computer-readable storage medium, wherein a management program of a database is stored on the computer-readable storage medium, which when executed by a processor, implements the steps of the method for managing a database according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911322188.0A CN110968569B (en) | 2019-12-19 | 2019-12-19 | Database management method, database management device, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911322188.0A CN110968569B (en) | 2019-12-19 | 2019-12-19 | Database management method, database management device, and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110968569A CN110968569A (en) | 2020-04-07 |
| CN110968569B true CN110968569B (en) | 2023-12-29 |
Family
ID=70035354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911322188.0A Active CN110968569B (en) | 2019-12-19 | 2019-12-19 | Database management method, database management device, and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110968569B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651431B (en) * | 2020-06-09 | 2023-06-27 | 中国雄安集团数字城市科技有限公司 | Database service-oriented management flow standardization method |
| CN115586916A (en) * | 2021-07-06 | 2023-01-10 | 华为云计算技术有限公司 | Version management method and device of database model and related equipment |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102160029A (en) * | 2008-09-19 | 2011-08-17 | 美国索尼电脑娱乐有限责任公司 | Software change management, configuration substitution and remote administration of datacenters |
| CN102193938A (en) * | 2010-03-01 | 2011-09-21 | 深圳市金蝶中间件有限公司 | Method and device for acquiring incremental data |
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN103778133A (en) * | 2012-10-18 | 2014-05-07 | 阿里巴巴集团控股有限公司 | Database object changing method and device |
| CN107797916A (en) * | 2016-11-14 | 2018-03-13 | 平安科技（深圳）有限公司 | DDL sentences checking method and device |
| WO2019056707A1 (en) * | 2017-09-22 | 2019-03-28 | 平安科技（深圳）有限公司 | Method and device for quickly initializing system database and storage medium |
| CN110489436A (en) * | 2019-08-16 | 2019-11-22 | 北京百度网讯科技有限公司 | Variation and platform, computer equipment and readable medium on the line of database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7562357B2 (en) * | 2004-03-08 | 2009-07-14 | Microsoft Corporation | Relational database schema version management |
-
2019
- 2019-12-19 CN CN201911322188.0A patent/CN110968569B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102160029A (en) * | 2008-09-19 | 2011-08-17 | 美国索尼电脑娱乐有限责任公司 | Software change management, configuration substitution and remote administration of datacenters |
| CN102193938A (en) * | 2010-03-01 | 2011-09-21 | 深圳市金蝶中间件有限公司 | Method and device for acquiring incremental data |
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN103778133A (en) * | 2012-10-18 | 2014-05-07 | 阿里巴巴集团控股有限公司 | Database object changing method and device |
| CN107797916A (en) * | 2016-11-14 | 2018-03-13 | 平安科技（深圳）有限公司 | DDL sentences checking method and device |
| WO2019056707A1 (en) * | 2017-09-22 | 2019-03-28 | 平安科技（深圳）有限公司 | Method and device for quickly initializing system database and storage medium |
| CN110489436A (en) * | 2019-08-16 | 2019-11-22 | 北京百度网讯科技有限公司 | Variation and platform, computer equipment and readable medium on the line of database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110968569A (en) | 2020-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3428811B1 (en) | Database interface agent for a tenant-based upgrade system | |
| US8065323B2 (en) | Offline validation of data in a database system for foreign key constraints | |
| US8255899B2 (en) | Techniques for upgrade dependency management | |
| US11188319B2 (en) | Systems and methods for entry point-based code analysis and transformation | |
| US10481884B2 (en) | Systems and methods for dynamically replacing code objects for code pushdown | |
| US9552214B2 (en) | Tool for automated extraction and loading of configuration settings | |
| US9280554B2 (en) | Using confidence values for synchronizing file systems | |
| US8875306B2 (en) | Customization restrictions for multi-layer XML customization | |
| US20190158420A1 (en) | Mainframe migration tools | |
| US20120158795A1 (en) | Entity triggers for materialized view maintenance | |
| US10204125B2 (en) | Method, apparatus, and application platform for updating application object attribute | |
| US20110209042A1 (en) | Information Technology Standard Inventory Utility | |
| CN110941629B (en) | Metadata processing method, apparatus, device and computer readable storage medium | |
| KR20060045965A (en) | Integrating best practices into database design | |
| CN111737140A (en) | Interface automation test method, device, equipment and computer readable storage medium | |
| US11487742B2 (en) | Consistency checks between database systems | |
| CN110968569B (en) | Database management method, database management device, and storage medium | |
| US20140095522A1 (en) | Reference data segmentation from single to multiple tables | |
| US11567808B2 (en) | Dependency handling for configuration transport | |
| CN110674119A (en) | Data processing method, system and computer readable storage medium | |
| JP7246301B2 (en) | Program development support system and program development support method | |
| CN110221952B (en) | Service data processing method and device and service data processing system | |
| CN112862399A (en) | Method, device and equipment for changing material list table and storage medium | |
| US8775873B2 (en) | Data processing apparatus that performs test validation and computer-readable storage medium | |
| US8150821B2 (en) | System and method for using generic utilities to perform database utilities on mainframe operated DB2 databases |
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 |