CN108268524A - Database aggregation processing method and device - Google Patents
Database aggregation processing method and device Download PDFInfo
- Publication number
- CN108268524A CN108268524A CN201611264054.4A CN201611264054A CN108268524A CN 108268524 A CN108268524 A CN 108268524A CN 201611264054 A CN201611264054 A CN 201611264054A CN 108268524 A CN108268524 A CN 108268524A
- Authority
- CN
- China
- Prior art keywords
- target polymerization
- dimension
- index
- querying condition
- inquiry
- 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
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/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses a kind of database aggregation processing method and devices.This method includes:Inquiry request is received, wherein, querying condition is carried in inquiry request;The dimension and index in querying condition are obtained, wherein, content of the index for inquiry request instruction inquiry, restrictive condition of the dimension for inquiry request instruction limitation inquiry content;The target polymerization table for including all indexs in all dimensions and querying condition in querying condition is searched, wherein, target polymerization table is the table being polymerize to original tables of data;And in the case where finding target polymerization table, inquired in target polymerization table using dimension and index, and return to the result obtained after inquiry.By the application, solve the problems, such as to carry out in the database in the relevant technologies less efficient during data query.
Description
Technical field
This application involves database processing technical field, in particular to a kind of database aggregation processing method and dress
It puts.
Background technology
In existing application, it is often necessary to inquiry be accelerated by prepolymerization table.For example, in advance according to some spies
Fixed dimension carries out polymerization generation prepolymerization table, the parameter in Aggregation Table, so that line number substantially reduces, so as to reach
Accelerate the effect of inquiry.However, this mode can often increase there are many prepolymerization tables or delete some prepolymerization tables,
After performing these operations, certain customization of front end may be caused to inquire and report an error or cannot apply in time updated pre-
Aggregation Table.Therefore cannot accelerate to inquire.In order to ensure to accelerate inquiry, being used in the relevant technologies increases a prepolymerization table,
With regard to the query language of modification inquiry layer, prepolymerization table is reached the standard grade in application, however whole process is troublesome in poeration, needs linkage more
Change, and mistake easily occurs, influence product usability, also cause search efficiency relatively low.
For it is less efficient when carrying out data query in the relevant technologies in the database the problem of, not yet propose at present effective
Solution
Invention content
The main purpose of the application is to provide a kind of database aggregation processing method and device, to solve in the relevant technologies
The problem of less efficient during data query is carried out in the database.
To achieve these goals, according to the one side of the application, a kind of database aggregation processing method is provided.It should
Method includes:Inquiry request is received, wherein, querying condition is carried in inquiry request;It obtains the dimension in querying condition and refers to
Mark, wherein, content of the index for inquiry request instruction inquiry, limitation item of the dimension for inquiry request instruction limitation inquiry content
Part;The target polymerization table for including all indexs in all dimensions and querying condition in querying condition is searched, wherein, target polymerization table
For the table being polymerize to original tables of data;And in the case where finding target polymerization table, using dimension and refer to
It is marked in target polymerization table and is inquired, and return to the result obtained after inquiry.
Further, it in the case where target polymerization table is multiple, is carried out in target polymerization table using dimension and index
Inquiry includes:Determine the data volume expense of each target polymerization table in multiple target polymerization tables;It is selected from multiple target polymerization tables
Select the target polymerization table of data volume expense minimum;And using dimension and index in the target polymerization table of data volume expense minimum
It is inquired.
Further, the target polymerization table that includes all indexs in all dimensions and querying condition in querying condition is being searched
Before, this method further includes:Determine the dimension and index in target polymerization table;It and will be in target polymerization table using preset interface
Dimension and index dimension corresponding with original tables of data and index synchronize.
Further, the target polymerization for including all indexs in dimensions all in querying condition and querying condition is not found
In the case of table, this method further includes:It is inquired in original tables of data using dimension and index.
Further, this method is applied in enquiring component.
To achieve these goals, according to the another aspect of the application, a kind of database polymerization processing apparatus is provided.It should
Device includes:Receiving unit, for receiving inquiry request, wherein, querying condition is carried in inquiry request;Acquiring unit is used
In obtaining dimension and index in querying condition, wherein, content of the index for inquiry request instruction inquiry, dimension is inquiry request
Indicate the restrictive condition of limitation inquiry content;Searching unit includes all dimensions and querying condition in querying condition for searching
In all indexs target polymerization table, wherein, target polymerization table is the table being polymerize to original tables of data;And the
One query unit, in the case where finding target polymerization table, being looked into target polymerization table using dimension and index
It askes, and returns to the result obtained after inquiry.
Further, which includes:Determining module, in the case of being multiple in target polymerization table,
Determine the data volume expense of each target polymerization table in multiple target polymerization tables;Selecting module, for from multiple target polymerization tables
The target polymerization table of middle selection data volume expense minimum;And enquiry module, for using dimension and index in data volume expense
It is inquired in minimum target polymerization table.
Further, which further includes:Determination unit, for including all dimensions and inquiry in querying condition searching
In condition before the target polymerization table of all indexs, dimension and index in target polymerization table are determined;And synchronization unit, it is used for
The dimension in target polymerization table and index dimension corresponding with original tables of data and index are carried out together using preset interface
Step.
Further, which further includes:Second query unit, for not finding including dimensions all in querying condition
In the case of the target polymerization tables of indexs all in querying condition, looked into original tables of data using dimension and index
It askes.
Further, which is applied in enquiring component.
By the application, using following steps:Inquiry request is received, wherein, querying condition is carried in inquiry request;It obtains
The dimension and index in querying condition are taken, wherein, content of the index for inquiry request instruction inquiry, dimension is indicated for inquiry request
The restrictive condition of limitation inquiry content;It searches and includes the targets of all indexs in all dimensions and querying condition in querying condition and gather
Table is closed, wherein, target polymerization table is the table being polymerize to original tables of data;And finding target polymerization table
In the case of, inquired in target polymerization table using dimension and index, and return inquiry after obtain as a result, solving correlation
The problem of less efficient during data query is carried out in technology in the database.By dimensions all in including querying condition and look into
It is inquired in the target polymerization table of all indexs in inquiry condition, and then has achieved the effect that promote efficiency data query.
Description of the drawings
The attached drawing for forming the part of the application is used for providing further understanding of the present application, the schematic reality of the application
Example and its explanation are applied for explaining the application, does not form the improper restriction to the application.In the accompanying drawings:
Fig. 1 is the flow chart according to database aggregation processing method provided by the embodiments of the present application;And
Fig. 2 is the schematic diagram according to database polymerization processing apparatus provided by the embodiments of the present application.
Specific embodiment
It should be noted that in the absence of conflict, the feature in embodiment and embodiment in the application can phase
Mutually combination.The application is described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
In order to which those skilled in the art is made to more fully understand application scheme, below in conjunction in the embodiment of the present application
The technical solution in the embodiment of the present application is clearly and completely described in attached drawing, it is clear that described embodiment is only
The embodiment of the application part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people
Member's all other embodiments obtained without making creative work should all belong to the model of the application protection
It encloses.
It should be noted that term " first " in the description and claims of this application and above-mentioned attached drawing, "
Two " etc. be the object for distinguishing similar, and specific sequence or precedence are described without being used for.It should be appreciated that it uses in this way
Data can be interchanged in the appropriate case, so as to embodiments herein described herein.In addition, term " comprising " and " tool
Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing series of steps or unit
Process, method, system, product or equipment are not necessarily limited to those steps or unit clearly listed, but may include without clear
It is listing to Chu or for the intrinsic other steps of these processes, method, product or equipment or unit.
According to an embodiment of the present application, a kind of database aggregation processing method is provided.
Fig. 1 is the flow chart according to database aggregation processing method provided by the embodiments of the present application.As shown in Figure 1, the party
Method includes the following steps:
Step S101 receives inquiry request, wherein, querying condition is carried in inquiry request.
Receive inquiry request, for example, the querying condition carried in the inquiry request received for the first quarter to product A's
Order volume and visit capacity.
Step S102 obtains dimension and index in querying condition, wherein, index is interior for inquiry request instruction inquiry
Hold, restrictive condition of the dimension for inquiry request instruction limitation inquiry content.
For example, querying condition is used as limit for the first quarter to the order volume and visit capacity of product A, the first quarter and product A
The restrictive condition of system inquiry content, the content of order volume and visit capacity as inquiry.That is, dimension is the first quarter and product A,
Index is order volume and visit capacity.
Step S103 searches the target polymerization table for including all indexs in all dimensions and querying condition in querying condition,
Wherein, target polymerization table is the table being polymerize to original tables of data.
It should be noted that Aggregation Table in this application is according to preset condition polymerize to original tables of data
The table arrived.For example, Aggregation Table is only arranged comprising limited dimension and index, so that the efficiency data query in Aggregation Table is more
Soon.The Aggregation Table for including all indexs in all dimensions and querying condition in querying condition is searched in multiple Aggregation Tables, will be wrapped
The Aggregation Table of all indexs in all dimensions and querying condition in querying condition is included as target polymerization table.
Step S104 in the case where finding target polymerization table, is carried out using dimension and index in target polymerization table
Inquiry, and return to the result obtained after inquiry.
In finding including querying condition in all dimensions and querying condition the target polymerization table of all indexs situation
Under, it is inquired in target polymerization table using dimension and index, and return to the result obtained after inquiry.By including inquiry
It is inquired, and then reached promotion data and looked into the target polymerization table of all indexs in all dimensions and querying condition in condition
Ask the effect of efficiency.
Optionally, it is multiple in target polymerization table in database aggregation processing method provided by the embodiments of the present application
In the case of, inquiry is carried out in target polymerization table using dimension and index and is included:Determine each target in multiple target polymerization tables
The data volume expense of Aggregation Table;The target polymerization table of data volume expense minimum is selected from multiple target polymerization tables;And it uses
Dimension and index are inquired in the target polymerization table of data volume expense minimum.
In the case where target polymerization table is multiple, the data volume of each target polymerization table in multiple target polymerization tables is determined
Expense selects the Aggregation Table of data volume expense minimum from multiple target polymerization tables;Use all equivalent indexs and all dimensions
Degree is inquired in the target polymerization table of data volume expense minimum, ensures also to reach acceleration data query while inquiry effect
Effect.
Optionally, in database aggregation processing method provided by the embodiments of the present application, in lookup includes querying condition
In all dimensions and querying condition before the target polymerization table of all indexs, this method further includes:It determines in target polymerization table
Dimension and index;And preset interface is used by the dimension in target polymerization table and index dimension corresponding with original tables of data
Degree and index synchronize.
By the dimension in target polymerization table and index dimension corresponding with original tables of data and referred to using preset interface
Mark synchronizes, and ensure that the consistency of the data information and the data information in original tables of data in target polymerization table.It needs
It is noted that in order to ensure the accuracy of inquiry.Reading is recalled after the target polymerization table of rear end is ready to, is being ready to
Before, it provides interface to be removed, ensures the available state of target polymerization table that front end is inquired.
Optionally, it in database aggregation processing method provided by the embodiments of the present application, does not find including querying condition
In in all dimensions and querying condition in the case of the target polymerization table of all indexs, this method further includes:Using dimension and refer to
It is marked in original tables of data and is inquired.
In order to ensure the validity of inquiry, own in all dimensions and querying condition in not finding including querying condition
In the case of the target polymerization table of index, inquired in original tables of data using dimension and index.
Optionally, in database aggregation processing method provided by the embodiments of the present application, this method is applied to enquiring component
In.
By enquiring component using database aggregation processing method provided by the embodiments of the present application, by including inquiring item
It is inquired, and then reached promotion data query in the target polymerization table of all indexs in all dimensions and querying condition in part
The effect of efficiency.
Database aggregation processing method provided by the embodiments of the present application, by receiving inquiry request, wherein, in inquiry request
Carry querying condition;The dimension and index in querying condition are obtained, wherein, content of the index for inquiry request instruction inquiry,
Restrictive condition of the dimension for inquiry request instruction limitation inquiry content;Lookup includes all dimensions and querying condition in querying condition
In all indexs target polymerization table, wherein, target polymerization table is the table being polymerize to original tables of data;And
It in the case of finding target polymerization table, is inquired in target polymerization table using dimension and index, and is obtained after returning to inquiry
To as a result, when solving the problems, such as to carry out data query in the database in the relevant technologies it is less efficient.By including looking into
It is inquired, and then reached promotion data in the target polymerization table of all indexs in all dimensions and querying condition in inquiry condition
The effect of search efficiency.
It should be noted that step shown in the flowchart of the accompanying drawings can be in such as a group of computer-executable instructions
It is performed in computer system, although also, show logical order in flow charts, it in some cases, can be with not
The sequence being same as herein performs shown or described step.
The embodiment of the present application additionally provides a kind of database polymerization processing apparatus, it should be noted that the embodiment of the present application
Database polymerization processing apparatus can be used for performing that the embodiment of the present application provided for database aggregation processing method.With
Under database polymerization processing apparatus provided by the embodiments of the present application is introduced.
Fig. 2 is the schematic diagram according to database polymerization processing apparatus provided by the embodiments of the present application.As shown in Fig. 2, the dress
Put including:Receiving unit 10, acquiring unit 20,30 and first query unit 40 of searching unit.
Specifically, receiving unit 10, for receiving inquiry request, wherein, querying condition is carried in inquiry request.
Acquiring unit 20, for obtaining the dimension and index in querying condition, wherein, index is inquiry request instruction inquiry
Content, dimension for inquiry request instruction limitation inquiry content restrictive condition.
Searching unit 30 includes the targets of all indexs in all dimensions and querying condition in querying condition and gathers for searching
Table is closed, wherein, target polymerization table is the table being polymerize to original tables of data.
First query unit 40, in the case where finding target polymerization table, being gathered using dimension and index in target
It is inquired in conjunction table, and returns to the result obtained after inquiry.
Database polymerization processing apparatus provided by the embodiments of the present application receives inquiry request by receiving unit 10, wherein,
Querying condition is carried in inquiry request;Acquiring unit 20 obtains the dimension and index in querying condition, wherein, index is inquiry
The content of request instruction inquiry, restrictive condition of the dimension for inquiry request instruction limitation inquiry content;Searching unit 30 searches packet
The target polymerization table of all indexs in all dimensions and querying condition in querying condition is included, wherein, target polymerization table is to original
The table that is polymerize of tables of data;And first query unit 40 in the case where finding target polymerization table, use dimension
Degree and index are inquired in target polymerization table, and return to the result obtained after inquiry.It solves in the relevant technologies in data
The problem of less efficient during data query is carried out in library.By owning in dimensions all in including querying condition and querying condition
It is inquired in the target polymerization table of index, and then has achieved the effect that promote efficiency data query.
Optionally, in database polymerization processing apparatus provided by the embodiments of the present application, the first query unit 40 includes:Really
Cover half block in the case of being multiple in target polymerization table, determines the number of each target polymerization table in multiple target polymerization tables
According to amount expense;Selecting module, for selecting the target polymerization table of data volume expense minimum from multiple target polymerization tables;And it looks into
Module is ask, for being inquired in the target polymerization table of data volume expense minimum using dimension and index.
Optionally, in database polymerization processing apparatus provided by the embodiments of the present application, which further includes:It determines single
Member, it is determining for including in querying condition in all dimensions and querying condition before the target polymerization table of all indexs searching
Dimension and index in target polymerization table;And synchronization unit, for using preset interface by the dimension in target polymerization table and
Index dimension corresponding with original tables of data and index synchronize.
Optionally, in database polymerization processing apparatus provided by the embodiments of the present application, which further includes:Second inquiry
Unit, for not finding the situation for including the target polymerization table of all indexs in dimensions all in querying condition and querying condition
Under, it is inquired in original tables of data using dimension and index.
Optionally, in database polymerization processing apparatus provided by the embodiments of the present application, which is applied to enquiring component
In.
The database polymerization processing apparatus includes processor and memory, and above-mentioned receiving unit 10, is looked into acquiring unit 20
30 and first query unit of unit, 40 grade is looked in memory, storage to be stored in by processor execution as program unit storage
Above procedure unit in device realizes corresponding function.
Comprising kernel in processor, gone in memory to transfer corresponding program unit by kernel.Kernel can set one
Or more, it is inquired in the database by adjusting kernel parameter.
Memory may include computer-readable medium in volatile memory, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM), memory includes at least one deposit
Store up chip.
Present invention also provides a kind of embodiment of computer program product, when being performed on data processing equipment, fitting
In the program code for performing initialization there are as below methods step:Inquiry request is received, wherein, inquiry item is carried in inquiry request
Part;The dimension and index in querying condition are obtained, wherein, content of the index for inquiry request instruction inquiry, dimension please for inquiry
Seek the restrictive condition of instruction limitation inquiry content;It searches and includes in querying condition all indexs in all dimensions and querying condition
Target polymerization table, wherein, target polymerization table is the table being polymerize to original tables of data;And gather finding target
It in the case of closing table, is inquired in target polymerization table using dimension and index, and returns to the result obtained after inquiry.
It should be noted that for aforementioned each method embodiment, in order to be briefly described, therefore it is all expressed as a series of
Combination of actions, but those skilled in the art should know, the application is not limited by described sequence of movement because
According to the application, certain steps may be used other sequences or be carried out at the same time.Secondly, those skilled in the art should also know
It knows, embodiment described in this description belongs to preferred embodiment, involved action and module not necessarily the application
It is necessary.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, there is no the portion being described in detail in some embodiment
Point, it may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed device, it can be by another way
It realizes.For example, the apparatus embodiments described above are merely exemplary, such as the division of the unit, it is only a kind of
Division of logic function, can there is an other dividing mode in actual implementation, such as multiple units or component can combine or can
To be integrated into another system or some features can be ignored or does not perform.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical unit, you can be located at a place or can also be distributed to multiple
In network element.Some or all of unit therein can be selected according to the actual needs to realize the mesh of this embodiment scheme
's.
In addition, each functional unit in each embodiment of the application can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
Obviously, those skilled in the art should be understood that each module of above-mentioned the application or each step can be with general
Computing device realize that they can concentrate on single computing device or be distributed in multiple computing devices and be formed
Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored
In the storage device by computing device come perform either they are fabricated to respectively each integrated circuit modules or by they
In multiple modules or step be fabricated to single integrated circuit module to realize.In this way, the application be not limited to it is any specific
Hardware and software combines.
The foregoing is merely the preferred embodiments of the application, are not limited to the application, for those skilled in the art
For member, the application can have various modifications and variations.All any modifications within spirit herein and principle, made,
Equivalent replacement, improvement etc., should be included within the protection domain of the application.
Claims (10)
1. a kind of database aggregation processing method, which is characterized in that including:
Inquiry request is received, wherein, carry querying condition in the inquiry request;
The dimension and index in the querying condition are obtained, wherein, content of the index for inquiry request instruction inquiry,
Restrictive condition of the dimension for inquiry request instruction limitation inquiry content;
The target polymerization table for including all indexs in all dimensions and the querying condition in the querying condition is searched, wherein,
The target polymerization table is the table being polymerize to original tables of data;And
In the case where finding the target polymerization table, using the dimension and the index in the target polymerization table into
Row inquiry, and return to the result obtained after inquiry.
2. according to the method described in claim 1, it is characterized in that, in the case where the target polymerization table is multiple, use
The dimension and the index carry out inquiry in the target polymerization table and include:
Determine the data volume expense of each target polymerization table in multiple target polymerization tables;
The target polymerization table of data volume expense minimum is selected from multiple target polymerization tables;And
It is inquired in the target polymerization table of the data volume expense minimum using the dimension and the index.
3. according to the method described in claim 1, it is characterized in that, include all dimensions and institute in the querying condition searching
Before the target polymerization table for stating all indexs in querying condition, the method further includes:
Determine the dimension and index in the target polymerization table;And
Using preset interface by the dimension in the target polymerization table and index and corresponding dimension in the original tables of data
It is synchronized with index.
4. according to the method described in claim 1, it is characterized in that, do not find including dimensions all in the querying condition and
In the querying condition in the case of the target polymerization table of all indexs, the method further includes:
It is inquired in the original tables of data using the dimension and the index.
5. according to the method described in claim 1, it is characterized in that, the method is applied in enquiring component.
6. a kind of database polymerization processing apparatus, which is characterized in that including:
Receiving unit, for receiving inquiry request, wherein, carry querying condition in the inquiry request;
Acquiring unit, for obtaining the dimension and index in the querying condition, wherein, the index refers to for the inquiry request
Show the content of inquiry, restrictive condition of the dimension for inquiry request instruction limitation inquiry content;
Searching unit, for searching the target for including all indexs in all dimensions and the querying condition in the querying condition
Aggregation Table, wherein, the target polymerization table is the table being polymerize to original tables of data;And
First query unit, in the case where finding the target polymerization table, being existed using the dimension and the index
It is inquired in the target polymerization table, and returns to the result obtained after inquiry.
7. device according to claim 6, which is characterized in that first query unit includes:
Determining module in the case of being multiple in the target polymerization table, determines each in multiple target polymerization tables
The data volume expense of target polymerization table;
Selecting module, for selecting the target polymerization table of data volume expense minimum from multiple target polymerization tables;And
Enquiry module, for being carried out in the target polymerization table of the data volume expense minimum using the dimension and the index
Inquiry.
8. device according to claim 6, which is characterized in that described device further includes:
Determination unit, for searching the mesh for including all indexs in all dimensions and the querying condition in the querying condition
Before marking Aggregation Table, the dimension and index in the target polymerization table are determined;And
Synchronization unit, for using preset interface by the dimension in the target polymerization table and index and the original tables of data
In corresponding dimension and index synchronize.
9. device according to claim 6, which is characterized in that described device further includes:
Second query unit, for not finding including all fingers in dimensions all in the querying condition and the querying condition
In the case of target target polymerization table, inquired in the original tables of data using the dimension and the index.
10. device according to claim 6, which is characterized in that described device is applied in enquiring component.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611264054.4A CN108268524A (en) | 2016-12-30 | 2016-12-30 | Database aggregation processing method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611264054.4A CN108268524A (en) | 2016-12-30 | 2016-12-30 | Database aggregation processing method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108268524A true CN108268524A (en) | 2018-07-10 |
Family
ID=62755353
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611264054.4A Pending CN108268524A (en) | 2016-12-30 | 2016-12-30 | Database aggregation processing method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108268524A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109299141A (en) * | 2018-10-19 | 2019-02-01 | 深圳市元征科技股份有限公司 | A kind of method of data query, system and associated component |
CN109471893A (en) * | 2018-10-24 | 2019-03-15 | 上海连尚网络科技有限公司 | Querying method, equipment and the computer readable storage medium of network data |
CN110008211A (en) * | 2019-02-21 | 2019-07-12 | 北京奇艺世纪科技有限公司 | Data query method, apparatus, electronic equipment and storage medium |
CN111309729A (en) * | 2020-02-13 | 2020-06-19 | 湖南快乐阳光互动娱乐传媒有限公司 | Data query method and device |
CN111767279A (en) * | 2019-04-01 | 2020-10-13 | 北京百度网讯科技有限公司 | Data merging method and device |
CN111782688A (en) * | 2020-06-29 | 2020-10-16 | 中国平安财产保险股份有限公司 | Request processing method, device and equipment based on big data analysis and storage medium |
CN113010373A (en) * | 2021-01-25 | 2021-06-22 | 腾讯科技(深圳)有限公司 | Data monitoring method and device, electronic equipment and storage medium |
CN113392130A (en) * | 2020-03-13 | 2021-09-14 | 阿里巴巴集团控股有限公司 | Data processing method, device and equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1193618A2 (en) * | 2000-09-27 | 2002-04-03 | Microsoft Corporation | Cost based materialized view selection for query optimization |
CN101477524A (en) * | 2008-12-11 | 2009-07-08 | 金蝶软件(中国)有限公司 | System performance optimization method and system based on materialized view |
CN103617175A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for virtualization of large-scale distributed heterogeneous data |
CN105550270A (en) * | 2015-12-09 | 2016-05-04 | 百度在线网络技术(北京)有限公司 | Database inquiry method and device |
-
2016
- 2016-12-30 CN CN201611264054.4A patent/CN108268524A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1193618A2 (en) * | 2000-09-27 | 2002-04-03 | Microsoft Corporation | Cost based materialized view selection for query optimization |
CN101477524A (en) * | 2008-12-11 | 2009-07-08 | 金蝶软件(中国)有限公司 | System performance optimization method and system based on materialized view |
CN103617175A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for virtualization of large-scale distributed heterogeneous data |
CN105550270A (en) * | 2015-12-09 | 2016-05-04 | 百度在线网络技术(北京)有限公司 | Database inquiry method and device |
Non-Patent Citations (1)
Title |
---|
胡雅颖等: "基于物化视图的查询系统研究与实现", 《计算机工程与科学》 * |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109299141A (en) * | 2018-10-19 | 2019-02-01 | 深圳市元征科技股份有限公司 | A kind of method of data query, system and associated component |
CN109471893A (en) * | 2018-10-24 | 2019-03-15 | 上海连尚网络科技有限公司 | Querying method, equipment and the computer readable storage medium of network data |
CN110008211A (en) * | 2019-02-21 | 2019-07-12 | 北京奇艺世纪科技有限公司 | Data query method, apparatus, electronic equipment and storage medium |
CN110008211B (en) * | 2019-02-21 | 2021-07-06 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and storage medium |
CN111767279A (en) * | 2019-04-01 | 2020-10-13 | 北京百度网讯科技有限公司 | Data merging method and device |
CN111309729A (en) * | 2020-02-13 | 2020-06-19 | 湖南快乐阳光互动娱乐传媒有限公司 | Data query method and device |
CN113392130A (en) * | 2020-03-13 | 2021-09-14 | 阿里巴巴集团控股有限公司 | Data processing method, device and equipment |
CN111782688A (en) * | 2020-06-29 | 2020-10-16 | 中国平安财产保险股份有限公司 | Request processing method, device and equipment based on big data analysis and storage medium |
CN111782688B (en) * | 2020-06-29 | 2024-02-06 | 中国平安财产保险股份有限公司 | Request processing method, device, equipment and storage medium based on big data analysis |
CN113010373A (en) * | 2021-01-25 | 2021-06-22 | 腾讯科技(深圳)有限公司 | Data monitoring method and device, electronic equipment and storage medium |
CN113010373B (en) * | 2021-01-25 | 2023-08-22 | 腾讯科技(深圳)有限公司 | Data monitoring method and device, electronic equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108268524A (en) | Database aggregation processing method and device | |
JP7072054B2 (en) | Methods and equipment for sorting cargo | |
CN109741060B (en) | Information inquiry system, method, device, electronic equipment and storage medium | |
US9635099B2 (en) | Federating applications providing modular data | |
CN106130972B (en) | resource access control method and device | |
CN108228799B (en) | Object index information storage method and device | |
CN110769079A (en) | Method and device for retrieving geographic position corresponding to IP | |
CN108140050A (en) | A kind of method and device using Bloom filter filtering file | |
CN106227893A (en) | A kind of file type acquisition methods and device | |
CN106528844B (en) | A kind of data request method and device and data-storage system | |
CN110276060A (en) | The method and device of data processing | |
CN109977135A (en) | A kind of data query method, apparatus and server | |
CN105389266B (en) | A kind of data managing method and device | |
CN107967279A (en) | The data-updating method and device of distributed data base | |
CN104933054B (en) | The URL storage methods and device of cache resource file, cache server | |
CN110532273A (en) | The processing method and processing device of tables of data, storage medium, electronic device | |
CN109885651A (en) | A kind of question pushing method and device | |
CN108427736A (en) | A method of for inquiring data | |
CN108268523A (en) | Database aggregation processing method and device | |
CN103853833A (en) | Information processing method and data processing equipment | |
CN103905512A (en) | Data processing method and equipment | |
CN106559452A (en) | Data processing method and device under cluster environment | |
CN109753510A (en) | A kind of acquisition methods of target data, system, electronic equipment and storage medium | |
CN108268536A (en) | Database aggregation processing method and device | |
CN105653540B (en) | Method and device for processing file attribute information |
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 | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180710 |