CN115905387A - Data code information generation method, device, equipment and storage medium - Google Patents

Data code information generation method, device, equipment and storage medium Download PDF

Info

Publication number
CN115905387A
CN115905387A CN202211502448.4A CN202211502448A CN115905387A CN 115905387 A CN115905387 A CN 115905387A CN 202211502448 A CN202211502448 A CN 202211502448A CN 115905387 A CN115905387 A CN 115905387A
Authority
CN
China
Prior art keywords
database
information table
data
data item
logic
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
CN202211502448.4A
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.)
China Construction Bank Corp
CCB Finetech Co Ltd
Original Assignee
China Construction Bank Corp
CCB Finetech Co Ltd
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 China Construction Bank Corp, CCB Finetech Co Ltd filed Critical China Construction Bank Corp
Priority to CN202211502448.4A priority Critical patent/CN115905387A/en
Publication of CN115905387A publication Critical patent/CN115905387A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application provides a data code information generation method, a data code information generation device, data code information generation equipment and a storage medium, and relates to the technical field of data information processing. The method comprises the steps of obtaining a logic information table; wherein, the logic information table comprises Chinese names of fields; determining the type of the database in a standard data item configuration table according to the logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database; and generating data code information matched with the database by the logic information table according to the standard data item configuration table. By adopting the technical scheme, a modeling tool is not needed, and the database can be directly and automatically converted into the database physical model by only providing the database logic in a table form. The difficulty of the database logic model is reduced, the workload is reduced, the use of modeling software is reduced, and the aims of reducing the cost and improving the working efficiency can be fulfilled.

Description

