CN109299141A - A kind of method of data query, system and associated component - Google Patents
A kind of method of data query, system and associated component Download PDFInfo
- Publication number
- CN109299141A CN109299141A CN201811223483.6A CN201811223483A CN109299141A CN 109299141 A CN109299141 A CN 109299141A CN 201811223483 A CN201811223483 A CN 201811223483A CN 109299141 A CN109299141 A CN 109299141A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- granularity
- target
- subclass
- 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
Abstract
This application discloses a kind of methods of data query, and corresponding target polymerization data are determined in aggregated data the method includes when receiving inquiry request, determining target query granularity corresponding with inquiry request in granularity of query, and according to target query granularity；Inquire target data corresponding with inquiry request in target polymerization data；Wherein, aggregated data includes target polymerization data, and aggregated data operates to obtain by executing data aggregate to initial data as line unit using N kind granularity of query；Initial data includes multiple data subclass, and granularity of query is the combination of any subclass or multiple subclass in data subclass.This method can improve the search efficiency of data under the premise of meeting the needs of user's real time access.Disclosed herein as well is a kind of system of data query, a kind of computer readable storage medium and a kind of electronic equipment, have the above beneficial effect.
Description
Technical field
This application involves technical field of data storage, in particular to a kind of method of data query, system, a kind of computer
Readable storage medium storing program for executing and a kind of electronic equipment.
Background technique
Car networking data SaaS service platform provides the service of real-time query magnanimity Automobile Service diagnosis report data for user, preceding
End page face is quickly rendered on map according to the GPS position information in diagnosis report, to show that diagnosis report data exist
Each metropolitan distribution situation, user can determine vehicle repairing factory position nearby according to region point in data set.
The inquiry of diagnosis report data is realized using asynchronous load request, small lot transmission data in the prior art.But
Be the above-mentioned prior art primary request processing the time it is longer, need to carry out multiple data pre-storage, pretreated operation, it is also necessary to
It considers how to solve the problems, such as that request is interrupted.
Therefore, how under the premise of meeting the needs of user's real time access, the search efficiency for improving data is this field
The current technical issues that need to address of technical staff.
Apply for content
The purpose of the application is to provide the method, system, a kind of computer readable storage medium and one of a kind of data query
Kind electronic equipment, can improve the search efficiency of data under the premise of meeting the needs of user's real time access.
In order to solve the above technical problems, the application provides a kind of method of data query, it is applied to Hbase row storage data
Library, this method comprises:
When receiving inquiry request, target query granularity corresponding with inquiry request, and root are determined in granularity of query
Corresponding target polymerization data are determined in aggregated data according to target query granularity；
Inquire target data corresponding with inquiry request in target polymerization data；
Wherein, aggregated data includes target polymerization data, and aggregated data is by being line unit to original number using N kind granularity of query
It operates to obtain according to data aggregate is executed；Initial data includes multiple data subclass, and granularity of query is appointing in data subclass
One subclass or the combination for appointing multiple subclass.
Optionally, target query granularity corresponding with inquiry request is determined in granularity of query, and according to target query grain
Degree determines that corresponding target polymerization data include: in aggregated data
Key word of the inquiry is determined according to inquiry request, and target query corresponding with key word of the inquiry is determined in granularity of query
Granularity；
Target polymerization data corresponding with target query granularity are determined according to the corresponding relationship of granularity of query and aggregated data.
Optionally, using N kind granularity of query as line unit to initial data execute data aggregate operate to obtain aggregated data include:
Specification is carried out to initial data using N kind granularity of query as the column cluster value of Hbase row storage data library row major key
Polymerization obtains aggregated data.
Optionally, further includes:
Target data is uploaded to human-computer interaction interface；Wherein, target data includes the corresponding location information of inquiry request.
Optionally, target data is uploaded to human-computer interaction interface includes:
Calculate coordinate value corresponding with location information in human-computer interaction interface；
Target data is uploaded to human-computer interaction interface according to coordinate value, so as in the corresponding position displaying target of coordinate value
Data.
Optionally, when initial data is automobile inspection data reporting, data subclass includes repair time, city, product
Board, vehicle or year money.
Optionally, target query granularity includes any one of repair time, city, brand, vehicle and year money or appoints several
The combination of item.
Present invention also provides a kind of systems of data query, are applied to Hbase row storage data library, which includes:
Target polymerization data determining module, for when receiving inquiry request, determination to be asked with inquiry in granularity of query
Corresponding target query granularity is sought, and corresponding target polymerization data are determined in aggregated data according to target query granularity；
Enquiry module, for inquiring target data corresponding with inquiry request in target polymerization data；
Wherein, aggregated data includes target polymerization data, and aggregated data is by being line unit to original number using N kind granularity of query
It operates to obtain according to data aggregate is executed；Initial data includes multiple data subclass, and granularity of query is appointing in data subclass
One subclass or the combination for appointing multiple subclass.
Optionally, target polymerization data determining module includes:
Granularity determination unit is determined in granularity of query and is closed with inquiry for determining key word of the inquiry according to inquiry request
The corresponding target query granularity of key word；
Data determination unit, for according to the determination of the corresponding relationship of granularity of query and aggregated data and target query granularity pair
The target polymerization data answered.
Optionally, further includes:
Aggregation module, for using N kind granularity of query as the column cluster value of Hbase row storage data library row major key to original
Data carry out specification and polymerize to obtain aggregated data.
Optionally, further includes:
Uploading module, for target data to be uploaded to human-computer interaction interface；Wherein, target data includes inquiry request pair
The location information answered.
Optionally, uploading module includes:
Coordinate determination unit, for calculating coordinate value corresponding with location information in human-computer interaction interface；
Display unit, for target data to be uploaded to human-computer interaction interface according to coordinate value, so as to corresponding in coordinate value
Position displaying target data.
Optionally, when initial data is automobile inspection data reporting, data subclass includes repair time, city, product
Board, vehicle or year money.
Optionally, target query granularity includes any one of repair time, city, brand, vehicle and year money or appoints several
The combination of item.
Present invention also provides a kind of computer readable storage mediums, are stored thereon with computer program, computer program
The step of method that above-mentioned data query is realized when execution executes.
Present invention also provides a kind of electronic equipment, including memory and processor, computer journey is stored in memory
The step of sequence, processor realizes above-mentioned data query method when calling the computer program in memory executes.
This application provides a kind of methods of data query, are applied to Hbase row storage data library, and method includes when reception
When to inquiry request, target query granularity corresponding with inquiry request is determined in granularity of query, and according to target query granularity
Corresponding target polymerization data are determined in aggregated data；Inquire number of targets corresponding with inquiry request in target polymerization data
According to；Wherein, aggregated data includes target polymerization data, and aggregated data is by holding initial data using N kind granularity of query as line unit
Row data converging operation obtains；Initial data includes multiple data subclass, and granularity of query is any son in data subclass
Classification or the combination for appointing multiple subclass.
It is that index executes data that initial data in the Hbase row storage data library of the application, which is passed through with multiple queries granularity,
Converging operation, therefore there are the aggregated data of each granularity of query in database, the application carries out corresponding according to inquiry request
Inquiry operation when relevant inquiring only can be carried out to the corresponding target polymerization data of target query granularity, without in initial data
It is middle to inquire data corresponding with inquiry request, the effect of data query is improved under the premise of meeting the needs of user's real time access
Rate.The application additionally provides system, a kind of computer readable storage medium and a kind of electronic equipment of a kind of data query simultaneously,
With above-mentioned beneficial effect, details are not described herein.
Detailed description of the invention
In ord to more clearly illustrate embodiments of the present application, attached drawing needed in the embodiment will be done simply below
It introduces, it should be apparent that, the drawings in the following description are only some examples of the present application, for ordinary skill people
For member, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow chart of the method for data query provided by the embodiment of the present application；
Fig. 2 is the flow chart of the method for another kind data query provided by the embodiment of the present application；
Fig. 3 is a kind of structural schematic diagram of the system of data query provided by the embodiment of the present application；
Fig. 4 is the structure chart of a kind of electronic equipment provided by the embodiments of the present application；
Fig. 5 is the structure chart of another electronic equipment provided by the embodiments of the present application.
Specific embodiment
To keep the purposes, technical schemes and advantages of the embodiment of the present application clearer, below in conjunction with the embodiment of the present application
In attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is
Some embodiments of the present application, instead of all the embodiments.Based on the embodiment in the application, those of ordinary skill in the art
Every other embodiment obtained without making creative work, shall fall in the protection scope of this application.
Below referring to Figure 1, Fig. 1 is a kind of flow chart of the method for data query provided by the embodiment of the present application.
Specific steps may include:
S101: when receiving inquiry request, determining target query granularity corresponding with inquiry request in granularity of query,
And corresponding target polymerization data are determined in aggregated data according to target query granularity；
Wherein, the present embodiment is applied to Hbase row storage data library, and rapid, scalability is strong with searching for the database
The advantages of, the data of magnanimity can be stored, query performance is able to ascend by rationally designing rowkey (line unit), meets real time access
Demand.The database mentioned in the present embodiment, Hbase database are all referring in Hbase row storage data library.The present embodiment
Default and execute following operation to the initial data in database: it is poly- to execute data to initial data using N kind granularity of query as line unit
Closing operation obtains a variety of aggregated datas, and each index granularity corresponds to a part of aggregated data.
It should be noted that the initial data in database may include multiple subclass, such as stored in database
Automobile inspection data reporting, may include in every portion automobile inspection data reporting the repair time, city, brand, vehicle and
The subclass such as year money.The present embodiment is also defaulted using any subclass or any number of subclass as granularity of query, by with each
Kind granularity of query is that line unit operates to obtain aggregated data to initial data execution data aggregate.For example, with city+brand+vehicle
It can be by the same city in all initial data, same brand, same model when carrying out converging operation as index granularity
Corresponding auto repair data reporting condenses together, and receives looking into using city, brand and vehicle as granularity of query to work as
When asking request, the auto repair data reporting of same city corresponding with inquiry request, same brand and same vehicle is carried out
Data query operation.
It is understood that the present embodiment is built upon to the initial data in database using granularity of query in N as line unit
On the basis of progress specification converging operation.As a preferred embodiment, the determination method of index granularity can be basis
The querying condition of user carries out rule confidence operation, excavates a variety of data query modes, each mode corresponds to a kind of inquiry grain
Degree.
This step can carry out keyword extraction operation to inquiry request, in all inquiries when receiving inquiry request
Target query granularity corresponding with inquiry request is determined in granularity, to determine the range of this data query.Continue with automobile
Maintenance report data instance, such as inquiry request is: the maintenance report data of the vehicle of the abbc model of inquiry Nanjing Beijing Automobile Workshop, this
It is " Nanjing ", " Beijing Automobile Workshop ", " abbc model " that Shi Jinhang keyword extraction, which obtains keyword, thus may determine that inquiry request pair
The target query granularity answered is Nanjing, Beijing Automobile Workshop, abbc model, belongs to Nanjing, Beijing Automobile Workshop, abbc type pair for all in database
The auto repair data reporting answered is as target polymerization data, to carry out data query operation.Certainly, it does not limit and looks into herein
The format for asking request can be and provide multiple inquiry tables corresponding with data subclass in query interface, so that inquiry is looking into
The condition for needing to inquire is filled in inquiry table；Being also possible to the inquiry request as described in above example is one section of complete sentence
Son carries out keyword extraction to it and determines granularity of query.
S102: target data corresponding with inquiry request in inquiry target polymerization data；
Wherein, the operation of the S101 in the present embodiment is equivalent to the range for reducing inquiry data, by region to be checked
The corresponding target polymerization data of target index granularity are reduced to by all data.Further, the inquiry mentioned in the present embodiment
It can also include other screening conditions in request, it in this step can be corresponding with inquiry request according to screening conditions determination
Target data.As a preferred embodiment, there may also be target data is uploaded to man-machine friendship after this step
The operation at mutual interface, so that user understands inquired data.
It is that index executes number that initial data in the Hbase row storage data library of the present embodiment, which is passed through with multiple queries granularity,
According to converging operation, therefore there are the aggregated data of each granularity of query in database, the application is carried out according to inquiry request pair
Relevant inquiring only can be carried out to the corresponding target polymerization data of target query granularity when the inquiry operation answered, without in original number
According to middle inquiry data corresponding with inquiry request, data query is improved under the premise of meeting the needs of user's real time access
Efficiency.
Fig. 2 is referred to below, and Fig. 2 is the flow chart of the method for another kind data query provided by the embodiment of the present application；
Specific steps may include:
S201: when receiving inquiry request, determining key word of the inquiry according to inquiry request, in granularity of query determine with
The corresponding target query granularity of key word of the inquiry；
S202: target polymerization corresponding with target query granularity is determined according to the corresponding relationship of granularity of query and aggregated data
Data；
The present embodiment, which defaults each granularity of query, corresponding aggregated data, and target query granularity belongs to inquiry grain
One kind of degree, therefore target corresponding with target query granularity can be determined according to the corresponding relationship of granularity of query and aggregated data
Aggregated data.
S203: target data corresponding with inquiry request in inquiry target polymerization data；
S204: coordinate value corresponding with location information in human-computer interaction interface is calculated；
Wherein, it is initial data relevant to geographical location information that the present embodiment default, which deposits store in the database, is
Preferably people's interactive interface is shown, can will acquire the location information in target data.This step defaults man-machine friendship
Mutual interface is specially the interface for showing map, can determine the seat shown on other interactive interface according to location information
Scale value.Location information is specifically as follows GPS information.
As a preferred embodiment, former data be include location information under the premise of, in database
When initial data carries out specification polymerization, it can be generated using granularity of query as line unit, with location information (e.g., GPS longitude and latitude data)
It is polymerize, obtains aggregate list.
S205: being uploaded to human-computer interaction interface for target data according to coordinate value, so as to aobvious in the corresponding position of coordinate value
Show target data.
Illustrate above-described embodiment description below by the embodiment for inquiring automobile inspection data reporting in practical applications
Process.
In practical applications for real-time response user query demand, and being returned by Web Service API includes GPS
The query result of data, when not using the scheme of asynchronous load request, small lot transmission data, it is necessary to carry out data
Pretreatment, in conjunction with user query situation, designs good data storage scheme, specific step is as follows for data prediction:
Step 1: carrying out rule confidence operation to user query condition, three kinds of data query modes, each mould are excavated
Formula corresponds to a kind of granularity of query (that is, inquiry complexity).Three kinds of granularity of query may include (1) city+time；(2) city+product
Board+time；(3) city+brand+vehicle or year money+time.
Granularity of query may include any one of repair time, city, brand, vehicle and year money or appoint several groups
It closes.
Step 2: designing corresponding Hbase line unit generating mode according to three kinds of data query modes；
Step 3: according to different line unit design methods, by the querying condition in addition to GPS location point be added rowkey it
In, train value is the data aggregate list of GPS longitude and latitude.
Further, it can also be corresponding rowkey design method under each granularity of query, create a Hbase number
Data preprocess table, for inquiry request each time, automatic identification granularity of query and matching inquiry position are always ensured that and hold
Capable is accurate inquiry operation.Hbase feature performance benefit is greatly utilized in this mode, reduces the complexity of business end data processing
Degree.
In the above-described embodiments, although Hbase database partitioned storage data in a manner of column cluster, in actual storage mistake
Cheng Zhong can carry out specification polymerization to data by rowkey, be associated with data as much as possible according to line unit, as with rowkey
Corresponding value, i.e. column cluster value.Specifically, querying condition " city+brand+time " is converted into rowkey, can incite somebody to action
In same city scope, diagnosis report data aggregate that same brand vehicle generates within the same month together, do so
Benefit has two o'clock: (1) reducing Hbase data storage capacity grade；(2) it is corresponded, is realized accurate according to rowkey and querying condition
Inquiry, quick response request.Hbase feature performance benefit is greatly utilized in the embodiment, reduces the complexity of business end data processing
Degree.Guarantee the corresponding accurate search operation of Hbase of fuzzy query of user, that is, can return to all maintenance diagnosis report GPS
Data.
Since the present embodiment designs corresponding Hbase storage scheme for each query pattern, realize that data are poly-
The pretreatment purpose of conjunction guarantees that user requests each time, all only carries out accurate inquiry operation, such benefit with can reduce
The I/O time that back-end data inquiry needs realizes Millisecond response.Simultaneously as checking out data has been subjected to polymerization
GPS list is equivalent to and does a data compression, can satisfy the requirement that data transmission is realized by Web API.
Fig. 3 is referred to, Fig. 3 is a kind of structural schematic diagram of the system of data query provided by the embodiment of the present application；
The system may include:
Target polymerization data determining module 301, for determining and inquiring in granularity of query when receiving inquiry request
Corresponding target query granularity is requested, and corresponding target polymerization data are determined in aggregated data according to target query granularity；
Enquiry module 302, for inquiring target data corresponding with inquiry request in target polymerization data；
Wherein, aggregated data includes target polymerization data, and aggregated data is by being line unit to original number using N kind granularity of query
It operates to obtain according to data aggregate is executed；Initial data includes multiple data subclass, and granularity of query is appointing in data subclass
One subclass or the combination for appointing multiple subclass.
It is that index executes number that initial data in the Hbase row storage data library of the present embodiment, which is passed through with multiple queries granularity,
According to converging operation, therefore there are the aggregated data of each granularity of query in database, the application is carried out according to inquiry request pair
Relevant inquiring only can be carried out to the corresponding target polymerization data of target query granularity when the inquiry operation answered, without in original number
According to middle inquiry data corresponding with inquiry request, data query is improved under the premise of meeting the needs of user's real time access
Efficiency.
Optionally, target polymerization data determining module 301 includes:
Granularity determination unit is determined in granularity of query and is closed with inquiry for determining key word of the inquiry according to inquiry request
The corresponding target query granularity of key word；
Data determination unit, for according to the determination of the corresponding relationship of granularity of query and aggregated data and target query granularity pair
The target polymerization data answered.
Optionally, further includes:
Aggregation module, for using N kind granularity of query as the column cluster value of Hbase row storage data library row major key to original
Data carry out specification and polymerize to obtain aggregated data.
Optionally, further includes:
Uploading module, for target data to be uploaded to human-computer interaction interface；Wherein, target data includes inquiry request pair
The location information answered.
Optionally, uploading module includes:
Coordinate determination unit, for calculating coordinate value corresponding with location information in human-computer interaction interface；
Display unit, for target data to be uploaded to human-computer interaction interface according to coordinate value, so as to corresponding in coordinate value
Position displaying target data.
Optionally, when initial data is automobile inspection data reporting, data subclass includes repair time, city, product
Board, vehicle or year money.
Optionally, target query granularity includes any one of repair time, city, brand, vehicle and year money or appoints several
The combination of item.
Since the embodiment of components of system as directed is corresponded to each other with the embodiment of method part, the embodiment of components of system as directed is asked
Referring to the description of the embodiment of method part, wouldn't repeat here.
Present invention also provides a kind of computer readable storage mediums, have computer program thereon, the computer program
It is performed and step provided by above-described embodiment may be implemented.The storage medium may include: USB flash disk, mobile hard disk, read-only deposit
Reservoir (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic disk or
The various media that can store program code such as CD.Computer program is stored on the storage medium, computer program is located
Reason device performs the steps of when executing when receiving inquiry request, and mesh corresponding with inquiry request is determined in granularity of query
Granularity of query is marked, and corresponding target polymerization data are determined in aggregated data according to target query granularity；Inquire target polymerization
Target data corresponding with inquiry request in data；Wherein, aggregated data includes target polymerization data, and aggregated data passes through with N
Kind granularity of query is that line unit operates to obtain to initial data execution data aggregate；Initial data includes multiple data subclass, is looked into
Ask the combination that granularity is any subclass or multiple subclass in data subclass.
It is that index executes number that initial data in the Hbase row storage data library of the present embodiment, which is passed through with multiple queries granularity,
According to converging operation, therefore there are the aggregated data of each granularity of query in database, the application is carried out according to inquiry request pair
Relevant inquiring only can be carried out to the corresponding target polymerization data of target query granularity when the inquiry operation answered, without in original number
According to middle inquiry data corresponding with inquiry request, data query is improved under the premise of meeting the needs of user's real time access
Efficiency.
It preferably, specifically can be with when the computer subprogram stored in computer readable storage medium is executed by processor
It performs the steps of and key word of the inquiry is determined according to inquiry request, mesh corresponding with key word of the inquiry is determined in granularity of query
Mark granularity of query；Target polymerization number corresponding with target query granularity is determined according to the corresponding relationship of granularity of query and aggregated data
According to.
It preferably, specifically can be with when the computer subprogram stored in computer readable storage medium is executed by processor
It performs the steps of and initial data is carried out using N kind granularity of query as the column cluster value of Hbase row storage data library row major key
Specification polymerize to obtain aggregated data.
It preferably, specifically can be with when the computer subprogram stored in computer readable storage medium is executed by processor
It performs the steps of and target data is uploaded to human-computer interaction interface；Wherein, target data includes the corresponding positioning of inquiry request
Information.
It preferably, specifically can be with when the computer subprogram stored in computer readable storage medium is executed by processor
It performs the steps of and calculates coordinate value corresponding with location information in human-computer interaction interface；It will be in target data according to coordinate value
Human-computer interaction interface is reached, so as in the corresponding position displaying target data of coordinate value.
Present invention also provides a kind of electronic equipment, and referring to fig. 4, Fig. 4 is that a kind of electronics provided by the embodiments of the present application is set
Standby structure chart, comprising:
Memory 100, for storing computer program；
Step provided by above-described embodiment may be implemented in processor 200 when for executing the computer program.
Specifically, memory 100 includes non-volatile memory medium, built-in storage.Non-volatile memory medium storage
There are operating system and computer-readable instruction, which is that the operating system and computer in non-volatile memory medium can
The operation of reading instruction provides environment.Processor 200 provides calculating and control ability for electronic equipment, executes and protects in memory 100
When the computer program deposited, following steps may be implemented: when receiving inquiry request, determination is asked with inquiry in granularity of query
Corresponding target query granularity is sought, and corresponding target polymerization data are determined in aggregated data according to target query granularity；It looks into
Ask target data corresponding with inquiry request in target polymerization data；Wherein, aggregated data includes target polymerization data, aggregate number
It operates to obtain according to by executing data aggregate to initial data as line unit using N kind granularity of query；Initial data includes multiple data
Subclass, granularity of query are the combination of any subclass or multiple subclass in data subclass.
It is that index executes number that initial data in the Hbase row storage data library of the present embodiment, which is passed through with multiple queries granularity,
According to converging operation, therefore there are the aggregated data of each granularity of query in database, the application is carried out according to inquiry request pair
Relevant inquiring only can be carried out to the corresponding target polymerization data of target query granularity when the inquiry operation answered, without in original number
According to middle inquiry data corresponding with inquiry request, data query is improved under the premise of meeting the needs of user's real time access
Efficiency.
Preferably, when processor 200 executes the computer subprogram saved in memory 100, following steps may be implemented:
Key word of the inquiry is determined according to inquiry request, and target query granularity corresponding with key word of the inquiry is determined in granularity of query；Root
Target polymerization data corresponding with target query granularity are determined according to the corresponding relationship of granularity of query and aggregated data.
Preferably, when processor 200 executes the computer subprogram saved in memory 100, following steps may be implemented:
N kind granularity of query is carried out specification to initial data as the column cluster value of Hbase row storage data library row major key to polymerize to obtain
Aggregated data.
Preferably, when processor 200 executes the computer subprogram saved in memory 100, following steps may be implemented:
Target data is uploaded to human-computer interaction interface；Wherein, target data includes the corresponding location information of inquiry request.
Preferably, when processor 200 executes the computer subprogram saved in memory 100, following steps may be implemented:
Calculate coordinate value corresponding with location information in human-computer interaction interface；Target data is uploaded to human-computer interaction circle according to coordinate value
Face, so as in the corresponding position displaying target data of coordinate value.
It on the basis of the above embodiments, preferably, is provided by the embodiments of the present application referring to Fig. 5, Fig. 5
The structure chart of another electronic equipment, the electronic equipment further include:
Input interface 300 is connected with processor 200, for obtaining computer program, parameter and the instruction of external importing,
It saves through the control of processor 200 into memory 100.The input interface 300 can be connected with input unit, and it is manual to receive user
The parameter or instruction of input.The input unit can be the touch layer covered on display screen, be also possible to be arranged in terminal enclosure
Key, trace ball or Trackpad, be also possible to keyboard, Trackpad or mouse etc..
Display unit 400 is connected with processor 200, the data sent for video-stream processor 200.The display unit 400
It can be display screen, liquid crystal display or the electric ink display screen etc. in PC machine.It, can be with specifically, in the present embodiment
Target data corresponding with inquiry request is shown by display unit 400.
The network port 500 is connected with processor 200, for being communicatively coupled with external each terminal device.The communication link
The communication technology used by connecing can be cable communicating technology or wireless communication technique, and such as mobile high definition chained technology (MHL) leads to
It is blue with universal serial bus (USB), high-definition media interface (HDMI), adopting wireless fidelity technology (WiFi), Bluetooth Communication Technology, low-power consumption
The tooth communication technology, communication technology based on IEEE802.11s etc..
Each embodiment is described in a progressive manner in specification, the highlights of each of the examples are with other realities
The difference of example is applied, the same or similar parts in each embodiment may refer to each other.For system disclosed in embodiment
Speech, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part illustration
?.It should be pointed out that for those skilled in the art, under the premise of not departing from the application principle, also
Can to the application, some improvement and modification can also be carried out, these improvement and modification also fall into the protection scope of the claim of this application
It is interior.
It should also be noted that, in the present specification, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning
Covering non-exclusive inclusion, so that the process, method, article or equipment for including a series of elements not only includes that
A little elements, but also including other elements that are not explicitly listed, or further include for this process, method, article or
The intrinsic element of equipment.Under the situation not limited more, the element limited by sentence "including a ..." is not arranged
Except there is also other identical elements in the process, method, article or apparatus that includes the element.
Claims (10)
1. a kind of method of data query, which is characterized in that be applied to Hbase row storage data library, which comprises
When receiving inquiry request, target query granularity corresponding with the inquiry request, and root are determined in granularity of query
Corresponding target polymerization data are determined in aggregated data according to the target query granularity；
Inquire target data corresponding with the inquiry request in the target polymerization data；
Wherein, aggregated data includes the target polymerization data, and the aggregated data is by being line unit to original using N kind granularity of query
Beginning data execute data aggregate and operate to obtain；The initial data includes multiple data subclass, and the granularity of query is described
The combination of any subclass or multiple subclass in data subclass.
2. method according to claim 1, which is characterized in that determine mesh corresponding with the inquiry request in granularity of query
Granularity of query is marked, and determines that corresponding target polymerization data include: in aggregated data according to the target query granularity
Key word of the inquiry is determined according to the inquiry request, and determination is corresponding with the key word of the inquiry in the granularity of query
The target query granularity；
Target corresponding with the target query granularity is determined according to the corresponding relationship of the granularity of query and the aggregated data
Aggregated data.
3. method according to claim 1, which is characterized in that execute data to initial data using N kind granularity of query as line unit
Converging operation obtains the aggregated data
Using granularity of query described in N kind as the column cluster value of Hbase row storage data library row major key to the initial data
Specification is carried out to polymerize to obtain the aggregated data.
4. method according to claim 3, which is characterized in that further include:
The target data is uploaded to human-computer interaction interface；Wherein, the target data includes that the inquiry request is corresponding
Location information.
5. method according to claim 4, which is characterized in that the target data, which is uploaded to human-computer interaction interface, includes:
Calculate coordinate value corresponding with the location information in the human-computer interaction interface；
The target data is uploaded to human-computer interaction interface according to the coordinate value, so as in the corresponding position of the coordinate value
Show the target data.
6. a kind of system of data query, which is characterized in that it is applied to Hbase row storage data library, the system comprises:
Target polymerization data determining module, for when receiving inquiry request, determination to be asked with the inquiry in granularity of query
Corresponding target query granularity is sought, and corresponding target polymerization number is determined in aggregated data according to the target query granularity
According to；
Enquiry module, for inquiring target data corresponding with the inquiry request in the target polymerization data；
Wherein, aggregated data includes the target polymerization data, and the aggregated data is by being line unit to original using N kind granularity of query
Beginning data execute data aggregate and operate to obtain；The initial data includes multiple data subclass, and the granularity of query is described
The combination of any subclass or multiple subclass in data subclass.
7. system according to claim 6, which is characterized in that the target polymerization data determining module includes:
Granularity determination unit, for determining key word of the inquiry according to the inquiry request, the determining and institute in the granularity of query
State the corresponding target query granularity of key word of the inquiry；
Data determination unit is looked into for being determined according to the corresponding relationship of the granularity of query and the aggregated data with the target
Ask the corresponding target polymerization data of granularity.
8. system according to claim 6, which is characterized in that the system also includes:
Aggregation module, for using N kind granularity of query as the column cluster value of Hbase row storage data library row major key to initial data
Specification is carried out to polymerize to obtain the aggregated data.
9. a kind of electronic equipment characterized by comprising
Memory, for storing computer program；
Processor realizes the method for the data query as described in any one of claim 1 to 5 when for executing the computer program
The step of.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program, realizing the method for data query as described in any one of claim 1 to 5 when the computer program is executed by processor
Step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811223483.6A CN109299141A (en) | 2018-10-19 | 2018-10-19 | A kind of method of data query, system and associated component |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811223483.6A CN109299141A (en) | 2018-10-19 | 2018-10-19 | A kind of method of data query, system and associated component |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109299141A true CN109299141A (en) | 2019-02-01 |
Family
ID=65158358
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811223483.6A Pending CN109299141A (en) | 2018-10-19 | 2018-10-19 | A kind of method of data query, system and associated component |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109299141A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111339096A (en) * | 2020-02-25 | 2020-06-26 | 网易（杭州）网络有限公司 | Data configuration table processing method, device, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105138592A (en) * | 2015-07-31 | 2015-12-09 | 武汉虹信技术服务有限责任公司 | Distributed framework-based log data storing and retrieving method |
| CN105989076A (en) * | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Data statistical method and device |
| CN106407480A (en) * | 2016-11-29 | 2017-02-15 | 北京世纪高通科技有限公司 | Information search method and system |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN108268524A (en) * | 2016-12-30 | 2018-07-10 | 北京国双科技有限公司 | Database aggregation processing method and device |
| US20180253474A1 (en) * | 2017-03-01 | 2018-09-06 | Mckesson Corporation | Methods and apparatuses for improved database design |
-
2018
- 2018-10-19 CN CN201811223483.6A patent/CN109299141A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105989076A (en) * | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Data statistical method and device |
| CN105138592A (en) * | 2015-07-31 | 2015-12-09 | 武汉虹信技术服务有限责任公司 | Distributed framework-based log data storing and retrieving method |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN106407480A (en) * | 2016-11-29 | 2017-02-15 | 北京世纪高通科技有限公司 | Information search method and system |
| CN108268524A (en) * | 2016-12-30 | 2018-07-10 | 北京国双科技有限公司 | Database aggregation processing method and device |
| US20180253474A1 (en) * | 2017-03-01 | 2018-09-06 | Mckesson Corporation | Methods and apparatuses for improved database design |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111339096A (en) * | 2020-02-25 | 2020-06-26 | 网易（杭州）网络有限公司 | Data configuration table processing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110264023B (en) | Shared vehicle management server and non-transitory storage medium storing shared vehicle management program | |
| CN103248723B (en) | The defining method of region, a kind of IP address and device | |
| US20190156357A1 (en) | Advanced computational prediction models for heterogeneous data | |
| US9785897B2 (en) | Methods and systems for optimizing efficiency of a workforce management system | |
| US11144578B2 (en) | High performance and efficient multi-scale trajectory retrieval | |
| CN109993627B (en) | Recommendation method, recommendation model training device and storage medium | |
| CN110168529A (en) | Date storage method, device and storage medium | |
| CN113869801B (en) | Maturity state evaluation method and device for enterprise digital middleboxes | |
| US10417059B1 (en) | Staged application programming interface | |
| CN111813804A (en) | Data query method and device, electronic equipment and storage medium | |
| CN110675238A (en) | Client label configuration method, system, readable storage medium and electronic equipment | |
| CN109299141A (en) | A kind of method of data query, system and associated component | |
| CN102831169B (en) | Plane figure relation determining method and system in geographical information system | |
| CN110134721A (en) | Data statistical approach, device and electronic equipment based on bitmap | |
| CN114185941A (en) | Report data query method and device, electronic equipment and storage medium | |
| CN109783498A (en) | Data processing method and device, electronic equipment, storage medium | |
| CN110765226B (en) | Goods owner matching method, device, equipment and medium | |
| CN110689177B (en) | Method and device for predicting order preparation time, electronic equipment and storage medium | |
| CN114925153B (en) | Service-based geographic information data quality detection method, device and equipment | |
| CN113379464B (en) | Block chain-based site selection method, device, equipment and storage medium | |
| CN114971412A (en) | Order distribution method, order distribution platform, order distribution system and storage medium | |
| US11521274B2 (en) | Cost allocation estimation using direct cost vectors and machine learning | |
| CN113657759A (en) | Task processing method, device, equipment and storage medium | |
| CN112418442A (en) | Data processing method, device, equipment and storage medium for federal transfer learning | |
| CN111782696A (en) | Credit investigation data processing 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190201 |
|
| RJ01 | Rejection of invention patent application after publication |