CN106095792A - The method and apparatus generating database manipulation code - Google Patents
The method and apparatus generating database manipulation code Download PDFInfo
- Publication number
- CN106095792A CN106095792A CN201610370032.XA CN201610370032A CN106095792A CN 106095792 A CN106095792 A CN 106095792A CN 201610370032 A CN201610370032 A CN 201610370032A CN 106095792 A CN106095792 A CN 106095792A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- configuration file
- code
- database manipulation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- 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/245—Query processing
- G06F16/2452—Query translation
- G06F16/24524—Access plan code generation and invalidation; Reuse of access plans
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of method and apparatus generating database manipulation code.Method includes: first step, employing abstract describes, by database information, table information and database manipulation message configure in configuration file, second step, code building engine is utilized to resolve described configuration file, by database information, table information and database manipulation message, be converted to the fundamental objects with hierarchical structure and association, third step, SQL statement is resolved, obtain its input/output argument information, and this SQL statement is converted to the execution statement under certain database and programming language, 4th step, incidence relation according to fundamental objects, generate source file.
Description
Technical field
Embodiments of the invention relate to the method and apparatus generating database manipulation code.
Background technology
The page, as the main flow framework of existing information system, is well shown and separates with service logic by MVC framework.
M shell in MVC framework, predominantly database-operation level.Along with the extension of portfolio, generally require by existing operation system to
Different database migrations, and use different programming languages to develop.Along with the development of cloud computing technology, this trend
The most aggravate, go IOEization concept to arise.In the most original MVC framework, relatively stable data operation layer is also faced with
The possibility of large change.Prior art is different programming language and database development corresponding database manipulation code, opens
The workload sent out and safeguard is the biggest, and is readily incorporated mistake.In addition business development personnel need to be familiar with concrete difference
Language, the disparate databases operation use of API and concern the details such as report an error, and development difficulty is bigger.
The following is shortcomings more of the prior art.
1. utilize existing operation system when carrying out database manipulation, be required for different programming language, different pieces of information
Storehouse, calls corresponding API, when programming language and data base change when, is required for identical services function, again opens
Sending out database manipulation code a set of, workload is quite big, and is very easy to introduce defect.
2., for the handling function that a SQL statement is corresponding, need manually to determine the input of needs, output parameter, parameter
Type, and put in order, workload is the most loaded down with trivial details, and is very easy to introduce mistake.
3. the metadata description form of disparate databases differs greatly, and different program data types is also different,
Any database manipulation first has to it is considered that conversion between Database field and program data types, and the mapping of the two is closed
Be sum be the cartesian product of data base's kind and programming language quantity, the most either expand to different programming language real
The most still it is transplanted to different database platforms, is required for the work repeated in a large number.
4., owing to database table itself is along with the change of business, the additions and deletions causing field are changed, under many circumstances, by shadow
Ring most data base manipulation statement, it is therefore desirable to have special mechanism, it is possible to auxiliary finds to need the data base behaviour of change
Make code, even can automatically adapt to the change of database table.
5., by the data base manipulation statement of manual compiling, it is also likely to introduce the mistake spelt or in terms of grammer, these
Mistake may need in compiling, and the stage that even performs just can be found, and has a strong impact on the development quality of operation system.
The most in the ordinary course of things, if sql statement occurs to perform mistake, need in the daily record that reports an error, print relevant input
Parameter value, as insert statement major key needs to print corresponding major key field, and select statement is searched and is needed to beat less than record
The condition field that print is corresponding, manual type is write the statement that reports an error and is very easy to cause the mistakes such as order of the field or type not coupling
By mistake, the most then cannot normally show information, heavy then initiator coredump.
7. in a lot of operation systems, need to divide table to deposit business datum, for the database manipulation code of different tables
Except the difference of table name, substantially coincident, if manually developing and safeguarding these codes, the workload brought also is huge
's.
8. substitute Db2 according to Mysql cluster and store data, need to carry out the data of same table cutting, and point storehouse
Depositing, this is also the key technological transformation to data base's operation code, and this also requires that and realizes dividing by the logical AND collective of database manipulation
From.
Summary of the invention
Main idea is that database manipulation definition and implement code dehind, making the exploitation of operation system
Personnel can free from loaded down with trivial details database manipulation bottom layer realization.Propose a set of based on XML based on this thought
Database code generates configuration mode, and the Command Line Parsing of correspondence and code generating framework.This thought is by original MVC framework
In database-operation level be separated into the database manipulation abstractdesription layer unrelated with concrete database and programming language and
Implement layer, code building engine be automatically performed level of abstraction to the conversion implementing layer.
By resolving database manipulation definition configuration file, in conjunction with the database table metadata information automatically obtained, in generation
Code generates to write under framework and generates code for certain database and the personalized of programming language, can arbitrarily generate based on difference
Data base API, the database manipulation code of different programming languages, even generate the compiling file of correspondence, hence for business generation
The developer of code achieves What You See Is What You Get, the most only need to specify the SQL statement of correspondence, and without considering at disparate databases,
Realization under different programming languages.
One embodiment of the present of invention introduces data base's full literary name section and replaces labelling and blacklist mechanism, it is thus possible to very
The good change adapting to literary name section；Energy generates the most set tables and the database manipulation code of any table tricks rule；Can be certainly
Move and determine the incoming of most of database manipulation function, spread out of parameter and data type, simplify the configuration of database manipulation；Energy
The most of SQL statement of parsing of enough automatizatioies, to check whether this SQL statement has syntax error, to avoid compiling, performed
Mistake in journey；Automatically the value of relevant field can be printed in error information, in order to business personnel's Wrong localization accurately
Reason.
The present invention alleviates workload and the difficulty of service code developer, reduces the possibility that database manipulation code is made mistakes
Property, reduce the workload of code follow-up maintenance, reduce difficulty and the workload of Database Systems bulk migration.
To this end, according to one or more embodiments of the invention, disclose a kind of method generating database manipulation code, bag
Including: first step, use abstract to describe, by database information, table information and database manipulation message are in configuration file
Configuration, second step, utilize code building engine to resolve described configuration file, by database information, table information and data base
Operation information, is converted to the fundamental objects with hierarchical structure and association, third step, resolves SQL statement, obtain it
Input/output argument information, and this SQL statement is converted to the execution statement under certain database and programming language, the 4th step
Suddenly, according to the incidence relation of fundamental objects, generate source file.
According to one or more embodiments of the invention, a kind of device generating database manipulation code is disclosed, including: the
Unit one, uses abstract to describe, and by database information, table information and database manipulation message configure in configuration file,
Second unit, utilizes code building engine to resolve described configuration file, by database information, table information and database manipulation letter
Breath, is converted to the fundamental objects with hierarchical structure and association, Unit the 3rd, resolves SQL statement, obtain its input defeated
Go out parameter information, and this SQL statement is converted to the execution statement under certain database and programming language, Unit the 4th, according to
The incidence relation of fundamental objects, generates source file.
When reading in conjunction with the accompanying following description it will also be understood that the further feature of embodiments of the invention and advantage, the most attached
Figure shows the principle of embodiments of the invention by means of example.
Accompanying drawing explanation
Fig. 1 is the step schematic diagram of the method generating database manipulation code according to embodiments of the present invention.
Fig. 2 is that XML configuration file is carried out resolving the figure generating object by code building engine according to embodiments of the present invention
Show.
Detailed description of the invention
Hereinafter, the principle that invention will be described in conjunction with the embodiments.It should be appreciated that the embodiment be given is simply
Those skilled in the art are more fully understood that and put into practice the present invention rather than limit the scope of the present invention.This specification is wrapped
The concrete implementation detail contained is not necessarily to be construed as the restriction of the scope maybe may being claimed the scope of invention, but should
This is considered the description specific to embodiment.Advantageously, the feature at the context-descriptive of each embodiment can be combined in single
Embodiment is implemented.Spy described in the context of single embodiment can implement in multiple embodiments.
Fig. 1 is the step schematic diagram of the method generating database manipulation code according to embodiments of the present invention.
First step, uses abstract to describe, by database information, table information and database manipulation message at configuration literary composition
Part configures.
Second step, utilizes code building engine to resolve described configuration file, by database information, table information and data
Storehouse operation information, is converted to the fundamental objects with hierarchical structure and association.
Third step, resolves SQL statement, obtains its input/output argument information, and this SQL statement is converted to
Execution statement under certain database and programming language.
4th step, according to the incidence relation of fundamental objects, generates source file.
In the aforementioned embodiment, this XML configuration file can include the element generating database manipulation code..One relatively
Complexity, the XML configuration file content containing all special circumstances is as follows.
According to this XML configuration file, Db root node correspondence database configuration information, including type of database (type), number
According to storehouse operation based on programming language (language), (mode has static and dynamic etc. to take to api programming mode respectively
Value, corresponding static Sql and dynamically Sql), (dataMode, has single and cluster value to Data Distribution respectively, corresponding
Single cpu mode and cluster mode), data base IP (ip), data base's port (port), database name (name), user name (user)
And encrypted message (pass).Database code generates engine according to type of database, and will bring the data bases such as data base IP into
Link information, calls and connects database functions accordingly, to obtain the metadata information of correspondence database.
One child node of Db root node is Tbl, corresponding table information, mainly includes table name (name), and database code is raw
Become engine will call corresponding metadata according to type of database and obtain API, obtain the metadata information of this table, including being comprised
Database field and field length and type information, code building engine acquiescence is generated the structure comprising all fields of table
Body (or class).Table information also includes table tricks (tableNum) and table set digital modeling (tableMode), for being configured with table
The table of tricks, corresponding handling function, using automatically comprising current table tricks as parameter, checks the table tricks parameter of input simultaneously
Legitimacy.For static database programming code, database manipulation will be carried out by code building engine for different table tricks
Extension.The naming method of table set digital modeling correspondence difference set table, mainly has MMDD (day moon table), NN (sequence list) etc..
Main child node under Tbl node is Opr, and corresponding is database manipulation message.Underlying attribute includes operation
Type (tp mainly has declare, select, insert, update, delete) and the operation name suffix of correspondence
(suffix, the suffix using as respective operations function or method).
Stmt is the optional child node of Opr, when this node does not configures when, gives tacit consent to this operation for without where condition
Full field operations.The sql attribute of this node is corresponding sql statement, and the r value of where condition adds parameter sequence number table with $ symbol
Show.List of fields in Sql statement can use [field_list], [value_list], [set_list] to substitute, code building
These lists, by according to the metadata information obtained, are replaced, it is contemplated that some field needs individually to carry out by engine automatically
(such as using data base time current_timestamp) is set, by the configuration of BlackListFlds node, it is also possible to
Specifying blacklist field, blacklist field will be excluded automatically.List of fields is replaced plus blacklist mechanism, is effectively reduced
The redundancy of configuration, is reduced to the degree of minimum by the impact that Database field changes.
BindParam and BindResult node is the child node of Stmt, and the incoming of respective operations spreads out of parameter respectively
And type information.In most of the cases, this node is without configuration.Code building engine will carry out grammer to SQL statement and divide
Analysis, automatically obtains and needs incoming and spread out of field name and type, and specific rules will be described in detail later.For multi-table manipulation
Etc. special SQL or in the case of needing custom parameter name and type, need it is configured.Database manipulation function
The parameter of (method) is except being default configuration body corresponding to database table, it is also possible to be user-defined structure, very
Can be extremely single initial form parameter.
Struct node is used for configuring self-defining structure.Struct node both can be as the son joint of Db node
Point (this structure is defined in the header file of data base's overall situation), it is also possible to (this structure is only at this table as the child node of Tbl node
Corresponding header file kind definition).Its child node Fld is used for configuring the field information of self-defined structure, and attribute (tp) is field class
Type, wherein field type is the general program type of definition, respectively value String, Int32, Int64, Double, Float,
Bool, the definition of these universal classes will be converted to the respective type of corresponding programming language by code building engine.Length is can
Select attribute, only effective when for String type when.Additionally, field type can also arise directly from the corresponding field of table,
Representing with src attribute, the character string that the value of this attribute is table name and field name is split with period, current table tbl represents
(only effective when this node is Tbl node child node when).
According to this embodiment of the invention, the method generating database manipulation code, comprise the following steps.
First step, uses general abstract to describe, and by database information, table information and database manipulation message exist
Configuration file configures.Such as, it is arranged in XML file.
Second step, utilizes code building engine to resolve configuration, by database information, table information and database manipulation letter
Breath, is converted to the fundamental objects with hierarchical structure and association.Fig. 2 is code building engine pair according to embodiments of the present invention
XML configuration file carries out resolving the diagram generating object.In this embodiment, right with reference to the definition of above-mentioned example XML element structure
Code building engine XML configuration file to be analyzed is described.As in figure 2 it is shown, in this example, according to OO think of
Thinking, configuration information is converted to have hierarchical relationship class formation, and main class includes: data base (Database), table
(Table), structure (Struct), territory (Field), operation (Operation), function (Function), source file (File) with
And code building engine (CodeEngine).First according to programming language, api programming mode, Data Distribution, it is right to initialize
The code building engine answered, according to the database object that type of database instantiation is corresponding, then, calls database object
Connect method connects data base, all tables comprising this data base, calls GetMetadata method, obtains the unit of this table
Data message.Record the Universal Database type of each field, such as Char, Varchar, Bit, Decimal, Timestamp.
Wherein Char and Bit type needs record length information, Decimal type to need to record integer and the figure place of decimal.Last root
Generate corresponding Field object according to its conventional data type, improve its general program type information, and by corresponding for each field
Field object adds the Field list that this table comprises.
Third step, the automatic parsing to SQL statement, obtain its input/output argument information, and be converted to particular data
Execution statement under storehouse and programming language.
First list of fields is combined blacklist list to be replaced, then whole piece SQL statement is carried out syntactic analysis, obtain
Take corresponding incoming of this SQL statement and spread out of field and type thereof.The grammatical rules that can use for reference PostgreSQL data base describes,
Use morphology and the syntax parsing instrument generative grammar tree of Lexer and Yacc system, SQL statement is carried out complete syntactic analysis.
In view of the SQL statement in general business system uncomplicated, and need not the most complete semantic letter obtaining corresponding SQL
Breath, the method that therefore can also use simplification.
In some instances, as follows to the process of analysis of Select operation:
(1) judge whether this SQL statement has Where keyword, if it has, to its coupling regular expression ' s* (？
select\s+(.+？)\s+from\s+(.+？)\s+where\s+(.+)\)？', thus obtain list of fields clause and
Where clause.If it is not, mate following regular expression ' s* (？select\s+(.+？)\s+from\s+(.
+)\)？', obtain list of fields clause.
(2) list of fields clause being called split function, separator is comma, is applying the element after each segmentation just
Then expression formula ' (.+) s+as s+ (.+) ', if cannot mate, illustrate that corresponding field is not called, currentElement is and spreads out of
Parameter name, type is corresponding field type.Otherwise, then take and call as spreading out of parameter name, and parameter type depends on the poly-of correspondence
Set function, if SUM, then combines corresponding field type, takes INT64 or DOUBLE respectively；If MIN or MAX, the most directly
Take corresponding field type；If COUNT, then it is fixed as INT64.
(3) it is in where clause, to travel through $ n (n is parameter sequence number) successively crucial to the resolution rules of Where clause
Word, if finding, then forward trace, first non-keyword found and inverse symbol are then corresponding field name, currently incoming
Parameter type takes the field type of correspondence, and parameter name prefix is corresponding field name, and suffix is the multiplexing number that field is current.
In some instances, as follows to the process of analysis of Insert operation:
(1) to SQL statement coupling regular expression ' insert s+into s+ (.+) s* ((.+)) s+values
((.+)) ', obtains list of fields statement and value list statement.
(2) list of fields and value list statement being called split function respectively, separator is comma, obtains field row
Table and value list.
(3) search value list, mates $ n (n is parameter sequence number) keyword, if matching, then this incoming parameter name and type
All with the field in corresponding list of fields.
In some instances, as follows to the process of analysis of delete operation:
(1) judge whether this SQL statement has Where keyword, if it has, to its coupling regular expression ' delete s+
from\s+(.+？) s+where s+ (.+) ', obtain corresponding where clause.
(2) to the resolution rules of where clause with described in select operation.
In some instances, as follows to the process of analysis of update operation:
(1) judge whether this SQL statement has Where keyword, if it has, to its coupling regular expression ' update s+
(.+)\s+set\s+(.+？) s+where s+ (.+) ', obtain corresponding assignment clause and where clause, otherwise apply canonical
Expression formula ' update s+ (.+) s+set s+ (.+) ', obtain assignment clause.
(2) in assignment clause, travel through $ n (n is parameter sequence number) keyword, if finding, then forward trace, eliminating etc. successively
Number first non-keyword be then corresponding field name.
(3) to the resolution rules of where clause with described in select operation.
After parsing default operation parameters information, applying self-defining parameter name and type configuration information, to it
It is updated, thus obtains final parameter information.According to configuration letters such as programming language, api programming mode, Data Distributions
Breath, generates the function that operation is corresponding.For the field of cacography in sql statement (or name change), will be easy to by work
Tool analyzes, and offer reports an error, accordingly to point out developer to modify.
4th step, according to incidence relation and the essential information of fundamental objects, generates and comprises structure definition, and structure is stated,
Global variable defines, and function defines, function declaration, annotation information and the source file of compiling information.
The aforementioned exemplary of the present invention, when reading in conjunction with the accompanying aforementioned specification, is implemented by those skilled in the relevant art
Various amendments and the deformation of example can become obvious for those skilled in the relevant art.Therefore, embodiments of the invention are not limited to
Disclosed specific embodiment, and variation and other embodiments be intended within the scope of the appended claims.
Claims (10)
1. the method generating database manipulation code, it is characterised in that including:
First step, uses abstract to describe, and by database information, table information and database manipulation message are in configuration file
Configuration,
Second step, utilizes code building engine to resolve described configuration file, by database information, table information and data base behaviour
Make information, be converted to the fundamental objects with hierarchical structure and association,
Third step, resolves SQL statement, obtains its input/output argument information, and is converted to specific by this SQL statement
Execution statement under data base and programming language,
4th step, according to the incidence relation of fundamental objects, generates source file.
2. the method for claim 1, it is characterised in that
Described configuration file is XML configuration file, and this XML configuration file includes the element for generating database manipulation code.
3. the method for claim 1, it is characterised in that
Described source file comprise structure definition, structure state, global variable define, function define, function declaration, annotation information with
And compiling information.
4. method as claimed in claim 2, it is characterised in that
This XML configuration file includes the database element as root element, and the attribute definition of this database element is used for calling number
The parameter of connection API and programming language according to storehouse.
5. method as claimed in claim 4, it is characterised in that
This XML configuration file includes the table element of the daughter element as database element, and the attribute definition of this table element is used for adjusting
The parameter of API is obtained with table metadata.
6. the device generating database manipulation code, it is characterised in that including:
First module, uses abstract to describe, and by database information, table information and database manipulation message are in configuration file
Configuration,
Second unit, utilizes code building engine to resolve described configuration file, by database information, table information and data base behaviour
Make information, be converted to the fundamental objects with hierarchical structure and association,
Unit the 3rd, resolves SQL statement, obtains its input/output argument information, and is converted to specific by this SQL statement
Execution statement under data base and programming language,
Unit the 4th, according to the incidence relation of fundamental objects, generates source file.
7. device as claimed in claim 6, it is characterised in that
Described configuration file is XML configuration file, and this XML configuration file includes the element for generating database manipulation code.
8. device as claimed in claim 6, it is characterised in that
Described source file comprise structure definition, structure state, global variable define, function define, function declaration, annotation information with
And compiling information.
9. device as claimed in claim 7, it is characterised in that
This XML configuration file includes the database element as root element, and the attribute definition of this database element is used for calling number
The parameter of connection API and programming language according to storehouse.
10. device as claimed in claim 8, it is characterised in that
This XML configuration file includes the table element of the daughter element as database element, and the attribute definition of this table element is used for adjusting
The parameter of API is obtained with table metadata.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610370032.XA CN106095792A (en) | 2016-05-27 | 2016-05-27 | The method and apparatus generating database manipulation code |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610370032.XA CN106095792A (en) | 2016-05-27 | 2016-05-27 | The method and apparatus generating database manipulation code |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106095792A true CN106095792A (en) | 2016-11-09 |
Family
ID=57230821
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610370032.XA Pending CN106095792A (en) | 2016-05-27 | 2016-05-27 | The method and apparatus generating database manipulation code |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106095792A (en) |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106844758A (en) * | 2017-02-17 | 2017-06-13 | 安图实验仪器(郑州)有限公司 | Data set code generating method |
| CN107818157A (en) * | 2017-10-31 | 2018-03-20 | 北京酷我科技有限公司 | A kind of SQL statement method for packing based on FMDB |
| CN108170661A (en) * | 2016-12-07 | 2018-06-15 | 北京京东尚科信息技术有限公司 | A kind of management method and system of rule text |
| CN108334621A (en) * | 2018-02-08 | 2018-07-27 | 平安科技（深圳）有限公司 | Database operation method, device, equipment and computer readable storage medium |
| CN109062925A (en) * | 2018-06-06 | 2018-12-21 | 中国平安人寿保险股份有限公司 | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence |
| CN109055235A (en) * | 2018-08-20 | 2018-12-21 | 云南农业大学 | A kind of preparation of the inoculating microbes strain for Pu'er tea pile fermentation and its application method |
| CN109446255A (en) * | 2018-09-30 | 2019-03-08 | 珠海沙盒网络科技有限公司 | A kind of storage method and system that can be adaptive |
| CN109582647A (en) * | 2018-11-21 | 2019-04-05 | 珠海市新德汇信息技术有限公司 | A kind of analysis method and system towards the unstructured instrument of evidence |
| CN110019229A (en) * | 2017-12-25 | 2019-07-16 | 航天信息股份有限公司 | Database configures system |
| CN110113196A (en) * | 2019-04-26 | 2019-08-09 | 中车青岛四方机车车辆股份有限公司 | A kind of protocol configuration method, device, equipment and medium |
| CN110795101A (en) * | 2019-09-18 | 2020-02-14 | 平安科技（深圳）有限公司 | SQL code information display method and device, computer device and storage medium |
| CN111095195A (en) * | 2018-03-15 | 2020-05-01 | 欧姆龙株式会社 | Controller, control method, and control program |
| CN111597163A (en) * | 2020-03-26 | 2020-08-28 | 中国南方航空股份有限公司 | Memory database |
| CN111752964A (en) * | 2019-06-10 | 2020-10-09 | 北京京东尚科信息技术有限公司 | Data processing method and device based on data interface |
| CN111966718A (en) * | 2020-09-09 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | System and method for data propagation tracking of application systems |
| CN112631567A (en) * | 2020-12-30 | 2021-04-09 | 中国农业银行股份有限公司 | Method and device for generating database operation file |
| CN112799643A (en) * | 2021-01-26 | 2021-05-14 | 中国工商银行股份有限公司 | Front-end page application development method and device based on database mapping dynamic interface |
| CN112905624A (en) * | 2021-02-26 | 2021-06-04 | 浪潮通用软件有限公司 | Database extension method and device of low-code development platform |
| CN113641745A (en) * | 2021-08-18 | 2021-11-12 | 上海通联金融服务有限公司 | Method for operating database across language platforms |
| CN113676437A (en) * | 2020-05-14 | 2021-11-19 | ***通信集团云南有限公司 | Parameter analysis method, parameter acquisition method, parameter setting method and device |
| CN115334177A (en) * | 2022-07-07 | 2022-11-11 | 浙江众合科技股份有限公司 | Binary data message analysis method based on xml configuration file recursion |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102117202A (en) * | 2009-12-30 | 2011-07-06 | 北大方正集团有限公司 | J2EE architecture-based code generating device |
| CN102508876A (en) * | 2011-10-17 | 2012-06-20 | 无锡诺宝科技发展有限公司 | Information management system combined with database sheet and configuration file |
| CN102541521A (en) * | 2010-12-17 | 2012-07-04 | ***股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN105354036A (en) * | 2015-11-26 | 2016-02-24 | 深圳市金证科技股份有限公司 | Database operation code generating method and apparatus |
-
2016
- 2016-05-27 CN CN201610370032.XA patent/CN106095792A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102117202A (en) * | 2009-12-30 | 2011-07-06 | 北大方正集团有限公司 | J2EE architecture-based code generating device |
| CN102541521A (en) * | 2010-12-17 | 2012-07-04 | ***股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN102508876A (en) * | 2011-10-17 | 2012-06-20 | 无锡诺宝科技发展有限公司 | Information management system combined with database sheet and configuration file |
| CN105354036A (en) * | 2015-11-26 | 2016-02-24 | 深圳市金证科技股份有限公司 | Database operation code generating method and apparatus |
Cited By (34)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108170661A (en) * | 2016-12-07 | 2018-06-15 | 北京京东尚科信息技术有限公司 | A kind of management method and system of rule text |
| CN108170661B (en) * | 2016-12-07 | 2022-04-12 | 北京京东尚科信息技术有限公司 | Method and system for managing rule text |
| CN106844758A (en) * | 2017-02-17 | 2017-06-13 | 安图实验仪器(郑州)有限公司 | Data set code generating method |
| CN107818157A (en) * | 2017-10-31 | 2018-03-20 | 北京酷我科技有限公司 | A kind of SQL statement method for packing based on FMDB |
| CN107818157B (en) * | 2017-10-31 | 2021-06-29 | 北京酷我科技有限公司 | SQL statement packaging method based on FMDB |
| CN110019229B (en) * | 2017-12-25 | 2022-04-15 | 航天信息股份有限公司 | Database configuration system |
| CN110019229A (en) * | 2017-12-25 | 2019-07-16 | 航天信息股份有限公司 | Database configures system |
| CN108334621A (en) * | 2018-02-08 | 2018-07-27 | 平安科技（深圳）有限公司 | Database operation method, device, equipment and computer readable storage medium |
| CN111095195A (en) * | 2018-03-15 | 2020-05-01 | 欧姆龙株式会社 | Controller, control method, and control program |
| CN111095195B (en) * | 2018-03-15 | 2023-10-27 | 欧姆龙株式会社 | Controller, control method, and storage medium |
| CN109062925B (en) * | 2018-06-06 | 2023-08-22 | 中国平安人寿保险股份有限公司 | Method, device, computer equipment and storage medium for automatically generating insert sentences |
| CN109062925A (en) * | 2018-06-06 | 2018-12-21 | 中国平安人寿保险股份有限公司 | Automatically generate the method, apparatus, computer equipment and storage medium of insert sentence |
| CN109055235A (en) * | 2018-08-20 | 2018-12-21 | 云南农业大学 | A kind of preparation of the inoculating microbes strain for Pu'er tea pile fermentation and its application method |
| CN109446255A (en) * | 2018-09-30 | 2019-03-08 | 珠海沙盒网络科技有限公司 | A kind of storage method and system that can be adaptive |
| CN109582647B (en) * | 2018-11-21 | 2022-09-30 | 珠海市新德汇信息技术有限公司 | Unstructured evidence file oriented analysis method and system |
| CN109582647A (en) * | 2018-11-21 | 2019-04-05 | 珠海市新德汇信息技术有限公司 | A kind of analysis method and system towards the unstructured instrument of evidence |
| CN110113196A (en) * | 2019-04-26 | 2019-08-09 | 中车青岛四方机车车辆股份有限公司 | A kind of protocol configuration method, device, equipment and medium |
| CN110113196B (en) * | 2019-04-26 | 2022-04-15 | 中车青岛四方机车车辆股份有限公司 | Protocol configuration method, device, equipment and medium |
| CN111752964A (en) * | 2019-06-10 | 2020-10-09 | 北京京东尚科信息技术有限公司 | Data processing method and device based on data interface |
| CN110795101B (en) * | 2019-09-18 | 2024-01-30 | 平安科技（深圳）有限公司 | SQL code information display method, device, computer device and storage medium |
| CN110795101A (en) * | 2019-09-18 | 2020-02-14 | 平安科技（深圳）有限公司 | SQL code information display method and device, computer device and storage medium |
| CN111597163A (en) * | 2020-03-26 | 2020-08-28 | 中国南方航空股份有限公司 | Memory database |
| CN113676437B (en) * | 2020-05-14 | 2023-08-18 | ***通信集团云南有限公司 | Parameter acquisition method, parameter setting method and device |
| CN113676437A (en) * | 2020-05-14 | 2021-11-19 | ***通信集团云南有限公司 | Parameter analysis method, parameter acquisition method, parameter setting method and device |
| CN111966718A (en) * | 2020-09-09 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | System and method for data propagation tracking of application systems |
| CN111966718B (en) * | 2020-09-09 | 2024-03-15 | 支付宝(杭州)信息技术有限公司 | System and method for data propagation tracking of application systems |
| CN112631567A (en) * | 2020-12-30 | 2021-04-09 | 中国农业银行股份有限公司 | Method and device for generating database operation file |
| CN112799643A (en) * | 2021-01-26 | 2021-05-14 | 中国工商银行股份有限公司 | Front-end page application development method and device based on database mapping dynamic interface |
| CN112799643B (en) * | 2021-01-26 | 2024-02-20 | 中国工商银行股份有限公司 | Front-end page application development method and device based on database mapping dynamic interface |
| CN112905624A (en) * | 2021-02-26 | 2021-06-04 | 浪潮通用软件有限公司 | Database extension method and device of low-code development platform |
| CN113641745A (en) * | 2021-08-18 | 2021-11-12 | 上海通联金融服务有限公司 | Method for operating database across language platforms |
| CN113641745B (en) * | 2021-08-18 | 2024-01-26 | 上海通联金融服务有限公司 | Method for operating database by cross-language platform |
| CN115334177B (en) * | 2022-07-07 | 2023-12-05 | 浙江众合科技股份有限公司 | Binary data message analysis method based on xml configuration file recursion realization |
| CN115334177A (en) * | 2022-07-07 | 2022-11-11 | 浙江众合科技股份有限公司 | Binary data message analysis method based on xml configuration file recursion |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106095792A (en) | The method and apparatus generating database manipulation code | |
| EP3514694B1 (en) | Query translation | |
| US7526503B2 (en) | Interactive schema translation with instance-level mapping | |
| CN107092656B (en) | A kind of tree data processing method and system | |
| CN110837492B (en) | Method for providing data service by multi-source data unified SQL | |
| Cerf et al. | An Experimental Service for Adaptable Data Reconfiguration | |
| US7860823B2 (en) | Generic interface for deep embedding of expression trees in programming languages | |
| US20140156282A1 (en) | Method and system for controlling target applications based upon a natural language command string | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| AU2006200383A1 (en) | Mapping of a file system model to a database object | |
| CN101901265B (en) | Objectification management system of virtual test data | |
| CN106844380A (en) | A kind of database operation method, information processing method and related device | |
| CN109840256A (en) | A kind of inquiry implementation method based on Business Entity | |
| CN112235311B (en) | OVSDB client code automatic generation method, system, device and medium | |
| US11995075B2 (en) | System and method for efficient transliteration of machine interpretable languages | |
| CN106843827A (en) | A kind of target software generation method and device based on work(part tree and work(part storehouse | |
| CN113157723B (en) | SQL access method for Hyperridge Fabric | |
| CN105302842A (en) | Data processing method and device | |
| Sprinkle et al. | The new metamodeling generation | |
| Hidaka et al. | Towards a compositional approach to model transformation for software development | |
| CN112765209A (en) | SQL statement syntax migration method and system between databases | |
| CN108153522B (en) | Method for generating Spark and Hadoop program codes by midcore based on model conversion | |
| CN109116828B (en) | Method and device for configuring model codes in controller | |
| CN116628066B (en) | Data transmission method, device, computer equipment and storage medium | |
| CN108984631A (en) | A kind of generation of big data and call method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161109 |