CN113434528A - Service data updating method, service method and readable storage medium - Google Patents
Service data updating method, service method and readable storage medium Download PDFInfo
- Publication number
- CN113434528A CN113434528A CN202110985278.9A CN202110985278A CN113434528A CN 113434528 A CN113434528 A CN 113434528A CN 202110985278 A CN202110985278 A CN 202110985278A CN 113434528 A CN113434528 A CN 113434528A
- Authority
- CN
- China
- Prior art keywords
- instruction
- statement
- data updating
- string
- updating method
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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/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
Abstract
The invention provides a service data updating method, a service method and a readable storage medium. The service data updating method comprises the following steps: obtaining a preparation character string based on the updating instruction; obtaining a database operation instruction based on an instruction generation method, wherein the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and executing the database operation instruction by the configuration table and the history table. With the configuration, on one hand, the service data updating method is abstracted into a general method, so that higher-level program calling is facilitated; on the other hand, the implementation process of the business data updating method is simplified, the process and the parameters are decoupled, and the development cost and the later maintenance cost are reduced. Therefore, the problems of code repetition and high development and maintenance cost of the data updating method in the prior art are solved.
Description
Technical Field
The present invention relates to the field of database programming, and in particular, to a service data updating method, a service method, and a readable storage medium.
Background
The database refers to an organized and sharable data set stored in a computer for a long time. A relational database refers to a database that uses a relational model to organize data, and stores data in rows and columns for a user to understand conveniently, a series of rows and columns of the relational database are called tables, and a group of tables constitutes the database. The database has smaller redundancy, higher data independence and expansibility, and can be shared by various users.
The database program refers to a program for managing a database and operating data. With the widespread use of database technology, particularly relational databases, the development of various database applications through database programming has become an important aspect of computer applications.
The data updating process in the database, including the adding, modifying and deleting processes, is the basic operation that most business logics need to be involved. The data updating method in the prior art has the problems of code repetition and high development and maintenance cost.
Disclosure of Invention
The invention provides a business data updating method, a business method and a readable storage medium, which aim to solve the problems of code repetition and high development and maintenance cost of the data updating method in the prior art.
In order to solve the above technical problem, according to a first aspect of the present invention, there is provided a business data updating method, where current values of the business data are stored in a configuration table, historical values of the business data are stored in a history table, and the configuration table and the history table are both configured to support responding to database operation statements, the business data updating method including:
acquiring an updating instruction;
obtaining a preparation character string based on the updating instruction;
obtaining a database operation instruction based on an instruction generation method, wherein the database operation instruction is the database operation statement, the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and the number of the first and second groups,
the configuration table and the history table execute the database operation instruction.
Optionally, the database operation statement is a structured query statement.
Optionally, the instruction generating method obtains the database operation instruction based on concatenation of a reserved character string and the preparation character string, where the reserved character string conforms to a construction syntax of the database operation statement.
Optionally, before the obtaining of the update instruction, the service data updating method includes:
and the field names of the data with the same service function stored in the configuration table and the history table are set to be the same.
Optionally, before the obtaining the update instruction, the service data updating method further includes: storing the prepared data; the preparation data is used to assist in obtaining the preparation string.
Optionally, the preparing the character string includes: a configuration table name string, a history table name string, a field name string, a new value string, a current value string, and a qualification string.
Optionally, the format of the qualified string conforms to the construction syntax of the database operation statement.
Optionally, the update instruction includes a new addition instruction, a modification instruction, and a deletion instruction, and the database operation instruction includes a first statement, a second statement, a third statement, and a fourth statement, where:
when the update instruction is the new instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the first statement; after the first statement executes, the configuration table executes the second statement;
when the update instruction is the modification instruction or the deletion instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the third statement; after the third statement executes, the configuration table executes the fourth statement;
when the update instruction is the delete instruction, the step of executing the database operation instruction by the configuration table and the history table further includes: after the fourth statement executes, the configuration table executes the first statement.
In order to solve the above technical problem, according to a second aspect of the present invention, a service method is provided, where the service method includes at least two mutually independent sub-methods, and each of the at least two mutually independent sub-methods updates service data based on the above service data updating method.
In order to solve the above technical problem, according to a third aspect of the present invention, a readable storage medium is provided, on which a program is stored, and when the program runs, the service data updating method described above or the service method described above is executed.
Compared with the prior art, in the service data updating method, the service method and the readable storage medium provided by the invention, the service data updating method comprises the following steps: obtaining a preparation character string based on the updating instruction; obtaining a database operation instruction based on an instruction generation method, wherein the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and executing the database operation instruction by the configuration table and the history table. With the configuration, on one hand, the service data updating method is abstracted into a general method, so that higher-level program calling is facilitated; on the other hand, the implementation process of the business data updating method is simplified, the process and the parameters are decoupled, and the development cost and the later maintenance cost are reduced. Therefore, the problems of code repetition and high development and maintenance cost of the data updating method in the prior art are solved.
Drawings
It will be appreciated by those skilled in the art that the drawings are provided for a better understanding of the invention and do not constitute any limitation to the scope of the invention. Wherein:
FIG. 1 is a flow chart diagram of a data update method;
fig. 2 is a schematic flow chart of a service data updating method according to an embodiment of the present invention;
fig. 3 is another schematic flow chart of a service data updating method according to an embodiment of the present invention.
Detailed Description
To further clarify the objects, advantages and features of the present invention, a more particular description of the invention will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings. It is to be noted that the drawings are in greatly simplified form and are not to scale, but are merely intended to facilitate and clarify the explanation of the embodiments of the present invention. Further, the structures illustrated in the drawings are often part of actual structures. In particular, the drawings may have different emphasis points and may sometimes be scaled differently.
As used in this application, the singular forms "a", "an" and "the" include plural referents, the term "or" is generally employed in a sense including "and/or," the terms "a" and "an" are generally employed in a sense including "at least one," the terms "at least two" are generally employed in a sense including "two or more," and the terms "first", "second" and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicit to the number of technical features indicated. Thus, features defined as "first", "second" and "third" may explicitly or implicitly include one or at least two of the features, "one end" and "the other end" and "proximal end" and "distal end" generally refer to the corresponding two parts, which include not only the end points, but also the terms "mounted", "connected" and "connected" should be understood broadly, e.g., as a fixed connection, as a detachable connection, or as an integral part; can be mechanically or electrically connected; either directly or indirectly through intervening media, either internally or in any other relationship. Furthermore, as used in the present invention, the disposition of an element with another element generally only means that there is a connection, coupling, fit or driving relationship between the two elements, and the connection, coupling, fit or driving relationship between the two elements may be direct or indirect through intermediate elements, and cannot be understood as indicating or implying any spatial positional relationship between the two elements, i.e., an element may be in any orientation inside, outside, above, below or to one side of another element, unless the content clearly indicates otherwise. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
The core idea of the invention is to provide a service data updating method, a service method and a readable storage medium, so as to solve the problems of code repetition and high development and maintenance cost of the data updating method in the prior art.
The following description refers to the accompanying drawings. FIG. 1 is a flow chart of a data update method; fig. 2 is a schematic flow chart of a service data updating method according to an embodiment of the present invention; fig. 3 is another schematic flow chart of a service data updating method according to an embodiment of the present invention.
The inventors have made a deep understanding of the data updating method in the prior art, and have reached the following conclusion. Database applications typically use configuration tables to record current business data, while corresponding history tables are used to record change histories for the business data. A common programming approach in code modules for data processing is shown in fig. 1.
The data updating method shown in fig. 1 includes:
c1 judgment step: the method is used for judging the updating mode, wherein the updating mode comprises adding, modifying and deleting;
i1, if the updating mode is new, inserting data into the configuration table;
i2 after step I1, inserting data into the history table;
if the updating mode of the U1 is modification, selecting the data of the existing configuration table to insert into the history table;
u2 after step U1 deletes the current data of the configuration table;
u3 following step U2, insert new data into the configuration table
D1 if the update mode is delete, selecting the existing configuration table data to insert into the history table;
d2 after step D1, delete the current data of the configuration table.
There are three main problems with this approach:
1. in the change and deletion program module of the configuration table, code duplication exists, namely, existing configuration table data is selected to be inserted into the history table (steps U1 and D1), current data of the configuration table is deleted (steps U2 and D2), and code is repeatedly written.
2. When a table field changes, the codes of all the other steps except step U2 and step D2 need to be modified.
3. When there are multiple sets of configuration/history tables in the program, the code segment needs to be repeated for multiple times.
Therefore, the programming method needs a large amount of workload in the program development and the later maintenance stage.
Based on the above understanding, the inventor proposes a business data updating method, in which current values of the business data are stored in a configuration table, and historical values of the business data are stored in a history table, and the configuration table and the history table are both configured to support responding to database operation statements. Referring to fig. 2, the service data updating method includes:
s30, acquiring an updating instruction;
s40, obtaining a preparation character string based on the updating instruction;
s50, obtaining a database operation instruction based on an instruction generation method, wherein the database operation instruction is the database operation statement, the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and the number of the first and second groups,
s60 executing the database operation instruction by the configuration table and the history table.
In step S30, the update instruction may be from a user or from a program at a higher level, and when the update instruction is from a user, the service data update method further provides a user interface for generating the update instruction, and the user interface may be configured according to common knowledge in the art and will not be described in detail in this specification. The update command includes all information necessary for updating data, for example, a new value, an updated target configuration table name, and the like.
In step S50, the input parameters of the instruction generation method only include the preparation character string, and the instruction generation method only includes a character string splicing operation and a value assignment operation. Therefore, it is ensured that the service data updating method takes less time when being called by different other programs or used by users, and although the system resources and time taken for one updating are relatively less, since most service methods need to update data frequently, the total time and total system resources saved by step S50 are considerable. In addition, the configuration also makes program defects not easy to generate during development and later maintenance.
With the above configuration, the following advantageous effects can be obtained:
1. the service data updating method provides a general implementation mode for processing all configuration tables and history tables in a program.
2. In the program development stage, the code amount required by the business data updating method is reduced by more than n x 50% (compared with the data updating method shown in fig. 1) (n is the number of configuration tables and history tables needing to be processed).
3. In the program maintenance phase, when the fields of the table are changed, only the specific contents of the preparation character string in step S40 need to be modified, and the code related to the flow does not need to be modified.
4. The decoupling of the parameters and the flow is realized, the subsequent maintenance cost is reduced, and the code of the core module does not need to be modified in the later stage.
In one embodiment, the database operation statement is a structured query statement. I.e., an sql (structured Query language) statement. SQL is a special purpose programming language, a database query and programming language, used to access data and query, update, and manage relational database systems. It should be understood that there are some other databases in the prior art, and as the technology develops, some new databases may appear in the future, and the database operation syntax specification different from SQL may be adopted to implement the call and operation of the external program to the database function. Of course, in the present specification, the details will be described by taking SQL as an example, and the configuration may be performed according to the same design concept based on other schemes of syntax specification.
Further, the instruction generation method obtains the database operation instruction based on splicing of a reserved character string and the preparation character string, wherein the reserved character string conforms to the construction grammar of the database operation statement.
The reserved character string is a reserved word or a keyword concept in the common knowledge in the art, for example, in an SQL statement, SELECT, WHERE, FROM, etc. are all the reserved character strings.
Through the configuration, the instruction generation method is simplified to the simplest degree in theory, so that on one hand, the code amount is reduced, and the operation efficiency is improved; and on the other hand, the method is also beneficial to modification and error checking in maintenance.
Referring to the drawings, before the obtaining of the update instruction, the service data updating method includes:
s10, the field names of the configuration table and the history table storing data of the same service function are set to be the same.
With such a configuration, the number of character strings to be calculated in the subsequent preparation character string is further reduced, and errors are not easily caused.
Before the obtaining of the update instruction, the service data updating method further includes:
s20 stores the preparation data; the preparation data is used to assist in obtaining the preparation string. For example, the correspondence between the configuration table name and the history table name, the set of field names in the configuration table, the current parameter value, some predetermined limiting conditions, and the like are stored in advance.
The configuration can further improve the efficiency and reduce the error probability.
In one embodiment, the preparing the character string includes: a configuration table name string, a history table name string, a field name string, a new value string, a current value string, and a qualification string.
The character string may be extracted from the preparation data, extracted from the update instruction, extracted from the configuration table, or calculated and spliced from the extracted contents of the three. So configured, by preparing the above-mentioned preparation character string in advance to support the subsequent operation of the instruction generation method, the instruction generation method can exist in a concise form.
Preferably, the format of the qualification string conforms to the construction syntax of the database operation statement. With such configuration, the instruction generation method can directly splice the limited condition character string and other character strings to obtain a complete instruction character string conforming to the grammar of the database operation statement.
In an embodiment, a flow of the service data updating method is shown in fig. 3.
The service data updating method comprises the following steps:
s1 initializing the fields of configuration table and history table, value variable and limit condition in database;
s2, according to the name of the currently processed configuration table, taking out data and constructing an SQL statement;
s3 determining whether the current update operation is an operation to add new data;
s4 if the judgment result of S3 is yes, the SQL constructed by S2 is executed: inserting data into a configuration table;
s5 after step S4, the S2 structured SQL is executed: inserting data into a history table;
if the judgment result of the S3 is negative, the S6 executes the SQL constructed in the S2: inserting data into a history table;
s7 after step S6, the S2 structured SQL is executed: deleting the current data of the configuration table;
s8 after step S7, determining whether the current update operation is a modify data operation;
s9 if the judgment result of S8 is yes, the SQL constructed by S2 is executed: inserting data into a configuration table;
when the execution of steps S5, S9 ends and the determination result of S8 is no, the current service data updating method ends.
It should be understood that the above step S1 corresponds to step S40, step S2 corresponds to step S50, and the generated SQL statement is the database operation command. Steps S4 to S9 correspond to the step S60. The SQL statements used in step S4 and step S9 are the same, and the SQL statements used in S4, S5, S6, and S7 are different from each other, but are the SQL statements generated in step S2. In one embodiment, all possible SQL statements are generated in advance, which simplifies the flow.
Steps S2-S9 can also be understood by the following pseudo code.
varSqlInsCfg: = 'INSERT INTO' + the configuration table name string + '(' + the field name string + ') VALUES (' + the new value string + ')';
varSqlInsHis: = 'INSERT INTO' + the history table name string + '(' + the field name string + ') VALUES (' + the new value string + ')';
varSqlInsHisMD = 'INSERT INTO' + said historical table name new value string + '(' + said field name string + ') SELECT' + said current value string + 'FROM' + said configuration table name string + 'WHERE' + said qualifying condition string;
varSqlDelCfg = 'DELETE FROM' + the configuration table name string + 'WHERE' + the qualifier string;
IF varUserAction='A' THEN
EXECUTE IMMEDIATE varSqlInsCfg;
EXECUTE IMMEDIATE varSqlInsHis;
ELSE
EXECUTE IMMEDIATE varSqlInsHisMD;
EXECUTE IMMEDIATE varSqlDelCfg;
IF varUserAction='M' THEN
EXECUTE IMMEDIATE varSqlInsCfg;
END IF;
END IF;
for example, when the new value string of the configuration table name is 'a', the new value string of the history table name is 'B', the new value string of the field name is 'C', the new value string of the current value is '10', the new value string of the new value is '20', and the new value string of the qualification condition is 'userId = 10', varsql lnsc fg is 'INSERT INTO a (C) VALUES (20)'; varSqlInsHis is 'INSERT INTO B (C) VALUES (20)'; varsqlInsHisMD is 'INSERT INTO B (C) SELECT 10 FROM A WHERE userId = 10'; varsqlDelCfg is 'DELETE FROM A WHERE userId = 10'.
The above process may also be described as optional, where the update instruction includes an add instruction, a modify instruction, and a delete instruction, and the database operation instruction includes a first statement (i.e., varsql instig), a second statement (i.e., varsql instis), a third statement (i.e., varsql instimmd), and a fourth statement (i.e., varsql delcfg), where:
when the update instruction is the new instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the first statement; after the first statement executes, the configuration table executes the second statement;
when the update instruction is the modification instruction or the deletion instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the third statement; after the third statement executes, the configuration table executes the fourth statement;
when the update instruction is the delete instruction, the step of executing the database operation instruction by the configuration table and the history table further includes: after the fourth statement executes, the configuration table executes the first statement.
The present embodiment also provides a service method, where the service method includes at least two mutually independent sub-methods, and the at least two mutually independent sub-methods update service data based on the service data updating method. The business method does not limit the specific application field and the technical target of solution. At least two mutually independent sub-methods in the service method update the service data by calling the service data updating method, so that the method has the advantages of concise codes and low maintenance cost.
The embodiment also provides a readable storage medium, where a program is stored, and when the program runs, the service data updating method or the service method is executed.
In summary, in the service data updating method, the service method, and the readable storage medium provided in this embodiment, the service data updating method includes: obtaining a preparation character string based on the updating instruction; obtaining a database operation instruction based on an instruction generation method, wherein the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and executing the database operation instruction by the configuration table and the history table. With the configuration, on one hand, the service data updating method is abstracted into a general method, so that higher-level program calling is facilitated; on the other hand, the implementation process of the business data updating method is simplified, the process and the parameters are decoupled, and the development cost and the later maintenance cost are reduced. Therefore, the problems of code repetition and high development and maintenance cost of the data updating method in the prior art are solved.
The above description is only for the purpose of describing the preferred embodiments of the present invention, and is not intended to limit the scope of the present invention, and any variations and modifications made by those skilled in the art according to the above disclosure are within the scope of the present invention.
Claims (10)
1. A business data updating method, wherein a current value of the business data is stored in a configuration table, a history value of the business data is stored in a history table, and the configuration table and the history table are both configured to support a response database operation statement, the business data updating method comprising:
acquiring an updating instruction;
obtaining a preparation character string based on the updating instruction;
obtaining a database operation instruction based on an instruction generation method, wherein the database operation instruction is the database operation statement, the input parameters of the instruction generation method only comprise the preparation character string, and the instruction generation method only comprises character string splicing operation and assignment operation; and the number of the first and second groups,
the configuration table and the history table execute the database operation instruction.
2. The business data updating method of claim 1, wherein the database operation statement is a structured query statement.
3. The business data updating method according to claim 1, wherein the instruction generating method obtains the database operation instruction based on concatenation of a reserved string and the preparation string, and the reserved string conforms to a construction syntax of the database operation statement.
4. The service data updating method according to claim 1, wherein before the obtaining of the update instruction, the service data updating method comprises:
and the field names of the data with the same service function stored in the configuration table and the history table are set to be the same.
5. The service data updating method according to claim 1, wherein before the obtaining of the update instruction, the service data updating method further comprises: storing the prepared data; the preparation data is used to assist in obtaining the preparation string.
6. The service data updating method according to claim 1, wherein the preparing the character string comprises: a configuration table name string, a history table name string, a field name string, a new value string, a current value string, and a qualification string.
7. The business data updating method according to claim 6, wherein the format of the qualifier string conforms to the construction syntax of the database operation statement.
8. The service data updating method according to any one of claims 1 to 7, wherein the update instruction includes an addition instruction, a modification instruction, and a deletion instruction, and the database operation instruction includes a first statement, a second statement, a third statement, and a fourth statement, where:
when the update instruction is the new instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the first statement; after the first statement executes, the configuration table executes the second statement;
when the update instruction is the modification instruction or the deletion instruction, the step of executing the database operation instruction by the configuration table and the history table includes: the history table executes the third statement; after the third statement executes, the configuration table executes the fourth statement;
when the update instruction is the delete instruction, the step of executing the database operation instruction by the configuration table and the history table further includes: after the fourth statement executes, the configuration table executes the first statement.
9. A service method, characterized in that the service method comprises at least two mutually independent sub-methods, each of which updates service data based on the service data updating method according to any one of claims 1 to 8.
10. A readable storage medium, characterized in that the readable storage medium has a program stored thereon, and when the program is executed, the program executes the service data updating method according to any one of claims 1 to 8 or executes the service method according to claim 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110985278.9A CN113434528B (en) | 2021-08-26 | 2021-08-26 | Service data updating method, service method and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110985278.9A CN113434528B (en) | 2021-08-26 | 2021-08-26 | Service data updating method, service method and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113434528A true CN113434528A (en) | 2021-09-24 |
| CN113434528B CN113434528B (en) | 2021-12-17 |
Family
ID=77797983
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110985278.9A Active CN113434528B (en) | 2021-08-26 | 2021-08-26 | Service data updating method, service method and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113434528B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6640278B1 (en) * | 1999-03-25 | 2003-10-28 | Dell Products L.P. | Method for configuration and management of storage resources in a storage network |
| CN101968793A (en) * | 2010-08-25 | 2011-02-09 | 大唐软件技术股份有限公司 | Method and system for checking on basis of disparate data source data |
| CN104503984A (en) * | 2014-11-28 | 2015-04-08 | 北京国双科技有限公司 | Data operating record processing method and device |
| CN113157554A (en) * | 2021-02-19 | 2021-07-23 | 武汉木仓科技股份有限公司 | Software automation question making test method and related equipment |
-
2021
- 2021-08-26 CN CN202110985278.9A patent/CN113434528B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6640278B1 (en) * | 1999-03-25 | 2003-10-28 | Dell Products L.P. | Method for configuration and management of storage resources in a storage network |
| CN101968793A (en) * | 2010-08-25 | 2011-02-09 | 大唐软件技术股份有限公司 | Method and system for checking on basis of disparate data source data |
| CN104503984A (en) * | 2014-11-28 | 2015-04-08 | 北京国双科技有限公司 | Data operating record processing method and device |
| CN113157554A (en) * | 2021-02-19 | 2021-07-23 | 武汉木仓科技股份有限公司 | Software automation question making test method and related equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113434528B (en) | 2021-12-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106021594B (en) | The mapping treatment method and its system of database table and XML message | |
| US7676492B2 (en) | Migration of database using serialized objects | |
| CN112559554B (en) | Query statement optimization method and device | |
| US20150142734A1 (en) | Meta Model Driven Data Base Replication and Synchronization | |
| CN111104151B (en) | Shell script-based Git code simplification management method | |
| CN115543402B (en) | Software knowledge graph increment updating method based on code submission | |
| CN113204571B (en) | SQL execution method and device related to write-in operation and storage medium | |
| US20060136471A1 (en) | Differential management of database schema changes | |
| CN111367893A (en) | Method and device for database version iteration | |
| CN113467785B (en) | SQL translation method and system for mimicry database | |
| CN100527131C (en) | Interdynamic access method and tool of IMS data base | |
| CN114564500A (en) | Method and system for implementing structured data storage and query in block chain system | |
| CN113434528B (en) | Service data updating method, service method and readable storage medium | |
| US20070067254A1 (en) | Business model data management | |
| CN111914028A (en) | Method and device for synchronizing data relation of heterogeneous data sources based on graph increment | |
| JP5377522B2 (en) | Efficiently correlate nominally incompatible types | |
| CN110806973A (en) | Automatic generation method and device of interface message | |
| US6925630B1 (en) | Method for generating code for processing a database | |
| CN111259003B (en) | Database establishment method and device | |
| CN114138815A (en) | Multi-database compatibility implementation method, device and medium for application program | |
| CN113934726A (en) | Random smooth sub-table method, terminal and storage medium | |
| CN116302206B (en) | Presto data source hot loading method based on MQ | |
| CN112051987B (en) | Service data processing method, device and equipment, program generating method and device | |
| CN111984648B (en) | Data initialization method and system under micro-service architecture | |
| CN114089976B (en) | Method, apparatus, and medium for generating database operation statements |
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 | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 510000 No. 28, Fenghuang fifth road, Huangpu District, Guangzhou, Guangdong Patentee after: Yuexin Semiconductor Technology Co.,Ltd. Address before: 510000 No. 28, Fenghuang fifth road, Huangpu District, Guangzhou, Guangdong Patentee before: Guangzhou Yuexin Semiconductor Technology Co.,Ltd. |