CN108021589A - The collocation method and device of the inquiry dimension of database - Google Patents
The collocation method and device of the inquiry dimension of database Download PDFInfo
- Publication number
- CN108021589A CN108021589A CN201610971433.0A CN201610971433A CN108021589A CN 108021589 A CN108021589 A CN 108021589A CN 201610971433 A CN201610971433 A CN 201610971433A CN 108021589 A CN108021589 A CN 108021589A
- Authority
- CN
- China
- Prior art keywords
- dimension
- database
- collection
- data
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- 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/2228—Indexing structures
- G06F16/2264—Multidimensional index structures
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Abstract
The invention discloses the collocation method and device of a kind of inquiry dimension of database.Wherein, this method includes：By obtaining dimension configuring request, the first dimension collection for asking currently to allow database user to use is updated to the second dimension collection；In response to dimension configuring request, database is currently allowed the first dimension collection that user uses be updated to the second dimension collection；Second dimension collection is replaced the first dimension collection is included on the query interface of database, so that user inquires about database according to one or more of the second dimension collection dimension.The low technical problem of search efficiency caused by the inquiry dimension for needing wait newly-increased when the present invention is solved by increasing data query dimension newly is reached the standard grade.
Description
Technical field
The present invention relates to data processing field, collocation method in particular to a kind of inquiry dimension of database and
Device.
Background technology
In the prior art, data processing method is usually：For business demand, number is obtained from perdurable data storehouse from the background
According to being stored in caching after asynchronous computing, further according to agreement dock with interface user, the data in caching carried out with assembly, again
Group.Alternatively, being directed to business demand, access layer directly inquires about database, and data are recombinated, is assembled, then according to set
Agreement is supplied to interface user.
Prior art has disadvantages that, for example, development cost is high, interface is not configurable, authority is uncontrollable, interface association
No clear and definite standard etc. is discussed, and prior art interface is once reached the standard grade, and inquiry dimension has just been fixed, if desired from new
Dimension inquiry data, then need interface provider to develop, dispose, reach the standard grade again, flow is tediously long.
For it is above-mentioned the problem of, not yet propose effective solution at present.
The content of the invention
An embodiment of the present invention provides the collocation method and device of a kind of inquiry dimension of database, at least to solve to pass through
The low technical problem of search efficiency caused by the inquiry dimension for needing wait newly-increased during newly-increased data query dimension is reached the standard grade.
One side according to embodiments of the present invention, there is provided a kind of collocation method of the inquiry dimension of database, including：
Dimension configuring request is obtained, wherein, the dimension configuring request is used to ask currently allow database user to use first
Dimension collection is updated to the second dimension collection；In response to the dimension configuring request, currently user is allowed to make the database
First dimension collection is updated to second dimension collection；Second dimension collection is replaced into first dimension
Set is shown on the query interface of the database, so that user is according to one or more of described second dimension collection
Dimension inquires about the database.
Another aspect according to embodiments of the present invention, additionally provides a kind of configuration device of the inquiry dimension of database, bag
Include：First acquisition unit, for obtaining dimension configuring request, wherein, the dimension configuring request is used to ask to work as database
Preceding the first dimension collection for allowing user to use is updated to the second dimension collection；Updating block, for matching somebody with somebody in response to the dimension
Request is put, first dimension collection that the database currently allows user to use is updated to second dimension collection；
Display unit, includes the query interface in the database for second dimension collection to be replaced first dimension collection
On, so that user inquires about the database according to one or more of second dimension collection dimension.
In embodiments of the present invention, by obtaining dimension configuring request, ask currently to allow database into what user used
First dimension collection is updated to the second dimension collection；In response to dimension configuring request, database is currently allowed to what user used
First dimension collection is updated to the second dimension collection；Second dimension collection is replaced the first dimension collection includes looking into database
Ask on interface, so that user inquires about database according to one or more of the second dimension collection dimension, reach
The extra purpose for supporting that database can be inquired about by new dimension is provided without waiting for interface provider, it is achieved thereby that according to
Second dimension collection is replaced the first dimension collection and allowed a user to by the dimension in the second dimension collection by dimension configuring request
Need to wait in newly-increased inquiry dimension when inquiring about the technique effect of database, and then solving by increasing data query dimension newly
The low technical problem of search efficiency caused by line.
Brief description of the drawings
Attached drawing described herein is used for providing a further understanding of the present invention, forms the part of the application, this hair
Bright schematic description and description is used to explain the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the schematic diagram of the hardware environment of the collocation method of the inquiry dimension of database according to embodiments of the present invention；
Fig. 2 is a kind of flow chart of the collocation method of the inquiry dimension of optional database according to embodiments of the present invention；
Fig. 3 is a kind of flow chart of document library system framework according to embodiments of the present invention；
Fig. 4 is the schematic diagram of abstraction UML according to embodiments of the present invention；
Fig. 5 is the schematic diagram of data bank code excerpt according to embodiments of the present invention；
Fig. 6 is the schematic diagram of a variety of inquiry dimension interface exploitations according to prior art；
Fig. 7 is the schematic diagram of a variety of inquiry dimension interface exploitations according to embodiments of the present invention；
Fig. 8 is the schematic diagram of Olympic contest detailed data query result according to embodiments of the present invention；
Fig. 9 is the schematic diagram of NBA player statistics according to embodiments of the present invention；
Figure 10 is the schematic diagram of football race statistics according to embodiments of the present invention；
Figure 11 is a kind of schematic diagram of the configuration device of the inquiry dimension of optional database according to embodiments of the present invention；
And
Figure 12 is a kind of structure diagram of terminal according to embodiments of the present invention.
Embodiment
In order to make those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Attached drawing, is clearly and completely described the technical solution in the embodiment of the present invention, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
Member's all other embodiments obtained without making creative work, should all belong to the model that the present invention protects
Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so use
Data can exchange in the appropriate case, so as to the embodiment of the present invention described herein can with except illustrating herein or
Order beyond those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment
Those steps or unit clearly listed, but may include not list clearly or for these processes, method, product
Or the intrinsic other steps of equipment or unit.
Embodiment 1
According to embodiments of the present invention, there is provided a kind of embodiment of the method for the configuration of the inquiry dimension of database.
Alternatively, in the present embodiment, the collocation method of the inquiry dimension of above-mentioned database can be applied to as shown in Figure 1
The hardware environment being made of server 102 and terminal 104 in.As shown in Figure 1, server 102 passes through network and terminal 104
It is attached, above-mentioned network includes but not limited to：Wide area network, Metropolitan Area Network (MAN) or LAN, terminal 104 be not limited to PC, mobile phone,
Tablet computer etc..The collocation method of the inquiry dimension of the database of the embodiment of the present invention can be performed by server 102, also may be used
To be performed by terminal 104, it can also be and performed jointly by server 102 and terminal 104.Wherein, terminal 104 performs the present invention
The collocation method of the inquiry dimension of the database of embodiment can also be performed by client mounted thereto.
In a kind of optional application scenarios, the collocation method of the inquiry dimension of database can be by operating in terminal
Database inquiry system realizes that database inquiry system obtains dimension configuring request, asks newly-increased one or more data to be looked into
Dimension is ask, the first dimension collection that original permission user uses is updated to by database inquiry system according to dimension configuring request
Second dimension collection, then includes the second dimension collection on the query interface of database, enables a user to by the
Dimension in two-dimensions set inquires about database.Database inquiry system can also be run in the server, by servicing
Device performs control and calculates, and result of calculation is returned in terminal and is shown.
Fig. 2 is a kind of flow chart of the collocation method of the inquiry dimension of optional database according to embodiments of the present invention,
As shown in Fig. 2, this method may comprise steps of：
Step S202, obtains dimension configuring request, wherein, dimension configuring request is used to ask currently to allow to use by database
The first dimension collection that family uses is updated to the second dimension collection.
Database, in response to dimension configuring request, is currently allowed the first dimension collection that user uses more by step S204
New is the second dimension collection.
Step S206, the second dimension collection is replaced the first dimension collection is included on the query interface of database, so that
User is obtained to inquire about database according to one or more of the second dimension collection dimension.
By above-mentioned steps S202 to step S206, by obtaining dimension configuring request, ask currently to allow database
The first dimension collection that user uses is updated to the second dimension collection；In response to dimension configuring request, database is currently allowed
The first dimension collection that user uses is updated to the second dimension collection；Second dimension collection is replaced the first dimension collection includes
On the query interface of database, so that user looks into database according to one or more of the second dimension collection dimension
Ask, the low skill of search efficiency caused by the inquiry dimension for needing wait newly-increased when solving by increasing data query dimension newly is reached the standard grade
Art problem, and then the second dimension collection is replaced by the first dimension collection according to dimension configuring request and is allowed a user to by the
The technique effect of dimension inquiry database in two-dimensions set, improves search efficiency.
In the technical solution that step S202 is provided, the first dimension collection and the second dimension collection can be one or more
The set of a dimension, for example, the first dimension collection is the set of four dimensions, the second dimension collection is the set of six dimensions,
Or first dimension collection be four dimensions set, the second dimension collection is the set of a dimension, and the first dimension collection is
The set of the current dimension for allowing user to use, user can be by all dimensions in the first dimension collection in database
Data are inquired about, and the difference of the second dimension collection and the first dimension collection is the inquiry dimension that user wants to change, for example, with
Newly-increased inquiry dimension is wanted at family, then the second dimension collection is that this is newly-increased than the inquiry dimension being had more in the first dimension collection
Inquiry dimension.The first dimension collection that dimension configuring request is used to ask currently to allow database user to use is updated to the
Two-dimensions set, dimension configuring request can be that interface user sends, and it can be that database is looked into obtain dimension configuring request
What inquiry system obtains or other modes obtained, the dimension letter of request configuration can be carried in dimension configuring request
Breath, for example, params parameters etc., can also carry dimension name of request configuration etc..
, please in response to dimension configuration after dimension configuring request is got in the technical solution that step S204 is provided
Ask, database is currently allowed the first dimension collection that user uses be updated to the second dimension collection.Database currently allows to use
Family is inquired about using the dimension in the first dimension collection, and after dimension configuring request is got, database is by the first dimension
Set is updated to the second dimension collection, and user can inquire about database by the dimension in the second dimension collection.In sound
, can be with when the first dimension collection that answering dimension configuring request currently allows database user to use is updated to the second dimension collection
First dimension collection is updated to the second dimension collection by the dimensional information that the request according to being carried in dimension configuring request configures.
When first dimension collection is updated to the second dimension collection, without user's manual setting, but it is automatic by database inquiry system
Configured, since dimension configuration needs need not be sent to interface provider, wait interface provider exploitation to reach the standard grade, because
This, can effectively improve efficiency data query.
In the technical solution that step S206 is provided, after the first dimension collection is updated to the second dimension collection, in number
The first dimension collection is replaced with the second dimension collection according on the query interface in storehouse, for example, the first dimension collection has four inquiries
Attribute, and the second dimension collection has six querying attributes, then is belonged on the query interface of the database after updating by four inquiries
Property increase be six, user can inquire about the data in database by six querying attributes after renewal.
As a kind of optional embodiment, before dimension configuring request is obtained, whole dimensions that data place is supported
State be arranged to configurable state, wherein, the dimension in configurable state is used to be configured in response to the first configuration-direct
The inquiry dimension for not allowing currently user to use for database, or work as being configured as database in response to the second configuration-direct
The preceding inquiry dimension for allowing user to use.
The state for whole dimensions that data place is supported include configurable state and can not configuration status, in some dimension
When state is configurable state, which can be configured to the inquiry dimension for allowing user to use, or not allow user to make
Inquiry dimension, it is allowed to which the inquiry dimension that user uses can be used by a user, and not allow the inquiry dimension that user uses not
It can be used by a user, some dimension can be positioned to allow for user's use by the first configuration-direct, and the second configuration-direct can incite somebody to action
Some dimension is arranged to not allow user to use.Before dimension configuring request is obtained, whole dimensions that data place is supported
State be arranged to after configurable state, it is possible to one or more dimensions are configured in response to dimension configuring request,
Then database is currently allowed the first dimension collection that user uses to be updated to the second dimension collection.
As a kind of optional embodiment, database is currently allowed the first dimension collection that user uses be updated to second
Dimension collection includes：The dimension in the first dimension collection is arranged to database in response to the first configuration-direct does not allow currently to use
The inquiry dimension that family uses, and the dimension in the second dimension collection is arranged to database in response to the second configuration-direct and is currently permitted
The inquiry dimension that family allowable uses.
After the state for the whole dimensions for supporting data place is arranged to configurable state, database is currently allowed
The first dimension collection that user uses is updated to the second dimension collection, wherein, the inquiry dimension for wishing to delete for user, response
In the inquiry dimension that the dimension in the first dimension collection is arranged to currently not allow user to use by the first configuration-direct, then ring
The dimension in the second dimension collection should be positioned to allow for the inquiry dimension that user uses in the second configuration-direct.
As a kind of optional embodiment, the first configuration-direct and the second configuration-direct are same instruction, wherein, by data
The first dimension collection that storehouse currently allows user to use, which is updated to the second dimension collection, to be included：The information generation of response input is same
Instruction；Respond same instruction and the value of the dimension configuration parameter of database is updated to second value from the first value, wherein, the first value
For indicating the dimension in the first dimension collection, second value is used to indicate the dimension in the second dimension collection, dimension configuration parameter
The inquiry dimension for currently allowing user to use for referred database.
First configuration-direct and the second configuration-direct can be same instruction, for example, by the dimension in the first dimension collection
Increase by one obtains the second dimension collection, then the first configuration-direct and the second configuration-direct are same, in response to same finger
The value of the dimension configuration parameter of database is updated to second value by order from the first value, and the first value and second value represent first respectively
Dimension in dimension collection and the second dimension collection, dimension configuration parameter can represent that database currently allows what user used to look into
Ask dimension.
As a kind of optional embodiment, the second dimension collection is replaced the first dimension collection includes the inquiry in database
Include on interface：Dimension in second dimension collection is loaded on the query interface of database by response web access requests, its
In, web access requests are used to ask the query interface for accessing database.
When the inquiry dimension to database configures, replace the first dimension collection with the second dimension collection and be shown in number
According on the query interface in storehouse, web access requests are used to ask the query interface for accessing database, and the query interface of database can
To be web interface, such as when web interface refreshes, response web access requests load the dimension in the second dimension collection
On the query interface of database.
As a kind of optional embodiment, between the dimension in dimension and the second dimension collection in the first dimension collection
Relation includes at least one following：First dimension collection includes the second dimension collection；Second dimension collection includes the first dimension collection
Close；There are intersection for first dimension collection and the second dimension collection；First dimension collection and the second dimension collection do not have intersection.
One or more dimensions are also included comprising one or more dimensions, the second dimension collection in first dimension collection, such as
The inquiry dimension that fruit newly configures is reduced, then the first dimension collection can include the second dimension collection；If the inquiry dimension newly configured
Degree increase, then the second dimension collection includes the first dimension collection, if the inquiry dimension newly configured has a small range change, first
There are intersection for dimension collection and the second dimension collection；If the scope of the inquiry dimension change newly configured is larger, the first dimension
Set and the second dimension collection do not have intersection.
As a kind of optional embodiment, before dimension configuring request is obtained, pass through the judgement data source number of serial number
According to whether there is newly-increased data in storehouse, when the data in data source data storehouse have newly-increased data, by newly-increased data
Import in Information Repository database.
When the data in data source data storehouse are imported in Information Repository database, data are carried out by serial number mechanism and are led
Enter, when certain data in data source data storehouse changes, document library system has perceived data by serial number change
Change, when the data in data source data storehouse are newly-increased, newly-increased data are imported in Information Repository database.Changed by serial number
The data variation in data source data storehouse is obtained, data variation can be obtained in time, improves data configuration efficiency.
As a kind of optional embodiment, before dimension configuring request is obtained, to the data in data source database into
Row is abstract, obtains multiple abstractions, wherein, multiple abstractions include the first abstraction, the second abstraction, the 3rd abstraction, the
Four abstractions, the first abstraction are used to configure the Data source table in data source database, and the second abstraction is used for industry
Business interface is configured, and the 3rd abstraction is used to configure data source row, and the 4th abstraction is used to take business interface
Field configured.
Database inquiry system can be abstracted the tables of data in database, obtain multiple abstractions, each abstract
Body is responsible for configuring certain part of the data in data source database or tables of data.Wherein, multiple abstractions can be with
Including other abstractions, the 3rd abstraction is used to configure data source row, can be the row progress to data source data table
Configuration.
As a kind of optional embodiment, include looking into database the second dimension collection is replaced the first dimension collection
Before or after asking on interface, the data inquiry request of active user is received；Whether judgement currently has historical user to be transparent to number
According to library inquiry data；If currently there is historical user to be transparent to data base querying data, active user is not allowed to be transparent to number
According to library inquiry data.
When user inquires about database, the data first read in caching are inquired about, if in the buffer can not
The data of needs are inquired, then is transparent in database and inquires about data, but any time, only a user are transparent to data
Library inquiry data, it is impossible to while two users are transparent to data base querying data, if it is determined that currently having historical user's transparent transmission
To data base querying data, then active user is not allowed to be transparent to data base querying data, by limiting same time inquiring number
According to the quantity of the user in storehouse, it is possible to increase the efficiency of data query.
Present invention also offers a kind of preferred embodiment, with reference to the preferred embodiment to technical scheme into
Row explanation：
The collocation method of the inquiry dimension of the database of the embodiment of the present invention can be performed by database inquiry system, the number
It can be connect according to library inquiry system as a kind of data bank data query system of configurableization, database inquiry system including system
Enter layer, system logic layer and system data layer etc..
(1) the problems such as system access layer mainly handles xss, and csrf, sql inject, and service authority is verified, protect
The department that demonstrate,proving only has the interface authority can use, while also only the business having permission is responsible for.Golang languages can be used
Association's journey technology timing renewal search index of speech.System not only realizes the local cache of interface, but also for data bank data
The access frequency in storehouse limits, and ensures only have a user to be transparent to data base querying data within the regular hour, other
Data are obtained in user's all access caches.The user of interface can be according to the inquiry dimension of the needs of oneself, in get parameters
Configured, and the data structure (such as dictionary, array) that dynamic configuration oneself needs, without demand is posed to interface again
Provider, and could be used after waiting one section of exploitation on-line time.
(2) system logic layer assembles data, is formatted, and can be completed by consistency operation interface here, so that
Have the function that interface is reached the standard grade at once after verifying to come into force.Fig. 3 is a kind of document library system frame according to embodiments of the present invention
The flow chart of structure, as shown in figure 3, the document library system framework comprises the following steps：
Step S301, access layer inquiry system inquiry data.
Interface user sends inquiry request, and data are inquired about by access layer inquiry system.In database frequency limit,
Data in query caching, if the data currently without user in Information Repository database is inquired about, can inquire about data bank
In data.
Step S302, backstage operation system configuration interface.
Interface configuration person applies for interface authority, in Authority Verification by that afterwards, can be configured and connect by backstage operation system
Mouthful.
Step S303, Information Repository database provide data query.
Information Repository database provides data query service by the interface newly configured.
Step S304, data import.
Data in Information Repository database are imported by data source data storehouse.Include full dose importing and increment when data import
Import two parts.
Step S305, full dose import.
It can be that manually position-automatic position carries out full dose renewal that full dose, which imports (loadall), in table initialization or
Run during the artificial set of person, for importing data full dose or data full dose is recovered.
Step S306, increment import.
Increment, which imports (loadincr), to carry out incremental update according to serial number, and number is obtained from data source data storehouse
According to data that are newly-increased or changing are imported into Information Repository database.
Data are collected in step S307, data source data storehouse.
Data in data source data storehouse can come from multiple programs, for example, football data source imports program, NBA data
Source imports program, and NFL data sources import program, and Olympic Games data source imports program, and CBA data sources import program etc..
Step S308, table structural maintenance.
At regular intervals, newly-increased data be might have, for example, when field or attribute increase, by data source data storehouse and
Table in Information Repository database is safeguarded.
(3) system data layer mainly includes data import modul and tables of data structural maintenance module, data import modul
Data import is divided into " full dose importing " and " increment importing " again." full dose importing " is run in table initialization or artificial set,
For by data full dose import or data full dose recover." increment importing " has used serial number mechanism, i.e. Data source table
Data change, and document library system is perceived by serial number change, you can this record of corresponding renewal.By assisting journey at the same time
Multiple tables are handled, make use of the hardware superiority of multinuclear, so as to improve renewal efficiency.Table structural maintenance module is mainly used for safeguarding
The table structure of Information Repository database, database D DL operations are carried out by configuring to tables of data.
(4) system is abstracted tables of data, and it is several abstract to take out Cube, CubeCol, CubeDim and CubeTemp
Body, Fig. 4 is the schematic diagram of abstraction UML according to embodiments of the present invention, as shown in figure 4, the abstraction is modeled by standard
Language (Unified Modeling Language, referred to as UML) realization, wherein, Cube is the abstract of all tables of data
Body, is the data basis of total interface, and is responsible for data source data and is integrated, and Data source table is managed for configuration.
CubeCol can be understood as the field that can be configured in interface, and data source row are managed for configuration.CubeDim is appreciated that
For the data space for traffic assignments, business interface is managed for configuration.CubeTemp is that the data space of business has been matched somebody with somebody
The field put, takes field to be managed for configuration business interface.The quantitative proportion of each Cube and CubeCol can be 1：N,
The quantitative proportion of each CubeDim and CubeTemp can be 1：N.
Fig. 5 is the schematic diagram of data bank code excerpt according to embodiments of the present invention, as shown in figure 5, document library system is real
Show oneself custom interface, real-time update data, easy care, configurable and there is interface authority management according to demand,
The service line of multiple departments can be supported.Interface unit is read concurrently to have reached 1300qps, is delayed 4 milliseconds, is supported on 10 or so
(mainly consuming CPU).
Fig. 6 is the schematic diagram of a variety of inquiry dimension interface exploitations according to prior art, as shown in fig. 6, in the prior art,
Interface user applies for that interface is wished after being inquired about by new dimension, such as wishes the inquiry of passage time dimension, match dimension
Inquiry or match dimension+time dimension inquiry, then need interface provider to develop new interface, there is provided side disposes code
Line, is then back to data, could realize and inquire about data by new dimension.Fig. 7 is a variety of inquiries according to embodiments of the present invention
The schematic diagram of dimension interface exploitation, as shown in fig. 7, after user applies for interface, without exploitation, passes through the automatic high configuration of parameter
It can be achieved to inquire about data by new dimension, for example, passage time dimension is inquired about, parameter params=t5 can be passed through:
2015-08-20~2016-08-30 is inquired about, and obtains returned data, for another example inquiring about data by dimension of competing, can be passed through
Parameter params-t1:WPW400A02 is inquired about, and obtains returned data, alternatively, being inquired about by dimension of competing+time dimension, is passed through
Parameter params=t1：WPW400A02|t5：2015-08-04~2016-08-30 is inquired about, and obtains returned data.
Fig. 8 is the schematic diagram of Olympic contest detailed data query result according to embodiments of the present invention, as shown in figure 8, can
Include racing number to inquire about the detailed data of Olympic contest according to ranking dimension, in query result, name, country /region,
Multiple dimensional informations such as achievement, the final result are often jumped, can also be inquired about from other dimensions, obtain comprehensive query result.
Fig. 9 is the schematic diagram of NBA player statistics according to embodiments of the present invention, as shown in figure 9, using NBA sportsman as
Dimension inquiry sportsman's related data is inquired about, can be according to the equal score in field, the equal backboard in field, multiple dimensions inquiry sportsmen such as assist for field
Related data.
Figure 10 is the schematic diagram of football race statistics according to embodiments of the present invention, as shown in Figure 10, can be inquired about
The data of this competition season single game data statistics dimension, fixture, match team title, team's figure are included in obtained query result
Mark, score, goal number, assists, number of passing, grab the knot of multiple dimensions such as number, famous number, yellow card number
Fruit, the statistical result of racing season statistical dimension include England Premier League victory and put down negative number, goal quantity, quantity of fumbling, assists, pass
Number, grabs the data of multiple dimensions such as number, famous number, yellow card number, offside number, foul times.
The data query system of the embodiment of the present invention is in Olympic Games database project, NBA database projects, football database items
Test and complete in mesh, system provides standardized data interface for more than 200 a projects of the Olympic Games, as schedules, ranking list, match are detailed
Count evidence, player information, national information etc. accurately.Due to the use of technical scheme, interface user is applying connecing
After mouthful, it can be inquired about according to the dimension that oneself is needed, such as time dimension, project dimension, sportsman's dimension, rather than
As in pervious scheme, every kind of new inquiry dimension is required for interface provider to be developed, code deployment is reached the standard grade, therefore this hair
The technical solution of bright embodiment can greatly improve the allocative efficiency of new inquiry dimension interface, can also improve data query
Efficiency.
The collocation method of the inquiry dimension of the database of the embodiment of the present invention, realizes following functions, and (1) interface can configure
The function of change, is supported for the height of web agile developments.(2) interface called side can be joined according to the demand of oneself by get
Several configurations carries out interface the inquiry of various dimensions.(3) system architecture is realized, for the abstract of data structure.(4) it is perfect
Serial number update mechanism.(5) protection of the local cache for bottom data.Compared with prior art, have the advantage that：
1 prior art of table is contrasted with technical scheme
| Contrast points | Prior art | Technical solution of the present invention |
| Interface exploitation cost | It is high | It is low |
| Inquiry dimension can configure | It is no | It is |
| Nuclear interface standardizing | It is low | It is high |
| Interface needs code deployment, reaches the standard grade | It is | It is no |
As shown in table 1, prior art development cost is high, interface is not configurable, authority is uncontrollable etc..And the present invention
In the case where no interface provider provides extra support, interface is easy to use to be moved according to the demand of oneself technical solution
State configures interface.Prior art interface is once reached the standard grade, and inquiry dimension has just been fixed, if necessary to be inquired about from new dimension
Data, then need interface provider to develop, dispose, reach the standard grade again, flow is tediously long.And technical scheme can make interface
User carries out various dimensions inquiry according to the demand of oneself, is additionally supported without interface provider.Prior art provides
Interface protocol there is no clear and definite standard.The interface of technical scheme is supplied to interface to use with the agreement of standardization
Side, has a variety of advantages relative to the prior art.
It should be noted that for foregoing each method embodiment, in order to be briefly described, therefore it is all expressed as a series of
Combination of actions, but those skilled in the art should know, the present invention and from the limitation of described sequence of movement because
According to the present invention, some steps can use other orders or be carried out at the same time.Secondly, those skilled in the art should also know
Know, embodiment described in this description belongs to preferred embodiment, and involved action and module are not necessarily of the invention
It is necessary.
Through the above description of the embodiments, those skilled in the art can be understood that according to above-mentioned implementation
The method of example can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but very much
In the case of the former be more preferably embodiment.Based on such understanding, technical scheme is substantially in other words to existing
The part that technology contributes can be embodied in the form of software product, which is stored in a storage
In medium (such as ROM/RAM, magnetic disc, CD), including some instructions are used so that a station terminal equipment (can be mobile phone, calculate
Machine, server, or network equipment etc.) perform method described in each embodiment of the present invention.
Embodiment 2
According to embodiments of the present invention, a kind of collocation method for the inquiry dimension for being used to implement above-mentioned database is additionally provided
The configuration device of the inquiry dimension of database.Figure 11 is a kind of inquiry dimension of optional database according to embodiments of the present invention
Configuration device schematic diagram, as shown in figure 11, which can include：
First acquisition unit 10, for obtaining dimension configuring request, wherein, dimension configuring request is used to ask database
Current the first dimension collection for allowing user to use is updated to the second dimension collection；
Updating block 20, in response to dimension configuring request, the first dimension for database currently being allowed user use
Set is updated to the second dimension collection；
Display unit 30, includes the query interface in database for the second dimension collection to be replaced the first dimension collection
On, so that user inquires about database according to one or more of the second dimension collection dimension.
It should be noted that the first acquisition unit 10 in the embodiment can be used for performing in the embodiment of the present application 1
Step S202, the updating block 20 in the embodiment can be used for performing the step S204 in the embodiment of the present application 1, the embodiment
In display unit 30 can be used for perform the embodiment of the present application 1 in step S206.
Herein it should be noted that above-mentioned module is identical with example and application scenarios that corresponding step is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module as a part for device may operate in as
It in hardware environment shown in Fig. 1, can be realized by software, hardware realization can also be passed through.
By above-mentioned module, the inquiry dimension for needing wait newly-increased when solving by increasing data query dimension newly, which is reached the standard grade, to be led
The low technical problem of the search efficiency of cause, and then the second dimension collection is replaced by the first dimension collection according to dimension configuring request
Close the technique effect for allowing a user to that database is inquired about by the dimension in the second dimension collection.
Alternatively, which further includes：Setting unit, for before dimension configuring request is obtained, by data place branch
The state for the whole dimensions held is arranged to configurable state, wherein, the dimension in configurable state is used to match somebody with somebody in response to first
Put instruction and be configured as the inquiry dimension that database does not allow currently user to use, or in response to the second configuration-direct by with
It is set to the inquiry dimension that database currently allows user to use.
Alternatively, updating block 20 is used for：The dimension in the first dimension collection is arranged in response to the first configuration-direct
Database does not allow the inquiry dimension that user uses currently, and in response to the second configuration-direct by the dimension in the second dimension collection
It is arranged to the inquiry dimension that database currently allows user to use.
Alternatively, the first configuration-direct and the second configuration-direct are same instruction, wherein, updating block 20 includes：Generation
Module, the information for responding input generate same instruction；Update module, matches somebody with somebody the dimension of database for responding same instruction
The value for putting parameter is updated to second value from the first value, wherein, first value be used for indicate the first dimension collection in dimension, second
Value is used to indicate the dimension in the second dimension collection, and dimension configuration parameter, which is used for referred database, currently allows what user used to look into
Ask dimension.
Alternatively, display unit 30 is used for：Dimension in second dimension collection is loaded into number by response web access requests
According on the query interface in storehouse, wherein, web access requests are used to ask the query interface for accessing database.
Alternatively, the relation between the dimension in the dimension and the second dimension collection in the first dimension collection include such as down toward
It is one of few：First dimension collection includes the second dimension collection；Second dimension collection includes the first dimension collection；First dimension collection
There are intersection with the second dimension collection；First dimension collection and the second dimension collection do not have intersection.
Alternatively, second acquisition unit, for before dimension configuring request is obtained, judging number by the serial number of data
According to whether there is newly-increased data in source database, import unit, during for there are newly-increased data in data source data storehouse,
Newly-increased data are imported in Information Repository database.
Alternatively, which further includes：Processing unit, for before dimension configuring request is obtained, to data source data
Data in storehouse are abstracted, and obtain multiple abstractions, wherein, multiple abstractions include：First abstraction, the second abstraction,
3rd abstraction and the 4th abstraction, the first abstraction are used to configure the Data source table in data source database, and second
Abstraction is used to configure business interface, and the 3rd abstraction is used to configure data source row, and the 4th abstraction is used for
The field taken to business interface configures.
Alternatively, which further includes：Receiving unit, for being shown by the second dimension collection the first dimension collection of replacement
Before or after on the query interface of database, the data inquiry request of active user is received；Judging unit, for judging to work as
It is preceding whether to there is historical user to be transparent to data base querying data；Control unit, for thering is historical user to be transparent to data currently
During library inquiry data, active user is not allowed to be transparent to data base querying data.
Herein it should be noted that above-mentioned module is identical with example and application scenarios that corresponding step is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module as a part for device may operate in as
In hardware environment shown in Fig. 1, can be realized by software, can also by hardware realization, wherein, hardware environment includes network
Environment.
Embodiment 3
According to embodiments of the present invention, a kind of collocation method for the inquiry dimension for being used to implement above-mentioned database is additionally provided
Server or terminal.
Figure 12 is a kind of structure diagram of terminal according to embodiments of the present invention, and as shown in figure 12, which can include：
One or more (one is only shown in figure) processor 201, memory 203 and transmitting devices 205 are (in such as above-described embodiment
Dispensing device), as shown in figure 12, which can also include input-output equipment 207.
Wherein, memory 203 can be used for storage software program and module, such as looking into for the database in the embodiment of the present invention
The collocation method and the corresponding programmed instruction/module of device of dimension are ask, processor 201 is stored in memory 203 by operation
Software program and module, so as to perform various functions application and data processing, that is, realize the inquiry of above-mentioned database
The collocation method of dimension.Memory 203 may include high speed random access memory, can also include nonvolatile memory, such as one
Or multiple magnetic storage devices, flash memory or other non-volatile solid state memories.In some instances, memory 203 can
Further comprise that relative to the remotely located memory of processor 201, these remote memories network connection to end can be passed through
End.The example of above-mentioned network includes but not limited to internet, intranet, LAN, mobile radio communication and combinations thereof.
Above-mentioned transmitting device 205 is used to data are received or sent via network, can be also used for processor with
Data transfer between memory.Above-mentioned network instantiation may include cable network and wireless network.In an example,
Transmitting device 205 includes a network adapter (Network Interface Controller, NIC), it can pass through cable
It is connected with other network equipments with router so as to be communicated with internet or LAN.In an example, transmission dress
It is radio frequency (Radio Frequency, RF) module to put 205, it is used to wirelessly be communicated with internet.
Wherein, specifically, memory 203 is used to store application program.
Processor 201 can call the application program that memory 203 stores by transmitting device 205, to perform following steps
Suddenly：Dimension configuring request is obtained, wherein, dimension configuring request is used to ask the first dimension for currently allowing database user to use
Degree set is updated to the second dimension collection；In response to dimension configuring request, the first dimension for database currently being allowed user use
Degree set is updated to the second dimension collection；Second dimension collection is replaced the first dimension collection includes the query interface in database
On, so that user inquires about database according to one or more of the second dimension collection dimension.
Processor 201 is additionally operable to perform following step：Before dimension configuring request is obtained, data place is supported complete
The state of portion's dimension is arranged to configurable state, wherein, the dimension in configurable state is used in response to the first configuration-direct
The inquiry dimension that database does not allow currently user to use is configured as, or for being configured as counting in response to the second configuration-direct
The inquiry dimension for currently allowing user to use according to storehouse.
Processor 201 is additionally operable to perform following step：In response to the first configuration-direct by the dimension in the first dimension collection
The inquiry dimension that database does not allow currently user to use is arranged to, and in response to the second configuration-direct by the second dimension collection
Dimension be arranged to the inquiry dimension that database currently allows user to use.
Processor 201 is additionally operable to perform following step：The information of response input generates same instruction；Responding same instruction will
The value of the dimension configuration parameter of database is updated to second value from the first value, wherein, the first value is used to indicate the first dimension collection
Dimension in conjunction, second value are used to indicate the dimension in the second dimension collection, and it is current that dimension configuration parameter is used for referred database
The inquiry dimension for allowing user to use.
Processor 201 is additionally operable to perform following step：Response web access requests add the dimension in the second dimension collection
It is downloaded on the query interface of database, wherein, web access requests are used to ask the query interface for accessing database.
Processor 201 is additionally operable to perform following step：Judge whether deposited in data source data storehouse by the serial number of data
In newly-increased data；When there are newly-increased data in data source data storehouse, newly-increased data are imported in Information Repository database.
Processor 201 is additionally operable to perform following step：Before dimension configuring request is obtained, in data source database
Data are abstracted, and obtain multiple abstractions, wherein, multiple abstractions include：First abstraction, the second abstraction, the 3rd take out
As body and the 4th abstraction, the first abstraction is used to configure the Data source table in data source database, the second abstraction
For being configured to business interface, the 3rd abstraction is used to configure data source row, and the 4th abstraction is used for business
The field that interface is taken is configured.
Processor 201 is additionally operable to perform following step：Include the second dimension collection is replaced the first dimension collection in number
Before or after on the query interface in storehouse, the data inquiry request of active user is received；Whether judgement currently has historical user
It is transparent to data base querying data；If currently there is historical user to be transparent to data base querying data, do not allow active user
It is transparent to data base querying data.
Using the embodiment of the present invention, by obtaining dimension configuring request, ask currently to allow database into what user used
First dimension collection is updated to the second dimension collection；In response to dimension configuring request, database is currently allowed to what user used
First dimension collection is updated to the second dimension collection；Second dimension collection is replaced the first dimension collection includes looking into database
Ask on interface, so that user inquires about database according to one or more of the second dimension collection dimension, reach
The extra purpose for supporting that database can be inquired about by new dimension is provided without waiting for interface provider, it is achieved thereby that according to
Second dimension collection is replaced the first dimension collection and allowed a user to by the dimension in the second dimension collection by dimension configuring request
Need to wait in newly-increased inquiry dimension when inquiring about the technique effect of database, and then solving by increasing data query dimension newly
The low technical problem of search efficiency caused by line.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2
Example, details are not described herein for the present embodiment.
It will appreciated by the skilled person that the structure shown in Figure 12 is only to illustrate, terminal can be smart mobile phone
(such as Android phone, iOS mobile phones), tablet computer, palm PC and mobile internet device (Mobile Internet
Devices, MID), the terminal device such as PAD.Figure 12 it does not cause to limit to the structure of above-mentioned electronic device.For example, terminal is also
It may include more either less components (such as network interface, display device) than shown in Figure 12 or have and Figure 12 institutes
Show different configurations.
One of ordinary skill in the art will appreciate that all or part of step in the various methods of above-described embodiment is can
To be completed by program come command terminal device-dependent hardware, which can be stored in a computer-readable recording medium
In, storage medium can include：Flash disk, read-only storage (Read-Only Memory, ROM), random access device (Random
Access Memory, RAM), disk or CD etc..
Embodiment 4
The embodiment of the present invention additionally provides a kind of storage medium.Alternatively, in the present embodiment, above-mentioned storage medium can
For performing the program code of the collocation method of the inquiry dimension of database.
Alternatively, in the present embodiment, above-mentioned storage medium can be located at multiple in the network shown in above-described embodiment
On at least one network equipment in the network equipment.
Alternatively, in the present embodiment, storage medium is arranged to the program code that storage is used to perform following steps：
S1, obtains dimension configuring request, wherein, dimension configuring request is used to ask currently to allow user to use database
The first dimension collection be updated to the second dimension collection；
S2, in response to dimension configuring request, database is currently allowed the first dimension collection that user uses be updated to
Two-dimensions set；
S3, the second dimension collection is replaced the first dimension collection is included on the query interface of database, so that user
Database is inquired about according to one or more of the second dimension collection dimension.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Match somebody with somebody obtaining dimension
Before putting request, the state for whole dimensions that data place is supported is arranged to configurable state, wherein, in configurable state
Dimension be used to be configured as the inquiry dimension that database do not allow currently user to use in response to the first configuration-direct, or be used for
The inquiry dimension that database currently allows user to use is configured as in response to the second configuration-direct.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Match somebody with somebody in response to first
Put instruction and the dimension in the first dimension collection is arranged to the inquiry dimension that database do not allow currently user to use, and in response to
Dimension in second dimension collection is arranged to the inquiry dimension that database currently allows user to use by the second configuration-direct.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Respond the letter of input
Breath generates same instruction；Respond same instruction and the value of the dimension configuration parameter of database be updated to second value from the first value,
Wherein, the first value is used to indicate the dimension in the first dimension collection, and second value is used to indicate the dimension in the second dimension collection, dimension
Degree configuration parameter, which is used for referred database, currently allows the inquiry dimension that user uses.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Respond web page access
Dimension in second dimension collection is loaded on the query interface of database by request, wherein, web access requests are used to ask
Access the query interface of database.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Pass through the stream of data
Water number is judged in data source data storehouse with the presence or absence of newly-increased data；, will when there are newly-increased data in data source data storehouse
Newly-increased data are imported in Information Repository database.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：Match somebody with somebody obtaining dimension
Before putting request, the data in data source database are abstracted, obtain multiple abstractions, wherein, multiple abstractions include：
First abstraction, the second abstraction, the 3rd abstraction and the 4th abstraction, the first abstraction are used in data source database
Data source table is configured, the second abstraction be used for business interface is configured, the 3rd abstraction be used for data source is arranged into
Row configuration, the field that the 4th abstraction is used to take business interface configure.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps：By the second dimension
Before or after set the first dimension collection of replacement is shown on the query interface of database, the data query of active user is received
Request；Whether judgement currently has historical user to be transparent to data base querying data；If currently there is historical user to be transparent to data
Library inquiry data, then do not allow active user to be transparent to data base querying data.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2
Example, details are not described herein for the present embodiment.
Alternatively, in the present embodiment, above-mentioned storage medium can include but is not limited to：USB flash disk, read-only storage (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disc or
CD etc. is various can be with the medium of store program codes.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
If the integrated unit in above-described embodiment is realized in the form of SFU software functional unit and is used as independent product
Sale or in use, the storage medium that above computer can be read can be stored in.Based on such understanding, skill of the invention
The part or all or part of the technical solution that art scheme substantially in other words contributes the prior art can be with soft
The form of part product embodies, which is stored in storage medium, including some instructions are used so that one
Platform or multiple stage computers equipment (can be personal computer, server or network equipment etc.) perform each embodiment institute of the present invention
State all or part of step of method.
In the above embodiment of the present invention, the description to each embodiment all emphasizes particularly on different fields, and does not have in some embodiment
The part of detailed description, may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed client, can be by others side
Formula is realized.Wherein, device embodiment described above is only schematical, such as the division of the unit, is only one
Kind of division of logic function, can there is an other dividing mode when actually realizing, for example, multiple units or component can combine or
Another system is desirably integrated into, or some features can be ignored, or do not perform.It is another, it is shown or discussed it is mutual it
Between coupling, direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
Connect, can be electrical or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
In network unit.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, can also be realized in the form of SFU software functional unit.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (18)
- A kind of 1. collocation method of the inquiry dimension of database, it is characterised in that including：Dimension configuring request is obtained, wherein, the dimension configuring request is used to ask currently to allow database into what user used First dimension collection is updated to the second dimension collection；In response to the dimension configuring request, first dimension collection that the database currently allows user to use is updated For second dimension collection；Second dimension collection is replaced first dimension collection is included on the query interface of the database, so that User inquires about the database according to one or more of second dimension collection dimension.
- 2. according to the method described in claim 1, it is characterized in that, before the acquisition dimension configuring request, further include：The state for whole dimensions that the data place is supported is arranged to configurable state, wherein, in the configurable shape The dimension of state is used for the inquiry dimension for being configured as the database in response to the first configuration-direct and not allowing currently user to use, Or for being configured as the inquiry dimension that the database currently allows user to use in response to the second configuration-direct.
- 3. according to the method described in claim 2, it is characterized in that, the database is currently allowed that user uses described Dimension set, which is updated to second dimension collection, to be included：The dimension in first dimension collection is arranged to the database in response to first configuration-direct not permit currently The inquiry dimension that family allowable uses, and be arranged to the dimension in second dimension collection in response to second configuration-direct The database currently allows the inquiry dimension that user uses.
- 4. according to the method described in claim 2, it is characterized in that, first configuration-direct is with second configuration-direct Same instruction, wherein, first dimension collection that the database currently allows user to use is updated to second dimension Degree set includes：The information of response input generates the same instruction；Respond the same instruction and the value of the dimension configuration parameter of the database is updated to second value from the first value, its In, first value is used to indicate the dimension in first dimension collection, and the second value is used to indicate second dimension Dimension in set, the dimension configuration parameter are used to indicate the inquiry dimension that the database currently allows user to use.
- 5. according to the method described in claim 2, it is characterized in that, described replace first dimension by second dimension collection Degree set, which is shown on the query interface of the database, to be included：Dimension in second dimension collection is loaded on the query interface of the database by response web access requests, its In, the web access requests are used to ask the query interface for accessing the database.
- 6. method according to any one of claim 1 to 5, it is characterised in that the dimension in first dimension collection Relation between the dimension in second dimension collection includes at least one following：First dimension collection includes second dimension collection；Second dimension collection includes first dimension collection；There are intersection with second dimension collection for first dimension collection；First dimension collection does not have intersection with second dimension collection.
- 7. according to the method described in claim 1, it is characterized in that, before dimension configuring request is obtained, the method is also wrapped Include：Judged by the serial number of data in data source data storehouse with the presence or absence of newly-increased data；There are during the newly-increased data in the data source data storehouse, the newly-increased data are imported into Information Repository database In.
- 8. according to the method described in claim 1, it is characterized in that, before dimension configuring request is obtained, the method is also wrapped Include：Data in data source database are abstracted, obtain multiple abstractions, wherein, the multiple abstraction includes：The One abstraction, the second abstraction, the 3rd abstraction and the 4th abstraction, first abstraction are used for the data source data Data source table in storehouse is configured, and second abstraction is used to configure business interface, and the 3rd abstraction is used Configured in data source row, the field that the 4th abstraction is used to take business interface configures.
- 9. according to the method described in claim 1, it is characterized in that, second dimension collection is being replaced into first dimension Before or after set is shown on the query interface of the database, the method further includes：Receive the data inquiry request of active user；Whether judgement currently has historical user to be transparent to the data base querying data；If currently there is historical user to be transparent to the data base querying data, the active user is not allowed to be transparent to described Data base querying data.
- A kind of 10. configuration device of the inquiry dimension of database, it is characterised in that including：First acquisition unit, for obtaining dimension configuring request, wherein, the dimension configuring request is used to ask to work as database Preceding the first dimension collection for allowing user to use is updated to the second dimension collection；Updating block, in response to the dimension configuring request, the database is currently allowed that user uses described Dimension set is updated to second dimension collection；Display unit, includes the inquiry in the database for second dimension collection to be replaced first dimension collection On interface, so that user inquires about the database according to one or more of second dimension collection dimension.
- 11. device according to claim 10, it is characterised in that described device further includes：Setting unit, for it is described acquisition dimension configuring request before, by the data place support whole dimensions shape State is arranged to configurable state, wherein, the dimension in the configurable state is used to be configured in response to the first configuration-direct The inquiry dimension for not allowing currently user to use for the database, or it is described for being configured as in response to the second configuration-direct Database currently allows the inquiry dimension that user uses.
- 12. according to the devices described in claim 11, it is characterised in that the updating block is used for：The dimension in first dimension collection is arranged to the database in response to first configuration-direct not permit currently The inquiry dimension that family allowable uses, and be arranged to the dimension in second dimension collection in response to second configuration-direct The database currently allows the inquiry dimension that user uses.
- 13. according to the devices described in claim 11, it is characterised in that first configuration-direct and second configuration-direct For same instruction, wherein, the updating block includes：Generation module, the information for responding input generate the same instruction；Update module, updates the value of the dimension configuration parameter of the database from the first value for responding the same instruction For second value, wherein, first value is used to indicate the dimension in first dimension collection, and the second value is used to indicate institute State the dimension in the second dimension collection, the dimension configuration parameter is used to indicating that the database currently to allow what user used to look into Ask dimension.
- 14. according to the devices described in claim 11, it is characterised in that the display unit is used for：Dimension in second dimension collection is loaded on the query interface of the database by response web access requests, its In, the web access requests are used to ask the query interface for accessing the database.
- 15. the device according to any one of claim 10 to 14, it is characterised in that the dimension in first dimension collection The relation between dimension in degree and second dimension collection includes at least one following：First dimension collection includes second dimension collection；Second dimension collection includes first dimension collection；There are intersection with second dimension collection for first dimension collection；First dimension collection does not have intersection with second dimension collection.
- 16. device according to claim 10, it is characterised in that described device further includes：Second acquisition unit, for before dimension configuring request is obtained, judging data source data storehouse by the serial number of data In with the presence or absence of newly-increased data；The newly-increased data there are during the newly-increased data in the data source data storehouse, are imported money by import unit Expect in library database.
- 17. device according to claim 10, it is characterised in that described device further includes：Processing unit, for before dimension configuring request is obtained, being abstracted, obtaining more to the data in data source database A abstraction, wherein, the multiple abstraction includes：First abstraction, the second abstraction, the 3rd abstraction and the 4th are abstract Body, first abstraction are used to configure the Data source table in the data source data storehouse, and second abstraction is used Configured in business interface, the 3rd abstraction is used to configure data source row, and the 4th abstraction is used for The field taken to business interface configures.
- 18. device according to claim 10, it is characterised in that described device further includes：Receiving unit, for second dimension collection replacement, first dimension collection to be included looking into the database Before or after asking on interface, the data inquiry request of active user is received；Judging unit, for judging currently whether there is historical user to be transparent to the data base querying data；Control unit, for when currently thering is historical user to be transparent to the data base querying data, not allowing the current use Family is transparent to the data base querying data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610971433.0A CN108021589B (en) | 2016-10-31 | 2016-10-31 | Configuration method and device for query dimension of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610971433.0A CN108021589B (en) | 2016-10-31 | 2016-10-31 | Configuration method and device for query dimension of database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108021589A true CN108021589A (en) | 2018-05-11 |
| CN108021589B CN108021589B (en) | 2020-08-04 |
Family
ID=62084644
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610971433.0A Active CN108021589B (en) | 2016-10-31 | 2016-10-31 | Configuration method and device for query dimension of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108021589B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109492138A (en) * | 2018-10-22 | 2019-03-19 | 中国银行股份有限公司 | A kind of data query processing method and system |
| CN110968788A (en) * | 2019-12-03 | 2020-04-07 | 重庆肯库数据科技有限公司 | Method, device and system for screening race resources, computer equipment and storage medium |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063469A (en) * | 2010-12-03 | 2011-05-18 | 百度在线网络技术（北京）有限公司 | Method and device for acquiring relevant keyword message and computer equipment |
| CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
| US8909680B1 (en) * | 2011-10-08 | 2014-12-09 | Bay Dynamics | Intelligent caching of multidimensional cube data |
| CN105488231A (en) * | 2016-01-22 | 2016-04-13 | 杭州电子科技大学 | Self-adaption table dimension division based big data processing method |
-
2016
- 2016-10-31 CN CN201610971433.0A patent/CN108021589B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063469A (en) * | 2010-12-03 | 2011-05-18 | 百度在线网络技术（北京）有限公司 | Method and device for acquiring relevant keyword message and computer equipment |
| US8909680B1 (en) * | 2011-10-08 | 2014-12-09 | Bay Dynamics | Intelligent caching of multidimensional cube data |
| CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
| CN105488231A (en) * | 2016-01-22 | 2016-04-13 | 杭州电子科技大学 | Self-adaption table dimension division based big data processing method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109492138A (en) * | 2018-10-22 | 2019-03-19 | 中国银行股份有限公司 | A kind of data query processing method and system |
| CN110968788A (en) * | 2019-12-03 | 2020-04-07 | 重庆肯库数据科技有限公司 | Method, device and system for screening race resources, computer equipment and storage medium |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108021589B (en) | 2020-08-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106294614B (en) | Method and apparatus for accessing business | |
| CN104572122B (en) | A kind of generating means and method of software application data | |
| CN105338026B (en) | The acquisition methods of data resource, device and system | |
| CN107623714A (en) | Data sharing method, device and computer-readable recording medium | |
| CN107273436A (en) | The training method and trainer of a kind of recommended models | |
| CN107589952A (en) | Intelligent upgrade method, device and system | |
| CN106651097A (en) | Data collection method, data collection device and data collection server based on crowd sourcing | |
| CN108241799B (en) | Cross-system access method, system, device and computer readable storage medium | |
| CN107317724A (en) | Data collecting system and method based on cloud computing technology | |
| CN106021463A (en) | Method for providing intelligent services on basis of artificial intelligence, intelligent service system and intelligent terminal | |
| CN103842961A (en) | System for creating personalized and customized mobile devices | |
| CN109445949A (en) | A kind of data collection system and collecting method | |
| CN108959633A (en) | It is a kind of that the method and apparatus of customer service are provided | |
| CN109656963A (en) | Metadata acquisition methods, device, equipment and computer readable storage medium | |
| CN109684530A (en) | Information Push Service system based on web-based management and the application of mobile phone small routine | |
| CN109033277A (en) | Class brain system, method, equipment and storage medium based on machine learning | |
| CN110162292A (en) | Voice broadcast method and device | |
| CN109118353A (en) | The data processing method and device of air control model | |
| CN108021589A (en) | The collocation method and device of the inquiry dimension of database | |
| CN109063122A (en) | A kind of information synchronization method, related system and the equipment of ERP system and MES system | |
| CN106777368A (en) | Data base query language adaptation method and device, distributed data-storage system | |
| CN110276074A (en) | Distributed training method, device, equipment and the storage medium of natural language processing | |
| CN110148033A (en) | Product automatic get-on carriage method, apparatus, equipment and storage medium | |
| CN110196936A (en) | Search method, device and the storage medium and electronic device of project | |
| CN109522919A (en) | A kind of data assessment 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |