CN109918394A - Data query method, system, computer installation and computer readable storage medium - Google Patents
Data query method, system, computer installation and computer readable storage medium Download PDFInfo
- Publication number
- CN109918394A CN109918394A CN201910065353.2A CN201910065353A CN109918394A CN 109918394 A CN109918394 A CN 109918394A CN 201910065353 A CN201910065353 A CN 201910065353A CN 109918394 A CN109918394 A CN 109918394A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- node
- choice box
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000009434 installation Methods 0.000 title claims abstract description 28
- 238000004590 computer program Methods 0.000 claims description 22
- 238000012545 processing Methods 0.000 abstract description 8
- 230000006870 function Effects 0.000 description 10
- 238000009877 rendering Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000013475 authorization Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data query method, system, computer installation and computer readable storage medium.The data query method includes: the attribute information for obtaining multiple databases, and generates tree-like preference pattern according to the attribute information of multiple databases;The choice box of the node of the tree-like preference pattern and default query interface is associated operation, wherein the default query interface includes an at least choice box and an at least input frame;The query information inputted in the option chosen in the choice box and the input frame is obtained, and inquiry instruction is generated according to the query information in the option and the input frame in the choice box;Return to the query result that the inquiry instruction carries out data query operation in multiple databases.The present invention is based on data processing techniques to be integrated into tree-like preference pattern for the simplification of multiple databases, and model and data query frame are associated, and reduces data query threshold, improves user query experience.
Description
Technical field
The present invention relates to technical field of data processing more particularly to a kind of data query method, system, computer installation and
Computer readable storage medium.
Background technique
Database Systems have become an important component indispensable in existing field of software development, and data
Access facility is then the most basic function of Database Systems.Traditional inquiry data access method is to call that database is dedicated connects
Mouth writes structured query language (Structured Query Language, abbreviation SQL) realization, this access method pair
The Basis of Database of software developer is more demanding, needs to write special SQL query according to inquiry field when inquiring record
Sentence.However, writing SQL statement, there are certain difficulty for being not software developer, the inquiry body of user is reduced
It tests.
Summary of the invention
In view of above-mentioned, the present invention provides a kind of data query method, system, computer installation and computer-readable storage medium
Matter carries out data query without inputting SQL statement, improves the data query experience of user.
One embodiment of the application provides a kind of data query method, which comprises
The attribute information of multiple databases is obtained, and tree-like selection mould is generated according to the attribute information of multiple databases
Type;
The choice box of the node of the tree-like preference pattern and default query interface is associated operation, wherein described pre-
If query interface includes an at least choice box and an at least input frame;
The query information inputted in the option chosen in the choice box and the input frame is obtained, and according to the selection
Query information in option and the input frame in frame generates inquiry instruction;And
Return to the query result that the inquiry instruction carries out data query operation in multiple databases.
Preferably, the attribute information includes: that Database Identification, tables of data mark, field identification and annotation identify, described
Tree-like preference pattern includes Database Identification node, tables of data mark node, field identification node and annotation mark node.
Preferably, each database includes an at least tables of data, and each tables of data includes an at least field, institute
Stating the step of generating tree-like preference pattern according to the attribute information of multiple databases includes:
The Database Identification node is connected to root node, tables of data mark node is connected to corresponding data
Library identifies node, and the field identification node is connected to corresponding tables of data and identifies node, and annotation mark node is connected
It is connected to corresponding tables of data mark node or field identification node.
Preferably, the default query interface includes multi-layer choice box, the node by the tree-like preference pattern
The step of being associated operation with the choice box of default query interface include:
First level choice box of the Database Identification node and the default query interface is associated;
Second level choice box of the tables of data mark node and the default query interface is associated;
The third level choice box of the field identification node and the default query interface is associated;And
4th level choice box of annotation the mark node and the default query interface is associated.
Preferably, the step for obtaining the query information inputted in the option and the input frame chosen in the choice box
Before rapid further include:
Data inquiry request is received, and obtains the identification information of the data inquiry request;
Whether there is search access right according to data inquiry request described in the identification information judgment;And
When the data inquiry request has search access right, the default query interface is jumped to.
Preferably, the query information in the option and the input frame according in the choice box generates inquiry instruction
The step of include:
Query information in option and the input frame in the choice box is packaged into SQL query instruction.
Preferably, the query result for returning to the inquiry instruction and carrying out data query operation in multiple databases
The step of include:
The inquiry instruction is input to each database using multithreading;And
The query result of each database is received, and the query result of each database is merged defeated
Out.
One embodiment of the application provides a kind of data query system, the system comprises:
First generation module, for obtaining the attribute information of multiple databases, and according to the attribute of multiple databases
Information generates tree-like preference pattern;
Relating module, for the choice box of the node of the tree-like preference pattern and default query interface to be associated behaviour
Make, wherein the default query interface includes an at least choice box and an at least input frame;
Second generation module, for obtaining the option chosen in the choice box and the inquiry inputted in the input frame letter
Breath, and inquiry instruction is generated according to the query information in the option and the input frame in the choice box;And
Enquiry module, for returning to the inquiry instruction in the inquiry knot of multiple databases progress data query operations
Fruit.
One embodiment of the application provides a kind of computer installation, and the computer installation includes processor and memory,
Several computer programs are stored on the memory, the processor is for when executing the computer program stored in memory
The step of realizing data query method as elucidated before.
One embodiment of the application provides a kind of computer readable storage medium, is stored thereon with computer program, described
The step of data query method as elucidated before is realized when computer program is executed by processor.
Above-mentioned data query method, system, computer installation and computer readable storage medium, according to multiple databases
Attribute information generates tree-like preference pattern, and the query frame of the node of tree-like preference pattern and query interface is associated, and uses
Family can the self-service database oneself to be inquired of selection, query frame supports that table name, field name, annotation etc. are inquired, without writing
Special SQL query statement is write, database data inquiry experience is improved, reduces data base querying doorframe.
Detailed description of the invention
It, below will be to required in embodiment description in order to illustrate more clearly of the technical solution of embodiment of the present invention
The attached drawing used is briefly described, it should be apparent that, the accompanying drawings in the following description is some embodiments of the present invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is the step flow chart of data query method in one embodiment of the invention.
Fig. 2 is the functional block diagram of data query system in one embodiment of the invention.
Fig. 3 is computer schematic device in one embodiment of the invention.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention will be described in detail.It should be noted that in the absence of conflict, presently filed embodiment and reality
The feature applied in mode can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, described embodiment
Only some embodiments of the invention, rather than whole embodiments.Based on the embodiment in the present invention, this field
Those of ordinary skill's every other embodiment obtained without making creative work, belongs to guarantor of the present invention
The range of shield.
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical.Term as used herein in the specification of the present invention is intended merely to description tool
The purpose of the embodiment of body, it is not intended that in the limitation present invention.
Preferably, data query method of the invention is applied in one or more computer installation.The computer
Device is that one kind can be according to the instruction for being previously set or storing, the automatic equipment for carrying out numerical value calculating and/or information processing,
Hardware includes but is not limited to microprocessor, specific integrated circuit (Application Specific Integrated
Circuit, ASIC), programmable gate array (Field-Programmable Gate Array, FPGA), digital processing unit
(Digital Signal Processor, DSP), embedded device etc..
The computer installation can be the calculating such as desktop PC, laptop, tablet computer, server and set
It is standby.The computer installation can carry out people by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user
Machine interaction.
Embodiment one:
Fig. 1 is the step flow chart of data query method preferred embodiment of the present invention.The process according to different requirements,
The sequence of step can change in figure, and certain steps can be omitted.
As shown in fig.1, the data query method specifically includes following steps.
Step S11, the attribute information of multiple databases is obtained, and according to the attribute information spanning tree of multiple databases
Shape preference pattern.
In one embodiment, data base management system (DBMS) management have multiple databases, can by with DBMS system
System is communicated to obtain the attribute information of multiple databases.The attribute information of database may include Database Identification,
Tables of data mark, field identification and annotation mark.Each database may include one or more tables of data, and each tables of data can
Including one or more fields, each field may include one or more data item.Each field may include one or more
Annotation, each tables of data also may include one or more annotations.
Each database is configured with a Database Identification, and each tables of data is identified configured with a tables of data, and each field is matched
It is equipped with a field identification, when tables of data has annotation, which also has annotation mark, when field has annotation,
The field equally also has an annotation mark.The Database Identification, tables of data mark, the field identification and the note
Releasing mark can be used as the node of the tree-like preference pattern.Wherein each Database Identification is all connected in the tree-like preference pattern
One default root node, each tables of data mark node are all connected to correspondence database mark node, and each field identification node is equal
It is connected to corresponding tables of data mark node, annotation mark node is connected to corresponding tables of data mark node or corresponding word
Segment identification node.
For example, multiple databases include first database and the second database, and user is when needing to inquire data, institute
First database and the second database are stated for user query.The first database is identified with first database, and described the
Two databases have the second Database Identification;The first database includes the first tables of data, and first tables of data may include
First field and the second field, the first tables of data also have corresponding first annotation;Second database may include the second number
According to table and third tables of data, second tables of data may include third field, and the third tables of data includes the 4th field, described
4th field also has corresponding second annotation.In the tree-like preference pattern, the first database mark node and institute
It states the second Database Identification node and is all connected to root node, the first tables of data mark node is connected to the first database
Node is identified, the first annotation mark node is connected to the first tables of data mark node, the first field identification section
Point and the second field identification node are all connected to the first tables of data mark node;Second tables of data mark node and the
Three tables of data mark node is all connected to the second Database Identification node, and the third field identification node is connected to described
Second tables of data identifies node, and the 4th field identification node is connected to third tables of data mark node, and described second
Annotation mark node is connected to the 4th field identification node.
In one embodiment, an interface UI can also be established according to the tree-like preference pattern, to realize at the interface UI
On check the data dictionaries of multiple databases.The interface UI may include page-mode, paging mode and UI imposition layout.Institute
Stating page-mode may include relative placement's page style and absolute layout page style.The paging mode can provide multipage
A title can be set in face configuration, each page, more than a certain amount of tables of data or is divided into the primary and secondary page for literary name section
Tables of data can be set to multi-page, if page-mode selection be relative placement page style, carry out multi-page match
The mode of alignment placement need to be set when setting, comprising: the big smallest number of horizontally-arranged, vertical setting of types and ranks.Carrying out UI imposition layout
When, if page-mode selection is relative placement's page style, it can be ranked up according to the requirement sequence of field and add one by one
It is added in the page, if page-mode selection is absolute layout page style, can be arranged by visualized graph interface
Version layout.
Step S12, the choice box of the node of the tree-like preference pattern and default query interface is associated operation,
Described in preset query interface include an at least choice box and an at least input frame.
In one embodiment, the default query interface can be integrated into the interface UI, and the query interface can
To include one or more choice boxs and one or more input frames.The choice box supports drop-down selection operation, the input
Frame supports the operation of input inquiry information.
In one embodiment, can have in the default query interface the first level choice box, the second level choice box,
Third level choice box and the 4th level choice box.The first level choice box can be with database in the tree-like preference pattern
Mark node is associated, and the second level choice box can be closed with tables of data mark node in the tree-like preference pattern
Connection, the third level choice box can be associated with field identification node in the tree-like preference pattern, the 4th level
Choice box can be associated with annotation mark node in the tree-like preference pattern.
For example, multiple databases include first database and the second database, and the first database has first
Database Identification, second database have the second Database Identification;The first database includes the first tables of data, described
First tables of data may include the first field and the second field, and the first tables of data also has corresponding first annotation;Second number
It may include the second tables of data and third tables of data according to library, second tables of data may include third field, the third tables of data
Including the 4th field, the 4th field also has corresponding second annotation.When the tree-like preference pattern and those choice boxs
After being associated operation, the first level choice box can show the first database and the second database, the second layer
Grade choice box can show first to third tables of data, and the third level choice box can show first to fourth field, described the
Four level choice boxs can show the first to the second annotation.It is to be appreciated that rendering preferences can in the second level choice box
It is associated with the first level choice box, rendering preferences can be selected with second level in the third level choice box
It selects frame to be associated, rendering preferences can be with the second level choice box or the third layer in the 4th level choice box
Grade choice box is associated.For example, when user chooses first database in the first level choice box, the second layer
Grade choice box can provide the first tables of data, and other tables of data are not shown then;When user is in the first level choice box
When choosing the second database, the second level choice box can provide the second tables of data and third tables of data, and other data
Table is not shown then;When user continues to choose third tables of data in the second level choice box, the third level selection
It can provide the 4th field in frame, other fields are not shown then.
It is understood that the choice box is also supported while selected multiple queries condition, such as first level choosing
Selecting frame can support to choose the first database and second database simultaneously.
Step S13, obtains the query information inputted in the option chosen in the choice box and the input frame, and according to
Query information in option and the input frame in the choice box generates inquiry instruction.
In one embodiment, the query information in the option and the input frame chosen in the choice box can be encapsulated
At a SQL query statement, data query operation is executed in the database to facilitate.The default query interface may be provided with one and look into
Asking icon can be by the query information in the option and the input frame in the choice box when the query icon is triggered
It is packaged into SQL query statement, and then executes inquiry operation in the database.
In one embodiment, the default query interface has Authorization Attributes, when the inquiry with corresponding authority attribute
Request can just link to the query interface.For example, the customer attribute information may include that user's name and/or user are close
Code.When hyperlink request to the query interface it may require that user inputs corresponding customer attribute information (user name and/or close
Code) to be verified, and just enter the default query interface after being proved to be successful.Specifically, choosing in the choice box is obtained
In option and the input frame in input query information the step of before further include: receive data inquiry request, and obtain
The identification information of the data inquiry request;According to data inquiry request described in the identification information judgment whether there is inquiry to weigh
Limit;And when the data inquiry request has search access right, jump to the default query interface.
Step S14, the query result that the inquiry instruction carries out data query operation in multiple databases is returned.
In one embodiment, when needs are when multiple databases carry out data query operation, in order to promote inquiry velocity
It can use multithreading and the inquiry instruction be input to each database progress parallel processing, then receive each institute again
The query result of database is stated, and the query result of each database is merged into output and obtains final data query
As a result;When only need to can use single thread when database carries out data query operation and be input to the inquiry instruction
Target database carries out data query operation.The final data query result can be packaged as file carry out output or
Directly output is carried out by the default query interface to show.
Above-mentioned data query method generates tree-like preference pattern according to the attribute information of multiple databases, and by tree-like choosing
The query frame of the node and query interface of selecting model is associated, user can the self-service database oneself to be inquired of selection, look into
It askes frame and supports that table name, field name, annotation etc. are inquired, without writing special SQL query statement, improve database data
Inquiry experience, reduces data base querying doorframe.
Embodiment two:
Fig. 2 is the functional block diagram of data query system preferred embodiment of the present invention.
As shown in fig.2, the data query system 10 may include the first generation module 101, relating module 102,
Two generation modules 103, enquiry module 104 and certification jump module 105.
First generation module 101 is used to obtain the attribute information of multiple databases, and according to multiple databases
Attribute information generate tree-like preference pattern.
In one embodiment, DBMS system administration has multiple databases, first generation module 101 can by with
DBMS system is communicated to obtain the attribute information of multiple databases.The attribute information of database may include database
Mark, tables of data mark, field identification and annotation mark.Each database may include one or more tables of data, each number
It may include one or more fields according to table, each field may include one or more data item.Each field may include one
Or multiple annotations, each tables of data also may include one or more annotations.
Each database is configured with a Database Identification, and each tables of data is identified configured with a tables of data, and each field is matched
It is equipped with a field identification, when tables of data has annotation, which also has annotation mark, when field has annotation,
The field equally also has an annotation mark.The Database Identification, tables of data mark, the field identification and the note
Releasing mark can be used as the node of the tree-like preference pattern.Wherein each Database Identification is all connected in the tree-like preference pattern
One default root node, each tables of data mark node are all connected to correspondence database mark node, and each field identification node is equal
It is connected to corresponding tables of data mark node, annotation mark node is connected to corresponding tables of data mark node or corresponding word
Segment identification node.
For example, multiple databases include first database and the second database, and user is when needing to inquire data, institute
First database and the second database are stated for user query.The first database is identified with first database, and described the
Two databases have the second Database Identification;The first database includes the first tables of data, and first tables of data may include
First field and the second field, the first tables of data also have corresponding first annotation;Second database may include the second number
According to table and third tables of data, second tables of data may include third field, and the third tables of data includes the 4th field, described
4th field also has corresponding second annotation.In the tree-like preference pattern, the first database mark node and institute
It states the second Database Identification node and is all connected to root node, the first tables of data mark node is connected to the first database
Node is identified, the first annotation mark node is connected to the first tables of data mark node, the first field identification section
Point and the second field identification node are all connected to the first tables of data mark node;Second tables of data mark node and the
Three tables of data mark node is all connected to the second Database Identification node, and the third field identification node is connected to described
Second tables of data identifies node, and the 4th field identification node is connected to third tables of data mark node, and described second
Annotation mark node is connected to the 4th field identification node.
In one embodiment, first generation module 101 can also establish a UI according to the tree-like preference pattern
Interface, to realize the data dictionary for checking multiple databases on the interface UI.The interface UI may include page-mode, paging
Mode and UI imposition layout.The page-mode may include relative placement's page style and absolute layout page style.It is described
Paging mode can provide multi-page configuration, and a title can be set in each page, be more than a certain amount of data for literary name section
Table or the tables of data for being divided into the primary and secondary page, can be set to multi-page, if page-mode selection be relative placement page
Face style, in the mode for carrying out that alignment placement need to be arranged when multi-page configuration, comprising: the big decimal of horizontally-arranged, vertical setting of types and ranks
Amount.It, can be according to the requirement of field if page-mode selection is relative placement's page style when carrying out UI imposition layout
Sequence is ranked up and is added in the page one by one, can be by can if page-mode selection is absolute layout page style
Imposition layout is carried out depending on changing graphical interfaces.
The relating module 102 is used to carry out the choice box of the node of the tree-like preference pattern and default query interface
It is operation associated, wherein the default query interface includes an at least choice box and an at least input frame.
In one embodiment, the default query interface can be integrated into the interface UI, and the query interface can
To include one or more choice boxs and one or more input frames.The choice box supports drop-down selection operation, the input
Frame supports the operation of input inquiry information.
In one embodiment, can have in the default query interface the first level choice box, the second level choice box,
Third level choice box and the 4th level choice box.The relating module 102 can configure the first level choice box and institute
It states Database Identification node in tree-like preference pattern to be associated, in the second level choice box and the tree-like preference pattern
Tables of data mark node is associated, and field identification node carries out in the third level choice box and the tree-like preference pattern
Association, the 4th level choice box are associated with annotation mark node in the tree-like preference pattern.
For example, multiple databases include first database and the second database, and the first database has first
Database Identification, second database have the second Database Identification;The first database includes the first tables of data, described
First tables of data may include the first field and the second field, and the first tables of data also has corresponding first annotation;Second number
It may include the second tables of data and third tables of data according to library, second tables of data may include third field, the third tables of data
Including the 4th field, the 4th field also has corresponding second annotation.When the tree-like preference pattern and those choice boxs
After being associated operation, the first level choice box can show the first database and the second database, the second layer
Grade choice box can show first to third tables of data, and the third level choice box can show first to fourth field, described the
Four level choice boxs can show the first to the second annotation.It is to be appreciated that rendering preferences can in the second level choice box
It is associated with the first level choice box, rendering preferences can be selected with second level in the third level choice box
It selects frame to be associated, rendering preferences can be with the second level choice box or the third layer in the 4th level choice box
Grade choice box is associated.For example, when user chooses first database in the first level choice box, the second layer
Grade choice box can provide the first tables of data, and other tables of data are not shown then;When user is in the first level choice box
When choosing the second database, the second level choice box can provide the second tables of data and third tables of data, and other data
Table is not shown then;When user continues to choose third tables of data in the second level choice box, the third level selection
It can provide the 4th field in frame, other fields are not shown then.
It is understood that the choice box is also supported while selected multiple queries condition, such as first level choosing
Selecting frame can support to choose the first database and second database simultaneously.
Second generation module 103 is used to obtain input in the option chosen in the choice box and the input frame
Query information, and inquiry instruction is generated according to the query information in the option and the input frame in the choice box.
In one embodiment, second generation module 103 can be by the option chosen in the choice box and described defeated
Enter the query information in frame and be packaged into a SQL query statement, executes data query operation in the database to facilitate.It is described default
Query interface may be provided with a query icon, when the query icon is triggered, can by the choice box option and institute
It states the query information in input frame and is packaged into SQL query statement, and then execute inquiry operation in the database.
In one embodiment, the default query interface has Authorization Attributes, when the inquiry with corresponding authority attribute
Request can just link to the query interface.For example, the customer attribute information may include that user's name and/or user are close
Code.When hyperlink request to the query interface it may require that user inputs corresponding customer attribute information (user name and/or close
Code) to be verified, and just enter the default query interface after being proved to be successful, carry out data query operation.
The certification jump module 105 for receiving data believe by inquiry request, the mark for obtaining the data inquiry request
Breath, and whether the data inquiry request according to the identification information judgment has search access right.
In one embodiment, when the data inquiry request is identified as with search access right, the certification is jumped
Module 105 jumps to the default query interface.When the data inquiry request be identified as do not have search access right when, not into
Row jumps movement, can export the prompt information of lack of competence inquiry database.
The enquiry module 104 is used to return the inquiry instruction and carries out data query operation in multiple databases
Query result.
In one embodiment, when needs are when multiple databases carry out data query operation, in order to promote inquiry velocity,
The enquiry module 104 can use multithreading and the inquiry instruction be input to each database progress parallel processing,
Then the query result of each database is received again, and the query result of each database is merged and is exported
To final data query result;When only need to be when database carries out data query operation, the enquiry module 104 can be with
The inquiry instruction is input to target database using only single thread and carries out data query operation.The final data query
As a result can be packaged as file carry out output or directly carrying out output by the default query interface shows.
Above-mentioned data query method generates tree-like preference pattern according to the attribute information of multiple databases, and by tree-like choosing
The query frame of the node and query interface of selecting model is associated, user can the self-service database oneself to be inquired of selection, look into
It askes frame and supports that table name, field name, annotation etc. are inquired, without writing special SQL query statement, improve database data
Inquiry experience, reduces data base querying doorframe.
Fig. 3 is the schematic diagram of computer installation preferred embodiment of the present invention.
The computer installation 1 includes memory 20, processor 30 and is stored in the memory 20 and can be in institute
State the computer program 40 run on processor 30, such as data query program.The processor 30 executes the computer journey
The step in above-mentioned data query embodiment of the method, such as step S11~S14 shown in FIG. 1 are realized when sequence 40.Alternatively, described
Processor 30 realizes the function of each module in above-mentioned data query system embodiment when executing the computer program 40, such as schemes
Module 101~105 in 2.
Illustratively, the computer program 40 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 20, and are executed by the processor 30, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, and described instruction section is used
In implementation procedure of the description computer program 40 in the computer installation 1.For example, the computer program 40 can be with
The first generation module 101, relating module 102, the second generation module 103, enquiry module 104 and the certification being divided into Fig. 2
Jump module 105.Each module concrete function is referring to embodiment two.
The computer installation 1 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.It will be understood by those skilled in the art that the schematic diagram is only the example of computer installation 1, do not constitute to computer
The restriction of device 1 may include perhaps combining certain components or different components, example than illustrating more or fewer components
Such as described computer installation 1 can also include input-output equipment, network access equipment, bus.
Alleged processor 30 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor 30 is also possible to any conventional processing
Device etc., the processor 30 are the control centres of the computer installation 1, utilize various interfaces and the entire computer of connection
The various pieces of device 1.
The memory 20 can be used for storing the computer program 40 and/or module/unit, and the processor 30 passes through
Operation executes the computer program and/or module/unit being stored in the memory 20, and calls and be stored in memory
Data in 20 realize the various functions of the computer installation 1.The memory 20 can mainly include storing program area and deposit
Store up data field, wherein storing program area can application program needed for storage program area, at least one function (for example sound is broadcast
Playing function, image player function etc.) etc.;Storage data area, which can be stored, uses created data (ratio according to computer installation 1
Such as audio data, phone directory) etc..In addition, memory 20 may include high-speed random access memory, it can also include non-easy
The property lost memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) card, flash card (Flash Card), at least one disk memory, flush memory device or other
Volatile solid-state part.
If the integrated module/unit of the computer installation 1 is realized in the form of SFU software functional unit and as independence
Product when selling or using, can store in a computer readable storage medium.Based on this understanding, of the invention
It realizes all or part of the process in above-described embodiment method, can also instruct relevant hardware come complete by computer program
At the computer program can be stored in a computer readable storage medium, and the computer program is held by processor
When row, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, institute
Stating computer program code can be source code form, object identification code form, executable file or certain intermediate forms etc..It is described
Computer-readable medium may include: any entity or device, recording medium, U that can carry the computer program code
Disk, mobile hard disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), arbitrary access
Memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It needs
It is bright, the content that the computer-readable medium includes can according in jurisdiction make laws and patent practice requirement into
Row increase and decrease appropriate, such as do not include electric load according to legislation and patent practice, computer-readable medium in certain jurisdictions
Wave signal and telecommunication signal.
In several embodiments provided by the present invention, it should be understood that disclosed computer installation and method, it can be with
It realizes by another way.For example, computer installation embodiment described above is only schematical, for example, described
The division of unit, only a kind of logical function partition, there may be another division manner in actual implementation.
It, can also be in addition, each functional unit in each embodiment of the present invention can integrate in same treatment unit
It is that each unit physically exists alone, can also be integrated in same unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds software function module.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.This
Outside, it is clear that one word of " comprising " does not exclude other units or steps, and odd number is not excluded for plural number.It is stated in computer installation claim
Multiple units or computer installation can also be implemented through software or hardware by the same unit or computer installation.The
One, the second equal words are used to indicate names, and are not indicated any particular order.
Finally it should be noted that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although reference
Preferred embodiment describes the invention in detail, those skilled in the art should understand that, it can be to of the invention
Technical solution is modified or equivalent replacement, without departing from the spirit and scope of the technical solution of the present invention.
Claims (10)
1. a kind of data query method, which is characterized in that the described method includes:
The attribute information of multiple databases is obtained, and tree-like preference pattern is generated according to the attribute information of multiple databases;
The choice box of the node of the tree-like preference pattern and default query interface is associated operation, wherein described preset is looked into
Asking interface includes an at least choice box and an at least input frame;
The query information inputted in the option chosen in the choice box and the input frame is obtained, and according in the choice box
Option and the input frame in query information generate inquiry instruction;And
Return to the query result that the inquiry instruction carries out data query operation in multiple databases.
2. data query method as described in claim 1, which is characterized in that the attribute information includes: Database Identification, number
According to table mark, field identification and annotation mark, the tree-like preference pattern includes Database Identification node, tables of data mark section
Point, field identification node and annotation mark node.
3. data query method as claimed in claim 2, which is characterized in that each database includes an at least data
Table, each tables of data includes an at least field, described to generate tree-like selection according to the attribute information of multiple databases
The step of model includes:
The Database Identification node is connected to root node, tables of data mark node is connected to corresponding database mark
Know node, the field identification node is connected to corresponding tables of data and identifies node, annotation mark node is connected to
Corresponding tables of data mark node or field identification node.
4. data query method as claimed in claim 2, which is characterized in that the default query interface includes multi-layer selection
The step of choice box of frame, the node and default query interface by the tree-like preference pattern is associated operation include:
First level choice box of the Database Identification node and the default query interface is associated;
Second level choice box of the tables of data mark node and the default query interface is associated;
The third level choice box of the field identification node and the default query interface is associated;And
4th level choice box of annotation the mark node and the default query interface is associated.
5. the data query method as described in claim 1-4 any one, which is characterized in that described to obtain in the choice box
Before the step of query information inputted in the option and the input frame chosen further include:
Data inquiry request is received, and obtains the identification information of the data inquiry request;
Whether there is search access right according to data inquiry request described in the identification information judgment;And
When the data inquiry request has search access right, the default query interface is jumped to.
6. the data query method as described in claim 1-4 any one, which is characterized in that described according in the choice box
Option and the input frame in query information generate inquiry instruction the step of include:
Query information in option and the input frame in the choice box is packaged into SQL query instruction.
7. the data query method as described in claim 1-4 any one, which is characterized in that described to return to the inquiry instruction
Include: in the step of multiple databases carry out the query result of data query operation
The inquiry instruction is input to each database using multithreading;And
The query result of each database is received, and the query result of each database is merged into output.
8. a kind of data query system, which is characterized in that the system comprises:
First generation module, for obtaining the attribute information of multiple databases, and according to the attribute information of multiple databases
Generate tree-like preference pattern;
Relating module, for the choice box of the node of the tree-like preference pattern and default query interface to be associated operation,
Wherein the default query interface includes an at least choice box and an at least input frame;
Second generation module, the query information for obtaining the option chosen in the choice box and being inputted in the input frame,
And inquiry instruction is generated according to the query information in the option and the input frame in the choice box;And
Enquiry module, for returning to the inquiry instruction in the query result of multiple databases progress data query operations.
9. a kind of computer installation, the computer installation includes processor and memory, is stored on the memory several
Computer program, which is characterized in that such as right is realized when the processor is for executing the computer program stored in memory
It is required that described in any one of 1-7 the step of data query method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of data query method as described in any one of claim 1-7 is realized when being executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910065353.2A CN109918394B (en) | 2019-01-23 | 2019-01-23 | Data query method, system, computer device and computer readable storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910065353.2A CN109918394B (en) | 2019-01-23 | 2019-01-23 | Data query method, system, computer device and computer readable storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109918394A true CN109918394A (en) | 2019-06-21 |
CN109918394B CN109918394B (en) | 2023-11-28 |
Family
ID=66960655
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910065353.2A Active CN109918394B (en) | 2019-01-23 | 2019-01-23 | Data query method, system, computer device and computer readable storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109918394B (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111680110A (en) * | 2020-05-21 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | Data processing method, data processing device, BI system and medium |
CN111986331A (en) * | 2020-08-18 | 2020-11-24 | 上海外高桥造船有限公司 | Smart3D attribute viewing system for cruise ship design |
CN112417027A (en) * | 2020-11-19 | 2021-02-26 | 青岛以萨数据技术有限公司 | Data processing method, system, terminal and medium for visual operation database |
CN112632115A (en) * | 2020-07-31 | 2021-04-09 | 银盛支付服务股份有限公司 | BI-based data query method and system |
CN113064911A (en) * | 2020-01-02 | 2021-07-02 | 北京中关村科金技术有限公司 | Query method, query device and storage medium |
CN113761009A (en) * | 2021-11-09 | 2021-12-07 | 深圳市明源云科技有限公司 | Personnel selection method, system, device and computer readable storage medium |
CN114547107A (en) * | 2022-02-24 | 2022-05-27 | 新奥数能科技有限公司 | Internet of things data query method, device, equipment and storage medium |
CN116414778A (en) * | 2021-12-29 | 2023-07-11 | 宁畅信息产业(北京)有限公司 | File integration method, apparatus, computer device, storage medium and program product |
US11741093B1 (en) | 2021-07-21 | 2023-08-29 | T-Mobile Usa, Inc. | Intermediate communication layer to translate a request between a user of a database and the database |
CN116681382A (en) * | 2023-05-16 | 2023-09-01 | 智诚计算机辅助设计(深圳)有限公司 | Material list data grabbing method, system and readable storage medium |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080027788A1 (en) * | 2006-07-28 | 2008-01-31 | Lawrence John A | Object Oriented System and Method for Optimizing the Execution of Marketing Segmentations |
US20110093500A1 (en) * | 2009-01-21 | 2011-04-21 | Google Inc. | Query Optimization |
CN103778124A (en) * | 2012-10-17 | 2014-05-07 | 北大方正集团有限公司 | Tree structure query method and device |
US20140244687A1 (en) * | 2013-02-24 | 2014-08-28 | Technion Research & Development Foundation Limited | Processing query to graph database |
CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
CN107665228A (en) * | 2017-05-10 | 2018-02-06 | 平安科技(深圳)有限公司 | A kind of related information querying method, terminal and equipment |
CN107729396A (en) * | 2017-09-20 | 2018-02-23 | 上海精数信息科技有限公司 | Data Dynamic Query method and device |
-
2019
- 2019-01-23 CN CN201910065353.2A patent/CN109918394B/en active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080027788A1 (en) * | 2006-07-28 | 2008-01-31 | Lawrence John A | Object Oriented System and Method for Optimizing the Execution of Marketing Segmentations |
US20110093500A1 (en) * | 2009-01-21 | 2011-04-21 | Google Inc. | Query Optimization |
CN103778124A (en) * | 2012-10-17 | 2014-05-07 | 北大方正集团有限公司 | Tree structure query method and device |
US20140244687A1 (en) * | 2013-02-24 | 2014-08-28 | Technion Research & Development Foundation Limited | Processing query to graph database |
CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
CN107665228A (en) * | 2017-05-10 | 2018-02-06 | 平安科技(深圳)有限公司 | A kind of related information querying method, terminal and equipment |
CN107729396A (en) * | 2017-09-20 | 2018-02-23 | 上海精数信息科技有限公司 | Data Dynamic Query method and device |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113064911A (en) * | 2020-01-02 | 2021-07-02 | 北京中关村科金技术有限公司 | Query method, query device and storage medium |
CN113064911B (en) * | 2020-01-02 | 2024-04-19 | 北京中关村科金技术有限公司 | Query method, device and storage medium |
CN111680110A (en) * | 2020-05-21 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | Data processing method, data processing device, BI system and medium |
CN112632115A (en) * | 2020-07-31 | 2021-04-09 | 银盛支付服务股份有限公司 | BI-based data query method and system |
CN111986331A (en) * | 2020-08-18 | 2020-11-24 | 上海外高桥造船有限公司 | Smart3D attribute viewing system for cruise ship design |
CN111986331B (en) * | 2020-08-18 | 2024-03-15 | 上海外高桥造船有限公司 | Smart3D attribute viewing system for mailbox design |
CN112417027A (en) * | 2020-11-19 | 2021-02-26 | 青岛以萨数据技术有限公司 | Data processing method, system, terminal and medium for visual operation database |
US11741093B1 (en) | 2021-07-21 | 2023-08-29 | T-Mobile Usa, Inc. | Intermediate communication layer to translate a request between a user of a database and the database |
CN113761009A (en) * | 2021-11-09 | 2021-12-07 | 深圳市明源云科技有限公司 | Personnel selection method, system, device and computer readable storage medium |
CN116414778A (en) * | 2021-12-29 | 2023-07-11 | 宁畅信息产业(北京)有限公司 | File integration method, apparatus, computer device, storage medium and program product |
CN114547107A (en) * | 2022-02-24 | 2022-05-27 | 新奥数能科技有限公司 | Internet of things data query method, device, equipment and storage medium |
CN116681382A (en) * | 2023-05-16 | 2023-09-01 | 智诚计算机辅助设计(深圳)有限公司 | Material list data grabbing method, system and readable storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN109918394B (en) | 2023-11-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109918394A (en) | Data query method, system, computer installation and computer readable storage medium | |
US8108367B2 (en) | Constraints with hidden rows in a database | |
US7257597B1 (en) | Table substitution | |
US6108651A (en) | Heuristic co-identification of objects across heterogeneous information sources | |
JP2957702B2 (en) | Semantic object modeling system for generating relational database schema | |
US8589424B1 (en) | Method and system for accurate medical-code translation | |
CN109766097A (en) | UI generation method, device, electronic equipment and computer readable storage medium | |
CN109840257B (en) | Database query method, database query device, computer device and readable storage medium | |
US20230018975A1 (en) | Monolith database to distributed database transformation | |
US20110246535A1 (en) | Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment | |
CN111427577A (en) | Code processing method and device and server | |
US7975247B2 (en) | Method and system for organizing data generated by electronic design automation tools | |
CN108388623A (en) | ER relationships generation method, device, computer equipment and storage medium | |
US20190065499A1 (en) | Execution Planner | |
US20080077552A1 (en) | Systems and methods for analyzing multiple states in one or more groups of data | |
CN109829138A (en) | File comparison method, device, electronic equipment and computer readable storage medium | |
CN112487036A (en) | Data processing method and device | |
US20190147088A1 (en) | Reporting and data governance management | |
US8650534B2 (en) | Metaobject enhancement objects | |
JP2007133624A (en) | Information management method and device using connection relation information | |
CN117851375A (en) | Metadata model optimization method and computing device | |
CN112328599A (en) | Metadata-based field blood relationship analysis method and device | |
CN110489401A (en) | A kind of dispositions method and device of database object | |
US10318524B2 (en) | Reporting and data governance management | |
CN110990637A (en) | Method and device for constructing network map |
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 |