CN109992262A - A kind of structured query language (SQL) graphical operation method - Google Patents
A kind of structured query language (SQL) graphical operation method Download PDFInfo
- Publication number
- CN109992262A CN109992262A CN201910234884.XA CN201910234884A CN109992262A CN 109992262 A CN109992262 A CN 109992262A CN 201910234884 A CN201910234884 A CN 201910234884A CN 109992262 A CN109992262 A CN 109992262A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- field
- completed
- merging
- 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
- 238000000034 method Methods 0.000 title claims abstract description 12
- 238000001914 filtration Methods 0.000 claims abstract description 19
- 238000006116 polymerization reaction Methods 0.000 claims abstract description 14
- 238000005457 optimization Methods 0.000 claims abstract 2
- 230000000379 polymerizing effect Effects 0.000 claims description 3
- 238000010422 painting Methods 0.000 description 30
- 238000010586 diagram Methods 0.000 description 14
- 238000011017 operating method Methods 0.000 description 3
- 238000005314 correlation function Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000009954 braiding Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000006073 displacement reaction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of structured query language (SQL) graphical operation methods, including " filtering ", " association ", " polymerization ", " duplicate removal ", " merging ", " object table " 6 steps, the optional logical operation of each field part in tables of data is completed by " filtering " step；The Correlation Criteria selection of each field in each tables of data is completed by " association " step；The logical operation between each field is completed by " polymerization " step；The optimization of querying condition in query statement is completed by " duplicate removal " step；The merging of each field in each tables of data is completed by " merging " step；The pot-life of object table in query statement is completed by " object table " step.The method provided through the invention makes the business personnel that will not write SQL that can also inquire required data.Simultaneously by patterned way operation, make developer need not expend a large amount of learning cost and time cost can efficient, simple mode get required data.
Description
Technical field
The present invention relates to a kind of operating method, especially a kind of structured query language (SQL) graphical operation method belongs to
In computer information technology field.
Background technique
SQL query sentence is broadly divided into two parts: data manipulation language (DML) and Data Definition Language (DDL).It looks into
It askes and more new command (SELECT, UPDATE, DELETE, INSERT INTO) constitutes the part DML of SQL.Data Definition Language
(DDL) part (CREATE DATABASE, ALTERDATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE,
CREATEINDEX, DROP INDEX) creation or Delete Table.
One or more tables are generally comprised in one database, inquire data from database to realize, developer
Or business personnel needs to write SQL manually, (such as Connection inquiring, multiple subquery, multilist especially in complicated data query
Inquiry etc.), need professional to write extremely complex SQL statement manually.In order to write complicated SQL statement, business personnel
Or developer needs to expend a large amount of learning cost and time cost.Therefore, a kind of simple patterned there is an urgent need to have
SQL statement authoring tool allows developer or business personnel only to need simple graphic operation that can complete complicated SQL statement
It writes.
Summary of the invention
A kind of structured query language (SQL) figure is provided it is an object of the invention to overcome above-mentioned the deficiencies in the prior art
Shape operating method realizes quickly writing for complicated SQL statement.
To achieve the above object, the technical solution adopted by the present invention is that:
A kind of structured query language (SQL) graphical operation method, mainly comprises the steps that
(1) it filters: using mouse drag " filtering " icon into painting canvas, a data is then pulled from tables of data list
For table into painting canvas, mouse chooses icon data table in painting canvas, and " filtering " icon can show that 4 can connect dot immediately, uses
Mouse, which is arbitrarily chosen one of dot and pinned, does not put (MouseDown), is immediately generated an interim line segment in painting canvas at this time
(Path1), the starting point of line segment is the coordinate (x of dot1, y1), the terminal point coordinate of line segment is mouse mobile (MouseMove)
Coordinate (x2, y2), mouse is moved at filtering icon to be unclamped mouse (MouseUp) immediately, and interim line segment (Path1) can be by immediately
It deletes, one can be regenerated with dot coordinate (x1, y1) it is starting point coordinate, to filter icon central coordinate of circle (x3, y3) it is eventually
The fixation line segment of point.
Double click " filtering " icon pops up filter condition editor, can add tables of data filter condition, use mouse
It clicks at left side " please select ", all fields (field 1- field n) of tables of data can be listed.When choosing one of field, meeting
The optional logical operator list for visiting field is generated according to field type immediately, the operation between each condition is completed by mouse.
(2) it is associated with: pulling " association " icon from icon list into painting canvas using mouse, then arranged from tables of data
Two tables of data are pulled in table into painting canvas, mouse chooses two tables of data to be connected with " association " icon respectively, uses mouse
" association " icon is double-clicked, correlation function editor is popped up, the single field of each tables of data is selected to pass through " Zuo Guanlian ", " right pass
Connection ", " interior association " three kinds of modes connect two tables of data, can add more field items by " addition is associated with " button
Part.
(3) it polymerize: pulls " polymerization " icon from icon list into painting canvas using mouse, then arranged from tables of data
A tables of data is pulled in table to be connected into painting canvas, and by the tables of data with " object table ", with double click " polymerization " icon,
Polymerizing condition, the first a certain field in selection tables of data are edited, " maximum value " is then selected, " minimum value ", " summation ", " puts down
It is a certain in mean ", " sum ", click " addition " button, a line can be increased newly, to the column of other fields do " maximum value " or
" minimum value " or " summation " or the operation of " average " or " sum ".
(4) duplicate removal: " duplicate removal " icon is pulled from icon list into painting canvas using mouse, is then arranged from tables of data
A tables of data is pulled in table to be connected into painting canvas, and by the tables of data with " duplicate removal " icon, is used double click " duplicate removal "
Icon, editable duplicate removal condition.
(5) merge: pulling " merging " icon from icon list into painting canvas using mouse, then arranged from tables of data
A tables of data is pulled in table to be connected into painting canvas, and by the tables of data with " merging ", using double click " merging " icon,
Editable merges condition.
(6) object table: using mouse drag " object table " icon into painting canvas, a number then is pulled from tables of data list
According to table into painting canvas, and the tables of data is connected with " object table ", using double click " object table " icon, edits object table
Pot-life.
Preferably, " filtering ", " association ", " polymerization ", " duplicate removal ", " merging ", " object table " in above-mentioned steps can be with
Group is combined into more complicated inquiry, and the result of such as " association " can execute the operation of " merging " again, and the result of " merging " can be held again
The operation of row " duplicate removal ".
The technical program mainly solves developer's quick search data from database in the prior art and needs to compile manually
The problem of writing complicated SQL query statement realizes the quick braiding of complicated SQL query statement by a kind of patterned operating method
It writes.
Beneficial effects of the present invention: (1) business personnel that the method provided through the invention makes will not to write SQL can also be with
Inquire required data.(2) by patterned way operate, make developer need not expend a large amount of learning cost and when
Between cost can efficient, simple mode get required data.
Detailed description of the invention
Fig. 1 is each tables of data schematic diagram in database of the present invention；
Fig. 2 is the schematic diagram that a tables of data is chosen in Fig. 1；
Fig. 3 is the field information schematic diagram of tables of data in Fig. 2；
Fig. 4 is the schematic diagram of each step of the present invention；
Fig. 5 is to execute filtration step schematic diagram after choosing tables of data；
Fig. 6 is schematic diagram when filtration step executes；
Fig. 7 is field optional logical operation schematic diagram when executing filtration step；
Fig. 8 is the schematic diagram selected after a kind of filter condition；
Fig. 9 is complete single filter condition schematic diagram；
Figure 10 is the schematic diagram for executing associated steps；
Figure 11 is the schematic diagram for executing polymerization procedure；
Figure 12 is the schematic diagram for executing duplicate removal step；
Figure 13 is to execute the schematic diagram for merging step.
Specific embodiment
In conjunction with the accompanying drawings, the present invention is further explained in detail, and these attached drawings are simplified schematic diagram, only with
The mode of signal illustrates the principle of the present invention.
As shown in Figure 1, tables of data 1 indicates several data in some database (relevant database) to tables of data n
Table stores several datas in table.One of them are chosen using mouse, mouse is pinned not put and is drawn in painting canvas, and painting canvas is vertical
An icon is generated, indicates that the tables of data being just dragged in, display effect are as shown in Figure 2.Using double click icon, can look into
The field relevant information seen in the tables of data (field name, field type, field are explained, as shown in Figure 3).Fig. 4 indicates data
The alternate list of table optional function, wherein " filtering " can carry out " WHERE " operation to table, " association " can complete " JOIN " to table
Operation, " polymerization " table can be completed " SUN, AVGCOUNT, MAX, MIN " etc. operation, " duplicate removal " table can be completed " DISCOUT " grasp
Make, " merging " can complete " UNION " operation to table, and " object table " produces an interim table.
A specific embodiment of the invention is as follows:
Step " filtering ": it using mouse drag " filtering " icon into painting canvas, is then pulled from tables of data list (Fig. 1)
One tables of data is into painting canvas, and mouse chooses icon data table 1 in painting canvas, and icon can show 4 immediately can connect dot (such as
Shown in Fig. 5), one of dot is arbitrarily chosen using mouse and is pinned and does not put (MouseDown), is immediately generated in painting canvas at this time
One interim line segment (Path1), the starting point of line segment are the coordinate (x of dot1,y1), the terminal point coordinate of line segment is mobile for mouse
(MouseMove) coordinate (x2, y2), mouse is moved at filtering icon unclamps mouse (MouseUp), interim line segment immediately
(Path1) it can be deleted immediately, one can be regenerated with dot coordinate (x1, y1) it is starting point coordinate, to filter the icon center of circle
Coordinate (x3, y3) be terminal fixation line segment.
Double click filters icon, pops up filter condition editor, tables of data filter condition can be added, such as Fig. 6 institute
Show, is clicked at left side " please select " with mouse, all fields (field 1- field n) of tables of data 1 can be listed.Choose one of them
When field, the optional logical operator list for visiting field can be generated according to field type immediately, such as data type field can be into
Row " being greater than ", " being less than ", " being more than or equal to ", " being less than or equal to ", " being equal to ", " being not equal to ", " non-empty ", the filter operations such as " sky ",
As shown in Figure 7.(such as when selection " being greater than " or " being less than " or " being more than or equal to " or " being less than or equal to " or " being equal to " or " being not equal to "
Fig. 8), right side can show Optional Field list, choose one of them to show as shown in figure 9, herein while supporting customized defeated
Enter value, including character string, time, numerical value etc..Fig. 9 illustrates a complete single filter condition, it indicates to need to inquire
The operation of " WHERE ' field 1 '=' field 2 ' " in tables of data.When selection " non-empty " or " sky ", may also indicate that one it is complete
Single filter condition, it indicate need to inquire in tables of data " 1 ' IS NOT NULL of WHERE ' field " or " WHERE ' field
The operation of 1 ' IS NULL ".
Click " adding conditional " button, more filter conditions can be added, between condition and condition may be selected " AND " or
The operation of " OR ".
Step " association ": using mouse from " association " icon is pulled in icon list (Fig. 4) into painting canvas, then from
Two tables of data are pulled in tables of data list (Fig. 1) into painting canvas, mouse chooses tables of data 1 and tables of data 2 respectively, with " association "
Icon is connected, and using double click " association " icon, popping up correlation function editor can choose number as shown in Figure 10
According to the single field of table 1 and the single field of tables of data 2 by " Zuo Guanlian ", " right association ", " interior association " three kinds of modes by two
A table connection.More field conditions can be added by " addition association " button.
Step " polymerization ": using mouse from " polymerization " icon is pulled in icon list (Fig. 4) into painting canvas, then from
A tables of data is pulled in tables of data list (Fig. 1) to be connected into painting canvas, and by " tables of data 1 " with " object table ", uses mouse
" polymerization " icon is double-clicked, then editable polymerizing condition (as shown in figure 11), the first a certain field in selection tables of data select
" maximum value ", " minimum value ", " summation ", " average ", a certain in " sum ", click " addition " button, can increase a line newly,
" maximum value " or " minimum value " or " summation " or the operation of " average " or " sum " are done to the column of other fields.
Step " duplicate removal ": using mouse from " duplicate removal " icon is pulled in icon list (Fig. 4) into painting canvas, then from
A tables of data is pulled in tables of data list (Fig. 1) to be connected into painting canvas, and by " tables of data 1 " with " duplicate removal " icon, is used
Double click " duplicate removal " icon, editable duplicate removal condition indicate to need to go the execution of field 1 in tables of data 1 as shown in figure 12
It operates again.
Step " merging ": using mouse from " merging " icon is pulled in icon list (Fig. 4) into painting canvas, then from
A tables of data is pulled in tables of data list (Fig. 1) to be connected into painting canvas, and by " tables of data 1 " with " icon ", uses mouse
" merging " icon is double-clicked, editable merges condition, and as shown in figure 13, the optional list in left side is all fields in " tables of data 1 ",
Right side Optional Field is all fields in " tables of data 2 ", and the field 1 that left side chooses needs to merge, right side, which is chosen, to be needed to merge
Field 2, indicate the field 2 in the field 1 and tables of data 2 in tables of data 1 merging into a column.
Step " object table ": it using mouse drag " object table " icon into painting canvas, is then dragged from tables of data list (Fig. 1)
A tables of data is dragged to be connected into painting canvas, and by " tables of data 1 " with " object table ", using double click " object table " icon,
The editable object table pot-life.
It should be understood that the above are a kind of specific embodiment of situation of the invention, " filtering " in above-mentioned steps,
" association ", " polymerization ", " duplicate removal ", " merging ", " object table " can be combined into more complicated inquiry, and those skilled in the art exists
The simple change for other combinations made under the enlightenment of above-mentioned specific embodiment or displacement belong to protection of the invention
Range.
Claims (3)
1. a kind of structured query language (SQL) graphical operation method, it is characterised in that: including " filtering ", " association ", " gather
Conjunction ", " duplicate removal ", " merging ", " object table " 6 steps are completed each the optional of field part in tables of data by " filtering " step and are patrolled
Collect operation；The Correlation Criteria selection of each field in each tables of data is completed by " association " step；It is completed by " polymerization " step each
Logical operation between field；The optimization of querying condition in query statement is completed by " duplicate removal " step；Pass through " merging " step
Complete the merging of each field in each tables of data；The pot-life of object table in query statement is completed by " object table " step.
2. a kind of structured query language (SQL) graphical operation method as described in claim 1, it is characterised in that: described
" filtering " step can add tables of data filter condition, according to all fields for listing tables of data, choose one of field
When, the optional logical operator list for visiting field can be generated according to field type immediately, is completed between each condition by mouse
Operation；Described " association " step can choose the single field of each tables of data and pass through " Zuo Guanlian ", " right association ", " interior association " three
Kind mode connects tables of data, can add more field conditions by " addition is associated with "；In described " polymerization " step, compile
Polymerizing condition, the first a certain field in selection tables of data are collected, " maximum value " is then selected, " minimum value ", " summation ", " is averaged
It is number ", a certain in " sum ", " maximum value " or " minimum value " or " summation " or " average " or " always are done to the column of other fields
The operation of number "；Each tables of data can be completed to merge by certain merging condition in described " merging " step.
3. a kind of structured query language (SQL) graphical operation method as described in claim 1, it is characterised in that: described
" filtering ", " association ", " polymerization ", " duplicate removal ", " merging ", " object table " can be combined into more complicated query statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910234884.XA CN109992262A (en) | 2019-03-27 | 2019-03-27 | A kind of structured query language (SQL) graphical operation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910234884.XA CN109992262A (en) | 2019-03-27 | 2019-03-27 | A kind of structured query language (SQL) graphical operation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109992262A true CN109992262A (en) | 2019-07-09 |
Family
ID=67131643
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910234884.XA Pending CN109992262A (en) | 2019-03-27 | 2019-03-27 | A kind of structured query language (SQL) graphical operation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109992262A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114707472A (en) * | 2022-03-11 | 2022-07-05 | 北京字跳网络技术有限公司 | Method and device for field merging and electronic equipment |
| CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN105160023A (en) * | 2015-09-30 | 2015-12-16 | 深圳市巧捷万端云计算有限公司 | Graphical data query processing method based on cloud server |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN109408540A (en) * | 2018-08-24 | 2019-03-01 | 周宁 | A kind of visualization SQL query system and method |
| CN109522321A (en) * | 2018-11-15 | 2019-03-26 | 北京锐安科技有限公司 | A kind of data base query method, device, server and storage medium |
-
2019
- 2019-03-27 CN CN201910234884.XA patent/CN109992262A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN105160023A (en) * | 2015-09-30 | 2015-12-16 | 深圳市巧捷万端云计算有限公司 | Graphical data query processing method based on cloud server |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN109408540A (en) * | 2018-08-24 | 2019-03-01 | 周宁 | A kind of visualization SQL query system and method |
| CN109522321A (en) * | 2018-11-15 | 2019-03-26 | 北京锐安科技有限公司 | A kind of data base query method, device, server and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114707472A (en) * | 2022-03-11 | 2022-07-05 | 北京字跳网络技术有限公司 | Method and device for field merging and electronic equipment |
| CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7461077B1 (en) | Representation of data records | |
| US7908266B2 (en) | Systems and methods for automatically creating an SQL join expression | |
| EP0583053B1 (en) | Graphical database access | |
| US7581189B2 (en) | Dynamically generating a database report during a report building process | |
| US5761654A (en) | Memory structure and method for tuning a database statement using a join-tree data structure representation, including selectivity factors, of a master table and detail table | |
| JP2819517B2 (en) | Method and system for performing a database query | |
| US6470335B1 (en) | System and method for optimizing the structure and display of complex data filters | |
| CN109992262A (en) | A kind of structured query language (SQL) graphical operation method | |
| CN101727322B (en) | Method and device for optimizing bill of material management interface | |
| JPH05224907A (en) | Graphic inquiry system | |
| US20120159427A1 (en) | System and method for extracting uml models from legacy applications | |
| US9448705B2 (en) | Configuring graphical displays | |
| JPH06208491A (en) | Optimization method for inquiry to related database management system and syntax analytical method of result | |
| JPH0675738A (en) | Apparatus and method for dialog box display | |
| WO1992016903A1 (en) | Database management system graphical query front end | |
| DE10103574A1 (en) | Method for executing a statement in a computer to manipulate data in a data store linked to the computer receives the statement with aggregated ratings while searching in a database administration system. | |
| US6418426B1 (en) | Enhanced tree control for multiple item selection | |
| CN110442620A (en) | A kind of big data is explored and cognitive approach, device, equipment and computer storage medium | |
| JP2662130B2 (en) | System and method for searching a database | |
| Griffin et al. | A framework for implementing hypothetical queries | |
| Moro et al. | TVQL-temporal versioned query language | |
| CN110135797A (en) | Product design Template Manager method, the network terminal and the device with store function | |
| US20020040357A1 (en) | Configurable pattern recognition and filtering tool | |
| US20110022639A1 (en) | Hierarchy Nodes Derived Based On Parent/Child Foreign Key And/Or Range Values On Parent Node | |
| CN111966705A (en) | Interactive data modeling method |
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 |
Application publication date: 20190709 |
|
| RJ01 | Rejection of invention patent application after publication |