[go: up one dir, main page]
More Web Proxy on the site http://driver.im/

CN112631567A - Method and device for generating database operation file - Google Patents

Method and device for generating database operation file Download PDF

Info

Publication number
CN112631567A
CN112631567A CN202011623396.7A CN202011623396A CN112631567A CN 112631567 A CN112631567 A CN 112631567A CN 202011623396 A CN202011623396 A CN 202011623396A CN 112631567 A CN112631567 A CN 112631567A
Authority
CN
China
Prior art keywords
data
file
column
database
language
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
Application number
CN202011623396.7A
Other languages
Chinese (zh)
Inventor
朱全鑫
李冉冉
高绍洁
赵鹏
陈旭
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Agricultural Bank of China
Original Assignee
Agricultural Bank of China
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Agricultural Bank of China filed Critical Agricultural Bank of China
Priority to CN202011623396.7A priority Critical patent/CN112631567A/en
Publication of CN112631567A publication Critical patent/CN112631567A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/31Programming languages or programming paradigms
    • G06F8/315Object-oriented languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/33Intelligent editors

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the application discloses a method and a device for generating a database operation file, wherein the method comprises the following steps: acquiring data of each column in at least one column of a target table; generating a first file according to the data of each column in at least one column, wherein the data in the first file conforms to a first program language; and calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on data by adopting the first program language, and the database operation file is used for operating the data of the database. Therefore, the first file can be automatically generated based on the database table, the database operation file for calling the first file is generated, a large amount of repeated code writing labor is reduced, the waste of personnel, time and energy is avoided, the generated codes of the database operation file are uniform and standard, and the later-stage uniform maintenance and modification are facilitated.

Description

Method and device for generating database operation file
Technical Field
The present application relates to the field of computers, and in particular, to a method and an apparatus for generating a database operation file.
Background
Currently, when data in a database is required to be processed, tables in the database are operated, and a code file for operating the database data is manually written on the basis of the data in the tables in the database.
However, in general, there are a lot of tables for the database, i.e. a lot of code files for processing the data in the database are written manually, which takes a lot of time and effort, and the code files have the same parts, and a lot of manual writing is wasted by personnel.
In summary, the existing code file for manually writing the data of the database wastes people, time and energy.
Disclosure of Invention
In order to solve the problem that in the prior art, personnel, time and energy are wasted when code files for processing data of a database are manually written, the application provides a method and a device for generating database operation files, and the code files for processing the database data can be automatically generated according to tables in the database.
The embodiment of the application provides a method for generating a database operation file, which comprises the following steps:
acquiring data of each column in at least one column of a target table;
generating a first file according to the data of each column in the at least one column, wherein the data in the first file conforms to a first program language;
calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on the data by adopting the first program language, and the database operation file is used for operating the data of the database.
Optionally, the generating a first file according to the data of each of the at least one column includes:
and converting the data format of the data of each column in the at least one column to obtain the first file.
Optionally, the data format includes: a data type;
the converting the data format of the data of each of the at least one column includes:
and converting the data type of the data into the data type of the first program language.
Optionally, before acquiring the data of each column in the at least one column of the target table, the method further includes:
and acquiring the target table from a Physical Data Model (PDM) file according to the table name of the target table.
Optionally, the first programming language is C language, and the second programming language is Java language.
An embodiment of the present application further provides a device for generating a database operation file, where the device includes:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring data of each column in at least one column of a target table;
the first generating unit is used for generating a first file according to the data of each column in the at least one column, and the data in the first file conforms to a first program language;
the second generating unit is configured to call the first file through a preset template file of a second program language, and generate a database operation file of the first program language, where the template file includes operation information for performing an operation on the data in the first program language, and the database operation file is used for operating the data in the database.
Optionally, the generating, by the first generating unit, the first file according to the data of each of the at least one column includes:
the first generating unit converts the data format of the data in each of the at least one column to obtain the first file.
Optionally, the data format includes: a data type;
the first generating unit converting a data format of data of each of the at least one column includes:
the first generation unit converts a data type of the data into a data type of a first program language.
Optionally, before the obtaining unit obtains the data of each column in the at least one column of the target table, the apparatus further includes:
and the target table acquisition unit is used for acquiring the target table from a Physical Data Model (PDM) file according to the table name of the target table.
Optionally, the first programming language is C language, and the second programming language is Java language.
Compared with the prior art, the method has the advantages that:
the embodiment of the application provides a method for generating a database operation file, which comprises the following steps:
acquiring data of each column in at least one column of a target table; generating a first file according to the data of each column in the at least one column, wherein the data in the first file conforms to a first program language; calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on the data by adopting the first program language, and the database operation file is used for operating the data of the database. Therefore, in the embodiment of the application, the data in the database table is generated into the first file of the first programming language through the preset template of the second programming language, and then the first file is called to generate the database operation file of the first programming language. According to the embodiment of the application, the first file can be automatically generated based on the database table, the database operation file for calling the first file is generated, a large amount of repeated code compiling labor is reduced, the waste of personnel, time and energy is avoided, the generated codes of the database operation file are uniform and standard, and the later-stage uniform maintenance and modification are facilitated.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments described in the present application, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flowchart of an embodiment of a method for generating a database operation file provided in the present application;
FIG. 2 is a schematic diagram of a database table provided herein;
FIG. 3 is a diagram illustrating a first document in a first programming language provided herein;
FIG. 4 is a diagram illustrating a database operation file in a first programming language provided herein;
fig. 5 is a block diagram illustrating a structure of an embodiment of an apparatus for generating a database operation file according to the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
As described in the background, the processing of data in a database mainly includes adding, deleting, modifying, querying, and the like to the data in the database. When data operation is performed on the data of the databases, the operation is realized based on the tables in the databases. When writing database operation programs based on database tables, it is usually written manually. However, there are a large number of tables in the database, and the final database operation procedure is partially repeated, which results in a great waste of personnel, time and energy if all are manually written.
Based on this, in the embodiment of the application, the data in the database table is generated into the first file of the first programming language through the preset template of the second programming language, and then the first file is called to generate the database operation file of the first programming language. According to the embodiment of the application, the first file can be automatically generated based on the database table, the database operation file for calling the first file is generated, a large amount of repeated code compiling labor is reduced, the waste of personnel, time and energy is avoided, the generated codes of the database operation file are uniform and standard, and the later-stage uniform maintenance and modification are facilitated.
Referring to fig. 1, the figure is a flowchart of a method for generating a database operation file according to an embodiment of the present application.
The method for generating the database operation file provided by the embodiment comprises the following steps:
step S101: data is obtained for each of at least one column of the target table.
In the embodiments of the present application, the target table refers to a table in the database, and the target table reflects attribute information of data in the database. Specifically, the target table can reflect attribute information such as the name of the data, the data type, the data length, and whether the data is a primary key. The target table comprises a plurality of columns, each column comprises data, and the data is distinguished according to the column name of each column, namely the data of each column has different attribute information. Specifically, the column name may include a name of the data, a data type, a data length, whether the data is a primary key, and the like.
As an example, as shown in fig. 2, it is a target table in a database. The target table is shown in FIG. 2 as a child table Column (Column) in the configuration table (tbtrans) for the transaction. The Column Name of each Column in Column is Name (Name), Code (Code), Data type (Data _ type), Data Length (Length), and whether it is a primary key (P). The Column name of each Column in Column reflects attribute information of data included in Column.
In an embodiment of the application, the template file of the second programming language obtains data of each column of the at least one column of the target table as a basis for generating the database operation file. Therefore, data acquisition and processing are required for data of each column in at least one column of the target table. Specifically, the second program language may be Java language.
In practical applications, before acquiring Data of each column of at least one column of the target table, the target table is also acquired from a Physical Data Model (PDM) file according to a table name of the target table. The PDM file contains a plurality of tables, each Table is called a Table object, and each Table includes a plurality of sub-tables, i.e., target tables. Each Table object includes attribute information such as an Identity Document (ID) of the Table, a name of the Table, and the like.
As an example, as shown in FIG. 2, the PDM file with the file name designed for the Bank protection V2.0 database includes a transaction configuration Table (tbtrans), i.e., the transaction configuration Table is a Table object. The transaction configuration table includes a plurality of sub-tables: columns (Column), triggers (Trigger), Keys (Keys), stored procedures (Procedure), Rules (Rules), Indexes (Indexes), and constraints (Check), among others.
As an implementation manner, the template file of the second programming language reads the PDM file with the specified file name, acquires information of all tables included in the PDM file, that is, acquires attribute information of all Table objects in the PDM file, and determines a Table from which data is to be acquired according to the attribute information of the Table objects. And acquiring the desired data by taking Column in the table for determining the desired data as a target table. For example, the Table to be acquired is determined as the transaction configuration Table by the attribute information of the Table name of the Table object, and the Column in the transaction configuration Table is used as the target Table.
Step S102: and generating a first file according to the data of each column in the at least one column, wherein the data in the first file conforms to a first program language.
In an embodiment of the present application, a first file is generated according to the data in each of the at least one column in the target table, that is, a code of the data is generated according to the data in each of the at least one column in the target table, wherein a format of the data in the first file conforms to the first program language. Specifically, the data format in the target table is the data format in the PDM file, and when the first file is generated, the data format may be converted into the data format in the first programming language, that is, the data format of the data in each column in at least one column in the target table is converted to obtain the first file. Specifically, the first program language may be a C language.
It should be noted that, the data format includes a data type, and thus, converting the data format of the data in each column of the at least one column in the target table includes: the data type of the data is converted into a data type of a first program language.
As an example, the first programming language is C, and the data types in the target table are data types in a PDM file. Table 1 shows the correspondence of data types in the target table to data types of the C language version.
TABLE 1 correspondence between data types in the target Table and data types of the C language version
Data types in target tables Data types of C language version
char char
integer long
decimal double
varchar char
It should be noted that, the data format further includes whether the data is a primary key, so that converting the data format of the data in each column of the at least one column in the target table includes: and converting the information whether the data is the primary key in the target table into the information whether the data is the primary key in the first program language.
As an example, as shown in FIG. 2, the information whether it is a primary key in the target table is reflected in a column with column name P: if the data is a main key, checking; and if the data is not the primary key, not checking. If the first program language is C language, in C language, number 1 represents data as main key; the number 0 indicates that the data is not a primary key. In the process of generating the first file for data format conversion, the data to be checked in the column P of the target table is denoted by the numeral 1 in the first file.
As an implementation manner, a first file is generated from data in each of at least one column in the target table, where the data in the target table is in a data format supported by the PDM file, and the data in the first file is in a data format supported by the C language. As shown in fig. 2, the following data can be found in Column of the transaction configuration information table in the PDM file:
Name Code Data_type Length P
company code corp_no char(4) 4
Changing the date modi_date integer
According to the rule of the data format conversion, the following data of the first file of the C language version can be obtained:
{“corp_no”,“corp_no”,“char”,4,1}
{“modi_date”,“modi_date”,“long”,9,1}
when the data type integer in the PDM file is converted into the data type long of the C language version, the data length is fixed to 9. When the data types are char, decimal and varchar, the data length is not changed in the process of data format conversion.
As an example, fig. 3 shows a first file generated from the data in the transaction configuration table in fig. 2, the first file being a code of a C language version and having a name b2i _ db _ tbtrans.
Step S103: calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on the data by adopting the first program language, and the database operation file is used for operating the data of the database.
In the embodiment of the application, the first file can be called through a preset template file of the second programming language, and the database operation file of the first programming language is generated. The preset template file of the second program language comprises operation information for executing operations on data by adopting the first program language, namely the template file comprises operation information for processing the data in the database by adopting the first program language, and the operation information comprises code statements for processing the data in the database by utilizing the first program language. Specifically, the second program language may be Java language. The database operation file is used for operating data of the database. Specifically, the operations may include adding, deleting, modifying and querying database data, and the query may include a primary key query or a conditional query. As an example, the name of the database operation file may be b2i _ db _ tbtrans.
As one implementation, the second programming language is Java, and the first programming language is C. The template file of Java language includes code statements for processing data of the database by C language, configuration information of a first file for generating C language version by data in the target table, and operation information of a database operation file for generating C language version by calling the first file.
As an example, a template file in Java language may specify a code statement of data queried by a primary key using a database operation file in C language version, for example, the primary keys in the tbtrans table are corp _ no, prod _ no, trans _ code, and then the code statement of the database operation file in output C language version may be specified as:
WHERE corp_no=:scorp_no AND prod_no=:sprod_no AND trans_code=:strans_code;
as an example, fig. 4 shows a database operation file of C language version generated by calling the first file of C language version in fig. 3, the name of the database operation file is b2i _ db _ tbtrans.cpre, and the name of the called first file is b2i _ db _ tbtrans.eh.
The embodiment of the application provides a method for generating a database operation file, which comprises the following steps: acquiring data of each column in at least one column of a target table; generating a first file according to the data of each column in the at least one column, wherein the data in the first file conforms to a first program language; calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on the data by adopting the first program language, and the database operation file is used for operating the data of the database. Therefore, in the embodiment of the application, the data in the database table is generated into the first file of the first programming language through the preset template of the second programming language, and then the first file is called to generate the database operation file of the first programming language. According to the embodiment of the application, the first file can be automatically generated based on the database table, the database operation file for calling the first file is generated, a large amount of repeated code compiling labor is reduced, the waste of personnel, time and energy is avoided, the generated codes of the database operation file are uniform and standard, and the later-stage uniform maintenance and modification are facilitated.
Based on the method for generating the database operation file provided by the above embodiment, the embodiment of the present application further provides a device for generating the database operation file, and the working principle of the device is described in detail below with reference to the accompanying drawings.
Referring to fig. 5, this figure is a block diagram of a structure of an apparatus for generating a database operation file according to an embodiment of the present application.
The device for generating the database operation file provided by the embodiment comprises:
an obtaining unit 510, configured to obtain data of each column in at least one column of the target table;
a first generating unit 520, configured to generate a first file according to data in each of the at least one column, where the data in the first file conforms to a first programming language;
a second generating unit 530, configured to call the first file through a preset template file of a second program language, and generate a database operation file of the first program language, where the template file includes operation information for performing an operation on the data in the first program language, and the database operation file is used to operate data of a database.
Optionally, the generating, by the first generating unit 520, a first file according to the data of each of the at least one column includes:
the first generating unit 520 converts a data format of the data in each of the at least one column to obtain the first file.
Optionally, the data format includes: a data type;
the first generating unit 520 converting the data format of the data of each of the at least one column includes:
the first generation unit 520 converts the data type of the data into a data type of a first program language.
Optionally, before the obtaining unit 510 obtains the data of each column in the at least one column of the target table, the apparatus further includes:
and the target table acquisition unit is used for acquiring the target table from a Physical Data Model (PDM) file according to the table name of the target table.
Optionally, the first programming language is C language, and the second programming language is Java language.
The embodiment of the application provides a device for generating a database operation file, which comprises: the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring data of each column in at least one column of a target table; the first generating unit is used for generating a first file according to the data of each column in the at least one column, and the data in the first file conforms to a first program language; the second generating unit is configured to call the first file through a preset template file of a second program language, and generate a database operation file of the first program language, where the template file includes operation information for performing an operation on the data in the first program language, and the database operation file is used for operating the data in the database. Therefore, in the embodiment of the application, the data in the database table is generated into the first file of the first programming language through the preset template of the second programming language, and then the first file is called to generate the database operation file of the first programming language. According to the embodiment of the application, the first file can be automatically generated based on the database table, the database operation file for calling the first file is generated, a large amount of repeated code compiling labor is reduced, the waste of personnel, time and energy is avoided, the generated codes of the database operation file are uniform and standard, and the later-stage uniform maintenance and modification are facilitated.
When introducing elements of various embodiments of the present application, the articles "a," "an," "the," and "said" are intended to mean that there are one or more of the elements. The terms "comprising," "including," and "having" are intended to be inclusive and mean that there may be additional elements other than the listed elements.
It should be noted that, as one of ordinary skill in the art would understand, all or part of the processes of the above method embodiments may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and when executed, the computer program may include the processes of the above method embodiments. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus embodiment, since it is substantially similar to the method embodiment, it is relatively simple to describe, and reference may be made to some descriptions of the method embodiment for relevant points. The above-described apparatus embodiments are merely illustrative, and the units and modules described as separate components may or may not be physically separate. In addition, some or all of the units and modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The foregoing is directed to embodiments of the present application and it is noted that numerous modifications and adaptations may be made by those skilled in the art without departing from the principles of the present application and are intended to be within the scope of the present application.

Claims (10)

1. A method of generating a database operation file, the method comprising:
acquiring data of each column in at least one column of a target table;
generating a first file according to the data of each column in the at least one column, wherein the data in the first file conforms to a first program language;
calling the first file through a preset template file of a second program language to generate a database operation file of the first program language, wherein the template file comprises operation information for executing operation on the data by adopting the first program language, and the database operation file is used for operating the data of the database.
2. The method of claim 1, wherein generating the first file according to the data of each of the at least one column comprises:
and converting the data format of the data of each column in the at least one column to obtain the first file.
3. The method of claim 2, wherein the data format comprises: a data type;
the converting the data format of the data of each of the at least one column includes:
and converting the data type of the data into the data type of the first program language.
4. The method of claim 1, wherein prior to obtaining data for each of at least one column of the target table, the method further comprises:
and acquiring the target table from a Physical Data Model (PDM) file according to the table name of the target table.
5. The method of claim 1, wherein the first programming language is C language and the second programming language is Java language.
6. An apparatus for generating a database operation file, the apparatus comprising:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring data of each column in at least one column of a target table;
the first generating unit is used for generating a first file according to the data of each column in the at least one column, and the data in the first file conforms to a first program language;
the second generating unit is configured to call the first file through a preset template file of a second program language, and generate a database operation file of the first program language, where the template file includes operation information for performing an operation on the data in the first program language, and the database operation file is used for operating the data in the database.
7. The apparatus of claim 6, wherein the first generating unit generates the first file according to the data of each of the at least one column comprises:
the first generating unit converts the data format of the data in each of the at least one column to obtain the first file.
8. The apparatus of claim 7, wherein the data format comprises: a data type;
the first generating unit converting a data format of data of each of the at least one column includes:
the first generation unit converts a data type of the data into a data type of a first program language.
9. The apparatus according to claim 6, wherein before the obtaining unit obtains the data of each column of the at least one column of the target table, the apparatus further comprises:
and the target table acquisition unit is used for acquiring the target table from a Physical Data Model (PDM) file according to the table name of the target table.
10. The apparatus of claim 6, wherein the first programming language is C language and the second programming language is Java language.
CN202011623396.7A 2020-12-30 2020-12-30 Method and device for generating database operation file Pending CN112631567A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011623396.7A CN112631567A (en) 2020-12-30 2020-12-30 Method and device for generating database operation file

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011623396.7A CN112631567A (en) 2020-12-30 2020-12-30 Method and device for generating database operation file

Publications (1)

Publication Number Publication Date
CN112631567A true CN112631567A (en) 2021-04-09

Family

ID=75289746

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011623396.7A Pending CN112631567A (en) 2020-12-30 2020-12-30 Method and device for generating database operation file

Country Status (1)

Country Link
CN (1) CN112631567A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113190218A (en) * 2021-04-28 2021-07-30 中国邮政储蓄银行股份有限公司 Target operation function generation method and device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105354036A (en) * 2015-11-26 2016-02-24 深圳市金证科技股份有限公司 Database operation code generating method and apparatus
CN106095792A (en) * 2016-05-27 2016-11-09 中国银联股份有限公司 The method and apparatus generating database manipulation code
US20170060890A1 (en) * 2015-08-26 2017-03-02 International Business Machines Corporation Method for storing data elements in a database
CN109375910A (en) * 2018-11-16 2019-02-22 京东方科技集团股份有限公司 Class file generation method, device, electronic equipment and storage medium
CN110543299A (en) * 2019-07-31 2019-12-06 苏州浪潮智能科技有限公司 Cloud computing management platform code generation method and device

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170060890A1 (en) * 2015-08-26 2017-03-02 International Business Machines Corporation Method for storing data elements in a database
CN105354036A (en) * 2015-11-26 2016-02-24 深圳市金证科技股份有限公司 Database operation code generating method and apparatus
CN106095792A (en) * 2016-05-27 2016-11-09 中国银联股份有限公司 The method and apparatus generating database manipulation code
CN109375910A (en) * 2018-11-16 2019-02-22 京东方科技集团股份有限公司 Class file generation method, device, electronic equipment and storage medium
CN110543299A (en) * 2019-07-31 2019-12-06 苏州浪潮智能科技有限公司 Cloud computing management platform code generation method and device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113190218A (en) * 2021-04-28 2021-07-30 中国邮政储蓄银行股份有限公司 Target operation function generation method and device

Similar Documents

Publication Publication Date Title
CN105868204B (en) A kind of method and device for converting Oracle scripting language SQL
CN107506383B (en) Audit data processing method and computer equipment
CN110597844B (en) Unified access method for heterogeneous database data and related equipment
CN101271390A (en) Software, system and method for modifying XML data structure
US20070073675A1 (en) Database query translation
CN113010183B (en) Code conversion method and device
CN111367893A (en) Method and device for database version iteration
US9652478B2 (en) Method and apparatus for generating an electronic document schema from a relational model
CN102707948B (en) Source code generation method
CN113297251A (en) Multi-source data retrieval method, device, equipment and storage medium
CN105808772A (en) Data defining file generation method and device
CN108960672B (en) Quota and time-limited wind control method and device and computer readable storage medium
US10402380B1 (en) Interactive user interface for schema transformation
CN117743362A (en) Large language model structured data query method with length overflow protection mechanism
US20200356570A1 (en) Interactive user interface having transform operators for schema transformation
CN112631567A (en) Method and device for generating database operation file
CN100527131C (en) Interdynamic access method and tool of IMS data base
CN104731597A (en) Method for applying SQL statements to engineering software compiling platform
JP6588988B2 (en) Business program generation support system and business program generation support method
CN117539981A (en) Method, equipment and medium for constructing theme data set
US11216438B2 (en) Database creation and collision reduction
CN115757479A (en) Database query optimization method, machine-readable storage medium and computer device
CN113868138A (en) Method, system, equipment and storage medium for acquiring test data
WO2017071777A1 (en) Generation of a data type code value for a data type
CN111176638B (en) BIOS code variable conversion method, system, equipment and 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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20210409