CN108256080A - A kind of method and system using python grammatical and semantics structure complexity sql sentences - Google Patents
A kind of method and system using python grammatical and semantics structure complexity sql sentences Download PDFInfo
- Publication number
- CN108256080A CN108256080A CN201810054162.1A CN201810054162A CN108256080A CN 108256080 A CN108256080 A CN 108256080A CN 201810054162 A CN201810054162 A CN 201810054162A CN 108256080 A CN108256080 A CN 108256080A
- Authority
- CN
- China
- Prior art keywords
- clause
- python
- sql
- diversified forms
- complicated
- 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.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- 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/31—Programming languages or programming paradigms
- G06F8/315—Object-oriented languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Devices For Executing Special Programs (AREA)
Abstract
The present invention discloses a kind of method and system using python grammatical and semantics structure complexity sql sentences, and method includes:Complicated sql query statements are decomposed, decomposition obtains the clause of diversified forms, the clause for the diversified forms that the decomposition is obtained is assigned to python variables, according to the python variables after the assignment, the clause's tandem junction for the diversified forms that the decomposition is obtained is combined together, generate a complicated sql sentence, the method that the present invention builds complexity sql sentences using python grammatical and semantics, use the basic element of python language, variable and function etc., so that during the query statement of structure complexity, it can decompose with combining, reduction problem complexity, improve code wrap extent for multiplexing, when solving structure complex query sql sentences, it is difficult to write, hardly possible is read, hardly possible debugging, the problem of difficulty is safeguarded.
Description
Technical field
The present invention relates to sentence builder technical field more particularly to a kind of utilization python grammatical and semantics structure complexity sql
The method and system of sentence.
Background technology
Structured query language (sql) is a kind of specific purpose program language, for administrative relationships data base management system
(rdbms) or in relationship DATA STREAM MANAGE SYSTEM (rdsms) stream process is carried out.
Object Relation Mapping (orm) is a kind of programmatics, is used to implement inhomogeneity in Object-Oriented Programming Language
Conversion between the data of type system, says from effect, it be in fact create one can be used in programming language it is " virtual
Object database ".
Python is a kind of widely used universal programming language.
Sqlalchemy is a python program libraries for providing sql kits and Object Relation Mapping orm tools.
The scheme of existing structure sql sentences, mainly including following two:
Scheme one directly writes sql sentences in program:
Structured query language sql is a kind of specific purpose program language, it is a kind of Domain Specific Language (dsl), language
Close to natural language in method, introduction is simple, is easily write in simple queries readability, but when building complexity sql sentences, than
During the connection of subquery and multiple compound conditions if any complexity, due to can only be expressed in a sql sentence, sql sentences
In the problem of just show, layer of structure not understand, sentence it is tediously long, punctuate be not easy read get up difficulty, used in program
Sql character strings need to carry out the operation of character string interpolation, string-concatenation, and in the dynamic construction of querying condition, splicing is easy
Error in addition when there is external input, due to the impedance mismatch between program and db systems, is susceptible to sql injection problems,
Escape is needed, anti-injection is needed to handle.
Scheme two generates sql sentences by orm frames:
Orm frames are mapped to object model in database relation model, and class has corresponded to table, and field has been corresponded in table
Row, an example have corresponded to a line in table, and are equipped with basic crud operations, this facilitates whole fields of inquiry table really
With the situation of multiple fields, but not very good processing when being related to correlation inquiry, orm also compare one-to-one, one-to-many support
It is more simple and clear, but object model just complicates during multi-to-multi association, being far from, it is clear that join is specified to come in sql sentences
Understand, in addition in complicated subquery, the scene of multi-condition inquiry, also do not apply to, many orm frames introduce the inquiry of oneself
Language handles these scenes, for example frame hibernate introduces hql query languages, but I thinks that this shaft problem becomes
Complexity, additional increase learning cost, orm frames often can not intuitively be known last during complex query is built
The sql sentences of generation be how, also easily abuse constructs the sql sentences of poor performance.
Invention content
The present invention provides a kind of method and system using python grammatical and semantics structure complexity sql sentences, to solve
The prior art when building complex query sql sentences, be difficult to write, it is difficult read, the technical issues of difficult debugging, difficulty are safeguarded.
In order to solve the above technical problems, present invention offer is a kind of to build complexity sql sentences using python grammatical and semantics
Method, which is characterized in that including:
Complicated sql query statements are decomposed, decomposition obtains the clause of diversified forms;
The clause of diversified forms that the decomposition obtains is assigned to python variables;
According to the python variables after the assignment, by clause's series combination of diversified forms that the decomposition obtains to one
It rises, generates a complicated sql sentence.
Wherein, described that complicated sql query statements are decomposed, decomposition obtains the clause of diversified forms, including:
By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition obtains
The clause of diversified forms.
Wherein, it is described by way of representing query structure, complicated sql query statements to be divided python grammers
Solution, decomposition obtain the clause of diversified forms, including:
By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition obtains
Including if-clause, with or decompose clause, offset clause, limit clause diversified forms clause.
Wherein, the python variables according to after the assignment go here and there the clause of the diversified forms decomposed and obtained
Connection is combined together, and generates a complicated sql sentence, including:
According to the python variables after the assignment, obtained using the decomposition in sqlAlchemy expression languages
The object of the clause of diversified forms, the form called using object chain-like manner, by the son of diversified forms for decomposing and obtaining
Sentence tandem junction is combined together, and generates a complicated sql sentence.
Wherein, the decomposition obtains the clause of diversified forms, including:
The language of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
In order to solve the above technical problems, utilize python grammatical and semantics structure complexity sql sentences the present invention also provides a kind of
System, including:Resolving cell, assignment unit, series unit;
The resolving cell, for being decomposed to complicated sql query statements, decomposition obtains the clause of diversified forms;
The assignment unit, the clause of diversified forms for the decomposition to be obtained are assigned to python variables;
The series unit, for according to the python variables after the assignment, by the diversified forms decomposed and obtained
Clause's tandem junction be combined together, generate a complicated sql sentence.
Wherein, the resolving cell, for being decomposed to complicated sql query statements, decomposition obtains the son of diversified forms
Sentence, including:
The resolving cell, by way of representing query structure python grammers, to complicated sql query statements
It is decomposed, decomposition obtains the clause of diversified forms.
Wherein, the resolving cell by way of representing query structure python grammers, is looked into complicated sql
Sentence to be ask to be decomposed, decomposition obtains the clause of diversified forms, including:
The resolving cell, by way of representing query structure python grammers, to complicated sql query statements
Decomposed, decompose obtain including if-clause, with or decomposition clause, offset clause, limit clause diversified forms son
Sentence.
Wherein, the series unit, for according to the python variables after the assignment, the decomposition being obtained a variety of
Clause's tandem junction of form is combined together, and generates a complicated sql sentence, including:
The series unit, for according to the python variables after the assignment, using sqlAlchemy expression languages
In the obtained object of the clause of diversified forms of the decomposition, the form called using object chain-like manner, by the decomposition
Clause's tandem junction of obtained diversified forms is combined together, and generates a complicated sql sentence.
Wherein, the decomposition obtains the clause of diversified forms, including:
The language of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
Method provided by the invention using python grammatical and semantics structure complexity sql sentences, including:Complicated sql is looked into
It askes sentence to be decomposed, decomposition obtains the clause of diversified forms, and the clause for the diversified forms which is obtained is assigned to
Python variables, according to the python variables after the assignment, clause's series combination of the diversified forms which is obtained to one
It rises, generates a complicated sql sentence, the present invention is used using the method for python grammatical and semantics structure complexity sql sentences
The basic element of python language, variable and function etc. so that when building complicated query statement, it can decompose with combining,
Reduction problem complexity improves code wrap extent for multiplexing, when solving structure complex query sql sentences, is difficult to write, hardly possible is read, difficult
The problem of debugging, difficulty are safeguarded.
System provided by the invention using python grammatical and semantics structure complexity sql sentences, including:Resolving cell, tax
Value cell, series unit;Resolving cell, for being decomposed to complicated sql query statements, decomposition obtains the son of diversified forms
Sentence;Assignment unit, the clause of the diversified forms for the decomposition to be obtained are assigned to python variables;Series unit, for root
According to the python variables after the assignment, the clause's tandem junction for the diversified forms which is obtained is combined together, and generates one again
Miscellaneous sql sentences, the present invention use the base of python language using the system of python grammatical and semantics structure complexity sql sentences
This element, variable and function etc. so that when building complicated query statement, it can decompose and combine, reduce problem complexity,
Improve code wrap extent for multiplexing, when solving structure complex query sql sentences, be difficult to write, it is difficult read, difficult debugging, it is difficult safeguard ask
Topic.
Description of the drawings
Fig. 1 is the flow diagram for the method that the present invention builds complexity sql sentences using python grammatical and semantics;
Fig. 2 is the structure diagram for the system that the present invention builds complexity sql sentences using python grammatical and semantics.
Specific embodiment
With reference to the accompanying drawings and examples, the present invention is described in further detail.It is emphasized that following implement
Example is merely to illustrate the present invention, but the scope of the present invention is not defined.Likewise, following embodiment is only the portion of the present invention
Point embodiment and not all embodiments, the institute that those of ordinary skill in the art are obtained without creative efforts
There are other embodiments, shall fall within the protection scope of the present invention.
The present invention provides a kind of method using python grammatical and semantics structure complexity sql sentences.
Fig. 1 is referred to, Fig. 1 is that the flow for the method that the present invention builds complexity sql sentences using python grammatical and semantics is shown
It is intended to, the method that the present invention builds complexity sql sentences using python grammatical and semantics, including:
S101:Complicated sql query statements are decomposed, decomposition obtains the clause of diversified forms.
Wherein, complicated sql query statements to be decomposed, decomposition obtains the clause of diversified forms, including:
By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition obtains
The clause of diversified forms.
Wherein, by way of representing query structure python grammers, complicated sql query statements are decomposed, point
Solution obtains the clause of diversified forms, including:
By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition obtains
Including if-clause, with or decompose clause, offset clause, limit clause etc. diversified forms clause.
Selecting sqlAlchemy libraries, it supports directly to write sql sentences, also supports orm modes, in addition have as orm frames
The expression language of oneself exactly represents query structure by python grammers, after pass through analytic tree generate sql sentences.Make
With table object, but not object-oriented, not object-oriented, refers to table association is not specified to close by way of object-oriented here
System avoids being rolled into complicated relational model, the set of table object as a result, and has a title to specify, after convenient
Continuous reference, reduces the size of code of repetition, can analogize to the mode using structure (struct) without the use of class (class)
Mode.
S102:The clause for the diversified forms that the decomposition is obtained is assigned to python variables.
The clause for the diversified forms that the decomposition is obtained is assigned to python variables, this step solves sql language and do not become
The defects of amount, provides the function of multiplexing, and flexibility also provides significantly, and the clause for the diversified forms which obtains can be in journey
It is used in being inquired in sequence by many places, as long as at the definition of modification clause, all query statements are all updated, and lift a common row
Son, we inquire some tables of data mileage according to when generally all some querying conditions are common, than such as whether effective inquiry
Condition updates this condition, if be not multiplexed, everywhere is required for changing, bad maintenance.
S103:According to the python variables after the assignment, the clause's series combination for the diversified forms which is obtained arrives
Together, a complicated sql sentence is generated.
Wherein, according to the python variables after the assignment, the clause's series combination for the diversified forms which is obtained arrives
Together, a complicated sql sentence is generated, including:
According to the python variables after the assignment, obtained using the decomposition in sqlAlchemy expression languages a variety of
The object of the clause of form, the form called using object chain-like manner, the clause's series connection for the diversified forms which is obtained
It combines, generates a complicated sql sentence.
Wherein, which obtains the clause of diversified forms, including:
The language etc. of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
The present invention also provides a kind of systems using python grammatical and semantics structure complexity sql sentences.
Fig. 2 is referred to, Fig. 2 is that the structure for the system that the present invention builds complexity sql sentences using python grammatical and semantics is shown
It is intended to, the system that the present invention builds complexity sql sentences using python grammatical and semantics, including:Resolving cell 201, assignment unit
202nd, series unit 203.
Resolving cell 201, for being decomposed to complicated sql query statements, decomposition obtains the clause of diversified forms.
Wherein, resolving cell 201, for being decomposed to complicated sql query statements, decomposition obtains the son of diversified forms
Sentence, including:
Resolving cell 201, by way of representing query structure python grammers, to complicated sql query statements
It is decomposed, decomposition obtains the clause of diversified forms.
Wherein, resolving cell 201 by way of representing query structure python grammers, are inquired complicated sql
Sentence is decomposed, and decomposition obtains the clause of diversified forms, including:
Resolving cell 201, by way of representing query structure python grammers, to complicated sql query statements
Decomposed, decompose obtain including if-clause, with or decomposition clause, offset clause, limit clause etc. diversified forms
Clause.
Selecting sqlAlchemy libraries, it supports directly to write sql sentences, also supports orm modes, in addition have as orm frames
The expression language of oneself exactly represents query structure by python grammers, after pass through analytic tree generate sql sentences.Make
With table object, but not object-oriented, not object-oriented, refers to table association is not specified to close by way of object-oriented here
System avoids being rolled into complicated relational model, the set of table object as a result, and has a title to specify, after convenient
Continuous reference, reduces the size of code of repetition, can analogize to the mode using structure (struct) without the use of class (class)
Mode.
Assignment unit 202, the clause of the diversified forms for the decomposition to be obtained are assigned to python variables.
The clause for the diversified forms that assignment unit 202 obtains the decomposition is assigned to python variables, this step solves sql
Language does not have the defects of variable, provides the function of multiplexing, and flexibility also provides significantly, the son for the diversified forms which obtains
Sentence uses in being inquired in program by many places, as long as at the definition of modification clause, all query statements are all updated, and lifts
A common row, we inquire some tables of data mileage according to when generally all some querying conditions be it is common, than such as whether
Effective querying condition updates this condition, if be not multiplexed, everywhere is required for changing, bad maintenance.
Series unit 203, for according to the python variables after the assignment, the clause for the diversified forms which is obtained
Tandem junction is combined together, and generates a complicated sql sentence.
Wherein, series unit 203, for according to the python variables after the assignment, the diversified forms which is obtained
Clause's tandem junction be combined together, generate a complicated sql sentence, including:
Series unit 203, for according to the python variables after the assignment, using in sqlAlchemy expression languages
The object of the clause for the diversified forms that the decomposition obtains, the form called using object chain-like manner, which is obtained more
Clause's tandem junction of kind form is combined together, and generates a complicated sql sentence.
Wherein, which obtains the clause of diversified forms, including:
The language etc. of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
Method provided by the invention using python grammatical and semantics structure complexity sql sentences, including:Complicated sql is looked into
It askes sentence to be decomposed, decomposition obtains the clause of diversified forms, and the clause for the diversified forms which is obtained is assigned to
Python variables, according to the python variables after the assignment, clause's series combination of the diversified forms which is obtained to one
It rises, generates a complicated sql sentence, the present invention is used using the method for python grammatical and semantics structure complexity sql sentences
The basic element of python language, variable and function etc. so that when building complicated query statement, it can decompose with combining,
Reduction problem complexity improves code wrap extent for multiplexing, when solving structure complex query sql sentences, is difficult to write, hardly possible is read, difficult
The problem of debugging, difficulty are safeguarded.
System provided by the invention using python grammatical and semantics structure complexity sql sentences, including:Resolving cell 201,
Assignment unit 202, series unit 203;Resolving cell 201, for being decomposed to complicated sql query statements, decomposition obtains more
The clause of kind form;Assignment unit 202, the clause of the diversified forms for the decomposition to be obtained are assigned to python variables;String
Receipts or other documents in duplicate member 203, for according to the python variables after the assignment, the clause's series combination for the diversified forms which is obtained to arrive
Together, a complicated sql sentence is generated, the present invention is used using the system of python grammatical and semantics structure complexity sql sentences
The basic element of python language, variable and function etc. so that when building complicated query statement, it can decompose with combining,
Reduction problem complexity improves code wrap extent for multiplexing, when solving structure complex query sql sentences, is difficult to write, hardly possible is read, difficult
The problem of debugging, difficulty are safeguarded.
Method and system provided by the invention using python grammatical and semantics structure complexity sql sentences, in network application
In development process, read-write database is the thing often to be done, how quickly and effectively to build query statement to adapt to complexity
Inquiry scene put close it is important, it is provided by the invention using python grammatical and semantics structure complexity sql sentences method and be
System can improve the readability of code, and durability is maintainable, reduce mistake and improve development efficiency.
Method and system provided by the invention using python grammatical and semantics structure complexity sql sentences so that structure is multiple
During miscellaneous sql query statements, it can improve code reuse degree effectively PROBLEM DECOMPOSITION, write out the code for being easy to read, pass through
The clear understanding of code energy derives the sql query statements for generating come to the end, substantially increases development efficiency.
In several embodiments provided by the present invention, it should be understood that disclosed system, device and method can
To realize by another way.For example, device embodiments described above are only schematical, for example, module or
The division of unit, only a kind of division of logic function can have other dividing mode, such as multiple units in actual implementation
Or component may be combined or can be integrated into another system or some features can be ignored or does not perform.Another point, institute
Display or the mutual coupling, direct-coupling or communication connection discussed can be by some interfaces, device or unit
INDIRECT COUPLING or communication connection can be electrical, machinery or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
Component may or may not be physical unit, you can be located at a place or can also be distributed to multiple networks
On unit.Some or all of unit therein can be selected according to the actual needs to realize the mesh of present embodiment scheme
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, also may be used
To be that each unit is individually physically present, can also two or more units integrate in a unit.It is above-mentioned integrated
The form that hardware had both may be used in unit is realized, can also be realized in the form of SFU software functional unit.
If integrated unit realized in the form of SFU software functional unit and be independent product sale or in use, can
To be stored in a computer read/write memory medium.Based on such understanding, technical scheme of the present invention substantially or
Saying all or part of the part contribute to the prior art or the technical solution can be embodied in the form of software product
Out, which is stored in a storage medium, is used including some instructions so that a computer equipment
(can be personal computer, server or the network equipment etc.) or processor (processor) perform each implementation of the present invention
The all or part of step of methods.And aforementioned storage medium includes:USB flash disk, mobile hard disk, read-only memory (ROM,
Read-OnlyMemory), random access memory (RAM, RandomAccessMemory), magnetic disc or CD etc. are various can
To store the medium of program code.
The foregoing is merely the section Examples of the present invention, not thereby limit the scope of the invention, every utilization
The equivalent device or equivalent process transformation that description of the invention and accompanying drawing content are made directly or indirectly are used in other correlations
Technical field, be included within the scope of the present invention.
Claims (10)
- A kind of 1. method using python grammatical and semantics structure complexity sql sentences, which is characterized in that including:Complicated sql query statements are decomposed, decomposition obtains the clause of diversified forms;The clause of diversified forms that the decomposition obtains is assigned to python variables;According to the python variables after the assignment, clause's tandem junction of diversified forms that the decomposition obtains is combined together, Generate a complicated sql sentence.
- 2. the method for python grammatical and semantics structure complexity sql sentences is utilized as described in claim 1, which is characterized in that institute It states and complicated sql query statements is decomposed, decomposition obtains the clause of diversified forms, including:By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition obtains a variety of The clause of form.
- 3. the method for python grammatical and semantics structure complexity sql sentences is utilized as claimed in claim 2, which is characterized in that institute It states by way of representing query structure python grammers, complicated sql query statements is decomposed, decomposition obtains a variety of shapes The clause of formula, including:By way of representing query structure python grammers, complicated sql query statements are decomposed, decomposition is included If-clause, with or decompose clause, offset clause, limit clause diversified forms clause.
- 4. the method for python grammatical and semantics structure complexity sql sentences is utilized as described in claim 1, which is characterized in that institute It states according to the python variables after the assignment, clause's tandem junction of diversified forms that the decomposition obtains is combined together, it is raw The sql sentence complicated into one, including:According to the python variables after the assignment, obtained using the decomposition in sqlAlchemy expression languages a variety of The object of the clause of form, the form called using object chain-like manner are gone here and there the clause of the diversified forms decomposed and obtained Connection is combined together, and generates a complicated sql sentence.
- 5. the method using python grammatical and semantics structure complexity sql sentences as described in Claims 1-4 any one, It being characterized in that, the decomposition obtains the clause of diversified forms, including:The language of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
- 6. a kind of system using python grammatical and semantics structure complexity sql sentences, which is characterized in that including:Resolving cell, tax Value cell, series unit;The resolving cell, for being decomposed to complicated sql query statements, decomposition obtains the clause of diversified forms;The assignment unit, the clause of diversified forms for the decomposition to be obtained are assigned to python variables;The series unit, for according to the python variables after the assignment, by the son of diversified forms for decomposing and obtaining Sentence tandem junction is combined together, and generates a complicated sql sentence.
- 7. the system of python grammatical and semantics structure complexity sql sentences is utilized as claimed in claim 6, which is characterized in that institute Resolving cell is stated, for being decomposed to complicated sql query statements, decomposition obtains the clause of diversified forms, including:The resolving cell by way of representing query structure python grammers, carries out complicated sql query statements It decomposes, decomposition obtains the clause of diversified forms.
- 8. the system of python grammatical and semantics structure complexity sql sentences is utilized as claimed in claim 7, which is characterized in that institute Resolving cell is stated, by way of representing query structure python grammers, complicated sql query statements are decomposed, Decomposition obtains the clause of diversified forms, including:The resolving cell by way of representing query structure python grammers, carries out complicated sql query statements Decompose, decompose obtain including if-clause, with or decomposition clause, offset clause, limit clause diversified forms clause.
- 9. the system of python grammatical and semantics structure complexity sql sentences is utilized as claimed in claim 6, which is characterized in that institute Series unit is stated, for according to the python variables after the assignment, the clause of the diversified forms decomposed and obtained to be connected It combines, generates a complicated sql sentence, including:The series unit, for according to the python variables after the assignment, using in sqlAlchemy expression languages Form that is described to decompose the obtained object of the clause of diversified forms, being called using object chain-like manner is obtained the decomposition Clause's tandem junctions of diversified forms be combined together, generate a complicated sql sentence.
- 10. the system using python grammatical and semantics structure complexity sql sentences as described in claim 6 to 9 any one, It being characterized in that, the decomposition obtains the clause of diversified forms, including:The language of hand-written sql sentence fragments, sqlAlchemy expression formulas structure.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810054162.1A CN108256080A (en) | 2018-01-19 | 2018-01-19 | A kind of method and system using python grammatical and semantics structure complexity sql sentences |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810054162.1A CN108256080A (en) | 2018-01-19 | 2018-01-19 | A kind of method and system using python grammatical and semantics structure complexity sql sentences |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108256080A true CN108256080A (en) | 2018-07-06 |
Family
ID=62741253
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810054162.1A Withdrawn CN108256080A (en) | 2018-01-19 | 2018-01-19 | A kind of method and system using python grammatical and semantics structure complexity sql sentences |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108256080A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109298857A (en) * | 2018-10-09 | 2019-02-01 | 杭州朗和科技有限公司 | Method for building up, medium, device and the calculating equipment of DSL statement model |
CN110209689A (en) * | 2019-05-09 | 2019-09-06 | 上海车轮互联网服务有限公司 | ORM data processing method and device based on Swoole |
CN112241416A (en) * | 2020-10-16 | 2021-01-19 | 四川长虹电器股份有限公司 | System and method for constructing complex sql statement by using python syntax semantics |
KR20210049359A (en) | 2019-10-25 | 2021-05-06 | 삼성에스디에스 주식회사 | Method and apparatus for data retrieving |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1881208A (en) * | 2005-06-14 | 2006-12-20 | 联想(北京)有限公司 | Construction method for dynamic structured query language statement |
US7987179B2 (en) * | 2007-11-16 | 2011-07-26 | International Business Machines Corporation | Method and apparatus for optimizing queries over vertically stored database |
CN102693310A (en) * | 2012-05-28 | 2012-09-26 | 无锡成电科大科技发展有限公司 | Resource description framework querying method and system based on relational database |
CN104391923A (en) * | 2014-11-20 | 2015-03-04 | 北京锐安科技有限公司 | Data set query method and apparatus |
CN105740344A (en) * | 2016-01-25 | 2016-07-06 | 中国科学院计算技术研究所 | Sql statement combination method and system independent of database |
CN106940870A (en) * | 2017-03-22 | 2017-07-11 | 成都市互联互通大数据科技有限公司 | A kind of method and its system for being used to carry out constructional enterprises information various dimensions combined retrieval |
-
2018
- 2018-01-19 CN CN201810054162.1A patent/CN108256080A/en not_active Withdrawn
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1881208A (en) * | 2005-06-14 | 2006-12-20 | 联想(北京)有限公司 | Construction method for dynamic structured query language statement |
US7987179B2 (en) * | 2007-11-16 | 2011-07-26 | International Business Machines Corporation | Method and apparatus for optimizing queries over vertically stored database |
CN102693310A (en) * | 2012-05-28 | 2012-09-26 | 无锡成电科大科技发展有限公司 | Resource description framework querying method and system based on relational database |
CN104391923A (en) * | 2014-11-20 | 2015-03-04 | 北京锐安科技有限公司 | Data set query method and apparatus |
CN105740344A (en) * | 2016-01-25 | 2016-07-06 | 中国科学院计算技术研究所 | Sql statement combination method and system independent of database |
CN106940870A (en) * | 2017-03-22 | 2017-07-11 | 成都市互联互通大数据科技有限公司 | A kind of method and its system for being used to carry out constructional enterprises information various dimensions combined retrieval |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109298857A (en) * | 2018-10-09 | 2019-02-01 | 杭州朗和科技有限公司 | Method for building up, medium, device and the calculating equipment of DSL statement model |
CN110209689A (en) * | 2019-05-09 | 2019-09-06 | 上海车轮互联网服务有限公司 | ORM data processing method and device based on Swoole |
KR20210049359A (en) | 2019-10-25 | 2021-05-06 | 삼성에스디에스 주식회사 | Method and apparatus for data retrieving |
CN112241416A (en) * | 2020-10-16 | 2021-01-19 | 四川长虹电器股份有限公司 | System and method for constructing complex sql statement by using python syntax semantics |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11055287B2 (en) | Eigenvalue-based data query | |
CN108256080A (en) | A kind of method and system using python grammatical and semantics structure complexity sql sentences | |
CN105260403B (en) | General integration across database access method | |
CN105868204B (en) | A kind of method and device for converting Oracle scripting language SQL | |
US7512633B2 (en) | Conversion of hierarchically-structured HL7 specifications to relational databases | |
CN107491561B (en) | Ontology-based urban traffic heterogeneous data integration system and method | |
CN104391730B (en) | A kind of software source codes language translation system and method | |
CN109614432B (en) | System and method for acquiring data blood relationship based on syntactic analysis | |
DE102019005879A1 (en) | Generate three-dimensional digital content from natural language prompts | |
CN107169033A (en) | Relation data enquiring and optimizing method with parallel framework is changed based on data pattern | |
CN104765731A (en) | Database query optimization method and equipment | |
CN104915450A (en) | HBase-based big data storage and retrieval method and system | |
CN108829884A (en) | data mapping method and device | |
US8554760B2 (en) | System and method for optimizing queries | |
CN102982095B (en) | A kind of body automatic creation system based on thesaurus and method thereof | |
Atzeni et al. | Modelgen: Model independent schema translation | |
Thakkar et al. | Two for one: Querying property graph databases using SPARQL via gremlinator | |
CN105335366A (en) | SQL statement processing method and apparatus and server | |
CN106933869A (en) | A kind of method and apparatus of operating database | |
CN110532358A (en) | A kind of template automatic generation method towards knowledge base question and answer | |
CN110688397A (en) | SQL-based distributed data unified access system and method | |
CN104951565B (en) | XM (extensible messaging client) L (extensible markup language) configuration maintenance method and system based on memory database | |
US20080281842A1 (en) | Apparatus and method for pre-processing mapping information for efficient decomposition of xml documents | |
CN116795859A (en) | Data analysis method, device, computer equipment and storage medium | |
CN116541411A (en) | SQL sentence acquisition method, report generation device, computer equipment and storage medium |
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 | ||
WW01 | Invention patent application withdrawn after publication | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20180706 |