CN106446034A - Data visual query language system - Google Patents
Data visual query language system Download PDFInfo
- Publication number
- CN106446034A CN106446034A CN201610781312.XA CN201610781312A CN106446034A CN 106446034 A CN106446034 A CN 106446034A CN 201610781312 A CN201610781312 A CN 201610781312A CN 106446034 A CN106446034 A CN 106446034A
- Authority
- CN
- China
- Prior art keywords
- data
- dvl
- module
- engine module
- model
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9032—Query formulation
- G06F16/90324—Query formulation using system suggestions
- G06F16/90328—Query formulation using system suggestions using search space presentation or visualization, e.g. category or range presentation and selection
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Devices For Executing Special Programs (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data visual query language system. The system comprises a DVL builder, a DVL analysis engine module and a data analysis engine module, wherein the DVL builder builds a DVL statement by a user operation model and a data model; the DVL builder is connected with a data model module, an operation model module and a DVL grammar rule module; the DVL analysis engine module is connected with the DVL builder to analyze the DVL statement to obtain executive plan trees of executive sub-processes; the data analysis engine module executes the executive plan trees of the executive sub-processes one by one according to an executive sequence, and fuses graphic information and data information to generate a graphic data model; and obtained graphic data is transmitted to a visual engine module, and the visual engine module renders the graphic model data into a BI chart visible for a user. According to the system, front-end visual chart display and a back-end data analysis process of the system are subjected to DVL-level isolation, so that complete decoupling of graphic display and back-end data processing is realized and a language-level standard data visual interface can be provided for outside.
Description
Technical field
The invention belongs to data visualization technique field and computer language system regions, be specifically related to data visualization and look into
Ask language system.
Background technology
Use domain model language technology carry out language definition, based on Antlr technology component exploitation, use morphology, grammer,
Semantic analysis technology carries out DVL language parsing and execution.
Graphical data process is generally divided into data statistics, (each figure to show the figure that must have to primitive information
The required descriptive information of display) build, figure renders 3 processes, and data statistics and primitive information build and are often isolated
In two services or assembly, cause system interface species and quantity too much, bring difficulty to system architecture and use.
Two above process can be combined by the DVL using the definition of domain model language technology, externally provides unified language
Interface, uses Antlr technology component to carry out DVL parsing in internal system, thus reaches statistic processes pel building process one
Change, reduce the system external degree of coupling, and promote the adaptability of system.
Content of the invention
It is an object of the invention to provide data visualization query language system, the design simplifying data visualisation system is complicated
Degree, extension complexity and development efficiency, and provide flexibly based on the man-machine interaction mode of language level.
For reaching above-mentioned purpose, technical scheme is as follows：
Data visualization query language system, including：
DVL composer, described is DVL statement by user operation model and data model construction, and described DVL composer connects
Have data module module, operation model module and DVL syntax rule module；
DVL analytics engine module, described DVL analytics engine module is connected with DVL composer and holds to resolve to DVL statement
The executive plan tree of row subprocess；
Also including data analysis engine module, the executive plan tree performing subprocess is pressed by described data analysis engine module
Perform one by one according to execution sequence, merge graphical information and data message, generate Graphical Data Model；
The graph data module of described acquisition delivers to visualization engine module, and described visualization engine module is by graphical model
Data render is user's visible BI chart.
In a preferred embodiment of the invention, described DVL statement includes three sections, graph segments, graph data section sum
According to section, described graph segments describes graphic display mode, and graph data section describes graphics data format, and it is final that data segment describes data
Source.
In a preferred embodiment of the invention, on the premise of user is familiar with DVL statement, user is write DVL language
Sentence, and submission system resolves and perform, returns and represents figure desired by user.
By technique scheme, the invention has the beneficial effects as follows：
The present invention, by way of defining interface language (DVL), provides the knot that software front end is shown and Back end data is processed
Splice grafting mouth, fully achieves the decoupling that Visual Chart is shown and Back end data is processed of software, thus reduces and third party
The integration complexity of system, moving costs between minimizing system.
Standard language DVL is defined for man-machine interaction part, can be by the input self-defining Visual Chart of DVL language
Type and pattern, enhance flexibility and the standard of interactive process.
Brief description
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the accompanying drawing of required use is briefly described, it should be apparent that, the accompanying drawing in describing below is only this
Some examples of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can also root
Obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is overall technology structure chart of the present invention；
Fig. 2 is the Organization Chart of the present invention；
Fig. 3 is the DVL grammer overall construction drawing of the present invention；
Detailed description of the invention
In order to make the present invention realize technological means, creation characteristic, reach purpose and be easy to understand with effect, tie below
Conjunction is specifically illustrating, and the present invention is expanded on further.
Shown in seeing figures.1.and.2, based on the data visualization query language system of domain model language technology, including：
DVL composer, described is DVL statement by user operation model and data model construction, and described DVL composer is connected with data mould
Block module, operation model module and DVL syntax rule module；
DVL analytics engine module, described DVL analytics engine module is connected with DVL composer and holds to resolve to DVL statement
The executive plan tree of row subprocess；
Also including data analysis engine module, the executive plan tree performing subprocess is pressed by described data analysis engine module
Perform one by one according to execution sequence, merge graphical information and data message, generate Graphical Data Model；
The graph data module of described acquisition delivers to visualization engine module, and described visualization engine module is by graphical model
Data render is user's visible BI chart.
Above-mentioned DVL (data visualization query language) composer, this composer provides system in systems in the way of service
DVL constructing function within Tong, this service convergence data model, operation model simultaneously build DVL statement according to DVL syntax rule.
DVL building process is divided into two levels：
1) on the premise of user is familiar with DVL syntax rule, user is write DVL statement, and submission system resolves and performs,
Return and represent figure desired by user.
2) system provides DVL the build tool, is carried out attribute, graph style or number by user according to purpose by interactive interface
Select according to graphic element, carried out structure the submission system parsing of DVL by the build tool according to user operation and syntax rule.
Fusion process logic is as follows：1) first by graph segments in the operation in operation model and DVL and graph data section row
Correspondence, graph segments represents the definition to graph style and corresponding figure display basic parameter of user, for example:It is shown as cake
Figure, and entitled " so-and-so Sales per unit distribution ", graph data section represents the data display mode to this figure for the user
Definition, for example：X-axis shows sales volume data, Y-axis viewing area title etc.；2) data source then selecting according to user, table,
Field, condition, constructs the data segment in DVL, i.e. extracts the stsndard SQL statement needed for this data.
Specifically, DVL syntax rule belongs to the predefined rule of system, is abided by by system user or Third party system connector
Keeping, internal system carries out legitimate verification and parsing according to syntax rule.
DVL language general structure is divided into three sections, i.e. graph segments, graph data section and data segment, wherein graph segments (chart_
Define_clause) describing graphic display mode, graph data section (chart_data_clause) describes graphics data format,
Data segment (sql_stat) describes data and finally originates.Constitute whole DVL language syntax rule by above three sections.
DVL analytics engine module, this engine provides the DVL analytical capabilities of internal system in systems in the way of service,
Its function is by morphology, and grammer and semanteme resolve to subprocess executive plan tree, and this executive plan tree passes through the optimization of this function,
Its execution sequence can take optimum execution sequence in the case that it is logically true.In the interface definition mistake that database data extracts
Cheng Zhong, disparate databases performs in the way of different Visitor objects, it is ensured that the interface to all type of database for the system
The adaptation of rank.Analytics engine service uses Antlr technology component to resolve DVL statement, and wherein resolution rules is by the language of DVL language
Method and morphology definition, specifically the form with morphology and syntactic definition file is supplied to Antlr technology component, Antlr technology component
Grammer and morphology are defined the Basic application that document analysis is based on Java programming language, and DVL analytics engine is to be somebody's turn to do to inherit
The form of java class simultaneously realizes by way of covering method, thus externally provides DVL analysis service.
Data analysis engine module, this engine provides in terms of the subprocess execution of internal system in the mode of service in systems
Draw the execution of tree, including extract data from database, build two mistakes of graphical model data according to graphical information and data message
Journey.
Database extracts the performed SQL statement that stsndard SQL clause is translated as correspondence database type by data procedures, example
As：Mysql, oracle, sqlserver etc..Each type of database all has different parsing definition programs, and this program is morphology
The different successions of syntax parsing basis java class (being generated by Antlr technology component), submit correspondence database to after being parsed
Perform, and return data.
Building graphical model data procedures according to graphical information and data message, this process is by the graphics class in graphical information
Type, figure basic parameter corresponds in the model translation program of different graphic, corresponding interpretive program by graphical display parameter and
Data message is combined, and is output as figure and shows required XML data (graphical model data), submits to visualization engine to carry out
Chart renders.
Visualization engine service module, graphical model data render is Visual Chart by this service, for guaranteeing graphical set
The replaceability of part, model data form and chart components itself are isolated by system.
With reference to Fig. 2, in this figure, capitalized words represents the keyword in DVL, and lower-case portion represents clause；Order in structure
Connecting and representing necessary definitional part, branch's connection represents optional definitional part.Totally be divided into 3 parts, 1) subtype and sample
Formula, 2) chart data form, 3) SQL statement needed for data pick-up, specifically：
Wherein：PLOT and CREATE is DVL keyword, and chart_define_clause is graph style and style definitions
Part, chart_data_clause is graphics data format definitional part, and sql_stat is graph data definition clause's part,
This clause keeps consistent with stsndard SQL grammer.Fig. 2 illustrates this syntactic structure.
The general principle of the present invention and principal character and advantages of the present invention have more than been shown and described.The technology of the industry
Personnel are it should be appreciated that the present invention is not restricted to the described embodiments, and the simply explanation described in above-described embodiment and specification is originally
The principle of invention, without departing from the spirit and scope of the present invention, the present invention also has various changes and modifications, and these become
Change and improvement both falls within scope of the claimed invention.Claimed scope by appending claims and
Equivalent defines.
Claims (3)
1. data visualization query language system, it is characterised in that include：
DVL composer, described is DVL statement by user operation model and data model construction, and described DVL composer is connected with number
According to module, operation model module and DVL syntax rule module；
DVL analytics engine module, described DVL analytics engine module is connected with DVL composer and performs son to resolve to DVL statement
The executive plan tree of process；
Also including data analysis engine module, described data analysis engine module will perform the executive plan tree of subprocess according to holding
Row order performs one by one, merges graphical information and data message, generates Graphical Data Model；
The graph data module of described acquisition delivers to visualization engine module, and described visualization engine module is by graphical model data
It is rendered into user's visible BI chart.
2. data visualization query language system according to claim 1, it is characterised in that described DVL statement includes three
Section, graph segments, graph data section and data segment, described graph segments describes graphic display mode, and graph data section describes figure figurate number
According to form, data segment describes data and finally originates.
3. data visualization query language system according to claim 1, it is characterised in that be familiar with DVL statement user
On the premise of, user is write DVL statement, and submission system resolves and performs, return and represent figure desired by user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610781312.XA CN106446034A (en) | 2016-08-30 | 2016-08-30 | Data visual query language system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610781312.XA CN106446034A (en) | 2016-08-30 | 2016-08-30 | Data visual query language system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106446034A true CN106446034A (en) | 2017-02-22 |
Family
ID=58090901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610781312.XA Pending CN106446034A (en) | 2016-08-30 | 2016-08-30 | Data visual query language system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106446034A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107341021A (en) * | 2017-07-14 | 2017-11-10 | 中南大学 | The software network of large complicated software belt restraining logical attribute represents, storage and retrieval method |
| CN108268621A (en) * | 2018-01-09 | 2018-07-10 | 上海大学 | Data analysis, excavation, rendering and method for visualizing based on big data |
| CN109933622A (en) * | 2019-02-26 | 2019-06-25 | 美林数据技术股份有限公司 | A kind of data visualisation system and implementation method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5255363A (en) * | 1990-06-19 | 1993-10-19 | Mentor Graphics Corporation | Graph-based programming system and associated method |
| CN103092621A (en) * | 2013-03-08 | 2013-05-08 | 广州市西美信息科技有限公司 | Chart creating method and device |
| CN103677763A (en) * | 2012-08-30 | 2014-03-26 | 中国科学院软件研究所 | Graphical programming source file storage and analytic method |
| CN103761288A (en) * | 2014-01-14 | 2014-04-30 | 国家电网公司 | Visual chart custom generation system and visual chart custom generation method |
-
2016
- 2016-08-30 CN CN201610781312.XA patent/CN106446034A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5255363A (en) * | 1990-06-19 | 1993-10-19 | Mentor Graphics Corporation | Graph-based programming system and associated method |
| CN103677763A (en) * | 2012-08-30 | 2014-03-26 | 中国科学院软件研究所 | Graphical programming source file storage and analytic method |
| CN103092621A (en) * | 2013-03-08 | 2013-05-08 | 广州市西美信息科技有限公司 | Chart creating method and device |
| CN103761288A (en) * | 2014-01-14 | 2014-04-30 | 国家电网公司 | Visual chart custom generation system and visual chart custom generation method |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107341021A (en) * | 2017-07-14 | 2017-11-10 | 中南大学 | The software network of large complicated software belt restraining logical attribute represents, storage and retrieval method |
| CN107341021B (en) * | 2017-07-14 | 2020-05-15 | 中南大学 | Software network representation, storage and retrieval method for large complex software with constraint logic attribute |
| CN108268621A (en) * | 2018-01-09 | 2018-07-10 | 上海大学 | Data analysis, excavation, rendering and method for visualizing based on big data |
| CN109933622A (en) * | 2019-02-26 | 2019-06-25 | 美林数据技术股份有限公司 | A kind of data visualisation system and implementation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8429525B2 (en) | Method and system for reversible design tree transformations | |
| Haber et al. | Engineering delta modeling languages | |
| US20080244541A1 (en) | Code translator and method of automatically translating modeling language code to hardware language code | |
| CN107545093B (en) | The technological design and assembly of spacecraft execute interactive system and exchange method | |
| CN106446034A (en) | Data visual query language system | |
| CN109522008A (en) | A kind of block chain intelligence contract construction method | |
| CN113157723A (en) | SQL access method for Hyperridge Fabric | |
| CN106681727A (en) | Modelica external function graphical editing system and implementation method thereof | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN117112608A (en) | Antlr 4-based database statement conversion method and device | |
| CN114036183A (en) | Data ETL processing method, device, equipment and medium | |
| CN110889013A (en) | Data association method, device, server and storage medium based on XML | |
| CN113655996A (en) | Enterprise-level system generation method based on demand model | |
| CN116126304B (en) | XML-based extended Lustre code generation method | |
| US20220405297A1 (en) | Apparatus and method for filtering data from or across different analytics platforms | |
| Mitchell et al. | Flower: Viewing data flow in er diagrams | |
| Kashlev et al. | Coercion approach to the shimming problem in scientific workflows | |
| US20170139970A1 (en) | Method for updating a record in a database by a data- processing device | |
| Hamie et al. | Navigation expressions in object-oriented modelling | |
| Schneider et al. | A role language to interpret multi-formalism system of systems models | |
| TW201327432A (en) | Scalable order data validation method | |
| Cuinat et al. | Specedit: Projectional editing for tla+ specifications | |
| CN112163031B (en) | Graph data extraction method based on thought guide graph | |
| TWI648682B (en) | Software system generating system | |
| TWI638276B (en) | Bom-based structuralized software design specification generating method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 710065 Shaanxi hi tech Zone, Xi'an science and technology zone, No. 68 Xi'an Software Park, Han Yun Ge C501 Applicant after: Merrill Lynch data technology Limited by Share Ltd Address before: 710065 Shaanxi hi tech Zone, Xi'an science and technology zone, No. 68 Xi'an Software Park, Han Yun Ge C501 Applicant before: XI'AN MERIT DATA TECHNOLOGY CO., LTD. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170222 |