CN110287193A - A file generation method, device, equipment and computer-readable storage medium - Google Patents
A file generation method, device, equipment and computer-readable storage medium Download PDFInfo
- Publication number
- CN110287193A CN110287193A CN201910570445.6A CN201910570445A CN110287193A CN 110287193 A CN110287193 A CN 110287193A CN 201910570445 A CN201910570445 A CN 201910570445A CN 110287193 A CN110287193 A CN 110287193A
- Authority
- CN
- China
- Prior art keywords
- enumeration
- database table
- electronic form
- field
- name
- 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 OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/73—Program documentation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本申请公开了一种文件生成方法、装置、设备及计算机可读存储介质,该方法包括:获取数据字典中的至少一个电子表格,电子表格用于描述其对应的数据库表的数据结构;根据至少一个电子表格生成建表脚本,该建表脚本用于生成数据库表;执行该建表脚本,得到与至少一个电子表格对应的至少一个数据库表;根据至少一个数据库表生成应用于至少一个数据库表的文件。
The present application discloses a file generation method, device, device, and computer-readable storage medium. The method includes: acquiring at least one electronic form in the data dictionary, and the electronic form is used to describe the data structure of its corresponding database table; according to at least An electronic form generates a table-building script, and the table-building script is used to generate a database table; execute the table-building script to obtain at least one database table corresponding to at least one electronic form; generate an application for at least one database table according to at least one database table document.
Description
技术领域technical field
本申请涉及科技金融科技(Fintech)技术领域,尤其涉及一种文件生成方法、装置、设备及计算机可读存储介质。The present application relates to the technical field of financial technology (Fintech), and in particular to a file generation method, device, equipment, and computer-readable storage medium.
背景技术Background technique
随着计算机技术的发展,越来越多的技术应用在金融领域,传统金融业正在逐步向金融科技(Finteh)转变,代码文件的生成也不例外,但由于金融行业的安全性、实时性要求,也对技术提出的更高的要求。With the development of computer technology, more and more technologies are applied in the financial field. The traditional financial industry is gradually transforming into financial technology (Finteh). The generation of code files is no exception. However, due to the security and real-time requirements of the financial industry , but also higher requirements for technology.
Mybatis为基于Java编程语言的持久层框架,与数据交互的对象关系映射(ObjectRelational Mapping,ORM)开发组件。Mybatis可使用检测的xml文件或注解来配置和映射原生信息,将接口和Java的简单Java对象(Plain Ordinary Java Object,POJO)映射成数据库中的记录。在生成与Mybatis相关的Java文件时,有两种Java文件生成方式一种是与界面交互的方式进行生成,一种是基于xml文件的方式进行生成。但这两种Java文件生成方式中数据字典、数据库以及Java代码未统一,如果要传递文档给业务、系统上下游的时候,数据字典、数据库以及Java代码间沟通起来不太方便,对系统的维护带来一定的困难。Mybatis is a persistence layer framework based on the Java programming language, and an object relational mapping (ObjectRelational Mapping, ORM) development component that interacts with data. Mybatis can use detected xml files or annotations to configure and map native information, and map interfaces and Java's simple Java objects (Plain Ordinary Java Object, POJO) into records in the database. When generating Java files related to Mybatis, there are two ways to generate Java files, one is to generate by interacting with the interface, and the other is to generate based on xml files. However, the data dictionary, database, and Java code in these two Java file generation methods are not unified. If the document is to be transmitted to the upstream and downstream of the business and system, the communication between the data dictionary, database, and Java code is not convenient, and it is difficult for system maintenance. bring some difficulties.
发明内容Contents of the invention
本申请实施例提供一种文件生成方法、装置、设备及计算机可读存储介质,用以将数据字典、数据库和代码统一,提高系统维护效率。Embodiments of the present application provide a file generation method, device, device, and computer-readable storage medium, which are used to unify data dictionaries, databases, and codes, and improve system maintenance efficiency.
第一方面,提供一种文件生成方法,包括:获取数据字典中的至少一个电子表格,所述电子表格用于描述其对应的数据库表的数据结构;根据所述至少一个电子表格生成建表脚本,所述建表脚本用于生成数据库表;执行所述建表脚本,得到与所述至少一个电子表格对应的至少一个数据库表;根据所述至少一个数据库表生成应用于所述至少一个数据库表的文件。In the first aspect, a method for generating a file is provided, including: obtaining at least one electronic form in the data dictionary, the electronic form is used to describe the data structure of its corresponding database table; generating a table creation script according to the at least one electronic form , the table-building script is used to generate a database table; execute the table-building script to obtain at least one database table corresponding to the at least one electronic form; generate and apply to the at least one database table according to the at least one database table document.
可选地,所述电子表格用于描述其对应的数据库表的数据结构,包括:所述电子表格中包括表名、各字段的属性,所述字段中包括被指定为主键的字段,所述字段属性包括字段名和字段的数据类型,其中至少一个字段的数据类型为枚举类型。Optionally, the electronic form is used to describe the data structure of its corresponding database table, including: the electronic form includes a table name, attributes of each field, and the field includes a field designated as a primary key, and the The field attributes include field names and field data types, wherein at least one field data type is an enumeration type.
可选地,所述根据所述至少一个数据库表生成应用于所述至少一个数据库表的文件,包括:根据所述至少一个数据库表中的枚举类型字段,生成用于描述所述枚举类型字段的代码,所述代码中,所述枚举类型字段的枚举名为所述枚举类型字段在所述至少一个数据库表中的枚举名的基础上增加非数字前缀。Optionally, the generating the file applied to the at least one database table according to the at least one database table includes: generating a file for describing the enumeration type according to the enumeration type field in the at least one database table The code of the field, in the code, the enumeration name of the enumeration type field is added with a non-numeric prefix on the basis of the enumeration name in the at least one database table.
可选地,针对所述至少一个数据库表中的所有枚举类型字段,所述代码中,所述所有枚举类型字段的枚举名为相应枚举类型字段在所述至少一个数据库表中的枚举名的基础上增加非数字前缀;或者,针对所述至少一个数据库表中的特定枚举类型字段,所述代码中,所述特定枚举类型字段的枚举名为相应特定枚举类型在所述至少一个数据库表中的枚举名的基础上增加非数字前缀;其中,所述特定枚举类型字段为所述至少一个数据库表中枚举名以数字开头命名的枚举类型字段。Optionally, for all enumeration type fields in the at least one database table, in the code, the enumeration names of all the enumeration type fields are in the at least one database table Adding a non-numeric prefix on the basis of the enumeration name; or, for the specific enumeration type field in the at least one database table, in the code, the enumeration name of the specific enumeration type field is corresponding to the specific enumeration type Adding a non-numeric prefix to the enumeration name in the at least one database table; wherein, the specific enumeration type field is an enumeration type field in the at least one database table whose enumeration name starts with a number.
可选地,所述非数字前缀为下划线前缀。Optionally, the non-numeric prefix is an underscore prefix.
可选地,所述电子表格中字段的数据类型与目标数据库所支持的字段的数据类型一致。Optionally, the data types of the fields in the electronic form are consistent with the data types of the fields supported by the target database.
可选地,所述建表脚本中新增用于生成公共字段的代码,所述公共字段至少包括账户标识、数据处理日期和系统时间。Optionally, codes for generating public fields are newly added in the table creation script, and the public fields include at least account identifier, data processing date and system time.
第二方面,提供一种文件生成装置,包括:获取单元以及处理单元;In a second aspect, a file generation device is provided, including: an acquisition unit and a processing unit;
所述获取模块,用于获取数据字典中的至少一个电子表格,所述电子表格用于描述其对应的数据库表的数据结构;所述处理单元,用于根据所述至少一个电子表格生成建表脚本,所述建表脚本用于生成数据库表;执行所述建表脚本,得到与所述至少一个电子表格对应的至少一个数据库表;并根据所述至少一个数据库表生成应用于所述至少一个数据库表的文件。The acquisition module is configured to acquire at least one electronic form in the data dictionary, and the electronic form is used to describe the data structure of its corresponding database table; the processing unit is configured to generate a table according to the at least one electronic form Script, the table-building script is used to generate a database table; execute the table-building script to obtain at least one database table corresponding to the at least one electronic form; The file for the database table.
第三方面,提供一种文件生成设备,包括:处理器、存储器及存储在所述存储器上并可在所述处理器上运行的文件生成程序,所述文件生成程序被所述处理器执行时实现如第一方面所述的文件生成方法的步骤。In a third aspect, a file generating device is provided, including: a processor, a memory, and a file generating program stored on the memory and operable on the processor, when the file generating program is executed by the processor The steps of the file generation method described in the first aspect are realized.
第四方面,提供一种计算机可读存储介质,所述存储介质存储有计算机指令,所述计算机指令被处理器执行时实现第一方面中任一项所述的方法。In a fourth aspect, a computer-readable storage medium is provided, the storage medium stores computer instructions, and when the computer instructions are executed by a processor, the method described in any one of the first aspects is implemented.
本申请的上述实施例中获取数据字典中的至少一个电子表格,电子表格用于描述其对应的数据库表的数据结构;根据至少一个电子表格生成建表脚本,执行该建表脚本,得到与至少一个电子表格对应的至少一个数据库表;并根据该至少一个数据库表生成应用于至少一个数据库表的文件。由于数据库表以及生成的文件皆是基于数据字典中的电子表格生成的,故实现了数据字典、数据库以及代码的统一,并且相较于界面或xml文件,电子表格的格式使得用户直观了解数据库和代码的内容,便于系统的运维和维护,提高用户体验。Obtain at least one electronic form in the data dictionary in the above-mentioned embodiment of the present application, electronic form is used for describing the data structure of its corresponding database table; Generate table-building script according to at least one electronic form, execute this table-building script, obtain and at least At least one database table corresponding to an electronic form; and generating a file applied to the at least one database table according to the at least one database table. Since the database table and generated files are generated based on the electronic form in the data dictionary, the data dictionary, database and code are unified, and compared with the interface or xml file, the format of the electronic form allows users to intuitively understand the database and The content of the code facilitates the operation and maintenance of the system and improves the user experience.
附图说明Description of drawings
图1为本申请实施例提供的一种文件生成方法的流程示意图;FIG. 1 is a schematic flow diagram of a method for generating a file provided in an embodiment of the present application;
图2为本申请实施例提供的一种文件生成装置的结构示意图;FIG. 2 is a schematic structural diagram of a file generating device provided in an embodiment of the present application;
图3为本申请实施例提供的一种文件生成设备的结构示意图。FIG. 3 is a schematic structural diagram of a file generation device provided by an embodiment of the present application.
具体实施方式Detailed ways
以下结合附图对本申请的具体实施方式进行详细的说明。应当理解的是,此处所描述的具体实施方式仅用于说明和解释本申请,并不用于限制本申请。The specific implementation manners of the present application will be described in detail below in conjunction with the accompanying drawings. It should be understood that the specific implementations described here are only used to illustrate and explain the present application, and are not intended to limit the present application.
数据字典是开发和测试、业务之间交互的文档,业务的变化会体验到数据的变化,也就是会修改相应的数据字典。在生成与Mybatis相关的Java代码时,为了统一数据字典、数据库以及Java代码,直观了解数据库、Java代码的内容,提高用户体验,本申请实施例对数据字典进行定义或修改。The data dictionary is a document for development, testing, and business interactions. Business changes will experience data changes, that is, the corresponding data dictionary will be modified. When generating the Java code related to Mybatis, in order to unify the data dictionary, database and Java code, intuitively understand the content of the database and Java code, and improve user experience, the embodiment of this application defines or modifies the data dictionary.
本申请实施例中的数据字典以电子表格的形式对数据的数据结构进行描述。对数据字典定义即对电子表格进行定义。电子表格中需要定义的内容包括:表名、各字段的属性,字段中包括被指定为主键的字;其中,各字段的属性包括字段名和字段的数据类型,至少一个字段的数据类型为枚举类型。The data dictionary in the embodiment of the present application describes the data structure of the data in the form of electronic form. The definition of the data dictionary is the definition of the spreadsheet. The content that needs to be defined in the spreadsheet includes: table name, attributes of each field, and the field includes the word designated as the primary key; among them, the attributes of each field include the field name and the data type of the field, and the data type of at least one field is an enumeration type.
其中,表名用于标识该表格,以字母加下划线的形式表示;字段名为一列或一行的数据的统称,以字母带下划线的形式表示;字段的数据类型用于表示字段名下各字段的类型,所定义的各字段的数据类型与目标数据库(mysql)所支持的字段的数据类型一致,比如varchar、bigint等;枚举用于表示该字段名对应的集合,以“大写字母带下划线=中文描述”的形式表示枚举类型,再换行以“数字或大写字母-中文描述”的形式表示枚举名以及该枚举名对应的枚举值,或者直接以“数字或大写字母-中文描述”的形式表示枚举名以及该枚举名对应的枚举值。Among them, the table name is used to identify the table, expressed in the form of letters and underlines; the collective name of the field name for a column or row of data is expressed in the form of letters with underlines; the data type of the field is used to indicate the value of each field under the field name Type, the data type of each field defined is consistent with the data type of the field supported by the target database (mysql), such as varchar, bigint, etc.; the enumeration is used to represent the set corresponding to the field name, with "uppercase letters with underscores = Chinese description" to indicate the enumeration type, and then wrap the line to indicate the enumeration name and the enumeration value corresponding to the enumeration name in the form of "numbers or uppercase letters-Chinese description", or directly use "numbers or uppercase letters-Chinese description "The form indicates the enumeration name and the enumeration value corresponding to the enumeration name.
可选地,一个电子表格中还可以包括对表名进行文字描述的表名描述、对字段名进行文字描述的字段描述;这样,用户可直观地了解该电子表格以及各字段所描述的信息。Optionally, an electronic form may also include a table name description that describes the table name in text, and a field description that provides a text description for the field name; in this way, the user can intuitively understand the electronic form and the information described in each field.
参见表1,该表示例性地示出了数据字典中冻结类型的定义表。如表所示,所定义的电子表的表名为ba_hold_def,对应的文字描述(即表名描述)为冻结类型定义表;该电子表中的字段包括冻结分类码(hold_type)、冻结分类名称(hold_name)、冻结业务类型(hold_biz_type)、限制类型(hold_process_type)、超额冻结许可(exceeding_flag)、冻结级别(hold_level)、同级别计算方式(same_level_calc_mode)、子账号受理标志(acct_allow_flag)、所有子账号受理标志(all_acct_allow_flag)、客户账号受理标志(custacct_allow_flag)、允许人工受理标志(manual_hold_flag)、冻结次数限制标志(hold_restrict_num)以及描述(hold_mark);冻结分类码的数据类型为varchar(8)、冻结分类名称的数据类型为varchar(32)、冻结业务类型的数据类型为varchar(1)、限制类型的数据类型为varchar(10)、超额冻结许可的数据类型为varchar(1)、冻结级别的数据类型为bigint(19)、同级别计算方式的数据类型为varchar(1)、子账号受理标志的数据类型为varchar(1)、所有子账号受理标志的数据类型为varchar(1)、客户账号受理标志的数据类型为varchar(1)、允许人工受理标志的数据类型为varchar(1)、冻结次数限制标志的数据类型为varchar(1)以及描述的数据类型为varchar(200)。See Table 1, which exemplarily shows the definition table of frozen types in the data dictionary. As shown in the table, the table name of the defined electronic table is ba_hold_def, and the corresponding text description (that is, the description of the table name) is a frozen type definition table; the fields in the electronic table include the frozen classification code (hold_type), the frozen classification name ( hold_name), frozen business type (hold_biz_type), restricted type (hold_process_type), excessive frozen license (exceeding_flag), frozen level (hold_level), same-level calculation method (same_level_calc_mode), sub-account acceptance flag (acct_allow_flag), all sub-account acceptance flags (all_acct_allow_flag), customer account acceptance flag (custacct_allow_flag), manual acceptance flag (manual_hold_flag), freeze limit flag (hold_restrict_num) and description (hold_mark); the data type of the freeze category code is varchar(8), and the data of the freeze category name The type is varchar(32), the data type of the frozen business type is varchar(1), the data type of the restriction type is varchar(10), the data type of the oversubscription frozen license is varchar(1), and the data type of the frozen level is bigint( 19), the data type of the calculation method at the same level is varchar(1), the data type of the sub-account acceptance flag is varchar(1), the data type of all sub-account acceptance flags is varchar(1), and the data type of the customer account acceptance flag It is varchar(1), the data type of the manual acceptance flag is varchar(1), the data type of the freezing number limit flag is varchar(1), and the data type of the description is varchar(200).
其中,字段冻结分类码为主键的字段;字段冻结业务类型、限制类型、超额冻结许可、冻结级别、同级别计算方式、子账号受理标志、所有子账号受理标志、客户账号受理标志、允许人工受理标志、以及冻结次数限制标志的数据类型为枚举类型。Among them, the field frozen classification code is the primary key field; the fields frozen business type, restriction type, excess frozen permission, frozen level, calculation method of the same level, sub-account acceptance flag, all sub-account acceptance flags, customer account acceptance flag, manual acceptance allowed The data type of the flag and the freezing times limit flag is an enumeration type.
字段冻结业务类型的枚举类型包括司法冻结和银行止付,1为枚举名对应的枚举值为司法冻结,2为枚举名对应的枚举值为银行支付;限制类型的枚举类型包括金额冻结、只收不付、只付不收以及不付不收,枚举名为HOLD_PROCESS_TYPE对应的枚举值为限制类型,枚举名为AMTHOLD对应的枚举值为金额冻结,枚举名为DRBLOCK对应的枚举值为只收不付,枚举名为CRBLOCK对应的枚举值为只付不收,枚举名为TOTALBLOCK对应的枚举值为不付不收;冻结级别的枚举类型包括先来后到和不区分,枚举名为0对应的枚举值为先来后到,枚举名为1对应的枚举值为不区分;超额冻结许可的枚举类型包括是和否,枚举名为YES_NO_FLAG对应的枚举值为是否标识,枚举名为Y对应的枚举值为是,枚举名为N对应的枚举值为否。The enumeration type of the field freeze business type includes judicial freeze and bank stop payment, 1 is the enumeration value corresponding to the enumeration name is judicial freeze, 2 is the enumeration value corresponding to the enumeration name is bank payment; the enumeration type of the restriction type Including amount freeze, only receive but not pay, only pay but not receive, and no pay and no receive, the enumeration name corresponding to HOLD_PROCESS_TYPE is the restriction type, the enumeration name corresponding to AMTHOLD is the amount freezing, the enumeration name is The enumeration value corresponding to DRBLOCK is only receive but not pay, the enumeration value corresponding to the enumeration name CRBLOCK is only pay but not receive, the enumeration value corresponding to the enumeration name TOTALBLOCK is no pay and no receive; the enumeration of the freezing level The types include first-come-first-served and no distinction. The enumeration value corresponding to the enumeration name 0 is first-come-first-served, and the enumeration value corresponding to the enumeration name 1 is no distinction. The enumeration types of excess freezing license include yes and no, and the enumeration name is The enumeration value corresponding to YES_NO_FLAG is whether to identify, the enumeration value corresponding to the enumeration name Y is Yes, and the enumeration value corresponding to the enumeration name N is No.
字段同级别计算方式、子帐号受理标志、所有子账号受理标志、客户账号受理标志、允许人工受理标志、冻结次数以及限制标志的枚举类型与字段超额冻结许可的枚举类型类似,有关描述可参见对超额冻结许可的枚举类型的描述,在此不再赘述。The enumeration types of the same-level calculation method, sub-account acceptance flag, all sub-account acceptance flags, customer account acceptance flags, manual acceptance flags, freezing times, and limit flags are similar to the enumeration types of the field over-freezing permission. See the description of the enumerated types of oversubscription frozen licenses, so I won't repeat them here.
表1冻结类型的定义表Table 1 Definition table of frozen types
可选地,电子表格中还可以包括索引、分区字段等,本申请不限定于表1所示的内容。Optionally, the electronic form may also include indexes, partition fields, etc., and the present application is not limited to the contents shown in Table 1.
可选地,数据字典中的电子表格为excel格式。Optionally, the spreadsheet in the data dictionary is in excel format.
基于上述定义的数据字典,本申请实施例提供一种文件生成方法,以使得数据字典、数据库以及代码统一,便于直观了解数据库与代码的内容。Based on the data dictionary defined above, the embodiment of the present application provides a method for generating a file, so that the data dictionary, database, and code are unified, and it is convenient to intuitively understand the content of the database and code.
如图1所示,为本申请实施例提供的一种文件生成方法的流程示意图。As shown in FIG. 1 , it is a schematic flowchart of a method for generating a file provided in the embodiment of the present application.
如图所示,该方法流程包括:As shown in the figure, the method flow includes:
S101:获取数据字典中的至少一个电子表格,电子表格用于描述其对应的数据库表的数据结构。S101: Obtain at least one electronic form in the data dictionary, where the electronic form is used to describe the data structure of its corresponding database table.
具体地,在数据字典中获取如表1所定义的至少一个excel文件,并确定该至少一个excel文件的存储路径。Specifically, at least one excel file as defined in Table 1 is obtained from the data dictionary, and a storage path of the at least one excel file is determined.
其中,一个电子表格中包括表名、各字段的属性,该字段中包括被指定为主键的字段,字段属性包括字段名和字段的数据类型,其中至少一个字段的数据类型为枚举类型,电子表格中字段的数据类型与mysql所支持的字段的数据类型一致。Among them, a spreadsheet includes the table name, the attributes of each field, the field includes the field designated as the primary key, the field attributes include the field name and the data type of the field, and the data type of at least one field is an enumeration type, and the spreadsheet The data type of the field in is consistent with the data type of the field supported by mysql.
S102:根据至少一个电子表格生成建表脚本,该建表脚本用于生成数据库表。S102: Generate a table creation script according to at least one electronic table, where the table creation script is used to generate a database table.
具体地,根据该至少一个电子表格的存储路径,对该至少一个电子表格执行建表函数,比如DicToMysql.java,生成与该至少一个电子表格对应的mysql的建表脚本。执行该建表函数可自动生成建表语句,同时生成了主键、索引、备注;若一个字段的数据类型为枚举类型,还会把枚举类型、所有的枚举名以及枚举名对应的枚举值列举在备注中,以便后期的开发、运维、维护、查询时使用。Specifically, according to the storage path of the at least one electronic form, a table creation function, such as DicToMysql.java, is executed on the at least one electronic form to generate a mysql table creation script corresponding to the at least one electronic form. Executing the table creation function can automatically generate the table creation statement, and at the same time generate the primary key, index, and remarks; if the data type of a field is an enumeration type, the enumeration type, all enumeration names, and the enumeration name corresponding The enumerated values are listed in the remarks for later use in development, operation and maintenance, maintenance, and query.
可选地,通过在建表函数中配置生成公共字段,比如conf.setGenPublicField(true),从而在建表脚本中新增数据字典中未定义的公共字段,该公共字段可包括账户标识(mnt_teller_id)、数据处理日期(mnt_process_date)、系统时间(mnt_sys_time mnt_sys_time)以及账户权限(mnt_auth_teller)等。这样,公共字段就不需要在数据字典中的每个电子表格中进行维护,降低了数据字典的复杂度。Optionally, by configuring and generating public fields in the table building function, such as conf.setGenPublicField(true), a public field not defined in the data dictionary is added in the table building script, and the public field may include the account ID (mnt_teller_id) , data processing date (mnt_process_date), system time (mnt_sys_time mnt_sys_time), account authority (mnt_auth_teller), etc. In this way, the common fields do not need to be maintained in each spreadsheet in the data dictionary, reducing the complexity of the data dictionary.
S103:执行该建表脚本,得到与该至少一个电子表格对应的至少一个数据库表。S103: Execute the table creation script to obtain at least one database table corresponding to the at least one electronic table.
执行该建表脚本,在数据库中生成与该至少一个电子表格对应的至少一个数据库表。其中,每个数据库表配置有mysql数据源以及数据模块,比如表1所示的表名中ba表示银行(bank)模块,配置的mysql数据源为银行层的数据。Execute the table creation script to generate at least one database table corresponding to the at least one electronic form in the database. Wherein, each database table is configured with a mysql data source and a data module. For example, in the table name shown in Table 1, ba represents a bank (bank) module, and the configured mysql data source is data of the bank layer.
S104:根据该至少一个数据库表生成应用于该至少一个数据库表的文件。S104: Generate a file applied to the at least one database table according to the at least one database table.
其中,生成的文件为应用于数据库表的代码文件。可选地,该代码文件为Java文件。Wherein, the generated file is a code file applied to a database table. Optionally, the code file is a Java file.
具体地,根据该至少一个数据库表的存储路径以及与该至少一个数据库表对应的数据模块和mysql数据源,对该至少一个数据库表执行代码生成函数,比如MysqlToJava.java,生成应用于该至少一个数据库表的文件。生成的文件中包括实体类,查询相关的对象类,查询DAO,Mapper,mapper对应的xml文件,以及相关的复合主键、枚举类。其中,生成的文件中,对枚举进行序列化反序列化处理,便于组装报文,且不同的枚举有相应的文字描述,便于理解。Specifically, according to the storage path of the at least one database table and the data module and mysql data source corresponding to the at least one database table, execute a code generation function for the at least one database table, such as MysqlToJava. The file for the database table. The generated files include entity classes, query related object classes, query DAO, Mapper, xml files corresponding to mapper, and related composite primary keys and enumeration classes. Among them, in the generated file, the enumeration is serialized and deserialized, which is convenient for assembling messages, and different enumerations have corresponding text descriptions, which is easy to understand.
可选地,通过在代码生成函数中对枚举名配置非数字前缀,使得生成的文件中的枚举名新增非数字前缀,从而避免了Java不支持数字作为枚举名的问题。具体地,根据至少一个数据库表中的枚举类型字段,生成用于描述枚举类型字段的代码,在该代码中,枚举类型字段的枚举名为枚举类型字段在至少一个数据库表中的枚举名的基础上增加非数字前缀。Optionally, by configuring a non-numeric prefix for the enumeration name in the code generation function, a non-numeric prefix is added to the enumeration name in the generated file, thereby avoiding the problem that Java does not support numbers as the enumeration name. Specifically, according to the enumeration type field in at least one database table, generate code for describing the enumeration type field, in the code, the enumeration name of the enumeration type field is in at least one database table Add a non-numeric prefix to the enumeration name.
可选地,在一种情况下,针对该至少一个数据库表中的所有枚举类型字段,在该代码中,所有枚举类型字段的枚举名为相应枚举类型字段在该至少一个数据库表中的枚举名的基础上增加非数字前缀;在另一种情况下,针对该至少一个数据库表中的特定枚举类型字段,在该代码中,特定枚举类型字段的枚举名为相应特定枚举类型在该至少一个数据库表中的枚举名的基础上增加非数字前缀;其中,特定枚举类型字段为该至少一个数据库表中枚举名以数字开头命名的枚举类型字段。Optionally, in one case, for all enumeration type fields in the at least one database table, in the code, the enumeration names of all enumeration type fields are corresponding to enumeration type fields in the at least one database table Add a non-numeric prefix on the basis of the enumeration name in; in another case, for the specific enumeration type field in the at least one database table, in this code, the enumeration name of the specific enumeration type field corresponds to The specific enumeration type adds a non-numeric prefix to the enumeration name in the at least one database table; wherein, the specific enumeration type field is an enumeration type field whose enumeration name starts with a number in the at least one database table.
可选地,上述非数字前缀为下划线前缀。比如,表1中字段冻结级别的枚举类型包括先来后到和不区分,在先来后到对应的枚举名“0”新增下划线前缀为“_0”,生成的文件中先来后到对应的枚举名则为“_0”。Optionally, the above-mentioned non-numeric prefix is an underscore prefix. For example, the enumeration types of the field freezing level in Table 1 include first-come-first-served and no-distinguishment, add an underscore prefix to "_0" for the enumeration name "0" corresponding to first-come-first-served, and the corresponding enumeration name in the generated file is " _0".
下面以表1所定义的电子表格以及所生成的文件为Java文件为例,对S104所生成的文件做详细说明。Taking the electronic form defined in Table 1 and the generated file as a Java file as an example, the file generated in S104 will be described in detail below.
对表1所示的电子表格执行图1所示的流程,得到Java文件,该Java文件的目录中包括与银行冻结类型相关代码(com.webank.deposit.ba.persisitence.domain)、基于mybatis技术有数据交互的类(com.webank.deposit.ba.persisitence.mapper)以及与银行冻结类型相关的公共枚举类(com.webank.deposit.common.enumeration);其中,com.webank.deposit为包名,即文件名,ba表示银行(bank)数据模块,common表示公共数据模块,本申请实施例中将枚举的类归入公共模块。Execute the process shown in Figure 1 to the electronic form shown in Table 1, and obtain the Java file, which includes the code (com.webank.deposit.ba.persisitence.domain) related to the bank freezing type in the directory of the Java file, based on mybatis technology There are classes for data interaction (com.webank.deposit.ba.persisitence.mapper) and public enumeration classes (com.webank.deposit.common.enumeration) related to bank freezing types; among them, com.webank.deposit is the package name, that is, the file name, ba represents the bank (bank) data module, and common represents the public data module. In the embodiment of the present application, the enumerated classes are classified into the common module.
与银行冻结类型相关代码主要存储与数据操作相关的Java类,示例性地,该与银行冻结类型相关代码可包括BaHoldDef.java、BaHoldDefPk.java以及BaHoldDefCondition;其中,BaHoldDef.java表示和数据库表ba_hold_def一一映射的实体,映射关系在BaHoldDefMapper.xml里定义,BaHoldDefPk.java表示是复合主键的定义类,BaHoldDefCondition表示查询相关的,以实现复杂的组合查询。The code related to the bank freeze type mainly stores Java classes related to data operations. Exemplarily, the code related to the bank freeze type can include BaHoldDef.java, BaHoldDefPk.java and BaHoldDefCondition; A mapped entity, the mapping relationship is defined in BaHoldDefMapper.xml, BaHoldDefPk.java represents the definition class of the composite primary key, and BaHoldDefCondition represents query related to realize complex combined queries.
基于mybatis技术有数据交互的类包括BaHoldDefDao.java、BaHoldDeMapper.java以及BaHoldDefMapper.xml;其中,BaHoldDefDao.java表示用于实现所有增删改查的操作,它操作数据使用BaHoldDefmapper类,BaHoldDeMapper.java是根据mybatis规范实现的数据操作类,BaHoldDefMapper.xml是根据mybatis规范实现的,包括BaHoldDef.java和数据库表ba_hold_def一一映射的,以及各类数据库操作,比如对数据的增删改查操作,用户对数据操作的参数会传递到xml文件里,再组装成sql,发送到数据库,从而完成与数据库的交互。Classes with data interaction based on mybatis technology include BaHoldDefDao.java, BaHoldDeMapper.java, and BaHoldDefMapper.xml; among them, BaHoldDefDao.java is used to implement all additions, deletions, modifications, and queries. It uses the BaHoldDefmapper class to operate data, and BaHoldDeMapper.java is based on mybatis The data operation class implemented by the specification, BaHoldDefMapper.xml is implemented according to the mybatis specification, including the one-to-one mapping between BaHoldDef.java and the database table ba_hold_def, and various database operations, such as adding, deleting, modifying and checking operations on data, and user operations on data The parameters will be passed to the xml file, then assembled into sql, and sent to the database to complete the interaction with the database.
与银行冻结类型相关的公共枚举类包括表1所示所有枚举类型,比如冻结业务类型的枚举类,HoldBizType.java;限制类型的枚举类,HoldProcessType.java;同级别计算方式的枚举类,SameLevelCalcMode.java等。The public enumeration classes related to bank freezing types include all enumeration types shown in Table 1, such as the enumeration class of the frozen business type, HoldBizType.java; the enumeration class of the restricted type, HoldProcessType.java; the enumeration class of the same level calculation method For example, SameLevelCalcMode.java and so on.
通过生成的Java文件,可实现用户对数据的增删改查。举例而言,selectByPk表示按主键查询;selectByPkWithLock表示主键查询,且锁定当前纪录;insert表示插入数据操作;update表示更新数据操作;Count表示按条件统计条数;deletebyContitoin表示按条件删除记录;deleteByPk表示按主键删除记录等。Through the generated Java file, the user can add, delete, modify and check the data. For example, selectByPk means query by primary key; selectByPkWithLock means query by primary key and lock the current record; insert means insert data operation; update means update data operation; Count means count records by condition; deletebyContitoin means delete record by condition; Primary key delete records etc.
本申请的上述实施例中获取数据字典中的至少一个电子表格,电子表格用于描述其对应的数据库表的数据结构;根据至少一个电子表格生成建表脚本,执行该建表脚本,得到与至少一个电子表格对应的至少一个数据库表;并根据该至少一个数据库表生成应用于至少一个数据库表的文件。由于数据库表以及文件皆是基于数据字典中的电子表格生成的,故实现了数据字典、数据库以及代码的统一,并且相较于界面或xml文件,电子表格的格式使得用户直观了解数据库和代码的内容,便于系统的运维和维护,提高用户体验。Obtain at least one electronic form in the data dictionary in the above-mentioned embodiment of the present application, electronic form is used for describing the data structure of its corresponding database table; Generate table-building script according to at least one electronic form, execute this table-building script, obtain and at least At least one database table corresponding to an electronic form; and generating a file applied to the at least one database table according to the at least one database table. Since the database tables and files are generated based on the electronic tables in the data dictionary, the data dictionary, database and codes are unified, and compared with the interface or xml files, the format of the electronic tables allows users to intuitively understand the relationship between the database and codes content, which facilitates the operation and maintenance of the system and improves the user experience.
基于相同的技术构思,本申请实施例还提供一种文件生成装置,该文件生成装置可实现前述实施例中图1所执行的流程。Based on the same technical concept, the embodiment of the present application further provides a file generation device, which can implement the process executed in FIG. 1 in the foregoing embodiments.
如图2所示,为本申请实施例提供的一种文件生成装置的结构示意图。As shown in FIG. 2 , it is a schematic structural diagram of a file generating device provided in the embodiment of the present application.
如图所示,该文件生成装置包括获取单元201、处理单元202。As shown in the figure, the file generation device includes an acquisition unit 201 and a processing unit 202 .
所述获取模块201,用于获取数据字典中的至少一个电子表格,电子表格用于描述其对应的数据库表的数据结构。The acquiring module 201 is configured to acquire at least one electronic form in the data dictionary, and the electronic form is used to describe the data structure of its corresponding database table.
所述处理单元202,用于根据所述至少一个电子表格生成建表脚本,所述建表脚本用于生成数据库表;执行所述建表脚本,得到与所述至少一个电子表格对应的至少一个数据库表;并根据所述至少一个数据库表生成应用于所述至少一个数据库表的文件。The processing unit 202 is configured to generate a table creation script according to the at least one electronic form, and the table creation script is used to generate a database table; execute the table creation script to obtain at least one corresponding to the at least one electronic form a database table; and generating a file applied to the at least one database table according to the at least one database table.
可选地,所述一个电子表格用于描述其对应的数据库表的数据结构,包括:所述一个电子表格中包括表名、各字段的属性,所述字段中包括被指定为主键的字段,所述字段属性包括字段名和字段的数据类型,其中至少一个字段的数据类型为枚举类型。Optionally, the one electronic form is used to describe the data structure of its corresponding database table, including: the one electronic form includes a table name, attributes of each field, and the field includes a field designated as a primary key, The field attributes include field names and field data types, wherein the data type of at least one field is an enumeration type.
可选地,所述处理单元202,具体用于:根据所述至少一个数据库表中的枚举类型字段,生成用于描述所述枚举类型字段的代码,所述代码中,所述枚举类型字段的枚举名为所述枚举类型字段在所述至少一个数据库表中的枚举名的基础上增加非数字前缀。Optionally, the processing unit 202 is specifically configured to: generate a code for describing the enumeration type field according to the enumeration type field in the at least one database table, in the code, the enumeration type field The enumeration name of the type field adds a non-numeric prefix to the enumeration name in the at least one database table for the enumeration type field.
可选地,针对所述至少一个数据库表中的所有枚举类型字段,所述代码中,所述所有枚举类型字段的枚举名为相应枚举类型字段在所述至少一个数据库表中的枚举名的基础上增加非数字前缀;或者,针对所述至少一个数据库表中的特定枚举类型字段,所述代码中,所述特定枚举类型字段的枚举名为相应特定枚举类型在所述至少一个数据库表中的枚举名的基础上增加非数字前缀;其中,所述特定枚举类型字段为所述至少一个数据库表中枚举名以数字开头命名的枚举类型字段。Optionally, for all enumeration type fields in the at least one database table, in the code, the enumeration names of all the enumeration type fields are in the at least one database table Adding a non-numeric prefix on the basis of the enumeration name; or, for the specific enumeration type field in the at least one database table, in the code, the enumeration name of the specific enumeration type field is corresponding to the specific enumeration type Adding a non-numeric prefix to the enumeration name in the at least one database table; wherein, the specific enumeration type field is an enumeration type field in the at least one database table whose enumeration name starts with a number.
可选地,所述非数字前缀为下划线前缀。Optionally, the non-numeric prefix is an underscore prefix.
可选地,所述电子表格中字段的数据类型与目标数据库所支持的字段的数据类型一致。Optionally, the data types of the fields in the electronic form are consistent with the data types of the fields supported by the target database.
可选地,所述建表脚本中新增用于生成公共字段的代码,所述公共字段至少包括账户标识、数据处理日期和系统时间。Optionally, codes for generating public fields are newly added in the table creation script, and the public fields include at least account identifier, data processing date and system time.
基于相同的技术构思,本申请实施例还提供一种文件生成设备,该文件生成设备可实现前述实施例中图1所执行的流程。Based on the same technical concept, the embodiment of the present application further provides a file generation device, which can realize the process executed in FIG. 1 in the foregoing embodiments.
图3示出了本申请实施例提供的文件生成设备300的结构示意图,即示出了文件生成装置200的另一结构示意图。参阅图3所示,该文件生成设备300包括处理器301、存储器302及存储在所述存储器上并可在所述处理器上运行的文件生成程序(图中未画出),所述文件生成程序被所述处理器执行时实现如图1所示的步骤。所述处理器301被配置为支持终端执行前述流程涉及的功能。存储器302用于与处理器301耦合,其保存终端必要的程序指令和数据。其中,处理器301、和存储器302相连,该存储器302用于存储指令,该处理器301用于执行该存储器302存储的指令,以完成上述方法中客户端设备执行相应功能的步骤。FIG. 3 shows a schematic structural diagram of a file generating device 300 provided by an embodiment of the present application, that is, another schematic structural diagram of the file generating apparatus 200 is shown. 3, the file generation device 300 includes a processor 301, a memory 302, and a file generation program (not shown) that is stored on the memory and can run on the processor. The file generation When the program is executed by the processor, the steps shown in FIG. 1 are realized. The processor 301 is configured to support the terminal to execute the functions involved in the foregoing process. The memory 302 is used to be coupled with the processor 301, and stores necessary program instructions and data of the terminal. Wherein, the processor 301 is connected to the memory 302, the memory 302 is used to store instructions, and the processor 301 is used to execute the instructions stored in the memory 302, so as to complete the steps of the client device performing corresponding functions in the above method.
本申请实施例中,文件生成装置200和文件生成设备300所涉及的与本申请实施例提供的技术方案相关的概念,解释和详细说明及其它步骤请参见前述方法或其它实施例中关于这些内容的描述,此处不做赘述。In this embodiment of the application, for the concepts, explanations, detailed descriptions and other steps related to the technical solution provided by the file generation device 200 and the file generation device 300 involved in the file generation device 300, please refer to the aforementioned methods or other embodiments for these contents description, which will not be repeated here.
需要说明的是,本申请实施例上述涉及的处理器可以是中央处理器(centralprocessing unit,CPU),通用处理器,数字信号处理器(digital signal processor,DSP),专用集成电路(application-specific integrated circuit,ASIC),现场可编程门阵列(field programmable gate array,FPGA)或者其它可编程逻辑器件、晶体管逻辑器件、硬件部件或者其任意组合。其可以实现或执行结合本申请内容所描述的各种示例性的逻辑方框,模块和电路。处理器也可以是实现计算功能的组合,例如包含一个或多个微处理器组合,DSP和微处理器的组合等等。其中,所述存储器可以集成在所述处理器中,也可以与所述处理器分开设置。It should be noted that, the above-mentioned processors involved in the embodiment of the present application may be a central processing unit (central processing unit, CPU), a general processor, a digital signal processor (digital signal processor, DSP), an application-specific integrated circuit (application-specific integrated circuit) circuit, ASIC), field programmable gate array (field programmable gate array, FPGA) or other programmable logic devices, transistor logic devices, hardware components or any combination thereof. It may implement or execute the various illustrative logical blocks, modules and circuits described in connection with the disclosure herein. The processor can also be a combination of computing functions, for example, a combination of one or more microprocessors, a combination of DSP and a microprocessor, and so on. Wherein, the memory may be integrated in the processor, or may be set separately from the processor.
基于相同的技术构思,本申请实施例还提供了一种计算机可读存储介质。计算机可读存储介质存储有计算机可执行指令,计算机可执行指令用于使计算机执行图1中所执行的流程。Based on the same technical concept, the embodiment of the present application also provides a computer-readable storage medium. The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions are used to cause the computer to execute the process executed in FIG. 1 .
本申请是参照根据本申请实施例的方法、设备(系统)、和计算机程序产品的流程图和/或方框图来描述的。应理解可由计算机程序指令实现流程图和/或方框图中的每一流程和/或方框、以及流程图和/或方框图中的流程和/或方框的结合。可提供这些计算机程序指令到通用计算机、专用计算机、嵌入式处理机或其他可编程数据处理设备的处理器以产生一个机器,使得通过计算机或其他可编程数据处理设备的处理器执行的指令产生用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的装置。The present application is described with reference to flowcharts and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the present application. It should be understood that each procedure and/or block in the flowchart and/or block diagram, and a combination of procedures and/or blocks in the flowchart and/or block diagram can be realized by computer program instructions. These computer program instructions may be provided to a general purpose computer, special purpose computer, embedded processor, or processor of other programmable data processing equipment to produce a machine such that the instructions executed by the processor of the computer or other programmable data processing equipment produce a An apparatus for realizing the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.
这些计算机程序指令也可存储在能引导计算机或其他可编程数据处理设备以特定方式工作的计算机可读存储器中,使得存储在该计算机可读存储器中的指令产生包括指令装置的制造品,该指令装置实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能。These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing apparatus to operate in a specific manner, such that the instructions stored in the computer-readable memory produce an article of manufacture comprising instruction means, the instructions The device realizes the function specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.
这些计算机程序指令也可装载到计算机或其他可编程数据处理设备上,使得在计算机或其他可编程设备上执行一系列操作步骤以产生计算机实现的处理,从而在计算机或其他可编程设备上执行的指令提供用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的步骤。These computer program instructions can also be loaded onto a computer or other programmable data processing device, causing a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process, thereby The instructions provide steps for implementing the functions specified in the flow chart or blocks of the flowchart and/or the block or blocks of the block diagrams.
尽管已描述了本申请的优选实施例,但本领域内的技术人员一旦得知了基本创造性概念,则可对这些实施例作出另外的变更和修改。所以,所附权利要求意欲解释为包括优选实施例以及落入本申请范围的所有变更和修改。While preferred embodiments of the present application have been described, additional changes and modifications to these embodiments can be made by those skilled in the art once the basic inventive concept is appreciated. Therefore, it is intended that the appended claims be interpreted to cover the preferred embodiment and all changes and modifications that fall within the scope of the application.
显然,本领域的技术人员可以对本申请进行各种改动和变型而不脱离本申请的精神和范围。这样,倘若本申请的这些修改和变型属于本申请权利要求及其等同技术的范围之内,则本申请也意图包含这些改动和变型在内。Obviously, those skilled in the art can make various changes and modifications to the application without departing from the spirit and scope of the application. In this way, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application is also intended to include these modifications and variations.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910570445.6A CN110287193A (en) | 2019-06-27 | 2019-06-27 | A file generation method, device, equipment and computer-readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910570445.6A CN110287193A (en) | 2019-06-27 | 2019-06-27 | A file generation method, device, equipment and computer-readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110287193A true CN110287193A (en) | 2019-09-27 |
Family
ID=68019980
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910570445.6A Pending CN110287193A (en) | 2019-06-27 | 2019-06-27 | A file generation method, device, equipment and computer-readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110287193A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110389955A (en) * | 2019-07-13 | 2019-10-29 | 北京海致星图科技有限公司 | A kind of data warehouse scheduling file automatic creation system and generation method |
| CN110990412A (en) * | 2019-12-25 | 2020-04-10 | 中国银行股份有限公司 | Data structure design method and device |
| CN112069773A (en) * | 2020-07-23 | 2020-12-11 | 北京三快在线科技有限公司 | Data processing system, method, apparatus, electronic device, and computer-readable medium |
| CN115797031A (en) * | 2022-11-01 | 2023-03-14 | 中电金信软件(上海)有限公司 | Freezing control method and device for business transaction, computer equipment and storage medium |
-
2019
- 2019-06-27 CN CN201910570445.6A patent/CN110287193A/en active Pending
Non-Patent Citations (1)
| Title |
|---|
| WUYONGDE0922: "JAVA读取Excel表格,建数据库建表,并生成java实体实例", pages 1 - 3, Retrieved from the Internet <URL:https://blog.csdn.net/wuyongde_0922/article/details/43233413> * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110389955A (en) * | 2019-07-13 | 2019-10-29 | 北京海致星图科技有限公司 | A kind of data warehouse scheduling file automatic creation system and generation method |
| CN110990412A (en) * | 2019-12-25 | 2020-04-10 | 中国银行股份有限公司 | Data structure design method and device |
| CN110990412B (en) * | 2019-12-25 | 2023-09-19 | 中国银行股份有限公司 | Data structure design method and device |
| CN112069773A (en) * | 2020-07-23 | 2020-12-11 | 北京三快在线科技有限公司 | Data processing system, method, apparatus, electronic device, and computer-readable medium |
| CN115797031A (en) * | 2022-11-01 | 2023-03-14 | 中电金信软件(上海)有限公司 | Freezing control method and device for business transaction, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11615142B2 (en) | Mapping and query service between object oriented programming objects and deep key-value data stores | |
| CN111966692B (en) | Data processing method, medium, device and computing equipment for data warehouse | |
| TWI748175B (en) | Data processing method, device and equipment | |
| US10540383B2 (en) | Automatic ontology generation | |
| US8768967B2 (en) | Data export/import from multiple data sources to a destination data repository using corresponding data exporters and an importer | |
| CN109034988B (en) | Accounting entry generation method and device | |
| US8762428B2 (en) | Rapidly deploying virtual database applications using data model analysis | |
| US8712965B2 (en) | Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse | |
| CN110287193A (en) | A file generation method, device, equipment and computer-readable storage medium | |
| US20170139975A1 (en) | Semantic database driven form validation | |
| US11362997B2 (en) | Real-time policy rule evaluation with multistage processing | |
| US20110191304A1 (en) | System and method for export and import of metadata located in metadata registries | |
| AU2017352442B2 (en) | Defining variability schemas in an application programming interface (API) | |
| CN114281803A (en) | Data migration method, device, equipment, medium and program product | |
| US20220300497A1 (en) | Ai-based data virtualization | |
| US20240296350A1 (en) | Computed values for knowledge graph | |
| CN112115209A (en) | Method for realizing data expansion | |
| WO2019019702A1 (en) | Algorithm generation method and device, terminal device and storage medium | |
| CN113220762A (en) | Method, device, processor and storage medium for realizing general record processing of key service field change in big data application | |
| US20170286471A1 (en) | Methods and apparatuses for enterprise revision-based auditing of database management systems | |
| CN112445499A (en) | Derived variable determination method, device, equipment and storage medium | |
| US9251222B2 (en) | Abstracted dynamic report definition generation for use within information technology infrastructure | |
| US20200218741A1 (en) | Inferring location attributes from data entries | |
| US20170193409A1 (en) | Business resource modeling | |
| US10248701B2 (en) | Efficient distributed query execution |
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 |