CN110515979A - Data query method, apparatus, equipment and storage medium - Google Patents
Data query method, apparatus, equipment and storage medium Download PDFInfo
- Publication number
- CN110515979A CN110515979A CN201910828306.9A CN201910828306A CN110515979A CN 110515979 A CN110515979 A CN 110515979A CN 201910828306 A CN201910828306 A CN 201910828306A CN 110515979 A CN110515979 A CN 110515979A
- Authority
- CN
- China
- Prior art keywords
- data
- activity
- business
- memory space
- checked
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of data query method, apparatus, equipment and storage mediums, wherein this method comprises: obtaining the goal activities being buffered in memory space in advance according to data inquiry request；The target service data in database tables of data to be checked are obtained according to the goal activities.The preparatory of the embodiment of the present invention stores goal activities to be checked to buffer zone, reduce the volume of transmitted data of data query process, without being screened according to data inquiry request to data, the computing cost of server is reduced, the efficiency of data query in database is improved.
Description
Technical field
The present embodiments relate to computer application technology more particularly to a kind of data query method, apparatus, equipment
And storage medium.
Background technique
With the development of internet technology, data are successfully the valuable source of Internet company, and existing Internet company exists
When storage service data, by the storage of different types of data into different database tables, for example, business activity rule and user
Business information is respectively stored into active rule table and customer service table.According to being stored in active rule table and customer service table
Business activity rule and customer service generate the individual center that corresponding personal business information is shown to user.
Business activity rule and user service information are respectively stored into active rule table and customer service table in the prior art,
Referring to Fig. 1, it is stored with activity SN and Customs Assigned Number in customer service table, is stored with rule numbers and order in active rule table
When needing to inquire user service data, all business of user are found according to Customs Assigned Number in user service data table for type
Data get active rule according to order type and rule numbers, in the buffer according to the active rule screening institute found
There is business datum to get the user service data for meeting Operations Requirements.Above-mentioned technical solution has two, is first
It needs to read all business datums of user from database, network data transmission expense is big；Followed by, basis in memory is needed
Active rule screens all business datums, when user service information is more, expends a large amount of server computing resources.
Summary of the invention
The present invention provides a kind of data query method, apparatus, equipment and storage medium, to realize the efficient of database data
Inquiry, reduces the computing cost of server, and improve the efficiency of transmission of data.
In a first aspect, the embodiment of the invention provides a kind of data query methods, this method comprises:
The goal activities being buffered in memory space in advance are obtained according to data inquiry request；
The target service data in database tables of data to be checked are obtained according to the goal activities.
Second aspect, the embodiment of the invention also provides a kind of data query device, which includes:
Cache match module, for obtaining the goal activities being buffered in memory space in advance according to data inquiry request；
Database matching module, for obtaining the target service number in database tables of data to be checked according to the goal activities
According to.
The third aspect, the embodiment of the invention also provides a kind of equipment, which includes:
One or more processors；
Memory, 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 processing
Device realizes the data query method as described in any in the embodiment of the present invention.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer
Program realizes the data query method as described in any in the embodiment of the present invention when program is executed by processor.
It is living to obtain the target being buffered in memory space by data inquiry request for the technical solution of the embodiment of the present invention
It is dynamic, corresponding target service data are searched in the database according to goal activities, by the way that activity data is buffered in storage in advance
In space, the query time for obtaining business datum is shortened, the computing cost of server is reduced, data query effect can be improved
Rate.
Detailed description of the invention
Fig. 1 is the exemplary diagram of data query in the prior art；
Fig. 2 is a kind of step flow chart for data query method that the embodiment of the present invention one provides；
Fig. 3 is a kind of step flow chart of data query method provided by Embodiment 2 of the present invention；
Fig. 4 is a kind of exemplary diagram of data query method provided by Embodiment 2 of the present invention；
Fig. 5 is a kind of structural schematic diagram for data query device that the embodiment of the present invention three provides；
Fig. 6 is a kind of structural schematic diagram for equipment that the embodiment of the present invention four provides.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
Only the parts related to the present invention are shown in description, attached drawing rather than entire infrastructure, in addition, in the absence of conflict, this
The feature in embodiment and embodiment in invention can be combined with each other.
Embodiment one
Fig. 2 is a kind of step flow chart of data query method provided in an embodiment of the present invention, and the present embodiment is applicable to
The case where business datum that inquiry divides table to store, this method can be executed by data query device, which can be using hard
The mode of part and/or software realizes that referring to fig. 2, method provided in an embodiment of the present invention includes the following steps:
Step 101 obtains the goal activities being buffered in memory space in advance according to data inquiry request.
Wherein, data inquiry request can be the request for being used to obtain data of user's sending, for example, it may be user
It clicks order or shows that order etc. is opened at interface, memory space can be the space for being previously stored with action message, can be height
The memory of fast data exchange directly can carry out data exchange with central processing unit, and goal activities can be data query and ask
The initial data of the target data of acquisition is sought, goal activities can be the target of data inquiry request by screening or after combining
Data.
Specifically, when getting data inquiry request, it can be empty in the storage cached in advance according to data inquiry request
Interior lookup goal activities can be looked into for example, data inquiry request is the corresponding activity favor information of inquiry order according to data
Order information in inquiry request obtains in the memory space cached in advance and the associated activity of order information, can will find
Activity as goal activities.
Step 102 obtains the target service data in database tables of data to be checked according to the goal activities.
Wherein, database can be the data acquisition system for being stored with goal activities and business datum, goal activities and business number
According to the different data table that can store in the database, tables of data to be checked can be the tables of data for being stored with target service data.
It is understood that business datum and goal activities can have incidence relation in tables of data to be checked, for example, the mark of goal activities
Know number can with the identification number of business datum there are corresponding relationships.
In embodiments of the present invention, it can be searched according in the tables of data to be checked of goal activities in the database, when
When finding goal activities, can using with the business datum of goal activities associated storage as target service data.For example, data
Business datum can inquire the mark of goal activities with the identification number associated storage of goal activities in tables of data to be checked in library
Number when, can be using the corresponding business datum of goal activities identification number as target service data.
The technical solution of the embodiment of the present invention, by searching data inquiry request in the memory space cached in advance
Corresponding goal activities are searched in the tables of data to be checked of database according to goal activities, using the data found as
The activity data of database purchase is cached to memory space by target service data, improves data search speed, across table number
It is investigated that asking it is not necessary that when getting data inquiry request, in data cached interior carry out data screening, the technology for reducing server is opened
Pin, improves efficiency data query.
Embodiment two
Fig. 3 is a kind of step flow chart of data query method provided by Embodiment 2 of the present invention, and the embodiment of the present invention is
Materialization on foregoing invention practice processes, referring to Fig. 3, the data query method of the embodiment of the present invention includes:
Step 201, the respectively regular data in the activity data and rule list in reading database activity table.
Wherein, movable table can be the tables of data for being stored with action message, and movable table can store movable relevant information,
It may include movable activity introduction and activity description etc., rule list can be the tables of data for being stored with active rule, rule list
It can store movable effective time and participated in requiring etc. regular, regular data can be the rule stored in movable table, living
Activity data in dynamic table can correspond to different movable data, and regular data can be regular data, it is to be understood that rule
Then multiple regular datas in table can correspond to identical activity, can limit activity.
Specifically, activity data and regular data can store in movable table and rule list in the database, it can be pre-
All activity datas stored in data and regular data are first read, the activity data read and regular data can be cached
To memory space.For example, regular data and activity data can be read, acquisition is worked as before getting data inquiry request
When to data inquiry request, the data stored in caching can be read directly, without from database caches to memory space.
Activity data and regular data are formed business activity, and business activity are cached to space storage by step 202.
Wherein, business activity can be the activity being made of activity data and regular data, and business activity may include living
Dynamic activity description and corresponding active rule, the combination of activity data and regular data can select or automatic according to user
Selection.
In embodiments of the present invention, activity data and regular data can be needed according to user or configuration file carries out
To generate business activity, business activity can generate in the activity space that activity data and regular data cache for combination.For example,
Activity SN and rule numbers can be associated as to active entry number, active entry can be numbered and be used as corresponding business activity,
It is understood that activity data can correspond to multiple regular datas, business activity may include an activity data and multiple
Regular data.
Attribute information to be checked in step 203, extraction data inquiry request.
Wherein, attribute information to be checked may include user information and order type etc., and attribute information to be checked can be obtained with user
Corresponding business activity is taken, for example, different business activities can be corresponded to according to different order types.
In embodiments of the present invention, it may include the attribute information to be checked of user in data inquiry request, get data
When inquiry request, the attribute information to be checked such as the user information for including in data inquiry request and order type can be extracted.
Step 204 determines the corresponding target service activity of regular data that attribute information to be checked meets in memory space.
Wherein, memory space can be the memory that data interaction is directly carried out with central processing unit, can in memory space
To be stored with business activity, when getting data inquiry request, corresponding target industry can be inquired according to attribute information to be checked
Business activity.
Specifically, business activity may include that can search corresponding rule according to attribute information to be checked by regular data
Data, if attribute information to be checked meets the corresponding active rule of regular data, for example, the order in order type and regular data
Type is identical, the target service activity that the corresponding business activity of regular data can be needed to inquire as data inquiry request.
Step 205, using the corresponding activity data of the target service activity as goal activities.
In embodiments of the present invention, target service activity may include regular data and business datum, when data query is asked
It is available with the associated activity data of regular data when attribute to be checked in asking meets the requirement of regular data, for example, can be with
The activity SN with regular data associated storage is got, mesh of the activity data that can be will acquire as data inquiry request
Mark activity.
Step 206 determines data query quantity in data inquiry request.
Wherein, data inquiry request can be the refresh requests at user information revealing interface, can be asked according to data query
Inquiry target data is asked to show in user information revealing interface, it can be according to needing to show target in user information revealing interface
The quantity of data determines that data query quantity in data inquiry request, data query quantity can be the number of inquiry target data
Amount.
Specifically, including the data query quantity for needing to inquire target data in data inquiry request, it can parse data
Inquiry request extracts data query quantity.Further, data query quantity can with shown in user information revealing interface
The quantity of target data is related, for example, need to show 20 target datas in user information revealing interface, it can be by data query
Data query quantity in request is determined as 20.
Step 207, the business datum for searching data query quantity in database tables of data to be checked according to goal activities,
In, tables of data associated storage business datum to be checked and activity data.
Wherein, tables of data to be checked can be by business datum and activity data associated storage, for example, business datum can be with mesh
Movable activity SN associated storage is marked, corresponding business datum can be inquired according to the activity data of goal activities.
Specifically, can be looked into the database according to goal activities after getting goal activities according to data inquiry request
Corresponding business datum is looked for, obtains the business datum of data query quantity as target service data.For example, can be according to target
The tables of data to be checked of movable activity SN in the database searches business datum, the industry of available wherein data query quantity
Data of being engaged in can directly search the business datum of data query quantity as target service data, want without obtaining all to meet
The business datum asked improves the speed of data query.
Step 208, using the business datum found as target service data.
It in embodiments of the present invention, can be using the business datum inquired according to goal activities as target service data.
The technical solution of the embodiment of the present invention, by reading database activity table and rule list to obtain activity data and rule
Activity data and regular data are formed business activity by then data, by business activity storage to memory space, obtain data query
Attribute information to be checked in request determines the corresponding target industry of the regular data met in memory space according to attribute information to be checked
Business activity determines the data query number of data inquiry request using the movable activity data of target service as goal activities are used as
Amount searches the business datum of data query quantity as target service data in database tables of data to be checked；By in advance will
Business activity is buffered in memory space, when obtaining data inquiry request, obtains activity data and regular number without searching database
According to improving efficiency data query, without inquiring all business datums according to activity data and regular data, reduce service
The computing cost of device, improves efficiency data query.
Further, on the basis of foregoing invention embodiment, activity data and regular data are formed into business activity, packet
It includes:
Obtain the preconfigured incidence relation of user；Activity data and regular data are associated work according to incidence relation
For business activity.
In embodiments of the present invention, incidence relation can be the corresponding relationship of activity data and regular data, an activity
Data can correspond to multiple regular datas, and incidence relation can be stored in advance in configuration file, when needing activity data and
When regular data is formed, activity data and regular data can be formed according to the incidence relation in configuration file
Active rule collection is generated, it can be using active rule collection as business activity.
Further, on the basis of foregoing invention embodiment, further includes:
It is when the activity time range of current time business activity not in memory space, the business activity is empty from storage
Interior deletion；When database activity table updates, update business activity is generated according to more new data and is cached to memory space.
Wherein, current time can be the time for updating storage business activity in space, and activity time range can be industry
Movable regular data of being engaged in can determine that business activity is lost if current time is not within the activity time of business activity
Effect, alternatively, when the movable table in database updates, for example, when being stored into new activity data in movable table, it can be according to new
Activity data be added to memory space and form new business activity.
Specifically, the regular data of business activity in memory space is obtained, if the range of current time no longer activity time
When interior, corresponding business activity can be deleted out of memory space；If movable table is stored into more new data in database,
In, the activity data that more new data can be stylish can be according to activity data when being stored into new activity data in movable table
It generates update business activity and is cached to memory space.
Further, raw according to more new data when database activity table updates on the basis of foregoing invention embodiment
Memory space is cached at business activity is updated, comprising:
Obtain the regular data updated in activity data and rule list in database activity table；According to update activity data
It is generated with regular data and updates business activity；The update business activity is cached to memory space.
Specifically, newly added update activity data in available database activity table, it can be according to more New activity number
Business activity is updated according to the regular data composition in group and rule list, business activity can will be updated and be cached to memory space.
Illustratively, Fig. 4 is a kind of exemplary diagram of data query method provided by Embodiment 2 of the present invention, referring to fig. 4, is led to
The active entry that regular data in activity data in movable table and rule list is formed order type and activity SN by timing script is crossed,
It can store active entry as business activity in the buffer, when getting data inquiry request, can search in the buffer
Business activity gets activity SN, target service data can be searched in tables of data to be checked according to activity SN, it can be achieved that
The quick lookup of target data.
Embodiment three
Fig. 5 is a kind of structural schematic diagram for data query device that the embodiment of the present invention three provides, referring to Fig. 5, the present invention
The data query device that embodiment provides can execute the data query method of any embodiment of that present invention offer, have the side of execution
The corresponding functional module of method and beneficial effect, the device can be specifically included by software and or hardware realization: cache match module
301 and database matching module 302.
Wherein, cache match module 301, for obtaining the mesh being buffered in memory space in advance according to data inquiry request
Mark activity.
Database matching module 302, for obtaining the target industry in database tables of data to be checked according to the goal activities
Business data.
The technical solution of the embodiment of the present invention is searched in the memory space cached in advance by cache match module
The corresponding goal activities of data inquiry request, database matching module according to goal activities in the tables of data to be checked of database into
Row is searched, and using the data found as target service data, the activity data of database purchase is cached to memory space,
Data search speed is improved, across table data query is not necessarily to when getting data inquiry request in data cached interior carry out data
Screening, reduces the technology overhead of server, improves efficiency data query.
Further, on the basis of foregoing invention embodiment, data query device further include:
Data read module, for distinguishing the regular number in the activity data and rule list in reading database activity table
According to.
Active cache module for activity data and regular data to be formed business activity, and business activity is cached to
Memory space.
Further, on the basis of foregoing invention embodiment, active cache module includes:
Acquiring unit is configured, for obtaining the preconfigured incidence relation of user.
Activity determination unit, it is living as business for being associated activity data and regular data according to incidence relation
It is dynamic.
Further, on the basis of foregoing invention embodiment, cache match module includes:
Information extraction unit, for extracting the attribute information to be checked in data inquiry request.
Cache lookup unit, for determining attribute information to be checked meets in memory space the corresponding target industry of regular data
Business activity.
Goal activities unit, for using the corresponding activity data of the target service activity as goal activities.
Further, on the basis of foregoing invention embodiment, database matching module includes:
Quantity determination unit, for determining the data query quantity in data inquiry request.
Data searching unit, for searching the industry of data query quantity in database tables of data to be checked according to goal activities
Business data, wherein tables of data associated storage business datum to be checked and activity data.
Target data determination unit, for using the business datum found as target service data.
Further, on the basis of foregoing invention embodiment, further includes:
Movable removing module, when activity time range for current time business activity not in memory space, by institute
Business activity is stated to delete out of memory space.
Processing business and updates module, for it is slow to generate update business activity according to more new data when database activity table updates
It is stored to memory space.
Further, on the basis of foregoing invention embodiment, processing business and updates module includes:
More new data element, for obtaining the regular number updated in activity data and rule list in database activity table
According to.
Business activity unit is updated, updates business activity for generating according to update activity data and regular data；
Cache unit is updated, for the update business activity to be cached to memory space.
Example IV
Fig. 6 is a kind of structural schematic diagram for equipment that the embodiment of the present invention four provides, as shown in fig. 6, the equipment includes place
Manage device 40, memory 41, input unit 42 and output device 43；The quantity of processor 40 can be one or more in equipment,
In Fig. 6 by taking a processor 40 as an example；Processor 40, memory 41, input unit 42 and output device 43 in equipment can be with
It is connected by bus or other modes, in Fig. 6 for being connected by bus.
Memory 71 is used as a kind of computer readable storage medium, can be used for storing software program, journey can be performed in computer
Sequence and module, if the corresponding program module of data query method in the embodiment of the present invention is (for example, in data inquiry module
Cache match module 301 and database matching module 302).The software journey that processor 40 is stored in memory 41 by operation
Sequence, instruction and module realize above-mentioned data query side thereby executing the various function application and data processing of equipment
Method.
Memory 41 can mainly include storing program area and storage data area, wherein storing program area can store operation system
Application program needed for system, at least one function；Storage data area, which can be stored, uses created data etc. according to terminal.This
Outside, memory 41 may include high-speed random access memory, can also include nonvolatile memory, for example, at least a magnetic
Disk storage device, flush memory device or other non-volatile solid state memory parts.In some instances, memory 41 can be further
Including the memory remotely located relative to processor 40, these remote memories can pass through network connection to equipment.It is above-mentioned
The example of network includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Input unit 42 can be used for receiving the number or character information of input, and generate with the user setting of equipment and
The related key signals input of function control.Output device 73 may include that display screen etc. shows equipment.
Embodiment five
The embodiment of the present invention five also provides a kind of storage medium comprising computer executable instructions, and the computer can be held
Row instruction is used to execute a kind of data query method when being executed by computer processor, this method comprises:
The goal activities being buffered in memory space in advance are obtained according to data inquiry request；
The target service data in database tables of data to be checked are obtained according to the goal activities.
Certainly, a kind of storage medium comprising computer executable instructions, computer provided by the embodiment of the present invention
The method operation that executable instruction is not limited to the described above, can also be performed data query provided by any embodiment of the invention
Relevant operation in method.
By the description above with respect to embodiment, it is apparent to those skilled in the art that, the present invention
It can be realized by software and required common hardware, naturally it is also possible to which by hardware realization, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which can store in computer readable storage medium
In, floppy disk, read-only memory (Read-Only Memory, ROM), random access memory (Random such as computer
Access Memory, RAM), flash memory (FLASH), hard disk or CD etc., including some instructions are with so that a computer is set
Standby (can be personal computer, server or the network equipment etc.) executes method described in each embodiment of the present invention.
It is worth noting that, included each unit and module are only pressed in the embodiment of above-mentioned data query device
It is divided, but is not limited to the above division according to function logic, as long as corresponding functions can be realized；In addition,
The specific name of each functional unit is also only for convenience of distinguishing each other, the protection scope being not intended to restrict the invention.
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being carried out by above embodiments to the present invention
It is described in further detail, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, also
It may include more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (10)
1. a kind of data query method characterized by comprising
The goal activities being buffered in memory space in advance are obtained according to data inquiry request；
The target service data in database tables of data to be checked are obtained according to the goal activities.
2. the method according to claim 1, wherein being buffered in the goal activities in memory space in advance, comprising:
Regular data in activity data and rule list in reading database activity table respectively；
Activity data and regular data are formed into business activity, and business activity is cached to memory space.
3. according to the method described in claim 2, it is characterized in that, activity data and regular data are formed business activity, packet
It includes:
Obtain the preconfigured incidence relation of user；
Activity data and regular data are associated as business activity according to incidence relation.
4. being buffered in storage sky in advance the method according to claim 1, wherein obtaining according to data inquiry request
Between in goal activities, comprising:
Extract the attribute information to be checked in data inquiry request；
Determine the corresponding target service activity of regular data that attribute information to be checked meets in memory space；
Using the corresponding activity data of the target service activity as goal activities.
5. the method according to claim 1, wherein obtaining database tables of data to be checked according to the goal activities
In target service data, comprising:
Determine the data query quantity in data inquiry request；
The business datum of data query quantity is searched in database tables of data to be checked according to goal activities, wherein data to be checked
Table associated storage business datum and activity data；
Using the business datum found as target service data.
6. the method according to claim 1, wherein further include:
When the activity time range of current time business activity not in memory space, by the business activity out of memory space
It deletes；
When database activity table updates, update business activity is generated according to more new data and is cached to memory space.
7. according to the method described in claim 6, it is characterized in that, it is described when database activity table update when, according to update number
Memory space is cached to according to update business activity is generated, comprising:
Obtain the regular data updated in activity data and rule list in database activity table；
It is generated according to update activity data and regular data and updates business activity；
The update business activity is cached to memory space.
8. a kind of data query device characterized by comprising
Cache match module, for obtaining the goal activities being buffered in memory space in advance according to data inquiry request；
Database matching module, for obtaining the target service data in database tables of data to be checked according to the goal activities.
9. a kind of equipment, which is characterized in that the equipment includes:
One or more processors；
Memory, 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-7.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
The data query method as described in any in claim 1-7 is realized when execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910828306.9A CN110515979B (en) | 2019-09-03 | 2019-09-03 | Data query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910828306.9A CN110515979B (en) | 2019-09-03 | 2019-09-03 | Data query method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110515979A true CN110515979A (en) | 2019-11-29 |
| CN110515979B CN110515979B (en) | 2022-04-22 |
Family
ID=68630515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910828306.9A Active CN110515979B (en) | 2019-09-03 | 2019-09-03 | Data query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110515979B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111708848A (en) * | 2020-06-12 | 2020-09-25 | 北京思特奇信息技术股份有限公司 | Data query method and system and electronic equipment |
| CN111831692A (en) * | 2020-01-21 | 2020-10-27 | 北京嘀嘀无限科技发展有限公司 | Information processing method, device, equipment and storage medium |
| CN113254480A (en) * | 2020-02-13 | 2021-08-13 | 中国移动通信集团广东有限公司 | Data query method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101102367A (en) * | 2007-08-16 | 2008-01-09 | 华为技术有限公司 | Provision method and system of service information |
| CN104834691A (en) * | 2015-04-22 | 2015-08-12 | 中国建设银行股份有限公司 | Voice robot |
| CN105787768A (en) * | 2016-03-03 | 2016-07-20 | 陈包容 | Method and device for obtaining goods sales data |
| CN110019319A (en) * | 2017-09-30 | 2019-07-16 | 北京国双科技有限公司 | Data query method and device |
-
2019
- 2019-09-03 CN CN201910828306.9A patent/CN110515979B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101102367A (en) * | 2007-08-16 | 2008-01-09 | 华为技术有限公司 | Provision method and system of service information |
| CN104834691A (en) * | 2015-04-22 | 2015-08-12 | 中国建设银行股份有限公司 | Voice robot |
| CN105787768A (en) * | 2016-03-03 | 2016-07-20 | 陈包容 | Method and device for obtaining goods sales data |
| CN110019319A (en) * | 2017-09-30 | 2019-07-16 | 北京国双科技有限公司 | Data query method and device |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111831692A (en) * | 2020-01-21 | 2020-10-27 | 北京嘀嘀无限科技发展有限公司 | Information processing method, device, equipment and storage medium |
| CN113254480A (en) * | 2020-02-13 | 2021-08-13 | 中国移动通信集团广东有限公司 | Data query method and device |
| CN113254480B (en) * | 2020-02-13 | 2024-04-19 | 中国移动通信集团广东有限公司 | Data query method and device |
| CN111708848A (en) * | 2020-06-12 | 2020-09-25 | 北京思特奇信息技术股份有限公司 | Data query method and system and electronic equipment |
| CN111708848B (en) * | 2020-06-12 | 2024-02-23 | 北京思特奇信息技术股份有限公司 | Data query method, system and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110515979B (en) | 2022-04-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110515979A (en) | Data query method, apparatus, equipment and storage medium | |
| CN107077480A (en) | The method and system of column storage database is adaptively built from the row data storage storehouse of current time based on query demand | |
| CN109783543B (en) | Data query method, device, equipment and storage medium | |
| CN101308505A (en) | Dynamic data access in a computer system via remote services | |
| CN108614837B (en) | File storage and retrieval method and device | |
| CN109508339A (en) | A kind of data query method, apparatus, terminal device and storage medium | |
| CN113836163A (en) | Data association query method, device, equipment and storage medium | |
| CN107491463B (en) | Optimization method and system for data query | |
| CN103020058A (en) | Multi-version data acquisition method and device | |
| CN109325056A (en) | A kind of big data processing method and processing device, communication equipment | |
| CN111125213A (en) | Data acquisition method, device and system | |
| CN111125156A (en) | Data query method and device and electronic equipment | |
| CN108268468A (en) | The analysis method and system of a kind of big data | |
| CN109871338B (en) | Data storage method and device and computer equipment | |
| CN111047434A (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN107451252A (en) | Method for quickly querying and its system based on API | |
| CN111984660A (en) | Data synchronization method, device, equipment and storage medium | |
| CN110737662B (en) | Data analysis method, device, server and computer storage medium | |
| CN116628027A (en) | Cross-database query method, apparatus, device, medium and computer program product | |
| CN111767282A (en) | MongoDB-based storage system, data insertion method and storage medium | |
| CN114153547B (en) | Management page display method and device | |
| CN111367500A (en) | Data processing method and device | |
| CN114297211A (en) | Data online analysis system, method, equipment and storage medium | |
| CN112181391A (en) | Method and system capable of dynamically expanding data | |
| CN113590667A (en) | Real-time data updating and managing method based on Spark Streaming |
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 |