Data code information generation method, device, equipment and storage medium
Technical Field
The present application relates to the field of data information processing technologies, and in particular, to a data code information generation method, apparatus, device, and storage medium.
Background
At present, the conversion of the database logical model into the database physical model is usually realized by professional database modelers using professional modeling tools, specifically, the database logical model is created first, and then a specific database product such as Oracle is selected and converted into the database physical model in the Oracle format for developers to use.
However, this approach requires specialized data modelers throughout the development phase of the project, requires specialized modeling tools to perform the transformations, and only transforms to one database physical model at a time. If the data needs to be converted into a plurality of physical data models, a plurality of sets of database logic models need to be created, or the same set of database logic model is used for continuously switching database products, so that the aim of converting the data into a plurality of sets of database physical models is fulfilled.
Therefore, a method for generating data code information is needed, which can directly and automatically convert into a database physical model by providing a database logic in a table form without using a modeling tool. The difficulty of the database logic model is reduced, the workload is reduced, the use of modeling software is reduced, and the aims of reducing the cost and improving the working efficiency can be fulfilled.
Disclosure of Invention
The application provides a data code information generation method, a data code information generation device and a storage medium, which can directly and automatically convert data code information into a database physical model by providing database logic in a table form without using a modeling tool. The difficulty of the database logic model is reduced, the workload is reduced, the use of modeling software is reduced, and the aims of reducing the cost and improving the working efficiency can be fulfilled.
In a first aspect, the present application provides a data code information generating method, including:
acquiring a logic information table; the logic information table comprises Chinese names of fields;
determining the type of a database in a standard data item configuration table according to the logic information table; wherein the standard data item configuration table represents the mapping relation between the logic information table and the database;
and generating data code information matched with the database by the logic information table according to the standard data item configuration table.
In one example, the configuring the table according to the standard data item, and the generating the logic information table into the data code information matched with the database includes:
according to the Chinese name of a field in the logic information table, determining the English name of the field and the data type of the field in the database in the standard data item configuration table;
and generating data code information matched with the database by the logic information table according to the English name of the field and the data type.
In one example, the generating the logic information table into data code information matched with the database according to the English name of the field and the data type includes:
generating initial data information by using the English name of the field and the data type according to the database grammar of the database;
and generating data code information matched with the database according to the logic information table and the initial data information.
In one example, before the determining the type of the database in the standard data item configuration table, the method further includes:
determining a data item corresponding to a field in the standard data item configuration table according to the Chinese name of the field in the logic information table;
and if the data item corresponding to the field in the standard data item configuration table is missing, adding the data item corresponding to the field.
In one example, the method further comprises:
and if the number of the types of the database is a numerical value larger than one, sequentially configuring a table according to the standard data items, and generating data code information matched with the database by using the logic information table.
In one example, the code languages of the data code information are the same.
In a second aspect, the present application provides a data code information generating apparatus, the apparatus comprising:
an acquisition unit configured to acquire a logical information table; wherein, the logic information table comprises Chinese names of fields;
the first determining unit is used for determining the type of the database in a standard data item configuration table according to the logic information table; wherein the standard data item configuration table represents the mapping relation between the logic information table and the database;
and the first generating unit is used for generating the data code information matched with the database from the logic information table according to the standard data item configuration table.
In one example, a first generation unit includes:
the determining module is used for determining the English name of the field and the data type of the field in the database in the standard data item configuration table according to the Chinese name of the field in the logic information table;
and the generating module is used for generating the logic information table into data code information matched with the database according to the English name of the field and the data type.
In one example, a generation module includes:
the first generation submodule is used for generating initial data information by the English name of the field and the data type according to the database grammar of the database;
and the second generation submodule is used for generating data code information matched with the database according to the logic information table and the initial data information.
In one example, the apparatus further comprises:
a second determining unit, configured to determine, according to the chinese name of a field in the logical information table, a data item corresponding to the field in the standard data item configuration table;
and the adding unit is used for adding the data item corresponding to the field if the data item corresponding to the field in the standard data item configuration table is missing.
In one example, the apparatus further comprises:
and the second generation unit is used for sequentially generating data code information matched with the database from the logic information table according to the standard data item configuration table if the number of the types of the database is a numerical value larger than one.
In one example, the code languages of the data code information are the same.
In a third aspect, the present application provides an electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of the first aspect.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon computer-executable instructions for implementing the method according to the first aspect when executed by a processor.
In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the method according to the first aspect.
According to the data code information generation method, the data code information generation device, the data code information generation equipment and the storage medium, the logic information table is obtained; wherein, the logic information table comprises Chinese names of fields; determining the type of a database in a standard data item configuration table according to the logic information table; wherein the standard data item configuration table represents the mapping relation between the logic information table and the database; and generating data code information matched with the database by the logic information table according to the standard data item configuration table. By adopting the technical scheme, a modeling tool is not needed, and only the database logic in a table form is needed to be provided, so that the database can be directly and automatically converted into the physical database model. The difficulty of the database logic model is reduced, the workload is reduced, the use of modeling software is reduced, and the aims of reducing the cost and improving the working efficiency can be fulfilled.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic flowchart of a data code information generating method according to an embodiment of the present application;
FIG. 2 is a schematic flowchart of a data code information generating method according to a second embodiment of the present application;
FIG. 3 is a schematic structural diagram of a data code information generating apparatus according to a third embodiment of the present application;
fig. 4 is a schematic structural diagram of a data code information generating apparatus according to a fourth embodiment of the present application;
FIG. 5 is a block diagram illustrating an electronic device in accordance with an example embodiment.
With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. The drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the concepts of the application by those skilled in the art with reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the application, as detailed in the appended claims.
The application provides a data code information generation method, which aims to solve the technical problems in the prior art.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
In the technical scheme of the application, the collection, storage, use, processing, transmission, provision, disclosure and other processing of the related information such as financial data or user data and the like all accord with the regulations of related laws and regulations and do not violate the good custom of the public order.
Fig. 1 is a schematic flowchart of a data code information generation method according to an embodiment of the present application. The first embodiment comprises the following steps:
s101, acquiring a logic information table; wherein the logical information table includes the Chinese name of the field.
In one example, the logical information table is a listing of data-critical information, which is a table built up from the collection, transmission, processing, storage, and output of various process analysis summaries of the data-critical information. For example, in a people information management system, a logical information table includes a table Chinese name, a table English name, a field Chinese name, a field type, whether a primary key is present, and whether it is not empty. The Chinese names of the fields are user numbers, user names or remarks, and the like. The user number is 10 characters without Chinese; the user name is less than 20 characters, including Chinese characters; the number of remarked characters is a range, up to 100 characters, and includes chinese characters. Specifically, the logic information table can be referred to in table 1.
TABLE 1 logic information Table
Figure BDA0003968308820000051
S102, determining the type of a database in a standard data item configuration table according to a logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database.
In this embodiment, the standard data item configuration table is used to convert the logic information table into data code information of the database, where the standard data item configuration table includes the following data items: chinese name of field, english name of field, length description, oracle data type, mySQL data type, hive data type, postgreSQL data type, and SQLite data type. Specifically, see the standard data item configuration table shown in table 2. Wherein the Oracle datatype representation length describes the representation in the Oracle database, such as VARCHAR2 under UTF8 character set (60). MySQL data type represents a representation whose length is described in the MySQL database, such as VARCHAR (20). The PostgreSQL data type representation length describes a representation in a PostgreSQL database, such as VARCHAR (20). Hive data type representation length is described in a representation of Hive database, such as VARCHAR (20). SQLite data type representation length describes a representation in a SQLite database, such as VARCHAR (20).
In this embodiment, the types of the database include: oracle database type, mySQL database type, hive database type, postgreSQL database type, and SQLite database type.
Table 2 standard data item configuration table
Figure BDA0003968308820000061
And S103, generating data code information matched with the database from the logic information table according to the standard data item configuration table.
In this embodiment, the generation of the data code information matching the logical information table with the database is realized by a conversion component, and the data code information is generated in an SQL statement manner.
The data code information generation method provided by the application comprises the steps of obtaining a logic information table; wherein, the logic information table comprises Chinese names of fields; determining the type of the database in a standard data item configuration table according to the logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database; and generating data code information matched with the database by the logic information table according to the standard data item configuration table. By adopting the technical scheme, a modeling tool is not needed, and only the database logic in a table form is needed to be provided, so that the database can be directly and automatically converted into the physical database model. The difficulty of the database logic model is reduced, the workload is reduced, the use of modeling software is reduced, and the aims of reducing the cost and improving the working efficiency can be fulfilled.
Fig. 2 is a schematic flowchart of a data code information generation method according to a second embodiment of the present application. The second embodiment comprises the following steps:
s201, acquiring a logic information table; wherein the logical information table includes the Chinese name of the field.
For example, this step may refer to step S101 described above, and is not described again.
S202, determining data items corresponding to the fields in the standard data item configuration table according to the Chinese names of the fields in the logic information table.
In this embodiment, the chinese name of a field in the logical information table is obtained, the chinese name of the field is determined in the standard data item configuration table, and the english name, the length description, the Oracle data type, the MySQL data type, the Hive data type, the PostgreSQL data type, and the SQLite data type of the field corresponding to the chinese name of the field are determined. Specifically, traversal may be performed according to the above sequence to determine whether a data item is missing in the standard data item configuration table.
S203, if the data items corresponding to the fields in the standard data item configuration table are missing, adding the data items corresponding to the fields.
For example, in this embodiment, if a data item corresponding to a field in the standard data item configuration table is missing, the missing data item is supplemented.
S204, determining the type of the database in a standard data item configuration table according to the logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database.
For example, this step may refer to step S102, which is not described again.
S205, according to the Chinese name of the field in the logic information table, determining the English name of the field and the data type of the field in the database in the standard data item configuration table.
In this embodiment, for example, if the chinese name of a field in the logical information table is a user number, the english name of the field is determined to be user _ id in the standard data item configuration table according to the user number, and if the data type of the field in the database is an Oracle data type, the field is represented as VARCHAR2 (10).
And S206, generating data code information matched with the database by the logic information table according to the English name and the data type of the field.
In one example, generating the logical information table into data code information matched with the database according to the English name and the data type of the field comprises:
generating initial data information by the English name and the data type of the field according to the database grammar of the database;
and generating data code information matched with the database according to the logic information table and the initial data information.
In this embodiment, the database syntax of different databases is different, for example, the database syntax may be the database syntax of Oracle and the database syntax of MySQL. For example, the type of the database is the MySQL database type, and the conversion component assembles other information of the logical information table, such as whether the main key is not empty, according to the logical information table and the MySQL database syntax, to form data code information of MySQL.
In one example, the code languages of the data code information are the same. The code Language may be Structured Query Language (SQL).
In one example, the method further comprises:
and if the number of the types of the database is a numerical value larger than one, sequentially configuring the table according to the standard data items, and generating the data code information matched with the database by the logic information table.
In this embodiment, if the number of the types of the databases is a numerical value greater than one, the logic information table generates data code information matched with the databases according to the types of each database according to the standard data item configuration table.
The data code information generating method includes the steps of determining data items corresponding to fields in a standard data item configuration table according to Chinese names of the fields in a logic information table, adding the data items corresponding to the fields if the data items corresponding to the fields in the standard data item configuration table are missing, determining the type of a database in the standard data item configuration table according to the logic information table, determining English names of the fields and the data types of the fields in the database in the standard data item configuration table according to the Chinese names of the fields in the logic information table, and generating data code information matched with the database by the logic information table according to the English names of the fields and the data types. By adopting the technical scheme, the one-time design of the logical model of the database is realized, the database can be adapted to various databases for many times, and the difficulty of designing the physical model of the database is greatly reduced.
Fig. 3 is a schematic structural diagram of a data code information generating apparatus according to a third embodiment of the present application. Specifically, the apparatus 30 of the third embodiment includes:
an obtaining unit 301, configured to obtain a logic information table; wherein the logical information table includes the Chinese names of the fields.
A first determining unit 302, configured to determine a type of the database in the standard data item configuration table according to the logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database.
A first generating unit 303, configured to generate data code information matching the logical information table with the database according to the standard data item configuration table.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the above-described apparatus may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
Fig. 4 is a schematic structural diagram of a data code information generating apparatus according to the fourth embodiment of the present application. Specifically, the apparatus 40 according to the fourth embodiment includes:
an obtaining unit 401, configured to obtain a logic information table; wherein the logical information table includes the Chinese name of the field.
A first determining unit 402, configured to determine a type of the database in the standard data item configuration table according to the logic information table; the standard data item configuration table represents the mapping relation between the logic information table and the database.
A first generating unit 403, configured to generate data code information matching the logic information table with the database according to the standard data item configuration table.
In one example, the first generating unit 403 includes:
a determining module 4031, configured to determine, according to the chinese name of the field in the logic information table, an english name of the field and a data type of the field in the database in the standard data item configuration table.
And a generating module 4032 for generating the data code information matched with the database from the logic information table according to the English name and the data type of the field.
In one example, generating module 4032 includes:
the first generation sub-module 40321 is used for generating initial data information by using the english name and the data type of the field according to the database syntax of the database.
And a second generating sub-module 40322, configured to generate data code information matched with the database according to the logical information table and the initial data information.
In one example, the apparatus 40 further comprises:
and a second determining unit 404, configured to determine, according to the chinese name of the field in the logical information table, a data item corresponding to the field in the standard data item configuration table.
An adding unit 405, configured to add a data item corresponding to a field if the data item corresponding to the field in the standard data item configuration table is missing.
In one example, the apparatus 40 further comprises:
and a second generating unit 406, configured to, if the number of the types of the database is a numerical value greater than one, sequentially configure the table according to the standard data items, and generate data code information matching the logic information table with the database.
In one example, the code languages of the data code information are the same.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the above-described apparatus may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
FIG. 5 is a block diagram illustrating an electronic device, which may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, an exercise device, a personal digital assistant, and the like, in accordance with one exemplary embodiment.
The apparatus 500 may include one or more of the following components: processing component 502, memory 504, power component 506, multimedia component 508, audio component 510, input/output (I/O) interface 512, sensor component 514, and communication component 516.
The processing component 502 generally controls overall operation of the device 500, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing components 502 may include one or more processors 520 to execute instructions to perform all or a portion of the steps of the methods described above. Further, the processing component 502 can include one or more modules that facilitate interaction between the processing component 502 and other components. For example, the processing component 502 can include a multimedia module to facilitate interaction between the multimedia component 508 and the processing component 502.
The memory 504 is configured to store various types of data to support operations at the apparatus 500. Examples of such data include instructions for any application or method operating on device 500, contact data, phonebook data, messages, pictures, videos, and so forth. The memory 504 may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.
The power supply component 506 provides power to the various components of the device 500. The power components 506 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the apparatus 500.
The multimedia component 508 includes a screen that provides an output interface between the device 500 and the user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 508 includes a front facing camera and/or a rear facing camera. The front camera and/or the rear camera may receive external multimedia data when the device 500 is in an operating mode, such as a shooting mode or a video mode. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.
The audio component 510 is configured to output and/or input audio signals. For example, audio component 510 includes a Microphone (MIC) configured to receive external audio signals when apparatus 500 is in an operating mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may further be stored in the memory 504 or transmitted via the communication component 516. In some embodiments, audio component 510 further includes a speaker for outputting audio signals.
The I/O interface 512 provides an interface between the processing component 502 and peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include, but are not limited to: a home button, a volume button, a start button, and a lock button.
The sensor component 514 includes one or more sensors for providing various aspects of state assessment for the apparatus 500. For example, the sensor assembly 514 may detect an open/closed state of the apparatus 500, the relative positioning of the components, such as a display and keypad of the apparatus 500, the sensor assembly 514 may also detect a change in the position of the apparatus 500 or a component of the apparatus 500, the presence or absence of user contact with the apparatus 500, orientation or acceleration/deceleration of the apparatus 500, and a change in the temperature of the apparatus 500. The sensor assembly 514 may include a proximity sensor configured to detect the presence of a nearby object without any physical contact. The sensor assembly 514 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 514 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.
The communication component 516 is configured to facilitate communication between the apparatus 500 and other devices in a wired or wireless manner. The apparatus 500 may access a wireless network based on a communication standard, such as WiFi,2G or 3G, or a combination thereof. In an exemplary embodiment, the communication component 516 receives a broadcast signal or broadcast related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 516 further includes a Near Field Communication (NFC) module to facilitate short-range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.
In an exemplary embodiment, the apparatus 500 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, micro-controllers, microprocessors or other electronic components for performing the above-described methods.
In an exemplary embodiment, a non-transitory computer-readable storage medium comprising instructions, such as the memory 504 comprising instructions, executable by the processor 520 of the apparatus 500 to perform the above-described method is also provided. For example, the non-transitory computer readable storage medium may be a ROM, a Random Access Memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
A non-transitory computer-readable storage medium, in which instructions, when executed by a processor of an electronic device, enable the electronic device to perform a data code information generation method of the electronic device.
The application also discloses a computer program product comprising a computer program which, when executed by a processor, implements the method as described in the embodiments.
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
Program code for implementing the methods of the present application may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or electronic device.
In the context of this application, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data electronic device), or that includes a middleware component (e.g., an application electronic device), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), and the Internet.
The computer system may include a client and an electronic device. The client and the electronic device are generally remote from each other and typically interact through a communication network. The relationship of client and electronic device arises by virtue of computer programs running on the respective computers and having a client-electronic device relationship to each other. The electronic device may be a cloud electronic device, which is also called a cloud computing electronic device or a cloud host, and is a host product in a cloud computing service system, so as to solve the defects of high management difficulty and weak service extensibility in a traditional physical host and a VPS service ("Virtual Private Server", or "VPS" for short). The electronic device may also be a distributed system of electronic devices or an electronic device incorporating a blockchain. It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present application may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solutions disclosed in the present application can be achieved.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It will be understood that the present application is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.

