CN106980617B - Method and system for operating database based on JSON statement - Google Patents

Method and system for operating database based on JSON statement Download PDF

Info

Publication number
CN106980617B
CN106980617B CN201610028786.7A CN201610028786A CN106980617B CN 106980617 B CN106980617 B CN 106980617B CN 201610028786 A CN201610028786 A CN 201610028786A CN 106980617 B CN106980617 B CN 106980617B
Authority
CN
China
Prior art keywords
expression
database
json
data request
relation
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201610028786.7A
Other languages
Chinese (zh)
Other versions
CN106980617A (en
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.)
Aisino Corp
Original Assignee
Aisino Corp
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 Aisino Corp filed Critical Aisino Corp
Priority to CN201610028786.7A priority Critical patent/CN106980617B/en
Publication of CN106980617A publication Critical patent/CN106980617A/en
Application granted granted Critical
Publication of CN106980617B publication Critical patent/CN106980617B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • 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/21Design, administration or maintenance of databases

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 embodiment of the invention provides a method and a system for operating a database based on JSON statements. Creating an expression of table relation of query SQL statement according to a database table relation diagram described by JSON description rule and according to a data request described by JSON description rule; creating an expression of a screening condition for querying the table relation of the SQL statement according to the data request described by the JSON description rule and the expression of the table relation; and generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition. The method for generating the query SQL statement is a once-for-all manner, and zero codes are realized in the compiling process of the query SQL statement under the ideal condition. The development work based on database items with complex business logic can be greatly improved. The working efficiency and the product quality are improved.

Description

