CN111367893A - Method and device for database version iteration - Google Patents
Method and device for database version iteration Download PDFInfo
- Publication number
- CN111367893A CN111367893A CN202010245360.3A CN202010245360A CN111367893A CN 111367893 A CN111367893 A CN 111367893A CN 202010245360 A CN202010245360 A CN 202010245360A CN 111367893 A CN111367893 A CN 111367893A
- Authority
- CN
- China
- Prior art keywords
- database
- sql
- updated
- target language
- language
- 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
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/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- 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
-
- 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/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for iteration of database versions, wherein the method comprises the following steps: acquiring database updating information and generating an SQL statement for updating the database; inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types; according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type, the version iteration is carried out on the database of the target language type.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for database version iteration.
Background
This is the case for software systems or systems within an enterprise developed by many enterprises or software development companies: the system uses the same set of core code to implement business logic or product functionality, but uses different databases due to customer differences, operating environment differences, or other constraints, such as: customer A uses an Oracle database, customer B uses a Mysql database, customer C uses a Sqlserver database, etc., and then each customer applies different databases in different deployment environments through different configuration layers.
Aiming at the situation, the problem of unified management and updating of SQL sentences of different databases exists, the prior art manually maintains SQL sentences of various databases, because the programming languages used by the different databases are different, each database needs to manually compile a set of corresponding SQL sentences, when the versions of the databases are iterated, the SQL sentences of various languages need to be manually and synchronously compiled, and after the compiling is finished, whether all scripts are correct or not needs to be checked, so that the workload is high, the requirement on the capability of business personnel is high, errors are easy to occur, and the efficiency and the accuracy of database version iteration are low.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a database version iteration method, which is used for improving the efficiency and the accuracy of database version iteration and comprises the following steps:
acquiring database updating information and generating an SQL statement for updating the database;
inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
and performing version iteration on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type.
The embodiment of the invention provides a database version iteration device, which is used for improving the efficiency and the accuracy of database version iteration and comprises the following components:
the updating statement generating module is used for acquiring the updating information of the database and generating an SQL statement for updating the database;
the target statement generation module is used for inputting the SQL statement updated by the database into the language conversion relational database and outputting the SQL statement updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
and the database version iteration module is used for performing version iteration on the database of the target language type according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the method for iterating the database version when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program for executing the above-described database version iteration method is stored.
The embodiment of the invention comprises the following steps: acquiring database updating information and generating an SQL statement for updating the database; inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types; according to the method and the system, version iteration is carried out on the database of the target language type according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type, and compared with the prior art that the SQL sentences of multiple language types need to be written manually during the database version iteration, the SQL sentences updated by the database can be converted into the SQL sentences of multiple language types based on the language conversion relational database, so that the workload of business personnel is reduced, and the efficiency and the accuracy of the database version iteration are improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 is a schematic diagram of a method flow of database version iteration in an embodiment of the invention;
FIG. 2 is a diagram illustrating a process of establishing a language translation relational database according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating an exemplary architecture of an apparatus for database version iteration according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating another structure of an apparatus for database version iteration according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a computer device structure according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In order to solve the technical problem that in the prior art, when a database version is iterated, SQL statements of multiple language types need to be manually written, so that the database version is lower in iteration efficiency and accuracy, an embodiment of the present invention provides a database version iteration method, so as to improve the database version iteration efficiency and accuracy, fig. 1 is a schematic diagram of a method flow of the database version iteration in the embodiment of the present invention, and as shown in fig. 1, the method includes:
step 101: acquiring database updating information and generating an SQL statement for updating the database;
step 102: inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
step 103: and performing version iteration on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type.
As shown in fig. 1, an embodiment of the present invention is implemented by: acquiring database updating information and generating an SQL statement for updating the database; inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types; according to the method and the system, version iteration is carried out on the database of the target language type according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type, and compared with the prior art that the SQL sentences of multiple language types need to be written manually during the database version iteration, the SQL sentences updated by the database can be converted into the SQL sentences of multiple language types based on the language conversion relational database, so that the workload of business personnel is reduced, and the efficiency and the accuracy of the database version iteration are improved.
In step 101, a user may input database update information through an interactive interface, where the database update information may include: newly creating names and versions of databases, for example, information such as Mysql, Oracle and the like, field information such as names, field types, field lengths, whether fields are empty, default values and the like of the newly created databases, and attribute information such as indexes, constraint conditions, main keys and the like of the newly created databases, and the database update information may also include other information, which is not limited in the present invention.
The user can add new database and database table at any time, also can add or modify the field and attribute information of the table at any time, and can generate the SQL sentence of the corresponding database update according to the database update information input by the user. The interactive interface can be used for a user to check, manage and enter database information, the interactive interface can adopt an interface style of a document style, the convenience and the rapidness are realized, a new page can be established for each database, when a database table is newly established, a form is equivalently added on the page, each row in the form is a field of the database table, and the database updating information input by the user can be printed with a timestamp for storage for inquiring at any time.
Fig. 2 is a schematic diagram of a process of establishing a language translation relational database according to an embodiment of the present invention, as shown in fig. 2, in an embodiment, before inputting an SQL statement updated by a database into the language translation relational database in step 102, the method further includes:
establishing a language conversion relation library according to the following steps;
step 1021: determining the conversion relation among the SQL sentences of the multiple language types for the SQL sentences of the multiple language types;
step 1022: and establishing a language conversion relation library according to the conversion relation among the SQL sentences of the multiple language types.
In specific implementation, in step 1021 and step 1022, the conversion relationship between the SQL statements of multiple language types may be stored in the language conversion relational library, for example, syntax differences such as correspondence, constraints, indexes, and the like between the field type of Mysql and the field type of Oracle and the field type of the universal language may be stored in the language conversion relational library, and loaded into a memory when the system is started, and used for reading when the SQL statements are converted, where the universal language may be a programming language familiar to business personnel. In addition, the language types, such as GP, Sybase and the like, can be dynamically expanded according to the actual requirements of users.
The core function of the language conversion relation library is the corresponding relation and conversion relation between the universal language and the SQL sentences of multiple language types, as shown in table 1, the variable length Text type of the universal language is String, the variable length Text type of Mysql is Varchar, the variable length Text type of Oracle is Varchar2, in table 1, the large String type of the universal language and Mysql is Text, and the large String type of Oracle is Clob.
TABLE 1 correspondence between common language field types and Oracle, Mysql database field types
In specific implementation, in step 102, the SQL statement of the general language type may be input into the language conversion relational database, and the SQL statement updated by the database of the target language type may be output, where the target language type may be specified by a user and may be one or more types. It should be noted that, a Create statement or an enter statement may also be correspondingly generated according to whether the database Table and the field are created at the same time, if the database Table and the field are created at the same time, the Create statement is generated, and if the database Table is created before, and the updating is only to modify or Add the field, an enter Table Add column statement is generated.
In specific implementation, in step 103, version iteration may be performed on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type, for example: business personnel build a database, and there are 10 pieces of database tables in the database, the existing SQL statement of the database can be the SQL statement of the 10 pieces of database tables, because of business requirements, the user adds 2 pieces of database tables, can generate the SQL statement of the newly added 2 pieces of database tables, and can generate the full-base SQL statement containing the complete 12 pieces of database tables, and can perform version iteration of the database according to the SQL statement of the newly added 2 pieces of database tables or the full-base SQL statement of the 12 pieces of database tables based on user requirements, so that in the whole software life cycle, after the user inputs update information each time, the corresponding SQL statement updated by the database or all the SQL statements of the database can be generated, and version iteration of the database is realized.
In one embodiment, the method may further comprise:
according to the SQL statements updated by the database of the target language type and the existing SQL statements of the database of the target language type, deploying the running environment of the software corresponding to the database of the target language type;
the SQL statement for updating the database of the target language type comprises the following steps: creating SQL sentences of the database table and/or modifying SQL sentences of the database table.
In specific implementation, based on user requirements, according to the SQL statements updated by the database or all the SQL statements of the database, the operating environment deployment or performance test can be performed on the software corresponding to the database, so as to implement various software functions.
In one embodiment, the method may further comprise:
storing SQL statements updated by the database of the target language type, and recording a timestamp of the database update of the target language type;
and querying the SQL sentences of the database update or all the SQL sentences of the database of multiple language types corresponding to different timestamps based on different timestamps.
In specific implementation, after the user performs update operations such as addition, modification, deletion, and the like, the SQL statement updated by the database of the target language type may be stored according to the update timestamp, and an update log may be generated, which may include: updating running water, updating operators, updating operation time and other information. Subsequently, the SQL sentences updated by the databases of various language types or all the SQL sentences of the databases corresponding to any timestamp can be inquired based on different timestamps, and the user can derive the SQL sentences updated by the databases of any language types or all the SQL sentences of the databases of any timestamp according to actual requirements for the user to use and deploy at any time, so that the management of the database versions of the database platform in the whole software life cycle process can be realized.
The following is a specific example to facilitate an understanding of how the invention may be practiced.
Firstly, establishing a language conversion relation library according to the conversion relation among SQL sentences of a plurality of language types, and then executing the following steps:
the first step is as follows: a user inputs database updating information through an interactive interface, selects whether to create a new database, and inputs information such as database names, versions and the like if the new database needs to be created; if not, sequentially inputting the names, fields, attributes and other information of the newly built database table; generating an SQL statement for updating the database according to database updating information input by a user;
the second step is that: inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type;
the third step: version iteration can be carried out on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type;
the fourth step: the SQL sentences updated by the database of the target language type are stored according to the updated time stamp, and a user can derive the SQL sentences updated by the database of any language type or all the SQL sentences of the database with any time stamp according to actual requirements, and perform operating environment deployment or performance test on software corresponding to the database.
The implementation of the above specific application is only an example, and the rest of the embodiments are not described in detail.
Based on the same inventive concept, the embodiment of the present invention further provides a device for database version iteration, such as the following embodiments. Because the principle of solving the problems of the device for database version iteration is similar to the method for database version iteration, the implementation of the device can refer to the implementation of the method, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
In order to solve the technical problem that in the prior art, when database versions are iterated, SQL statements of multiple language types need to be manually written, so that the efficiency and accuracy of the database version iteration are low, an embodiment of the present invention provides a database version iteration device, so as to improve the efficiency and accuracy of the database version iteration, fig. 3 is a schematic diagram of a structure of the database version iteration device in the embodiment of the present invention, and as shown in fig. 3, the device includes:
the update statement generation module 01 is used for acquiring database update information and generating an SQL statement for updating the database;
the target statement generation module 02 is used for inputting the SQL statement updated by the database into the language conversion relational database and outputting the SQL statement updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
and the database version iteration module 03 is configured to perform version iteration on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type.
Fig. 4 is a schematic diagram of another structure of an apparatus for database version iteration according to an embodiment of the present invention, as shown in fig. 4, in an embodiment, the apparatus further includes: a storage module 04 for:
storing SQL statements updated by the database of the target language type, and recording a timestamp of the database update of the target language type;
and querying the SQL sentences of the database update or all the SQL sentences of the database of multiple language types corresponding to different timestamps based on different timestamps.
As shown in fig. 4, in one embodiment, the apparatus further comprises: a runtime deployment module 05 to:
according to the SQL statements updated by the database of the target language type and the existing SQL statements of the database of the target language type, performing operating environment deployment on the software corresponding to the database of the target language type;
wherein the SQL statement for updating the database of the target language type comprises: creating SQL sentences of the database table and/or modifying SQL sentences of the database table.
As shown in fig. 4, in one embodiment, the apparatus further comprises: a language conversion relation library establishing module 06 for:
before the SQL sentences updated by the database are input into a language conversion relational database, establishing the language conversion relational database according to the following steps;
determining the conversion relation among the SQL sentences of the multiple language types for the SQL sentences of the multiple language types;
and establishing the language conversion relation library according to the conversion relation among the SQL sentences of the multiple language types.
Fig. 5 is a schematic diagram of a structure of a computer device in an embodiment of the present invention, and as shown in fig. 5, the computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the method for database version iteration when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program for executing the above-described database version iteration method is stored.
In summary, the embodiment of the present invention provides: acquiring database updating information and generating an SQL statement for updating the database; inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types; according to the method and the system, version iteration is carried out on the database of the target language type according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type, and compared with the prior art that the SQL sentences of multiple language types need to be written manually during the database version iteration, the SQL sentences updated by the database can be converted into the SQL sentences of multiple language types based on the language conversion relational database, so that the workload of business personnel is reduced, and the efficiency and the accuracy of the database version iteration are improved.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and variations of the embodiment of the present invention may occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method of database version iteration, comprising:
acquiring database updating information and generating an SQL statement for updating the database;
inputting the SQL sentences updated by the database into a language conversion relational database, and outputting the SQL sentences updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
and performing version iteration on the database of the target language type according to the SQL statement updated by the database of the target language type and the existing SQL statement of the database of the target language type.
2. The method of claim 1, further comprising:
according to the SQL statements updated by the database of the target language type and the existing SQL statements of the database of the target language type, performing operating environment deployment on the software corresponding to the database of the target language type;
wherein the SQL statement for updating the database of the target language type comprises: creating SQL sentences of the database table and/or modifying SQL sentences of the database table.
3. The method of claim 1, further comprising:
storing SQL statements updated by the database of the target language type, and recording a timestamp of the database update of the target language type;
and querying the SQL sentences of the database update or all the SQL sentences of the database of multiple language types corresponding to different timestamps based on different timestamps.
4. The method of claim 1, wherein prior to entering the database-updated SQL statements into a language conversion relational library, the method further comprises:
establishing the language conversion relational database according to the following steps;
determining the conversion relation among the SQL sentences of the multiple language types for the SQL sentences of the multiple language types;
and establishing the language conversion relation library according to the conversion relation among the SQL sentences of the multiple language types.
5. An apparatus for database version iteration, comprising:
the updating statement generating module is used for acquiring the updating information of the database and generating an SQL statement for updating the database;
the target statement generation module is used for inputting the SQL statement updated by the database into the language conversion relational database and outputting the SQL statement updated by the database of the target language type; the language conversion relation library is established according to conversion relations among SQL sentences of multiple language types;
and the database version iteration module is used for performing version iteration on the database of the target language type according to the SQL sentences updated by the database of the target language type and the existing SQL sentences of the database of the target language type.
6. The apparatus of claim 5, further comprising: a runtime deployment module to:
according to the SQL statements updated by the database of the target language type and the existing SQL statements of the database of the target language type, performing operating environment deployment on the software corresponding to the database of the target language type;
wherein the SQL statement for updating the database of the target language type comprises: creating SQL sentences of the database table and/or modifying SQL sentences of the database table.
7. The apparatus of claim 5, further comprising: a storage module to:
storing SQL statements updated by the database of the target language type, and recording a timestamp of the database update of the target language type;
and querying the SQL sentences of the database update or all the SQL sentences of the database of multiple language types corresponding to different timestamps based on different timestamps.
8. The apparatus of claim 5, further comprising: a language conversion relational library establishing module for:
before the SQL sentences updated by the database are input into a language conversion relational database, establishing the language conversion relational database according to the following steps;
determining the conversion relation among the SQL sentences of the multiple language types for the SQL sentences of the multiple language types;
and establishing the language conversion relation library according to the conversion relation among the SQL sentences of the multiple language types.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010245360.3A CN111367893A (en) | 2020-03-31 | 2020-03-31 | Method and device for database version iteration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010245360.3A CN111367893A (en) | 2020-03-31 | 2020-03-31 | Method and device for database version iteration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111367893A true CN111367893A (en) | 2020-07-03 |
Family
ID=71209281
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010245360.3A Pending CN111367893A (en) | 2020-03-31 | 2020-03-31 | Method and device for database version iteration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111367893A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817990A (en) * | 2021-01-28 | 2021-05-18 | 北京百度网讯科技有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN113420010A (en) * | 2021-06-23 | 2021-09-21 | 建信金融科技有限责任公司 | Database management method and device, electronic equipment and storage medium |
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
| CN115422301A (en) * | 2022-11-03 | 2022-12-02 | 江苏智云天工科技有限公司 | Iterative product quality detection method and system based on quality inspection machine database synchronization |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110121A (en) * | 2009-12-24 | 2011-06-29 | 阿里巴巴集团控股有限公司 | Method and system for processing data |
| CN106933703A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | A kind of method of database data backup, device and electronic equipment |
| CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronous method |
| CN109992595A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Different database conversion method, apparatus, equipment and storage medium |
| CN110245002A (en) * | 2019-05-23 | 2019-09-17 | 阿里巴巴集团控股有限公司 | System interaction method, apparatus, equipment and storage medium |
| CN110674162A (en) * | 2019-09-23 | 2020-01-10 | 税友软件集团股份有限公司 | Database statement execution method and related device |
-
2020
- 2020-03-31 CN CN202010245360.3A patent/CN111367893A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110121A (en) * | 2009-12-24 | 2011-06-29 | 阿里巴巴集团控股有限公司 | Method and system for processing data |
| CN106933703A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | A kind of method of database data backup, device and electronic equipment |
| CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronous method |
| CN109992595A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Different database conversion method, apparatus, equipment and storage medium |
| CN110245002A (en) * | 2019-05-23 | 2019-09-17 | 阿里巴巴集团控股有限公司 | System interaction method, apparatus, equipment and storage medium |
| CN110674162A (en) * | 2019-09-23 | 2020-01-10 | 税友软件集团股份有限公司 | Database statement execution method and related device |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817990A (en) * | 2021-01-28 | 2021-05-18 | 北京百度网讯科技有限公司 | Data processing method and device, electronic equipment and readable storage medium |
| CN112817990B (en) * | 2021-01-28 | 2024-03-08 | 北京百度网讯科技有限公司 | Data processing method, device, electronic equipment and readable storage medium |
| CN113420010A (en) * | 2021-06-23 | 2021-09-21 | 建信金融科技有限责任公司 | Database management method and device, electronic equipment and storage medium |
| CN113420010B (en) * | 2021-06-23 | 2023-05-26 | 中国建设银行股份有限公司 | Database management method, device, electronic equipment and storage medium |
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
| CN115422301A (en) * | 2022-11-03 | 2022-12-02 | 江苏智云天工科技有限公司 | Iterative product quality detection method and system based on quality inspection machine database synchronization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10698682B1 (en) | Computerized software development environment with a software database containing atomic expressions | |
| US20210174006A1 (en) | System and method for facilitating complex document drafting and management | |
| CN111367893A (en) | Method and device for database version iteration | |
| Didonet Del Fabro et al. | Towards the efficient development of model transformations using model weaving and matching transformations | |
| Melnik et al. | Compiling mappings to bridge applications and databases | |
| Clemm et al. | A mechanism for environment integration | |
| CN101901265B (en) | Objectification management system of virtual test data | |
| US20130332449A1 (en) | Generating data processing code from a directed acyclic graph | |
| CN113204571B (en) | SQL execution method and device related to write-in operation and storage medium | |
| CN115543402B (en) | Software knowledge graph increment updating method based on code submission | |
| CN109614315A (en) | A kind of automatic generation method and system of data synchronism detection use-case | |
| Cheney et al. | Database queries that explain their work | |
| US10409815B2 (en) | SQLScript compilation tracing system | |
| CN115809065A (en) | Low-code development platform, data storage method and electronic equipment | |
| Gonçalves et al. | ReFlO: An interactive tool for pipe-and-filter domain specification and program generation | |
| US6925630B1 (en) | Method for generating code for processing a database | |
| JP5641901B2 (en) | SQL verification system, method and program thereof | |
| García et al. | Improving understanding of dynamically typed software developed by agile practitioners | |
| KR100656559B1 (en) | Program Automatic Generating Tools | |
| CN116627390B (en) | ICD file substitution method and device in aviation software development | |
| CN115048109A (en) | Code generation method and device based on metadata | |
| Pavkovic et al. | A UML-based approach to forward engineering of SQLite database | |
| CN114942766A (en) | Excel function conversion method based on SQL database and related device | |
| Ristić et al. | Resolving Database Constraint Collisions Using IIS* Case Tool | |
| Scandura | Cognitive approach to systems engineering and re‐engineering: Integrating new designs with old systems |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20221009 Address after: 12 / F, 15 / F, 99 Yincheng Road, Pudong New Area pilot Free Trade Zone, Shanghai, 200120 Applicant after: Jianxin Financial Science and Technology Co.,Ltd. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |