CN110019544A - Data query method and system - Google Patents
Data query method and system Download PDFInfo
- Publication number
- CN110019544A CN110019544A CN201710938359.7A CN201710938359A CN110019544A CN 110019544 A CN110019544 A CN 110019544A CN 201710938359 A CN201710938359 A CN 201710938359A CN 110019544 A CN110019544 A CN 110019544A
- Authority
- CN
- China
- Prior art keywords
- inquiry
- data
- dimension
- instruction
- query
- 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/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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data query methods, comprising: receives the inquiry instruction of user's input, includes at least one inquiry dimension in the inquiry instruction；In data-base cluster to be checked, the corresponding data set of each inquiry dimension is inquired respectively, includes at least one database in the data-base cluster to be checked；The each data set obtained according to the dimensional relationships between each inquiry dimension to inquiry is integrated, to determine inquiry data corresponding with the inquiry instruction.Data query method provided by the invention, user inputs one query instruction, each inquiry dimension in inquiry instruction can be inquired respectively in data-base cluster to be checked, obtain inquiry data corresponding with the inquiry instruction, it does not need for disparate databases that input inquiry language is inquired respectively, improves the efficiency to data query.
Description
Technical field
The present invention relates to technical field of data processing, in particular to a kind of data query method, system, storage medium and
Processor.
Background technique
With the development of Information technology, in different industries, a large amount of data can be all generated all the time, to be formed
It is general be stored in the mass data of generation in pre-established database to the storage performance demand of mass data.And with
The development of every profession and trade information system, and produce the demand inquired mass data.It is existing to data in database
Query process inquires the data stored in database using scripting language corresponding with database is write.Due to difference
The data structure of database has differences, therefore used query language during data query, and there is also differences.
Since the query language that disparate databases use is different, user needs when carrying out data query to different data
Constantly switching inputs different query languages, causes the efficiency of data query lower.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
A kind of data query method of problem is stated, specific scheme is as follows:
A kind of data query method, comprising:
The inquiry instruction of user's input is received, includes at least one inquiry dimension in the inquiry instruction；
In data-base cluster to be checked, the corresponding data set of each inquiry dimension, the data to be checked are inquired respectively
It include at least one database in the cluster of library；
The each data set obtained according to the dimensional relationships between each inquiry dimension to inquiry is integrated, with true
Fixed inquiry data corresponding with the inquiry instruction.
Above-mentioned method, it is preferred that it is described in data-base cluster to be checked, it is corresponding that each inquiry dimension is inquired respectively
Data set includes:
The each inquiry dimension for including in the inquiry instruction is split；
Determine the target database of each inquiry dimension required inquiry in the data-base cluster to be checked split out；
It is script querying condition corresponding with the target database of inquiry needed for it, and foundation by each inquiry dimension transformation
The script querying condition inquires data set corresponding with the inquiry dimension in the target database.
Above-mentioned method, it is preferred that it is described to each inquiry dimension for including in the inquiry instruction carry out split include:
Traverse each dimension mark for including in the inquiry instruction；
It is determining that there are the dimension texts of incidence relation with each dimension mark；
Using each dimension text as the inquiry dimension in the inquiry instruction.
Above-mentioned method, it is preferred that described by each inquiry dimension transformation is target database pair with inquiry needed for it
The script querying condition answered includes:
Obtain the corresponding script table of comparisons of the target database；
Determine the query language in the script table of comparisons；
It is script querying condition corresponding with the query language by the inquiry dimension transformation.
Above-mentioned method, it is preferred that further include:
The inquiry instruction and the inquiry data are stored into preset command mappings table.
A kind of data query system, comprising:
Receiving unit includes at least one inquiry dimension in the inquiry instruction for receiving the inquiry instruction of user's input
Degree；
Query unit, for inquiring the corresponding data set of each inquiry dimension, institute respectively in data-base cluster to be checked
It states in data-base cluster to be checked comprising at least one database；
Integral unit, each data set for being obtained according to the dimensional relationships between each inquiry dimension to inquiry
It is integrated, to determine inquiry data corresponding with the inquiry instruction.
Above-mentioned system, it is preferred that the query unit includes:
Subelement is split, for splitting to each inquiry dimension for including in the inquiry instruction；
Subelement is determined, for looking into needed for determining each inquiry dimension split out in the data-base cluster to be checked
The target database of inquiry；
Subelement is inquired, for being script corresponding with the target database of inquiry needed for it by each inquiry dimension transformation
Querying condition, and according to the script querying condition, number corresponding with the inquiry dimension is inquired in the target database
According to collection.
Above-mentioned system, it is preferred that further include:
Storage unit, for storing the inquiry instruction and the inquiry data into preset command mappings table.
A kind of storage medium, the storage medium include the program of storage, wherein described program executes above-mentioned data and looks into
Inquiry method.
A kind of processor, the processor is for running program, wherein described program executes above-mentioned data when running and looks into
Inquiry method.
By above-mentioned technical proposal, a kind of data query method provided by the invention, comprising: receive the inquiry of user's input
It instructs, at least one inquiry dimension is included in the inquiry instruction；In data-base cluster to be checked, each inquiry is inquired respectively
The corresponding data set of dimension includes at least one database in the data-base cluster to be checked；It is tieed up according to each inquiry
Each data set that dimensional relationships between degree obtain inquiry is integrated, to determine inquiry corresponding with the inquiry instruction
Data.Data query method provided by the invention, user only input one query instruction when needing to inquire data,
It is corresponding can to inquire each inquiry dimension in the inquiry instruction in each database in data-base cluster to be checked
Data set, do not need to input different query languages for disparate databases, improve search efficiency.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows a kind of data query method flow diagram disclosed in the embodiment of the present application；
Fig. 2 shows a kind of another method flow diagrams of data query method disclosed in the embodiment of the present application；
Fig. 3 shows a kind of another method flow diagram of data query method disclosed in the embodiment of the present application；
Fig. 4 shows a kind of another method flow diagram of data query method disclosed in the embodiment of the present application；
Fig. 5 has gone out a kind of data query system structural block diagram disclosed in the embodiment of the present application；
Fig. 6 has gone out a kind of another structural block diagram of data query system disclosed in the embodiment of the present application.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
The foregoing description of the disclosed embodiments enables those skilled in the art to implement or use the present invention.
Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the invention
It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one
The widest scope of cause.
The present invention provides a kind of data query methods, are applied to user terminal, can be the processor of user terminal, use
It is inquired in the data needed in the database to user, the method flow diagram of the data query method is as shown in Figure 1, packet
It includes:
S101: the inquiry instruction of user's input is received, includes at least one inquiry dimension in the inquiry instruction；
It is described to look into comprising at least one inquiry dimension in the inquiry instruction in data query method provided by the invention
Asking dimension can be text formatting, can be the combination of text, numerical value, letter, spcial character or above-mentioned several texts.
S102: in data-base cluster to be checked, inquiring the corresponding data set of each inquiry dimension respectively, described to be checked
It include at least one database in data-base cluster；
Data query method provided by the invention, user need the data inquired, and can be to be stored in same database
Data, or the data in disparate databases in same database platform, can also be in disparate databases platform
Disparate databases in data, each database where user is needed the data inquired in the present invention is referred to as to be checked
Data-base cluster.
S103: each data set that inquiry obtains is carried out according to the dimensional relationships between each inquiry dimension whole
It closes, to determine inquiry data corresponding with the inquiry instruction.
In data query method provided by the invention, there are certain dimensional relationships between each inquiry dimension, according to looking into
The dimensional relationships between dimension are ask, each data set obtained to inquiry is integrated, and is looked into the determination inquiry instruction needs
The data of inquiry.
Data query method provided by the invention, the data that user inquires needs, input inquiry instruction, so that it may
In each database in data-base cluster to be checked, the corresponding data of each inquiry dimension in the inquiry instruction are inquired
Collection does not need to input different query languages for disparate databases and inquired, improves search efficiency.
With reference to Fig. 2, show in data query method provided by the invention, it is described in data-base cluster to be checked, point
The detailed process of the corresponding data set of each inquiry dimension is not inquired, comprising:
S201: each inquiry dimension for including in the inquiry instruction is split；
In method provided by the invention, each inquiry dimension in inquiry instruction is combined according to certain dimensional relationships one
It rises, by preset fractionation rule in the present invention, each inquiry dimension in the inquiry instruction received is split.
S202: the number of targets of each inquiry dimension required inquiry in the data-base cluster to be checked split out is determined
According to library；
In method provided by the invention, the corresponding data of each inquiry dimension be can store in different databases, this
In invention, the data inquired required for each inquiry dimension are determined, in which database specifically stored, by the database
Target database as the inquiry dimension.
S203: being script querying condition corresponding with the target database of inquiry needed for it by each inquiry dimension transformation,
And according to the script querying condition, data set corresponding with the inquiry dimension is inquired in the target database.
In method provided by the invention, each target database is corresponding with the query language of their own, will in the present invention
The inquiry dimension for carrying out data query is converted into the scripting language that corresponding target database can identify, according to the foot
The data that this querying condition directly can inquire needs in target database are inquired.
It is right for each inquiry dimension in the inquiry instruction of user's input in data query method provided by the invention
The data are converted into after the database that the inquiry dimension is inquired has been determined in each inquiry dimension
The script querying condition that library can identify is inquired.That is, it is corresponding to be converted to database for the inquiry dimension in inquiry instruction
Scripting language is inquired.For a user, user only needs to input one query instruction, does not need in different numbers
Inquiry is switched over according to different query languages is inputted between library, improves the efficiency of data query.
It is described that each inquiry dimension for including in the inquiry instruction is carried out in data query method provided by the invention
Fractionation includes:
Traverse each dimension mark for including in the inquiry instruction；
It is determining that there are the dimension texts of incidence relation with each dimension mark；
Using each dimension text as the inquiry dimension in the inquiry instruction.
In data query method provided by the invention, for each inquiry dimension in inquiry instruction, such as user can be with
Input, region=Beijing and time=2017and case type=criminal case, the inquiry instruction indicate: user query Beijing
Area, in the file data of criminal case in 2017, when being inquired using data query method provided by the invention, ground
Domain=Beijing is an inquiry dimension in the inquiry instruction, it is of the invention in, " and " conduct in inquiry instruction can be found
Mark is split, according to certain fractionation rule, each inquiry dimension is splitted out, can also be found all in inquiry instruction
"=" splits the text on "=" both sides in conjunction with "=".
Data query method provided by the invention can be used according to the character component relationship between each inquiry dimension
Different fractionation rules.
It with reference to Fig. 3, shows in the present invention, described by each inquiry dimension transformation is target data with inquiry needed for it
The detailed process of the corresponding script querying condition in library, comprising:
S301: the corresponding script table of comparisons of the target database is obtained；
S302: the query language in the script table of comparisons is determined；
S303: being script querying condition corresponding with the query language by the inquiry dimension transformation.
In data query method provided by the invention, different databases corresponds to its respective script table of comparisons, the script
Recording in the table of comparisons has the query language inquired and should used in the database, in the present invention, gets the corresponding foot of database
After this table of comparisons, dimension will be inquired and switch to the querying condition that the query language of the database is write.
Data query method provided by the invention can be applied to be put down by the database that centralized database storage mode is established
Platform also can be applied to the database platform established using multiple database purchase modes, more when existing in the Data Query Platform
When the database of seed type, the inquiry instruction is converted into script querying condition corresponding with currently database to be checked
Script converter is there is also multiple, in order to avoid conflict, it is preferred that can be each of Data Query Platform data
Different distinguishing identifiers is established in library, carries distinguishing identifier in input inquiry instruction, and the distinguishing identifier is distributed to and is worked as
The corresponding script converter of preceding database to be checked, the area of database converter corresponding with the database is carried out with distinguishing identifier
Point.
Data query method provided by the invention can obtain each inquiry dimension in the inquiry instruction, so first
Each inquiry dimension is respectively converted into script querying condition corresponding with currently database to be checked afterwards.Can also first by
The inquiry instruction is converted to script querying condition corresponding with the current database to be checked, then obtains script inquiry item
Each inquiry dimension is respectively converted into script corresponding with currently database to be checked by each inquiry dimension in part
Querying condition.
In data query method provided by the invention, during being integrated to each data set of acquisition, Ke Yiyi
According to the dimensional relationships, the priority orders of each data set are determined；And the sequence according to the priority, phase will be present
The data set of adjacent relationship is successively integrated.
In data query method provided by the invention, the method is applied to the Data Query Platform pre-established, this hair
The bright middle each data set that will be inquired in each database, is integrated into the Data Query Platform in the present invention, described
In Data Query Platform, according to the dimensional relationships between each inquiry dimension, each data set obtained to inquiry is integrated.
In data query method provided by the invention, it is corresponding that the priority orders of each data set depend on dimensional relationships
Dimension mark.There are dimensional relationships between each inquiry dimension, the dimensional relationships are depended between each inquiry dimension
Dimension mark, the sequence of the priority specified by user, is depended in actual conditions and the current database to be checked
The amount of storage of data.
In the embodiment of the present invention, dimension mark can be various for " ", " | | ", " and ", " or ", "and", "or" etc.
One of dimension mark or several combinations.
It, can also will be described each after determining corresponding with inquiry instruction inquiry data in the embodiment of the present invention
The original order of inquiry dimension each inquiry dimension corresponding with the inquiry instruction is mapped, according to described original suitable
Sequence determines inquiry data corresponding with the inquiry instruction.
In the embodiment of the present invention, the inquiry instruction and the inquiry data can be stored to preset command mappings table
In.When occurring inquiry request identical with the inquiry instruction again, directly transfers the inquiry data and shown.
An instantiation figure of data query method provided by the invention is shown with reference to Fig. 4, to adjudicate in judicial domain
It is illustrated for the search procedure of book, in case inquiry database, if the inquiry instruction includes " region=Beijing and
Time=2017and type=criminal case ".Include three inquiry dimensions in the inquiry instruction, be " region=Beijing ",
" time=2017 ", " type=criminal case ", user want the data of inquiry Beijing area all criminal cases in 2017.
When being inquired using data query method provided by the invention, above three inquiry dimension is torn open first
Point, then determine that each data to be inquired of inquiry dimension specifically in which database, are inquired such as above three and tieed up respectively
Degree is stored in the same database, in the query language for determining that the database uses, by above three inquiry dimension point
The querying condition that the query language of the database is write is not converted to, is inquired, each data for then obtaining inquiry
Collection carries out the operation that seeks common ground in the front end of searching platform, obtains the corresponding inquiry data of the inquiry instruction.
If inquiry dimension " region=Beijing " data to be inquired are stored in database A, inquiry dimension " time=
2017 " and " type=criminal case ", be stored in database B, then by region=Beijing " be converted to the corresponding foot of database A
This query language, is inquired in database A, and " time=2017 " and " type=criminal case " are respectively converted into data
The corresponding script query language of library B, and inquired in database B respectively, each data set that will be inquired, it is flat in inquiry
Platform front end carries out the operation that seeks common ground, and obtains the corresponding inquiry data of the inquiry instruction.
Corresponding with above-mentioned querying method, the present invention also provides a kind of data query system, structural schematic diagrams
As shown in Figure 5, comprising:
Receiving unit 401 includes at least one inquiry in the inquiry instruction for receiving the inquiry instruction of user's input
Dimension；
Query unit 402, for inquiring the corresponding data of each inquiry dimension respectively in data-base cluster to be checked
Collect, includes at least one database in the data-base cluster to be checked；
Integral unit 403, each number for being obtained according to the dimensional relationships between each inquiry dimension to inquiry
It is integrated according to collection, to determine inquiry data corresponding with the inquiry instruction.
Data query system provided by the invention, user only input one query and refer to when needing to inquire data
It enables, so that it may in each database in data-base cluster to be checked, inquire each inquiry dimension in the inquiry instruction
Corresponding data set does not need to input different query languages for disparate databases, improves search efficiency.
On the basis of Fig. 5, with reference to Fig. 6, the another structural schematic diagram of inquiry system provided by the invention is shown, it is described
Query unit 402 includes:
Subelement 404 is split, for splitting to each inquiry dimension for including in the inquiry instruction；
Subelement 405 is determined, for determining each inquiry dimension split out institute in the data-base cluster to be checked
The target database that need to be inquired；
Subelement 406 is inquired, for being corresponding with the target database of inquiry needed for it by each inquiry dimension transformation
Script querying condition, and according to the script querying condition, it is inquired in the target database corresponding with the inquiry dimension
Data set.
In system provided by the invention, further includes:
Storage unit 407, for storing the inquiry instruction and the inquiry data into preset command mappings table.
The data query system includes processor and memory, and above-mentioned receiving unit, integral unit, is torn open at query unit
Molecular cell, determine subelement, inquiry subelement, storage unit etc. as program unit storage in memory, by handling
Device executes above procedure unit stored in memory to realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, search efficiency is improved by adjusting kernel parameter.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, if read-only memory (ROM) or flash memory (flash RAM), memory include that at least one is deposited
Store up chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor
The existing data query method.
The embodiment of the invention provides a kind of processor, the processor is for running program, wherein described program operation
Data query method described in Shi Zhihang.
The embodiment of the invention provides a kind of equipment, equipment include processor, memory and storage on a memory and can
The program run on a processor, processor perform the steps of when executing program
A kind of data query method, comprising:
The inquiry instruction of user's input is received, includes at least one inquiry dimension in the inquiry instruction；
In data-base cluster to be checked, the corresponding data set of each inquiry dimension, the data to be checked are inquired respectively
It include at least one database in the cluster of library；
The each data set obtained according to the dimensional relationships between each inquiry dimension to inquiry is integrated, with true
Fixed inquiry data corresponding with the inquiry instruction.
Above-mentioned method, it is described in data-base cluster to be checked, the corresponding data set of each inquiry dimension is inquired respectively
Include:
The each inquiry dimension for including in the inquiry instruction is split；
Determine the target database of each inquiry dimension required inquiry in the data-base cluster to be checked split out；
It is script querying condition corresponding with the target database of inquiry needed for it, and foundation by each inquiry dimension transformation
The script querying condition inquires data set corresponding with the inquiry dimension in the target database.
Above-mentioned method, it is described to each inquiry dimension for including in the inquiry instruction carry out split include:
Traverse each dimension mark for including in the inquiry instruction；
It is determining that there are the dimension texts of incidence relation with each dimension mark；
Using each dimension text as the inquiry dimension in the inquiry instruction.
Above-mentioned method, it is described by each inquiry dimension transformation be script corresponding with the target database of inquiry needed for it
Querying condition includes:
Obtain the corresponding script table of comparisons of the target database；
Determine the query language in the script table of comparisons；
It is script querying condition corresponding with the query language by the inquiry dimension transformation.
Above-mentioned method, further includes:
The inquiry instruction and the inquiry data are stored into preset command mappings table.
Equipment herein can be server, PC, PAD, mobile phone etc..
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
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 instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (10)
1. a kind of data query method characterized by comprising
The inquiry instruction of user's input is received, includes at least one inquiry dimension in the inquiry instruction；
In data-base cluster to be checked, the corresponding data set of each inquiry dimension, the data base set to be checked are inquired respectively
It include at least one database in group；
The obtained each data set of inquiry is integrated according to the dimensional relationships between each inquiry dimension, with determine with
The corresponding inquiry data of the inquiry instruction.
2. inquiry is each respectively the method according to claim 1, wherein described in data-base cluster to be checked
The corresponding data set of a inquiry dimension includes:
The each inquiry dimension for including in the inquiry instruction is split；
Determine the target database of each inquiry dimension required inquiry in the data-base cluster to be checked split out；
It is script querying condition corresponding with the target database of inquiry needed for it by each inquiry dimension transformation, and according to described
Script querying condition inquires data set corresponding with the inquiry dimension in the target database.
3. according to the method described in claim 2, it is characterized in that, described tie up each inquiry for including in the inquiry instruction
Degree split
Traverse each dimension mark for including in the inquiry instruction；
It is determining that there are the dimension texts of incidence relation with each dimension mark；
Using each dimension text as the inquiry dimension in the inquiry instruction.
4. according to the method described in claim 2, it is characterized in that, described be and inquiry needed for it by each inquiry dimension transformation
The corresponding script querying condition of target database include:
Obtain the corresponding script table of comparisons of the target database；
Determine the query language in the script table of comparisons；
It is script querying condition corresponding with the query language by the inquiry dimension transformation.
5. the method according to claim 1, wherein further include:
The inquiry instruction and the inquiry data are stored into preset command mappings table.
6. a kind of data query system characterized by comprising
Receiving unit includes at least one inquiry dimension in the inquiry instruction for receiving the inquiry instruction of user's input；
Query unit inquires the corresponding data set of each inquiry dimension in data-base cluster to be checked respectively, it is described to
Inquiring includes at least one database in data-base cluster；
Integral unit, for being carried out according to the dimensional relationships between each inquiry dimension to each data set that inquiry obtains
Integration, to determine inquiry data corresponding with the inquiry instruction.
7. system according to claim 6, which is characterized in that the query unit includes:
Subelement is split, for splitting to each inquiry dimension for including in the inquiry instruction；
Subelement is determined, for determining each inquiry dimension required inquiry in the data-base cluster to be checked split out
Target database；
Subelement is inquired, for being script corresponding with the target database of inquiry needed for it inquiry by each inquiry dimension transformation
Condition, and according to the script querying condition, data set corresponding with the inquiry dimension is inquired in the target database.
8. system according to claim 6, which is characterized in that further include:
Storage unit, for storing the inquiry instruction and the inquiry data into preset command mappings table.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage, wherein described program right of execution
Benefit require any one of 1 to 5 described in data query method.
10. a kind of processor, which is characterized in that the processor is for running program, wherein right of execution when described program is run
Benefit require any one of 1 to 5 described in data query method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710938359.7A CN110019544B (en) | 2017-09-30 | 2017-09-30 | Data query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710938359.7A CN110019544B (en) | 2017-09-30 | 2017-09-30 | Data query method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019544A true CN110019544A (en) | 2019-07-16 |
| CN110019544B CN110019544B (en) | 2022-08-19 |
Family
ID=67186508
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710938359.7A Active CN110019544B (en) | 2017-09-30 | 2017-09-30 | Data query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019544B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113127722A (en) * | 2019-12-31 | 2021-07-16 | 新奥数能科技有限公司 | Data query method and device, readable medium and electronic equipment |
| CN114267348A (en) * | 2021-11-16 | 2022-04-01 | 北京执象科技发展有限公司 | Man-machine collaborative teaching interaction method, system, equipment and storage medium |
Citations (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040122707A1 (en) * | 2002-12-18 | 2004-06-24 | Sabol John M. | Patient-driven medical data processing system and method |
| US20050192941A1 (en) * | 2004-02-27 | 2005-09-01 | Stefan Biedenstein | Fast aggregation of compressed data using full table scans |
| CN1687922A (en) * | 2005-05-30 | 2005-10-26 | 北京慧讯信息技术有限公司 | Distributed data source data integration system and method |
| US20080040317A1 (en) * | 2006-08-09 | 2008-02-14 | Dettinger Richard D | Decomposed query conditions |
| CN101149749A (en) * | 2007-10-29 | 2008-03-26 | 浙江大学 | Heterogeneous relational database data integration method based on meaning |
| CN101221578A (en) * | 2008-02-01 | 2008-07-16 | 中国建设银行股份有限公司 | Data screening method and device, and securitization loan screening method and device |
| US7546312B1 (en) * | 2005-09-23 | 2009-06-09 | Emc Corporation | System and methods for modeling a report query database |
| US20090222476A1 (en) * | 2008-02-29 | 2009-09-03 | Williamson Eric J | Pyramid reporting tool |
| US20090228430A1 (en) * | 2008-03-05 | 2009-09-10 | Microsoft Corporation | Multidimensional data cubes with high-cardinality attributes |
| US20090249125A1 (en) * | 2008-04-01 | 2009-10-01 | Microsoft Corporation | Database querying |
| CN101599087A (en) * | 2009-07-02 | 2009-12-09 | 金蝶软件（中国）有限公司 | Data enquire method and device |
| US7657503B1 (en) * | 2005-11-29 | 2010-02-02 | At&T Corp. | System and method for generating statistical descriptors for a data stream |
| CN101916261A (en) * | 2010-07-28 | 2010-12-15 | 北京播思软件技术有限公司 | Data partitioning method for distributed parallel database system |
| CN102184257A (en) * | 2011-06-02 | 2011-09-14 | 广东亿迅科技有限公司 | Unified searching method, device and system |
| CN102207940A (en) * | 2010-03-31 | 2011-10-05 | 国际商业机器公司 | Method and system for checking data |
| CN102999526A (en) * | 2011-09-16 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Splitting and inquiring method and system of database relational table |
| CN103399923A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data result dynamic thematic map generating system and method |
| CN103514201A (en) * | 2012-06-27 | 2014-01-15 | 阿里巴巴集团控股有限公司 | Method and device for querying data in non-relational database |
| CN103729448A (en) * | 2013-12-31 | 2014-04-16 | 深圳市科漫达智能管理科技有限公司 | Method and device for querying data |
| CN104182546A (en) * | 2014-09-09 | 2014-12-03 | 北京国双科技有限公司 | Method and device for querying data in databases |
| CN104392001A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | Database inquiry method and device |
| CN104408169A (en) * | 2014-12-09 | 2015-03-11 | 北京国双科技有限公司 | Multi-dimensional expression language based dimension query method and device |
| CN104462434A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data inquiring method and device |
| US9183272B1 (en) * | 2013-11-06 | 2015-11-10 | Dell Software Inc. | System and method for accessing dimensional databases |
| US20160188710A1 (en) * | 2014-12-29 | 2016-06-30 | Wipro Limited | METHOD AND SYSTEM FOR MIGRATING DATA TO NOT ONLY STRUCTURED QUERY LANGUAGE (NoSOL) DATABASE |
| CN105760380A (en) * | 2014-12-16 | 2016-07-13 | 华为技术有限公司 | Database query method, device and system |
| US20160253403A1 (en) * | 2015-02-27 | 2016-09-01 | Microsoft Technology Licensing, Llc | Object query model for analytics data access |
| CN106407244A (en) * | 2016-06-21 | 2017-02-15 | 平安科技（深圳）有限公司 | Multi-database-based data query method, system and apparatus |
| CN106570022A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Cross-data-source query method, apparatus and system |
-
2017
- 2017-09-30 CN CN201710938359.7A patent/CN110019544B/en active Active
Patent Citations (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040122707A1 (en) * | 2002-12-18 | 2004-06-24 | Sabol John M. | Patient-driven medical data processing system and method |
| US20050192941A1 (en) * | 2004-02-27 | 2005-09-01 | Stefan Biedenstein | Fast aggregation of compressed data using full table scans |
| CN1687922A (en) * | 2005-05-30 | 2005-10-26 | 北京慧讯信息技术有限公司 | Distributed data source data integration system and method |
| US7546312B1 (en) * | 2005-09-23 | 2009-06-09 | Emc Corporation | System and methods for modeling a report query database |
| US7657503B1 (en) * | 2005-11-29 | 2010-02-02 | At&T Corp. | System and method for generating statistical descriptors for a data stream |
| US20080040317A1 (en) * | 2006-08-09 | 2008-02-14 | Dettinger Richard D | Decomposed query conditions |
| CN101149749A (en) * | 2007-10-29 | 2008-03-26 | 浙江大学 | Heterogeneous relational database data integration method based on meaning |
| CN101221578A (en) * | 2008-02-01 | 2008-07-16 | 中国建设银行股份有限公司 | Data screening method and device, and securitization loan screening method and device |
| US20090222476A1 (en) * | 2008-02-29 | 2009-09-03 | Williamson Eric J | Pyramid reporting tool |
| US20090228430A1 (en) * | 2008-03-05 | 2009-09-10 | Microsoft Corporation | Multidimensional data cubes with high-cardinality attributes |
| US20090249125A1 (en) * | 2008-04-01 | 2009-10-01 | Microsoft Corporation | Database querying |
| CN101599087A (en) * | 2009-07-02 | 2009-12-09 | 金蝶软件（中国）有限公司 | Data enquire method and device |
| CN102207940A (en) * | 2010-03-31 | 2011-10-05 | 国际商业机器公司 | Method and system for checking data |
| CN101916261A (en) * | 2010-07-28 | 2010-12-15 | 北京播思软件技术有限公司 | Data partitioning method for distributed parallel database system |
| CN102184257A (en) * | 2011-06-02 | 2011-09-14 | 广东亿迅科技有限公司 | Unified searching method, device and system |
| CN102999526A (en) * | 2011-09-16 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Splitting and inquiring method and system of database relational table |
| CN103514201A (en) * | 2012-06-27 | 2014-01-15 | 阿里巴巴集团控股有限公司 | Method and device for querying data in non-relational database |
| CN103399923A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data result dynamic thematic map generating system and method |
| US9183272B1 (en) * | 2013-11-06 | 2015-11-10 | Dell Software Inc. | System and method for accessing dimensional databases |
| CN103729448A (en) * | 2013-12-31 | 2014-04-16 | 深圳市科漫达智能管理科技有限公司 | Method and device for querying data |
| CN104182546A (en) * | 2014-09-09 | 2014-12-03 | 北京国双科技有限公司 | Method and device for querying data in databases |
| CN104408169A (en) * | 2014-12-09 | 2015-03-11 | 北京国双科技有限公司 | Multi-dimensional expression language based dimension query method and device |
| CN104462434A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data inquiring method and device |
| CN104392001A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | Database inquiry method and device |
| CN105760380A (en) * | 2014-12-16 | 2016-07-13 | 华为技术有限公司 | Database query method, device and system |
| US20160188710A1 (en) * | 2014-12-29 | 2016-06-30 | Wipro Limited | METHOD AND SYSTEM FOR MIGRATING DATA TO NOT ONLY STRUCTURED QUERY LANGUAGE (NoSOL) DATABASE |
| US20160253403A1 (en) * | 2015-02-27 | 2016-09-01 | Microsoft Technology Licensing, Llc | Object query model for analytics data access |
| CN106570022A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Cross-data-source query method, apparatus and system |
| CN106407244A (en) * | 2016-06-21 | 2017-02-15 | 平安科技（深圳）有限公司 | Multi-database-based data query method, system and apparatus |
Non-Patent Citations (1)
| Title |
|---|
| 高文浩: "基于本体的异构数据库集成技术研究与应用", 《中国优秀硕士学位论文全文数据库 信息科技辑（月刊 ）》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113127722A (en) * | 2019-12-31 | 2021-07-16 | 新奥数能科技有限公司 | Data query method and device, readable medium and electronic equipment |
| CN114267348A (en) * | 2021-11-16 | 2022-04-01 | 北京执象科技发展有限公司 | Man-machine collaborative teaching interaction method, system, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019544B (en) | 2022-08-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108664812A (en) | Information desensitization method, apparatus and system | |
| CN109658238A (en) | Data processing method and device | |
| CN106407207B (en) | Real-time newly-added data updating method and device | |
| CN113297396B (en) | Method, device and equipment for updating model parameters based on federal learning | |
| CN110019668A (en) | A kind of text searching method and device | |
| EP3640813B1 (en) | Cluster-based random walk method and apparatus | |
| CN106326309A (en) | Data query method and device | |
| CN112529694B (en) | Credit granting processing method, device, equipment and system | |
| CN110019298A (en) | Data processing method and device | |
| CN109145625A (en) | Processing method, device and the block chain data-storage system of policy information | |
| CN110069488A (en) | A kind of date storage method, method for reading data and its device | |
| CN109033365A (en) | A kind of data processing method and relevant device | |
| CN107451204B (en) | Data query method, device and equipment | |
| CN108399175A (en) | A kind of storage of data, querying method and its device | |
| CN110019544A (en) | Data query method and system | |
| CN104750749B (en) | Data processing method and device | |
| CN110020333A (en) | Data analysing method and device, electronic equipment, storage medium | |
| CN110069453A (en) | Operation/maintenance data treating method and apparatus | |
| CN110019385A (en) | The querying method and device of parameter | |
| CN108959330A (en) | A kind of processing of database, data query method and apparatus | |
| CN110019295B (en) | Database retrieval method, device, system and storage medium | |
| CN109697234A (en) | More attribute information storages, querying method, device, server and the medium of entity | |
| CN109885425A (en) | Backup method, back-up device, storage medium and the processor of data | |
| CN109582476A (en) | Data processing method, apparatus and system | |
| CN110019357A (en) | Data base querying scenario generation 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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Applicant before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |