CN107169130A - The visual inquiry method and system of a kind of database - Google Patents

The visual inquiry method and system of a kind of database Download PDF

Info

Publication number
CN107169130A
CN107169130A CN201710427410.8A CN201710427410A CN107169130A CN 107169130 A CN107169130 A CN 107169130A CN 201710427410 A CN201710427410 A CN 201710427410A CN 107169130 A CN107169130 A CN 107169130A
Authority
CN
China
Prior art keywords
parameter
basic module
database
module
query language
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201710427410.8A
Other languages
Chinese (zh)
Inventor
李晖
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guizhou Youlian Borui Technology Co Ltd
Original Assignee
Guizhou Youlian Borui Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guizhou Youlian Borui Technology Co Ltd filed Critical Guizhou Youlian Borui Technology Co Ltd
Priority to CN201710427410.8A priority Critical patent/CN107169130A/en
Publication of CN107169130A publication Critical patent/CN107169130A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2452Query translation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2452Query translation
    • G06F16/24526Internal representations for queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Abstract

The present invention relates to field of database query technology, the visual inquiry method and system of a kind of database are disclosed, by generating visualized graph interface;According to analysis task type, concatenation, and arrange parameter are carried out to the basic module, with creation analysis task visualization model;Statement translation is carried out to the visualization model, with the target query language statement sequence of generation;According to the target query language statement sequence, database is inquired about.The present invention is applied to Array Model, can correctly define science data analysis task, realizes visualization and builds complex query statement sequence, meets the demand that user's visualization builds complex query sentence.

Description

The visual inquiry method and system of a kind of database
Technical field
The present invention relates to field of database query technology, more particularly to a kind of database visual inquiry method and be System.
Background technology
The arrival of magnanimity science data makes field scientist face unprecedented Scientific data management predicament.On the one hand, Relational DBMS of the tradition using table as data model can not meet the extensive science data of scientific domain Regulatory requirement;On the other hand, for the field scientist of Non-computer Majors background, quick definition data analysis task is The key of research, but it is still relatively difficult to write complex query sentence using query language.Array database system (Array Database System) rise provide optional solution newly for Scientific data management, but these systems generally use The array query language each designed, query statement for representing complicated analysis task is write this again improves scientists Threshold.
Visual inquiring structuring can easily generate complicated SQL statement, reduce the threshold for writing complex query.It is existing Visual query building mode in technology is broadly divided into four classes:Table parameter form inquiring structuring, example statement inquiry mode, Natural language description and graph inquiring structuring mode.First two is easy to use, such as SDSS SkyServer, but table parameter shape Formula is inquired about and example statement inquires about the stronger domain knowledge of needs, and the support inquired about User Defined is limited, the scope of application It is limited;The third is using natural language description as input, such as NaLIR, and it is only supported using English as description language at present, and will be various The actual pattern of natural language description accurate translation into database is relatively difficult, and applicability is not also strong.4th kind of mode, user is only Drag operation is needed to complete the setting of data object and the structure of query statement, such as Ajax Query Builder, but this Mode is mainly directed towards relevant database, is no longer desirable for Scientific data management and the analysis of Array Model.
The content of the invention
The present invention provides the visual inquiry method and system of a kind of database, solves visual inquiry in the prior art Construction method applicability is not strong, inefficient, is particularly unsuitable for the technical problem of Array Model.
The purpose of the present invention is achieved through the following technical solutions:
A kind of visual inquiry method of database, including:
Visualized graph interface is generated, the visualized graph interface includes exercisable function menu option and basic group Part, the basic module includes SELECT components, result items list element, Data source table list element, table connection component, condition Component and function component are set;
According to analysis task type, concatenation, and arrange parameter are carried out to the basic module, with creation analysis task Visualization model;
Statement translation is carried out to the visualization model, with the target query language statement sequence of generation;
According to the target query language statement sequence, database is inquired about.
The visual inquiry method of foregoing database, it is described according to analysis task type, basic module is spliced Operation, and after the step of arrange parameter, it is described the step of carry out statement translation to the visualization model before, including:
The parameter region of the basic module is traveled through, the parameter value of the basic module is collected;
The parameter value being collected into is changed into the parameter list of grammaticality.
The visual inquiry method of foregoing database, it is described according to analysis task type, basic module is spliced Operate, and the step of arrange parameter includes:
According to analysis task type, concatenation, and arrange parameter are carried out to the basic module;
During concatenation, according to the syntax rule of target query language, the parameter between the basic module is judged Whether type matches;
When the parameter type between the basic module is mismatched, produce alarm and indicate.
The step of visual inquiry method of foregoing database, progress statement translation to the visualization model, Including:
Take out the parameter in parameter list;
The parameter position parameter of taking-up inserted in the target query language sentence of correspondence basic module;
From the generation of internal code BOB(beginning of block), successively carry out, with the target query language statement sequence of generation.
A kind of visual query system of database, it is characterised in that including:
Interface generation module, for generating visualized graph interface, the visualized graph interface includes exercisable work( Energy menu option and basic module, the basic module include SELECT components, result items list element, Data source table list group Part, table connection component, condition setting component and function component;
Graphical analytic type inquiring structuring module, for according to analysis task type, splicing to the basic module Operation, and arrange parameter, with creation analysis task visualization model;
Query translation module, for carrying out statement translation to the visualization model, with the target query language language of generation Sentence sequence;
Query execution module, for according to the target query language statement sequence, inquiring about database.
The visual query system of foregoing database, in addition to parameter collection module, for traveling through the basic module Parameter region, collect the parameter value of the basic module;The parameter value being collected into is changed into grammaticality Parameter list.
The visual query system of foregoing database, the graphical analytic type inquiring structuring module, including:
Parameter set unit, for according to analysis task type, carrying out concatenation to the basic module, and set ginseng Number;
Execution unit is built, for during concatenation, according to the syntax rule of target query language, judges described Whether the parameter type between basic module matches;
Matching judgment unit, for when the parameter type between the basic module is mismatched, producing alarm and indicating.
The visual query system of foregoing database, the query translation module, including:
Parameter acquiring unit, for taking out the parameter in parameter list;
Parameter generating unit, for the parameter of taking-up to be inserted in the target query language sentence of correspondence basic module Parameter position;
Execution unit is translated, for from the generation of internal code BOB(beginning of block), successively carrying out, with the target query language language of generation Sentence sequence.
The present invention technique effect be:By generating visualized graph interface;According to analysis task type, to described basic Component carries out concatenation, and arrange parameter, with creation analysis task visualization model;Line statement is entered to the visualization model Translation, with the target query language statement sequence of generation;According to the target query language statement sequence, database is looked into Ask.The present invention is applied to Array Model, can correctly define science data analysis task, realizes visualization and builds complex query language Sentence sequence, meets the demand that user's visualization builds complex query sentence.
Brief description of the drawings
Fig. 1 is a kind of flow chart of the visual inquiry method of database provided in an embodiment of the present invention;
Fig. 2 is the schematic diagram of graphical analysis task basic module (Block) provided in an embodiment of the present invention;
Fig. 3 is a kind of structural representation of the visual query system of database provided in an embodiment of the present invention.
Embodiment
In order to facilitate the understanding of the purposes, features and advantages of the present invention, it is below in conjunction with the accompanying drawings and specific real Applying mode, the present invention is further detailed explanation.
For the research-on-research of the scientific domains such as astronomy, nuclear physics, long-range remote sensing application, oceanography and biology For person, the natural data model of the data obtained in its research process is mostly array (Array) model, one-dimensional Array is array, and two-dimentional Array is from logical form, and the table of relational database is of equal value, but Array has three-dimensional The even more form of higher-dimension.The embodiments of the invention provide a kind of visual inquiry method of database, as shown in figure 1, including:
Step 101, generation visualized graph interface;
Wherein, the visualized graph interface includes exercisable function menu option and basic module, basic module bag Include the basic module (Block) of analytic type task as shown in Figure 2, including the basic Block mono- of (a) SELECT, (b) SELECT bases The basic Block tri- of this Block two, (c) SELECT, the basic Block tetra- of (d) SELECT, (e) result items list Block, (f) number According to source table list Block (g), base table connection Block (h), primary condition Block examples, (i) function (containing built-in function and SQL) Block examples etc..Wherein, list Block can increase and decrease list items number according to query intention.These Block Interface is built including visualization, can be by simply splicing Block come expression analysis task so as to obtain user, and automatically generate The statement sequence of target query language.
Step 102, according to analysis task type, concatenation, and arrange parameter are carried out to the basic module, to build Analysis task visualization model;
Wherein, step 102, it can specifically include:
Step 102-1, according to analysis task type, concatenation, and arrange parameter are carried out to the basic module;
In this step, splice graphical analysis task basic module (Block) structure science data analysis times by pulling Business.Concatenation supports the function of complicated nested query, and (level of nesting is or not the nested query that can for example build as follows Limit).
Select a,b,d
from A,B
where A.a>B.b and d in(select d from B where d>12)。
During step 102-2, concatenation, according to the syntax rule of target query language, the basic module is judged Between parameter type whether match;
Step 103, to the visualization model carry out statement translation, with the target query language statement sequence of generation;
Wherein, step 103, it can specifically include:
Step 103-1, the parameter taken out in parameter list;
Step 103-2, the parameter for inserting the parameter of taking-up in the target query language sentence for corresponding to basic module Position;
Step 103-3, from internal code BOB(beginning of block) generation, successively carry out, with the target query language statement sequence of generation.
Step 104, according to the target query language statement sequence, database is inquired about.
Wherein, target query language is the query language AQL of array (Array) database.AQL is when design, ginseng According to SQL, but there is difference in both in the syntax and semantics rule of language.
Between step 103 and step 102, it can also include:
Step a, the traversal basic module parameter region, collect the parameter value of the basic module;
Step b, the parameter list that the parameter value being collected into is changed into grammaticality.
Step c, when between the basic module parameter type mismatch when, produce alarm indicate.
The visual inquiry method and system of a kind of database provided in an embodiment of the present invention, by generating visualized graphs Interface;According to analysis task type, concatenation, and arrange parameter are carried out to the basic module, can with creation analysis task Depending on changing module;Statement translation is carried out to the visualization model, with the target query language statement sequence of generation;According to the mesh Query language statement sequence is marked, database is inquired about.The present invention is applied to Array Model, can correctly define science data point Analysis task, realizes visualization and builds complex query statement sequence, meets the demand that user's visualization builds complex query sentence.
The embodiment of the present invention additionally provides a kind of visual query system of database, as shown in figure 3, including:
Interface generation module 310, for generating visualized graph interface, the visualized graph interface includes exercisable Function menu option and basic module, the basic module include SELECT components, result items list element, Data source table list Component, table connection component, condition setting component and function (built-in function and SQL) component;
Graphical analytic type inquiring structuring module 320, for according to analysis task type, being spelled to the basic module Operation, and arrange parameter are connect, with creation analysis task visualization model;
Query translation module 330, for carrying out statement translation to the visualization model, with the target query language of generation Statement sequence;
Query execution module 340, for according to the target query language statement sequence, inquiring about database.
Wherein, the system can be with parameter collection module 350, the parameter region for traveling through the basic module, collects The parameter value of the basic module;The parameter value being collected into is changed into the parameter list of grammaticality.
The graphical analytic type inquiring structuring module 320, including:
Parameter set unit 321, for according to analysis task type, carrying out concatenation to the basic module, and set Put parameter;
Execution unit 322 is built, for during concatenation, according to the syntax rule of target query language, is judged Whether the parameter type between the basic module matches;
Matching judgment unit 323, for when the parameter type between the basic module is mismatched, producing alarm and referring to Show.
The query translation module 330, including:
Parameter acquiring unit 331, for taking out the parameter in parameter list;
Parameter generating unit 332, the target query language language for the parameter of taking-up to be inserted to correspondence basic module Parameter position in sentence;
Execution unit 333 is translated, for from the generation of internal code BOB(beginning of block), successively carrying out, with the target query language of generation Say statement sequence.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be by Software adds the mode of required hardware platform to realize, naturally it is also possible to all implemented by hardware, but in many cases before Person is more preferably embodiment.Understood based on such, whole that technical scheme contributes to background technology or Person part can be embodied in the form of software product, and the computer software product can be stored in storage medium, such as ROM/RAM, magnetic disc, CD etc., including some instructions are to cause a computer equipment (can be personal computer, service Device, or the network equipment etc.) perform method described in some parts of each embodiment of the invention or embodiment.
The present invention is described in detail above, principle and embodiment party of the specific case used herein to the present invention Formula is set forth, and the explanation of above example is only intended to the method and its core concept for helping to understand the present invention;Meanwhile, it is right In those of ordinary skill in the art, according to the thought of the present invention, change is had in specific embodiments and applications Part, in summary, this specification content should not be construed as limiting the invention.

Claims (8)

1. a kind of visual inquiry method of database, it is characterised in that including:
Visualized graph interface is generated, the visualized graph interface includes exercisable function menu option and basic module, The basic module includes SELECT components, result items list element, Data source table list element, table connection component, condition and set Put component and function component;
According to analysis task type, concatenation, and arrange parameter are carried out to the basic module, it is visual with creation analysis task Change module;
Statement translation is carried out to the visualization model, with the target query language statement sequence of generation;
According to the target query language statement sequence, database is inquired about.
2. the visual inquiry method of database according to claim 1, it is characterised in that described according to analysis task class Type, it is described line statement is entered to the visualization model to turn over after carrying out concatenation, and the step of arrange parameter to basic module Before the step of translating, including:
The parameter region of the basic module is traveled through, the parameter value of the basic module is collected;
The parameter value being collected into is changed into the parameter list of grammaticality.
3. the visual inquiry method of database according to claim 1 or 2, it is characterised in that described to be appointed according to analysis Service type, concatenation is carried out to basic module, and the step of arrange parameter includes:
According to analysis task type, concatenation, and arrange parameter are carried out to the basic module;
During concatenation, according to the syntax rule of target query language, the parameter type between the basic module is judged Whether match;
When the parameter type between the basic module is mismatched, produce alarm and indicate.
4. the visual inquiry method of database according to claim 1 or 2, it is characterised in that described to described visual Change the step of module carries out statement translation, including:
Take out the parameter in parameter list;
The parameter position parameter of taking-up inserted in the target query language sentence of correspondence basic module;
From the generation of internal code BOB(beginning of block), successively carry out, with the target query language statement sequence of generation.
5. a kind of visual query system of database, it is characterised in that including:
Interface generation module, for generating visualized graph interface, the visualized graph interface includes exercisable function dish Uniterming and basic module, the basic module include SELECT components, result items list element, Data source table list element, Table connection component, condition setting component and function component;
Graphical analytic type inquiring structuring module, for according to analysis task type, concatenation to be carried out to the basic module, And arrange parameter, with creation analysis task visualization model;
Query translation module, for carrying out statement translation to the visualization model, with the target query language sentence sequence of generation Row;
Query execution module, for according to the target query language statement sequence, inquiring about database.
6. the visual query system of database according to claim 5, it is characterised in that also including parameter collection mould Block, the parameter region for traveling through the basic module collects the parameter value of the basic module;By the parameter being collected into Value changes into the parameter list of grammaticality.
7. the visual query system of the database according to claim 5 or 6, it is characterised in that the graphical analysis Type inquiring structuring module, including:
Parameter set unit, for according to analysis task type, concatenation, and arrange parameter to be carried out to the basic module;
Execution unit is built, for during concatenation, according to the syntax rule of target query language, judges described basic Whether the parameter type between component matches;
Matching judgment unit, for when the parameter type between the basic module is mismatched, producing alarm and indicating.
8. the visual query system of the database according to claim 5 or 6, it is characterised in that the query translation mould Block, including:
Parameter acquiring unit, for taking out the parameter in parameter list;
Parameter generating unit, the ginseng in target query language sentence for the parameter of taking-up to be inserted to correspondence basic module Numerical digit is put;
Execution unit is translated, for from the generation of internal code BOB(beginning of block), successively carrying out, with the target query language sentence sequence of generation Row.
CN201710427410.8A 2017-06-08 2017-06-08 The visual inquiry method and system of a kind of database Pending CN107169130A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710427410.8A CN107169130A (en) 2017-06-08 2017-06-08 The visual inquiry method and system of a kind of database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710427410.8A CN107169130A (en) 2017-06-08 2017-06-08 The visual inquiry method and system of a kind of database

Publications (1)

Publication Number Publication Date
CN107169130A true CN107169130A (en) 2017-09-15

Family

ID=59824868

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710427410.8A Pending CN107169130A (en) 2017-06-08 2017-06-08 The visual inquiry method and system of a kind of database

Country Status (1)

Country Link
CN (1) CN107169130A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109783549A (en) * 2018-12-29 2019-05-21 成都信息工程大学 Meteorological data visualization discovery system and method, computer, computer program
CN112732744A (en) * 2021-01-12 2021-04-30 重庆长安汽车股份有限公司 Method for efficiently processing CIDAS database based on Tcl/Tk and R languages
CN112799659A (en) * 2021-01-12 2021-05-14 杨飞 Method, device and terminal for automatically generating data interface without programming

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1881208A (en) * 2005-06-14 2006-12-20 联想(北京)有限公司 Construction method for dynamic structured query language statement
US20090138456A1 (en) * 2005-09-14 2009-05-28 International Business Machines Corporation Disabling subsets of query conditions in an abstract query environment
CN102136162A (en) * 2010-12-25 2011-07-27 江西九江供电公司 Power transmission line polling system
CN103093000A (en) * 2013-02-25 2013-05-08 用友软件股份有限公司 Database query modeling system and database query modeling method
US20140025665A1 (en) * 2010-06-04 2014-01-23 Salesforce.Com, Inc. Methods and systems for analyzing a network feed in a multi-tenant database system environment
CN104915341A (en) * 2014-03-10 2015-09-16 中国科学院沈阳自动化研究所 Visual multi-database ETL integration method and system
CN105630874A (en) * 2015-12-18 2016-06-01 贵州大学 Array model-based database system
CN105677681A (en) * 2014-11-21 2016-06-15 北京神州泰岳软件股份有限公司 Data search method and device based on multiple databases

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1881208A (en) * 2005-06-14 2006-12-20 联想(北京)有限公司 Construction method for dynamic structured query language statement
US20090138456A1 (en) * 2005-09-14 2009-05-28 International Business Machines Corporation Disabling subsets of query conditions in an abstract query environment
US20140025665A1 (en) * 2010-06-04 2014-01-23 Salesforce.Com, Inc. Methods and systems for analyzing a network feed in a multi-tenant database system environment
CN102136162A (en) * 2010-12-25 2011-07-27 江西九江供电公司 Power transmission line polling system
CN103093000A (en) * 2013-02-25 2013-05-08 用友软件股份有限公司 Database query modeling system and database query modeling method
CN104915341A (en) * 2014-03-10 2015-09-16 中国科学院沈阳自动化研究所 Visual multi-database ETL integration method and system
CN105677681A (en) * 2014-11-21 2016-06-15 北京神州泰岳软件股份有限公司 Data search method and device based on multiple databases
CN105630874A (en) * 2015-12-18 2016-06-01 贵州大学 Array model-based database system

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109783549A (en) * 2018-12-29 2019-05-21 成都信息工程大学 Meteorological data visualization discovery system and method, computer, computer program
CN112732744A (en) * 2021-01-12 2021-04-30 重庆长安汽车股份有限公司 Method for efficiently processing CIDAS database based on Tcl/Tk and R languages
CN112799659A (en) * 2021-01-12 2021-05-14 杨飞 Method, device and terminal for automatically generating data interface without programming
CN112732744B (en) * 2021-01-12 2023-03-14 重庆长安汽车股份有限公司 Method for efficiently processing CIDAS database based on Tcl/Tk and R languages

Similar Documents

Publication Publication Date Title
CN103020453B (en) Based on the structured electronic patient record generation method of ontology
CN110019555B (en) Relation data semantical modeling method
CN110134724A (en) A kind of the data intelligence extraction and display system and method for Building Information Model
CN105677875A (en) Visual modeling platform based on unified constraint of normal data elements
CN103093000A (en) Database query modeling system and database query modeling method
WO2015010509A1 (en) One-dimensional liner space-based method for implementing trie tree dictionary search
CN107169130A (en) The visual inquiry method and system of a kind of database
CN113378011B (en) Construction method and system of complex product assembly digital twin body
CN104346383A (en) Data access control method and system
Liu Fast industrial product design method and its application based on 3D CAD system
CN106295074B (en) A kind of carrier rocket bay section vibratory response characteristic is quickly analyzed and optimization method
Singh et al. SQL2Neo: Moving health-care data from relational to graph databases
CN109241104A (en) The resolver and its implementation of AISQL in decision type distributed data base system
Zhang et al. A knowledge reuse-based computer-aided fixture design framework
Russo et al. Semantic-driven analysis and classification in architectural heritage
CN108205564A (en) Knowledge hierarchy construction method and system
CN111126961B (en) Full life cycle digital main line service system for complex products
Razafindramintsa et al. Logical services automatic location from eLEL
Gueddoudj et al. Towards a scalable and efficient etl
Rivero et al. A reference architecture for building semantic-web mediators
Pen et al. Comparing HiveQL and MapReduce methods to process fact data in a data warehouse
Ha et al. An Approach to Translating a Database from MySQL to Cassandra
Dong et al. Coordination technology of design data based on data space
Hardy et al. Databases, Data Modeling and Schemas: Databse Development in Metabolomics
Duan et al. Research on inspection feature recognition based on Pro/E

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20170915