CN111324614A - Table configuration method and device, terminal equipment and storage medium - Google Patents
Table configuration method and device, terminal equipment and storage medium Download PDFInfo
- Publication number
- CN111324614A CN111324614A CN202010192645.5A CN202010192645A CN111324614A CN 111324614 A CN111324614 A CN 111324614A CN 202010192645 A CN202010192645 A CN 202010192645A CN 111324614 A CN111324614 A CN 111324614A
- Authority
- CN
- China
- Prior art keywords
- column
- data
- data table
- sql file
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a configuration method of a table, which comprises the following steps: acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information; comparing the table name of the data table with a database, and verifying whether the data table exists or not; when the data table exists, updating the column data of the database based on the column information, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter; when the data table does not exist, the data table is created in the database, a corresponding table SQL file is generated, and when the table type of the created data table is configured to be an auxiliary table, a foreign key is established for a main table associated with the created data table. The invention also discloses a configuration device of the table, terminal equipment and a storage medium, which can visually acquire the relationship between the table and the table through the table type, effectively improve the operation efficiency and are easy to operate.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a table configuration method and apparatus, a terminal device, and a storage medium.
Background
The method comprises the steps of building a table in a database, associating a plurality of tables through foreign keys to form relationships between the tables, enabling the ER graph to clearly know the relationships between the tables, and enabling the tables to form a hierarchical relationship between data logics of the tables through different fields. However, the relation between tables can be known only through tools, for example, Navicat, the logical relation between tables cannot be visually seen, so that the manual maintenance cost is increased, the difficulty is eliminated, and the risk of error modification is avoided. Moreover, users who are not familiar with database operations cannot maintain and establish tables, increasing the development investment in the later period.
Disclosure of Invention
Embodiments of the present invention provide a table configuration method and apparatus, a terminal device, and a storage medium, which can effectively solve the problem in the prior art that the relationship between tables can only be known by a tool in a database, so that the relationship between tables can be directly known by table type, the operation efficiency can be effectively improved, and the operation is easy.
An embodiment of the present invention provides a table configuration method, including:
acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information;
comparing the table name of the data table with a database, and verifying whether the data table exists or not;
when the data table exists, updating the column data of the database based on the column information, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter;
when the data table does not exist, the data table is created in the database, a corresponding table SQL file is generated, and when the table type of the created data table is configured to be an auxiliary table, a foreign key is established for a main table associated with the created data table.
As an improvement of the above scheme, when the data table exists, the updating the column data of the database based on the column information to generate a corresponding column SQL file specifically includes:
when the data table exists, inquiring column data corresponding to the data table from the database according to the table name;
comparing the column information with the column data of the database according to the column name in the column information, and judging whether the column information exists or not; if not, adding and storing the column information, and generating a corresponding newly added column SQL file; if so, comparing the column information with the column of the column data, and updating the column data according to a comparison result; wherein the column SQL file comprises the newly added column SQL file.
As an improvement of the above scheme, the comparing the column length of the column information with the column data, and updating the column data according to the comparison result specifically includes:
when the column length of the column data is larger than that of the column information, deleting the column data and generating a corresponding deleted column SQL file;
when the column length of the column data is not greater than the column length of the column information, modifying the column data according to the column information, and generating a corresponding modified column SQL file; the column SQL file also comprises the deleted column SQL file and the modified column SQL file.
As an improvement of the above scheme, the establishing an index when the updated column data configuration is unique in parameter specifically includes:
judging whether the newly added column data or the modified column data are configured to be unique parameters; if so, establishing an index corresponding to the updated column data, and further executing the column SQL file; and if not, executing the column SQL file.
As an improvement of the above scheme, when the table type of the created data table is configured as an auxiliary table, the establishing of the foreign key with the main table associated with the created data table specifically includes:
judging whether the table type of the created data table is configured as an auxiliary table or not; if yes, inquiring a related main table through the parameters of the created data table, establishing an external key with the main table, and further executing the table SQL file; and if not, executing the table SQL file.
Another embodiment of the present invention correspondingly provides a table configuration apparatus, including:
the data table information acquisition module is used for acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information;
the verification module is used for comparing the table name of the data table with a database and verifying whether the data table exists or not;
the data table existence module is used for updating the column data of the database based on the column information when the data table exists, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter;
and the data table non-existence module is used for creating the data table in the database when the data table does not exist, generating a corresponding table SQL file, and establishing a foreign key with the main table associated with the created data table when the table type of the created data table is configured as an auxiliary table.
Compared with the prior art, the table configuration method and the table configuration device disclosed by the embodiment of the invention have the advantages that the basic information of the pre-established data table is obtained; wherein, the basic information comprises a table name, a table type and column information, the table name of the data table is compared with a database to verify whether the data table exists, when the data table exists, the column data of the database is updated based on the column information to generate a corresponding column SQL file, and when the updated column data is configured as a parameter unique, an index is established, when the data table does not exist, the data table is created in the database to generate a corresponding table SQL file, and when the table type of the created data table is configured as an auxiliary table, a main table associated with the created data table is established with an external key, thus effectively solving the problem that the relation between the table and the table can be known in the database through tools in the prior art, realizing the intuitive acquisition of the logical relation between the table and the table in the database, and effectively improving the operation efficiency, the operation is easy; in addition, the difficulty and risk of later maintenance, difficulty in removing, error in modification and the like can be effectively reduced.
Another embodiment of the present invention provides a terminal device for configuring a table, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, where the processor implements the table configuring method according to the above embodiment of the present invention when executing the computer program.
Another embodiment of the present invention provides a storage medium, where the computer-readable storage medium includes a stored computer program, where when the computer program runs, the apparatus where the computer-readable storage medium is located is controlled to execute the table configuration method described in the above embodiment of the present invention.
Drawings
FIG. 1 is a flowchart illustrating a table configuring method according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a table configuration method according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a table configuration apparatus according to a second embodiment of the present invention;
fig. 4 is a schematic structural diagram of a configuration terminal device of a table according to a third embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
Referring to fig. 1, a flowchart of a table configuration method according to an embodiment of the present invention is shown, where the method includes steps S101 to S104.
S101, acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information.
In this embodiment, a data table is established in advance, and basic information of the data table is acquired. The basic information includes a table name, a table type, and column information, and the table type may include a general table, a tree table, a cascade table, a single-row table, and an auxiliary table, but is not limited thereto. The column information may include a column name, a field type, and a column length.
S102, comparing the table name of the data table with a database, and verifying whether the data table exists.
For example, please refer to fig. 2, which is a specific flowchart illustrating a table configuration method according to an embodiment of the present invention, wherein after a data table is created, a table name is used to verify whether the table exists. Specifically, the table name (tableName) of the data table is used to query whether the table name (tableName) already exists in the table of the database.
S103, when the data table exists, updating the column data of the database based on the column information, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter.
In a preferred embodiment, step S103 specifically includes:
when the data table exists, inquiring column data corresponding to the data table from the database according to the table name;
comparing the column information with the column data of the database according to the column name in the column information, and judging whether the column information exists or not; if not, adding and storing the column information, and generating a corresponding newly added column SQL file; if so, comparing the column information with the column of the column data, and updating the column data according to a comparison result; wherein the column SQL file comprises the newly added column SQL file.
Further, step S103 further includes:
when the column length of the column data is larger than that of the column information, deleting the column data and generating a corresponding deleted column SQL file;
when the column length of the column data is not greater than the column length of the column information, modifying the column data according to the column information, and generating a corresponding modified column SQL file; the column SQL file also comprises the deleted column SQL file and the modified column SQL file.
Further, step S103 specifically includes:
judging whether the newly added column data or the modified column data are configured to be unique parameters; if so, establishing an index corresponding to the updated column data, and further executing the column SQL file; and if not, executing the column SQL file.
It can be understood that the column information is basic information of a pre-established data table, and the column data is basic information of a column corresponding to the data table in the database. For example, referring to fig. 2, when the data table exists in the database, the column data of the table is queried according to the table name, and then compared with the column data queried by the table, and the new, modified, and deleted columns are compared according to the column name, and then converted into the corresponding new, modified, and deleted column SQL files. Specifically, whether columns exist is compared through column names, and if not, SQL sentences of newly added columns are newly added and stored; if the data table exists, modifying the column to obtain the SQL sentence of the modified column, and if the column of the database in the comparison is more than the column of the pre-established data table, deleting the column to obtain the SQL sentence of the deleted column. Further, please refer to fig. 2, determine whether the parameters of the newly added columns or the modified columns configure a unique index, if yes, establish an index, and then execute the column SQL file; if not, executing the column SQL file. It can be understood that, specifically, determining whether the newly added column data or the modified column data is configured to have a unique parameter is that, when the parameter isunique value of the newly added column data or the modified column data is 1, it is determined that the newly added column data or the modified column data is configured to have a unique parameter (i.e., a unique value), and a unique index needs to be established; when the parameter isunique value of the newly added column data or the modified column data is not 1, the newly added column data or the modified column data is considered to be configured with non-unique parameters, and a unique index is not required to be established. Therefore, the logical relationship between the tables can be intuitively known from the database.
S104, when the data table does not exist, the data table is created in the database, a corresponding table SQL file is generated, and when the table type of the created data table is configured to be an auxiliary table, a foreign key is established for a main table associated with the created data table.
In a preferred embodiment, step S104 specifically includes:
judging whether the table type of the created data table is configured as an auxiliary table or not; if yes, inquiring a related main table through the parameters of the created data table, establishing an external key with the main table, and further executing the table SQL file; and if not, executing the table SQL file.
For example, referring to fig. 2, when the data table does not exist in the database, a default field is added in the database according to the table type of the data table to create the data table in the database, and the data table is converted into a table SQL file; further judging whether the created data table is an attached table, if so, converting the data table into an index establishing external key and associating the table SQL file, and further executing the table SQL file; if not, executing the table SQL file. Specifically, if the table type of the created data table is an attached table, the table type can find the main table of the corresponding table through pid, and establish a foreign key with the main table. Therefore, the logical relationship between the tables can be intuitively known from the database.
The table configuration method provided by the embodiment of the invention comprises the steps of acquiring basic information of a pre-established data table; wherein, the basic information comprises a table name, a table type and column information, the table name of the data table is compared with a database to verify whether the data table exists, when the data table exists, the column data of the database is updated based on the column information to generate a corresponding column SQL file, and when the updated column data is configured as a parameter unique, an index is established, when the data table does not exist, the data table is created in the database to generate a corresponding table SQL file, and when the table type of the created data table is configured as an auxiliary table, a main table associated with the created data table is established with an external key, thus effectively solving the problem that the relation between the table and the table can be known in the database through tools in the prior art, realizing the intuitive acquisition of the logical relation between the table and the table in the database, and effectively improving the operation efficiency, the operation is easy; in addition, the difficulty and risk of later maintenance, difficulty in removing, error in modification and the like can be effectively reduced.
Example two
Referring to fig. 3, a schematic structural diagram of a configuration apparatus of a watch according to a second embodiment of the present invention is shown, including:
a data table information obtaining module 201, configured to obtain basic information of a pre-established data table; the basic information comprises a table name, a table type and column information;
the verification module 202 is configured to compare the table name of the data table with a database, and verify whether the data table exists;
a data table existence module 203, configured to update the column data of the database based on the column information when the data table exists, generate a corresponding column SQL file, and establish an index when the updated column data configuration is unique in parameter;
a data table non-existence module 204, configured to create the data table in the database when the data table does not exist, generate a corresponding table SQL file, and establish a foreign key with a main table associated with the created data table when the table type of the created data table is configured as an auxiliary table.
Preferably, the data table existence module 203 comprises:
a column data query unit, configured to query, when the data table exists, column data corresponding to the data table from the database according to the table name;
the database updating unit is used for comparing the column information with the column data of the database according to the column name in the column information and judging whether the column information exists or not; if not, adding and storing the column information, and generating a corresponding newly added column SQL file; if so, comparing the column information with the column of the column data, and updating the column data according to a comparison result; wherein the column SQL file comprises the newly added column SQL file.
Preferably, the data table existence module 203 comprises:
the column deleting unit is used for deleting the column data and generating a corresponding deleted column SQL file when the column length of the column data is greater than that of the column information;
the column modification unit is used for modifying the column data according to the column information and generating a corresponding modified column SQL file when the column length of the column data is not greater than the column length of the column information; the column SQL file also comprises the deleted column SQL file and the modified column SQL file.
Preferably, the data table existence module 203 comprises:
the index establishing unit is used for judging whether the newly added column data or the modified column data are configured to be unique parameters; if so, establishing an index corresponding to the updated column data, and further executing the column SQL file; and if not, executing the column SQL file.
Preferably, the data table absence module 204 includes:
an affiliated table judging unit for judging whether the table type of the created data table is configured as an affiliated table; if yes, inquiring a related main table through the parameters of the created data table, establishing an external key with the main table, and further executing the table SQL file; and if not, executing the table SQL file.
The table configuration device provided by the embodiment of the invention comprises the following steps of acquiring basic information of a pre-established data table; wherein, the basic information comprises a table name, a table type and column information, the table name of the data table is compared with a database to verify whether the data table exists, when the data table exists, the column data of the database is updated based on the column information to generate a corresponding column SQL file, and when the updated column data is configured as a parameter unique, an index is established, when the data table does not exist, the data table is created in the database to generate a corresponding table SQL file, and when the table type of the created data table is configured as an auxiliary table, a main table associated with the created data table is established with an external key, thus effectively solving the problem that the relation between the table and the table can be known in the database through tools in the prior art, realizing the intuitive acquisition of the logical relation between the table and the table in the database, and effectively improving the operation efficiency, the operation is easy; in addition, the difficulty and risk of later maintenance, difficulty in removing, error in modification and the like can be effectively reduced.
EXAMPLE III
Fig. 4 is a schematic structural diagram of a configuration terminal device of a table according to a third embodiment of the present invention. The configuration terminal device of the table of this embodiment includes: a processor 301, a memory 302 and a computer program, such as a configuration program of a table, stored in said memory 302 and executable on said processor 301. The processor 301 implements the steps in the above-described embodiments of the table configuration method when executing the computer program. Alternatively, the processor 301 implements the functions of the modules/units in the above device embodiments when executing the computer program.
Illustratively, the computer program may be partitioned into one or more modules/units that are stored in the memory and executed by the processor 301 to implement the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution process of the computer program in the configuration terminal device of the table.
The configuration terminal device of the watch can be a desktop computer, a notebook computer, a palm computer, a cloud server and other computing devices. The configuration terminal device of the table may include, but is not limited to, a processor, a memory. It will be understood by those skilled in the art that the schematic diagram is merely an example of a configuration terminal device of a table, and does not constitute a limitation of the configuration terminal device of the table, and may include more or less components than those shown, or combine some components, or different components, for example, the configuration terminal device of the table may further include input-output devices, network access devices, buses, etc.
The Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may be any conventional processor or the like, which is the control center of the configuration terminal device of the table, and connects the various parts of the configuration terminal device of the entire table with various interfaces and lines.
The memory may be used to store the computer programs and/or modules, and the processor may implement various functions of the configuration terminal device of the table by running or executing the computer programs and/or modules stored in the memory and calling the data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
Wherein, the module/unit integrated by the configuration terminal device of the table can be stored in a computer readable storage medium if it is realized in the form of software functional unit and sold or used as an independent product. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method embodiments may be implemented. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
It should be noted that the above-described device embodiments are merely illustrative, where the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. In addition, in the drawings of the embodiment of the apparatus provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, and may be specifically implemented as one or more communication buses or signal lines. One of ordinary skill in the art can understand and implement it without inventive effort.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention.
Claims (8)
1. A method of configuring a table, comprising:
acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information;
comparing the table name of the data table with a database, and verifying whether the data table exists or not;
when the data table exists, updating the column data of the database based on the column information, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter;
when the data table does not exist, the data table is created in the database, a corresponding table SQL file is generated, and when the table type of the created data table is configured to be an auxiliary table, a foreign key is established for a main table associated with the created data table.
2. The table configuring method according to claim 1, wherein, when the data table exists, the column data of the database is updated based on the column information, and a corresponding column SQL file is generated, specifically including:
when the data table exists, inquiring column data corresponding to the data table from the database according to the table name;
comparing the column information with the column data of the database according to the column name in the column information, and judging whether the column information exists or not; if not, adding and storing the column information, and generating a corresponding newly added column SQL file; if so, comparing the column information with the column of the column data, and updating the column data according to a comparison result; wherein the column SQL file comprises the newly added column SQL file.
3. The method of claim 2, wherein the comparing the column length of the column information with the column length of the column data and updating the column length according to the comparison result specifically comprises:
when the column length of the column data is larger than that of the column information, deleting the column data and generating a corresponding deleted column SQL file;
when the column length of the column data is not greater than the column length of the column information, modifying the column data according to the column information, and generating a corresponding modified column SQL file; the column SQL file also comprises the deleted column SQL file and the modified column SQL file.
4. The table configuring method of claim 3, wherein the establishing an index when the updated column data configuration is unique in parameter comprises:
judging whether the newly added column data or the modified column data are configured to be unique parameters; if so, establishing an index corresponding to the updated column data, and further executing the column SQL file; and if not, executing the column SQL file.
5. The table configuring method according to claim 1, wherein when the table type of the created data table is configured as an attached table, the establishing of the foreign key with the primary table associated with the created data table specifically includes:
judging whether the table type of the created data table is configured as an auxiliary table or not; if yes, inquiring a related main table through the parameters of the created data table, establishing an external key with the main table, and further executing the table SQL file; and if not, executing the table SQL file.
6. An apparatus for configuring a watch, comprising:
the data table information acquisition module is used for acquiring basic information of a pre-established data table; the basic information comprises a table name, a table type and column information;
the verification module is used for comparing the table name of the data table with a database and verifying whether the data table exists or not;
the data table existence module is used for updating the column data of the database based on the column information when the data table exists, generating a corresponding column SQL file, and establishing an index when the updated column data is configured to be unique in parameter;
and the data table non-existence module is used for creating the data table in the database when the data table does not exist, generating a corresponding table SQL file, and establishing a foreign key with the main table associated with the created data table when the table type of the created data table is configured as an auxiliary table.
7. A configuration terminal device of a table, comprising a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, the processor implementing a configuration method of a table according to any one of claims 1 to 5 when executing the computer program.
8. A computer-readable storage medium, comprising a stored computer program, wherein the computer program, when executed, controls an apparatus in which the computer-readable storage medium is located to perform a method of configuring a table according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010192645.5A CN111324614B (en) | 2020-03-18 | 2020-03-18 | Table configuration method and device, terminal equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010192645.5A CN111324614B (en) | 2020-03-18 | 2020-03-18 | Table configuration method and device, terminal equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111324614A true CN111324614A (en) | 2020-06-23 |
| CN111324614B CN111324614B (en) | 2023-07-28 |
Family
ID=71173345
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010192645.5A Active CN111324614B (en) | 2020-03-18 | 2020-03-18 | Table configuration method and device, terminal equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111324614B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112559528A (en) * | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Engine steady-state data mining and statistical method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110222117A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
| CN110347693A (en) * | 2019-07-11 | 2019-10-18 | 招商局金融科技有限公司 | Method of data synchronization, device and storage medium |
| CN110347747A (en) * | 2019-06-14 | 2019-10-18 | 平安科技（深圳）有限公司 | Database data synchronic method, system, computer equipment and storage medium |
-
2020
- 2020-03-18 CN CN202010192645.5A patent/CN111324614B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110222117A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
| CN110347747A (en) * | 2019-06-14 | 2019-10-18 | 平安科技（深圳）有限公司 | Database data synchronic method, system, computer equipment and storage medium |
| CN110347693A (en) * | 2019-07-11 | 2019-10-18 | 招商局金融科技有限公司 | Method of data synchronization, device and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112559528A (en) * | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Engine steady-state data mining and statistical method and device |
| CN112559528B (en) * | 2020-12-15 | 2024-05-10 | 北京动力机械研究所 | Engine steady state data mining and statistics method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111324614B (en) | 2023-07-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| CN110704398B (en) | Database migration method and device from MySQL to Oracle and computer equipment | |
| CN109542907B (en) | Database cache construction method and device, computer equipment and storage medium | |
| CN110795455A (en) | Dependency relationship analysis method, electronic device, computer device and readable storage medium | |
| CN107220376B (en) | Data query method and device | |
| CN111522574B (en) | Differential packet generation method and related equipment | |
| CN110795431B (en) | Environment monitoring data processing method, device, equipment and storage medium | |
| CN111966747A (en) | Data synchronization method, system, terminal device and storage medium | |
| WO2018076971A1 (en) | Xml data manipulation method and apparatus | |
| CN111445319A (en) | Voucher generation method and device, computer equipment and storage medium | |
| CN103678396A (en) | Data backup method and device based on data models | |
| CN111324614B (en) | Table configuration method and device, terminal equipment and storage medium | |
| CN112988701A (en) | Database management method, device, system and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN113434489B (en) | Real-time database online capacity expansion method, system, equipment and storage medium | |
| CN115543936A (en) | Method, device and equipment for constructing model files in batches and storage medium | |
| CN113741864B (en) | Automatic semantic service interface design method and system based on natural language processing | |
| US10042957B2 (en) | Devices and methods for implementing dynamic collaborative workflow systems | |
| CN115757174A (en) | Database difference detection method and device | |
| CN109284278B (en) | Calculation logic migration method based on data analysis technology and terminal equipment | |
| CN110334098A (en) | A kind of database combining method and system based on script | |
| CN114510534B (en) | Data synchronization method, device, equipment and storage medium | |
| TWI816875B (en) | Data synchronous query method, device, computer device and storage medium | |
| US20190370259A1 (en) | Devices and methods for implementing dynamic collaborative workflow systems | |
| CN112199428B (en) | Application management system, method and terminal equipment of functional data block |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |