CN107357812A - A kind of data query method and device - Google Patents
A kind of data query method and device Download PDFInfo
- Publication number
- CN107357812A CN107357812A CN201710405339.3A CN201710405339A CN107357812A CN 107357812 A CN107357812 A CN 107357812A CN 201710405339 A CN201710405339 A CN 201710405339A CN 107357812 A CN107357812 A CN 107357812A
- Authority
- CN
- China
- Prior art keywords
- data
- feature
- user
- data set
- target
- 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/242—Query formulation
- G06F16/2423—Interactive query statement specification based on a database schema
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application discloses a kind of data query method and device, and this method includes：Receive the query statement of user, determine the data set of the data to be checked corresponding to the query statement, and the target data feature based on the data set, in the data set, it is determined that related data feature corresponding with the target data feature, based on the related data feature determined, record the related data feature selected by the user, according to the target data feature and the related data feature of record, generate Data expansion feature, and show, wherein, the target data feature comprises at least：The dimension and/or measurement of data, the related data feature comprise at least：Dimension, measurement and/or its value of data.By this method, the generation to different pieces of information extension feature can be realized so that inquiry of the user to data is more abundant, while realizes and the lower brill of data multi-angle is analyzed.
Description
Technical field
The application is related to field of computer technology, more particularly to a kind of data query method and device.
Background technology
Data are widely used in each field as a kind of general record form.At present, with the development of information technology,
The trend of magnanimity is presented in data.In order to it is directly perceived in mass data, clearly show different data, and be easy to data
Data are showed by analysis frequently with the mode of such as data sheet.
In actual applications, the user of data query is carried out, may be directed to data has different query demands, but using existing
Some reporting systems can not fully meet the query demand of user.
The content of the invention
The embodiment of the present application provides a kind of data query method and device, to solve the data report system of prior art
The problem of query demand of user can not fully be met.
A kind of data query method that the embodiment of the present application provides, including：
Receive the query statement of user；
Determine the data set of the data to be checked corresponding to the query statement, and the number of targets based on the data set
According to feature；
In the data set, it is determined that related data feature corresponding with the target data feature；
Based on the related data feature determined, the related data feature selected by the user is recorded；
According to the target data feature and the related data feature of record, Data expansion feature is generated, and show；
Wherein, the target data feature comprises at least：The dimension and/or measurement of data；
The related data feature comprises at least：Dimension, measurement and/or its value of data.
A kind of data query arrangement that the embodiment of the present application provides, including：
Receiving module, receive the query statement of user；
Target signature determining module, determines the data set of the data to be checked corresponding to the query statement, and is based on
The target data feature of the data set；
Correlated characteristic determining module, in the data set, it is determined that related data corresponding with the target data feature
Feature；
Logging modle, based on the related data feature determined, record the related data feature selected by the user；
Generation module, according to the target data feature and the related data feature of record, Data expansion feature is generated,
And show；
Wherein, the target data feature comprises at least：The dimension and/or measurement of data；
The related data feature comprises at least：Dimension, measurement and/or its value of data.
Above-mentioned at least one technical scheme that the embodiment of the present application uses can reach following beneficial effect：
After server receives the query statement of user, corresponding data set, and the mesh that user is of interest will be determined
Data characteristics is marked, target data feature is not embodied directly in data set, but needs to combine the different dimension of data set itself
Obtained by degree or measurement are carried out after a certain degree of calculating.Therefore server can also be determined and target data feature from data set
Corresponding related data feature, and user can be showed.Afterwards, user can be selected for different related data features
Operation, and server can record the different related data features that user selectes.And based on target data feature and by user
Selected different related data features, Data expansion feature is generated, as the data Angle to be inquired about of user, by Query Result
Show user.
Compared to prior art, the data query process in the embodiment of the present application, can realize different pieces of information is extended it is special
The generation of sign so that inquiry of the user to data is more abundant, meanwhile, user can be supported for different related data features and
The different levels of related data feature or selecting for its value, realize the lower brill analysis to data multi-angle.
Brief description of the drawings
Accompanying drawing described herein is used for providing further understanding of the present application, forms the part of the application, this Shen
Schematic description and description please is used to explain the application, does not form the improper restriction to the application.In the accompanying drawings：
Fig. 1 is the configuration diagram that the data query method that the embodiment of the present application provides is based on；
Fig. 2 is the data query process that the embodiment of the present application provides；
Fig. 3 a~3f are the schematic diagram for the query interface that the embodiment of the present application provides；
Fig. 4 a~4c are the schematic diagram for the query interface for the data characteristics comprising level that the embodiment of the present application provides；
The schematic diagram at interface when Fig. 5 a~5b are the carry out characteristic storage that the embodiment of the present application provides；
Fig. 5 c are the displaying schematic diagram for the real-time analysis result that the embodiment of the present application provides；
Fig. 6 is the data query arrangement structural representation that the embodiment of the present application provides.
Embodiment
To make the purpose, technical scheme and advantage of the application clearer, below in conjunction with the application specific embodiment and
Technical scheme is clearly and completely described corresponding accompanying drawing.Obviously, described embodiment is only the application one
Section Example, rather than whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not doing
Go out under the premise of creative work the every other embodiment obtained, belong to the scope of the application protection.
In the embodiment of the present application, there is provided a kind of data query method, to realize that the different characteristic to data is carried out fully
(Drill) is drilled through, providing the user different features according to the operation of user extends.
Specifically, this method can use framework as shown in Figure 1, it may include：Client, Xiang Yong used in user
Family provides the server and database of data query business.
Wherein, described server can be business provider (such as：Website, telecom operators, bank, data center etc.)
The server on backstage, using the teaching of the invention it is possible to provide data query service.User can be by client (such as：Applications client, browser etc.)
Access to the server, it should be appreciated that described client may operate on mobile terminal or computer.It is stored with database
The data of analysis needed for user.
Such as：Under a kind of possible application scenarios, user accesses server by client, selects needs to be handled
Data, server handled based on the data stored in database, and is shown by client to user after processing
Result.During being somebody's turn to do, user can arbitrarily select different feature (or combination of multiple features), and server can be according to user
Selection, corresponding result is shown using the different exhibition method such as pie chart, histogram, trend graph.
Certainly, above-mentioned example should not be used as the restriction to the application, meanwhile, framework as shown in Figure 1 again is just for
Readily appreciate the simple architecture shown by the method in the embodiment of the present application.In actual applications, server is also possible to be cluster
Formula, and provide data query business towards a large number of users.Here the restriction to the application should not formed.
Based on framework as shown in Figure 1, the embodiment of the present application provides a kind of data query process, as shown in Fig. 2 the process
Specifically include following steps：
Step S201：Receive the query statement of user.
In practical application scene, it is to carry out query analysis to data to be checked that user, which sends query statement,.Wherein,
Described data to be checked, it is believed that be all kinds of numbers for needing to use the data query process in the application to carry out query processing
According to.It can be specifically the relational data of the data set form such as multidimensional data, tables of data.
In actual applications, it described query statement, can be sent based on corresponding query interface by user, certainly, used
The form that family sends query statement may include：Speech polling instruction, mouse click, touch screen pressing etc., are not limited specifically here
It is fixed.
Step S202：The data set of the data to be checked corresponding to the query statement is determined, and based on the data
The target data feature of collection.
In the embodiment of the present application, the data set of data to be checked has different sources, specifically, in a kind of mode,
During user can be uploaded onto the server the data for needing to be analyzed with data files such as Excel file, sql files,
Form corresponding data set.In a further mode of operation, user can provide the storage information of data to be checked (such as to server：Treat
Data table information in the reference address of the database that is stored of inquiry data, database etc.), then, server can be with root
The storage information provided according to user, access to corresponding database (or in tables of data of the database), obtain number to be checked
According to data set.
Certainly, above-mentioned mode should not form the restriction to the application.
Simultaneously, it should be understood that ground, user may need some data characteristicses for data to be checked to be inquired about, to enter
Row data analysis.Therefore, for this step, described target data feature, it is believed that be the data that user needs to inquire about
Feature, specifically it may include：The dimension and/or measurement of data.Target data feature is generally pre-defined by business provider, such as：
Success rate, safety point, payment etc. are paid, user can select required target data special in the query process of reality
Sign.
Explanation is needed exist for, in the embodiment of the present application, user's target data feature of interest, typically not
The dimension or measurement being embodied directly in data set, but needing to carry out certain calculating processing can just obtain.Such as：Tables of data
In include：The dimensions such as date, name, sex, payment, for these dimensions, user can be in a manner of directly by tabling look-up
Inquired about, and in the inquiry scene of reality, the target data feature to be inquired about of user is probably to pay the proprietary moon
The amount of money, or daily payment, it is clear that such target data feature is not embodied directly in tables of data, but is needed
Calculated accordingly.
Therefore as it was previously stated, the target data feature in the application can be pre-defined by business provider, institute may be selected in user
The target data feature that need to be inquired about.
Step S203：In the data set, it is determined that related data feature corresponding with the target data feature.
Needed for being selected as user after the target data feature of inquiry, related data feature can be determined by server.This Shen
Please be in embodiment, described related data feature, it is believed that be embodied directly in above-mentioned data set dimension, measurement and/or
Its value.As above example, user have selected " daily payment " this target data feature, then, related data feature is extremely
It may include date, payment the two dimensions less.
It can be showed as a kind of preferably mode, server after related data feature is determined in query interface
User.
Step S204：Based on the related data feature determined, the related data feature selected by the user is recorded.
User can be directed to the related data feature shown and be selected, so as to realize the lower brill analysis to data.Therefore
In the embodiment of the present application, different related data features record user selected, at the same time, server will be based on user
Selection, the data that real-time implementation is concentrated to data drill through.
Step S205：According to the target data feature and the related data feature of record, Data expansion feature is generated,
And show.
In the embodiment of the present application, as user selectes to different related data features, also can is from different angles
Data are analyzed, therefore server will generate Data expansion feature.Use the example above, it is assumed that user's target data of interest is special
Sign is " daily payment ", and is selected for " male " this sub- dimension in dimension " sex ", and now, server can
To generate " the daily payment of male " this Data expansion feature.
Certainly, in the embodiment of the present application, as user selectes operation to the difference of related data feature, can generate not
With the Data expansion feature of hierarchical depth.
By above-mentioned steps, after server receives the query statement of user, corresponding data set, Yi Jiyong will be determined
Family target data feature of interest, target data feature are not embodied directly in data set, but need to combine data set
Obtained by itself different dimension or measurement are carried out after a certain degree of calculating.Therefore server can also be determined from data set with
Related data feature corresponding to target data feature, and user can be showed.Afterwards, user can be directed to different related datas
Feature carries out selected operation, and server can record the different related data features that user selectes.And it is based on target data
Feature and the different related data features selected by user, Data expansion feature is generated, as the data angle to be inquired about of user
Degree, user is showed by Query Result.
Compared to prior art, the data query process in the embodiment of the present application, can realize different pieces of information is extended it is special
The generation of sign so that inquiry of the user to data is more abundant, meanwhile, user can be supported for different related data features and
The different levels of related data feature or selecting for its value, realize the lower brill analysis to data multi-angle.
In order to clearly illustrate the above-mentioned data query method in the embodiment of the present application, carried out below in conjunction with example detailed
Explanation：
In the embodiment of the present application, for different types of target data feature, the data list structure created is generally deposited
In certain difference, herein below will be characterized as that the situation of measurement illustrates with target data, it should be appreciated that be equally applicable to tie up
Degree or other target data features, and should not be used as the restriction to the application.Specifically：
First, the tables of data of the type that can add up measurement
For the type measurement that can add up, when needing to be collected, then it can be carried out directly against the measurement for the type that can add up
Accumulative operation.It is as shown in table 1 below, for a kind of data list structure example for the type measurement that adds up：
| Date | Pay product | Sex | Payment (member) |
| 2017-01-01 | Pay product A | Female | 1000.0 |
| 2017-01-01 | Pay product A | Man | 2000.0 |
| 2017-01-01 | Pay product B | Man | 500.0 |
| 2017-01-02 | Pay product A | Female | 1500.0 |
| 2017-01-02 | Pay product B | Man | 500.0 |
Table 1
Visible in table 1, " date ", " payment product ", " sex " are different dimensions, and " payment " is measurement.
For measuring " payment ", can directly it be added up using needs according to different, such as：To count the date
For the total payoff amount of money of " 2017-01-01 ", then, it can be added up the payment on the same day is corresponded in table 1, i.e. 1000
+ 2000+500=3500.Simultaneously it should be noted that in table 1, different dimensions have different values (such as in itself：For " property
Not " this dimension, its value include " man " and " female "), in follow-up dimension anabolic process, the difference of different dimensions can be directed to
Value is drilled through.Here the restriction to the application should not formed.
2nd, the tables of data of average type measurement
In the embodiment of the present application, counted using the two seeds measurement for characterizing " measurement and value " and " counting of measurement "
Calculate average type measurement, that is to say, that for average type measurement, it usually needs can just be obtained by once extra mean value computation
Arrive.Shown in table 2 specific as follows, for a kind of data list structure example of average type measurement：
| Date | Subordinate | Security standpoint | Score | Count |
| 2017-01-01 | Xiao Ming (individual) | Awareness of safety | 90 | 1 |
| 2017-01-01 | Xiao Ming (individual) | Data safety | 91 | 1 |
| 2017-01-01 | Xiao Ming (individual) | IT safety | 92 | 1 |
| 2017-01-01 | Small red (team) | Awareness of safety | 273 | 3 |
| 2017-01-01 | Small red (team) | Data safety | 270 | 3 |
| 2017-01-01 | Small red (team) | IT safety | 267 | 3 |
Table 2
It is visible in table 2, it is assumed that the measurement of required concern is " safety point ", and the measurement needs to measure " by the son in table 2
Point " and " counting " be calculated.Specifically, based on upper table 2, Xiao Ming's personal safety point is Xiao Ming in above-mentioned three kinds of safety
The compound average of angle, i.e.,：(90+91+92)/(1+1+1).Small red safety point is small red (team) in above-mentioned three kinds peaces
The compound average of full angle, i.e.,：(273+270+267)/(3+3+3).
Explanation is needed exist for, in the embodiment of the present application, why is measured using two seeds to represent average type degree
Amount, if being because directly being measured using a sub- measurement representation average type, in some scenarios, it is difficult to be computed correctly to obtain
Value, such as：Assuming that " average age " of the measurement of required concern for employee, wherein, employee totally 3 people, the people of male 1, the age 20
In year, the people of women 2, the age is respectively 18 years old and 25 years old.It follows that the average age of employee should be (20+18+25)/3=21.
It is but if average age is arranged into a field to be indicated, then as shown in table 3 below：
| Sex | Average age |
| Man | 20 |
| Female | 21.5 |
Table 3
The average age that employee is calculated by table 3 is (20+21.5)/2=20.75.Obviously, by the average age in table 3,
The average age of employee can not be calculated exactly.
3rd, the tables of data of Ratio-type measurement
Similar with above-mentioned average type measurement, the Ratio-type measurement in the embodiment of the present application is also required to two kinds of measurements and counted
Obtain, two kinds of measurements can characterize the corresponding numerator value of Ratio-type measurement, and the denominator that Ratio-type measurement is corresponding respectively
Value.Shown in table 4 specific as follows, for a kind of data list structure example of Ratio-type measurement：
| Date | Bank | Pay product | The means of payment | Success stroke count | Total stroke count |
| 2017-01-01 | Industrial and commercial bank | Pay product A | Quick payment | 90 | 100 |
| 2017-01-01 | Industrial and commercial bank | Pay product B | Quick payment | 91 | 100 |
| 2017-01-01 | Construction Bank | Pay product A | E-Bank payment | 95 | 100 |
| 2017-01-01 | Construction Bank | Pay product B | E-Bank payment | 95 | 100 |
| 2017-01-01 | China Merchants Bank | Pay product A | Quick payment | 96 | 100 |
| 2017-01-01 | China Merchants Bank | Pay product B | E-Bank payment | 90 | 100 |
Table 4
Assuming that the measurement of required concern is payment success rate, then, understood based on table 4, measurement " success stroke count " can be passed through
Corresponding payment success rate is calculated in " total stroke count ".It is specific to pay success ratio values, by the difference according to selected by user
Dimension is calculated (specific calculating process will be described in detail in subsequent content).
Above content is the not data list structure corresponding to homometric(al).
In addition, it is contemplated that some dimensions have hierarchical structure, such as：Department's framework, geographic hierarchy in enterprise are (such as：Save,
City, area, county) etc..In practical application, the different levels that user may be directed in partial dimensional are inquired about.So, in order to
Realization drills through to different levels in above-mentioned dimension, is deposited in the embodiment of the present application using a kind of data structure for being easy to drill through
Storage.
Specifically, for the dimension with hierarchical relationship, can be stored according to hierarchical relationship.As a kind of feasible
Embodiment, stored according to the order of level from high to low, and different levels are realized using the separator specified and separated.Its
In, described separator may include the character with compartmentation, such as：" _ ", "-" etc., specifically can be according to the need of practical application
It is configured, is not especially limited here.
As a kind of mode, for any level in dimension, in storage, by the level and the layer is arranged in
All levels before level are stored, and to embody the hierarchical relationship of dimension, are easy to follow-up drill through.
By taking " department " this dimension as an example, it is assumed that department's framework in enterprise includes：One to level Four department, meanwhile, it is false
If the employee that employee Xiao Ming belongs under tier-3 department, then, for " department " of employee Xiao Ming this dimension, corresponding to it
Dimension values can be stored as according to the order of level from high to low：Primary department-tier-2 department-tier-3 department is (with word in this example
"-" is accorded with as separator).
Data volume when alternatively, in order to reduce storage, when storing hierarchical relationship, only need to store
The last layer level of current level and the level, such as to " department " of employee Xiao Ming this dimension in upper example, can be stored as：Two level
Department-tier-3 department.For highest level, because it does not have the level on upper strata, so, it is top can only to store this
Level, such as：Assuming that the small employee for just belonging to primary department of employee, then, small firm " department " dimension of employee can be stored as：One-level portion
Door.In practical application, in order to ensure the unification of storage format, for highest level, the side that increase upper strata can be used to identify
Formula, such as：ROOT- primary departments.Here " ROOT " identifies for upper strata, only plays mark action, not actual level.
As for which kind of mode used, it will be specifically configured according to the needs of practical application, be not construed as limiting here.
Certainly, above-mentioned hierarchical relationship, the order of level from low to high should also be covered, that is, in some application scenarios,
It can also be stored according to level from as little as high order, should not form the restriction to the application equally here.
Based on above content, the process extended below in conjunction with example of practical application to dimension is described in detail：
Example one
During practical application, user can carry out the inquiry of data by corresponding client, when user have selected a certain measurement
Afterwards, correspondingly, server will inquire about the tables of data related to the measurement, and generate corresponding query interface.
Such as：Assuming that user wants inquiry measurement " safety point ", and it is assumed that data related to " safety point " this measurement
Table is foregoing table 2, then, server can be to inquire about and obtain dimension data different in foregoing table 2.So as to be based on obtaining
The dimension data got generates corresponding query interface and is supplied to user by client, as shown in Figure 3 a (it is to be appreciated that with
The form of query interface shown in lower content is only a kind of example, and should not be used as the restriction to the application).
On query interface in fig. 3 a, the measurement to be inquired about including at least user, the dimension related to the measurement, number
According to figure show area.
Wherein, the measurement to be inquired about of user is " safety point ", and the dimension data related to measurement " safety point " includes：Under
Category and two dimensions of security standpoint.Two dimensions are shown in the form of operable control, that is, user can be directed to any one
Dimension carries out clicking operation.After user is clicked on for any dimension, the dimension will be shown in datagraphic show area
Safe component shape under degree.
Such as：As shown in Figure 3 b, it is assumed that user clicks on dimension " subordinate " (dimension " subordinate " after in fig 3b, being clicked
Represented with grey), then, the safety related to subordinate point will be shown in datagraphic show area.
It should be noted that in actual applications, shown figure is not limited in the histogram shown in Fig. 3 b, may be used also
To be other figures such as the trend graph based on the date, pie chart.As a kind of feasible pattern in the embodiment of the present application, can look into
Ask and figure toggle control is set in interface, to switch different types of datagraphic, auxiliary user carries out data analysis.
As shown in Figure 3 c, figure toggle control is provided in figure display area lower right.It is assumed here that：In the exhibition of Fig. 3 c institutes
On the basis of the Nogata figure shown, after user clicks on figure toggle control, figure can be switched to trend graph.In actual applications,
As a kind of feasible mode, different types of figure can be preset, then, as user is to the point of figure toggle control
Hit, different figures will be switched to respectively.As another feasible mode, after user clicks figure toggle control, can show
Diagram shape selection interface (figure selecting interface can use the modes such as floating layer, pop-up to show), is enumerated in the figure selecting interface
Go out a variety of different figures to select for user.
In addition, in above-mentioned figure to the exhibition method of concrete numerical value, can be with addition to the mode directly displayed
Shown according to the operation of user, such as：For the terminal operated using mouse, cursor hovering can be used aobvious
Show, and for the terminal with touch screen functionality, pressing display etc. can be used.Here the restriction to the application is not formed.
And after user clicks dimension " security standpoint ", due to there is three kinds of values (that is, three seed dimensions) under the dimension：
" awareness of safety ", " data safety " and " IT safety ", therefore user can be selected further directed to these three sub- dimensions.At this
Apply in embodiment, sub- dimension selection control can be provided in query interface, as shown in Figure 3 d.After user clicks on, it will show
The selection interface of sub- dimension, as shown in Figure 3 e.It should be understood that the sub- dimension selection control in Fig. 3 d selects with the sub- dimension in Fig. 3 e
Interface is only a kind of example, does not form the restriction to the application.
Based on the sub- dimension selection interface in Fig. 3 e, it is assumed that the sub- dimension that user selectes is " data safety " and carried out true
Recognize, then, also just generate a new extension measurement, the safety point of its characterize data safety.Certainly, in practical application,
If having more sub- dimensions under certain dimension, user can select one when selected and select, and can also carry out multiselect.
Now, for query interface as shown in 3f, measurement " safety point " originally is changed into the extension measurement " safety of data safety
Point ", also, only retaining dimension " subordinate " in query interface, figure here represents：The safety of data safety corresponding to subordinate
Point.
Example two
Assuming that the tables of data where a kind of dimension with hierarchical relationship is as shown in table 5 below.
| Date | Department | Score | Count |
| 2017-01-01 | ROOT- primary departments | 720 | 8 |
| 2017-01-01 | Primary department-tier-2 department A | 546 | 6 |
| 2017-01-01 | Primary department-tier-2 department B | 174 | 2 |
| 2017-01-01 | Tier-2 department B- tier-3 departments A | 368 | 4 |
| 2017-01-02 | ROOT- primary departments | 728 | 8 |
| 2017-01-02 | Primary department-tier-2 department A | 550 | 6 |
| 2017-01-02 | Primary department-tier-2 department B | 178 | 2 |
| 2017-01-02 | Tier-2 department B- tier-3 departments A | 368 | 4 |
Table 5
In table 5, dimension " department " is the dimension for having hierarchical relationship, it is assumed that the measurement to be inquired about of user is still " peace
Complete point ", corresponding query interface can be as shown in fig. 4 a.From the interface shown in Fig. 4 a, in selected " department " this dimension
Afterwards, the safety point corresponding to acquiescence displaying primary department., should by displaying after user is clicked on further directed to primary department
The department of lower floor of primary department, i.e. tier-2 department A and tier-2 department B, as shown in Figure 4 b.
It should be noted that in actual applications, for the level shown in Fig. 4 a, it can be looked into by corresponding database
Ask operation to realize, specifically, in table 5, inquire about in dimension value the separator "-" included, and determine to be located at separator "-"
Right side and content are the data row (" primary department " is highest level) where " primary department ", are obtained in data row corresponding
Numerical computations are divided safely, the datagraphic based on this generation Fig. 4 a.
And if the query path of user is：Primary department → tier-2 department B → tier-3 department A, then, query process can
Think：User clicks " primary department " having shown that, then, server will inquire about separator "-" left content in table 5 and be
The data item of " primary department ", it can obtain " tier-2 department A " and " tier-2 department B ", the numerical value where obtaining in data row are carried out
After calculating, user can be showed.User is further directed to " tier-2 department B " is clicked on, and now, server will be looked into table 5
Separator "-" left content is ask as " tier-2 department B " data item, can obtain " tier-3 department C ", can be based on respective value and carry out
Calculate, show user.
It is noted herein that as user is directed to the selection of different levels, dimension will be extended, just described above
Query path, dimension will expand to：Tier-3 department A safety point.
Based on the query interface shown in Fig. 4 b, user can also be inquired about for another dimension " date ", be shown with above-mentioned
Dimension " security standpoint " in example one is similar, and dimension " date " has two seed dimensions " 2017-01-01 " and " 2017-01-
02 ", correspondingly, the sub- dimension that user can be directed to dimension " date " is further selected.It is assumed here that user selects son dimension
Spend " 2017-01-02 ", then, dimension expands to " 2017-01-02 tier-2 departments A and tier-2 department B safety point ".Meanwhile
Query interface is as illustrated in fig. 4 c.Visible in Fig. 4 c, dimension only retains " department ", and user is for the sub- dimension of dimension " date "
Selection, it is shown in sub- dimension selection control region.Certainly, user can be selected on control in sub- dimension, cancel antithetical phrase
Selected (the "×" type control clicked in Fig. 4 c can be achieved) of dimension.
On the basis of above-mentioned two example, user can be directed to the measurement that extension obtains and be preserved, and can customize
Corresponding title, in order to user's subsequently tracking and analysis to extension measurement.As a kind of feasible mode, in query interface
The middle storage control that extension measurement is provided, as shown in Figure 5 a (control that " preservation " printed words are shown in figure).When user clicks
After the storage control, title editing interface is measured into displaying, as shown in Figure 5 b, user can edit corresponding title with self-defined,
And preserved.
It should be noted that in the embodiment of the present application, the preservation to extension measurement is not that preservation extension measurement institute is right
The specific data value answered, but preserve extension measurement drill through information.The description that information is regarded as drilling operation is drilled through, changes speech
It, drills through information by extension measurement, can trace " path " for drilling through extension measurement, extension measurement is looked into so as to realize
Ask.
Specifically, the information that drills through in the embodiment of the present application may include：Extend measurement title, the title of gauge,
Metric type, metric calculation method and constraint expression formula.Concrete example is as shown in table 6 below.
Table 6
Constraint expression formula shown in table 6 can be used in query sentence of database, it should be appreciated that the form of constraint expression formula
Not only this is a kind of, is not especially limited here.
In addition, in the query process of user, the real-time analysis to inquired about data can be provided the user.Specifically,
Real-time analysis to inquired about data may include：For all or part of dimension exploitation on year-on-year basis, ring ratio or setting time
Fluctuation ratio in section, result of calculation is sorted, and is shown according to the result for the selection setting quantity that puts in order.It can also wrap
Include：It is predicted for all or part of dimension value, obtains predicted value, and calculates the difference between predicted value and actual value
Value, after being sorted to difference value, it is shown according to the result for the selection setting quantity that puts in order.
Above-mentioned real-time analysis mode, analysis of the user to inquired about data can be aided in, can be played to query path
Suggesting effect, and data for contributing to user to note abnormalities.As a kind of more excellent mode in the embodiment of the present application, for
The result analyzed in real time, it can be showed by the way of text, specifically can be as shown in Figure 5 c.It should be understood that user is each time
The selected operation to dimension is performed, corresponding analysis text can be all generated, to aid in user to carry out data query.Here should not
Form the restriction to the application.
Foregoing disclosure show the data query method in the embodiment of the present application.Visible in the above, above-mentioned number
Drilling through and being drilled through to the longitudinal direction of single data characteristics to different pieces of information feature can be realized according to querying method.Difference can be directed to
The data characteristics of characteristic type is extended.The data characteristics selected can be directed in real time during user is inquired about
Analyzed, guide the query path of user.Stored for the extension information of Data expansion feature, storage can be reduced
Data volume.
The data query method provided above for the embodiment of the present application, based on same thinking, the embodiment of the present application also carries
For a kind of data query arrangement, as shown in Figure 6.The device includes：
Receiving module 601, receive the query statement of user；
Target signature determining module 602, determine the data set of the data to be checked corresponding to the query statement, Yi Jiji
In the target data feature of the data set；
Correlated characteristic determining module 603, in the data set, it is determined that dependency number corresponding with the target data feature
According to feature；
Logging modle 604, based on the related data feature determined, the related data recorded selected by the user is special
Sign；
Generation module 605, according to the target data feature and the related data feature of record, generation Data expansion is special
Sign, and show；
Wherein, the target data feature comprises at least：The dimension and/or measurement of data；
The related data feature comprises at least：Dimension, measurement and/or its value of data.
The data set is uploaded by the user, or is specified by the user, based on this, the target signature determining module
602, the data set for the data to be checked that the user uploads is received, the data set is defined as number corresponding to the query statement
According to collection, or
The storage location information of the data set of data that user specifies, to be checked is determined, according to the storage location information
Data set is obtained, the data set got is defined as data set corresponding to the query statement.
The target signature determining module 602, it is determined that target data feature and its target signature based on the data set
Value.
The target signature determining module 602, the characteristic type belonging to the target data feature is determined, according to the spy
Type is levied, the data characteristics calculated needed for the object feature value is obtained in data set, and enter according to the calculation of setting
Row calculates；
Wherein, the characteristic type belonging to the target data feature, is comprised at least：Can be added up feature, characteristics of mean or ratio
Rate feature.
The target signature determining module 602, when the characteristic type is that can add up feature, obtained in the data set
Cumulative data characteristics can be carried out by taking；
When the characteristic type is characteristics of mean, obtained in the data set data prestored and value tag with
And data counts value tag；
When the characteristic type is Ratio Features, obtained in the data set data component feature that prestores with
And data summation feature.
The target signature determining module 602, can according to what is got when the characteristic type is that can add up feature
The numerical value of cumulative data characteristics is carried out, carries out accumulation calculating；
When the characteristic type is characteristics of mean, according to the data and value tag and data counts value tag got
In numerical value, carry out ratio calculation；
When the characteristic type is Ratio Features, according in the data component feature and data summation feature got
Numerical value, carry out ratio calculation.
When including hierarchical relationship in the related data feature, the logging modle 604, according to including hierarchical relationship
Setting storage mode of the related data feature in the data set, determines the highest level of the related data feature, will most
High-level shows user, and receives the query statement step by step of user, according to the query statement step by step, determines the phase step by step
The different levels for closing data characteristics are shown, and record the level selected by user.
Described device also includes：Data memory module 606, in the data set, for every a data, determine the number
According to affiliated level, as current level, it is determined that the upper strata level of current level, will described currently level and the current layer level
Upper strata level stored.
Described device also includes：Data analysis module 607, when generating Data expansion feature, according to default analysis mould
Type, target data feature and related data feature according to selected by user are analyzed, and are generated analysis result and are shown；
Wherein, the analysis model comprises at least：Year-on-year analysis model, ring than analysis model, fluctuation ratio analysis model and/
Or difference value analysis model.
Described device also includes：Characteristic storage module 608, storage operation of the user to the Data expansion feature is received,
Operated according to the storage, determine the extension information corresponding to the Data expansion feature, the extension information is stored；
Wherein, the extension information comprises at least：The title of growth data feature, target data feature, growth data are special
Characteristic type, calculation and the constraint expression formula based on related data feature of sign.
In the 1990s, the improvement for a technology can clearly distinguish be on hardware improvement (for example,
Improvement to circuit structures such as diode, transistor, switches) or software on improvement (improvement for method flow).So
And as the development of technology, the improvement of current many method flows can be considered as directly improving for hardware circuit.
Designer nearly all obtains corresponding hardware circuit by the way that improved method flow is programmed into hardware circuit.Cause
This, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, PLD
(Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable Gate
Array, FPGA)) it is exactly such a integrated circuit, its logic function is determined by user to device programming.By designer
Voluntarily programming comes a digital display circuit " integrated " on a piece of PLD, without asking chip maker to design and make
Special IC chip.Moreover, nowadays, substitution manually makes IC chip, this programming is also used instead mostly " patrols
Volume compiler (logic compiler) " software realizes that software compiler used is similar when it writes with program development,
And the source code before compiling also write by handy specific programming language, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but have many kinds, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed are most generally used at present
Integrated Circuit Hardware Description Language) and Verilog.Those skilled in the art also should
This understands, it is only necessary to method flow slightly programming in logic and is programmed into integrated circuit with above-mentioned several hardware description languages,
Can is readily available the hardware circuit for realizing the logical method flow.
Controller can be implemented in any suitable manner, for example, controller can take such as microprocessor or processing
Device and storage can by the computer of the computer readable program code (such as software or firmware) of (micro-) computing device
Read medium, gate, switch, application specific integrated circuit (Application Specific Integrated Circuit,
ASIC), the form of programmable logic controller (PLC) and embedded microcontroller, the example of controller include but is not limited to following microcontroller
Device：ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20 and Silicone Labs C8051F320, are deposited
Memory controller is also implemented as a part for the control logic of memory.It is also known in the art that except with
Pure computer readable program code mode realized beyond controller, completely can be by the way that method and step is carried out into programming in logic to make
Controller is obtained in the form of gate, switch, application specific integrated circuit, programmable logic controller (PLC) and embedded microcontroller etc. to come in fact
Existing identical function.Therefore this controller is considered a kind of hardware component, and various for realizing to including in it
The device of function can also be considered as the structure in hardware component.Or even, can be by for realizing that the device of various functions regards
For that not only can be the software module of implementation method but also can be the structure in hardware component.
System, device, module or the unit that above-described embodiment illustrates, it can specifically be realized by computer chip or entity,
Or realized by the product with certain function.One kind typically realizes that equipment is computer.Specifically, computer for example may be used
Think personal computer, laptop computer, cell phone, camera phone, smart phone, personal digital assistant, media play
It is any in device, navigation equipment, electronic mail equipment, game console, tablet PC, wearable device or these equipment
The combination of equipment.
For convenience of description, it is divided into various units during description apparatus above with function to describe respectively.Certainly, this is being implemented
The function of each unit can be realized in same or multiple softwares and/or hardware during application.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the present invention can use the computer for wherein including computer usable program code in one or more
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram
Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data query facilities is instructed to produce
A raw machine so that produced by the instruction of computer or the computing device of other programmable data query facilities for real
The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data query facilities with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to
Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded on computer or other programmable data query facilities so that counted
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
In a typical configuration, computing device includes one or more processors (CPU), input/output interface, net
Network interface and internal memory.
Internal 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 storage (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer-readable instruction, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase transition internal memory (PRAM), static RAM (SRAM), moved
State random access memory (DRAM), other kinds of random access memory (RAM), read-only storage (ROM), electric erasable
Programmable read only memory (EEPROM), fast flash memory bank or other memory techniques, read-only optical disc read-only storage (CD-ROM),
Digital versatile disc (DVD) or other optical storages, magnetic cassette tape, the storage of tape magnetic rigid disk or other magnetic storage apparatus
Or any other non-transmission medium, the information that can be accessed by a computing device available for storage.Define, calculate according to herein
Machine computer-readable recording medium does not include temporary computer readable media (transitory media), such as data-signal and carrier wave of modulation.
It should also be noted that, term " comprising ", "comprising" or its any other variant are intended to nonexcludability
Comprising so that process, method, commodity or equipment including a series of elements not only include those key elements, but also wrapping
Include the other element being not expressly set out, or also include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that wanted including described
Other identical element also be present in the process of element, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program product.
Therefore, the application can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Form.Deposited moreover, the application can use to can use in one or more computers for wherein including computer usable program code
The shape for the computer program product that storage media is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The application can be described in the general context of computer executable instructions, such as program
Module.Usually, program module includes performing particular transaction or realizes routine, program, object, the group of particular abstract data type
Part, data structure etc..The application can also be put into practice in a distributed computing environment, in these DCEs, by
Affairs are performed and connected remote processing devices by communication network.In a distributed computing environment, program module can be with
In the local and remote computer-readable storage medium including storage device.
Each embodiment in this specification is described by the way of progressive, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.It is real especially for system
For applying example, because it is substantially similar to embodiment of the method, so description is fairly simple, related part is referring to embodiment of the method
Part explanation.
Embodiments herein is the foregoing is only, is not limited to the application.For those skilled in the art
For, the application can have various modifications and variations.All any modifications made within spirit herein and principle, it is equal
Replace, improve etc., it should be included within the scope of claims hereof.
Claims (20)
1. a kind of data query method, including：
Receive the query statement of user；
Determine the data set of the data to be checked corresponding to the query statement, and the spy of the target data based on the data set
Sign；
In the data set, it is determined that related data feature corresponding with the target data feature；
Based on the related data feature determined, the related data feature selected by the user is recorded；
According to the target data feature and the related data feature of record, Data expansion feature is generated, and show；
Wherein, the target data feature comprises at least：The dimension and/or measurement of data；
The related data feature comprises at least：Dimension, measurement and/or its value of data.
2. the method as described in claim 1, the data set is uploaded by the user, or is specified by the user；
The data set of the data to be checked corresponding to the query statement is determined, is specifically included：
The data set for the data to be checked that the user uploads is received, the data set is defined as number corresponding to the query statement
According to collection, or
The storage location information of the data set of data that user specifies, to be checked is determined, according to the storage location acquisition of information
Data set, the data set got is defined as data set corresponding to the query statement.
3. the method as described in claim 1, it is determined that the target data feature based on the data set, is specifically included：
It is determined that target data feature and its object feature value based on the data set.
4. method as claimed in claim 3, the mesh of the target data feature based on the data set is determined by the following method
Mark characteristic value：
Determine the characteristic type belonging to the target data feature；
According to the characteristic type, the data characteristics calculated needed for the object feature value is obtained in data set, and according to setting
Fixed calculation is calculated；
Wherein, the characteristic type belonging to the target data feature, is comprised at least：Feature, characteristics of mean or the ratio of can adding up are special
Sign.
5. method as claimed in claim 4, according to the characteristic type, obtained in data set and calculate the object feature value
Required data characteristics, is specifically included：
When the characteristic type is that can add up feature, cumulative data characteristics can be carried out by being obtained in the data set；
When the characteristic type is characteristics of mean, the data prestored and value tag and number are obtained in the data set
According to counting value tag；
When the characteristic type is Ratio Features, the data component feature prestored and number are obtained in the data set
According to summation feature.
6. method as claimed in claim 5, calculated, specifically included according to the calculation of setting：
When the characteristic type is that can add up feature, according to the numerical value that can carry out cumulative data characteristics got, enter
Row accumulation calculating；
When the characteristic type is characteristics of mean, according in the data and value tag and data counts value tag got
Numerical value, carry out ratio calculation；
When the characteristic type is Ratio Features, according to the number in the data component feature and data summation feature got
Value, carry out ratio calculation.
7. the method as described in claim 1, when including hierarchical relationship in the related data feature, record the user institute
The related data feature of selection, is specifically included：
According to setting storage mode of the related data feature comprising hierarchical relationship in the data set, the dependency number is determined
According to the highest level of feature；
Highest level is showed into user, and receives the query statement step by step of user；
According to the query statement step by step, determine that the different levels of the related data feature are shown step by step, and record use
Level selected by family.
8. method as claimed in claim 7, in the data set, the level of related data feature is stored in the following manner
Relation：
For every a data, the level belonging to the data is determined, as current level；
It is determined that the upper strata level of current level；
The upper strata level of the current level and the current layer level is stored.
9. the method as described in claim 1, methods described also includes：
When generating Data expansion feature, according to default analysis model, target data feature according to selected by user and
Related data feature is analyzed, and is generated analysis result and is shown；
Wherein, the analysis model comprises at least：Year-on-year analysis model, ring are than analysis model, fluctuation ratio analysis model and/or difference
Different value analysis model.
10. the method as described in claim 1, methods described also includes：
Receive storage operation of the user to the Data expansion feature；
Operated according to the storage, determine the extension information corresponding to the Data expansion feature；
The extension information is stored；
Wherein, the extension information comprises at least：The title of growth data feature, target data feature, growth data feature
Characteristic type, calculation and the constraint expression formula based on related data feature.
11. a kind of data query arrangement, including：
Receiving module, receive the query statement of user；
Target signature determining module, the data set of the data to be checked corresponding to the query statement is determined, and based on described
The target data feature of data set；
Correlated characteristic determining module, in the data set, it is determined that related data feature corresponding with the target data feature；
Logging modle, based on the related data feature determined, record the related data feature selected by the user；
Generation module, according to the target data feature and the related data feature of record, Data expansion feature is generated, and open up
Show；
Wherein, the target data feature comprises at least：The dimension and/or measurement of data；
The related data feature comprises at least：Dimension, measurement and/or its value of data.
12. device as claimed in claim 11, the data set is uploaded by the user, or is specified by the user；
The target signature determining module, the data set for the data to be checked that the user uploads is received, the data set is determined
For data set corresponding to the query statement, or
The storage location information of the data set of data that user specifies, to be checked is determined, according to the storage location acquisition of information
Data set, the data set got is defined as data set corresponding to the query statement.
13. device as claimed in claim 11, the target signature determining module, it is determined that the number of targets based on the data set
According to feature and its object feature value.
14. device as claimed in claim 13, the target signature determining module, determine belonging to the target data feature
Characteristic type, according to the characteristic type, the data characteristics calculated needed for the object feature value is obtained in data set, and press
Calculated according to the calculation of setting；
Wherein, the characteristic type belonging to the target data feature, is comprised at least：Feature, characteristics of mean or the ratio of can adding up are special
Sign.
15. device as claimed in claim 14, the target signature determining module, when the characteristic type is the feature that can add up
When, cumulative data characteristics can be carried out by being obtained in the data set；
When the characteristic type is characteristics of mean, the data prestored and value tag and number are obtained in the data set
According to counting value tag；
When the characteristic type is Ratio Features, the data component feature prestored and number are obtained in the data set
According to summation feature.
16. device as claimed in claim 15, the target signature determining module, when the characteristic type is the feature that can add up
When, according to the numerical value that can carry out cumulative data characteristics got, carry out accumulation calculating；
When the characteristic type is characteristics of mean, according in the data and value tag and data counts value tag got
Numerical value, carry out ratio calculation；
When the characteristic type is Ratio Features, according to the number in the data component feature and data summation feature got
Value, carry out ratio calculation.
17. device as claimed in claim 11, when including hierarchical relationship in the related data feature, the record mould
Block, according to setting storage mode of the related data feature comprising hierarchical relationship in the data set, determine the dependency number
According to the highest level of feature, highest level is showed into user, and receives the query statement step by step of user, is looked into step by step according to described
Instruction is ask, determines that the different levels of the related data feature are shown step by step, and record the level selected by user.
18. device as claimed in claim 17, described device also include：Data memory module, in the data set, for
Per a data, the level belonging to the data is determined, as current level, it is determined that the upper strata level of current level, described will work as
The upper strata level of preceding level and the current layer level is stored.
19. device as claimed in claim 11, described device also include：Data analysis module, in generation Data expansion feature
When, according to default analysis model, target data feature and related data feature according to selected by user are analyzed, raw
Into analysis result and show；
Wherein, the analysis model comprises at least：Year-on-year analysis model, ring are than analysis model, fluctuation ratio analysis model and/or difference
Different value analysis model.
20. device as claimed in claim 11, described device also include：Characteristic storage module, user is received to the data
The storage operation of extension feature, operates according to the storage, the extension information corresponding to the Data expansion feature is determined, to institute
Extension information is stated to be stored；
Wherein, the extension information comprises at least：The title of growth data feature, target data feature, growth data feature
Characteristic type, calculation and the constraint expression formula based on related data feature.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710405339.3A CN107357812A (en) | 2017-05-31 | 2017-05-31 | A kind of data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710405339.3A CN107357812A (en) | 2017-05-31 | 2017-05-31 | A kind of data query method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107357812A true CN107357812A (en) | 2017-11-17 |
Family
ID=60271073
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710405339.3A Pending CN107357812A (en) | 2017-05-31 | 2017-05-31 | A kind of data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107357812A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109284833A (en) * | 2018-08-22 | 2019-01-29 | 中国平安人寿保险股份有限公司 | Method, equipment and the storage medium of characteristic are obtained for machine learning model |
| CN109658251A (en) * | 2018-09-28 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Excess reserve rate querying method, device, equipment and storage medium |
| CN109669966A (en) * | 2018-12-12 | 2019-04-23 | 江苏赛睿信息科技股份有限公司 | Multi-stage data analysis method, device and electronic equipment |
| CN110413614A (en) * | 2019-07-09 | 2019-11-05 | 北京三快在线科技有限公司 | A kind of method and device that tables of data generates |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN111177206A (en) * | 2018-11-09 | 2020-05-19 | 阿里巴巴集团控股有限公司 | Method, device and system for processing pivot table |
| CN111382183A (en) * | 2018-12-29 | 2020-07-07 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN112989019A (en) * | 2019-12-12 | 2021-06-18 | 阿里巴巴集团控股有限公司 | Data processing method, device, computer system and readable storage medium |
| CN114168624A (en) * | 2021-12-08 | 2022-03-11 | 掌阅科技股份有限公司 | Data analysis method, computing device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599088A (en) * | 2008-11-18 | 2009-12-09 | 北京美智医疗科技有限公司 | The mining multi-dimensional data system and method for medical information system |
| US20110131250A1 (en) * | 2003-06-02 | 2011-06-02 | Chris Stolte | Computer Systems and Methods for the Query and Visualization of Multidimensional Databases |
| CN104239573A (en) * | 2014-10-08 | 2014-12-24 | 无锡慧方科技有限公司 | Medical system with novel open and integrated type search engine |
| WO2015054841A1 (en) * | 2013-10-16 | 2015-04-23 | 范煜 | Multidimensional data visual query method |
| CN104636478A (en) * | 2015-02-13 | 2015-05-20 | 广州神马移动信息科技有限公司 | Information query method and device |
-
2017
- 2017-05-31 CN CN201710405339.3A patent/CN107357812A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110131250A1 (en) * | 2003-06-02 | 2011-06-02 | Chris Stolte | Computer Systems and Methods for the Query and Visualization of Multidimensional Databases |
| CN101599088A (en) * | 2008-11-18 | 2009-12-09 | 北京美智医疗科技有限公司 | The mining multi-dimensional data system and method for medical information system |
| WO2015054841A1 (en) * | 2013-10-16 | 2015-04-23 | 范煜 | Multidimensional data visual query method |
| CN104239573A (en) * | 2014-10-08 | 2014-12-24 | 无锡慧方科技有限公司 | Medical system with novel open and integrated type search engine |
| CN104636478A (en) * | 2015-02-13 | 2015-05-20 | 广州神马移动信息科技有限公司 | Information query method and device |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109284833A (en) * | 2018-08-22 | 2019-01-29 | 中国平安人寿保险股份有限公司 | Method, equipment and the storage medium of characteristic are obtained for machine learning model |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN110928903B (en) * | 2018-08-31 | 2024-03-15 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN109658251A (en) * | 2018-09-28 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Excess reserve rate querying method, device, equipment and storage medium |
| CN111177206A (en) * | 2018-11-09 | 2020-05-19 | 阿里巴巴集团控股有限公司 | Method, device and system for processing pivot table |
| CN111177206B (en) * | 2018-11-09 | 2023-07-11 | 盒马(中国)有限公司 | Method, device and system for processing pivot table |
| CN109669966A (en) * | 2018-12-12 | 2019-04-23 | 江苏赛睿信息科技股份有限公司 | Multi-stage data analysis method, device and electronic equipment |
| CN111382183B (en) * | 2018-12-29 | 2023-06-27 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN111382183A (en) * | 2018-12-29 | 2020-07-07 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN110413614A (en) * | 2019-07-09 | 2019-11-05 | 北京三快在线科技有限公司 | A kind of method and device that tables of data generates |
| CN112989019A (en) * | 2019-12-12 | 2021-06-18 | 阿里巴巴集团控股有限公司 | Data processing method, device, computer system and readable storage medium |
| CN114168624B (en) * | 2021-12-08 | 2022-09-20 | 掌阅科技股份有限公司 | Data analysis method, computing device and storage medium |
| CN114168624A (en) * | 2021-12-08 | 2022-03-11 | 掌阅科技股份有限公司 | Data analysis method, computing device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107357812A (en) | A kind of data query method and device | |
| US10817534B2 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
| US10599313B2 (en) | System for high volume data analytic integration and channel-independent advertisement generation | |
| CN106796578B (en) | Autoknowledge system and method and memory | |
| US9460402B2 (en) | Condensing hierarchical data | |
| CN110019396A (en) | A kind of data analysis system and method based on distributed multidimensional analysis | |
| US20180165347A1 (en) | Multi-dimensional analysis using named filters | |
| US20160292578A1 (en) | Predictive modeling of data clusters | |
| JP2013513144A (en) | Method, apparatus, and computer program for retrieving annotations of data items in a view | |
| US9424337B2 (en) | Number of clusters estimation | |
| US20110153683A1 (en) | Method and system for generating visual representations of data | |
| US10282360B2 (en) | Uniform chart formatting based on semantics in data models | |
| JP6862531B2 (en) | Guided data exploration | |
| CN111444256A (en) | Method and device for realizing data visualization | |
| CN107705199A (en) | The generation method and device of feature calculation code | |
| US20160140190A1 (en) | Data representation | |
| US7908548B2 (en) | User interface for establishing mappings from internal metadata to external metadata | |
| CN111125266A (en) | Data processing method, device, equipment and storage medium | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| WO2018053859A1 (en) | Report form display system and method | |
| US20160162814A1 (en) | Comparative peer analysis for business intelligence | |
| US9582566B2 (en) | Condensing hierarchical data | |
| Moncrieff et al. | Integrating geo web services for a user driven exploratory analysis | |
| CN110020930B (en) | Financial data system construction method and device | |
| US10713609B1 (en) | Model driven reporting |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201019 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201019 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |