CN108153897A - A kind of PLSQL program codes generation method and system - Google Patents
A kind of PLSQL program codes generation method and system Download PDFInfo
- Publication number
- CN108153897A CN108153897A CN201810021557.1A CN201810021557A CN108153897A CN 108153897 A CN108153897 A CN 108153897A CN 201810021557 A CN201810021557 A CN 201810021557A CN 108153897 A CN108153897 A CN 108153897A
- Authority
- CN
- China
- Prior art keywords
- parameter
- program
- data
- template
- user
- 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.)
- Granted
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/21—Design, administration or maintenance of databases
-
- 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/2423—Interactive query statement specification based on a database schema
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
- G06F8/44—Encoding
- G06F8/447—Target code generation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Stored Programmes (AREA)
Abstract
The present invention provides a kind of PLSQL program codes generation method and system, wherein, method includes：Receive and store the data mapping information that user is configured by data process method configuration interface；Process template is generated according to the data mapping information of user configuration；Process template is loaded into the page, for the parameter of user's setting program template；PLSQL program codes are automatically generated according to process template and parameter set by user.The present invention has the characteristics that code building is efficient, code quality is excellent independent of software engineer and data process method.
Description
Technical field
The invention belongs to code building field more particularly to a kind of PLSQL program codes generation methods and system.
Background technology
When PLSQL programs are used in software systems, the generation of PLSQL programs is typically necessary through software engineer couple
The understanding hand-coding PLSQL program codes of data process method.This mode will have two necessary conditions：First, engineering
Teacher is appreciated that the logic of data processing；Second is that engineer, which will write program, realizes data process method.This mode presence is very big
The drawbacks of, it is mainly reflected in following several respects：
A, the generation of program code depends on data process method, and program code needs to coordinate after data process method variation
Variation, and under normal circumstances data process method can change with the understanding to business and constantly in addition software go into operation after still can
There is a large amount of data process method to change, therefore the variation of data process method is huge on program code influence；
B, it is low to write code efficiency, under exploitation code efficiency is very low by way of engineer's manual coding, each
The size of code that engineer generates daily is limited；
C, code quality is difficult to ensure that, the technical merit of engineer differs, and the program code quality write is irregular, matter
Amount is very difficult to ensure；
D, data process method is mostly preserved in a manner of excel documents, is needed after data process method changes
Will update excel documents by hand in time again, when needing more than newer document and frequently the update workload of the document greatly and
It is very easy to error；
E, programmed logic depends critically upon software engineer, when software engineer leaves office or transfer part PLSQL codes behind the door
Maintenance cost abruptly increase.
Invention content
There are depended software engineers and data processing to patrol for PLSQL code buildings for solving in the prior art by the present invention
Volume, there are the defects of code building efficiency is low, quality is difficult to ensure that.
In one embodiment, a kind of PLSQL program codes generation method is provided, including：
Receive and store the data mapping information that user is configured by data process method configuration interface；
Process template is generated according to the data mapping information of user configuration；
Process template is loaded into the page, for the parameter of user's setting program template；
PLSQL program codes are automatically generated according to process template and parameter set by user.
In another embodiment, a kind of PLSQL program codes generation system is also provided, including：
Data mapping management module for providing data process method configuration interface, receives and stores user and passes through data
Handle the data mapping information of logic configuration interface configuration；
Masterplate management module, for generating process template according to the data mapping information of user configuration；
Program management module, for process template to be loaded into the page, for the parameter of user's setting program template；
Program generating module, for automatically generating PLSQL program codes according to process template and parameter set by user.
The present invention is deposited by data process method configuration interface configuration data map information (including data process method)
The data mapping information of configuration is stored up so that system automatically generated PLSQL program codes use, data process method can be convenient for
It safeguards；The data mapping information that configured in advance is got well and stored automatically generates PLSQL program codes, can improve PLSQL programs
The formation speed of code.
Description of the drawings
In order to illustrate the technical solution of the embodiments of the present invention more clearly, required use in being described below to embodiment
Attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only some embodiments of the present invention, for this
For the those of ordinary skill of field, without creative efforts, others are can also be obtained according to these attached drawings
Attached drawing.
Fig. 1 is the flow chart of the PLSQL program code generation methods of the embodiment of the present invention；
Fig. 2A~Fig. 2 D are data process method configuration interface schematic diagram of the embodiment of the present invention；
Fig. 3 is that the PLSQL program codes of the embodiment of the present invention generate the structure chart of system.
Specific embodiment
In order to make the technical characterstic of the present invention and effect more obvious, technical scheme of the present invention is done below in conjunction with the accompanying drawings
It further illustrates, the specific example that the present invention also can have other different is illustrated or implements, any those skilled in the art
The equivalents done within the scope of the claims belong to the protection category of the present invention.
In the description of this specification, reference term " embodiment ", " specific embodiment ", " such as " etc. description meaning
Refer at least one reality that the present invention is contained in reference to the embodiment or example particular features, structures, materials, or characteristics described
It applies in example or example.In the present specification, schematic expression of the above terms are not necessarily referring to identical embodiment or show
Example.Moreover, particular features, structures, materials, or characteristics described can be in any one or more embodiments or example
It combines in an appropriate manner.The step of involved in each embodiment, is sequentially used to schematically illustrate the implementation of the present invention, step therein
Suddenly it is sequentially not construed as limiting, can appropriately adjust as needed.
As shown in FIG. 1, FIG. 1 is the flow charts of the PLSQL program code generation methods of one embodiment of the invention.The present invention is logical
PLSQL program codes can quickly and easily be automatically generated by crossing simple configuration, specifically, the PLSQL program codes generate
Method includes：
Step S101 receives the data mapping information that user is configured by data process method configuration interface, user is matched
The data mapping information put is stored in oracle database, and user refers to software engineer in the present invention；
Step S102 generates process template according to the data mapping information of user configuration, which is configuration program
Skeleton；
Process template is loaded into the page by step S103 according to user's operation, such as data process method configuration interface, for
The parameter of user's setting program template；
Step S104 automatically generates PLSQL program codes according to process template and parameter set by user.
In one embodiment of the invention, data process method configuration interface includes：Object table and source table setting interface, interfield
Incidence relation setting interface and packet setting connect between mapping relations setting interface, source table screening conditions setting interface, source table
Mouthful.As shown in Figure 2 A, software engineer can be clicked mouse, the configuration of data mapping information is realized by way of keypad editor,
The present invention is to realizing that the configuration mode of data mapping information does not limit.During implementation, data process method configuration interface further includes
Inquiry, modification and deletion interface etc., for inquiring, changing and deleting data mapping.Correspondingly, data mapping information includes：Source
Incidence relation, grouping condition between the mapping relations of table and object table interfield, the screening conditions of source table, source table.
Specifically, data process method configuration interface access oracle database, object table and source table are stored in
In oracle database, similar to excel tables, source table is to carry out the tables of data that is participated in of data process method, object table
To the tables of data that the data that source table generated after data process method are deposited in, interface is set to set by object table and source table
The field in display target table and source table is understood after good object table and source table.Interfield mapping relations is relate in data process method
And the source table arrived and object table be in the overall correspondence such as field processing relationship, source table screening conditions, as source Table A and source table B lead to
It crosses certain processing logic (such as field is added) and has eventually formed object table C.Processing logic is the processing request to data, e.g.,
Value data is summarized, averaging etc..
In one embodiment of the invention, in above-mentioned steps S102, program mould is generated according to the data mapping information of user configuration
The data mapping information of user configuration is inserted into the default program masterplate pre-established by version.Generate the process of program masterplate
By system automatic trigger or by software engineer generation program masterplate can be triggered according to page prompts.
In one specific embodiment, as shown in Figure 2 B, data process method configuration interface is additionally provided with masterplate management module, on
It states in step S102, software engineer clicks " Template Manager " button, and selection " the increasing template " button in open interface is
" mapping tree ", " template tree ", " template preview " three spaces of a whole page can be presented in system.Wherein, data are shown in " mapping tree " space of a whole page
Map information, the data mapping information are the main contents for generating data mart modeling logic.Acquiescence has one in " template tree " space of a whole page
The default program template that a system provides, each entry in default program template are known as template elements, and template elements are minimum
Unit, default program template are made of various types of template elements discharged in a designated order, and template elements are reflected including data
Penetrate information, decision logic etc..During implementation, default program template can be modified by software engineer, it as needed will " mapping
Map information in tree " is dragged to the designated position in default program template, can also be in acquiescence journey such as the mode 1 in Fig. 2 C
Increase element in sequence template by way of right button, and pass through input through keyboard element content, such as the mode 2 in Fig. 2 C, while
It can will determine that logic (such as if else while), log recording etc. are placed in default program template, the right side can also be passed through
Key deletes useless element (data mapping, decision logic, daily record etc.).Template elements click save button after correctly setting
The program masterplate of generation is saved in database, and give a name.The process template can be utilized to regenerate it for source in the future
Its template modifies to it, deletes, generating program in machine code etc..
When it is implemented, can also separately be deposited process template (just as separately depositing word document) by saving as button, lead to
Cross the code situation (ginseng in the program code of preview here that preview button checks the process template in the template preview space of a whole page
Number is still parameter, and when generating program, the code generated after modifying to parameter is only really executable code), and
Template is adjusted as needed, until meeting the requirement of software engineer.
In one embodiment of the invention, the parameter in above-mentioned steps S103 includes but not limited to date parameter, region parameter, work
Industry ID parameters, program description information parameter (function description, Chinese etc.), data mart modeling mode parameter, log processing parameter,
One or more of exception handling parameter, such as IS, the Create or replace procedure in the masterplate number in Fig. 2 D
Content under PRG_NAME files.
Parameter in program masterplate is placeholder, it is impossible to be directly used in program operation.For example, include in process template
" ic_period " parameter, and the parameter only represents the time cycle of PLSQL programs operation, when program actual motion, need root
Factually the date (" 20170801 ", " 20170901 ") on border is replaced.
In one specific embodiment, as shown in Figure 2 D, data process method configuration interface is additionally provided with program management module, soft
Part engineer clicks " program management " button, and " newly-increased program " button is selected in open interface, and " template can be presented in system
Tree ", " masterplate-program field relationship ", " masterplate preview " three spaces of a whole page click " loading template " button, select a step
The designed process templates of S102, at this moment can show the content of process template in the template tree space of a whole page, and user is double-clicked in template tree
Each element the relationship of the corresponding practical value of the parameter can be shown in " template-program field relationship " space of a whole page, this
When software engineer practical parameter can be inputted in the input frame of specific value, if user has double-clicked " ic_period " parameter,
At this moment can in " template-program field relationship " display parameters and practical value correspondence, at this moment user may input
The dates such as " 20170801 ".Other parameters can also carry out parameter replacement in such a way.All parameters is real
Actual value replace after the completion of can by preserve (or separately depositing) button program is preserved into database, the program at this moment preserved be by
Process template, parameter specific value collectively form.Because template is constant, the only corresponding practical value of parameter of change, therefore
Can reach a template can generate the target of branched program.
In one embodiment of the invention, when above-mentioned steps S400 is implemented, pass through Program Generating engine reading database Program
Masterplate, program parameter information in program parameter information dynamic combined to program masterplate, will form final significant code text
Part, and be saved in the file directory of operating system of windows or linux.Using this method can batch automatically generate it is more
A program.
The method generation one by the present invention is illustrated how by taking customer table, credit existing for banking system as an example below
The PLSQL program codes that a gender for counting certain province summarizes for the account balance of all clients of male.
First, pass through data process method configuration interface configuration data map information.
1. software engineer includes customer table and credit, target by the source table that data process method configuration interface is configured
Table is each province and city remaining sum summary sheet.Wherein, the essential information of customer table customer and credit account such as table one, client
Table customer concrete structures such as table two, credit account concrete structures such as table three, each province and city remaining sum summary sheet cus_
Area_sumbal such as tables four.
Table one：
| Table name | Storage content explanation | Remarks (field) |
| Customer table | Store the essential information of client | Such as customer ID, age, occupation |
| Credit | Store each account information of client | Such as account, remaining sum, account status |
Table two：
Table three：
| Field name | Field English name | Field type | Value explanation |
| Customer ID | cus_no | number(11) | Represent this account is which client belonged to |
| Account | acc_no | number(18) | The coding of certain account of client |
| Remaining sum | bal | number(18,2) | Account balance |
| It opens an account the date | open_dt | date | The date created an account |
| Account status | acc_stat | varchar2(2) | It opens an account, cancellation etc. |
Table four：
| Field name | Field English name | Field type | Value explanation |
| Province number | area_no | varchar2(5) | Provinces and cities' code |
| Remaining sum summarizes | bal_sum | number(18,2) | The remaining sum aggregate value of certain provinces and cities |
2. software engineer is closed by the mapping of the source table that data process method configuration interface is configured and object table interfield
System is as shown in Table 5.
Table five：
| Source table table name | Source literary name section | Handle logic | Target table name | Aiming field |
| customer | area_no | Directly map | cus_area_sumbal | area_no |
| account | bal | sum(bal) | cus_area_sumbal | bal_sum |
3. incidence relation is between the source table that software engineer is configured by data process method configuration interface：
Customer.cus_no=account.cus_no, i.e.,：The customer ID of customer table is associated with the client of credit.
4. the source table screening conditions that software engineer is configured by data processing configuration interface are：Customer.sex='
1', i.e.,：Only remaining sum of the statistics client gender for the client of " man ".
5. the grouping condition that software engineer is configured by data processing configuration interface is：group by
Customer.area_no, that is, summarized according to provinces and cities number.
The 2nd, the data mapping information that the first step is configured is inserted into the default program masterplate pre-established (including running day
The information such as phase, operating mechanism) in, obtain newly-built program masterplate.
3rd, the program masterplate that second step creates is loaded onto the page, so that software engineer is set in newly-built program masterplate
Actual operation parameters, such as to run the total program of remaining sum of Beijing, operating mechanism number can be set as 40142 and (represent Beijing
City).
4th, it is raw in the program masterplate for creating actual operation parameters dynamic combined to the second step that software engineer sets
Into PLSQL program in machine codes.
Based on same inventive concept, a kind of PLSQL program codes generation system is additionally provided in the embodiment of the present invention, it is as follows
Described in the embodiment in face.Since the principle that the system solves the problems, such as is similar to PLSQL program code generation methods, the system
Implementation may refer to the implementation of PLSQL program code generation methods, overlaps will not be repeated.
Specifically, as shown in figure 3, PLSQL program codes generation system includes：
Data mapping management module 301 for providing data process method configuration interface, receives and stores user and passes through number
According to the data mapping information of processing logic configuration interface configuration；
Masterplate management module 302, for generating process template according to the data mapping information of user configuration；
Program management module 303, for process template to be loaded into the page, for the parameter of user's setting program template；
Program generating module 304, for automatically generating PLSQL program generations according to process template and parameter set by user
Code.
Specifically, data process method configuration interface includes：Object table and source table setting interface, interfield mapping relations
Incidence relation setting interface, packet setting interface between interface, source table screening conditions setting interface, source table are set.
Data mapping information includes：Between the mapping relations of source table and object table interfield, the screening conditions of source table, source table
Incidence relation, grouping condition.
Parameter includes date parameter, region parameter, operation ID parameters, program description information parameter, data mart modeling mode and joins
One or more of number, log processing parameter, exception handling parameter.
In one embodiment of the invention, a kind of computer equipment is also provided, including memory, processor and is stored in memory
Computer program that is upper and can running on a processor, the processor realize above-described embodiment when performing the computer program
The PLSQL program code generation methods.
In one embodiment of the invention, a kind of computer readable storage medium, computer-readable recording medium storage are also provided
There is the computer program for performing the PLSQL program code generation methods described in above-described embodiment.
The present invention can realize following technique effect：
A, tremendous influence will not be brought because the variation of data process method is recompiled to program, it is only necessary to pass through system weight
Newly-generated portion program code, the workload recompiled are almost nil；
B, because by system automatically generated code, therefore the formation efficiency of code greatly improves；
C, code quality is high；
D, data process method is independent of software engineer, when software engineer leaves office or transfer part PLSQL codes behind the door
Maintenance cost it is constant.
It should be understood by those skilled in the art that, the embodiment of the present invention can be provided as method, system or computer program
Product.Therefore, the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware can be used in the present invention
Apply the form of example.Moreover, the computer for wherein including computer usable program code in one or more can be used in the present invention
The computer program production that usable storage medium is implemented on (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The present invention be with reference to according to the method for the embodiment of the present invention, the flow of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that it can be realized by computer program instructions every first-class in flowchart and/or the block diagram
The combination of flow and/or box in journey and/or box and flowchart and/or the block diagram.These computer programs can be provided
The processor of all-purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that the instruction performed by computer or the processor of other programmable data processing devices is generated for real
The device of function specified in present one flow of flow chart or one box of multiple flows and/or block diagram or multiple boxes.
These computer program instructions, which may also be stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction generation being stored in the computer-readable memory includes referring to
Enable the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one box of block diagram or
The function of being specified in multiple boxes.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps are performed on calculation machine or other programmable devices to generate computer implemented processing, so as in computer or
The instruction offer performed on other programmable devices is used to implement in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in a box or multiple boxes.
The above is merely to illustrate technical scheme of the present invention, any those of ordinary skill in the art can without prejudice to
Under the spirit and scope of the present invention, above-described embodiment is modified and is changed.Therefore, the scope of the present invention should regard
Subject to right.
Claims (10)
1. a kind of PLSQL program codes generation method, which is characterized in that including：
Receive and store the data mapping information that user is configured by data process method configuration interface；
Process template is generated according to the data mapping information of user configuration；
Process template is loaded into the page, for the parameter of user's setting program template；
PLSQL program codes are automatically generated according to process template and parameter set by user.
2. the method as described in claim 1, which is characterized in that the data process method configuration interface includes：Object table and
Incidence relation setting connects between source table setting interface, interfield mapping relations setting interface, source table screening conditions setting interface, source table
Mouth, packet setting interface.
3. the method as described in claim 1, which is characterized in that the data mapping information includes：Source table and target literary name section
Between mapping relations, the screening conditions of source table, the incidence relation between the table of source, grouping condition.
4. the method as described in claim 1, which is characterized in that the parameter includes date parameter, region parameter, operation ID ginsengs
One or more of number, program description information parameter, data mart modeling mode parameter, log processing parameter, exception handling parameter.
5. a kind of PLSQL program codes generate system, which is characterized in that including：
Data mapping management module for providing data process method configuration interface, receives and stores user and passes through data processing
The data mapping information of logic configuration interface configuration；
Masterplate management module, for generating process template according to the data mapping information of user configuration；
Program management module, for process template to be loaded into the page, for the parameter of user's setting program template；
Program generating module, for automatically generating PLSQL program codes according to process template and parameter set by user.
6. system as claimed in claim 5, which is characterized in that the data process method configuration interface includes：Object table and
Incidence relation setting connects between source table setting interface, interfield mapping relations setting interface, source table screening conditions setting interface, source table
Mouth, packet setting interface.
7. system as claimed in claim 5, which is characterized in that the data mapping information includes：Source table and target literary name section
Between mapping relations, the screening conditions of source table, the incidence relation between the table of source, grouping condition.
8. system as claimed in claim 5, which is characterized in that the parameter includes date parameter, region parameter, operation ID ginsengs
One or more of number, program description information parameter, data mart modeling mode parameter, log processing parameter, exception handling parameter.
9. a kind of computer equipment including memory, processor and stores the meter that can be run on a memory and on a processor
Calculation machine program, which is characterized in that the processor realizes any side of Claims 1-4 when performing the computer program
Method.
10. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has perform claim
It is required that the computer program of 1 to 4 any the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810021557.1A CN108153897B (en) | 2018-01-10 | 2018-01-10 | PLSQL program code generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810021557.1A CN108153897B (en) | 2018-01-10 | 2018-01-10 | PLSQL program code generation method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108153897A true CN108153897A (en) | 2018-06-12 |
| CN108153897B CN108153897B (en) | 2022-04-12 |
Family
ID=62461057
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810021557.1A Active CN108153897B (en) | 2018-01-10 | 2018-01-10 | PLSQL program code generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108153897B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108897728A (en) * | 2018-06-27 | 2018-11-27 | 平安科技（深圳）有限公司 | Short message splicing processing method, device, computer equipment and storage medium |
| CN108920134A (en) * | 2018-06-27 | 2018-11-30 | 中国建设银行股份有限公司 | The method and device of Design of automatic generation document |
| CN109408043A (en) * | 2018-10-19 | 2019-03-01 | 中国银行股份有限公司 | A kind of program creating method and device |
| CN109710300A (en) * | 2018-11-29 | 2019-05-03 | 中国北方车辆研究所 | A kind of software architecture of calibration and diagnostic software version management |
| CN110489128A (en) * | 2019-08-23 | 2019-11-22 | 第四范式（北京）技术有限公司 | The method and apparatus that feature calculation script is converted into underlying programs code |
| CN110968311A (en) * | 2018-09-30 | 2020-04-07 | 北京嘀嘀无限科技发展有限公司 | Front-end page construction method and device and electronic equipment |
| CN111427568A (en) * | 2020-03-30 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Interface configuration method and device |
| CN111638873A (en) * | 2020-05-21 | 2020-09-08 | 平安普惠企业管理有限公司 | Program code generation method and device, computer equipment and storage medium |
| CN112307097A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Data asset management method and device |
| CN112860248A (en) * | 2019-11-27 | 2021-05-28 | 中盈优创资讯科技有限公司 | Source code generation method and device |
| CN113867699A (en) * | 2021-10-21 | 2021-12-31 | 中国工商银行股份有限公司 | Method, device, equipment, medium and program product for implementing service system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050257193A1 (en) * | 2004-05-13 | 2005-11-17 | Alexander Falk | Method and system for visual data mapping and code generation to support data integration |
| CN101727324A (en) * | 2009-12-17 | 2010-06-09 | 中国电力科学研究院 | Code generation method and device |
| CN102033748A (en) * | 2010-12-03 | 2011-04-27 | 中国科学院软件研究所 | Method for generating data processing flow codes |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| CN104317604A (en) * | 2014-11-13 | 2015-01-28 | 中国建设银行股份有限公司 | Program code generating method and device |
| CN105487864A (en) * | 2015-11-26 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and device for automatically generating code |
| CN106777101A (en) * | 2016-12-14 | 2017-05-31 | 深圳天源迪科信息技术股份有限公司 | Data processing engine |
-
2018
- 2018-01-10 CN CN201810021557.1A patent/CN108153897B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050257193A1 (en) * | 2004-05-13 | 2005-11-17 | Alexander Falk | Method and system for visual data mapping and code generation to support data integration |
| CN101727324A (en) * | 2009-12-17 | 2010-06-09 | 中国电力科学研究院 | Code generation method and device |
| CN102033748A (en) * | 2010-12-03 | 2011-04-27 | 中国科学院软件研究所 | Method for generating data processing flow codes |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN104317604A (en) * | 2014-11-13 | 2015-01-28 | 中国建设银行股份有限公司 | Program code generating method and device |
| CN105487864A (en) * | 2015-11-26 | 2016-04-13 | 北京京东尚科信息技术有限公司 | Method and device for automatically generating code |
| CN106777101A (en) * | 2016-12-14 | 2017-05-31 | 深圳天源迪科信息技术股份有限公司 | Data processing engine |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108897728A (en) * | 2018-06-27 | 2018-11-27 | 平安科技（深圳）有限公司 | Short message splicing processing method, device, computer equipment and storage medium |
| CN108920134A (en) * | 2018-06-27 | 2018-11-30 | 中国建设银行股份有限公司 | The method and device of Design of automatic generation document |
| CN108920134B (en) * | 2018-06-27 | 2022-05-20 | 中国建设银行股份有限公司 | Method and device for automatically generating design document |
| CN110968311A (en) * | 2018-09-30 | 2020-04-07 | 北京嘀嘀无限科技发展有限公司 | Front-end page construction method and device and electronic equipment |
| CN109408043A (en) * | 2018-10-19 | 2019-03-01 | 中国银行股份有限公司 | A kind of program creating method and device |
| CN109710300A (en) * | 2018-11-29 | 2019-05-03 | 中国北方车辆研究所 | A kind of software architecture of calibration and diagnostic software version management |
| CN110489128A (en) * | 2019-08-23 | 2019-11-22 | 第四范式（北京）技术有限公司 | The method and apparatus that feature calculation script is converted into underlying programs code |
| CN110489128B (en) * | 2019-08-23 | 2023-08-29 | 第四范式（北京）技术有限公司 | Method and apparatus for converting feature computation script into underlying program code |
| CN112860248A (en) * | 2019-11-27 | 2021-05-28 | 中盈优创资讯科技有限公司 | Source code generation method and device |
| CN112860248B (en) * | 2019-11-27 | 2023-12-05 | 中盈优创资讯科技有限公司 | Source code generation method and device |
| CN111427568A (en) * | 2020-03-30 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Interface configuration method and device |
| CN111638873A (en) * | 2020-05-21 | 2020-09-08 | 平安普惠企业管理有限公司 | Program code generation method and device, computer equipment and storage medium |
| CN112307097A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Data asset management method and device |
| CN113867699A (en) * | 2021-10-21 | 2021-12-31 | 中国工商银行股份有限公司 | Method, device, equipment, medium and program product for implementing service system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108153897B (en) | 2022-04-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108153897A (en) | A kind of PLSQL program codes generation method and system | |
| US11003645B1 (en) | Column lineage for resource dependency system and graphical user interface | |
| DE102016105472B4 (en) | Storage tiering and block-level parallel allocation in file systems | |
| US10838982B2 (en) | System and method for aggregating values through risk dimension hierarchies in a multidimensional database environment | |
| US9424333B1 (en) | Systems and user interfaces for dynamic and interactive report generation and editing based on automatic traversal of complex data structures | |
| US10372807B1 (en) | Systems and user interfaces for dynamic and interactive table generation and editing based on automatic traversal of complex data structures in a distributed system architecture | |
| US9798781B2 (en) | Strategy trees for data mining | |
| US8996453B2 (en) | Distribution of data in a lattice-based database via placeholder nodes | |
| US20220092256A1 (en) | Method, system, and computing device for facilitating private drafting | |
| US20190102447A1 (en) | System and method for metadata sandboxing and what-if analysis in a multidimensional database environment | |
| US8533235B2 (en) | Infrastructure and architecture for development and execution of predictive models | |
| US11783254B2 (en) | Method and system for implementing an adaptive data governance system | |
| US20110161374A1 (en) | Systems and methods for conditioned distribution of data in a lattice-based database using spreading rules | |
| CN103246733A (en) | Dynamic form system based on metadata and generation method thereof | |
| CN104142930B (en) | General δ data load | |
| US20180285394A1 (en) | System and Method for Data Integration | |
| CN106294521A (en) | Date storage method and data warehouse | |
| US8364687B2 (en) | Systems and methods for binding multiple interpolated data objects | |
| US20190272071A1 (en) | Automatic generation of a hierarchically layered collaboratively edited document view | |
| US20110225484A1 (en) | Cloud based modeling for enhancing spreadsheets | |
| CN110263233A (en) | Enterprise's public sentiment base construction method, device, computer equipment and storage medium | |
| CN105117446A (en) | Railway main data full life circle management method and railway main data full life circle management system | |
| WO2023098034A1 (en) | Business data report classification method and apparatus | |
| CN110471668A (en) | Improve the method and device of the software compatibility | |
| CN113407980B (en) | Data annotation system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |