CN103093000A - Database query modeling system and database query modeling method - Google Patents
Database query modeling system and database query modeling method Download PDFInfo
- Publication number
- CN103093000A CN103093000A CN2013100591098A CN201310059109A CN103093000A CN 103093000 A CN103093000 A CN 103093000A CN 2013100591098 A CN2013100591098 A CN 2013100591098A CN 201310059109 A CN201310059109 A CN 201310059109A CN 103093000 A CN103093000 A CN 103093000A
- Authority
- CN
- China
- Prior art keywords
- sql statement
- name
- user
- statement
- data base
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database query modeling system which comprises an interface generating unit, an information acquisition unit, and a statement splicing unit, wherein the interface generating unit is used for generating a visualization graphical interface which is provided with operable function menu options, the information acquisition unit is used for selecting a function menu option according to first selection operation of a user to determine a list to be queried and acquire the list name and the field name of the list, the information acquisition unit is also used for selecting field information to be queried in the selected list according to second selection operation of the user, the statement splicing unit is used for taking the list name and the field name as a FROM part of a structured query language (SQL) statement and taking the field information as a SELECT part of the SQL statement and splicing the FROM part and the SELECT part together to form a corresponding SQL statement. The invention further provides a database query modeling method. According to the database query modeling system and the database query modeling method, a standard SQL statement can be generated automatically by means of graphical set, and writing difficulty of the SQL statement is reduced.
Description
Technical field
The present invention relates to the data base querying technical field, in particular to a kind of data base querying modeling and a kind of data base querying modeling method.
Background technology
Database has become indispensable necessary component in ripe software systems, and to the query manipulation of database, in Database Systems, the simplest especially, the most frequently used operation.But along with improving constantly of business event complexity, the query manipulation of database is also become to become increasingly complex, and this just need to write more complicated query sentence of database, and namely SQL statement, visit database.Such as, in a SQL statement, the nested a plurality of subqueries of meeting, perhaps have multiple annexation between a plurality of tables, and the inquiry field is had particular restriction etc.When writing the SQL statement of such complexity, even sophisticated data base administrator also can make a mistake unavoidably, for the primary database user who is not familiar with SQL statement, that is confused especially.
Therefore, how generating easily complicated SQL statement, is the major issue that accessing database need to solve.
Summary of the invention
The present invention just is being based on the problems referred to above, has proposed a kind of new technical scheme, the generative process of SQL statement can be constructed in patterned mode, automatically generates, and replaces hand-written.The mistake that can not only avoid hand-written SQL statement to occur also can improve the SQL statement accuracy simultaneously, also makes non-data base administrator also can facilitate left-hand seat, the query manipulation of performing database.
In view of this, the present invention proposes a kind of data base querying modeling, comprising: the interface generation unit, be used for generating visualized graph interface, be provided with exercisable function menu option on described visualized graph interface; Information acquisition unit is used for selecting operation according to user's first, selects in described function menu option, need to determine the table of inquiry, and obtain table name and the field name of this table, and select operation according to user's second, need to select the field information of inquiry in selected table; The statement concatenation unit is used for described table name and described field name with the SELECT part of described field information as SQL statement, being spliced into corresponding SQL statement as the FROM part of SQL statement.In this technical scheme, by generating visualized graph interface, thereby the user only needs information such as query objects, just can automatically generate the SQL statement of standard, has reduced the difficulty that the user writes SQL statement, has improved and has write efficient.
In technique scheme, preferably, described information acquisition unit by select in database the physics table, select the metadata that his-and-hers watches are described or the interrogation model selecting to have created need to determine the table that inquire about.
In technique scheme, preferably, also comprise: the contextual definition unit, be used in the situation that the number of selected table is a plurality of, define the annexation of a plurality of selected tables; Wherein, described statement concatenation unit splices the extremely FROM part of described SQL statement according to described annexation with described table name and described field name.In this technical scheme, according to the annexation of a plurality of selected tables, can determine the incidence relation such as quote between the field etc. of a plurality of tables, thereby be used for the generation of SQL statement.
In technique scheme, preferably, also comprise: the conditional definition unit, be used for the conditional definition operation according to the user, define corresponding restrictive condition; Wherein, described statement concatenation unit is also with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.In this technical scheme, restrictive condition can also be added in the SQL statement of generation.
In technique scheme, preferably, described restrictive condition comprise following at least one or a combination set of: sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
According to another aspect of the invention, also proposed a kind of data base querying modeling method, having comprised: step 201, generate visualized graph interface, be provided with exercisable function menu option on described visualized graph interface; Step 202 is selected operation according to user's first, selects in described function menu option, need determining the table of inquiry, and obtains table name and the field name of this table; Step 204 is selected operation according to user's second, need to select the field information of inquiry in selected table; Step 206 with described table name and the described field name FROM part as SQL statement, with the SELECT part of described field information as SQL statement, is spliced into corresponding SQL statement.In this technical scheme, by generating visualized graph interface, thereby the user only needs information such as query objects, just can automatically generate the SQL statement of standard, has reduced the difficulty that the user writes SQL statement, has improved and has write efficient.
In technique scheme, preferably, described definite step of the table of inquiry that needs comprises: the interrogation model that the metadata that the physics table in the selection database, selection his-and-hers watches are described or selection have created.
In technique scheme, preferably, described step 204 also comprises: when the number of selected table when being a plurality of, also define the annexation of a plurality of selected tables; And described step 206 comprises: according to described annexation, described table name and described field name are spliced the extremely FROM part of described SQL statement.In this technical scheme, according to the annexation of a plurality of selected tables, can determine the incidence relation such as quote between the field etc. of a plurality of tables, thereby be used for the generation of SQL statement.
In technique scheme, preferably, described step 204 also comprises: the conditional definition operation according to the user defines corresponding restrictive condition; And described step 206 also comprises: with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.In this technical scheme, restrictive condition can also be added in the SQL statement of generation.
In technique scheme, preferably, described restrictive condition comprise following at least one or a combination set of: sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
By above technical scheme, the generative process of SQL statement can be constructed in patterned mode, automatically generate, replace hand-written.The mistake that can not only avoid hand-written SQL statement to occur also can improve the SQL statement accuracy simultaneously, also makes non-data base administrator also can facilitate left-hand seat, the query manipulation of performing database.
Description of drawings
Fig. 1 shows the block diagram of data base querying modeling according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of data base querying modeling method according to an embodiment of the invention;
Fig. 3 shows the process flow diagram that generates according to an embodiment of the invention the stsndard SQL statement;
Fig. 4 shows the structural representation of the functional module that generates according to an embodiment of the invention the stsndard SQL statement.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.Need to prove, in the situation that do not conflict, the application's embodiment and the feature in embodiment can make up mutually.
A lot of details have been set forth in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not subjected to the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of data base querying modeling according to an embodiment of the invention.
As shown in Figure 1, the data base querying modeling 100 according to an embodiment of the invention, comprising: interface generation unit 102, be used for generating visualized graph interface, and be provided with exercisable function menu option on described visualized graph interface; Information acquisition unit 104, be used for selecting operation according to user's first, select in described function menu option, need to determine the table of inquiry, and obtain table name and the field name of this table, and select operation according to user's second, need to select the field information of inquiry in selected table; Statement concatenation unit 106 is used for described table name and described field name with the SELECT part of described field information as SQL statement, being spliced into corresponding SQL statement as the FROM part of SQL statement.In this technical scheme, by generating visualized graph interface, thereby the user only needs information such as query objects, just can automatically generate the SQL statement of standard, has reduced the difficulty that the user writes SQL statement, has improved and has write efficient.
In technique scheme, preferably, described information acquisition unit 104 by select in database the physics table, select the metadata that his-and-hers watches are described or the interrogation model selecting to have created need to determine the table that inquire about.
In technique scheme, preferably, also comprise: contextual definition unit 108, be used in the situation that the number of selected table is a plurality of, define the annexation of a plurality of selected tables; Wherein, described statement concatenation unit 106 splices the extremely FROM part of described SQL statement according to described annexation with described table name and described field name.In this technical scheme, according to the annexation of a plurality of selected tables, can determine the incidence relation such as quote between the field etc. of a plurality of tables, thereby be used for the generation of SQL statement.
In technique scheme, preferably, also comprise: conditional definition unit 110, be used for the conditional definition operation according to the user, define corresponding restrictive condition; Wherein, described statement concatenation unit 106 is also with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.In this technical scheme, restrictive condition can also be added in the SQL statement of generation.
In technique scheme, preferably, described restrictive condition comprise following at least one or a combination set of: sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
Fig. 2 shows the process flow diagram of data base querying modeling method according to an embodiment of the invention.
As shown in Figure 2, data base querying modeling method according to an embodiment of the invention comprises: step 201, generate visualized graph interface, and be provided with exercisable function menu option on described visualized graph interface; Step 202 is selected operation according to user's first, selects in described function menu option, need determining the table of inquiry, and obtains table name and the field name of this table; Step 204 is selected operation according to user's second, need to select the field information of inquiry in selected table; Step 206 with described table name and the described field name FROM part as SQL statement, with the SELECT part of described field information as SQL statement, is spliced into corresponding SQL statement.In this technical scheme, by generating visualized graph interface, thereby the user only needs information such as query objects, just can automatically generate the SQL statement of standard, has reduced the difficulty that the user writes SQL statement, has improved and has write efficient.
In technique scheme, preferably, described definite step of the table of inquiry that needs comprises: the interrogation model that the metadata that the physics table in the selection database, selection his-and-hers watches are described or selection have created.
In technique scheme, preferably, described step 204 also comprises: when the number of selected table when being a plurality of, also define the annexation of a plurality of selected tables; And described step 206 comprises: according to described annexation, described table name and described field name are spliced the extremely FROM part of described SQL statement.In this technical scheme, according to the annexation of a plurality of selected tables, can determine the incidence relation such as quote between the field etc. of a plurality of tables, thereby be used for the generation of SQL statement.
In technique scheme, preferably, described step 204 also comprises: the conditional definition operation according to the user defines corresponding restrictive condition; And described step 206 also comprises: with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.In this technical scheme, restrictive condition can also be added in the SQL statement of generation.
In technique scheme, preferably, described restrictive condition comprise following at least one or a combination set of: sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
Fig. 3 shows the process flow diagram that generates according to an embodiment of the invention the stsndard SQL statement.
As shown in Figure 3, the flow process that generates according to an embodiment of the invention the stsndard SQL statement comprises:
The first step, the table that selection will be inquired about is equivalent to the FROM part in the stsndard SQL statement.Table can be one, also can be many.The table of the definition here is not limited to a physics table of database, can also be the metadata that his-and-hers watches are described, and comprises table name and field name.Can also be an interrogation model that has created, so just can easily build nested subquery.
Second step, the condition of contact of definition list.Based on the first step, the table information of selection, if many tables need each table of definition annexation each other, such as interior connection, left connection, right connection, full connection etc.The annexation of the table that we can select this in step, the information of the table of selecting in conjunction with the first step is spliced to the FROM part of stsndard SQL statement, according to the syntax rule of stsndard SQL, a plurality of tables separate with comma, for each table is got an alias, separate with the space, another name is optional certainly.Separate with comma between table name and field name, adopt " table name. field name " form.
In the 3rd step, the field that selection will be inquired about is equivalent to the SELECT part in the stsndard SQL statement.Based on the table information that the first step has been selected, this step, the field information inside option table.Our field information that need to inquire about namely, adopt " table. field " form define.Similarly, separate with comma between a plurality of fields, can get another name for each field, separate with the space, optional.This step operating result is spliced to the SELECT part of stsndard SQL statement.
The 4th step, the definition restrictive condition, the WHERE that is equivalent to the stsndard SQL statement reaches part afterwards.For example can define sortord, SQL function etc.This step can also define some parameters according to user's needs, when carrying out inquiry, is inputted by the user; Can also define some macro-variables, when carrying out inquiry, get the value of macro-variable.
In the 5th step, generate the stsndard SQL statement that meets the SQL syntax rule.
It is to be noted: in above step, the first step must option table.Next, the condition of contact of definition list, the field that selection will be inquired about, definition does not have certain ordinal relation in these several steps of restrictive condition, who first after whom can, last, based on the operation in several steps of front, generate the SQL statement of standard.If only have a table, one step of condition of contact of definition list, can omit, if there is no restrictive condition, one step of definition restrictive condition also can omit, but selects one step of inquiry field, must must have, and can not omit.
Corresponding to above-mentioned steps, as shown in Figure 4, be the structural representation that generates according to an embodiment of the invention the functional module of stsndard SQL statement, comprising:
The table selector switch: be used for generating SQL statement, corresponding table message part, splicing is in the from back.Realize that principle is:
From graphic user interface, obtain table name and another name information, the centre separates with the space, separates with comma between a plurality of tables, wherein, calls not essential.Then, these information are combined into character string, shape is as: from table name 1 another name 1, table name 2 another names 2.
The table connector: be used for defining the annexation between a plurality of tables, if only have a table, this step can omit.Realize principle: based on the table that the first step is selected, this step can be chosen by graphical interfaces the annexation of table, and the field that is used for connection.Such as: the left connection table 2 of table 1, on field list 1. fields 1 and table 2. field 2.The SQL that risks is table 1 left join table 2 on table 1. field 1=table 2. field 2.
Field picker: be used for the field that selection will be inquired about, splicing is in the select back, and this step is based on the table of first step selection.Realize that principle is: field name and another name from the table that graphic user interface obtains to choose, the centre separates with the space, separates with comma between a plurality of fields, and another name can omit.Then field information is combined into character string, shape such as select table 1. field name 1 another name 1, table 2. field name 2 another names 2.
Restrictive condition definition device: be used for defining restrictive condition, splicing is in the where back.Realize that principle is: obtain the left operand of definite condition from graphic user interface, operational character and right operand.For example: table 1. field 1=table 2. field 2.
The SQL splicing: with the character string in former steps, according to select, from, the order of where is stitched together, and forms a complete SQL statement.In conjunction with above several steps, can generate a stsndard SQL statement, as follows:
Select table 1. field 1 another name 1, table 2. field 2 another name 2 from table 1 left join table 2 on
Table 1. field 1=table 2. field 2where table 1. field 1=table 2. field 2.
The SQL checker: verify whether spliced SQL statement meets the SQL syntax gauge, such as table name, whether field name is legal etc.
SQL statement maker: export spliced SQL character string.
More than be described with reference to the accompanying drawings technical scheme of the present invention, realized following beneficial effect:
1, by patterned mode, generate accurately, simply and easily complicated SQL statement.
2, SQL statement, the setting of support parameter and macro-variable supports the user at run mode, and SQL statement is controlled.
3, support the verification of SQL statement, guarantee the accuracy of SQL statement execution result.
The above is only the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a data base querying modeling, is characterized in that, comprising:
The interface generation unit is used for generating visualized graph interface, is provided with exercisable function menu option on described visualized graph interface;
Information acquisition unit is used for selecting operation according to user's first, selects in described function menu option, need to determine the table of inquiry, and obtain table name and the field name of this table, and select operation according to user's second, need to select the field information of inquiry in selected table;
The statement concatenation unit is used for described table name and described field name with the SELECT part of described field information as SQL statement, being spliced into corresponding SQL statement as the FROM part of SQL statement.
2. data base querying modeling according to claim 1, is characterized in that, described information acquisition unit by select in database the physics table, select the metadata that his-and-hers watches are described or the interrogation model selecting to have created need to determine the table that inquire about.
3. data base querying modeling according to claim 1 and 2, is characterized in that, also comprises:
The contextual definition unit is used in the situation that the number of selected table is a plurality of, defines the annexation of a plurality of selected tables;
Wherein, described statement concatenation unit splices the extremely FROM part of described SQL statement according to described annexation with described table name and described field name.
4. data base querying modeling according to claim 1 and 2, is characterized in that, also comprises:
The conditional definition unit is used for the conditional definition operation according to the user, defines corresponding restrictive condition;
Wherein, described statement concatenation unit is also with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.
5. data base querying modeling according to claim 4, is characterized in that, described restrictive condition comprise following at least one or a combination set of:
Sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
6. a data base querying modeling method, is characterized in that, comprising:
Step 201 generates visualized graph interface, is provided with exercisable function menu option on described visualized graph interface;
Step 202 is selected operation according to user's first, selects in described function menu option, need determining the table of inquiry, and obtains table name and the field name of this table;
Step 204 is selected operation according to user's second, need to select the field information of inquiry in selected table;
Step 206 with described table name and the described field name FROM part as SQL statement, with the SELECT part of described field information as SQL statement, is spliced into corresponding SQL statement.
7. data base querying modeling method according to claim 6, is characterized in that, described definite step of the table of inquiry that needs comprises:
The interrogation model that the metadata that physics table in the selection database, selection his-and-hers watches are described or selection have created.
8. according to claim 6 or 7 described data base querying modeling methods, is characterized in that, described step 204 also comprises: when the number of selected table when being a plurality of, also define the annexation of a plurality of selected tables; And
Described step 206 comprises: according to described annexation, described table name and described field name are spliced the extremely FROM part of described SQL statement.
9. according to claim 6 or 7 described data base querying modeling methods, is characterized in that, described step 204 also comprises: the conditional definition operation according to the user defines corresponding restrictive condition; And
Described step 206 also comprises: with WHERE and afterwards the part of described restrictive condition splicing to described SQL statement.
10. data base querying modeling method according to claim 9, is characterized in that, described restrictive condition comprise following at least one or a combination set of:
Sortord, SQL function, be used for when query manipulation by the custom parameter of user's input, be used for utilizing when the query manipulation macro-variable of value wherein.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013100591098A CN103093000A (en) | 2013-02-25 | 2013-02-25 | Database query modeling system and database query modeling method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013100591098A CN103093000A (en) | 2013-02-25 | 2013-02-25 | Database query modeling system and database query modeling method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103093000A true CN103093000A (en) | 2013-05-08 |
Family
ID=48205565
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013100591098A Pending CN103093000A (en) | 2013-02-25 | 2013-02-25 | Database query modeling system and database query modeling method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103093000A (en) |
Cited By (41)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN105653277A (en) * | 2015-12-29 | 2016-06-08 | 上海建坤信息技术有限责任公司 | Method for querying appointed field data of data table under simplified JAVA program, multi-table conjunctive query method under simplified JAVA program and statistical query method under simplified JAVA program |
| CN106293891A (en) * | 2015-06-12 | 2017-01-04 | 交通银行股份有限公司 | Multidimensional investment target measure of supervision |
| CN106777076A (en) * | 2016-12-13 | 2017-05-31 | 广东金赋科技股份有限公司 | A kind of SQL limits inquiry clause generation method and combinational logic filter |
| CN106919623A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | SQL query method and system |
| CN107169130A (en) * | 2017-06-08 | 2017-09-15 | 贵州优联博睿科技有限公司 | The visual inquiry method and system of a kind of database |
| CN107506442A (en) * | 2017-08-24 | 2017-12-22 | 中国银行股份有限公司 | The modeling method and device of a kind of model |
| CN107644097A (en) * | 2017-09-29 | 2018-01-30 | 北京酷我科技有限公司 | A kind of SLQ sentence generation methods |
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN108829884A (en) * | 2018-06-27 | 2018-11-16 | 中国建设银行股份有限公司 | data mapping method and device |
| CN108920566A (en) * | 2018-06-21 | 2018-11-30 | 吉林亿联银行股份有限公司 | Operating method, device and the equipment of a kind of pair of SQLite database |
| CN108984623A (en) * | 2018-06-14 | 2018-12-11 | 东软集团股份有限公司 | Data query conditions generation method, device, storage medium and electronic equipment |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109872265A (en) * | 2019-02-28 | 2019-06-11 | 山东浪潮云信息技术有限公司 | A kind of visual government affairs service data analysis method |
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN109992262A (en) * | 2019-03-27 | 2019-07-09 | 杭州城市大数据运营有限公司 | A kind of structured query language (SQL) graphical operation method |
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110019314A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团湖南有限公司 | Dynamic data packaging method, client and server-side based on data item analysis |
| CN110019371A (en) * | 2017-07-19 | 2019-07-16 | 诺沃皮尼奥内技术股份有限公司 | Database search system and method |
| CN110083650A (en) * | 2019-04-25 | 2019-08-02 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of data-query interfaces automatic generation method and system based on metadata self-discovery |
| CN110109947A (en) * | 2017-12-28 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus for extracting data |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN110633331A (en) * | 2019-09-12 | 2019-12-31 | 金蝶蝶金云计算有限公司 | Method, system and related equipment for extracting data in relational database |
| CN110750553A (en) * | 2019-09-02 | 2020-02-04 | 成都市知用科技有限公司 | Method for self-defining export of data in service management system |
| CN110807042A (en) * | 2018-07-20 | 2020-02-18 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN110851426A (en) * | 2019-11-19 | 2020-02-28 | 重庆华龙网海数科技有限公司 | Data DNA visualization relation analysis system and method |
| CN111552688A (en) * | 2020-03-18 | 2020-08-18 | 北京达佳互联信息技术有限公司 | Data export method and device and electronic equipment |
| CN111639078A (en) * | 2020-05-25 | 2020-09-08 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and readable storage medium |
| CN111694551A (en) * | 2020-06-02 | 2020-09-22 | 北京乾元大通技术有限公司 | Cloud property development platform |
| CN111767266A (en) * | 2020-05-15 | 2020-10-13 | 杭州传化智能制造科技有限公司 | Entity contact model design method and device, computer equipment and storage medium |
| CN111813799A (en) * | 2020-07-23 | 2020-10-23 | 德清云岫科技有限公司 | Database query statement generation method and device, computer equipment and storage medium |
| CN112199387A (en) * | 2020-11-16 | 2021-01-08 | 广州速威智能系统科技有限公司 | Method and system for processing database query statement |
| CN112380293A (en) * | 2020-12-11 | 2021-02-19 | 上海中通吉网络技术有限公司 | Method and device for processing database and table data |
| CN112434058A (en) * | 2020-11-24 | 2021-03-02 | 武汉虹信技术服务有限责任公司 | Data interaction method based on Java and MySQL and computer readable medium |
| CN112506952A (en) * | 2020-12-11 | 2021-03-16 | 中信银行股份有限公司 | Data inquiry device and data inquiry method |
| CN112632110A (en) * | 2021-01-06 | 2021-04-09 | 上海合合信息科技股份有限公司 | Data extraction method and device for automatically generating query statement |
| CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
| CN112860725A (en) * | 2021-02-02 | 2021-05-28 | 浙江大华技术股份有限公司 | SQL automatic generation method and device, storage medium and electronic equipment |
| CN115422167A (en) * | 2022-09-27 | 2022-12-02 | 北京柏睿数据技术股份有限公司 | Cross-data source database view visualization construction method and system |
| CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101788996A (en) * | 2009-11-19 | 2010-07-28 | 山东浪潮齐鲁软件产业股份有限公司 | User-defined searching method |
-
2013
- 2013-02-25 CN CN2013100591098A patent/CN103093000A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101788996A (en) * | 2009-11-19 | 2010-07-28 | 山东浪潮齐鲁软件产业股份有限公司 | User-defined searching method |
Cited By (56)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN106293891A (en) * | 2015-06-12 | 2017-01-04 | 交通银行股份有限公司 | Multidimensional investment target measure of supervision |
| CN106293891B (en) * | 2015-06-12 | 2020-08-04 | 交通银行股份有限公司 | Multidimensional investment index monitoring method |
| CN106919623A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | SQL query method and system |
| CN105653277A (en) * | 2015-12-29 | 2016-06-08 | 上海建坤信息技术有限责任公司 | Method for querying appointed field data of data table under simplified JAVA program, multi-table conjunctive query method under simplified JAVA program and statistical query method under simplified JAVA program |
| CN106777076A (en) * | 2016-12-13 | 2017-05-31 | 广东金赋科技股份有限公司 | A kind of SQL limits inquiry clause generation method and combinational logic filter |
| CN106777076B (en) * | 2016-12-13 | 2020-05-05 | 广东金赋科技股份有限公司 | SQL limited query clause generation method and combinational logic filter |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN107169130A (en) * | 2017-06-08 | 2017-09-15 | 贵州优联博睿科技有限公司 | The visual inquiry method and system of a kind of database |
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN107679056B (en) * | 2017-06-25 | 2021-03-02 | 平安科技（深圳）有限公司 | Method for generating SQL (structured query language) statement, electronic device and readable storage medium |
| CN110019371A (en) * | 2017-07-19 | 2019-07-16 | 诺沃皮尼奥内技术股份有限公司 | Database search system and method |
| CN107506442B (en) * | 2017-08-24 | 2020-09-29 | 中国银行股份有限公司 | Modeling method and device of model |
| CN107506442A (en) * | 2017-08-24 | 2017-12-22 | 中国银行股份有限公司 | The modeling method and device of a kind of model |
| CN107644097A (en) * | 2017-09-29 | 2018-01-30 | 北京酷我科技有限公司 | A kind of SLQ sentence generation methods |
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN109947788B (en) * | 2017-10-30 | 2021-10-15 | 北京京东尚科信息技术有限公司 | Data query method and device |
| CN110019307B (en) * | 2017-12-28 | 2023-09-01 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110109947A (en) * | 2017-12-28 | 2019-08-09 | 北京京东尚科信息技术有限公司 | The method and apparatus for extracting data |
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110019314A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团湖南有限公司 | Dynamic data packaging method, client and server-side based on data item analysis |
| CN108984623A (en) * | 2018-06-14 | 2018-12-11 | 东软集团股份有限公司 | Data query conditions generation method, device, storage medium and electronic equipment |
| CN108920566B (en) * | 2018-06-21 | 2020-10-20 | 吉林亿联银行股份有限公司 | Method, device and equipment for operating SQLite database |
| CN108920566A (en) * | 2018-06-21 | 2018-11-30 | 吉林亿联银行股份有限公司 | Operating method, device and the equipment of a kind of pair of SQLite database |
| CN108829884A (en) * | 2018-06-27 | 2018-11-16 | 中国建设银行股份有限公司 | data mapping method and device |
| CN110807042B (en) * | 2018-07-20 | 2023-02-24 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN110807042A (en) * | 2018-07-20 | 2020-02-18 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109408535B (en) * | 2018-09-28 | 2024-04-09 | 中国平安财产保险股份有限公司 | Large data volume matching method, device, computer equipment and storage medium |
| CN109872265A (en) * | 2019-02-28 | 2019-06-11 | 山东浪潮云信息技术有限公司 | A kind of visual government affairs service data analysis method |
| CN109992262A (en) * | 2019-03-27 | 2019-07-09 | 杭州城市大数据运营有限公司 | A kind of structured query language (SQL) graphical operation method |
| CN110083650B (en) * | 2019-04-25 | 2023-06-30 | 中电科嘉兴新型智慧城市科技发展有限公司 | Metadata self-discovery-based automatic generation method for data query interface |
| CN110083650A (en) * | 2019-04-25 | 2019-08-02 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of data-query interfaces automatic generation method and system based on metadata self-discovery |
| CN110489441B (en) * | 2019-08-12 | 2022-08-05 | 厦门商集网络科技有限责任公司 | Big data-based ad hoc query method and equipment |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN110750553A (en) * | 2019-09-02 | 2020-02-04 | 成都市知用科技有限公司 | Method for self-defining export of data in service management system |
| CN110633331A (en) * | 2019-09-12 | 2019-12-31 | 金蝶蝶金云计算有限公司 | Method, system and related equipment for extracting data in relational database |
| CN110633331B (en) * | 2019-09-12 | 2022-08-23 | 金蝶蝶金云计算有限公司 | Method, system and related equipment for extracting data in relational database |
| CN110851426A (en) * | 2019-11-19 | 2020-02-28 | 重庆华龙网海数科技有限公司 | Data DNA visualization relation analysis system and method |
| CN111552688A (en) * | 2020-03-18 | 2020-08-18 | 北京达佳互联信息技术有限公司 | Data export method and device and electronic equipment |
| CN111767266A (en) * | 2020-05-15 | 2020-10-13 | 杭州传化智能制造科技有限公司 | Entity contact model design method and device, computer equipment and storage medium |
| CN111639078A (en) * | 2020-05-25 | 2020-09-08 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and readable storage medium |
| CN111694551A (en) * | 2020-06-02 | 2020-09-22 | 北京乾元大通技术有限公司 | Cloud property development platform |
| CN111813799A (en) * | 2020-07-23 | 2020-10-23 | 德清云岫科技有限公司 | Database query statement generation method and device, computer equipment and storage medium |
| CN111813799B (en) * | 2020-07-23 | 2024-01-19 | 德清云岫科技有限公司 | Database query statement generation method, device, computer equipment and storage medium |
| CN112199387A (en) * | 2020-11-16 | 2021-01-08 | 广州速威智能系统科技有限公司 | Method and system for processing database query statement |
| CN112434058A (en) * | 2020-11-24 | 2021-03-02 | 武汉虹信技术服务有限责任公司 | Data interaction method based on Java and MySQL and computer readable medium |
| CN112434058B (en) * | 2020-11-24 | 2024-03-15 | 武汉虹信技术服务有限责任公司 | Java and MySQL-based data interaction method and computer readable medium |
| CN112506952A (en) * | 2020-12-11 | 2021-03-16 | 中信银行股份有限公司 | Data inquiry device and data inquiry method |
| CN112380293A (en) * | 2020-12-11 | 2021-02-19 | 上海中通吉网络技术有限公司 | Method and device for processing database and table data |
| CN112632110A (en) * | 2021-01-06 | 2021-04-09 | 上海合合信息科技股份有限公司 | Data extraction method and device for automatically generating query statement |
| CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
| CN112860725A (en) * | 2021-02-02 | 2021-05-28 | 浙江大华技术股份有限公司 | SQL automatic generation method and device, storage medium and electronic equipment |
| CN115422167B (en) * | 2022-09-27 | 2023-02-17 | 北京柏睿数据技术股份有限公司 | Cross-data source database view visualization construction method and system |
| CN115422167A (en) * | 2022-09-27 | 2022-12-02 | 北京柏睿数据技术股份有限公司 | Cross-data source database view visualization construction method and system |
| CN115563149A (en) * | 2022-10-27 | 2023-01-03 | 中电金信软件有限公司 | Index calculation method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103093000A (en) | Database query modeling system and database query modeling method | |
| US10503482B2 (en) | Object mapping using intrinsic persistence metadata and pattern-based rules for mapping transformation | |
| CN105446966B (en) | The method and apparatus that production Methods data are converted to the mapping ruler of RDF format data | |
| CN105849725B (en) | It is configured to the inquiry executed for multidimensional data structure | |
| CN103164222A (en) | Multidimensional modeling system and multidimensional modeling method | |
| US11288290B2 (en) | Building reports | |
| CN103020064A (en) | Method and configuration for generating query condition in annotation way | |
| US20070260582A1 (en) | Method and System for Visual Query Construction and Representation | |
| CN104903891A (en) | Automated report generation method | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN102722372A (en) | Method and system for automatically generating codes through classification and configuration | |
| CN104063361A (en) | Report design method and system | |
| CN110502227A (en) | The method and device of code completion, storage medium, electronic equipment | |
| CN108388623B (en) | ER relationship generation method and device, computer equipment and storage medium | |
| CN103186632A (en) | Method and device for customizing operation and maintenance form | |
| US8413109B2 (en) | Systems and methods for metamodel transformation | |
| US11693873B2 (en) | Systems and methods for using entity/relationship model data to enhance user interface engine | |
| CN102156640A (en) | Method for generating data operation code | |
| CN106407172B (en) | A kind of report form generation method based on XML | |
| CN108345646B (en) | Method for rapidly and automatically constructing multi-dimensional report by applying interception technology | |
| Yaish et al. | A multi-tenant database architecture design for software applications | |
| CN106648338A (en) | Method and device for editing data | |
| CN108228174A (en) | Accelerate the method and device of code efficiency in software development | |
| US9201909B1 (en) | Data volume attributes for entity-relationship modeling of databases | |
| US20150113470A1 (en) | Adjustable progressive disclosure of structured data |
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 |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130508 |