CN110909022A - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN110909022A CN110909022A CN201811073741.7A CN201811073741A CN110909022A CN 110909022 A CN110909022 A CN 110909022A CN 201811073741 A CN201811073741 A CN 201811073741A CN 110909022 A CN110909022 A CN 110909022A
- Authority
- CN
- China
- Prior art keywords
- data
- data query
- multidimensional
- identification
- cache
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000004590 computer program Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 description 12
- 238000012545 processing Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method and a data query device, and relates to the technical field of computers. One embodiment of the method comprises: determining a data query identifier according to a data query request, wherein the data query request is used for querying multidimensional data; reading the multidimensional data in a database by using multiple threads, and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data; and querying the multidimensional data in the cache according to the data query identification. The implementation method can improve the query speed, evenly share the database pressure, avoid the risk of querying the main database by the large SQL and reduce the pressure of data query.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data query method and a data query device.
Background
In the context of multidimensional data queries, for statistical data of different dimensions, because each data is of a different dimension, the conventional approach is to sequentially query the data of one dimension to form an entity object return page or a required logic. In the existing query mode of multi-dimensional data, single thread statistics is carried out one by one, and a main library is used for data query.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
the query speed is slow, the database pressure cannot be shared uniformly, the pressure of data such as statistics and the like to the database is larger, a risk point is formed when a connection is occupied for a long time and is not released when the call volume is slightly higher, and other functions of the system can be influenced when the query pressure is larger.
Disclosure of Invention
In view of this, embodiments of the present invention provide a data query method and apparatus, which can improve query speed, share database pressure, avoid risk of querying a master database with a large SQL (structured query language), and reduce data query pressure.
To achieve the above object, according to an aspect of an embodiment of the present invention, a data query method is provided.
A method of data query, comprising: determining a data query identifier according to a data query request, wherein the data query request is used for querying multidimensional data; reading the multidimensional data in a database by using multiple threads, and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data; and querying the multidimensional data in the cache according to the data query identification.
Optionally, the step of reading the multidimensional data in the database using multiple threads is preceded by: and confirming that the data with the data query identification as the cache identification does not exist in the cache.
Optionally, the step of determining a data query identifier according to the data query request includes: and generating a number corresponding to the submission time period according to the submission time period of the data query request, and determining the number as the data query identifier.
Optionally, the step of reading the multidimensional data in the database by using multiple threads, and caching the multidimensional data by using the data query identifier as a cache identifier of the multidimensional data includes: reading the multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database; organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through the data query identifier; and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data.
According to another aspect of the embodiments of the present invention, a data query apparatus is provided.
A data query apparatus, comprising: the identification determining module is used for determining a data query identification according to a data query request, wherein the data query request is used for querying multidimensional data; the data caching module is used for reading the multidimensional data in a database by using multithreading, and caching the multidimensional data by taking the data query identification as a caching identification of the multidimensional data; and the data query module is used for querying the multidimensional data in the cache according to the data query identification.
Optionally, the apparatus further comprises a determining module, configured to: and confirming that the data with the data query identification as the cache identification does not exist in the cache.
Optionally, the identification determination module is further configured to: and generating a number corresponding to the submission time period according to the submission time period of the data query request, and determining the number as the data query identifier.
Optionally, the data caching module is further configured to: reading the multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database; organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through the data query identifier; and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data.
According to yet another aspect of an embodiment of the present invention, an electronic device is provided.
An electronic device, comprising: one or more processors; a memory for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the data query method provided by the present invention.
According to yet another aspect of an embodiment of the present invention, a computer-readable medium is provided.
A computer-readable medium, on which a computer program is stored, which, when executed by a processor, implements the data query method provided by the present invention.
One embodiment of the above invention has the following advantages or benefits: determining a data query identifier according to the data query request, reading multidimensional data in a database by using multiple threads, reading one-dimensional data from the database by each thread, caching the multidimensional data by taking the data query identifier as a cache identifier of the multidimensional data, and querying the multidimensional data in the cache according to the data query identifier. The query speed can be improved, the slave libraries are fully utilized, the database pressure is shared equally, the risk of querying the master library by the large SQL is avoided, and the data query pressure is reduced.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a diagram illustrating the main steps of a data query method according to an embodiment of the present invention;
FIG. 2 is a schematic flow diagram of a data query according to an embodiment of the invention;
FIG. 3 is a schematic diagram of the main modules of a data query device according to an embodiment of the present invention;
FIG. 4 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 5 is a schematic block diagram of a computer system suitable for use in implementing a terminal device or server of an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
Fig. 1 is a schematic diagram of main steps of a data query method according to an embodiment of the present invention.
As shown in fig. 1, the data query method according to the embodiment of the present invention mainly includes the following steps S101 to S103.
Step S101: and determining a data query identifier according to the data query request, wherein the data query request is used for querying the multidimensional data.
The number corresponding to the submission time period can be generated according to the submission time period of the data query request, and the number is determined as the data query identifier.
The number is generated according to the submission time period of the data query request, and specifically, a number corresponding to the time period to which the submission time of the data query request belongs may be generated, and the numbers determined by the data query requests submitted in the time period are the same, that is, the data query identifiers are the same. The number generation rule is, for example: presetting a time period, wherein the number of milliseconds carried by all data query requests in the time period is the starting time point of the time period, taking the time period as 10 minutes as an example, the number of the milliseconds is equal to the number of the milliseconds of 14:20:00 in 6 and 10 months in 2018 and 14:29:59 in 6 and 10 months in 2018, and the number of the milliseconds is determined to be equal to the number of the milliseconds of 14:20:00 in 6 and 10 months in 2018. In other embodiments, the number may also be seconds, minutes, hours, etc. of the starting time point of the time period, or a time series with a number equal to the starting time point, such as 20180610142000.
Step S102: and reading multidimensional data in the database by using multithreading, taking the data query identification as a cache identification of the multidimensional data, and caching the multidimensional data.
Before step S102, it may be determined whether data using the data query identifier as a cache identifier exists in the cache, and if it is determined that data using the data query identifier as a cache identifier does not exist in the cache, step S102 is executed, and then the expiration time of the cache is set. Otherwise, reading the multidimensional data with the data query identification as the cache identification from the cache.
Step S102 may include: reading multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database; organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through a data query identifier; and taking the data query identification as a cache identification of the multidimensional data, and caching the multidimensional data.
The multidimensional data returned by each thread is organized, specifically, the multidimensional data returned by each thread can be counted according to the dimension, and the counted multidimensional data is associated through a data query identifier. For example, statistics is performed on dimensions such as "number of checks and accepts today", "number of checked and accepted today", "number of historically not checked and accepted today", "number of due-to-be-checked and accepted today", and correlation is established on the data of each counted dimension through a data query identifier.
The multi-dimensional data is read from a plurality of slave databases by a plurality of threads, for example, when statistical data of a certain dimension is calculated, a first slave database is used for inquiring required data, when second statistical data is calculated, a second slave database is used for inquiring required data, and the like, if the slave libraries are less, the first slave library can be used again after all the slave libraries are circularly used. The embodiment of the invention can use a CountDownLatch (latch in java thread) to block the main thread, when all sub-threads return data, the main thread continues to execute, the multidimensional data returned by each thread are organized, the multidimensional data are associated through the data query identification, a local variable can be used for temporarily storing the data during data organization, and the format is as follows: map < number, Map < service KEY, statistical number >, and finally, once storing the temporarily stored data into a cache (e.g., a REmote DIctionary Server, a KEY-value storage system)).
Step S103: and querying the multidimensional data in the cache according to the data query identification.
As shown in fig. 2, after receiving a data query request, the data query process in this embodiment of the present invention may first obtain multidimensional data (i.e., cache data in fig. 2) from a cache by using a number generated according to the data query request, return the obtained multidimensional data to a caller submitting the data query request (not shown in fig. 2) if the multidimensional data with the number as a cache identifier is obtained from the cache, obtain the multidimensional data from libraries 1 to 3 respectively by using a processing thread 1, a processing thread 2, and a processing thread 3 (in this embodiment, three processing threads (sub-threads), and three slave libraries are taken as examples) if the multidimensional data is not obtained from the cache, and after all the processing threads return data with corresponding dimensions, use the generated number as a cache identifier, and writing the data into a cache so that the multidimensional data can be obtained from the cache according to the number. The embodiment of the invention can improve the query speed, fully utilize the slave library, realize the uniform database pressure, avoid the risk of querying the master library by large SQL, reduce the pressure of data query, and have no influence on other functions of the system when the query pressure is higher.
Fig. 3 is a schematic diagram of main blocks of a data query device according to an embodiment of the present invention.
As shown in fig. 3, the data query apparatus 300 according to the embodiment of the present invention mainly includes: an identification determination module 301, a data caching module 302 and a data query module 303.
An identifier determining module 301, configured to determine a data query identifier according to a data query request, where the data query request is used to query multidimensional data.
The identifier determining module 301 may specifically be configured to: and generating a number corresponding to the submission time period according to the submission time period of the data query request, and determining the number as a data query identifier.
The data caching module 302 is configured to read multidimensional data in the database using multiple threads, and cache the multidimensional data by using the data query identifier as a cache identifier of the multidimensional data.
The data caching module 302 may be specifically configured to: reading multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database; organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through a data query identifier; and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data.
And the data query module 303 is configured to query the multidimensional data in the cache according to the data query identifier.
The data query apparatus 300 may further include a determining module configured to: and confirming that the data with the data query identification as the cache identification does not exist in the cache.
In addition, the detailed implementation of the data query device in the embodiment of the present invention has been described in detail in the above data query method, so that repeated descriptions herein are not repeated.
Fig. 4 shows an exemplary system architecture 400 of a data query method or data query device to which embodiments of the present invention may be applied.
As shown in fig. 4, the system architecture 400 may include terminal devices 401, 402, 403, a network 404, and a server 405. The network 404 serves as a medium for providing communication links between the terminal devices 401, 402, 403 and the server 405. Network 404 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.
A user may use terminal devices 401, 402, 403 to interact with a server 405 over a network 404 to receive or send messages or the like. The terminal devices 401, 402, 403 may have installed thereon various communication client applications, such as shopping-like applications, web browser applications, search-like applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).
The terminal devices 401, 402, 403 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 405 may be a server providing various services, such as a background management server (for example only) providing support for shopping websites browsed by users using the terminal devices 401, 402, 403. The backend management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (for example, target push information, product information — just an example) to the terminal device.
It should be noted that the data query method provided by the embodiment of the present invention is generally executed by the server 405, and accordingly, the data query apparatus is generally disposed in the server 405.
It should be understood that the number of terminal devices, networks, and servers in fig. 4 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 5, a block diagram of a computer system 500 suitable for use in implementing a terminal device or server of an embodiment of the present application is shown. The terminal device or the server shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present application.
As shown in fig. 5, the computer system 500 includes a Central Processing Unit (CPU)501 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data necessary for the operation of the system 500 are also stored. The CPU 501, ROM 502, and RAM 503 are connected to each other via a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
The following components are connected to the I/O interface 505: an input portion 506 including a keyboard, a mouse, and the like; an output portion 507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 508 including a hard disk and the like; and a communication section 509 including a network interface card such as a LAN card, a modem, or the like. The communication section 509 performs communication processing via a network such as the internet. The driver 510 is also connected to the I/O interface 505 as necessary. A removable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 510 as necessary, so that a computer program read out therefrom is mounted into the storage section 508 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 509, and/or installed from the removable medium 511. The above-described functions defined in the system of the present application are executed when the computer program is executed by the Central Processing Unit (CPU) 501.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present application, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In this application, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor comprises an identification determination module, a data caching module and a data query module. Where the names of these modules do not in some cases constitute a limitation on the modules themselves, for example, the identity determination module may also be described as a "module for determining a data query identity from a data query request".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to comprise: determining a data query identifier according to a data query request, wherein the data query request is used for querying multidimensional data; reading the multidimensional data in a database by using multiple threads, and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data; and querying the multidimensional data in the cache according to the data query identification.
According to the technical scheme of the embodiment of the invention, the data query identification is determined according to the data query request, the multi-dimensional data in the database is read by multiple threads, each thread reads the data of one dimension from the database, the data query identification is used as the cache identification of the multi-dimensional data, the multi-dimensional data is cached, and the multi-dimensional data in the cache is queried according to the data query identification. The query speed can be increased, the slave libraries are fully utilized, the database pressure is shared equally, the risk of large SQL query of the master library is avoided, the data query pressure is reduced, and other functions of the system cannot be influenced when the query pressure is large.
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for querying data, comprising:
determining a data query identifier according to a data query request, wherein the data query request is used for querying multidimensional data;
reading the multidimensional data in a database by using multiple threads, and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data;
and querying the multidimensional data in the cache according to the data query identification.
2. The method of claim 1, wherein the step of reading the multidimensional data in the database using multiple threads is preceded by the steps of:
and confirming that the data with the data query identification as the cache identification does not exist in the cache.
3. The method of claim 1, wherein the step of determining the data query identity from the data query request comprises:
and generating a number corresponding to the submission time period according to the submission time period of the data query request, and determining the number as the data query identifier.
4. The method of claim 1, wherein the step of caching the multidimensional data using multiple threads to read the multidimensional data from a database and using the data query identifier as a cache identifier for the multidimensional data comprises:
reading the multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database;
organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through the data query identifier;
and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data.
5. A data query apparatus, comprising:
the identification determining module is used for determining a data query identification according to a data query request, wherein the data query request is used for querying multidimensional data;
the data caching module is used for reading the multidimensional data in a database by using multithreading, and caching the multidimensional data by taking the data query identification as a caching identification of the multidimensional data;
and the data query module is used for querying the multidimensional data in the cache according to the data query identification.
6. The apparatus of claim 5, further comprising a determining module configured to:
and confirming that the data with the data query identification as the cache identification does not exist in the cache.
7. The apparatus of claim 5, wherein the identity determination module is further configured to:
and generating a number corresponding to the submission time period according to the submission time period of the data query request, and determining the number as the data query identifier.
8. The apparatus of claim 5, wherein the data caching module is further configured to:
reading the multidimensional data from a plurality of slave databases using a plurality of threads, wherein each thread reads data of one dimension from one slave database;
organizing the multidimensional data returned by each thread, and establishing association of the organized multidimensional data through the data query identifier;
and caching the multidimensional data by taking the data query identification as a cache identification of the multidimensional data.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method recited in any of claims 1-4.
10. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073741.7A CN110909022A (en) | 2018-09-14 | 2018-09-14 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073741.7A CN110909022A (en) | 2018-09-14 | 2018-09-14 | Data query method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110909022A true CN110909022A (en) | 2020-03-24 |
Family
ID=69812324
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811073741.7A Pending CN110909022A (en) | 2018-09-14 | 2018-09-14 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110909022A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111737257A (en) * | 2020-06-16 | 2020-10-02 | 中国银行股份有限公司 | Data query method and device |
| CN112434060A (en) * | 2020-12-09 | 2021-03-02 | 北京有竹居网络技术有限公司 | Data query method and system |
| CN112506970A (en) * | 2020-12-11 | 2021-03-16 | 中信银行股份有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| CN113760860A (en) * | 2020-11-12 | 2021-12-07 | 北京京东振世信息技术有限公司 | Data reading method and device |
| CN113986438A (en) * | 2021-10-30 | 2022-01-28 | 深圳市快易典教育科技有限公司 | Animation loading method, system, device and computer readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002003251A2 (en) * | 2000-06-29 | 2002-01-10 | Alphablox Corporation | Caching scheme for multi-dimensional data |
| US20150095364A1 (en) * | 2013-09-30 | 2015-04-02 | Lexmark International Technology, S.A. | System and Methods for Caching and Querying Objects Stored in Multiple Databases |
| WO2015062201A1 (en) * | 2013-10-30 | 2015-05-07 | 华为技术有限公司 | Data query method, device, server and system |
| CN107229623A (en) * | 2016-03-23 | 2017-10-03 | 泰康保险集团股份有限公司 | Data query processing method and processing device |
| CN107315751A (en) * | 2016-04-26 | 2017-11-03 | 北京京东尚科信息技术有限公司 | Multidimensional data query method and device |
| CN108241627A (en) * | 2016-12-23 | 2018-07-03 | 北京神州泰岳软件股份有限公司 | A kind of isomeric data storage querying method and system |
-
2018
- 2018-09-14 CN CN201811073741.7A patent/CN110909022A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002003251A2 (en) * | 2000-06-29 | 2002-01-10 | Alphablox Corporation | Caching scheme for multi-dimensional data |
| US20150095364A1 (en) * | 2013-09-30 | 2015-04-02 | Lexmark International Technology, S.A. | System and Methods for Caching and Querying Objects Stored in Multiple Databases |
| WO2015062201A1 (en) * | 2013-10-30 | 2015-05-07 | 华为技术有限公司 | Data query method, device, server and system |
| CN107229623A (en) * | 2016-03-23 | 2017-10-03 | 泰康保险集团股份有限公司 | Data query processing method and processing device |
| CN107315751A (en) * | 2016-04-26 | 2017-11-03 | 北京京东尚科信息技术有限公司 | Multidimensional data query method and device |
| CN108241627A (en) * | 2016-12-23 | 2018-07-03 | 北京神州泰岳软件股份有限公司 | A kind of isomeric data storage querying method and system |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111737257A (en) * | 2020-06-16 | 2020-10-02 | 中国银行股份有限公司 | Data query method and device |
| CN113760860A (en) * | 2020-11-12 | 2021-12-07 | 北京京东振世信息技术有限公司 | Data reading method and device |
| CN113760860B (en) * | 2020-11-12 | 2023-09-22 | 北京京东振世信息技术有限公司 | Data reading method and device |
| CN112434060A (en) * | 2020-12-09 | 2021-03-02 | 北京有竹居网络技术有限公司 | Data query method and system |
| CN112506970A (en) * | 2020-12-11 | 2021-03-16 | 中信银行股份有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| CN113986438A (en) * | 2021-10-30 | 2022-01-28 | 深圳市快易典教育科技有限公司 | Animation loading method, system, device and computer readable storage medium |
| CN113986438B (en) * | 2021-10-30 | 2024-01-30 | 深圳市快易典教育科技有限公司 | Animation loading method, system, device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110909022A (en) | Data query method and device | |
| CN109918191B (en) | Method and device for preventing frequency of service request | |
| CN107844488B (en) | Data query method and device | |
| CN111061680A (en) | Data retrieval method and device | |
| CN112948498A (en) | Method and device for generating global identification of distributed system | |
| CN113761565B (en) | Data desensitization method and device | |
| CN113641706A (en) | Data query method and device | |
| CN112948138A (en) | Method and device for processing message | |
| CN113722113A (en) | Traffic statistic method and device | |
| CN113726885A (en) | Method and device for adjusting flow quota | |
| CN113704222A (en) | Method and device for processing service request | |
| CN110019671B (en) | Method and system for processing real-time message | |
| CN113704242A (en) | Data processing method and device | |
| CN112579615A (en) | Method and device for realizing distributed lock | |
| CN113535768A (en) | Production monitoring method and device | |
| CN112988857A (en) | Service data processing method and device | |
| CN111125112A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN112214500A (en) | Data comparison method and device, electronic equipment and storage medium | |
| CN112783914A (en) | Statement optimization method and device | |
| CN112131287A (en) | Method and device for reading data | |
| CN113760860B (en) | Data reading method and device | |
| US11868423B1 (en) | Generation of filter and parameter context URIs | |
| CN117478535B (en) | Log storage method and device | |
| CN113127700A (en) | Method, device, equipment and computer readable medium for accessing data source | |
| CN116303566A (en) | Data query method and device |
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 |