Method and system for operating database based on JSON statement
Technical Field
The invention relates to the technical field of databases, in particular to a method and a system for operating a database based on JSON statements.
Background
In the operation process of a database for software development, software developers need to frequently write SQL sentences, but the manual writing of the SQL sentences has the defects of low efficiency, high error rate, time and labor consuming debugging process and the like. To improve this situation, there are currently some relevant software on the market, such as: navicat, etc., but such software still remains at the user level and generates the desired SQL statements by means of dialogue with the user. Then, the developer can copy the generated SQL and paste the copied SQL into a specific program, and then perform operations such as condition assignment and the like. The method provided by the patent is completely separated from manual intervention, the method runs synchronously with the main program, and the main program directly calls the SQL generating module to be used at any time and generated at any time. Developers do not need to participate in the whole process.
As is well known, the average number of errors in the code, the number of bugs generated, and the total number of lines of the code have a direct relationship, and how to reduce the code writing amount of the overall development becomes a technical problem to be solved urgently, that is, zero writing of query SQL statements can be realized under ideal conditions.
Disclosure of Invention
The embodiment of the invention provides a method and a system for operating a database based on JSON statements. The invention provides the following scheme:
creating an expression of table relation of query SQL sentences according to a database table relation diagram described by the JSON description rule and a data request described by the JSON description rule;
creating an expression of a screening condition for querying the table relation of the SQL statement according to the data request described by the JSON description rule and the expression of the table relation;
and generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
According to the method, the creating of the expression of the table relation of the query SQL statement according to the database table relational diagram described by the JSON description rule and the data request described by the JSON description rule comprises the following steps:
extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object.
The above method according to the present invention comprises:
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of the SQL statement according to the table object.
According to the method, the creating of the expression of the screening condition of the table relationship of the query SQL statement according to the data request described by the JSON description rule and the expression of the table relationship comprises:
extracting screening conditions corresponding to tag items of the data request according to the data request described by the JSON description rule;
extracting a table object matched with the label item of the data request according to the expression of the table relation;
and creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item.
The above method according to the present invention comprises:
the method comprises the steps of pre-establishing JSON and database table corresponding expression rules as JSON description rules, describing a database table relational graph by using the description rules, and describing a data request by using the description rules.
According to another aspect of the present invention, there is also provided a system for operating a database based on JSON statements, including:
a first description module: the method is used for creating an expression for querying the table relation of the SQL statement according to a database table relational graph described by a JSON description rule and a data request described by the JSON description rule;
a second description module: the method comprises the steps that an expression of a screening condition for querying table relations of SQL sentences is created according to data requests described by JSON description rules and the expression of the table relations;
an operation module: the SQL statement operation database is used for generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
According to another aspect of the present invention, the first description module is specifically configured to:
extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object.
According to another aspect of the present invention, the first description module is further specifically configured to:
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of the SQL statement according to the table object.
According to another aspect of the present invention, the second description module is further specifically configured to:
extracting screening conditions corresponding to tag items of the data request according to the data request described by the JSON description rule;
extracting a table object matched with the label item of the data request according to the expression of the table relation;
and creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item.
According to another aspect of the present invention, further comprising:
a building module: it is used for: the method comprises the steps of pre-establishing JSON and database table corresponding expression rules as JSON description rules, describing a database table relational graph by using the description rules, and describing a data request by using the description rules.
As can be seen from the technical solutions provided by the embodiments of the present invention, the embodiments of the present invention create an expression for querying table relationships of SQL statements according to a database table relationship diagram described by using JSON description rules and according to a data request described by using JSON description rules; creating an expression of a screening condition for querying a table relation of an SQL statement according to a data request described by a JSON description rule; and generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition. The method for generating the query SQL statement is a once-for-all manner, and zero codes are realized in the compiling process of the query SQL statement under the ideal condition. The development work based on database items with complex business logic can be greatly improved. The working efficiency and the product quality are improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive labor.
Fig. 1 is a processing flow chart of a method for operating a database based on JSON statements according to an embodiment of the present invention;
FIG. 2 is a database table relationship diagram of an example provided in accordance with an embodiment of the present invention;
fig. 3 is a system block diagram of a system based on a JSON statement operation database according to a second embodiment of the present invention.
Detailed Description
For the convenience of understanding the embodiments of the present invention, the following description will be further explained by taking several specific embodiments as examples in conjunction with the drawings, and the embodiments are not to be construed as limiting the embodiments of the present invention.
Example one
In this embodiment, a JSON (javascript Object notification) expression rule corresponding to a database table needs to be pre-established as a JSON description rule, the description rule is adopted to describe the database table relational graph, and the description rule is adopted to describe a data request; the database table relational graph is obtained directly based on the database or can be obtained based on other third-party tools.
In this embodiment, a description rule is provided to describe the database table relationship graph, which is specifically as follows: the description rule defined in this embodiment may be understood as an expression established between a structure defined in JSON and a database table. Fig. 2 shows an exemplary database table relationship diagram, for the database table relationship diagram of fig. 2, a description rule corresponding to JSON and a database table is established in advance, and the description rule is used to describe the database table relationship diagram, which may specifically use the following JSON structure:
{
"tablelist": [
{
"talbename": "table2",
"primaryKey": "id",
"foreignKey": [
{
"foreignKey": "fk_id1",
"linktoTable": "table1"
},
{
other external keys "
}
],
"field": [
"field 1",
"field 2",
"field 3"
]
},
{
Other watch.
}
]
}
In this embodiment, the following example is given to describe the data request by using the description rule, specifically as follows:
{
"condition": [
[
"table1.name",
"=",
'Zhang san'
],
[
" table2.age",
">",
"18"
]
],
"result": [
" table1.name",
" table2.age"
]
}
The processing flow of the method for operating the database based on the JSON statement is shown in fig. 1, and in the embodiment, the processing steps are as follows:
step 11, creating an expression for querying table relations of SQL sentences according to a database table relational graph described by a JSON description rule and a data request described by the JSON description rule;
specifically, in this embodiment, traversing the database table relationship graph according to the data request is still the database table relationship graph described based on the above-mentioned corresponding description rule of JSON and database table. Extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object.
For example in the description rule description data request with the present implementation described above,
"result": [
" table1.name",
" table2.age"
]
then name and age are the label items of the data request, the database table relational graph is traversed according to the extracted label items, the table objects are matched to the label items, and the expression of the table relation of the query SQL statement is created according to the table objects.
Table relationship refers to the relationship between two tables of tag items related to the current data request, and then the implementation is described above, assuming that in a database for statistical student information, table1 is used as a class information table for recording class information, the class information table relates to name information of students, table2 is used as a student information table for recording student information, and the student information table relates to age information of students, at this time, the database table relationship diagram is traversed, the table objects are matched for the tag items, table1 and table2 relate to the tag items name and age of the current data request, then table1 is the table object of the name tag item, and table2 is the table object of the age tag item, in this embodiment, the expression for creating the table relationship is: link class = class information table, primary key; specifically, in the present embodiment, the description rule is defined as: "primaryKey": id "," forignkey ": fk _ id1",
creating an expression of the table relationship of the query SQL statement from the table object may be represented as: table2.fk _ id1 = table1. id;
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of the SQL statement according to the table object.
Step 12, creating an expression of a screening condition for querying the table relationship of the SQL statement according to the data request described by the JSON description rule and the expression of the table relationship;
extracting a screening condition corresponding to a tag item of a data request according to the data request described by the JSON description rule, wherein the screening condition refers to a screening requirement of the data request, which needs to be met, and based on the above example, in the example of establishing the description rule, it can be known that the screening condition of the data request is that the name is zhang, and the age is greater than 18 years old;
extracting a table object matched with the label item of the data request according to the expression of the table relation; according to the step 11, in the expression according to the table relationship, a table1 class information table is used for recording class information, and a table2 student information table is used for recording student information;
creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item;
then, in this embodiment, the created expression of the screening condition is: class information table, name = 'zhang san' AND student information table, age > 18; specifically, in this embodiment, it can be expressed as:
table1. ", name = 'zhangsan' AND table2.age > 18;
and step 13, generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
For example, as described above, in describing a data request using the description rule,
[
"table1.name",
"=",
'Zhang san'
],
[
" table2.age",
">",
"18"
]
For the request condition of the current request, the converted SQL statement is:
SELECT
table1.`name`,
table2.age
FROM
table1
INNER JOIN table2 ON table2.fk_id1 = table1.id
WHERE
table1. "name = 'Zhang three'
AND table2.age > 18
Example two
The embodiment provides a system based on a JSON statement operation database, and a specific implementation structure of the system is shown in fig. 3, and may specifically include the following modules: a first description module 31, a second description module 32 and an operation module 33; wherein,
the first description module 31: the method is used for creating an expression for querying the table relation of the SQL statement according to a database table relational graph described by a JSON description rule and a data request described by the JSON description rule;
the second description module 32: the method comprises the steps that an expression of a screening condition for querying table relations of SQL sentences is created according to data requests described by JSON description rules and the expression of the table relations;
the operation module 33: the SQL statement operation database is used for generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
The first description module 31 is specifically configured to:
extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object.
The first description module 31 is further specifically configured to:
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of the SQL statement according to the table object.
The second description module 32 is further specifically configured to:
extracting screening conditions corresponding to tag items of the data request according to the data request described by the JSON description rule;
extracting a table object matched with the label item of the data request according to the expression of the table relation;
and creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item.
The system for operating a database based on JSON statements of this embodiment further includes:
the establishing module 30: it is used for: the method comprises the steps of pre-establishing JSON and database table corresponding expression rules as JSON description rules, describing a database table relational graph by using the description rules, and describing a data request by using the description rules.
The specific process of operating the database based on the JSON statement by using the system of the embodiment of the invention is similar to the method embodiment, and is not repeated here.
In summary, the embodiment of the present invention establishes the description rule corresponding to JSON and the database table in advance, uses the description rule to describe the database table relationship diagram, and uses the description rule to describe the data request; creating a table relation of a query SQL statement and an expression of a screening condition through the database table relational graph according to the data request; and generating an SQL statement operation database according to the table relation and the expression of the screening condition. The method for generating the query SQL statement is a once-for-all manner, and zero codes are realized in the compiling process of the query SQL statement under the ideal condition. The development work based on database items with complex business logic can be greatly improved. The working efficiency and the product quality are improved.
Those of ordinary skill in the art will understand that: the figures are merely schematic representations of one embodiment, and the blocks or flow diagrams in the figures are not necessarily required to practice the present invention.
From the above description of the embodiments, it is clear to those skilled in the art that the present invention can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the embodiments or some parts of the embodiments.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for apparatus or system embodiments, since they are substantially similar to method embodiments, they are described in relative terms, as long as they are described in partial descriptions of method embodiments. The above-described embodiments of the apparatus and system are merely illustrative, and the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (6)