Claims (10)

1. A data code information generating method, characterized in that the method comprises:
acquiring a logic information table; the logic information table comprises Chinese names of fields;
determining the type of a database in a standard data item configuration table according to the logic information table; wherein the standard data item configuration table represents the mapping relation between the logic information table and the database;
and generating data code information matched with the database by the logic information table according to the standard data item configuration table.
2. The method of claim 1, wherein the configuring the table according to the standard data item, generating the logical information table into data code information matched with the database, comprises:
according to the Chinese name of a field in the logic information table, determining the English name of the field and the data type of the field in the database in the standard data item configuration table;
and generating data code information matched with the database by the logic information table according to the English name of the field and the data type.
3. The method of claim 2, wherein the generating the logical information table into data code information matched with the database according to the english name of the field and the data type comprises:
generating initial data information by using the English name of the field and the data type according to the database grammar of the database;
and generating data code information matched with the database according to the logic information table and the initial data information.
4. The method of claim 2, further comprising, prior to said determining the type of database in the standard data item configuration table:
determining a data item corresponding to a field in the standard data item configuration table according to the Chinese name of the field in the logic information table;
and if the data item corresponding to the field in the standard data item configuration table is missing, adding the data item corresponding to the field.
5. The method according to any one of claims 1-4, further comprising:
and if the number of the types of the database is a numerical value larger than one, sequentially configuring a table according to the standard data items, and generating data code information matched with the database by using the logic information table.
6. The method according to claim 5, wherein the code languages of the data code information are the same.
7. An apparatus for generating data code information, the apparatus comprising:
an acquisition unit configured to acquire a logical information table; wherein, the logic information table comprises Chinese names of fields;
the first determining unit is used for determining the type of the database in a standard data item configuration table according to the logic information table; wherein the standard data item configuration table represents the mapping relation between the logic information table and the database;
and the first generating unit is used for generating the data code information matched with the database from the logic information table according to the standard data item configuration table.
8. An electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of any of claims 1-6.
9. A computer-readable storage medium having computer-executable instructions stored therein, which when executed by a processor, are configured to implement the method of any one of claims 1-6.
10. A computer program product, comprising a computer program which, when executed by a processor, implements the method of any one of claims 1-6.
CN202211502448.4A 2022-11-28 2022-11-28 Data code information generation method, device, equipment and storage medium Pending CN115905387A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211502448.4A CN115905387A (en) 2022-11-28 2022-11-28 Data code information generation method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211502448.4A CN115905387A (en) 2022-11-28 2022-11-28 Data code information generation method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115905387A true CN115905387A (en) 2023-04-04

