CN115114321B - A dynamic query method and system - Google Patents
A dynamic query method and system Download PDFInfo
- Publication number
- CN115114321B CN115114321B CN202210749703.9A CN202210749703A CN115114321B CN 115114321 B CN115114321 B CN 115114321B CN 202210749703 A CN202210749703 A CN 202210749703A CN 115114321 B CN115114321 B CN 115114321B
- Authority
- CN
- China
- Prior art keywords
- query
- mapping
- type
- data source
- target
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
- G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a dynamic query method and a system, which relate to the technical field of information query and comprise the steps of obtaining a local query data source, a query table and a first mapping between data types and query types according to a query data source ID sent by a service party, determining the query types corresponding to fields in the query table according to a mapping model of the data types and the query types and the first mapping, returning the query types and the corresponding query modes to the service party, receiving query conditions set by the service party, converting the query conditions into query sentences of a target database according to the query data source, inserting the query data source and the query table into the query sentences, executing new query sentences to obtain query results, and returning the query results to the service party. The application provides a query system between a service and a database, which can shield the difference of different databases for the service party, so that the code is not required to be modified or redeveloped when the service is changed or the query field is changed.
Description
Technical Field
The present application relates to the field of information query technologies, and in particular, to a dynamic query method and system.
Background
The current query scheme is developed separately for specific business to realize specific query logic, and each time the business changes, the query code needs to be changed or redeveloped.
The implementation mode of targeted development has no big problem when the service fields are few and relatively fixed, and maintainability is higher, but the queries of different services of the same type of data or different display modes of the same service are basically the same, so that a large number of codes with repeated logic exists.
If the business field has frequent change or needs to be dynamically added or changed, the code can be frequently changed and the implementation mode of targeted development is unstable.
Disclosure of Invention
The application provides a dynamic query method, which aims to solve the problem that the query code needs to be frequently changed due to business change in the prior art.
In order to achieve the above purpose, the present application adopts the following technical scheme:
the application discloses a dynamic query method, which comprises the following steps:
Acquiring a query data source, a query table and a first mapping between data types and query types, which are locally and correspondingly stored, according to a query data source ID sent by a service party;
Determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
receiving query conditions set by the service side according to the query type and the query mode, and converting the query conditions into query sentences of a target database according to the query data source;
and inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
Preferably, the obtaining, according to the query data source ID sent by the service party, the query data source, the query table and the first mapping between the data type and the query type, which are locally and correspondingly stored, includes:
Checking a query data source, a query table and a first mapping between data types and query types configured by a service party, if the check is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party.
Preferably, the determining, according to the mapping model of the pre-established data type and the query type and the first mapping, the query type corresponding to each field in the query table includes:
mapping each field in the query table into a corresponding query type according to a pre-established mapping model of the data type and the query type;
and loading the first mapping, and determining whether the query types of the fields in the query table are specified in the first mapping, if so, the first mapping is mainly specified.
Preferably, if so, the step of giving priority to the first mapping further includes:
And deleting a field which does not support the query table when a field which does not support the query table is appointed in the first mapping according to the query type obtained by the mapping model.
Preferably, the converting the query condition into a query statement of a target database according to the query data source includes:
Analyzing the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value;
Determining a target database type according to the query data source, and calling a query converter corresponding to the target database;
And inputting the target field name, the target query type, the target query mode and the target matching value into the query converter and outputting a query statement corresponding to the target database.
Preferably, the step of inserting the query data source and the query table into the query statement and then executing a new query statement to obtain a query result, and returning the query result to the service party includes:
assembling the query table and the query data source into the query statement to obtain a new query statement, and executing the new query statement in the target database to obtain a query result;
and converting the query result into a field name according to the first mapping and mapping model, and returning the field name and a field value corresponding to the field name to the service party.
A dynamic query device, comprising:
the acquisition module is used for acquiring a query data source, a query table and a first mapping between data types and query types which are locally and correspondingly stored according to the query data source ID sent by the service party;
The interaction module is used for determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
The conversion module is used for receiving the query conditions set by the service side according to the query type and the query mode and converting the query conditions into query sentences of a target database according to the query data source;
And the query module is used for inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
Preferably, the system further comprises a verification module, wherein the verification module is used for verifying a query data source, a query table and a first mapping between data types and query types configured by a service party, if verification is passed, the query data source, the query table and the first mapping are saved, and an ID corresponding to the query data source is returned to the service party.
An electronic device comprising memory and a processor, the memory to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement a dynamic query method as claimed in any one of the preceding claims.
A computer readable storage medium storing a computer program which, when executed by a computer, implements a dynamic query method as claimed in any one of the preceding claims.
The invention has the following beneficial effects:
The application provides a stable query system, which is positioned between a service and a database, can shield the difference of different databases for the service party, does not need to modify codes or redevelopment when the service is changed or a query field is changed, and can change related configuration when necessary, thereby being more stable.
Drawings
In order to more clearly illustrate the embodiments of the application or the technical solutions of the prior art, the drawings which are used in the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the description below are only some embodiments of the application, and that other drawings can be obtained according to these drawings without inventive faculty for a person skilled in the art.
FIG. 1 is a first flowchart of a dynamic query method implemented in accordance with embodiment 1 of the present application;
FIG. 2 is a second flowchart of embodiment 2 of the present application for implementing a dynamic query method
FIG. 3 is a schematic diagram of a dynamic query system implemented in accordance with embodiment 3 of the present application;
fig. 4 is a schematic diagram of an electronic device for implementing a dynamic query method according to embodiment 4 of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The terms "first," "second," and the like in the claims and the description of the application, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order, and it is to be understood that the terms so used may be interchanged, if appropriate, merely to describe the manner in which objects of the same nature are distinguished in the embodiments of the application by the description, and furthermore, the terms "comprise" and "have" and any variations thereof are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of elements is not necessarily limited to those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
As shown in fig. 1, a dynamic query method includes the following steps:
S110, acquiring a query data source, a query table and a first mapping between data types and query types, which are locally and correspondingly stored, according to a query data source ID sent by a service party;
S120, determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
S130, receiving query conditions set by the service side according to the query type and the query mode, and converting the query conditions into query sentences of a target database according to the query data source;
S140, inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
The embodiment mainly comprises interaction among the business party, the dynamic query system and the database, wherein the dynamic query system is the main body of the method description, and is also a medium between the business party and the database, and the function of the dynamic query system is to shield the business party from the differences of various databases, so that the business change does not need to re-write codes. The service side configures information such as a query data source, a query table and a first mapping between data types and query types in a dynamic query system, wherein the first mapping is manually configured, after the service side is configured, the dynamic query system checks the configured information, mainly to check whether the data source information is correct, namely whether the dynamic query system can be connected to the query data source, to determine whether the query table exists, whether the configuration format of the first mapping is correct, and the like, after the check is passed, the information such as the query data source, the query table and the first mapping is locally saved, and an ID corresponding to the query data source is returned to the service side, the service side acquires the corresponding query data source, the query table and the first mapping in the dynamic query system according to the query data source ID, returns an error if the acquisition fails, determines all the queryable field information according to the query table, then determines the query types corresponding to the fields according to a pre-established data type and query type mapping model and the first mapping, determines whether the query modes are automatic mapping, and converts the obtained query types and the corresponding query modes into query types, the service side is converted into a query type, the query system is converted into a query type, the query database is converted into a query type, the query system is converted into a query type, the query condition is converted into a query database is required by a query database is set according to a query condition, the query system is converted into a query condition, the query condition is converted into a query database is converted into a query condition, the set query condition is [ data source id=123, name=Zhang three, type=string, operator=eq ], the database to be queried is mysql through the data source during query, the query table is user, the converter equal to the character string of the mysql database, i.e., (type=string, operator=eq), is found, the (name=Zhang three) is transmitted into the converter to be converted into the corresponding mysql query statement [ name=' Zhang three ], therefore, the query condition is input into the corresponding query converter to be converted, the query statement of the target database is obtained, finally, the query data source and the query table are assembled into the query statement to obtain a new query statement, the new query statement is executed, the query result can be obtained, and then the query result is returned to the service side. By the dynamic query system, only the data source information is configured in the early stage, all queries in the later stage can be realized by the dynamic query system, and query codes of service parties are not required to be changed even if the service is changed, the query fields are changed or the query fields are dynamically added.
Example 2
As shown in fig. 2, a dynamic query method includes the following steps:
s210, checking a query data source, a query table and a first mapping between data types and query types configured by a service party, if the check is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party;
S220, acquiring a query data source, a query table and a first mapping between data types and query types, which are locally and correspondingly stored, according to the query data source ID sent by the service party;
S230, mapping each field in the query table into a corresponding query type according to a pre-established mapping model of the data type and the query type;
s240, loading the first mapping, and determining whether query types of all fields in the query table are specified in the first mapping, if so, taking the first mapping as the main rule;
s250, receiving query conditions set by the service side according to the query type and the query mode, and analyzing the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value;
S260, determining a target database type according to the query data source, and calling a query converter corresponding to the target database;
s270, inputting the target field name, the target query type, the target query mode and the target matching value into the query converter and outputting a query statement corresponding to the target database;
S280, inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
According to embodiment 2, the mapping relationship between the data type and the query type is divided into two types, one type is a first mapping configured manually, the first mapping mainly comprises three mapping relationships, the first mapping relationship is a mapping relationship of special data, such as 0 and 1 stored in a database, and in page query condition rendering, a drop-down frame or a single selection frame to be rendered into male and female correspondingly; the method comprises the steps of storing personnel information in a database, inquiring according to personnel names, wherein the personnel information is stored in the database, the personnel information is only required to be inquired, the field information which is not required to be displayed, such as creation time and modification time in the data, is not required to be rendered in page inquiry conditions, information (name, unit price, picture and the like) of commodities in the database is not required to be displayed in inquiry, the third step is that no inquiry information which is required to be supported in the data table, such as the number of the commodities in an order is not calculated in advance and stored in the data table, the mapping relation can be designated in a manual configuration mode, the other step is that a pre-established basic data mapping model belongs to automatic mapping, and the fields in corresponding data such as the inquiry table are mapped according to data types (numbers, characters, time, sets and the like) in combination with application scenes (addresses, organization personnel architecture and the like), inquiry types (values, texts, time, addresses and the like), each inquiry type can correspond to one or more inquiry modes (values, texts, time and the like), the number of the corresponding inquiry types can be more than one or more inquiry modes (values and the search, the number of the values are more than or the values, the fuzzy, the values are all the values, the ranges are less than the values, the ranges of the values are all the values, and the values are all the values and contain the values and the values are all the values and the values None, etc.).
After acquiring the corresponding query data source, the query table and the first mapping between the data types and the query types according to the query data source ID, determining to acquire the structure information of the query table according to the information of the query table, acquiring all the field information which can be queried in the query table, including the data types corresponding to each field, inputting the corresponding data types into a pre-established mapping model of the data types and the query types to acquire the query types supported by each field, searching the first mapping at the same time, determining whether the first mapping configures each field or not, if the step is not skipped directly, if the mapping relation of a certain field is appointed in the first mapping, the first mapping is mainly appointed, and if the first mapping definitely indicates that the query of the field is not supported, deleting the query types acquired by the field according to the mapping model, and not querying.
The finally obtained query type and the corresponding query mode are returned to the service party, the service party sets query conditions according to the query type and the query mode and sends the query conditions to the dynamic query system, the dynamic query system analyzes the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value, wherein the matching value refers to a specific value to be queried, such as data of which the query name is Zhang San, and the query conditions comprise: the field name (name represents name), the query type code (string represents character string), the query mode code (eq represents equal), the matching value (Zhang three), the database type to be queried is obtained according to the query data source, namely the target database type, the corresponding query converter is called according to the target database type, the query converter is used for converting the fields, the matching value, the query type and the query mode of the query to be queried into the corresponding query converter to obtain the query statement corresponding to the target database, then the query statement is assembled according to the query data source and the query table to obtain the complete query statement, the complete query statement is executed in the target database to obtain the query result, the dynamic query system is used for converting the query result into the format of (field name: field value) and then returning the query result to the service party, the returned results of different database queries are possibly inconsistent, the dynamic query system is used for unifying the formats of all the query results (field name: field value), the conversion is mainly the conversion of the data types, for example, the database stores 0 and 1, the results returned by men and women hope are returned when the query is performed, when in conversion, whether conversion is needed is judged, if conversion is needed, an identification (conversion=true) to be converted is added in a query condition, a corresponding mapping relation is obtained through a query data source ID transmitted during query, and a data type and a conversion value corresponding to the query result are determined according to the mapping relation (for example, the corresponding value is converted into a meaning specifically represented by the corresponding value according to a special mapping relation (male 0/female 1)).
Through the dynamic query system, as long as the data source information is configured in the early stage, all queries in the later stage can be realized through the dynamic query system, the service party query code is not required to be changed even if service change, query field change or dynamic addition of query fields and the like occur, only the mapping configuration is required to be changed, if the query requirement of special data which is not contained in the dynamic query exists, only one query type and a corresponding query mode are required to be added in the dynamic form according to a designated mode, and the data is designated as a new query type in the mapping configuration, so that the stability is better.
Example 3
As shown in fig. 3, a dynamic query system includes a verification module, an acquisition module, an interaction module, a conversion module, and a query module:
And the verification module is used for verifying the query data source, the query table and the first mapping between the data types and the query types configured by the service party, storing the query data source, the query table and the first mapping if the verification is passed, and returning the ID corresponding to the query data source to the service party.
The acquisition module is used for acquiring a query data source, a query table and a first mapping between data types and query types, which are locally and correspondingly stored, according to the query data source ID sent by the service party;
The interaction module is used for determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
The conversion module is used for receiving the query conditions set by the service side according to the query type and the query mode and converting the query conditions into query sentences of a target database according to the query data source;
the query module is used for inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
Example 4
As shown in fig. 4, an electronic device includes a memory 401 and a processor 402, where the memory 401 is configured to store one or more computer instructions, and the one or more computer instructions are executed by the processor 402 to implement a dynamic query method as described above.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the electronic device described above may refer to the corresponding process in the foregoing method embodiment, which is not described herein again.
A computer readable storage medium storing a computer program which, when executed by a computer, causes the computer to implement a dynamic query method as described above.
By way of example, a computer program may be divided into one or more modules/units stored in the memory 401 and executed by the processor 402 and completed by the input interface 405 and the output interface 406 for data I/O interface transmission to complete the present invention, and one or more modules/units may be a series of computer program instruction segments capable of accomplishing specific functions for describing the execution of the computer program in a computer device.
The computer device may be a desktop computer, a notebook computer, a palm computer, a cloud server, or the like. The computer device may include, but is not limited to, a memory 401, a processor 402, it will be appreciated by those skilled in the art that the present embodiment is merely an example of a computer device and is not limiting of a computer device, may include more or fewer components, or may combine certain components, or different components, e.g., a computer device may also include an input 407, a network access device, a bus, etc.
The Processor 402 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors 402, digital signal processors 402 (DIGITAL SIGNAL Processor, DSP), application SPECIFIC INTEGRATED Circuit (ASIC), off-the-shelf Programmable gate array (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. The general purpose processor 402 may be a microprocessor 402 or the processor 402 may be any conventional processor 402 or the like.
The memory 401 may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. The memory 401 may also be an external storage device of the computer device, for example, a plug-in hard disk, a smart memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD) or the like, and further, the memory 401 may also include an internal storage unit of the computer device and an external storage device, the memory 401 may be used to store a computer program and other programs and data required by the computer device, the memory 401 may also be used to temporarily store the computer program and other programs and data in the output device 408, and the foregoing storage media include a U disk, a removable hard disk, a read-only memory ROM403, a random access memory RAM404, a disk or an optical disk and other various media that can store program codes.
The foregoing is merely illustrative of specific embodiments of the present invention, and the scope of the present invention is not limited thereto, but any changes or substitutions within the technical scope of the present invention should be covered by 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 (9)
1. A dynamic query method, comprising the steps of:
Acquiring a query data source, a query table and a first mapping between manually configured data types and query types, which are locally and correspondingly stored, according to a query data source ID sent by a service party;
Determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
receiving query conditions set by the service side according to the query type and the query mode, and converting the query conditions into query sentences of a target database according to the query data source;
inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party;
Determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, wherein the method comprises the following steps:
Mapping fields in the lookup table into query types including numerical values, texts, time and addresses according to the preset mapping model of the data types and the query types and the first mapping, wherein the data types include numbers, characters, time and aggregate combined application scenes including address and organization personnel structures, and the query display modes include drop-down boxes, search boxes and time selectors;
The step of converting the query condition into a query statement of a target database according to the query data source comprises the following steps:
Analyzing the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value;
Determining a target database type according to the query data source, and calling a query converter corresponding to the target database;
And inputting the target field name, the target query type, the target query mode and the target matching value into the query converter and outputting a query statement corresponding to the target database.
2. The method of claim 1, wherein the obtaining the query data source, the query table, and the first mapping between the data type and the query type according to the query data source ID sent by the service party includes:
Checking a query data source, a query table and a first mapping between data types and query types configured by a service party, if the check is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party.
3. The method according to claim 1, wherein the determining the query type corresponding to each field in the query table according to the mapping model of the pre-established data type and the query type and the first mapping includes:
mapping each field in the query table into a corresponding query type according to a pre-established mapping model of the data type and the query type;
and loading the first mapping, and determining whether the query types of the fields in the query table are specified in the first mapping, if so, the first mapping is mainly specified.
4. A method of dynamic query as claimed in claim 3, wherein if so, the first mapping specification is dominant further comprising:
And deleting a field which does not support the query table when a field which does not support the query table is appointed in the first mapping according to the query type obtained by the mapping model.
5. The method according to claim 1, wherein said inserting the query data source and the query table into the query statement and then executing a new query statement to obtain a query result, and returning the query result to the service party, comprises:
assembling the query table and the query data source into the query statement to obtain a new query statement, and executing the new query statement in the target database to obtain a query result;
and converting the query result into a field name according to the first mapping and mapping model, and returning the field name and a field value corresponding to the field name to the service party.
6. A dynamic query system, comprising:
the acquisition module is used for acquiring a query data source, a query table and a first mapping between data types and query types which are locally and correspondingly stored according to the query data source ID sent by the service party;
The interaction module is used for determining the query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
The conversion module is used for receiving the query conditions set by the service side according to the query type and the query mode and converting the query conditions into query sentences of a target database according to the query data source;
the query module is used for inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party;
the determining, by the interaction module, the query type corresponding to each field in the query table according to a mapping model of a pre-established data type and a query type and the first mapping, includes:
Mapping fields in the lookup table into query types including numerical values, texts, time and addresses according to the preset mapping model of the data types and the query types and the first mapping, wherein the data types include numbers, characters, time and aggregate combined application scenes including address and organization personnel structures, and the query display modes include drop-down boxes, search boxes and time selectors;
the conversion module converts the query condition into a query statement of a target database according to the query data source, and comprises the following steps:
Analyzing the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value;
Determining a target database type according to the query data source, and calling a query converter corresponding to the target database;
And inputting the target field name, the target query type, the target query mode and the target matching value into the query converter and outputting a query statement corresponding to the target database.
7. The system of claim 6, further comprising a verification module configured to verify a query data source, a query table, and a first mapping between data types and query types configured by a service party, and if the verification is passed, save the query data source, the query table, and the first mapping, and return an ID corresponding to the query data source to the service party.
8. An electronic device comprising a memory and a processor, the memory configured to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement a dynamic query method as claimed in any one of claims 1 to 5.
9. A computer readable storage medium storing a computer program, wherein the computer program causes a computer to execute a dynamic query method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210749703.9A CN115114321B (en) | 2022-06-28 | 2022-06-28 | A dynamic query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210749703.9A CN115114321B (en) | 2022-06-28 | 2022-06-28 | A dynamic query method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115114321A CN115114321A (en) | 2022-09-27 |
| CN115114321B true CN115114321B (en) | 2025-02-11 |
Family
ID=83329980
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210749703.9A Active CN115114321B (en) | 2022-06-28 | 2022-06-28 | A dynamic query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115114321B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116204189A (en) * | 2022-12-29 | 2023-06-02 | 中国邮政储蓄银行股份有限公司 | Data processing method based on sql, server and electronic equipment |
| CN116414838A (en) * | 2023-04-04 | 2023-07-11 | 浙江太美医疗科技股份有限公司 | Data query method, data storage method, data query device and computer equipment |
| CN119293221A (en) * | 2023-06-30 | 2025-01-10 | 中兴通讯股份有限公司 | Inventory query method, terminal device and storage medium |
| CN117891847A (en) * | 2024-03-18 | 2024-04-16 | 辽宁牧龙科技有限公司 | Data query device and method based on data center |
| CN118820348B (en) * | 2024-09-19 | 2024-11-26 | 四川国蓝中天环境科技集团有限公司 | Multi-source heterogeneous data routing and management method based on ecological environment data center |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114416776A (en) * | 2021-12-28 | 2022-04-29 | 航天信息股份有限公司 | A Data Custom Query Statistics Method |
| CN114547076A (en) * | 2022-02-21 | 2022-05-27 | 京东方科技集团股份有限公司 | Data processing method and data processing system |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000090098A (en) * | 1998-09-09 | 2000-03-31 | Hitachi Ltd | Database query method, device for executing the method, and medium recording processing program for the method |
| US7584178B2 (en) * | 2006-04-20 | 2009-09-01 | International Business Machines Corporation | Query condition building using predefined query objects |
| CN109062952B (en) * | 2018-06-22 | 2022-06-03 | 北京奇艺世纪科技有限公司 | Data query method and device and electronic equipment |
| CN111914135B (en) * | 2020-07-24 | 2024-08-13 | 平安证券股份有限公司 | Data query method, device, electronic equipment and storage medium |
| CN112163000B (en) * | 2020-08-31 | 2025-03-25 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN113760948B (en) * | 2021-01-29 | 2025-02-21 | 北京沃东天骏信息技术有限公司 | Data query method and device |
| CN114036178A (en) * | 2021-11-05 | 2022-02-11 | 深圳创维智慧科技有限公司 | Service interface generation method, device, computer and readable storage medium |
-
2022
- 2022-06-28 CN CN202210749703.9A patent/CN115114321B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114416776A (en) * | 2021-12-28 | 2022-04-29 | 航天信息股份有限公司 | A Data Custom Query Statistics Method |
| CN114547076A (en) * | 2022-02-21 | 2022-05-27 | 京东方科技集团股份有限公司 | Data processing method and data processing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115114321A (en) | 2022-09-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115114321B (en) | A dynamic query method and system | |
| CN110162544B (en) | Heterogeneous data source data acquisition method and device | |
| CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN111797073B (en) | Database management method, electronic device, and computer-readable storage medium | |
| CN110737689B (en) | Data standard compliance detection method, device, system and storage medium | |
| CN107526806A (en) | The conversion method and device of data | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN109726295A (en) | Brand knowledge graph display method, device, graph server and storage medium | |
| CN113961569B (en) | Medical data ETL task synchronization method and device | |
| CN113469284B (en) | Data analysis method, device and storage medium | |
| CN119179716A (en) | Information query method, system, device, equipment, storage medium and program product | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN112052254A (en) | Data packaging method, electronic device and storage medium | |
| CN111125216A (en) | Method and device for importing data into Phoenix | |
| CN109800273A (en) | A kind of method, apparatus of data processing, computer storage medium and terminal | |
| CN113468258B (en) | Heterogeneous data conversion method, heterogeneous data conversion device and storage medium | |
| CN116257673A (en) | Data query method, device, equipment and storage medium based on ElasticSearch | |
| CN115357628A (en) | A data report generation method, device, computer equipment and storage medium | |
| CN115098154A (en) | Method and device for managing dependency relationship between services and electronic equipment | |
| CN110334328B (en) | Automatic generation method and device for object list based on machine learning | |
| CN114358596A (en) | Index calculation method and device | |
| CN112445811A (en) | Data service method, device, storage medium and component based on SQL configuration | |
| CN110647568A (en) | Method and device for converting graph database data into programming language data | |
| CN112052239A (en) | Data packaging method, electronic device and storage 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 |