CN112506946B - Service data query method, device, equipment and storage medium - Google Patents
Service data query method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112506946B CN112506946B CN202011396541.2A CN202011396541A CN112506946B CN 112506946 B CN112506946 B CN 112506946B CN 202011396541 A CN202011396541 A CN 202011396541A CN 112506946 B CN112506946 B CN 112506946B
- Authority
- CN
- China
- Prior art keywords
- service
- field
- data
- queried
- field information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000012216 screening Methods 0.000 claims abstract description 14
- 230000004044 response Effects 0.000 claims description 17
- 230000005856 abnormality Effects 0.000 claims description 5
- 238000001914 filtration Methods 0.000 claims description 4
- 238000009877 rendering Methods 0.000 claims description 4
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000012545 processing Methods 0.000 description 13
- 238000010586 diagram Methods 0.000 description 6
- 230000008676 import Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24558—Binary matching operations
- G06F16/2456—Join operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
Abstract
The invention relates to the technical field of big data, and discloses a service data query method, device, equipment and storage medium, which are used for improving data query efficiency. The service data query method comprises the following steps: acquiring a plurality of service table names and a plurality of service field information corresponding to each service table; generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page; screening a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried; determining a data table name to be queried from a plurality of service table names, and sending the data table name to be queried and the field information to be queried to a target server so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquiring target service data according to the structured query language statement. In addition, the invention also relates to a blockchain technology, and a plurality of service field information can be stored in a blockchain node.
Description
Technical Field
The present invention relates to the field of sequential query in big data technologies, and in particular, to a method, an apparatus, a device, and a storage medium for querying service data.
Background
A federated query is a result set that may combine multiple similar select queries, i.e., append one table to another, thereby enabling the queries of both tables to be combined together. The general query service needs to perform joint query on multiple fields and multiple tables to obtain corresponding data.
In the prior art, multiple fields are spliced, whether field values exist or not is judged, and the fields are queried as screening conditions, so that maintenance of newly added fields, deleted fields and modified fields is time-consuming. And the table used for inquiring needs to be associated with inquiry splicing sentences in a plurality of tables in advance, so that the inquiry speed is slow, and the number of returned fields is relatively large, so that the problems of low data processing speed and low data processing efficiency are solved.
Disclosure of Invention
The invention provides a service data query method, a device, equipment and a storage medium, which are used for improving data processing efficiency and data query efficiency.
In order to achieve the above object, a first aspect of the present invention provides a service data query method, including: acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description; acquiring tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page; receiving a data frame operation instruction, and screening a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; determining a data table name to be queried from the plurality of service table names according to the field information to be queried, and sending the data table name to be queried and the field information to be queried to a target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement.
Optionally, in a first implementation manner of the first aspect of the present invention, the obtaining and caching a plurality of service table names and a plurality of service field information corresponding to each service table, where each service field information includes a field name, a field type, and a field description includes: sending a service table information acquisition request to a target server to obtain response data returned by the target server; extracting a plurality of service table names and a plurality of service field information corresponding to each service table from the response data according to a preset association rule, wherein each service field information comprises a field name, a field type and a field description, and the preset association rule is a product code, a product name and an enterprise name; and storing the names of the service tables and the corresponding service field information of each service table into a memory database.
Optionally, in a second implementation manner of the first aspect of the present invention, the obtaining tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page includes: sending a tag tree configuration information acquisition request to a target server to obtain tag tree data returned by the target server; converting each label in the label tree data into each node in a document object model tree, adding cascading style sheet information to each node, and traversing and rendering the document object model tree to obtain a target page; and receiving each piece of service field information dragged by the user in the target page, and generating a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information.
Optionally, in a third implementation manner of the first aspect of the present invention, the receiving a data frame operation instruction, and filtering a content data frame corresponding to each service field information according to the data frame operation instruction, to obtain field information to be queried, where the field information to be queried includes a field name to be queried, a field relationship, and a field search rule, includes: receiving a data frame operation instruction, and analyzing the data frame operation instruction to obtain a data frame identification value; and carrying out data matching on the content data frame corresponding to each service field information according to the data frame identification value to obtain a field name to be queried, a field relation and a field searching rule.
Optionally, in a fourth implementation manner of the first aspect of the present invention, the determining a to-be-queried data table name from the plurality of service table names according to the to-be-queried field information, and sending the to-be-queried data table name and the to-be-queried field information to a target server, so that the target server splices the to-be-queried data table name and the to-be-queried field information into a structured query language statement, and obtains target service data according to the structured query language statement, including: determining a data table name to be queried from the plurality of service table names according to the field information to be queried, and encrypting the data table name to be queried, the field relation and the field searching rule according to a preset key to obtain encrypted data; sending the encrypted data to a target server through an asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determining a query result according to the structured query language statement; and receiving the query result through the asynchronous response target server, decrypting the query result according to the preset key to obtain target service data, and reformatting the target service data for asynchronous updating and displaying.
Optionally, in a fifth implementation manner of the first aspect of the present invention, before the acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, each service field information includes a field name, a field type and a field description, the service data query method includes: acquiring a to-be-imported service file corresponding to a preset service, and comparing the size of the to-be-imported file with a preset minimum threshold value and a preset maximum threshold value respectively; if the size of the file to be imported is smaller than a preset minimum threshold value or the size of the file to be imported is larger than a preset maximum threshold value, generating and displaying prompt information containing file abnormality; and if the size of the file to be imported is larger than or equal to a preset minimum threshold value and the size of the file to be imported is smaller than or equal to a preset maximum threshold value, acquiring a preset service identifier, and importing the file to be imported into a target server according to the preset service identifier.
Optionally, in a sixth implementation manner of the first aspect of the present invention, after determining a to-be-queried data table name from the plurality of service table names according to the to-be-queried field information, and sending the to-be-queried data table name and the to-be-queried field information to a target server, so that the target server splices the to-be-queried data table name and the to-be-queried field information into a structured query language statement, and obtains target service data according to the structured query language statement, the service data query method further includes: sending a service field updating request to the target server, so that the target server updates corresponding service field information according to the service field updating request to obtain an updating result, wherein the service field updating request is used for indicating to add, modify or delete the service field information in any one preset service table; and receiving an updating result sent by the target server, and changing a plurality of service field information corresponding to a preset service table in a memory database according to the updating result.
The second aspect of the present invention provides a service data query device, including: the acquisition module is used for acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description; the generating module is used for acquiring tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page; the screening module is used for receiving the data frame operation instruction, screening the content data frame corresponding to each service field information according to the data frame operation instruction, and obtaining the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and the query module is used for determining the data table name to be queried from the plurality of service table names according to the field information to be queried, and sending the data table name to be queried and the field information to be queried to a target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement.
Optionally, in a first implementation manner of the second aspect of the present invention, the acquiring module is specifically configured to: sending a service table information acquisition request to a target server to obtain response data returned by the target server; extracting a plurality of service table names and a plurality of service field information corresponding to each service table from the response data according to a preset association rule, wherein each service field information comprises a field name, a field type and a field description, and the preset association rule is a product code, a product name and an enterprise name; and storing the service table names and the service field information corresponding to each service table into a memory database.
Optionally, in a second implementation manner of the second aspect of the present invention, the generating module is specifically configured to: sending a tag tree configuration information acquisition request to a target server to obtain tag tree data returned by the target server; converting each label in the label tree data into each node in a document object model tree, adding cascading style sheet information to each node, and traversing and rendering the document object model tree to obtain a target page; and receiving each piece of service field information dragged by the user in the target page, and generating a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information.
Optionally, in a third implementation manner of the second aspect of the present invention, the screening module is specifically configured to: receiving a data frame operation instruction, and analyzing the data frame operation instruction to obtain a data frame identification value; and carrying out data matching on the content data frame corresponding to each service field information according to the data frame identification value to obtain a field name to be queried, a field relation and a field searching rule.
Optionally, in a fourth implementation manner of the second aspect of the present invention, the query module is specifically configured to: determining a data table name to be queried from the plurality of service table names according to the field information to be queried, and encrypting the data table name to be queried, the field relation and the field searching rule according to a preset key to obtain encrypted data; sending the encrypted data to a target server through an asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determining a query result according to the structured query language statement; and receiving the query result through the asynchronous response target server, decrypting the query result according to the preset key to obtain target service data, and reformatting the target service data for asynchronous updating and displaying.
Optionally, in a fifth implementation manner of the second aspect of the present invention, the service data query device further includes: the comparison module is used for acquiring a to-be-imported service file corresponding to a preset service, and comparing the size of the to-be-imported file with a preset minimum threshold value and a preset maximum threshold value respectively; the display module is used for generating and displaying prompt information containing file abnormality if the size of the file to be imported is smaller than a preset minimum threshold value or the size of the file to be imported is larger than a preset maximum threshold value; and the importing module is used for acquiring a preset service identifier and importing the file to be imported into the target server according to the preset service identifier if the size of the file to be imported is larger than or equal to a preset minimum threshold value and the size of the file to be imported is smaller than or equal to a preset maximum threshold value.
Optionally, in a sixth implementation manner of the second aspect of the present invention, the service data query device further includes: the sending module is used for sending a service field updating request to the target server so that the target server updates corresponding service field information according to the service field updating request to obtain an updating result, wherein the service field updating request is used for indicating to add, modify or delete the service field information in any one preset service table; and the change module is used for receiving the update result sent by the target server and changing a plurality of service field information corresponding to a preset service table in the memory database according to the update result.
A third aspect of the present invention provides a service data query device, including: a memory and at least one processor, the memory having instructions stored therein; the at least one processor invokes the instructions in the memory to cause the service data querying device to perform the service data querying method described above.
A fourth aspect of the present invention provides a computer readable storage medium having instructions stored therein which, when run on a computer, cause the computer to perform the business data query method described above.
In the technical scheme provided by the invention, a plurality of service table names and a plurality of service field information corresponding to each service table are acquired and cached, and each service field information comprises a field name, a field type and a field description; acquiring tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page; receiving a data frame operation instruction, and screening a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; determining a data table name to be queried from the plurality of service table names according to the field information to be queried, and sending the data table name to be queried and the field information to be queried to a target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement. In the embodiment of the invention, the corresponding content data frame is set for each service field information, and the content data frame corresponding to each service field information is screened to obtain the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and sending the data table name to be queried and the field information to be queried to a target server according to the actual service requirement, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement, thereby improving the data processing efficiency and the data query efficiency.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a service data query method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of another embodiment of a service data query method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an embodiment of a service data query device according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of another embodiment of a service data query device according to an embodiment of the present invention;
fig. 5 is a schematic diagram of an embodiment of a service data query device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a service data query method, a device, equipment and a storage medium, which are used for dynamically setting and sending field information to be queried and table names of data to be queried to a target server so that the target server can splice the table names of the data to be queried and the field information to be queried into a structured query language statement, and acquire target service data according to the structured query language statement, thereby improving data processing efficiency and data query efficiency.
The terms "first," "second," "third," "fourth" and the like in the description and in the claims and in the above drawings, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus.
For easy understanding, the following describes a specific flow of an embodiment of the present invention, referring to fig. 1, and one embodiment of a service data query method in the embodiment of the present invention includes:
101. and acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description.
The multiple service field information corresponding to each service table may include data table fields such as an insurance service data table, a loan financing service data table, an investment financing service data table, a credit card service data table, a customer management service data table, a company management service data table, a channel attribute service data table, a channel area service data table, a product management service data table, a product association service data table and the like. And then, the terminal caches the queried data according to a preset association relation rule, namely the service table name, the field type and the field description. The field description may also store attribute information of the corresponding field, such as whether the field is selectable by a pull-down, a list of standard values of the pull-down selection, whether the field is selectable by multiple options, and prompt information.
Further, the plurality of service field information is stored in a blockchain database, and is not limited herein.
It can be understood that the execution body of the present invention may be a service data query device, and may also be a terminal or a server, which is not limited herein. The embodiment of the invention is described by taking the terminal as an execution main body as an example.
102. And acquiring tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page.
It should be noted that, the HTML tag of the hypertext markup language is generally called an HTML tag, and the structure of the target web page is a document object model tree, that is, a tag tree, and each document object model tree includes a plurality of element nodes, for example, a text node, an attribute node, and an annotation node, and data required for forming the element nodes is tag tree data.
Specifically, when the terminal loads the target page, configuration information (namely tag tree data) of the tag tree is read from the memory database, the terminal renders the tag tree data into a module for inquiring in the target page, drags and adds the tag tree in the target page, and the terminal obtains a content data frame corresponding to each service field information setting according to field description (for example, a standard value selected by drop-down, whether the tag tree can be accurately matched, fuzzy matched, whether multi-standard value inquiry can be filled or interval inquiry can be carried out), field type (for example, numerical value type, character type or non-type) and whether the tag tree data has prompt information. The in-memory database may be a remote service dictionary redis, a map, or other types of databases, which is not limited herein.
103. And receiving a data frame operation instruction, screening a content data frame corresponding to each service field information according to the data frame operation instruction, and obtaining field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule.
That is, the terminal receives various types of operations of the user on the content data frame, such as a pull-down operation, an input operation, a single-selection operation or multiple-selection operation, and the like, and correspondingly screens and determines the content data frame corresponding to each service field information according to the data frame operation instruction of the user to obtain field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relationship and a field searching rule. The field names, the field relations and the field searching rules to be queried are used for indicating the splicing relations of the structured query language sentences. It can be understood that the terminal adopts a screening mode to more accurately query the field and the service table to be queried, so that the query range is reduced, and the data processing speed and the data processing efficiency are improved.
104. And determining the data table name to be queried from the plurality of service table names according to the field information to be queried, and sending the data table name to be queried and the field information to be queried to the target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquiring target service data according to the structured query language statement.
That is, the terminal matches the to-be-queried field information, the field relation (for example, and/or and does not contain 3 relations), and the field searching rule (for example, an accurate query rule, a fuzzy query rule, an interval query rule, a multi-value accurate query rule or a multi-value fuzzy query rule) according to the label value required to be queried by the user dragging, screens the to-be-queried data table name from a plurality of service table names according to the to-be-queried field information, and transmits the to-be-queried data table name, the field relation and the field searching rule to the target server, so that the target server adopts the structured query language sql grammar to splice according to the to-be-queried data table name, the field relation and the field searching rule to obtain the structured query language statement, and executes the structured query language statement to obtain the target service data.
It can be understood that the association relationship between the service tables is dynamic, and the terminal can set multiple query modes according to the actual service requirements, for example, fuzzy query, accurate query, multi-option query or interval query, etc. The target server can orderly and associatively inquire the service table selected by the terminal according to the requirement, can convert characters transmitted by the terminal into a corresponding format in the service table, and splice the service table into sql sentences for data inquiry, so that the data operation loss is reduced, and the sql sentence splicing and operation speed is improved.
In the embodiment of the invention, the corresponding content data frame is set for each service field information, and the content data frame corresponding to each service field information is screened to obtain the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and sending the data table name to be queried and the field information to be queried to a target server according to the actual service requirement, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement, thereby improving the data processing efficiency and the data query efficiency.
Referring to fig. 2, another embodiment of a service data query method in an embodiment of the present invention includes:
201. and acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description.
That is, the terminal sets a service table information acquisition request according to an actual service requirement, wherein the service table information acquisition request includes service identifiers and different service table information corresponding to different service identifiers. Optionally, the terminal sends a service table information acquisition request to the target server to obtain response data returned by the target server, wherein the response data is encapsulated according to a preset data format; the terminal extracts a plurality of service table names and a plurality of service field information corresponding to each service table from response data according to a preset association rule, wherein each service field information comprises a field name, a field type and a field description, and the preset association rule is a product code, a product name and an enterprise name; and the terminal stores the names of the service tables and the corresponding service field information of each service table into the memory database. For example, the plurality of service field information includes a name field name, an age field age, a status field status, and the like; the field type and the status field status of the age are integer int; the description information of status includes some attributes of this field, such as whether a drop-down selection is possible, a list of drop-down selection criteria values, whether multiple selections or hints are possible, etc.
Further, the terminal may also generate corresponding service data before the terminal queries the service data. Optionally, the terminal acquires a service file to be imported corresponding to the preset service, and compares the size of the file to be imported with a preset minimum threshold and a preset maximum threshold respectively; if the size of the file to be imported is smaller than a preset minimum threshold value or the size of the file to be imported is larger than a preset maximum threshold value, the terminal generates and displays prompt information containing file abnormality; if the size of the file to be imported is larger than or equal to a preset minimum threshold value and the size of the file to be imported is smaller than or equal to a preset maximum threshold value, the terminal acquires a preset service identifier, and imports the file to be imported into a target server according to the preset service identifier, and specifically, the target server updates the file to be imported into a relational database through preset structural query language configuration information. That is, the terminal verifies the uploaded file size and file format through the preset function of the script language js. For example, the file size of the electronic form file without any content is 10.1kb, the terminal determines that the content of the file smaller than 10.1kb is null (for example, 0 kb), and the terminal may define that the file size of the imported electronic form file is 10M at maximum, or may be other values, and is not limited herein. Then, the terminal verifies the uploading format of the file, further, the terminal converts the file name into a lowercase character string (which may also be a uppercase character string, and is not limited in detail herein), verifies whether the suffix name of the file name is consistent with the preset suffix name, for example, "xlsx" or "xls", or "word", and the like, and is not limited in detail herein.
202. And acquiring tag tree data, generating a target page based on the tag tree data, and setting a corresponding content data frame for each service field information in the target page.
The terminal loads tag tree data from the memory database, the tag tree data are used for generating a target page, the target page is used for loading and dragging each service field information, and different types of content data frames are set according to the field name, the field type and the field description of each service field information.
Optionally, the terminal sends a tag tree configuration information acquisition request to the target server to obtain tag tree data returned by the target server; the terminal converts each label in the label tree data into each node in the document object model tree, adds cascading style sheet information to each node, and traverses the rendered document object model tree to obtain a target page, namely, the label tree data and each node in the document object model tree have a corresponding relation; and the terminal receives each piece of service field information dragged by the user in the target page, and generates a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information.
203. And receiving a data frame operation instruction, screening a content data frame corresponding to each service field information according to the data frame operation instruction, and obtaining field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule.
The field information to be queried is field information screened according to actual service requirements, and the data range of the field information belongs to the field information in the content data frame generated by dragging in the step 202. The field name to be queried is used for indicating the name of the service field to be queried, the relation among the fields comprises and/or does not contain 3 relations, and the field searching rule comprises an accurate query rule, a fuzzy query rule, an interval query rule, a multi-value accurate query rule and a multi-value fuzzy query. Optionally, the terminal receives the data frame operation instruction, analyzes the data frame operation instruction, and obtains a data frame identification value; and the terminal performs data matching on the content data frame corresponding to each service field information according to the data frame identification value to obtain the field name to be queried, the field relation and the field searching rule.
204. And determining the data table name to be queried from the plurality of service table names according to the field information to be queried, and sending the data table name to be queried and the field information to be queried to the target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquiring target service data according to the structured query language statement.
Further, the terminal can determine the name of the data table to be queried from a plurality of service table names according to the field name to be queried and the relationship between the field name to be queried and the service table. For example, the terminal screens the data table names a and b to be queried from the service tables a, b and c according to the field names a.name, b.name and a.age to be queried.
Optionally, the terminal determines the data table name to be queried from the plurality of service table names according to the field information to be queried, encrypts the data table name to be queried, the field relation and the field searching rule according to the preset key, and obtains encrypted data; the terminal sends the encrypted data to the target server through the asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determines a query result according to the structured query language statement; the terminal receives the query result through the asynchronous response target server, decrypts the query result according to the preset key to obtain target service data, reformats the target service data to be updated and displayed asynchronously, and improves the safety of service data transmission.
205. And sending a service field updating request to the target server so that the target server updates the corresponding service field information according to the service field updating request to obtain an updating result, wherein the service field updating request is used for indicating to add, modify or delete the service field information in any one preset service table.
Specifically, the terminal acquires an operation type, a target service data table name, a service field name and a service field value, encapsulates the operation type, the target service data table name, the service field name and the service field value into a service field update request, sends the service field update request to a target server through an asynchronous request piece, and generates different structured operation sentences according to the operation type, the target service data table name, the service field name and the service field value by the target server, executes the structured operation sentences, updates the corresponding service field and obtains an update result. The service field update request is used for indicating to add, modify or delete the service field information in any one preset service table. Accordingly, the operation type includes an add type (e.g., add), a modify type (e.g., update), or a delete type (e.g., delete).
206. And receiving an updating result sent by the target server, and changing a plurality of service field information corresponding to the preset service table in the memory database according to the updating result.
Wherein the update result includes update success and update failure. Specifically, the terminal acquires and analyzes an updating result sent by the target server to obtain a status code and corresponding description information; when the status code is a preset code value, the terminal determines that the update result is successful, where the status code may be 200, 202, etc., or may be logic true or 1, and the present application is not limited. And then, the terminal performs adding, modifying or deleting operation on the plurality of service field information corresponding to the preset service table in the memory database according to the updating result. Further, when the status code is not the preset code value, the terminal determines that the update result is the update failure, and the server displays warning information in a prompt box mode, wherein the warning information is used for indicating that the service field update request is abnormal. For example, the status code is 500, logic false or 0, and the terminal determines that the update result is update failure.
In the embodiment of the invention, the corresponding content data frame is set for each service field information, and the content data frame corresponding to each service field information is screened to obtain the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and sending the data table name to be queried and the field information to be queried to a target server according to the actual service requirement, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement, thereby improving the data processing efficiency and the data query efficiency.
The service data query method in the embodiment of the present invention is described above, and the service data query device in the embodiment of the present invention is described below, referring to fig. 3, where an embodiment of the service data query device in the embodiment of the present invention includes:
an obtaining module 301, configured to obtain and cache a plurality of service table names and a plurality of service field information corresponding to each service table, where each service field information includes a field name, a field type, and a field description;
the generating module 302 is configured to obtain tag tree data, generate a target page based on the tag tree data, and set a corresponding content data frame for each service field information in the target page;
the filtering module 303 is configured to receive a data frame operation instruction, and filter a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried, where the field information to be queried includes a field name to be queried, a field relationship, and a field search rule;
the query module 304 is configured to determine a data table name to be queried from a plurality of service table names according to the field information to be queried, and send the data table name to be queried and the field information to be queried to the target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and obtain target service data according to the structured query language statement.
Further, the plurality of service field information is stored in a blockchain database, and is not limited herein.
In the embodiment of the invention, the corresponding content data frame is set for each service field information, and the content data frame corresponding to each service field information is screened to obtain the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and sending the data table name to be queried and the field information to be queried to a target server according to the actual service requirement, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement, thereby improving the data processing efficiency and the data query efficiency.
Referring to fig. 4, another embodiment of a service data query device according to an embodiment of the present invention includes:
an obtaining module 301, configured to obtain and cache a plurality of service table names and a plurality of service field information corresponding to each service table, where each service field information includes a field name, a field type, and a field description;
the generating module 302 is configured to obtain tag tree data, generate a target page based on the tag tree data, and set a corresponding content data frame for each service field information in the target page;
The filtering module 303 is configured to receive a data frame operation instruction, and filter a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried, where the field information to be queried includes a field name to be queried, a field relationship, and a field search rule;
the query module 304 is configured to determine a data table name to be queried from a plurality of service table names according to the field information to be queried, and send the data table name to be queried and the field information to be queried to the target server, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and obtain target service data according to the structured query language statement.
Optionally, the obtaining module 301 may be further specifically configured to:
sending a service table information acquisition request to a target server to obtain response data returned by the target server;
extracting a plurality of service table names and a plurality of service field information corresponding to each service table from response data according to a preset association rule, wherein each service field information comprises a field name, a field type and a field description, and the preset association rule is a product code, a product name and an enterprise name;
And storing the names of the service tables and the corresponding service field information of each service table into a memory database.
Optionally, the generating module 302 may be further specifically configured to:
sending a tag tree configuration information acquisition request to a target server to obtain tag tree data returned by the target server;
converting each label in the label tree data into each node in the document object model tree, adding cascading style sheet information to each node, and traversing the rendered document object model tree to obtain a target page;
and receiving each piece of service field information dragged by the user in the target page, and generating a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information.
Optionally, the screening module 303 may be further specifically configured to:
receiving a data frame operation instruction, and analyzing the data frame operation instruction to obtain a data frame identification value;
and carrying out data matching on the content data frame corresponding to each service field information according to the data frame identification value to obtain the field name to be queried, the field relation and the field searching rule.
Optionally, the query module 304 may be further specifically configured to:
determining a data table name to be queried from a plurality of service table names according to the field information to be queried, and encrypting the data table name to be queried, the field relation and the field searching rule according to a preset key to obtain encrypted data;
Sending the encrypted data to a target server through an asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determining a query result according to the structured query language statement;
and receiving the query result through the asynchronous response target server, decrypting the query result according to the preset key to obtain target service data, reformatting the target service data to update and display asynchronously.
Optionally, the service data query device further includes:
the comparison module 305 is configured to obtain a service file to be imported corresponding to a preset service, and compare the size of the service file to be imported with a preset minimum threshold and a preset maximum threshold respectively;
the display module 306 is configured to generate and display a prompt message including file abnormality if the size of the file to be imported is smaller than a preset minimum threshold value or the size of the file to be imported is larger than a preset maximum threshold value;
the import module 307 is configured to obtain a preset service identifier if the size of the file to be imported is greater than or equal to a preset minimum threshold value and the size of the file to be imported is less than or equal to a preset maximum threshold value, and import the file to be imported into the target server according to the preset service identifier.
Optionally, the service data query device further includes:
a sending module 308, configured to send a service field update request to a target server, so that the target server updates corresponding service field information according to the service field update request to obtain an update result, where the service field update request is used to instruct to add, modify, or delete service field information in any one preset service table;
and the change module 309 receives the update result sent by the target server, and changes the plurality of service field information corresponding to the preset service table in the memory database according to the update result.
In the embodiment of the invention, the corresponding content data frame is set for each service field information, and the content data frame corresponding to each service field information is screened to obtain the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule; and sending the data table name to be queried and the field information to be queried to a target server according to the actual service requirement, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and acquires target service data according to the structured query language statement, thereby improving the data processing efficiency and the data query efficiency.
The service data query device in the embodiment of the present invention is described in detail in terms of modularization in fig. 3 and fig. 4, and the service data query device in the embodiment of the present invention is described in detail in terms of hardware processing.
Fig. 5 is a schematic structural diagram of a service data query device according to an embodiment of the present invention, where the service data query device 500 may have a relatively large difference due to different configurations or performances, and may include one or more processors (central processing units, CPU) 510 (e.g., one or more processors) and a memory 520, and one or more storage media 530 (e.g., one or more mass storage devices) storing application programs 533 or data 532. Wherein memory 520 and storage medium 530 may be transitory or persistent storage. The program stored in the storage medium 530 may include one or more modules (not shown), each of which may include a series of instruction operations in the service data query device 500. Still further, the processor 510 may be arranged to communicate with a storage medium 530 to execute a series of instruction operations in the storage medium 530 on the traffic data querying device 500.
The traffic data query device 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input/output interfaces 560, and/or one or more operating systems 531, such as Windows Serve, mac OS X, unix, linux, freeBSD, and the like. It will be appreciated by those skilled in the art that the business data query device architecture shown in fig. 5 is not limiting of the business data query device, and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
The present invention also provides a computer readable storage medium, which may be a non-volatile computer readable storage medium, and may also be a volatile computer readable storage medium, where instructions are stored in the computer readable storage medium, when the instructions are executed on a computer, cause the computer to perform the steps of the service data query method.
The invention also provides a service data query device, which comprises a memory and a processor, wherein the memory stores instructions which, when executed by the processor, cause the processor to execute the steps of the service data query method in the above embodiments.
Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created from the use of blockchain nodes, and the like.
The blockchain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm and the like. The Blockchain (Blockchain), which is essentially a decentralised database, is a string of data blocks that are generated by cryptographic means in association, each data block containing a batch of information of network transactions for verifying the validity of the information (anti-counterfeiting) and generating the next block. The blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (random access memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (8)
1. The service data query method is characterized by comprising the following steps:
acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description;
sending a tag tree configuration information acquisition request to a target server to obtain tag tree data returned by the target server; converting each label in the label tree data into each node in a document object model tree, adding cascading style sheet information to each node, and traversing and rendering the document object model tree to obtain a target page; receiving each piece of service field information dragged by a user in the target page, and generating a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information;
Receiving a data frame operation instruction, and screening a content data frame corresponding to each service field information according to the data frame operation instruction to obtain field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule;
determining a data table name to be queried from the plurality of service table names according to the field information to be queried, and encrypting the data table name to be queried, the field relation and the field searching rule according to a preset key to obtain encrypted data; sending the encrypted data to a target server through an asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determining a query result according to the structured query language statement; and receiving the query result through the asynchronous response target server, decrypting the query result according to the preset key to obtain target service data, and reformatting the target service data for asynchronous updating and displaying.
2. The service data query method according to claim 1, wherein the obtaining and caching a plurality of service table names and a plurality of service field information corresponding to each service table, each service field information including a field name, a field type, and a field description includes:
Sending a service table information acquisition request to a target server to obtain response data returned by the target server;
extracting a plurality of service table names and a plurality of service field information corresponding to each service table from the response data according to a preset association rule, wherein each service field information comprises a field name, a field type and a field description, and the preset association rule is a product code, a product name and an enterprise name;
and storing the service table names and the service field information corresponding to each service table into a memory database.
3. The service data query method according to claim 1, wherein the receiving a data frame operation instruction and filtering a content data frame corresponding to each service field information according to the data frame operation instruction, to obtain field information to be queried, where the field information to be queried includes a field name to be queried, a field relationship, and a field search rule, includes:
receiving a data frame operation instruction, and analyzing the data frame operation instruction to obtain a data frame identification value;
and carrying out data matching on the content data frame corresponding to each service field information according to the data frame identification value to obtain a field name to be queried, a field relation and a field searching rule.
4. A service data query method according to any one of claims 1 to 3, wherein before said obtaining and caching a plurality of service table names and a plurality of service field information corresponding to each service table, each service field information including a field name, a field type and a field description, said service data query method comprises:
acquiring a to-be-imported service file corresponding to a preset service, and comparing the size of the to-be-imported file with a preset minimum threshold value and a preset maximum threshold value respectively;
if the size of the file to be imported is smaller than a preset minimum threshold value or the size of the file to be imported is larger than a preset maximum threshold value, generating and displaying prompt information containing file abnormality;
and if the size of the file to be imported is larger than or equal to a preset minimum threshold value and the size of the file to be imported is smaller than or equal to a preset maximum threshold value, acquiring a preset service identifier, and importing the file to be imported into a target server according to the preset service identifier.
5. The service data query method according to any one of claims 1 to 3, wherein after the determining the to-be-queried data table name from the plurality of service table names according to the to-be-queried field information and sending the to-be-queried data table name and the to-be-queried field information to a target server, so that the target server concatenates the to-be-queried data table name and the to-be-queried field information into a structured query language statement and obtains target service data according to the structured query language statement, the service data query method further comprises:
Sending a service field updating request to the target server, so that the target server updates corresponding service field information according to the service field updating request to obtain an updating result, wherein the service field updating request is used for indicating to add, modify or delete the service field information in any one preset service table;
and receiving an updating result sent by the target server, and changing a plurality of service field information corresponding to a preset service table in a memory database according to the updating result.
6. A service data query device, characterized in that the service data query device comprises:
the acquisition module is used for acquiring and caching a plurality of service table names and a plurality of service field information corresponding to each service table, wherein each service field information comprises a field name, a field type and a field description;
the generating module is used for sending a tag tree configuration information acquisition request to a target server to obtain tag tree data returned by the target server; converting each label in the label tree data into each node in a document object model tree, adding cascading style sheet information to each node, and traversing and rendering the document object model tree to obtain a target page; receiving each piece of service field information dragged by a user in the target page, and generating a corresponding content data frame for each piece of service field information according to the field name, the field type and the field description of each piece of service field information;
The screening module is used for receiving the data frame operation instruction, screening the content data frame corresponding to each service field information according to the data frame operation instruction, and obtaining the field information to be queried, wherein the field information to be queried comprises a field name to be queried, a field relation and a field searching rule;
the query module is used for determining a data table name to be queried from the plurality of service table names according to the field information to be queried, encrypting the data table name to be queried, the field relation and the field search rule according to a preset secret key, and obtaining encrypted data; sending the encrypted data to a target server through an asynchronous request, so that the target server splices the data table name to be queried and the field information to be queried into a structured query language statement, and determining a query result according to the structured query language statement; and receiving the query result through the asynchronous response target server, decrypting the query result according to the preset key to obtain target service data, and reformatting the target service data for asynchronous updating and displaying.
7. A service data query device, characterized in that the service data query device comprises: a memory and at least one processor, the memory having instructions stored therein;
the at least one processor invokes the instructions in the memory to cause the business data query device to perform the business data query method of any of claims 1-5.
8. A computer readable storage medium having instructions stored thereon, which when executed by a processor, implement the business data query method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011396541.2A CN112506946B (en) | 2020-12-03 | 2020-12-03 | Service data query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011396541.2A CN112506946B (en) | 2020-12-03 | 2020-12-03 | Service data query method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112506946A CN112506946A (en) | 2021-03-16 |
| CN112506946B true CN112506946B (en) | 2024-04-05 |
Family
ID=74969571
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011396541.2A Active CN112506946B (en) | 2020-12-03 | 2020-12-03 | Service data query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112506946B (en) |
Families Citing this family (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112989171A (en) * | 2021-03-26 | 2021-06-18 | 广东电网有限责任公司 | Data query method, device, equipment and medium |
| CN113094401B (en) * | 2021-05-07 | 2023-08-08 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
| CN113392105B (en) * | 2021-05-24 | 2023-03-24 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113360152B (en) * | 2021-06-11 | 2023-11-03 | 软子数字软件(广州)有限公司 | Method and system for realizing parameterized data query webpage display program |
| CN113127506B (en) * | 2021-06-16 | 2021-10-15 | 北京明略昭辉科技有限公司 | Target query statement construction method and device, storage medium and electronic device |
| CN113438290A (en) * | 2021-06-22 | 2021-09-24 | 康键信息技术（深圳）有限公司 | Method, device and equipment for detecting repeated request and storage medium |
| CN113342821B (en) * | 2021-06-29 | 2023-04-07 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113568924A (en) * | 2021-07-23 | 2021-10-29 | 北京达佳互联信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN113688131B (en) * | 2021-08-09 | 2024-03-26 | 招商银行股份有限公司 | Method, system, device and computer program product for analyzing field level influence |
| CN113900755B (en) * | 2021-10-11 | 2024-04-16 | 重庆紫光华山智安科技有限公司 | Alarm page processing method and device, computer equipment and readable storage medium |
| CN114398366B (en) * | 2021-12-28 | 2022-12-27 | 重庆允成互联网科技有限公司 | Heterogeneous data input method and data factory configuration system |
| CN114237806B (en) * | 2021-12-29 | 2024-03-12 | 瀚云科技有限公司 | Page information display method and device, electronic equipment and storage medium |
| CN114089976B (en) * | 2022-01-21 | 2022-04-26 | 通联支付网络服务股份有限公司 | Method, apparatus, and medium for generating database operation statements |
| CN114637761B (en) * | 2022-03-10 | 2024-03-19 | 马上消费金融股份有限公司 | Business object generation method and device |
| CN115576974B (en) * | 2022-09-30 | 2023-12-12 | 中电金信软件有限公司 | Data processing method, device, equipment and medium |
| CN115407992B (en) * | 2022-10-31 | 2023-04-28 | 平安银行股份有限公司 | Configuration method and device of data query menu, electronic equipment and storage medium |
| CN116028568A (en) * | 2023-03-27 | 2023-04-28 | 北京中科江南信息技术股份有限公司 | Financial service data export method and device and electronic equipment |
| CN116136825B (en) * | 2023-04-14 | 2023-09-19 | 阿里云计算有限公司 | Data detection method and system |
| CN116561132B (en) * | 2023-07-06 | 2023-12-22 | 深圳市明源云科技有限公司 | Service data query method, electronic device and readable storage medium |
| CN117407457B (en) * | 2023-12-14 | 2024-02-27 | 中国人民解放军国防科技大学 | Multi-source data fusion method, system and equipment based on configurable rules |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103078833A (en) * | 2011-10-26 | 2013-05-01 | 上海讯首软件有限公司 | Method for asynchronously transmitting data |
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
| CN110309196A (en) * | 2019-05-22 | 2019-10-08 | 深圳壹账通智能科技有限公司 | Block chain data storage and query method, apparatus, equipment and storage medium |
| CN110502506A (en) * | 2019-08-29 | 2019-11-26 | 北京博睿宏远数据科技股份有限公司 | A kind of data processing method, device, equipment and storage medium |
-
2020
- 2020-12-03 CN CN202011396541.2A patent/CN112506946B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103078833A (en) * | 2011-10-26 | 2013-05-01 | 上海讯首软件有限公司 | Method for asynchronously transmitting data |
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
| CN110309196A (en) * | 2019-05-22 | 2019-10-08 | 深圳壹账通智能科技有限公司 | Block chain data storage and query method, apparatus, equipment and storage medium |
| CN110502506A (en) * | 2019-08-29 | 2019-11-26 | 北京博睿宏远数据科技股份有限公司 | A kind of data processing method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112506946A (en) | 2021-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112506946B (en) | Service data query method, device, equipment and storage medium | |
| US11392550B2 (en) | System and method for investigating large amounts of data | |
| EP3602351B1 (en) | Apparatus and method for distributed query processing utilizing dynamically generated in-memory term maps | |
| US20210049191A1 (en) | Transforming a Data Stream into Structured Data | |
| US11366856B2 (en) | System and method for updating target schema of graph model | |
| US7080067B2 (en) | Apparatus, method, and program for retrieving structured documents | |
| US8019770B1 (en) | Dynamic rendering of content that includes query expressions | |
| JP5407043B2 (en) | Efficient piecewise update of binary encoded XML data | |
| CN112540923B (en) | Interface parameter checking and converting method, device, equipment and storage medium | |
| CN109388637A (en) | Data warehouse information processing method, device, system, medium | |
| US11030242B1 (en) | Indexing and querying semi-structured documents using a key-value store | |
| WO2018142942A1 (en) | Display program, display method, and display device | |
| CN112860727B (en) | Data query method, device, equipment and medium based on big data query engine | |
| CN112988770A (en) | Method and device for updating serial number, electronic equipment and storage medium | |
| CN112671734A (en) | Message processing method facing multiple data sources and related equipment thereof | |
| CN114490723A (en) | Unified retrieval method, device, electronic equipment and storage medium | |
| CN114139503A (en) | Document content processing method, device, equipment and storage medium | |
| CN108694172B (en) | Information output method and device | |
| US10235224B2 (en) | Validation and parsing performance using subtree caching | |
| CN110308907A (en) | Data transfer device, device, storage medium and electronic equipment | |
| CN114995719A (en) | List rendering method, device, equipment and storage medium | |
| CN115759029A (en) | Document template processing method and device, electronic equipment and storage medium | |
| CN110704481A (en) | Method and device for displaying data | |
| CN115794861A (en) | Offline data query multiplexing method based on feature abstract and application thereof | |
| CN115795187A (en) | Resource access method, device and equipment |
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 |