CN110019350A - Data query method and apparatus based on configuration information - Google Patents
Data query method and apparatus based on configuration information Download PDFInfo
- Publication number
- CN110019350A CN110019350A CN201710631092.7A CN201710631092A CN110019350A CN 110019350 A CN110019350 A CN 110019350A CN 201710631092 A CN201710631092 A CN 201710631092A CN 110019350 A CN110019350 A CN 110019350A
- Authority
- CN
- China
- Prior art keywords
- query
- index
- inquiry request
- configuration information
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
-
- 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
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 invention discloses the data query method and apparatus based on configuration information, are related to field of computer technology.One specific embodiment of this method includes: that the inquiry request of application system is received based on unified service framework；Inquiry request includes: query argument, and is uniquely directed toward the index mark ID of the corresponding target database of application system；Configuration information is obtained according to index ID；Configuration information includes: query statement template；Query statement can be performed according to query argument and query statement template dynamic generation；Query result is obtained according to executable query statement.The embodiment can provide unified query mode for multisystem, and the readability for effectively reducing the quantity of written in code, improving executable query statement greatly improves efficiency data query and development and production efficiency.In addition, the embodiment simultaneously support High Availabitity, high concurrent and can flexible expansion, adapt to more business scenarios and field.
Description
Technical field
The present invention relates to field of computer technology, more particularly to the data query method and apparatus based on configuration information.
Background technique
The prior art often directly writes query statement when carrying out data query in code.This data query side
At least there are the following problems for formula:
1) homologous ray does not often correspond to different databases, and the data structure of disparate databases is not necessarily identical.Therefore, needle
When carrying out data query to not homologous ray, need to write query statement in code respectively, repeatability is high, written in code amount is big,
Query statement manages and maintains difficulty, considerably increases difficulty and the period of project development；
2) the code readability of query statement is lower, requires a great deal of time and is understood query statement and determined
Position；
3) modification or when Optimizing Queries sentence every time, needs to keep system again online, the low efficiency of data query.
Summary of the invention
In view of this, the embodiment of the present invention provides the data query method and apparatus based on configuration information, it can be polyphyly
System provides unified query mode, and the readability for effectively reducing the quantity of written in code, improving executable query statement greatly improves
The efficiency and development and production efficiency of data query.In addition, the embodiment simultaneously support High Availabitity, high concurrent and can flexible expansion,
Adapt to more business scenarios and field.
To achieve the above object, according to an aspect of an embodiment of the present invention, the data based on configuration information are provided to look into
Inquiry method, comprising:
The inquiry request of application system is received based on unified service framework；Inquiry request includes: query argument, Yi Jiwei
One property it is directed toward the index mark ID of the corresponding database of application system；
Configuration information is obtained according to index ID；Configuration information includes: query statement template；
Query statement can be performed according to query argument and query statement template dynamic generation；
According to executable query statement, query result is obtained.
Optionally, service framework is by remote procedure call protocol RPC or WebService or hypertext transfer protocol
What HTTP was realized.
Optionally, the type based on inquiry request, and/or dimension, and/or index ID generate query statement template.
Optionally, according to index ID locating query sentence template；
The parameter placeholder of the query statement template is replaced using query argument, query statement can be performed in dynamic generation.
Optionally, data query method further comprises: remembering using inquiry request and corresponding query result as caching
Record is saved to cache module；
Obtaining query result according to executable query statement includes:
Judge in cache module with the presence or absence of caching record corresponding with inquiry request；If it exists, then from caching record
Obtain query result corresponding with inquiry request.
Optionally, configuration information further comprises: the first caching period；
For every caching record in cache module: if the cache-time of caching record was greater than for the first caching period,
Delete caching record.
Optionally, caching record is generated as follows:
Identifier with uniqueness is generated according to index ID and query argument；
Using the corresponding relationship of identifier and query result as caching record.
Optionally, cache module uses key-value pair data library；Caching record generates by the following method:
Index ID and query argument are spliced into character string, based on the text string generation key with uniqueness being spliced into
It is worth name key；
Using the corresponding query result of inquiry request as key assignments value；
Using the corresponding relationship of key and value as caching record.
Optionally, obtaining query result according to executable query statement includes:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or informative abstract
Algorithm calculates character string, generates key to be checked；
Judge in cache module with the presence or absence of key to be checked；If it exists, then it is obtained and key to be checked from caching record
Corresponding value, and using the value as query result.
Optionally, obtaining query result according to executable query statement includes:
Using the corresponding target database of Connection Pool access application system, this is executed from target database, and this can be held
Row query statement obtains query result.
Optionally, the corresponding target database of application system is non-relational database, and configuration information further comprises: collection
The Internet protocol IP group and index name of group；Alternatively,
Target database is relevant database, and configuration information further comprises: the domain names or IP of target database,
And library name.
Another aspect according to an embodiment of the present invention provides the data query device based on configuration information, comprising:
Communication module, communication module use unified service framework；
Service module is used for: the inquiry request of application system is received based on service framework, inquiry request includes: inquiry ginseng
Number, and uniquely it is directed toward the index mark ID of the corresponding database of application system；Configuration information is obtained according to index ID；Institute
Stating configuration information includes: query statement template；Query statement can be performed according to inquiry request and query statement template dynamic generation；
Query result is obtained according to executable query statement.
Optionally, the service framework of communication module is literary by remote procedure call protocol RPC or WebService or super
What this transportation protocol HTTP was realized.
Optionally, type, and/or dimension, and/or index ID of the service module based on inquiry request generate query statement mould
Plate；Alternatively,
The device of the present embodiment further comprises: parameter configuration module, for type and/or dimension based on inquiry request
Degree and index ID generate query statement template.
Optionally, service module foundation utilizes index ID locating query sentence template；
Service module replaces the parameter placeholder of the query statement template, the executable inquiry of dynamic generation using query argument
Sentence.
Optionally, data query device further comprises: cache module；
Service module is saved using inquiry request and corresponding query result as caching record to cache module；
Service module is further used for: judging in cache module with the presence or absence of caching record corresponding with inquiry request；If
In the presence of then obtaining corresponding with inquiry request query result from caching record.
Optionally, configuration information further comprises: the first caching period；
Service module is further used for:
For every caching record in cache module: if the cache-time of the caching record was greater than for the first caching period,
Then delete the caching record.
Optionally, service module generates caching record as follows:
Identifier with uniqueness is generated according to index ID and query argument；
Using the corresponding relationship of identifier and query result as caching record.
Optionally, cache module uses key-value pair data library；
Service module generates caching record as follows:
Index ID and query argument are spliced into character string, based on the text string generation key with uniqueness being spliced into
It is worth name key；
Using the corresponding query result of inquiry request as key assignments value；
It saves the corresponding relationship of key and value as caching record into key-value pair data library.
Optionally, service module is further used for:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or informative abstract
Algorithm calculates the character string, generates key to be checked；
Judge in cache module with the presence or absence of key to be checked；If it exists, then it is obtained and key to be checked from caching record
Corresponding value, and using the value as query result.
Optionally, communication module further comprises: Connection Pool；
Service module is further used for: using the corresponding target database of Connection Pool access application system, from target
The executable query statement is executed in database, obtains query result.
Optionally, the corresponding target database of application system is non-relational database, and configuration information further comprises: collection
The Internet protocol IP group and index name of group；Alternatively,
Target database is relevant database, and configuration information further comprises: the domain names or IP of target database,
And library name.
Other side according to an embodiment of the present invention provides the terminal of the data query based on configuration information, comprising:
One or more processors；
Storage device, for storing one or more programs,
When one or more programs are executed by one or more processors, so that one or more processors realize the present invention
The data query method based on configuration information.
Still another aspect according to an embodiment of the present invention provides a kind of computer-readable medium, is stored thereon with computer
Program realizes the data query method of the invention based on configuration information when program is executed by processor.
One embodiment in foregoing invention have the following advantages that or the utility model has the advantages that by using unified service framework,
Obtaining configuration information, foundation query argument and query statement template dynamic generation including query statement template according to index ID can
Query statement is executed, so overcoming the technology that must write query statement in code respectively when carrying out inquiry request every time
Problem, and then reach the quantity for reducing written in code, the readability of the executable query statement of raising, greatly improve data query effect
The technical effect of rate and development and production efficiency.
Further effect possessed by above-mentioned non-usual optional way adds hereinafter in conjunction with specific embodiment
With explanation.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the schematic diagram of the main flow of the data query method according to an embodiment of the present invention based on configuration information；
Fig. 2 is the schematic diagram of the key step of the data query method according to an embodiment of the present invention based on configuration information；
Fig. 3 is the configuration diagram of the data query device according to an embodiment of the present invention based on configuration information；
Fig. 4 is the schematic diagram of the main modular of the data query device according to an embodiment of the present invention based on configuration information；
Fig. 5 is that the embodiment of the present invention can be applied to exemplary system architecture figure therein；
Fig. 6 is adapted for the structural schematic diagram for realizing the terminal of the embodiment of the present invention or the computer system of server.
Specific embodiment
Below in conjunction with attached drawing, an exemplary embodiment of the present invention will be described, including the various of the embodiment of the present invention
Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize
It arrives, it can be with various changes and modifications are made to the embodiments described herein, without departing from scope and spirit of the present invention.Together
Sample, for clarity and conciseness, descriptions of well-known functions and structures are omitted from the following description.
Fig. 1 is the schematic diagram of the main flow of the data query method according to an embodiment of the present invention based on configuration information,
As shown in Figure 1, comprising:
Step S101, the inquiry request of application system is received based on unified service framework；Inquiry request includes: inquiry ginseng
Number, and uniquely it is directed toward the index mark ID of the corresponding database of application system；
Step S102, configuration information is obtained according to index ID；Configuration information includes: query statement template；
Step S103, query statement can be performed according to query argument and query statement template dynamic generation；
Step S104, according to query statement can be performed, query result is obtained.
The present invention is based on unified service frameworks to be managed collectively executable query statement, carries out data query every time
Shi Buxu can be suitable for various businesses scene and field it is to be understood that bottom-layer network, greatly improve the efficiency of data query
And development and production efficiency.The present invention can provide unified query mode for multisystem, and each application system can be called unified
Service interface, which sends the parameter informations such as index ID and query argument, can obtain corresponding query result, without being looked into every time
Query statement is write in code respectively when asking request, therefore, the quantity of written in code can be greatly reduced, improve executable look into
The readability of sentence is ask, query statement is reduced and manages and maintains difficulty, improves the efficiency of data query.By in this present embodiment
Executable query statement generated according to query statement template and query argument, rather than in the prior art based in code
When writing generation, therefore modifying every time or optimize executable query statement, without making system is again online can come into force, data
That inquires is high-efficient.Data query method and apparatus of the invention support High Availabitity, high concurrent and can flexible expansion, adapt to more
More business scenarios and field.
In some embodiments, service framework is by remote procedure call protocol (Remote Procedure Call
Protocol, RPC) realize, such as Jingdone district service framework (Jingdong Service Framework, JSF) frame,
DUBBO frame etc..RPC is a kind of request service from remote computer program, without understanding bottom-layer network by network
The agreement of technology can be realized the data transmission of cross-platform cross language.
Service framework can also be real by hypertext transfer protocol (HyperText Transfer Protocol, HTTP)
Existing.Http protocol is the transportation protocol for transmitting hypertext to local browser from www server, in some embodiments
In, be based on http protocol, can be used POST normal direction specify resource submit data carry out processing request, for example, submission form or
The upper transmitting file of person, or request is issued using the specific resource of GET normal direction, such as the request for obtaining data is sent to server
Deng.Service framework based on http protocol can make browser more efficient, reduce network transmission.
Certainly, those skilled in the art can also realize service framework of the invention using other modes, such as pass through net
Network services WebService and realizes.Web Service need not can make by additional, special third party software or hardware
The different application systems realization operated on different machines is exchanged with each other data or integrated.Therefore it is standardized according to Web Service
Between the application system of implementation, no matter whether language, platform or internal agreement are identical used in each application system, are ok
It is exchanged with each other data.
Compared with the prior art needs to write and safeguard a large amount of query statement respectively, the present invention uses query statement template
Generate executable query statement, it is only necessary to safeguard query statement template, therefore the amount of writing and dimension of executable query statement
Shield amount greatly reduces.In order to reduce the maintenance quantity of query statement template to the greatest extent, the various inquiries from each application system are asked
A query statement template can be shared by asking.In actual use, can also type based on inquiry request, and/or dimension,
And/or index ID generates query statement template, to improve each search efficiency.For example, inquiry request can be divided into available library
It files for reference the different types of service such as inquiry, perishable asset inquiry, order inquiries to be checked, respectively an inquiry is arranged in each type
Sentence template；Inquiry request can also be distinguished into multiple classifications according to the data dimension information that inquiry request is included, be each
A query statement template is respectively set in classification；In addition it is also possible to according to the storage location of the corresponding target database of index ID
Inquiry request is grouped, each group shares a query statement template.
The storage location of configuration information can be configured according to the actual situation, for example, configuration information is stored in application
In the corresponding target database of system, configuration information is obtained from target database according to index ID；Configuration information can also be deposited
Storage obtains configuration information from file server on file server, according to index ID；Certainly, configuration information also can store
Inside application system or on other elements with store function.When using multiple queries sentence template, multiple inquiry
Sentence template can be respectively stored on different storage mediums.
Target database can be relevant database, such as structured query language (Structured Query
Language, MYSQL), or be non-relational database.Configuration information may further include: uniquely be directed toward application
The data information of the corresponding target database of system.For example, when the corresponding target database of application system is non-relational data
When library, configuration information be may further include: the Internet protocol IP group and index name of cluster.When target database is relationship type
When database, configuration information be may further include: the domain names or IP and library name of target database.Pass through the data
Information can quickly position the corresponding target database of application system, and executable query statement is executed from the target database,
Obtain query result.
In some alternative embodiments, according to index ID locating query sentence template, to determine query statement template
Storage position；Using the parameter placeholder of query argument replacement query statement template, query statement is can be performed in dynamic generation.With it is existing
Have to need to write query statement in code respectively for each inquiry request in technology and compare, executable look into can be greatly simplified
The amount of writing of sentence is ask, and reduce executable query statement manages and maintains difficulty.
The present invention is not specifically limited the generating mode and composition of index ID, as long as it can uniquely be directed toward application
The corresponding target database of system.Those skilled in the art can be with application system, and/or the corresponding target of application system
Index ID of the unique identification of database as the application system, can also be corresponding based on application system, and/or application system
Target database unique identification and using preset indicator rule generate index ID.
The data format of query result can be configured according to actual needs.In some embodiments, for the ease of answering
Query result is parsed with system, the data format of query result are as follows: JSON, and/or XML, and/or TXT.
In some alternative embodiments, it saves using inquiry request and corresponding query result as caching record to slow
Storing module；Obtaining query result according to executable query statement includes: to judge to whether there is and inquiry request pair in cache module
The caching record answered；If it exists, then query result corresponding with inquiry request is obtained from caching record.It is further preferred that
If caching record corresponding with inquiry request is not present in cache module, the executable query statement is executed, inquiry knot is obtained
Fruit, and the inquiry request is saved with corresponding query result as caching record into cache module.
By caching to query result, efficiency data query can not only be improved, additionally it is possible to it is negative to substantially reduce system
Lotus reduces the operating pressure during data query.Preferably, configuration information further comprises: the first caching period；For slow
Every caching record in storing module: if the cache-time of caching record was greater than for the first caching period, caching record is deleted.Such as
This, can further decrease the load of inquiry request access, improve the efficiency of inquiry request access.
In some alternative embodiments, caching record is generated as follows: raw according to index ID and query argument
At identifier with uniqueness；Using the corresponding relationship of identifier and query result as caching record.According to inquiry request
Index ID and query argument can uniquely determine an identifier；Multiple queries are requested, if its corresponding index ID
Identical and query argument is identical, then the identifier with query result of multiple inquiry request are identical, corresponds to same caching note
Record.Corresponding relationship between executable query statement and caching record is determined using identifier, is convenient for quickly in cache module
Search caching record corresponding with inquiry request.
By taking cache module is using key-value pair data library as an example, caching record can generate by the following method: by index ID
It is spliced into character string with query argument, based on the text string generation key assignments name key with uniqueness being spliced into；It is asked with inquiry
Ask corresponding query result as key assignments value；Using the corresponding relationship of key and value as caching record.For example, can adopt
Character string is calculated with hash algorithm or message digest algorithm, generates key assignments name key with uniqueness.It is asked according to inquiry
The character string that the index ID and query argument asked is spliced into can uniquely determine a key；Multiple queries are requested, if
Its corresponding index ID is identical and query argument is identical, then the key and value of multiple inquiry request are identical, corresponds to same
Caching record.
In some embodiments, obtaining query result according to executable query statement includes:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or informative abstract
Algorithm calculates character string, generates key to be checked；
Judge in cache module with the presence or absence of key to be checked；If it exists, then it is obtained and key to be checked from caching record
Corresponding value, and using the value as query result.
In some alternative embodiments, obtaining query result according to executable query statement includes: using connection buffering
Pond accesses the corresponding target database of application system, and the executable query statement is executed from target database, obtains inquiry knot
Fruit.The connection that several access target databases can be retained in Connection Pool makes when for executing the executable query statement
With.In access target database, first determine whether in Connection Pool with the presence or absence of idle connection；If it exists, then using the free time
Connected reference target database；If it does not exist, then a new connection is created, new connected reference target data is then used
Library executes the executable query statement from target database, obtains query result.Several companies cached in Connection Pool
Connecing can be reused, to largely save system resource, reduce the pressure of system operation, improve the efficiency of data query.
Preferably, configuration information further comprises: the second caching period；For every connection in Connection Pool, if
The cache-time of the connection was greater than for the second caching period, then destroyed the connection.The use effect of Connection Pool so can be improved
Rate.
Fig. 2 is the schematic diagram of the key step of data query method according to an embodiment of the present invention, comprising:
The inquiry request that application system is received based on unified service framework, using index ID locating query sentence template,
Query statement can be performed according to inquiry request and query statement template dynamic generation；
The index ID and query argument of application system are spliced into character string, character string is counted using hash algorithm
It calculates, generates key to be checked；
Judge in cache module with the presence or absence of the key to be checked:
If it exists, value corresponding with key to be checked is obtained to return query result using the value as query result
Back to application system；
If it does not exist, executable query statement is executed, query result is obtained；Judge whether inquiry succeeds: if success, to look into
Result is ask as value, saves using the key to be checked and the value as caching record to cache module, query result is returned
Back to application system；If unsuccessful, error message is returned.
As shown in figure 4, providing a kind of data query device 400 based on configuration information, comprising:
Communication module 401, communication module 401 use unified service framework；
Service module 402, is used for: the inquiry request of application system is received based on service framework, inquiry request includes: inquiry
Parameter, and uniquely it is directed toward the index mark ID of the corresponding database of application system；Configuration information is obtained according to index ID；
Configuration information includes: query statement template；Query statement can be performed according to inquiry request and query statement template dynamic generation；Root
Query result is obtained according to executable query statement.
Fig. 3 is the configuration diagram of the data query device according to an embodiment of the present invention based on configuration information, such as Fig. 3 institute
Show, data query device 400 can receive application system 1, application system 2, application system 3 ... application system N etc. is multiple to be answered
With the inquiry request of system, wherein N is positive integer；Parsing is carried out to the inquiry request and obtains query result, and the inquiry is tied
Fruit returns to application system.The present invention is based on unified service frameworks to be managed collectively executable query statement, every time into
It is not required to when row data query it is to be understood that bottom-layer network, therefore various scenes and system can be suitable for, realize cross-platform cross language
Data query.Query statement is write in code respectively when carrying out inquiry request every time with each application system in the prior art
It compares, multiple application systems can share a query statement template in the present invention, it is only necessary to receive the index of application system transmission
The parameter informations such as ID and query argument can obtain corresponding query result, can greatly reduce the quantity of written in code, reduce
Executable query statement manages and maintains difficulty, improves the efficiency of data query.
Optionally, the service framework of communication module 401 is realized by remote procedure call protocol RPC or WebService
's.
Optionally, type and/or dimension and index ID of the service module based on query argument generate query statement mould
Plate；Alternatively,
The data query device 400 of the present embodiment further comprises: parameter configuration module 404, for being based on inquiry request
Type, and/or dimension, and/or index ID generate query statement template.
Optionally,
Service module 402 is according to utilization index ID locating query sentence template from target database；
Service module 402 replaces the parameter placeholder of the query statement template using query argument, and dynamic generation is executable
Query statement.
Optionally, data query device 400 of the present embodiment based on configuration information further comprises: cache module 403；
Service module 402 is saved using inquiry request and corresponding query result as caching record to cache module；
Service module 402 is further used for: judging in cache module with the presence or absence of caching record corresponding with inquiry request；
If it exists, then query result corresponding with inquiry request is obtained from caching record.
Optionally, configuration information further comprises: the first caching period；
Service module 402 is further used for:
For every caching record in cache module 402: if the cache-time of the caching record was greater than for the first caching week
Phase then deletes the caching record.
Optionally, service module 402 generates caching record as follows:
According to index ID and the raw identifier with uniqueness of query argument；
Using the corresponding relationship of identifier and query result as caching record.
Optionally, cache module 403 uses key-value pair data library；
Service module 402 generates caching record as follows:
Index ID and query argument are spliced into character string, based on the text string generation key with uniqueness being spliced into
It is worth name key；
Using the corresponding query result of inquiry request as key assignments value；
It saves the corresponding relationship of key and value as caching record into key-value pair data library.
Optionally, 402 pieces of mould are serviced to be further used for:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or informative abstract
Algorithm calculates character string, generates key to be checked；
Judge in cache module 403 with the presence or absence of key to be checked；If it exists, then from caching record obtain with it is to be checked
The corresponding value of key, and using the value as query result.
Optionally, communication module 401 further comprises: Connection Pool；
Service module 402 is using the corresponding target database of Connection Pool access application system, from target database
The executable query statement is executed, query result is obtained.
Optionally, configuration information further comprises: the second caching period；
Service module is further used for:
For the every connection cached in Connection Pool: if the cache-time of the connection was greater than for the second caching period,
Destroy the connection.
Optionally, the corresponding target database of application system is non-relational database, and configuration information further comprises: collection
The Internet protocol IP group and index name of group；Alternatively,
Target database is relevant database, and configuration information further comprises: the domain names or IP of target database,
And library name.
Other side according to an embodiment of the present invention provides a kind of terminal of data query based on configuration information, packet
It includes:
One or more processors；
Storage device, for storing one or more programs,
When one or more programs are executed by one or more processors, so that one or more processors realize the present invention
The data query method based on configuration information.
Fig. 5 is shown can be using data query method of the embodiment of the present invention based on configuration information or based on confidence
The exemplary system architecture 500 of the data query device of breath.
As shown in figure 5, system architecture 500 may include terminal device 501,502,503, network 504 and server 505.
Network 504 between terminal device 501,502,503 and server 505 to provide the medium of communication link.Network 504 can be with
Including various connection types, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 501,502,503 and be interacted by network 504 with server 505, to receive or send out
Send message etc..Various telecommunication customer end applications, such as the application of shopping class, net can be installed on terminal device 501,502,503
The application of page browsing device, searching class application, instant messaging tools, mailbox client, social platform software etc..
Terminal device 501,502,503 can be the various electronic equipments with display screen and supported web page browsing, packet
Include but be not limited to smart phone, tablet computer, pocket computer on knee and desktop computer etc..
Server 505 can be to provide the server of various services, such as utilize terminal device 501,502,503 to user
The shopping class website browsed provides the back-stage management server supported.Back-stage management server can believe the product received
The data such as breath inquiry request carry out the processing such as analyzing, and processing result is fed back to terminal device.
It should be noted that the data query method based on configuration information provided by the embodiment of the present invention is generally by servicing
Device 505 executes, and correspondingly, the data query device based on configuration information is generally positioned in server 505.
It should be understood that the number of terminal device, network and server in Fig. 5 is only schematical.According to realization need
It wants, can have any number of terminal device, network and server.
Below with reference to Fig. 6, it illustrates the knots of the computer system 600 for the terminal for being suitable for being used to realize the embodiment of the present invention
Structure schematic diagram.Terminal shown in Fig. 6 is only an example, should not function to the embodiment of the present invention and use scope bring and appoint
What is limited.
As shown in fig. 6, computer system 600 includes central processing unit (CPU) 601, it can be read-only according to being stored in
Program in memory (ROM) 602 or be loaded into the program in random access storage device (RAM) 603 from storage section 608 and
Execute various movements appropriate and processing.In RAM 603, also it is stored with system 600 and operates required various programs and data.
CPU 601, ROM 602 and RAM 603 are connected with each other by bus 604.Input/output (I/O) interface 605 is also connected to always
Line 604.
I/O interface 605 is connected to lower component: the importation 606 including keyboard, mouse etc.；It is penetrated including such as cathode
The output par, c 607 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.；Storage section 608 including hard disk etc.；
And the communications portion 609 of the network interface card including LAN card, modem etc..Communications portion 609 via such as because
The network of spy's net executes communication process.Driver 610 is also connected to I/O interface 605 as needed.Detachable media 611, such as
Disk, CD, magneto-optic disk, semiconductor memory etc. are mounted on as needed on driver 610, in order to read from thereon
Computer program be mounted into storage section 608 as needed.
Particularly, disclosed embodiment, the process described above with reference to flow chart may be implemented as counting according to the present invention
Calculation machine software program.For example, embodiment disclosed by the invention includes a kind of computer program product comprising be carried on computer
Computer program on readable medium, the computer program include the program code for method shown in execution flow chart.?
In such embodiment, which can be downloaded and installed from network by communications portion 609, and/or from can
Medium 611 is dismantled to be mounted.When the computer program is executed by central processing unit (CPU) 601, system of the invention is executed
The above-mentioned function of middle restriction.
It should be noted that computer-readable medium shown in the present invention can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter
The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires
Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the present invention, computer readable storage medium can be it is any include or storage journey
The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.And at this
In invention, computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for
By the use of instruction execution system, device or device or program in connection.Include on computer-readable medium
Program code can transmit with any suitable medium, including but not limited to: wireless, electric wire, optical cable, RF etc. are above-mentioned
Any appropriate combination.
Flow chart and block diagram in attached drawing are illustrated according to the system of various embodiments of the invention, method and computer journey
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, program segment or code of table, a part of above-mentioned module, program segment or code include one or more
Executable instruction for implementing the specified logical function.It should also be noted that in some implementations as replacements, institute in box
The function of mark can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are practical
On can be basically executed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.Also it wants
It is noted that the combination of each box in block diagram or flow chart and the box in block diagram or flow chart, can use and execute rule
The dedicated hardware based systems of fixed functions or operations is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
Being described in module involved in the embodiment of the present invention can be realized by way of software, can also be by hard
The mode of part is realized.Described module also can be set in the processor, for example, can be described as: a kind of processor packet
It includes sending module, obtain module, determining module and first processing module.Wherein, the title of these modules is under certain conditions simultaneously
The restriction to the module itself is not constituted, for example, sending module is also described as " sending picture to the server-side connected
The module of acquisition request ".
As on the other hand, the present invention also provides a kind of computer-readable medium, which be can be
Included in equipment described in above-described embodiment；It is also possible to individualism, and without in the supplying equipment.Above-mentioned calculating
Machine readable medium carries one or more program, when said one or multiple programs are executed by the equipment, makes
It obtains the equipment and realizes the data query method of the invention based on configuration information.
Above-mentioned specific embodiment, does not constitute a limitation on the scope of protection of the present invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and substitution can occur.It is any
Made modifications, equivalent substitutions and improvements etc. within the spirit and principles in the present invention, should be included in the scope of the present invention
Within.
Claims (24)
1. a kind of data query method based on configuration information characterized by comprising
The inquiry request of application system is received based on unified service framework；The inquiry request includes: query argument, Yi Jiwei
One property it is directed toward the index mark ID of the corresponding target database of the application system；
Configuration information is obtained according to the index ID；The configuration information includes: query statement template；
Query statement can be performed according to the query argument and the query statement template dynamic generation；
Query result is obtained according to the executable query statement.
2. data query method as described in claim 1, which is characterized in that the service framework is to pass through remote procedure call
What agreement RPC or WebService or hypertext transfer protocol HTTP was realized.
3. data query method as claimed in claim 2, which is characterized in that type, and/or dimension based on the inquiry request
Degree, and/or index ID generate query statement template.
4. data query method as claimed in claim 2, which is characterized in that
According to the index ID locating query sentence template；
The parameter placeholder of the query statement template is replaced using the query argument, query statement can be performed in dynamic generation.
5. data query method as claimed in claim 2, which is characterized in that further comprise: by the inquiry request and
The corresponding query result is saved as caching record to cache module；
It is described to include: according to the executable query statement acquisition query result
Judge in the cache module with the presence or absence of caching record corresponding with the inquiry request；If it exists, then from described slow
It deposits and obtains query result corresponding with the inquiry request in record.
6. data query method as claimed in claim 5, which is characterized in that the configuration information further comprises: first is slow
Cycle of deposit；
For every caching record in the cache module: if the cache-time of the caching record was greater than for the first caching week
Phase then deletes the caching record.
7. data query method as claimed in claim 5, which is characterized in that generate the caching record as follows:
Identifier with uniqueness is generated according to the index ID and the query argument；
Using the corresponding relationship of the identifier and the query result as the caching record.
8. data query method as claimed in claim 5, which is characterized in that the cache module uses key-value pair data library；
The caching record generates by the following method:
The index ID and the query argument are spliced into character string, had based on the text string generation being spliced into unique
The key assignments name key of property；
Using the corresponding query result of the inquiry request as key assignments value；
Using the corresponding relationship of the key and the value as the caching record.
9. data query method as claimed in claim 8, which is characterized in that described to be obtained according to the executable query statement
Query result includes:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or message digest algorithm
The character string is calculated, key to be checked is generated；
Judge in the cache module with the presence or absence of the key to be checked；If it exists, then from the caching record obtain and institute
The corresponding value of key to be checked is stated, and using the value as query result.
10. data query method as claimed in claim 2, which is characterized in that described to be obtained according to the executable query statement
The query result is taken to include:
The corresponding target database of the application system is accessed using connection pool, can be held described in execution from the target database
Row query statement obtains query result.
11. data query method as described in claim 1, which is characterized in that the target database is non-relational data
Library, the configuration information further comprises: the Internet protocol IP group and index name of cluster；Alternatively,
The target database is relevant database, and the configuration information further comprises: the domain names of target database
Or IP and library name.
12. a kind of data query device based on configuration information characterized by comprising
Communication module, the communication module use unified service framework；
Service module is used for: the inquiry request of application system is received based on the service framework, the inquiry request includes: to look into
Parameter is ask, and is uniquely directed toward the index mark ID of the corresponding target database of the application system；According to the index
ID obtains configuration information；The configuration information includes: query statement template；According to the query argument and the query statement mould
Query statement can be performed in plate dynamic generation；Query result is obtained according to the executable query statement.
13. data query device as claimed in claim 12, which is characterized in that the service framework of the communication module is to pass through
What remote procedure call protocol RPC or WebService or hypertext transfer protocol HTTP was realized.
14. data query device as claimed in claim 13, which is characterized in that the service module is based on the inquiry request
Type and/or dimension and the index ID generate the query statement template；Alternatively,
The data query device further comprises: parameter configuration module, for based on the inquiry request type, and/or
Dimension, and/or index ID generate the query statement template.
15. data query device as claimed in claim 13, which is characterized in that the service module is fixed according to the index ID
Position query statement template；
The service module replaces the query argument placeholder of the query statement template, dynamic generation using the query argument
Executable query statement.
16. device as claimed in claim 13, which is characterized in that further comprise: cache module；
The service module is saved using the inquiry request and the corresponding query result as caching record to caching mould
Block；
The service module is further used for: judging in the cache module with the presence or absence of caching corresponding with the inquiry request
Record；If it exists, then query result corresponding with the inquiry request is obtained from the caching record.
17. data query device as claimed in claim 16, which is characterized in that the configuration information further comprises: first
Caching period；
The service module is further used for:
For every caching record in the cache module: if the cache-time of the caching record was greater than for the first caching week
Phase then deletes the caching record.
18. data query device as claimed in claim 16, which is characterized in that the service module generates as follows
The caching record:
Identifier with uniqueness is generated according to the index ID and the query argument；
Using the corresponding relationship of the identifier and the query result as the caching record.
19. data query device as claimed in claim 16, which is characterized in that the cache module uses key-value pair data
Library；
The service module generates the caching record as follows:
The index ID and the query argument are spliced into character string, based on the text string generation key assignments name being spliced into
key；
Using the corresponding query result of the inquiry request as key assignments value；
It saves the corresponding relationship of the key and the value as the caching record into key-value pair data library.
20. data query device as claimed in claim 19, which is characterized in that the service module is further used for:
The index ID and query argument of current inquiry request are spliced into character string, using hash algorithm or message digest algorithm
The character string is calculated, key to be checked is generated；
Judge in the cache module with the presence or absence of the key to be checked；If it exists, then from the caching record obtain and institute
The corresponding value of key to be checked is stated, and using the value as query result.
21. device as claimed in claim 13, which is characterized in that the communication module further comprises: Connection Pool；
The service module accesses the corresponding target database of the application system using Connection Pool, from the target data
It is executed in library and the executable query statement, acquisition query result.
22. data query device as claimed in claim 12, which is characterized in that
The target database be non-relational database, configuration information further comprises: the Internet protocol IP group of cluster and
Index name；Alternatively,
The target database is relevant database, and configuration information further comprises: the domain names or IP of target database,
And library name.
23. a kind of terminal of the data query based on configuration information characterized by comprising
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
The now data query method as described in any in claim 1-11.
24. a kind of computer-readable medium, is stored thereon with computer program, which is characterized in that described program is held by processor
The data query method as described in any in claim 1-11 is realized when row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710631092.7A CN110019350B (en) | 2017-07-28 | 2017-07-28 | Data query method and device based on configuration information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710631092.7A CN110019350B (en) | 2017-07-28 | 2017-07-28 | Data query method and device based on configuration information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019350A true CN110019350A (en) | 2019-07-16 |
| CN110019350B CN110019350B (en) | 2021-06-29 |
Family
ID=67186007
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710631092.7A Active CN110019350B (en) | 2017-07-28 | 2017-07-28 | Data query method and device based on configuration information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019350B (en) |
Cited By (33)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110427188A (en) * | 2019-08-02 | 2019-11-08 | 深圳前海微众银行股份有限公司 | It is single to survey configuration method, device, equipment and the storage medium for asserting program |
| CN110716960A (en) * | 2019-10-22 | 2020-01-21 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
| CN110764769A (en) * | 2019-10-21 | 2020-02-07 | 苏州思必驰信息科技有限公司 | Method and device for processing user request |
| CN110781208A (en) * | 2019-09-27 | 2020-02-11 | 支付宝(杭州)信息技术有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN111177183A (en) * | 2019-12-24 | 2020-05-19 | 中国建设银行股份有限公司 | Method and device for generating database access statement |
| CN111198968A (en) * | 2019-12-11 | 2020-05-26 | 中国建设银行股份有限公司 | Data query method and device |
| CN111339140A (en) * | 2020-02-21 | 2020-06-26 | 北京三快在线科技有限公司 | Data query method and device, storage medium and electronic equipment |
| CN111597205A (en) * | 2020-05-26 | 2020-08-28 | 北京金堤科技有限公司 | Template configuration method, information extraction method, device, electronic equipment and medium |
| CN111767297A (en) * | 2020-06-30 | 2020-10-13 | 平安国际智慧城市科技股份有限公司 | Big data processing method, device, equipment and medium |
| CN111897849A (en) * | 2020-08-21 | 2020-11-06 | 中国工商银行股份有限公司 | Data query method and device |
| CN112035102A (en) * | 2020-07-30 | 2020-12-04 | 海尔优家智能科技（北京）有限公司 | Configuration method and device of data interface, storage medium and electronic device |
| CN112187849A (en) * | 2020-08-06 | 2021-01-05 | 深圳市麦谷科技有限公司 | Cache data dynamic generation method and system |
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112347114A (en) * | 2020-10-29 | 2021-02-09 | 有半岛(北京)信息科技有限公司 | Data query system, data query method, data query device and server |
| CN112560420A (en) * | 2020-12-08 | 2021-03-26 | 中国建设银行股份有限公司 | Method and device for automatically generating report file |
| CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
| CN112598289A (en) * | 2020-12-25 | 2021-04-02 | 平安银行股份有限公司 | Index configuration method, system, computer device and computer readable storage medium |
| CN112732734A (en) * | 2020-12-31 | 2021-04-30 | 上海瑞家信息技术有限公司 | Information processing method and device |
| CN112784139A (en) * | 2021-01-13 | 2021-05-11 | 多点(深圳)数字科技有限公司 | Query method, query device, electronic equipment and computer readable medium |
| CN112783914A (en) * | 2019-11-01 | 2021-05-11 | 北京京东振世信息技术有限公司 | Statement optimization method and device |
| CN112818202A (en) * | 2019-11-18 | 2021-05-18 | 北京京东振世信息技术有限公司 | Data query method and device |
| CN112835573A (en) * | 2021-01-27 | 2021-05-25 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113239044A (en) * | 2021-05-18 | 2021-08-10 | 安翰科技(武汉)股份有限公司 | Management device and application system of SQL records for query |
| CN113282585A (en) * | 2021-05-28 | 2021-08-20 | 山东浪潮通软信息科技有限公司 | Report calculation method, device, equipment and medium |
| CN113420051A (en) * | 2021-06-30 | 2021-09-21 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| CN113486116A (en) * | 2021-07-07 | 2021-10-08 | 建信金融科技有限责任公司 | Data synchronization method and device, electronic equipment and computer readable medium |
| CN113641706A (en) * | 2020-05-11 | 2021-11-12 | 北京沃东天骏信息技术有限公司 | Data query method and device |
| CN113761088A (en) * | 2020-07-01 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Method and device for processing position data |
| CN113806504A (en) * | 2021-08-27 | 2021-12-17 | 北京金蝶云基科技有限公司 | Multi-dimensional report data calculation method and device and computer equipment |
| CN115617859A (en) * | 2022-12-16 | 2023-01-17 | 安徽华云安科技有限公司 | Data query method and device based on knowledge graph cluster |
| WO2023029592A1 (en) * | 2021-08-30 | 2023-03-09 | 北京沃东天骏信息技术有限公司 | Data processing method and apparatus |
| WO2023045054A1 (en) * | 2021-09-27 | 2023-03-30 | 苏宁易购集团股份有限公司 | Structured query statement generation method and apparatus, and computer device |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003065179A2 (en) * | 2002-02-01 | 2003-08-07 | John Fairweather | A system and method for mining data |
| CN101216840A (en) * | 2008-01-21 | 2008-07-09 | 金蝶软件（中国）有限公司 | Data enquiry method and data enquiry system |
| CN102254008A (en) * | 2011-07-18 | 2011-11-23 | 深圳证券信息有限公司 | Method and system for setting dynamic data label |
| CN103823815A (en) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | Server and database access method |
| CN104809254A (en) * | 2015-05-19 | 2015-07-29 | 郑州悉知信息技术有限公司 | Data query method and device |
| CN104903891A (en) * | 2012-10-31 | 2015-09-09 | 1C有限责任公司 | Automated report generation method |
| CN105471931A (en) * | 2014-08-06 | 2016-04-06 | 腾讯科技（北京）有限公司 | Method, device and system for querying service data |
| CN105487864A (en) * | 2015-11-26 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and device for automatically generating code |
| US20160162535A1 (en) * | 2014-12-03 | 2016-06-09 | Verizon Patent And Licensing Inc. | Relational data model variant |
| CN106202361A (en) * | 2016-07-07 | 2016-12-07 | 上海携程商务有限公司 | Data query method and system |
| CN106843878A (en) * | 2017-01-20 | 2017-06-13 | 武汉斗鱼网络科技有限公司 | A kind of model generating method and system |
-
2017
- 2017-07-28 CN CN201710631092.7A patent/CN110019350B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003065179A2 (en) * | 2002-02-01 | 2003-08-07 | John Fairweather | A system and method for mining data |
| CN101216840A (en) * | 2008-01-21 | 2008-07-09 | 金蝶软件（中国）有限公司 | Data enquiry method and data enquiry system |
| CN102254008A (en) * | 2011-07-18 | 2011-11-23 | 深圳证券信息有限公司 | Method and system for setting dynamic data label |
| CN104903891A (en) * | 2012-10-31 | 2015-09-09 | 1C有限责任公司 | Automated report generation method |
| CN103823815A (en) * | 2012-11-19 | 2014-05-28 | 中国联合网络通信集团有限公司 | Server and database access method |
| CN105471931A (en) * | 2014-08-06 | 2016-04-06 | 腾讯科技（北京）有限公司 | Method, device and system for querying service data |
| US20160162535A1 (en) * | 2014-12-03 | 2016-06-09 | Verizon Patent And Licensing Inc. | Relational data model variant |
| CN104809254A (en) * | 2015-05-19 | 2015-07-29 | 郑州悉知信息技术有限公司 | Data query method and device |
| CN105487864A (en) * | 2015-11-26 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and device for automatically generating code |
| CN106202361A (en) * | 2016-07-07 | 2016-12-07 | 上海携程商务有限公司 | Data query method and system |
| CN106843878A (en) * | 2017-01-20 | 2017-06-13 | 武汉斗鱼网络科技有限公司 | A kind of model generating method and system |
Cited By (45)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110427188B (en) * | 2019-08-02 | 2023-06-09 | 深圳前海微众银行股份有限公司 | Configuration method, device, equipment and storage medium of single-test assertion program |
| CN110427188A (en) * | 2019-08-02 | 2019-11-08 | 深圳前海微众银行股份有限公司 | It is single to survey configuration method, device, equipment and the storage medium for asserting program |
| CN110781208A (en) * | 2019-09-27 | 2020-02-11 | 支付宝(杭州)信息技术有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN110781208B (en) * | 2019-09-27 | 2022-02-11 | 支付宝(杭州)信息技术有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN110764769A (en) * | 2019-10-21 | 2020-02-07 | 苏州思必驰信息科技有限公司 | Method and device for processing user request |
| CN110764769B (en) * | 2019-10-21 | 2022-07-08 | 思必驰科技股份有限公司 | Method and device for processing user request |
| CN110716960A (en) * | 2019-10-22 | 2020-01-21 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
| CN112783914A (en) * | 2019-11-01 | 2021-05-11 | 北京京东振世信息技术有限公司 | Statement optimization method and device |
| CN112783914B (en) * | 2019-11-01 | 2023-09-01 | 北京京东振世信息技术有限公司 | Method and device for optimizing sentences |
| CN112818202A (en) * | 2019-11-18 | 2021-05-18 | 北京京东振世信息技术有限公司 | Data query method and device |
| CN111198968A (en) * | 2019-12-11 | 2020-05-26 | 中国建设银行股份有限公司 | Data query method and device |
| CN111177183A (en) * | 2019-12-24 | 2020-05-19 | 中国建设银行股份有限公司 | Method and device for generating database access statement |
| CN111177183B (en) * | 2019-12-24 | 2023-07-04 | 中国建设银行股份有限公司 | Method and device for generating database access statement |
| CN111339140A (en) * | 2020-02-21 | 2020-06-26 | 北京三快在线科技有限公司 | Data query method and device, storage medium and electronic equipment |
| CN113641706A (en) * | 2020-05-11 | 2021-11-12 | 北京沃东天骏信息技术有限公司 | Data query method and device |
| CN111597205B (en) * | 2020-05-26 | 2024-02-13 | 北京金堤科技有限公司 | Template configuration method, information extraction device, electronic equipment and medium |
| CN111597205A (en) * | 2020-05-26 | 2020-08-28 | 北京金堤科技有限公司 | Template configuration method, information extraction method, device, electronic equipment and medium |
| CN111767297B (en) * | 2020-06-30 | 2023-07-04 | 深圳平安智慧医健科技有限公司 | Big data processing method, device, equipment and medium |
| CN111767297A (en) * | 2020-06-30 | 2020-10-13 | 平安国际智慧城市科技股份有限公司 | Big data processing method, device, equipment and medium |
| CN113761088A (en) * | 2020-07-01 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Method and device for processing position data |
| CN112035102A (en) * | 2020-07-30 | 2020-12-04 | 海尔优家智能科技（北京）有限公司 | Configuration method and device of data interface, storage medium and electronic device |
| CN112187849A (en) * | 2020-08-06 | 2021-01-05 | 深圳市麦谷科技有限公司 | Cache data dynamic generation method and system |
| CN111897849B (en) * | 2020-08-21 | 2023-09-15 | 中国工商银行股份有限公司 | Data query method and device |
| CN111897849A (en) * | 2020-08-21 | 2020-11-06 | 中国工商银行股份有限公司 | Data query method and device |
| CN112347114A (en) * | 2020-10-29 | 2021-02-09 | 有半岛(北京)信息科技有限公司 | Data query system, data query method, data query device and server |
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112560420A (en) * | 2020-12-08 | 2021-03-26 | 中国建设银行股份有限公司 | Method and device for automatically generating report file |
| CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
| CN112598289A (en) * | 2020-12-25 | 2021-04-02 | 平安银行股份有限公司 | Index configuration method, system, computer device and computer readable storage medium |
| CN112732734A (en) * | 2020-12-31 | 2021-04-30 | 上海瑞家信息技术有限公司 | Information processing method and device |
| CN112784139A (en) * | 2021-01-13 | 2021-05-11 | 多点(深圳)数字科技有限公司 | Query method, query device, electronic equipment and computer readable medium |
| CN112835573A (en) * | 2021-01-27 | 2021-05-25 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and storage medium |
| CN112835573B (en) * | 2021-01-27 | 2023-08-04 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113239044A (en) * | 2021-05-18 | 2021-08-10 | 安翰科技(武汉)股份有限公司 | Management device and application system of SQL records for query |
| CN113282585B (en) * | 2021-05-28 | 2023-12-29 | 浪潮通用软件有限公司 | Report calculation method, device, equipment and medium |
| CN113282585A (en) * | 2021-05-28 | 2021-08-20 | 山东浪潮通软信息科技有限公司 | Report calculation method, device, equipment and medium |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| CN113420051B (en) * | 2021-06-30 | 2023-08-29 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113420051A (en) * | 2021-06-30 | 2021-09-21 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113486116A (en) * | 2021-07-07 | 2021-10-08 | 建信金融科技有限责任公司 | Data synchronization method and device, electronic equipment and computer readable medium |
| CN113806504A (en) * | 2021-08-27 | 2021-12-17 | 北京金蝶云基科技有限公司 | Multi-dimensional report data calculation method and device and computer equipment |
| CN113806504B (en) * | 2021-08-27 | 2024-04-02 | 北京金蝶云基科技有限公司 | Multi-dimensional report data calculation method and device and computer equipment |
| WO2023029592A1 (en) * | 2021-08-30 | 2023-03-09 | 北京沃东天骏信息技术有限公司 | Data processing method and apparatus |
| WO2023045054A1 (en) * | 2021-09-27 | 2023-03-30 | 苏宁易购集团股份有限公司 | Structured query statement generation method and apparatus, and computer device |
| CN115617859A (en) * | 2022-12-16 | 2023-01-17 | 安徽华云安科技有限公司 | Data query method and device based on knowledge graph cluster |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019350B (en) | 2021-06-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019350A (en) | Data query method and apparatus based on configuration information | |
| US11640474B2 (en) | Method and apparatus for operating database | |
| CN110019211A (en) | The methods, devices and systems of association index | |
| CN109189835A (en) | The method and apparatus of the wide table of data are generated in real time | |
| CN109683998A (en) | Internationalize implementation method, device and system | |
| CN109413127A (en) | A kind of method of data synchronization and device | |
| CN110472207A (en) | List generation method and device | |
| US20210357461A1 (en) | Method, apparatus and storage medium for searching blockchain data | |
| CN110427438A (en) | Data processing method and its device, electronic equipment and medium | |
| CN107506218A (en) | The management method and management system of a kind of configuration file | |
| CN112182004B (en) | Method, device, computer equipment and storage medium for checking data in real time | |
| CN110110196A (en) | A kind of information push method and device | |
| CN111814024A (en) | Distributed data acquisition method, system and storage medium | |
| CN109039817A (en) | A kind of information processing method and device for traffic monitoring | |
| CN110019539A (en) | A kind of method and apparatus that the data of data warehouse are synchronous | |
| CN113190517B (en) | Data integration method and device, electronic equipment and computer readable medium | |
| CN109086414B (en) | Method, apparatus and storage medium for searching blockchain data | |
| CN110109983B (en) | Method and device for operating Redis database | |
| US20230153357A1 (en) | Method of processing an observation information, electronic device and storage medium | |
| CN107729394A (en) | Data Mart management system and its application method based on Hadoop clusters | |
| CN109145209B (en) | Method, apparatus and storage medium for searching blockchain data | |
| CN115033574A (en) | Information generation method, information generation device, electronic device, and storage medium | |
| CN110347654A (en) | A kind of method and apparatus of online cluster features | |
| CN114003659A (en) | Data synchronization method, data synchronization device, electronic equipment, storage medium and program product | |
| CN110020373A (en) | The method and apparatus that static page is stored, browsed |
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 |