1. A method for operating a database based on JSON statements is characterized by comprising the following steps:
creating an expression of table relation of query SQL statement according to a database table relation diagram described by JSON description rule and a data request described by JSON description rule, including:
extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object;
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of SQL sentences according to the table object;
creating an expression of a screening condition for querying the table relation of the SQL statement according to the data request described by the JSON description rule and the expression of the table relation;
and generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
2. The method for operating a database based on JSON statements according to claim 1, wherein the creating an expression of the screening condition for querying the table relationship of the SQL statement according to the data request described by the JSON description rule and the expression of the table relationship comprises:
extracting screening conditions corresponding to tag items of the data request according to the data request described by the JSON description rule;
extracting a table object matched with the label item of the data request according to the expression of the table relation;
and creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item.
3. The method for operating a database based on JSON statements according to any one of claims 1 to 2, wherein the method comprises the following steps:
the method comprises the steps of pre-establishing JSON and database table corresponding expression rules as JSON description rules, describing a database table relational graph by using the description rules, and describing a data request by using the description rules.
4. A system for operating a database based on JSON statements, comprising:
a first description module: the method is used for creating an expression for querying the table relation of the SQL statement according to a database table relational graph described by a JSON description rule and a data request described by the JSON description rule, and comprises the following steps:
extracting a tag item according to the data request, traversing the database table relational graph according to the tag item to obtain a table object of the tag item, and creating an expression for querying the table relation of the SQL statement according to the table object;
when the database table relational graph is traversed according to the data request to obtain a plurality of database table objects, and two database table objects without direct relation exist, extracting a label item according to the data request, traversing the database table relational graph according to the label item to find indirect relation between the two database table objects, obtaining the table object of the label item according to the indirect relation, and creating an expression for inquiring the table relation of SQL sentences according to the table object;
a second description module: the method comprises the steps that an expression of a screening condition for querying table relations of SQL sentences is created according to data requests described by JSON description rules and the expression of the table relations;
an operation module: the SQL statement operation database is used for generating an SQL statement operation database according to the expression of the table relation and the expression of the screening condition.
5. The JSON statement operation database-based system according to claim 4, wherein the second description module is further specifically configured to: extracting screening conditions corresponding to tag items of the data request according to the data request described by the JSON description rule;
extracting a table object matched with the label item of the data request according to the expression of the table relation;
and creating an expression of the screening condition for querying the table relation of the SQL statement according to the screening condition and the table object matched with the tag item.
6. The JSON statement operation database-based system according to any one of claims 4 to 5, further comprising:
a building module: it is used for: the method comprises the steps of pre-establishing JSON and database table corresponding expression rules as JSON description rules, describing a database table relational graph by using the description rules, and describing a data request by using the description rules.
CN201610028786.7A 2016-01-15 2016-01-15 Method and system for operating database based on JSON statement Active CN106980617B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610028786.7A CN106980617B (en) 2016-01-15 2016-01-15 Method and system for operating database based on JSON statement

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610028786.7A CN106980617B (en) 2016-01-15 2016-01-15 Method and system for operating database based on JSON statement

Publications (2)

Publication Number Publication Date
CN106980617A CN106980617A (en) 2017-07-25
CN106980617B true CN106980617B (en) 2021-03-26

Family

ID=59340055

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610028786.7A Active CN106980617B (en) 2016-01-15 2016-01-15 Method and system for operating database based on JSON statement

Country Status (1)

Country Link
CN (1) CN106980617B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109725982B (en) * 2017-10-31 2020-12-11 迈普通信技术股份有限公司 Data object construction method and device
CN112286783A (en) * 2019-07-23 2021-01-29 北京中关村科金技术有限公司 Method and device for generating database insertion statement and performing system test
CN117171203B (en) * 2023-09-04 2024-04-26 申万宏源证券有限公司 SQL automatic generation method and system based on zero code reasoning engine

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030212664A1 (en) * 2002-05-10 2003-11-13 Martin Breining Querying markup language data sources using a relational query processor
CN103092998A (en) * 2013-02-21 2013-05-08 用友软件股份有限公司 Data query system and data query method
CN104657384A (en) * 2013-11-21 2015-05-27 航天信息股份有限公司 Dynamic allocation report data processing method based on two-dimension relationship

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030212664A1 (en) * 2002-05-10 2003-11-13 Martin Breining Querying markup language data sources using a relational query processor
CN103092998A (en) * 2013-02-21 2013-05-08 用友软件股份有限公司 Data query system and data query method
CN104657384A (en) * 2013-11-21 2015-05-27 航天信息股份有限公司 Dynamic allocation report data processing method based on two-dimension relationship

Also Published As

Publication number Publication date
CN106980617A (en) 2017-07-25

Similar Documents

Publication Publication Date Title
CN110908997B (en) Data blood relationship construction method and device, server and readable storage medium
US10671671B2 (en) Supporting tuples in log-based representations of graph databases
US20160012093A1 (en) Test data generation and scale up for database testing using unique common factor sequencing
CN109558166B (en) Code searching method oriented to defect positioning
US9928288B2 (en) Automatic modeling of column and pivot table layout tabular data
US8904352B2 (en) Systems and methods for processing source code during debugging operations
US20180357278A1 (en) Processing aggregate queries in a graph database
US11675690B2 (en) Lineage-driven source code generation for building, testing, deploying, and maintaining data marts and data pipelines
US11720543B2 (en) Enforcing path consistency in graph database path query evaluation
EP2862101B1 (en) Method and a consistency checker for finding data inconsistencies in a data repository
CN106980617B (en) Method and system for operating database based on JSON statement
US9721362B2 (en) Auto-completion of partial line pattern
AU2013201725B2 (en) Foreign key identification in database management systems
TW202004526A (en) Index creating method and apparatus based on NoSQL database of mobile terminal
CN107239539A (en) A kind of user-defined m odel method based on relevant database
WO2018226255A1 (en) Functional equivalence of tuples and edges in graph databases
CN109033157B (en) Complex data retrieval method and system based on user-defined search condition tree
CN105808228A (en) Generation method of dynamic configuration statement
US20190303478A1 (en) Path query evaluation in graph databases
CN115617773A (en) Data migration method, device and system
US20180349443A1 (en) Edge store compression in graph databases
US20180046669A1 (en) Eliminating many-to-many joins between database tables
CN108415994B (en) Network management system report generation method, device and equipment
CN104731597A (en) Method for applying SQL statements to engineering software compiling platform
CN112783980B (en) Data synchronous processing method, device, electronic equipment and computer readable medium

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