Family

ID=86477585

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211502448.4A Pending CN115905387A (en) 2022-11-28 2022-11-28 Data code information generation method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115905387A (en)

Similar Documents

Publication Publication Date Title
CN107423106B (en) Method and apparatus for supporting multi-frame syntax
CN110442844B (en) Data processing method, device, electronic equipment and storage medium
CN111061452A (en) Voice control method and device of user interface
CN111552688A (en) Data export method and device and electronic equipment
CN115687303A (en) Data information migration method, device, equipment and storage medium
CN115905387A (en) Data code information generation method, device, equipment and storage medium
CN114090738A (en) Method, device and equipment for determining scene data information and storage medium
CN114298227A (en) Text duplicate removal method, device, equipment and medium
CN112988822A (en) Data query method, device, equipment, readable storage medium and product
CN111488267B (en) Interface test script generation method and device and electronic equipment
CN111191998A (en) Item processing method and device
CN114357052A (en) Heterogeneous database object conversion method and device, electronic equipment and storage medium
CN113778385B (en) Component registration method, device, terminal and storage medium
CN112182027B (en) Information query method, device, electronic equipment and storage medium
CN114329088A (en) Directory structure file generation method, device, equipment and storage medium
CN116680274A (en) Method and device for associating business database table and attachment information table
CN116562999A (en) Financial product asset class determination method, equipment and storage medium
CN111159148B (en) Configuration information state management method and device, electronic equipment and storage medium
CN117472931A (en) Method, device, equipment and storage medium for calling database execution statement
CN115756489A (en) Program language conversion method, device, equipment and storage medium
CN117539887A (en) Database statement conversion method, device, equipment and storage medium
CN114756319A (en) Applet page display method, device and equipment and storage medium
CN115269697A (en) Product data information conversion method and device, storage medium and electronic equipment
CN115268935A (en) Data processing method and device
CN113326282A (en) SQL statement generation method and device, electronic equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination