CN111104409A - Database processing method and device, storage medium and electronic equipment - Google Patents
Database processing method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN111104409A CN111104409A CN201911356191.4A CN201911356191A CN111104409A CN 111104409 A CN111104409 A CN 111104409A CN 201911356191 A CN201911356191 A CN 201911356191A CN 111104409 A CN111104409 A CN 111104409A
- Authority
- CN
- China
- Prior art keywords
- database
- data structure
- statement
- configuration file
- table structure
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 21
- 238000000034 method Methods 0.000 claims abstract description 17
- 238000012545 processing Methods 0.000 claims abstract description 16
- 238000012986 modification Methods 0.000 claims abstract description 13
- 230000004048 modification Effects 0.000 claims abstract description 13
- 238000004590 computer program Methods 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database processing method, a database processing device, a storage medium and electronic equipment. The method comprises the following steps: acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database; generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database; and executing the database adjusting statement to adjust the database. In the embodiment, the database is modified based on the database adjusting statement, so that the condition that the database is modified through manual operation in the prior art is replaced, the database adjusting statement can accurately modify the database, the conditions of stroke errors or misoperation and the like in the manual operation do not exist, and the database modification accidents caused by the manual operation are reduced. Meanwhile, the database adjusting statement is high in execution speed, the database modifying efficiency is improved, and the labor cost is reduced.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a database processing method and device, a storage medium and electronic equipment.
Background
The database is a data storage means commonly used in the field of computers, and can store and maintain data in a program development stage and a program application stage.
In the program development stage and the program application stage, the database is often adjusted according to requirements, the adjustment of the database is generally performed by means of testers at present, the situation that slight differences exist between the modification of the database and actual written documents is easy to exist, particularly in the multi-user collaborative development process, when members in a project group update the latest codes through version control software and operate a program, errors of the program operation database are found, the change of the database table is found, the changed documents are searched, or other people in the project group are inquired to obtain the changed contents, SQL sentences are input through a database console by oneself to change the database table structure, and the problem of high communication cost of the database table is caused in the data synchronization process.
Disclosure of Invention
The invention provides a database processing method, a database processing device, a storage medium and electronic equipment, and aims to improve the adjustment precision of a database.
In a first aspect, an embodiment of the present invention provides a database processing method, including:
acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and executing the database adjusting statement to adjust the database.
In a second aspect, an embodiment of the present invention further provides a database processing method, including:
the configuration file acquisition module is used for acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
the adjusting statement generating module is used for generating a database adjusting statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and the database adjusting module is used for executing the database adjusting statement and adjusting the database.
In a third aspect, an embodiment of the present invention further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor, when executing the computer program, implements a database processing method according to any embodiment of the present invention.
In a fourth aspect, embodiments of the present invention further provide a storage medium containing computer-executable instructions, where the computer-executable instructions, when executed by a computer processor, implement a database processing method according to any embodiment of the present invention.
According to the technical scheme provided by the embodiment of the invention, the modification and adjustment of the database are received and stored in the table structure configuration file, the table structure configuration file is compared with the table structure in the database to determine the difference between the table structure configuration file and the table structure in the database, the difference is converted into the database adjustment statement capable of being automatically executed, and the database is modified based on the database adjustment statement, so that the condition that the database is modified through manual operation in the prior art is replaced, the database adjustment statement can accurately modify the database, the conditions of stroke error or misoperation and the like in the manual operation do not exist, and the database modification accidents caused by the manual operation are reduced. Meanwhile, the database adjusting statement is high in execution speed, the database modifying efficiency is improved, and the labor cost is reduced.
Drawings
Fig. 1 is a schematic flowchart of a database processing method according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a database processing apparatus according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device according to a third embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a schematic flowchart of a database processing method according to an embodiment of the present invention, where the present embodiment is applicable to a case where a database is automatically adjusted, and the method may be implemented by a database processing apparatus according to an embodiment of the present invention, where the database processing apparatus may be implemented by software and/or hardware, and the apparatus may be integrated into an electronic device, such as a computer, a server, a mobile phone, and the like. The method specifically comprises the following steps:
s110, obtaining a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in the database.
And S120, generating a database adjusting statement based on the table structure defined by each node in the structure configuration file and the table structure in the database.
And S130, executing the database adjusting statement and adjusting the database.
In this embodiment, a table structure configuration file is set, where the table structure configuration file includes a plurality of nodes, and each node is used to define a table structure. Wherein, it can be a database corresponding to a table structure configuration file. Optionally, the table structure configuration file is an XML (extensible markup language) file, and the XML file is simple and intuitive, and can specify an SQL statement format for generating the table structure and simplify an optimization process of the table structure.
Optionally, when there is an adjustment requirement for the database, the operating user may modify the corresponding node in the table structure configuration file according to the adjustment requirement. When the table structure configuration file is detected to be modified, automatically adjusting the database according to the modified table structure configuration file, or detecting whether the table structure configuration file is modified or not according to fixed interval time, and if so, automatically adjusting the database according to the modified table structure configuration file.
In some embodiments, the table structure configuration file and the database are synchronously uploaded to the server, and under the condition of multi-user cooperation, after other users download the table structure configuration file and the database, the database can be automatically synchronized based on the table structure configuration file, so that the condition that the table structures in the database and the table structure configuration file are inconsistent is avoided, the condition that the database cannot normally run when other users modify the database during multi-user cooperation is reduced, and unnecessary communication cost is reduced.
At the same time of or after the table structure configuration file is acquired, the item database may send a table structure request and receive a table structure fed back by the database according to the table structure request.
Optionally, when the table structure defined in the table structure configuration file and the table structure in the database belong to the same file format, the table structure defined in the table structure configuration file is respectively compared with the table structure in the database to determine the difference between the two, and a database adjusting statement is generated according to the difference. When there is no difference between the two, no modification is required to the database.
When the table structure defined in the table structure configuration file and the table structure in the database are in different file formats, or the file formats of the table structure defined in the table structure configuration file and the table structure in the database are not suitable for data comparison, the table structure defined in the table structure configuration file and the table structure in the database may be converted into a data structure in the same format, and the data structure may be compared to determine the difference.
Optionally, the generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database includes: analyzing each node in the table structure configuration file, and converting the defined table structure into a first data structure in a preset format; acquiring a database corresponding to the table structure configuration file, and converting the table structure in the database into a second data structure in the preset format; generating a database adjustment statement based on a difference of the first data structure and the second data structure.
The preset format may be a file format determined according to user requirements, and is not limited in this embodiment. Optionally, the first data structure includes a table name, a table field, and a table attribute of a table structure defined in the structure configuration file, and the second data structure includes a table name, a table field, and a table attribute of a table structure in the database, where the table attribute may include, but is not limited to, index information, component information, unique identification information, and attribute information such as a type of the table field.
Optionally, generating a database adjustment statement based on a difference between the first data structure and the second data structure, including: comparing the table name, the table field and the table attribute in the first data structure with the table name, the table field and the table attribute in the second data structure one by one to determine the difference between the first data structure and the second data structure; calling a database adjusting statement template according to the difference type; and adding the difference of the first data structure and the second data structure into the database adjustment statement template to generate a database adjustment statement.
The comparison between the first data structure and the second data structure may be, for example, comparing table names in the first data structure and the second data structure, and comparing table fields and table attributes corresponding to the same table names to determine the difference. The electronic equipment stores a database adjusting statement template, and the difference obtained by comparison is added to the database adjusting statement template to obtain the database adjusting statement. It should be noted that, because the types of the difference information are different, a database adjustment statement template corresponding to each type of difference is set in the electronic device. The database adjusting statement template comprises a table structure modifying statement template and a table structure creating statement template.
Optionally, calling a database adjusting statement template according to the difference type, including: calling a table structure to create a statement template when the difference between the first data structure and the second data structure is a table name and a table field and a table attribute corresponding to the table name; invoking a table structure to modify a statement template when a difference in the first data structure and the second data structure is at least one of a table field and a table attribute.
Illustratively, when a new table name exists in the first data structure during the comparison between the table names in the first data structure and the second data structure, indicating that the adjustment requirement for the database is to add the new table structure, the table structure creation statement may be generated by calling the table structure creation statement template, and the table structure creation statement is used to create a new table structure in the database corresponding to the new table name. When the first data structure includes a table field and a table attribute corresponding to the newly added table name, the table structure modification statement template may be further invoked to generate a table structure modification statement, and the table field and the table attribute are added to the newly created table structure.
When there are many table names in the second data structure, it indicates that the adjustment requirement of the database is to delete an existing table structure, and may be to invoke a table structure modification statement template, where the table structure modification statement template may be a deletion template, and is used to delete the table structure corresponding to the difference table name in the database. It should be noted that the table structure modification statement template may include a deletion template, an addition template, and a replacement template.
And when the table names in the first data structure and the second data structure are matched, further comparing the table fields and the table attributes under the same table name, and determining the table fields and/or the table attributes with differences. And calling the corresponding table structure to modify the statement template according to the deletion, replacement or addition of the table fields and/or table attributes in the first data structure relative to the second data structure, and generating the database regulation statement.
Optionally, the difference obtained by comparing the first data structure with the second data structure includes difference information and a difference position, and the difference information and the difference position are added to the database adjustment statement template to generate the data adjustment statement. The data adjustment statement may be an SQL (Structured Query Language) statement.
And correspondingly, sending a database adjusting statement execution request to enable the database to execute the database adjusting statement, adjusting the database and feeding back an execution result.
According to the technical scheme of the embodiment, the modification and adjustment of the database are received and stored in the table structure configuration file, the table structure configuration file is compared with the table structure in the database to determine the difference between the table structure configuration file and the table structure, the difference is converted into the database adjustment statement capable of being automatically executed, and the database is modified based on the database adjustment statement. Meanwhile, the database adjusting statement is high in execution speed, the database modifying efficiency is improved, and the labor cost is reduced.
On the basis of the technical scheme, the method further comprises the following steps: generating database update code based on a difference of the first data structure and the second data structure.
The electronic device may further include a document, where the document includes code information for executing data, and when the database is modified, the code information in the document is modified adaptively, and specifically, the code information may be updated through the database. The database updating code can be generated according to the difference between the first data structure and the second data structure, and the difference between the first data structure and the second data structure is added to the code template to generate the database updating code. Wherein the code template may be corresponding to a difference type.
In this embodiment, a database update code is generated according to a difference between the first data structure and the second data structure, and is used to update the code information of the database, so that the code information of the database is consistent with the table structure in the database, and the business risk caused by inconsistency between the code information and the table structure in the database is reduced. Meanwhile, an operator does not need to manually write the updating code, so that the labor cost is reduced, and the error of manual operation is avoided.
Example two
Fig. 2 is a schematic structural diagram of a database processing apparatus according to a second embodiment of the present invention, where the apparatus includes:
a configuration file obtaining module 210, configured to obtain a table structure configuration file, where each node in the table structure configuration file defines each table structure in a database;
an adjusting statement generating module 220, configured to generate a database adjusting statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
the database adjusting module 230 is configured to execute the database adjusting statement to adjust the database.
Optionally, the adjusting statement generating module 220 includes:
the first data structure generating unit is used for analyzing each node in the table structure configuration file and converting the defined table structure into a first data structure with a preset format;
a second data structure generating unit, configured to acquire a database corresponding to the table structure configuration file, and convert the table structure in the database into a second data structure in the preset format;
and the adjusting statement generating unit is used for generating a database adjusting statement based on the difference between the first data structure and the second data structure.
Optionally, the first data structure and the second data structure include a table name, a table field, and a table attribute.
Optionally, the adjusting statement generating unit is configured to:
comparing the table name, the table field and the table attribute in the first data structure with the table name, the table field and the table attribute in the second data structure one by one to determine the difference between the first data structure and the second data structure;
calling a database adjusting statement template according to the difference type;
and adding the difference of the first data structure and the second data structure into the database adjustment statement template to generate a database adjustment statement.
Optionally, the database adjustment statement template includes a table structure modification statement template and a table structure creation statement template.
Optionally, the adjusting statement generating unit is configured to:
calling a table structure to create a statement template when the difference between the first data structure and the second data structure is a table name and a table field and a table attribute corresponding to the table name;
invoking a table structure to modify a statement template when a difference in the first data structure and the second data structure is at least one of a table field and a table attribute.
Optionally, the apparatus further comprises:
generating database update code based on a difference of the first data structure and the second data structure.
Optionally, the table structure configuration file is an XML file.
The database processing device provided by the embodiment of the invention can execute the database processing method provided by any embodiment of the invention, and has the corresponding functional module and beneficial effect of executing the database processing method.
EXAMPLE III
Fig. 3 is a schematic structural diagram of an electronic device according to a third embodiment of the present invention. FIG. 3 illustrates a block diagram of an exemplary electronic device 12 suitable for use in implementing embodiments of the present invention. The electronic device 12 shown in fig. 3 is only an example and should not bring any limitations to the function and scope of use of the embodiments of the present invention.
As shown in FIG. 3, electronic device 12 is embodied in the form of a general purpose computing device. The components of electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory. The electronic device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 3, and commonly referred to as a "hard drive"). Although not shown in FIG. 3, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 44 having a set of program modules 46 may be stored, for example, in memory 28, such program modules 46 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 46 generally carry out the functions and/or methodologies of the described embodiments of the invention.
The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing a database processing method provided by an embodiment of the present invention, the method including:
acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and executing the database adjusting statement to adjust the database.
The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, to implement a database processing method provided by an embodiment of the present invention.
Of course, those skilled in the art can understand that the processor can also implement the technical solution of the database processing method provided in any embodiment of the present invention.
Example four
The fourth embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a database processing method provided in the fourth embodiment of the present invention, where the method includes:
acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and executing the database adjusting statement to adjust the database.
Of course, the computer program stored on the computer-readable storage medium provided by the embodiment of the present invention is not limited to the above method operations, and may also perform related operations in a database processing method provided by any embodiment of the present invention.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, or device.
A computer readable signal medium may include a video clip, feature encoding of a second video, feature encoding of respective video clips, etc., having computer readable program code embodied therein. Such forms of the broadcast video clip, feature encoding of the second video, feature encoding of each video clip, and the like. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It should be noted that, in the embodiment of the video processing apparatus, the modules included in the embodiment are only divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A database processing method, comprising:
acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and executing the database adjusting statement to adjust the database.
2. The method of claim 1, wherein generating a database adjustment statement based on the table structure defined by each node in the structure configuration file and the table structure in the database comprises:
analyzing each node in the table structure configuration file, and converting the defined table structure into a first data structure in a preset format;
acquiring a database corresponding to the table structure configuration file, and converting the table structure in the database into a second data structure in the preset format;
generating a database adjustment statement based on a difference of the first data structure and the second data structure.
3. The method of claim 2, wherein the first data structure and the second data structure include a table name, a table field, and a table attribute.
4. The method of claim 3, wherein generating a database adjustment statement based on a difference between the first data structure and the second data structure comprises:
comparing the table name, the table field and the table attribute in the first data structure with the table name, the table field and the table attribute in the second data structure one by one to determine the difference between the first data structure and the second data structure;
calling a database adjusting statement template according to the type of the difference;
and adding the difference of the first data structure and the second data structure into the database adjustment statement template to generate a database adjustment statement.
5. The method of claim 4, wherein the database adjustment statement template comprises a table structure modification statement template and a table structure creation statement template;
calling a database adjusting statement template according to the type of the difference, wherein the calling comprises the following steps:
calling a table structure to create a statement template when the difference between the first data structure and the second data structure is a table name and a table field and a table attribute corresponding to the table name;
invoking a table structure to modify a statement template when a difference in the first data structure and the second data structure is at least one of a table field and a table attribute.
6. The method of claim 2, further comprising:
generating database update code based on a difference of the first data structure and the second data structure.
7. The method of claim 1, wherein the table structure configuration file is an XML file.
8. A database processing apparatus, comprising:
the configuration file acquisition module is used for acquiring a table structure configuration file, wherein each node in the table structure configuration file defines each table structure in a database;
the adjusting statement generating module is used for generating a database adjusting statement based on the table structure defined by each node in the structure configuration file and the table structure in the database;
and the database adjusting module is used for executing the database adjusting statement and adjusting the database.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements a database processing method according to any of claims 1-7 when executing the computer program.
10. A storage medium containing computer-executable instructions, which when executed by a computer processor implement the database processing method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911356191.4A CN111104409A (en) | 2019-12-25 | 2019-12-25 | Database processing method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911356191.4A CN111104409A (en) | 2019-12-25 | 2019-12-25 | Database processing method and device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111104409A true CN111104409A (en) | 2020-05-05 |
Family
ID=70424913
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911356191.4A Pending CN111104409A (en) | 2019-12-25 | 2019-12-25 | Database processing method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111104409A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2022242635A1 (en) * | 2021-05-18 | 2022-11-24 | 安翰科技(武汉)股份有限公司 | Management device for sql records for maintenance and application system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719149A (en) * | 2009-12-03 | 2010-06-02 | 联动优势科技有限公司 | Data synchronization method and device |
| CN103778133A (en) * | 2012-10-18 | 2014-05-07 | 阿里巴巴集团控股有限公司 | Database object changing method and device |
| CN103793514A (en) * | 2014-02-11 | 2014-05-14 | 华为技术有限公司 | Database synchronization method and databases |
| CN108037916A (en) * | 2017-11-29 | 2018-05-15 | 福州市智捷信息科技有限公司 | A kind of graphical service modeling method based on web |
| CN108572996A (en) * | 2017-03-14 | 2018-09-25 | 北京京东尚科信息技术有限公司 | Synchronous method, device, electronic equipment and the storage medium of database table structure |
| CN109165258A (en) * | 2018-08-14 | 2019-01-08 | 郑州云海信息技术有限公司 | A kind of method of data synchronization and device |
| US10387385B1 (en) * | 2016-09-29 | 2019-08-20 | Servicenow, Inc. | System and method for batch database modification |
-
2019
- 2019-12-25 CN CN201911356191.4A patent/CN111104409A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719149A (en) * | 2009-12-03 | 2010-06-02 | 联动优势科技有限公司 | Data synchronization method and device |
| CN103778133A (en) * | 2012-10-18 | 2014-05-07 | 阿里巴巴集团控股有限公司 | Database object changing method and device |
| CN103793514A (en) * | 2014-02-11 | 2014-05-14 | 华为技术有限公司 | Database synchronization method and databases |
| US10387385B1 (en) * | 2016-09-29 | 2019-08-20 | Servicenow, Inc. | System and method for batch database modification |
| CN108572996A (en) * | 2017-03-14 | 2018-09-25 | 北京京东尚科信息技术有限公司 | Synchronous method, device, electronic equipment and the storage medium of database table structure |
| CN108037916A (en) * | 2017-11-29 | 2018-05-15 | 福州市智捷信息科技有限公司 | A kind of graphical service modeling method based on web |
| CN109165258A (en) * | 2018-08-14 | 2019-01-08 | 郑州云海信息技术有限公司 | A kind of method of data synchronization and device |
Non-Patent Citations (1)
| Title |
|---|
| 张振友,孙燕: "分布式异构数据库同步技术研究与实现" * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2022242635A1 (en) * | 2021-05-18 | 2022-11-24 | 安翰科技(武汉)股份有限公司 | Management device for sql records for maintenance and application system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7870163B2 (en) | Implementation of backward compatible XML schema evolution in a relational database system | |
| US9563679B2 (en) | Adaptive warehouse data validation tool | |
| CN110019498B (en) | Log synchronization method and device, storage medium and electronic equipment | |
| US20070073770A1 (en) | Methods, systems, and computer program products for resource-to-resource metadata association | |
| US10621388B2 (en) | Automatic delta query support for backend databases | |
| CN106446064B (en) | Data conversion method and device | |
| CN113626223A (en) | Interface calling method and device | |
| CN110889013A (en) | Data association method, device, server and storage medium based on XML | |
| CN110308907B (en) | Data conversion method and device, storage medium and electronic equipment | |
| CN113190517B (en) | Data integration method and device, electronic equipment and computer readable medium | |
| CN110716804A (en) | Method and device for automatically deleting useless resources, storage medium and electronic equipment | |
| US7562099B1 (en) | Graphical user interface for a media management system for communicating quality, source and accessibility information for media data and media objects | |
| CN108694172B (en) | Information output method and device | |
| CN113609128A (en) | Method and device for generating database entity class, terminal equipment and storage medium | |
| CN111104409A (en) | Database processing method and device, storage medium and electronic equipment | |
| CN111104125B (en) | Intelligent integrated version management method, device, medium and electronic equipment | |
| WO2023151397A1 (en) | Application program deployment method and apparatus, device, and medium | |
| CN108196921B (en) | Document development method and device, computer equipment and storage medium | |
| US20050065945A1 (en) | Merging of products into a database | |
| CN113076343B (en) | Data query method, device, equipment and storage medium | |
| US10114864B1 (en) | List element query support and processing | |
| CN112883695B (en) | Method, device, equipment and medium for generating report template and displaying data report | |
| CN108334621B (en) | Database operation method, device, equipment and computer readable storage medium | |
| CN111400396A (en) | Method and device for generating data synchronization script and computer readable storage medium | |
| CN112905164A (en) | Project code processing method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200505 |