CN112860802A - Database operation statement processing method and device and electronic equipment - Google Patents

Database operation statement processing method and device and electronic equipment Download PDF

Info

Publication number
CN112860802A
CN112860802A CN202110333924.3A CN202110333924A CN112860802A CN 112860802 A CN112860802 A CN 112860802A CN 202110333924 A CN202110333924 A CN 202110333924A CN 112860802 A CN112860802 A CN 112860802A
Authority
CN
China
Prior art keywords
target
service data
data
fragment key
database
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
Application number
CN202110333924.3A
Other languages
Chinese (zh)
Inventor
彭飞
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Citic Bank Corp Ltd
Original Assignee
China Citic Bank Corp Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by China Citic Bank Corp Ltd filed Critical China Citic Bank Corp Ltd
Priority to CN202110333924.3A priority Critical patent/CN112860802A/en
Publication of CN112860802A publication Critical patent/CN112860802A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the application provides a method and a device for processing database operation statements and electronic equipment. The method comprises the following steps: when the target operation on the service data object is detected, acquiring service data corresponding to the service data object; determining a target fragment key based on target service data specified in the service data; and processing the operation statement of the target operation based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.

Description

Database operation statement processing method and device and electronic equipment
Technical Field
The application relates to the technical field of computers, in particular to a method and a device for processing database operation statements and electronic equipment.
Background
Object Relational Mapping (ORM), which is a programming technique for implementing conversion between data of different types of systems in an Object-oriented programming language, generally exists in the form of middleware and mainly implements Mapping of program objects to Relational database data.
At present, the ORM framework technology is widely used to support various mainstream databases, but at present, there is no ORM framework for a distributed database, which cannot support database operations based on a sharded key in the distributed database, and affects the availability and performance of the whole system.
Disclosure of Invention
The present application aims to solve at least one of the above technical drawbacks. The technical scheme adopted by the application is as follows:
in a first aspect, an embodiment of the present application provides a method for processing a database operation statement, where the method includes:
when the target operation on the service data object is detected, acquiring service data corresponding to the service data object;
determining a target fragment key based on target service data specified in the service data;
and processing the operation statement of the target operation based on the target fragment key.
Optionally, determining a target fragment key based on target service data specified in the service data includes any one of:
and determining a target fragment key associated with the target service data specified in the service data based on a preset association relationship, wherein the association relationship is the association relationship between the service data and the fragment key.
Optionally, determining a target fragment key associated with target service data specified in the service data based on a preset association relationship, where the target fragment key includes any one of:
based on a preset incidence relation, determining a first field which is associated with target business data and belongs to a database table of the specified target business data in the business data as a target fragment key;
and determining a second field associated with the target business data in a comparison table corresponding to a database table to which the target business data belongs in the business data as a target fragment key based on a preset association relation.
Optionally, processing an operation statement of the target operation based on the target sharding key includes:
and adding the target fragment key into the query condition of the operation statement of the target operation.
Optionally, the method further includes:
and operating the database table to which the target business data belongs in the database based on the operation statement.
Optionally, the target operation comprises any one of:
adding data;
reading data;
modifying the data;
and deleting the data.
Optionally, if the target operation is any one of adding data, modifying data and deleting data, and the database table to which the target business data belongs is a comparison table, after the data in the comparison table is operated by the operation statement corresponding to the target operation, the method further includes:
and updating the association relation based on the comparison table after the operation.
Optionally, the method further includes:
and writing the fragment key into a database table corresponding to the service data.
In a second aspect, an embodiment of the present application provides an apparatus for processing a database operation statement, where the apparatus includes:
the service data acquisition module is used for acquiring service data corresponding to the service data object when target operation on the service data object is detected;
the fragment key determining module is used for determining a target fragment key based on target service data appointed in the service data;
and the operation statement processing module is used for processing the operation statement of the target operation based on the target fragment key.
Optionally, the shard key determining module is specifically configured to:
and determining a target fragment key associated with the target service data specified in the service data based on a preset association relationship, wherein the association relationship is the association relationship between the service data and the fragment key.
Optionally, the fragment key determining module is specifically configured to, when determining, based on a preset association relationship, a target fragment key associated with target service data specified in the service data, any one of the following:
based on a preset incidence relation, determining a first field which is associated with target business data and belongs to a database table of the specified target business data in the business data as a target fragment key;
and determining a second field associated with the target business data in a comparison table corresponding to a database table to which the target business data belongs in the business data as a target fragment key based on a preset association relation.
Optionally, the operation statement processing module is specifically configured to:
and adding the target fragment key into the query condition of the operation statement of the target operation.
Optionally, the apparatus further comprises:
and the database operation module is used for operating the database table to which the target service data in the database belongs based on the operation statement.
Optionally, the target operation comprises any one of:
adding data;
reading data;
modifying the data;
and deleting the data.
Optionally, if the target operation is any one of adding data, modifying data and deleting data, and the database table to which the target business data belongs is a comparison table, after the data in the comparison table is operated by the operation statement corresponding to the target operation, the apparatus further includes:
and the incidence relation updating module is used for updating the incidence relation based on the comparison table after the operation.
Optionally, the apparatus further comprises:
and the fragment key writing module is used for writing the fragment key into a database table corresponding to the service data.
In a third aspect, an embodiment of the present application provides an electronic device, including: a processor and a memory;
a memory for storing operating instructions;
the processor is used for executing the processing method of the database operation statement as shown in any implementation manner of the first aspect of the application by calling the operation instruction.
In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for processing the database operation statement shown in any implementation manner of the first aspect of the present application.
The technical scheme provided by the embodiment of the application has the following beneficial effects:
according to the scheme provided by the embodiment of the application, when the target operation on the business data object is detected, the business data corresponding to the business data object is obtained, the target fragment key is determined based on the target business data specified in the business data, and therefore the operation statement of the target operation is processed based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.
Fig. 1 is a schematic flowchart of a method for processing a database operation statement according to an embodiment of the present application;
fig. 2 is a flowchart illustrating a specific implementation of a split key conversion scheme according to an embodiment of the present application.
Fig. 3 is a schematic structural diagram of a processing apparatus for database operation statements according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present invention.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
At present, in the process of providing services in a distributed database, data is generally coordinately located through a sharded key.
The existing ORM framework is not suitable for the characteristics of a distributed database, does not support fragmentation keywords, does not support dynamic generation of the fragmentation keywords during operation, does not support cascade fragmentation, and affects the availability and performance of the whole system.
The method and the device for processing the database operation statements and the electronic device provided by the embodiment of the application aim to solve at least one of the above technical problems in the prior art.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 1 shows a schematic flowchart of a method for processing a database operation statement according to an embodiment of the present application, and as shown in fig. 1, the method mainly includes:
step S110: when the target operation on the service data object is detected, acquiring service data corresponding to the service data object;
step S120: determining a target fragment key based on target service data specified in the service data;
step S130: and processing the operation statement of the target operation based on the target fragment key.
In the embodiment of the application, a JAVA-based data access framework may be developed, and when it is detected that a user performs a target operation on a business data object in an ORM engine, business data associated with the business data object is acquired.
In the embodiment of the application, the target fragment key can be determined according to the target service data in the service data, so that the fragment key is added in the operation statement of the target operation.
In the embodiment of the application, because the fragment key is determined according to the service data and is added into the operation data, a foundation can be provided for accessing the distributed database through the ORM framework and performing database operation based on the fragment key.
According to the method provided by the embodiment of the application, when the target operation on the business data object is detected, the business data corresponding to the business data object is obtained, the target fragment key is determined based on the target business data specified in the business data, and therefore the operation statement of the target operation is processed based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.
Because the distributed database is accessed through the ORM framework, the fragment key can be automatically added in the operation statement to support the database operation based on the fragment key, so that the distribution of data in the distributed database can be controlled according to the service characteristics, the cascade fragment is supported, and the system performance is conveniently improved.
In an optional manner of the embodiment of the present application, determining a target fragment key based on target service data specified in service data includes:
and determining a target fragment key associated with the target service data specified in the service data based on a preset association relationship, wherein the association relationship is the association relationship between the service data and the fragment key.
In the embodiment of the present application, a fragment key conversion scheme may be configured to obtain a fragment key, and specifically, an association relationship between service data and the fragment key may be configured.
After the service data targeted by the target operation is determined, the target service data associated with the fragment key in the service data can be determined according to the association relationship between the service data and the fragment key, and then the target fragment key associated with the target service data can be found out according to the association relationship.
In an optional manner of the embodiment of the present application, determining, based on a preset association relationship, a target fragment key associated with target service data specified in service data includes any one of:
based on a preset incidence relation, determining a first field which is associated with target business data and belongs to a database table of the specified target business data in the business data as a target fragment key;
and determining a second field associated with the target business data in a comparison table corresponding to a database table to which the target business data belongs in the business data as a target fragment key based on a preset association relation.
In the embodiment of the application, a first field associated with the target business data in a database table to which the target business data belongs may be determined as a target fragment key, and the first field may be a field itself in which the target business data is located, or may be one or more fields in the database table to which the target business data belongs.
In the embodiment of the present application, a second field associated in a comparison table corresponding to a database table to which target service data belongs may be determined as a target fragment key, and the second field may be one or more fields in the comparison table corresponding to the database table to which the target service data belongs.
In an optional manner of the embodiment of the present application, processing an operation statement of a target operation based on a target fragment key includes:
and adding the target fragment key into the query condition of the operation statement of the target operation.
In the embodiment of the application, the target fragment key can be added to the query condition of the operation statement, so that the target service data can be rapidly determined from the distributed database during database operation.
In an optional manner of the embodiment of the present application, the method further includes:
and operating the database table to which the target business data belongs in the database based on the operation statement.
In the embodiment of the application, after the target fragment key is added to the operation statement, the database operation can be performed on the distributed database through the operation statement.
In an optional manner of the embodiments of the present application, the target operation includes any one of:
adding data;
reading data;
modifying the data;
and deleting the data.
In the embodiment of the present application, the target operation may be a CRUD operation, i.e., add data (create), read data (read), modify data (update), and delete data (delete). By automatically generating the fragment key when CRUD operates, the adaptability to the distributed database is improved.
In an optional manner of the embodiment of the application, if the target operation is any one of adding data, modifying data, and deleting data, and a database table to which the target service data belongs is a comparison table, after the data in the comparison table is operated by an operation statement corresponding to the target operation, the method further includes:
and updating the association relation based on the comparison table after the operation.
In the embodiment of the present application, since the fragment key may be determined from the comparison table based on the association relationship, when the comparison table is changed, the association relationship needs to be updated according to the changed comparison table.
In actual use, after operations such as adding data, modifying data, deleting data and the like are performed on the comparison table, the comparison table may be changed, and the association relationship may be updated according to the changed comparison table.
In an optional manner of the embodiment of the present application, the method further includes:
and writing the fragment key into a database table corresponding to the service data.
In the implementation of the application, the distributed database can be preprocessed before database operation is performed, and the fragment key is written into the distributed database, so that the database operation is performed by a database operation statement added with the fragment key.
The embodiment of the application provides a JAVA-based data access framework, so that an application program can access a distributed database in a manner of accessing a centralized database, and can control the distribution of data in the distributed database according to service characteristics, and the availability and performance of the whole system can be improved in a distributed transaction scene. The present data access framework also contains ORM functionality.
The data access framework provided by the embodiment of the application comprises an ORM engine, and can solve the problem of object-relation mapping. When CRUD operation is performed on the database, a fragment key can be provided, and the fragment key influences the fragment to which the data belongs. The scheme can configure the fragment key source, automatically generates the fragment key during CRUD operation, and can reduce the coupling of the program and the characteristics of the distributed database. The shard key source may be a field on a table, or calculated from a field on a table, or obtained by querying other tables. The method supports cascading fragmentation, and solves the problem that certain tables are not provided with fragmentation keys and indirectly depend on other table fragmentation.
The method and the device provide a configurable ORM framework for accessing the distributed database, support the use and configuration of application programs, optimize data distribution aiming at the technical characteristics of the distributed database, and improve the usability and performance of transactions.
As an example, fig. 2 shows a flowchart of a specific implementation of the fragment key conversion scheme provided in the embodiment of the present application.
As shown in fig. 2, sharded keys, i.e., columns that exist on a database table without business implications, are provided exclusively to the distributed database for data sharding computations.
The fragment key conversion scheme may obtain the fragment key according to the source field lookup table, or may return the source field directly, for example.
The conversion key, i.e. the target service field, is the source field for the fragmentation key conversion scheme.
Table field, i.e. target traffic data.
When the fragment key conversion is performed, the conversion can be performed according to the fragment key conversion scheme by using the acquired target service data as a conversion key, so as to obtain the fragment key.
In CRUD operation, the ORM engine automatically calculates/acquires the fragment key of the operated record according to the configuration, generates and runs a correct SQL statement, and returns the result to the DAO class. The specific technical scheme is as follows:
a) before adding, reading, modifying and deleting operation, firstly using a fragment key conversion scheme to obtain a fragment key, and adding the fragment key to the query condition of the database operation statement.
b) After the add, modify, and delete operations, if the database table to which the operation is directed is a reference table class, the split key conversion scheme is automatically updated.
Based on the same principle as the method shown in fig. 1, fig. 3 shows a schematic structural diagram of a processing apparatus of a database operation statement provided by an embodiment of the present application, and as shown in fig. 3, the processing apparatus 20 of the database operation statement may include:
a service data obtaining module 210, configured to obtain service data corresponding to a service data object when a target operation on the service data object is detected;
a fragment key determining module 220, configured to determine a target fragment key based on target service data specified in the service data;
and the operation statement processing module 230 is configured to process an operation statement of the target operation based on the target sharding key.
The device provided by the embodiment of the application acquires the service data corresponding to the service data object when the target operation on the service data object is detected, and determines the target fragment key based on the target service data specified in the service data, so that the operation statement of the target operation is processed based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.
It is to be understood that the above modules of the database operation statement processing apparatus in the present embodiment have functions of implementing corresponding steps of the database operation statement processing method in the embodiment shown in fig. 1. The function can be realized by hardware, and can also be realized by executing corresponding software by hardware. The hardware or software includes one or more modules corresponding to the functions described above. The modules can be software and/or hardware, and each module can be implemented independently or by integrating a plurality of modules. For the functional description of each module of the processing apparatus for the database operation statement, reference may be specifically made to the corresponding description of the processing method for the database operation statement in the embodiment shown in fig. 1, and details are not repeated here.
The embodiment of the application provides an electronic device, which comprises a processor and a memory;
a memory for storing operating instructions;
and the processor is used for executing the processing method of the database operation statement provided by any embodiment of the application by calling the operation instruction.
As an example, fig. 4 shows a schematic structural diagram of an electronic device to which an embodiment of the present application is applicable, and as shown in fig. 4, the electronic device 2000 includes: a processor 2001 and a memory 2003. Wherein the processor 2001 is coupled to a memory 2003, such as via a bus 2002. Optionally, the electronic device 2000 may also include a transceiver 2004. It should be noted that the transceiver 2004 is not limited to one in practical applications, and the structure of the electronic device 2000 is not limited to the embodiment of the present application.
The processor 2001 is applied to the embodiment of the present application to implement the method shown in the above method embodiment. The transceiver 2004 may include a receiver and a transmitter, and the transceiver 2004 is applied to the embodiments of the present application to implement the functions of the electronic device of the embodiments of the present application to communicate with other devices when executed.
The Processor 2001 may be a CPU (Central Processing Unit), general Processor, DSP (Digital Signal Processor), ASIC (Application Specific Integrated Circuit), FPGA (Field Programmable Gate Array) or other Programmable logic device, transistor logic device, hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 2001 may also be a combination of computing functions, e.g., comprising one or more microprocessors, DSPs and microprocessors, and the like.
Bus 2002 may include a path that conveys information between the aforementioned components. The bus 2002 may be a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus 2002 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown in FIG. 4, but this does not indicate only one bus or one type of bus.
The Memory 2003 may be a ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, a RAM (Random Access Memory) or other type of dynamic storage device that can store information and instructions, an EEPROM (Electrically Erasable Programmable Read Only Memory), a CD-ROM (Compact Disc Read Only Memory) or other optical Disc storage, optical Disc storage (including Compact Disc, laser Disc, optical Disc, digital versatile Disc, blu-ray Disc, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these.
Optionally, the memory 2003 is used for storing application program code for performing the disclosed aspects, and is controlled in execution by the processor 2001. The processor 2001 is configured to execute the application program code stored in the memory 2003 to implement the method for processing the database operation statement provided in any embodiment of the present application.
The electronic device provided by the embodiment of the application is applicable to any embodiment of the method, and is not described herein again.
Compared with the prior art, when the target operation on the business data object is detected, the business data corresponding to the business data object is obtained, the target fragment key is determined based on the target business data specified in the business data, and therefore the operation statement of the target operation is processed based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.
The embodiment of the present application provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the computer program implements the method for processing the database operation statements shown in the above method embodiment.
The computer-readable storage medium provided in the embodiments of the present application is applicable to any of the embodiments of the foregoing method, and is not described herein again.
Compared with the prior art, when the target operation on the business data object is detected, the business data corresponding to the business data object is obtained, the target fragment key is determined based on the target business data specified in the business data, and therefore the operation statement of the target operation is processed based on the target fragment key. Based on the scheme, the database operation based on the fragment key in the distributed database can be supported, so that the availability and the performance of the whole system are ensured.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The foregoing is only a partial embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims (11)

1. A processing method of database operation statements is characterized by comprising the following steps:
when the target operation on a service data object is detected, acquiring service data corresponding to the service data object;
determining a target fragment key based on target service data specified in the service data;
and processing the operation statement of the target operation based on the target fragment key.
2. The method according to claim 1, wherein the determining a target fragmentation key based on target service data specified in the service data comprises:
and determining a target fragment key associated with the target service data specified in the service data based on a preset association relationship, wherein the association relationship is the association relationship between the service data and the fragment key.
3. The method according to claim 2, wherein the determining a target fragment key associated with the target service data specified in the service data based on a preset association relationship includes any one of:
determining a first field associated with the target business data in a database table to which the target business data belongs in the business data as a target fragment key based on a preset association relation;
and determining a second field associated with the target business data in a comparison table corresponding to a database table to which the target business data belongs in the business data as a target fragment key based on a preset incidence relation.
4. The method according to claim 1, wherein the processing the operation statement of the target operation based on the target sharding key comprises:
and adding the target fragment key to the query condition of the operation statement of the target operation.
5. The method of claim 1, further comprising:
and operating the database table to which the target business data belongs in the database based on the operation statement.
6. The method of claim 1, wherein the target operation comprises any one of:
adding data;
reading data;
modifying the data;
and deleting the data.
7. The method according to claim 6, wherein if the target operation is any one of adding data, modifying data and deleting data, and the database table to which the target business data belongs is the lookup table, after the data in the lookup table is operated by the operation statement corresponding to the target operation, the method further comprises:
and updating the association relation based on the comparison table after the operation.
8. The method according to any one of claims 1-7, further comprising:
and writing the fragment key into a database table corresponding to the service data.
9. An apparatus for processing database operation statements, comprising:
the service data acquisition module is used for acquiring service data corresponding to a service data object when target operation on the service data object is detected;
the fragment key determining module is used for determining a target fragment key based on the target service data appointed in the service data;
and the operation statement processing module is used for processing the operation statement of the target operation based on the target fragment key.
10. An electronic device comprising a processor and a memory;
the memory is used for storing operation instructions;
the processor is used for executing the method of any one of claims 1-8 by calling the operation instruction.
11. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method of any one of claims 1-8.
CN202110333924.3A 2021-03-29 2021-03-29 Database operation statement processing method and device and electronic equipment Pending CN112860802A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110333924.3A CN112860802A (en) 2021-03-29 2021-03-29 Database operation statement processing method and device and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110333924.3A CN112860802A (en) 2021-03-29 2021-03-29 Database operation statement processing method and device and electronic equipment

Publications (1)

Publication Number Publication Date
CN112860802A true CN112860802A (en) 2021-05-28

Family

ID=75993191

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110333924.3A Pending CN112860802A (en) 2021-03-29 2021-03-29 Database operation statement processing method and device and electronic equipment

Country Status (1)

Country Link
CN (1) CN112860802A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113255315A (en) * 2021-07-19 2021-08-13 杭州天谷信息科技有限公司 Method and system for configuring and generating evidence chain
CN113568924A (en) * 2021-07-23 2021-10-29 北京达佳互联信息技术有限公司 Data processing method and device, electronic equipment and storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113255315A (en) * 2021-07-19 2021-08-13 杭州天谷信息科技有限公司 Method and system for configuring and generating evidence chain
CN113568924A (en) * 2021-07-23 2021-10-29 北京达佳互联信息技术有限公司 Data processing method and device, electronic equipment and storage medium
CN113568924B (en) * 2021-07-23 2024-05-14 北京达佳互联信息技术有限公司 Data processing method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
US9875280B2 (en) Efficient partitioned joins in a database with column-major layout
US6665678B2 (en) Method, system, and program for optimistic concurrency control for scrollable cursors in a database
US7386609B2 (en) Method, system, and program for managing devices in a network
US7822710B1 (en) System and method for data collection
US20050050058A1 (en) Direct loading of opaque types
US20140101132A1 (en) Swapping expected and candidate affinities in a query plan cache
CN112860802A (en) Database operation statement processing method and device and electronic equipment
CN111737564B (en) Information query method, device, equipment and medium
CN111797073A (en) Database management method, electronic device, and computer-readable storage medium
US9971794B2 (en) Converting data objects from multi- to single-source database environment
US20200159461A1 (en) Data accessing method, device, and storage medium
CN112182036A (en) Data sending and writing method and device, electronic equipment and readable storage medium
CN111949693A (en) Data processing device, data processing method, storage medium and electronic equipment
CN117195185A (en) User authority management method for graph database, electronic equipment and medium
CN103678396A (en) Data backup method and device based on data models
CN109614411B (en) Data storage method, device and storage medium
CN104573112A (en) Page query method and data processing node for OLTP cluster database
US20070106652A1 (en) Apparatus, system, and method for accessing a database
CN109408539A (en) Data manipulation method, device, server and storage medium
CN111949725A (en) Data query method and device, electronic equipment and computer readable storage medium
US9342581B2 (en) System to disclose the internal structure of persistent database objects
CN116644122A (en) Data transaction processing method, device, computer equipment and storage medium
US7856344B2 (en) Method for transforming overlapping paths in a logical model to their physical equivalent based on transformation rules and limited traceability
CN115114325A (en) Data query method and device, electronic equipment and storage medium
CN112905601A (en) Routing method and device for database sub-tables

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