CN109408540A - A kind of visualization SQL query system and method - Google Patents
A kind of visualization SQL query system and method Download PDFInfo
- Publication number
- CN109408540A CN109408540A CN201810973649.XA CN201810973649A CN109408540A CN 109408540 A CN109408540 A CN 109408540A CN 201810973649 A CN201810973649 A CN 201810973649A CN 109408540 A CN109408540 A CN 109408540A
- Authority
- CN
- China
- Prior art keywords
- query
- interface
- inquiry
- sql
- parameter
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of visualization SQL query system and method, system mainly includes that computer storage, PC display screen, database, configuration management interface, inquiry preservation interface, inquiry selection interface and SQL query visualization use interface.It is mainly comprised the steps that using the method for visualization SQL query system and 1) establishes database.2) selected data source name.3) edit and debug SQL statement.4) query argument is set.5) inquiry saves interface and the corresponding relationship of the query argument of setting and query argument and parameter to be replaced is saved as an inquiry file.6) the SQL query visualization calls query argument using interface, carries out visual query.The present invention supports the parametrization management and viewable access of SQL query, significantly reduces using threshold, improves ease for use, realizes the preservation and visualization multiplexing of name inquiry.
Description
Technical field
The present invention relates to data base querying field, specifically a kind of visualization SQL query system and method.
Background technique
Database Systems common at present are mainly relevant database.Structured query language (SQL) is relation data
The major way of library inquiry has the series of advantages such as powerful, flexibility is high, and support programs, but still there is following lack
Point:
1. ease for use is poor: structured query language can only be used by professional, and difficulty is larger.
2. multiplexing is difficult: structured query language does not support visualization to be multiplexed, require to rewrite every time SQL statement or
It opens SQL editing machine to modify, use cost is high.
Summary of the invention
Present invention aim to address problems of the prior art.
To realize the present invention purpose and the technical solution adopted is that a kind of such, visualization SQL query system, it is main to wrap
Computer storage, PC display screen, database, configuration management interface, inquiry preservation interface, inquiry selection interface and SQL is included to look into
It askes visualization and uses interface.
Computer storage storing data library, configuration management interface, inquiry save interface, inquiry selection interface and
SQL query visualization uses the data at interface.
The PC display screen shows that configuration management interface, inquiry save interface, inquiry selection interface and SQL query visualization
Use interface.
The configuration management interface mainly include data source capability module, basic SQL statement editing module, inquiry button,
Parameter replacement module, save button and opening button.
The data source capability module has data source capability list.The data source capability list longitudinal arrangement data source
Title.The data source is the database file saved in the database.Database has several database files.Every number
Unique data source name is corresponded to according to library file.
The data source capability module links the corresponding data of the data source name by selecting the data source name
Library file.
The basic SQL statement editing module editor and operation SQL statement.
The structure of the SQL statement are as follows: Select display field FROM table name word where querying condition order by sequence
Field group by grouping field.
The display field include table name filename or be arranged successively and with comma be spaced apart multiple table name filenames.
The basic SQL statement editing module selectes parameter to be replaced in the SQL statement of editor.After selected, described
The right and left of parameter to be replaced adds square brackets.
The SQL statement of the inquiry button debugging editor.
The parameter replacement module mainly includes newly-increased button, delete button and parameter display module.
The newly-increased button increases query argument.
The delete button Delete query parameter.
The parameter display module shows English name, Chinese and the sequence of positions of query argument.Sequence of positions with
Positive integer sequence indicates.
The save button links the inquiry and saves interface.
The opening button link queries selection interface.
The inquiry saves interface and mainly includes Query Name editor module, publication address display module, illustrate column, is optional
Query argument display module has selected query argument display module and query argument save button.
The title of Query Name editor module editor's query argument.
The publication address display module shows the publication address of query argument.Issuing address shows query argument at one
Position in tree directory structure.
It is described illustrate column show the descriptive matter in which there be illustrated to query argument or for sky.
The optional query argument display module shows all alternative parameters.
It is described that query argument display module has been selected to show the alternative parameter selected.
The query argument save button saves the title of the Query Name editor module editor.
The inquiry selection interface has inquiry selective listing.Query argument described in the inquiry selective listing longitudinal arrangement
Title.
The title that the inquiry selection interface links the query argument by selecting the title of the query argument corresponds to
Database file.
The SQL query visualization calls the configuration management interface, inquiry to save interface and inquiry selection using interface
The data at interface.
The SQL query visualization mainly includes all name enquiry modules, text query module and time using interface
Enquiry module.
All name enquiry modules show the title of all query arguments.
The text query module meets the database file of condition by inputting keyword query.
The condition is to contain keyword in database file.
The time inquiring module includes time started selective listing, end time selective listing and time offset selection
List.
The time offset selective listing includes the left drop-down list of time offset and the right drop-down list of time offset.
Longitudinal chronological time offset in the left drop-down list of time offset.
Time offset right drop-down list longitudinal arrangement chronomere.The chronomere includes year, season, the moon, week
And/or day.
The time offset selective listing is modified the time according to time offset and chronomere, to calculate
Statistical indicator.
The time offset selective listing meets the database of condition by input starting and end time inquiry
File.
A method of using the visualization SQL query system, mainly comprise the steps that
1) database is established, and the computer storage is written into the data in database.
2) data source capability module selected data source name, to link the corresponding database of the data source name.
3) SQL statement is edited in basic SQL statement editing module.After the completion of editor, inquiry button is clicked to editor's
SQL statement is debugged.If debugging result shows that SQL statement is wrong, SQL statement is modified according to miscue, if errorless,
Debugging is completed.
4) query argument is set.
After debugging successfully, the parameter to be replaced in the SQL statement of editor is selected, and add in the right and left of parameter to be replaced
Add square brackets.
Query argument is defined in parameter replacement module, and formulates the correspondence of query argument and parameter position sequence to be replaced
Relationship.
It is established according to parameter to be replaced, query argument and SQL statement and inquires main table.
The main table management of inquiry creates query statement.
Whether it is empty and Chinese that the gauge outfit of the main table of the inquiry mainly includes field name, field name type, field name
Description.
5) inquiry saves interface and protects the query argument of setting and query argument and the corresponding relationship of parameter to be replaced
An inquiry file is saved as, and repeats step 1 to step 4, until being transferred to step 6 after saving several inquiry files.
6) the SQL query visualization calls query argument using interface, carries out visual query, key step is as follows:
7.1) query argument, i.e., the input inquiry keyword in query name input module are determined.
7.2) the SQL query parameter at configuration management interface is called in SQL query visualization using interface.
7.3) corresponding contents for naming querying condition are inquired in main table at configuration management interface with incoming parameter replacement, and are produced
New SQL statement.
7.4) new SQL statement is transmitted to execution method by configuration management interface, executes new SQL statement.Execution method root
According to the corresponding relationship of alternative parameter and parameter position sequence to be replaced, uses the mode of Transfer Parameters to replace with alternative parameter and correspond to
Square brackets in parameter to be replaced.
7.5) SQL query visualization uses interface display query result.
The solution have the advantages that unquestionable.The present invention provides a kind of machines of programming mode multiplexing SQL statement
System, improves software development efficiency and maintainability.Meanwhile the present invention supports the parametrization management of SQL query and visualization to visit
It asks, significantly reduces using threshold, improve ease for use, realize the preservation and visualization multiplexing of name inquiry.Branch of the present invention
Business personnel is held with visual means using SQL query, reduces the dependence to software vendor.
Detailed description of the invention
Fig. 1 is data source capability interface;
Fig. 2 is SQL statement editor and parameter definition interface;
Fig. 3 is that SQL query names interface;
Fig. 4 is that SQL query saves interface;
Fig. 5 is that SQL query visualization uses interface.
Specific embodiment
Below with reference to embodiment, the invention will be further described, but should not be construed the above-mentioned subject area of the present invention only
It is limited to following embodiments.Without departing from the idea case in the present invention described above, according to ordinary skill knowledge and used
With means, various replacements and change are made, should all include within the scope of the present invention.
Embodiment 1:
Referring to Fig. 1 to Fig. 5, a kind of visualization SQL query system applied to electric power networks mainly includes that computer stores
Device, PC display screen, database, configuration management interface, inquiry save interface, inquiry selection interface and SQL query visualization and use
Interface.
Computer storage storing data library, configuration management interface, inquiry save interface, inquiry selection interface and
SQL query visualization uses the data at interface.
The PC display screen shows that configuration management interface, inquiry save interface, inquiry selection interface and SQL query visualization
Use interface.
The configuration management interface mainly include data source capability module, basic SQL statement editing module, inquiry button,
Parameter replacement module, save button and opening button.
The data source capability module has data source capability list.The data source capability list longitudinal arrangement data source
Title.The data source is the database file saved in the database.Database has several database files.Every number
Unique data source name is corresponded to according to library file.
In the database include grid operation data related data, mainly have: operation of power networks year report, operation of power networks
Moon sheet, electric network data table, power plant's tables of data, holding tables of data, office data of powering, occupy a narrow space Hydro-Thermal Systems data etc..
The data source capability module links the corresponding data of the data source name by selecting the data source name
Library file.
The data source name mainly includes SDC system data center, D5000 water adjusting system, D5000 state estimation system
System, new TMR system, operating analysis system, SDC system and D5000 system etc..
The basic SQL statement editing module editor and operation SQL statement.
The structure of the SQL statement are as follows: Select display field FROM table name word where querying condition order by sequence
Field group by grouping field.
The display field include table name filename or be arranged successively and with comma be spaced apart multiple table name filenames.
The basic SQL statement editing module selectes parameter to be replaced in the SQL statement of editor.After selected, described
The right and left of parameter to be replaced adds square brackets.
The SQL statement of the inquiry button debugging editor.
The parameter replacement module mainly includes newly-increased button, delete button and parameter display module.
The newly-increased button increases query argument.
The delete button Delete query parameter.
The parameter display module shows English name, Chinese and the sequence of positions of query argument.Sequence of positions with
Positive integer sequence indicates.
The save button links the inquiry and saves interface.
The opening button link queries selection interface.
The inquiry saves interface and mainly includes Query Name editor module, publication address display module, illustrate column, is optional
Query argument display module has selected query argument display module and query argument save button.
The title of Query Name editor module editor's query argument.
The publication address display module shows the publication address of query argument.Publication address refers to name inquiry one
Position in a tree directory structure, the directory tree is convenient for tissue and checks name inquiry, can edit in publication.
Illustrate that column refers to the descriptive matter in which there being illustrated to name inquiry, understands query function, the column convenient for user
It can be sky.
The optional query argument display module shows all alternative parameters.
It is described that query argument display module has been selected to show the alternative parameter selected.
The query argument save button saves the title of the Query Name editor module editor.
The inquiry selection interface has inquiry selective listing.Query argument described in the inquiry selective listing longitudinal arrangement
Title.
The query argument title specifically includes that grid operation data inquiry, operating analysis, small Hydro-Thermal Systems etc..
The title that the inquiry selection interface links the query argument by selecting the title of the query argument corresponds to
Database file.
The SQL query visualization calls the configuration management interface, inquiry to save interface and inquiry selection using interface
The data at interface.
The SQL query visualization mainly includes all name enquiry modules, text query module and time using interface
Enquiry module.
All name enquiry modules show the title of all query arguments.
The text query module meets the database file of condition by inputting keyword query.
The text query module polls to database file be shown in drop-down list, and the database file have
There is check box.By selecting check box, selected database file can be exported simultaneously.
The condition is to contain keyword in database file.
The time inquiring module includes time started selective listing, end time selective listing and time offset selection
List.
The time offset selective listing includes the left drop-down list of time offset and the right drop-down list of time offset.
Longitudinal chronological time offset in the left drop-down list of time offset.The time offset is negative whole
Number.
Time offset right drop-down list longitudinal arrangement chronomere.The chronomere includes year, season, the moon, week
And/or day.
The time offset selective listing is modified according to above-mentioned selection, is referred to calculate the statistics such as year-on-year, ring ratio
Mark.
The time offset selective listing meets the database of condition by input starting and end time inquiry
File.
As shown in figure 5, having check box before Query Name.After check box is chosen, multiple queries title pair can be inquired simultaneously
The data answered.
Embodiment 2:
A method of electric power networks are inquired using the visualization SQL query system, mainly include following step
It is rapid:
1) electric power networks operation data library is established, and the computer storage is written into the data in database.
2) data source capability module selected data source name, to link the corresponding database of the data source name.
3) SQL statement is edited in basic SQL statement editing module.After the completion of editor, inquiry button is clicked to editor's
SQL statement is debugged.If debugging result shows that SQL statement is wrong, SQL statement is modified according to miscue, if errorless,
Debugging is completed.
4) query argument is set.
After debugging successfully, the parameter to be replaced in the SQL statement of editor is selected, and add in the right and left of parameter to be replaced
Add square brackets.
Query argument is defined in parameter replacement module, and formulates the correspondence of query argument and parameter position sequence to be replaced
Relationship.
It is established according to parameter to be replaced, query argument and SQL statement and inquires main table.
The main table management of inquiry creates query statement.
Whether it is empty and Chinese that the gauge outfit of the main table of the inquiry mainly includes field name, field name type, field name
Description.
5) inquiry saves interface and protects the query argument of setting and query argument and the corresponding relationship of parameter to be replaced
An inquiry file is saved as, and repeats step 1 to step 4, until being transferred to step 6 after saving several inquiry files.
6) the SQL query visualization calls query argument using interface, carries out visual query, key step is as follows:
6.1) query argument, i.e., the input inquiry keyword in query name input module are determined.
6.2) the SQL query parameter at configuration management interface is called in SQL query visualization using interface.
6.3) corresponding contents for naming querying condition are inquired in main table at configuration management interface with incoming parameter replacement, and are produced
New SQL statement.
6.4) new SQL statement is transmitted to execution method by configuration management interface, executes new SQL statement.Execution method root
According to the corresponding relationship of alternative parameter and parameter position sequence to be replaced, uses the mode of Transfer Parameters to replace with alternative parameter and correspond to
Square brackets in parameter to be replaced.
6.5) SQL query visualization uses interface display query result.
Claims (8)
1. a kind of visualization SQL query system, it is characterised in that: mainly include computer storage, PC display screen, database,
The configuration management interface, inquiry save interface, inquiry selection interface and SQL query visualization and use interface;
Computer storage storing data library, configuration management interface, inquiry save interface, inquiry selection interface and SQL and look into
Ask the data that visualization uses interface;
The PC display screen shows that configuration management interface, inquiry save interface, inquiry selection interface and SQL query visualization and use
Interface.
The configuration management interface mainly includes data source capability module, basic SQL statement editing module, inquiry button, parameter
Replacement module, save button and opening button;
The data source capability module has data source capability list;The data source capability list longitudinal arrangement dataSource link
Claim;
The data source capability module links the corresponding data library text of the data source name by selecting the data source name
Part;
The basic SQL statement editing module editor and operation SQL statement;
The basic SQL statement editing module selectes parameter to be replaced in the SQL statement of editor;After selected, described wait replace
Change the right and left addition square brackets of parameter;
The SQL statement of the inquiry button debugging editor;
The parameter replacement module mainly includes newly-increased button, delete button and parameter display module;
The newly-increased button increases query argument;
The delete button Delete query parameter;
The parameter display module shows English name, Chinese and the sequence of positions of query argument;
The save button links the inquiry and saves interface;
The opening button link queries selection interface;
The inquiry saves interface and mainly includes Query Name editor module, publication address display module, illustrates column, optional inquiry
Parameter display module has selected query argument display module and query argument save button;
The title of Query Name editor module editor's query argument;
The publication address display module shows the publication address of query argument;The publication address shows query argument at one
Position in tree directory structure;
It is described illustrate column show the descriptive matter in which there be illustrated to query argument or for sky;
The optional query argument display module shows all alternative parameters;
It is described that query argument display module has been selected to show the alternative parameter selected;
The query argument save button saves the title of the Query Name editor module editor;
The inquiry selection interface has inquiry selective listing;The name of query argument described in the inquiry selective listing longitudinal arrangement
Claim;
The inquiry selection interface links the corresponding number of title of the query argument by selecting the title of the query argument
According to library file;
The SQL query visualization calls the configuration management interface, inquiry to save interface and inquiry selection interface using interface
Data;
The SQL query visualization mainly includes all name enquiry modules, text query module and time inquiring using interface
Module;
All name enquiry modules show the title of all query arguments;
The text query module meets the database file of condition by inputting keyword query;
The condition is to contain keyword in database file.
The time inquiring module includes time started selective listing, end time selective listing and time offset alternative column
Table;
The time offset selective listing includes the left drop-down list of time offset and the right drop-down list of time offset;
Longitudinal chronological time offset in the left drop-down list of time offset;
Time offset right drop-down list longitudinal arrangement chronomere;
The time offset selective listing is by selecting time offset and chronomere according to time complexity curve is carried out, to count
Calculate statistical indicator;
The time offset selective listing meets the database file of condition by input starting and end time inquiry.
2. a kind of visualization SQL query system according to claim 1, it is characterised in that: the data source is to be stored in
Database file in database;Database has several database files;Each database file corresponds to unique data
Source name.
3. a kind of visualization SQL query system according to claim 1 or 2, it is characterised in that: sequence of positions is with positive integer
Sequence indicates.
4. a kind of visualization SQL query system according to claim 1 or 2, it is characterised in that: the knot of the SQL statement
Structure are as follows: Select display field FROM table name word where querying condition order by sort field group by grouping field;
The display field include table name filename or be arranged successively and with comma be spaced apart multiple table name filenames.
5. a kind of visualization SQL query system according to claim 1 or 2, it is characterised in that: the chronomere includes
Year, season, the moon, week and/or day.
6. a kind of use the method for visualizing SQL query system described in claim 1 to 5, which is characterized in that mainly include following
Step:
1) database is established, and the computer storage is written into the data in database;
2) data source capability module selected data source name, to link the corresponding database of the data source name;
3) SQL statement is edited in basic SQL statement editing module;After the completion of editor, inquiry button is clicked to the SQL language of editor
Sentence is debugged;If debugging result shows that SQL statement is wrong, SQL statement is modified according to miscue and is debugged if errorless
It completes;
4) query argument is set;
After debugging successfully, the parameter to be replaced in the SQL statement of editor is selected, and in the right and left addition side of parameter to be replaced
Bracket;
Query argument is defined in parameter replacement module, and formulates the corresponding pass of query argument and parameter position sequence to be replaced
System;
It is established according to parameter to be replaced, query argument and SQL statement and inquires main table;
5) inquiry saves interface and saves as the query argument of setting and query argument and the corresponding relationship of parameter to be replaced
One inquiry file, and step 1 is repeated to step 4, until being transferred to step 6 after saving several inquiry files;
6) the SQL query visualization calls query argument using interface, carries out visual query.
7. a kind of method using visualization SQL query system according to claim 6, which is characterized in that SQL query can
It is as follows depending on changing the key step for calling query argument to carry out visual query using interface:
1) query argument, i.e., the input inquiry keyword in query name input module are determined;
2) the SQL query parameter at configuration management interface is called in SQL query visualization using interface;
3) corresponding contents for naming querying condition are inquired in main table at configuration management interface with incoming parameter replacement, and are produced new
SQL statement;
4) new SQL statement is transmitted to execution method by configuration management interface, executes new SQL statement;Execution method is according to replacement
The corresponding relationship of parameter and parameter position sequence to be replaced uses the mode of Transfer Parameters to replace corresponding side with alternative parameter and includes
Parameter to be replaced in number;
5) SQL query visualization uses interface display query result.
8. a kind of method using visualization SQL query system according to claim 6 or 7, it is characterised in that: described to look into
Ask main table management creation query statement;
The gauge outfit of the main table of inquiry mainly includes field name, field name type, whether field name is empty and Chinese describes.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810973649.XA CN109408540A (en) | 2018-08-24 | 2018-08-24 | A kind of visualization SQL query system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810973649.XA CN109408540A (en) | 2018-08-24 | 2018-08-24 | A kind of visualization SQL query system and method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109408540A true CN109408540A (en) | 2019-03-01 |
Family
ID=65464379
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810973649.XA Pending CN109408540A (en) | 2018-08-24 | 2018-08-24 | A kind of visualization SQL query system and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109408540A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109992262A (en) * | 2019-03-27 | 2019-07-09 | 杭州城市大数据运营有限公司 | A kind of structured query language (SQL) graphical operation method |
CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
CN110222071A (en) * | 2019-06-06 | 2019-09-10 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, server and storage medium |
CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
CN113961588A (en) * | 2021-10-27 | 2022-01-21 | 北京科杰科技有限公司 | Big data SQL program design method based on configurable parameters |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
CN106919606A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of method and system that SQL query condition is realized based on tree construction |
CN106919623A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | SQL query method and system |
CN106934707A (en) * | 2015-12-30 | 2017-07-07 | 航天信息软件技术有限公司 | A kind of method of sales invoice account table statistics |
CN107656926A (en) * | 2016-07-24 | 2018-02-02 | 平安科技(深圳)有限公司 | Data query method and device based on sql |
-
2018
- 2018-08-24 CN CN201810973649.XA patent/CN109408540A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106919606A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of method and system that SQL query condition is realized based on tree construction |
CN106919623A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | SQL query method and system |
CN106934707A (en) * | 2015-12-30 | 2017-07-07 | 航天信息软件技术有限公司 | A kind of method of sales invoice account table statistics |
CN107656926A (en) * | 2016-07-24 | 2018-02-02 | 平安科技(深圳)有限公司 | Data query method and device based on sql |
CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
Non-Patent Citations (2)
Title |
---|
邵增珍: ""支持重用的可视化通用查询界面的生成"", 《计算机工程》 * |
黄波: ""GeoSQL:一种可视化空间扩展SQL查询语言"", 《武汉测绘科技大学学报》 * |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109992262A (en) * | 2019-03-27 | 2019-07-09 | 杭州城市大数据运营有限公司 | A kind of structured query language (SQL) graphical operation method |
CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
CN109992589B (en) * | 2019-04-11 | 2020-04-10 | 北京启迪区块链科技发展有限公司 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
CN110222071A (en) * | 2019-06-06 | 2019-09-10 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, server and storage medium |
CN110222071B (en) * | 2019-06-06 | 2021-11-02 | 上海达梦数据库有限公司 | Data query method, device, server and storage medium |
CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
CN113961588A (en) * | 2021-10-27 | 2022-01-21 | 北京科杰科技有限公司 | Big data SQL program design method based on configurable parameters |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109408540A (en) | A kind of visualization SQL query system and method | |
US5745897A (en) | Method and system for compiling management information base specifications | |
CN101958987B (en) | Method and system for dynamically converting telecommunications service data | |
CN108197237B (en) | Visual data acquisition and display system | |
CN103235820B (en) | Date storage method and device in a kind of group system | |
CN102541529A (en) | Query page generating device and method | |
CN103927331B (en) | Data querying method, data querying device and data querying system | |
CN112015413A (en) | Programming-free data visualization Web display system and implementation method thereof | |
CN110597842B (en) | Service data query method and system | |
IL239717A (en) | System and method for distributed database query engines | |
CN103744647A (en) | Java workflow development system and method based on workflow GPD | |
CN105550332B (en) | A kind of provenance graph querying method based on the double-deck index structure | |
CN103257852B (en) | The method and apparatus that a kind of development environment of distribution application system is built | |
CN107622055A (en) | A kind of quick method for realizing data, services issue | |
CN100498787C (en) | Report generating method, equipment and system | |
CN111125440B (en) | Monad-based persistent layer composite condition query method and storage medium | |
CN108431766A (en) | Method and system for object-oriented/functional language to be mapped to database language | |
Kharlamov et al. | A semantic approach to polystores | |
CN112363809A (en) | System and method for realizing micro-service link collection based on kubernets | |
CN102654878A (en) | Data operation method for distributed database in embedded system and board card | |
CN104714973A (en) | Method and device for processing query statements | |
CN113515564A (en) | Data access method, device, equipment and storage medium based on J2EE | |
CN109213780A (en) | A kind of inquiry name and multiplexing support system and method | |
CN117349368A (en) | Cross-database data real-time synchronous task management system and method based on Flink | |
CN103744678A (en) | Method for determining static function call relations based on register transfer language |
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 |