CN113220691A - Database table creating method and device for database table, and electronic equipment - Google Patents
Database table creating method and device for database table, and electronic equipment Download PDFInfo
- Publication number
- CN113220691A CN113220691A CN202110602828.4A CN202110602828A CN113220691A CN 113220691 A CN113220691 A CN 113220691A CN 202110602828 A CN202110602828 A CN 202110602828A CN 113220691 A CN113220691 A CN 113220691A
- Authority
- CN
- China
- Prior art keywords
- library
- identification
- name
- identifier
- creating
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000008859 change Effects 0.000 claims description 25
- 230000004048 modification Effects 0.000 claims description 13
- 238000012986 modification Methods 0.000 claims description 13
- 238000012217 deletion Methods 0.000 claims description 11
- 230000037430 deletion Effects 0.000 claims description 11
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000004044 response Effects 0.000 claims description 8
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000000638 solvent extraction Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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
- 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
- G06F16/2358—Change logging, detection, and notification
-
- 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)
- Stored Programmes (AREA)
Abstract
The invention discloses a database table creating method and a database table creating device of a database and electronic equipment. The method for creating the library table comprises the following steps: receiving a service table building request; responding to the service table building request, and acquiring a database identifier of a target database and a table identifier of each data table contained in the target database; configuring an identification template based on the library identification and the table identification; and creating a new base table corresponding to the business table building request based on the identification template. The invention solves the technical problems that the efficiency is lower and the use interest of the user is influenced when a new base table is manually created in the related technology.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a database table creating method and a database table creating device for a database and electronic equipment.
Background
In the related art, many databases of IT systems now adopt a mechanism of time-based database partitioning or table partitioning, for example: a database: db _ tradeinfo _2021 (tradeinfo library used by 2021); data table: tbl _ payment _2021_01 (payment table used in 1 month 2021).
The above-described library tables have significant time stamps and need to be created before use. For example, database db _ tradeinfo _2021 needs to be created before 2021 and data table tbl _ payload _2021_01 needs to be created before 1 month of 2021. If these library tables are not created before the required point in time, the IT system will fail severely because part of the library tables are missing.
Currently, when a database or a data table is created, manual memory is mostly used, and a new base table is created in time, and the creation mode of the base table has a plurality of disadvantages: 1. the creation of the base table mostly depends on the memory of people, and certain possibility is left out; 2. after a new base table is created manually, differences between the new base table and an original base table are easily found when the new base table is actually used (possible reasons include that SQL statements of base building and table building during creation have problems, or the original base table is changed and is not synchronized into the new table after creation); 3. the new base table is created through manual memory, the efficiency is low, a great deal of energy of workers is consumed, and the use interest of a client is influenced.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a database table creating method, a database table creating device and electronic equipment, which are used for at least solving the technical problems that the efficiency is low and the use interest of a user is influenced when a new database table is created manually in the related technology.
According to an aspect of an embodiment of the present invention, there is provided a method for creating a library table of a database, including: receiving a service table building request; responding to the service table building request, and acquiring a library identifier of a target database and a table identifier of each data table contained in the target database; configuring an identification template based on the library identification and the table identification; and creating a new base table corresponding to the service table building request based on the identification template.
Optionally, the step of configuring an identification template based on the library identification and the table identification includes: acquiring a paradigm identifier, wherein the paradigm identifier is used for indicating a table name of each data table; determining a name paradigm corresponding to each of the table identifiers; establishing an incidence relation between the name paradigm and a data table corresponding to the table identification; configuring a base table name paradigm based on the incidence relation and the paradigm identifier; and representing the identification template in the base table name paradigm.
Optionally, after configuring an identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name modification instruction; and responding to the name modification instruction to modify the base table name paradigm.
Optionally, after configuring an identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name deletion instruction; and responding to the name deletion instruction, and deleting the base table name paradigm.
Optionally, after configuring an identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name release instruction; and responding to the name removing instruction, and removing the incidence relation between the data table corresponding to the table identification and the base table name paradigm.
Optionally, the step of creating a new base table corresponding to the service table creation request based on the identification template includes: setting a creation time point; and when the current time reaches the creation time point, creating a new base table corresponding to the service table creation request based on the identification template.
Optionally, the method for creating a library table further includes: monitoring table data change parameters of a historical data table; copying the table data change parameters to the new library table.
Optionally, after monitoring the table data change parameters of the historical data table, the method for creating the base table further includes: judging whether the new base table is created completely; and if the new base table is not created, stopping copying the table data change parameters to the new base table.
According to another aspect of the embodiments of the present invention, there is also provided a database table creating apparatus for a database, including: a receiving unit, configured to receive a service table establishment request; an obtaining unit, configured to obtain, in response to the service table building request, a base identifier of a target database and a table identifier of each data table included in the target database; a configuration unit configured to configure an identifier template based on the library identifier and the table identifier; and the creating unit is used for creating a new base table corresponding to the service table building request based on the identification template.
Optionally, the configuration unit includes: the device comprises a first obtaining module, a second obtaining module and a third obtaining module, wherein the first obtaining module is used for obtaining a normal form identifier, and the normal form identifier is used for indicating the table name of each data table; a first determining module, configured to determine a name paradigm corresponding to each table identifier; the first establishing module is used for establishing the association relationship between the name paradigm and the data table corresponding to the table identification; a first configuration module, configured to configure a base table name paradigm based on the incidence relation and the paradigm identifier; and the first representation module is used for representing the identification template in the form of the name of the library table.
Optionally, the library table creating apparatus further includes: a first receiving module, configured to receive a name modification instruction after configuring an identifier template based on the library identifier and the table identifier; and the first response module is used for responding to the name modification instruction and modifying the base table name paradigm.
Optionally, the library table creating apparatus further includes: a second receiving module, configured to receive a name deletion instruction after configuring an identifier template based on the library identifier and the table identifier; and the second response module is used for responding to the name deletion instruction and deleting the library table name paradigm.
Optionally, the library table creating apparatus further includes: a third receiving module, configured to receive a name resolution instruction after configuring an identifier template based on the library identifier and the table identifier; and the third response module is used for responding to the name release instruction and releasing the association relation between the data table corresponding to the table identifier and the base table name paradigm.
Optionally, the creating unit includes: the first setting module is used for setting a creation time point; and the creating module is used for creating a new base table corresponding to the service table creating request based on the identification template when the current time reaches the creating time point.
Optionally, the library table creating apparatus further includes: the monitoring module is used for monitoring table data change parameters of the historical data table; and the copying module is used for copying the table data change parameters into the new table.
Optionally, the library table creating apparatus further includes: the judging module is used for judging whether the new base table is established or not after the table data change parameters of the historical data table are monitored; and the stopping module is used for stopping copying the table data change parameters to the new base table when the new base table is not created.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the database table creation method of the database of any of the above via execution of the executable instructions.
In the embodiment of the invention, a business table building request is received firstly, the business table building request is responded, the library identification of a target database and the table identification of each data table contained in the target database are obtained, an identification template is configured based on the library identification and the table identification, and a new table corresponding to the business table building request is created based on the identification template. In the embodiment, a new base table can be automatically created by using the configured identification template, so that table omission is avoided, and base table creation efficiency is improved, thereby solving the technical problems that efficiency is low and user interest is influenced when a new base table is manually created in the related art.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow chart of an alternative database table creation method according to an embodiment of the present invention;
fig. 2 is a schematic diagram of an alternative database table creation apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, 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.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example one
The embodiment can be applied to various IT systems/control software using databases or data tables, can automatically create the databases and data tables to be used in the future under a database-dividing and table-dividing mechanism (adopting a mechanism dividing databases or tables according to time), maintain the long-term and stable operation of the IT system, and avoid major problems caused by forgetting to create a new base table.
In accordance with an embodiment of the present invention, there is provided an embodiment of a method for creating a database table of a database, it being noted that the steps illustrated in the flowchart of the drawings may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than that presented herein.
Fig. 1 is a flowchart of an alternative database table creation method according to an embodiment of the present invention, as shown in fig. 1, the method includes the following steps:
step S102, receiving a service table building request;
step S104, responding to the service table building request, and acquiring the database identifier of the target database and the table identifier of each data table contained in the target database;
step S106, configuring an identification template based on the library identification and the table identification;
and step S108, based on the identification template, creating a new base table corresponding to the service table building request.
Through the steps, the service table building request can be received firstly, the service table building request is responded, the base identification of the target database and the table identification of each data table contained in the target database are obtained, the identification template is configured based on the base identification and the table identification, and the new table corresponding to the service table building request is created based on the identification template. In the embodiment, a new base table can be automatically created by using the configured identification template, so that table omission is avoided, and base table creation efficiency is improved, thereby solving the technical problems that efficiency is low and user interest is influenced when a new base table is manually created in the related art.
The following describes embodiments of the present invention in detail with reference to the above-described respective implementation steps.
Step S102, receiving a service table building request.
The service form establishing request may refer to request information for determining that a new database or a new data form needs to be created in time when a plurality of time points or time periods come according to a certain service scenario (for example, a new goods in a shopping mall and a personnel flow scenario).
Step S104, responding to the service table building request, and acquiring the database identifier of the target database and the table identifier of each data table contained in the target database.
The library identification may include, but is not limited to: library names, library IDs, library addresses, and library pointers, which are schematically illustrated in the embodiments of the present invention; table identifications may include, but are not limited to: table name, table ID, table address, table pointer, embodiments of the present invention are schematically illustrated with table names.
When configuring the name paradigm of the database table or the identification template of the new database table, the name paradigm is configured through the names of the database and the data table, the names of the database and the data table contain time formats, the time formats are replaced, and the replacement paradigm can be shown in the following table 1:
TABLE 1 TABLE NAME MODEL COMPRISING TIME FORMAT
In an embodiment of the present invention, a parenthesis [ ] may be set as the identifier of the paradigm, and if the parenthesis is already contained in the library table name, another pair of symbols may be specified as the identifier, such as { }, ####.
Step S106, configuring an identification template based on the library identification and the table identification.
Optionally, the step of configuring the identification template based on the library identification and the table identification includes: acquiring a paradigm identifier, wherein the paradigm identifier is used for indicating the table name of each data table; determining a name paradigm corresponding to each table identifier; establishing an association relation between a name paradigm and a data table corresponding to the table identification; configuring a base table name paradigm based on the incidence relation and the paradigm identifier; and characterizing the identification template in a base table name paradigm.
The above-mentioned paradigm identifier may indicate a table name of the data table, or may indicate a library name of the database, subject to the object of the creation, for example, if a new database is to be created, a paradigm identifier corresponding to the library name is obtained, and if a new data table is to be created, a paradigm identifier corresponding to the table name is obtained.
In this embodiment, a new data table is set up as an example for schematic description, and the process steps for setting up a new data table are also applicable to the process for setting up a new database.
When the name paradigm and the association relationship between the data tables corresponding to the table identifiers are established, each paradigm (table name paradigm or library name paradigm) can be bound to a specific database table, for example, under the condition of monthly divisions, a plurality of monthly tables exist, and the name paradigm of the monthly tables is bound to a specific monthly table, so that subsequent creation and monitoring operations are facilitated.
Optionally, after configuring the identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name modification instruction; and responding to the name modification instruction to modify the base table name paradigm.
In this embodiment, the name paradigm may be modified. The modification has no effect on the created and used base tables. If a library table has been created but not yet used, the present system will create a new library table according to the latest paradigm definition.
Alternatively, after configuring the identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name deletion instruction; and responding to the name deletion instruction, and deleting the base table name paradigm.
In this embodiment, the name paradigm may be deleted. Deletion has no effect on the created base tables.
Optionally, after configuring the identifier template based on the library identifier and the table identifier, the method for creating a library table further includes: receiving a name release instruction; and responding to the name removing instruction, and removing the association relation between the data table corresponding to the table identification and the base table name paradigm.
In this embodiment, the name paradigm bound to a certain data table can be solved.
And step S108, based on the identification template, creating a new base table corresponding to the service table building request.
The new database table may refer to a new database and/or a new data table.
As an optional implementation manner of this embodiment, the step of creating a new table corresponding to the service table creation request based on the identification template includes: setting a creation time point; and when the current time reaches the creation time point, creating a new base table corresponding to the service table creation request based on the identification template.
In this embodiment, the time point required to be created in advance may be configured, and a time point required to be created in advance may be configured for a batch or a name paradigm, for example, one month in advance, 10 days in advance, and so on. The time accuracy is on the order of minutes.
In addition, in the embodiment, before the time point arrives, a new library table is created, and the timed task is executed regularly, for example, once every minute. When a base table needing to be created in advance is found, the creation is triggered. The creation order set by the present embodiment is: firstly, building a library, and then building a table. According to the embodiment of the invention, new base tables can be created one by acquiring the structure of the original base table.
Optionally, the method for creating a library table further includes: monitoring table data change parameters of a historical data table; the table data change parameters are copied to the new table.
The embodiment of the invention can monitor the changes of the original base table after the new base table is created but before the new base table is used, and copy the changes into the new base table which is not opened for use, thereby being capable of automatically synchronizing the changes of the base table. For example, a field comment is added to the Tbl _ tradeinfo _2021_01 table, there are 12 new monthly tables in 2022, Tbl _ tradeinfo _2022_01, etc., and if these tables have already been created, this change is synchronized to the new table, i.e., a field comment is also added.
Alternatively, after monitoring the table data change parameters of the historical data table, the method for creating the base table further includes: judging whether the creation of the new base table is completed; and if the new base table is not created, stopping copying the table data change parameters into the new base table.
In other words, in the embodiment of the present invention, for the condition that the new base table is not created, the table data change parameter of the historical data table does not need to be monitored, and the table data change parameter is stopped from being copied to the new base table.
Optionally, for the condition that the new base table is created and used, the embodiment of the present invention does not need to monitor the table data change parameter of the historical data table, and stops copying the table data change parameter to the new base table.
In an optional implementation manner of the present invention, after the new library table is created, the new and old library tables may be compared, that is, after the new library table is created, the new library table and the original library table are compared at regular time, and a difference is found in time.
In another optional implementation mode, the embodiment of the invention can also perform real-time alarm, and alarm receiving personnel and alarm modes are configured, wherein the alarm receiving personnel and the alarm modes comprise mails, short messages, telephones and the like. And if the creation exception occurs in the process of creating the new base table, notifying an operator in an alarm mode.
By the embodiment, automatic creation of the new base table can be realized, omission is avoided, and the new base tables with different paradigms are created through various time formats.
The invention is described below in connection with an alternative embodiment.
Example two
The present embodiment provides a database table creating apparatus for a database, where the database table creating apparatus includes a plurality of implementation units, and each implementation unit corresponds to each implementation step in the first embodiment.
Fig. 2 is a schematic diagram of an alternative database table creation apparatus of a database according to an embodiment of the present invention, and as shown in fig. 2, the database table creation apparatus may include: a receiving unit 21, an obtaining unit 23, a configuring unit 25, a creating unit 27, wherein,
a receiving unit 21, configured to receive a service table creation request;
an obtaining unit 23, configured to respond to the service table building request, and obtain a library identifier of the target database and a table identifier of each data table included in the target database;
a configuration unit 25 configured to configure an identification template based on the library identification and the table identification;
and the creating unit 27 is configured to create a new table corresponding to the service table creation request based on the identification template.
The database table creating apparatus of the database may receive the service table creating request through the receiving unit 21, respond to the service table creating request through the obtaining unit 23, obtain the library identifier of the target database and the table identifiers of the data tables included in the target database, configure the identifier template based on the library identifier and the table identifiers through the configuration unit 25, and create a new database table corresponding to the service table creating request based on the identifier template through the creating unit 27. In the embodiment, a new base table can be automatically created by using the configured identification template, so that table omission is avoided, and base table creation efficiency is improved, thereby solving the technical problems that efficiency is low and user interest is influenced when a new base table is manually created in the related art.
Optionally, the configuration unit includes: the device comprises a first obtaining module, a second obtaining module and a third obtaining module, wherein the first obtaining module is used for obtaining a paradigm identifier, and the paradigm identifier is used for indicating the table name of each data table; a first determining module for determining a name paradigm corresponding to each table identifier; the first establishing module is used for establishing a name paradigm and an incidence relation between data tables corresponding to the table identifications; the first configuration module is used for configuring a base table name paradigm based on the incidence relation and the paradigm identifier; and the first representation module is used for representing the identification template in a base table name paradigm.
Optionally, the library table creating apparatus further includes: a first receiving module for receiving a name modification instruction after configuring an identification template based on the library identification and the table identification; and the first response module is used for responding to the name modification instruction and modifying the base table name paradigm.
Optionally, the library table creating apparatus further includes: a second receiving module, configured to receive a name deletion instruction after configuring the identification template based on the library identification and the table identification; and the second response module is used for responding the name deletion instruction and deleting the library table name paradigm.
Optionally, the library table creating apparatus further includes: a third receiving module, configured to receive a name resolution instruction after configuring the identification template based on the library identification and the table identification; and the third response module is used for responding to the name release instruction and releasing the association relation between the data table corresponding to the table identifier and the base table name paradigm.
Optionally, the creating unit includes: the first setting module is used for setting a creation time point; and the creating module is used for creating a new base table corresponding to the service table creating request based on the identification template when the current time reaches the creating time point.
Optionally, the library table creating apparatus further includes: the monitoring module is used for monitoring table data change parameters of the historical data table; and the copying module is used for copying the table data change parameters into the new table.
Optionally, the library table creating apparatus further includes: the judging module is used for judging whether the creation of the new database table is finished or not after the table data change parameters of the historical data table are monitored; and the stopping module is used for stopping copying the table data change parameters to the new base table when the new base table is not created.
The above-mentioned library table creation apparatus may further include a processor and a memory, and the above-mentioned receiving unit 21, the obtaining unit 23, the configuration unit 25, the creation unit 27, and the like are all stored in the memory as program units, and the processor executes the above-mentioned program units stored in the memory to implement corresponding functions.
The processor comprises a kernel, and the kernel calls a corresponding program unit from the memory. The kernel can set one or more, and a new library table corresponding to the business table building request is created based on the identification template by adjusting the kernel parameters.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions for the processor; wherein the processor is configured to perform a method of database table creation of a database of any of the above via execution of the executable instructions.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device: receiving a service table building request; responding to the service table building request, and acquiring a database identifier of a target database and a table identifier of each data table contained in the target database; configuring an identification template based on the library identification and the table identification; and creating a new base table corresponding to the business table building request based on the identification template.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A method of creating a table of a database, comprising:
receiving a service table building request;
responding to the service table building request, and acquiring a library identifier of a target database and a table identifier of each data table contained in the target database;
configuring an identification template based on the library identification and the table identification;
and creating a new base table corresponding to the service table building request based on the identification template.
2. The library table creation method of claim 1, wherein the step of configuring an identity template based on the library identity and the table identity comprises:
acquiring a paradigm identifier, wherein the paradigm identifier is used for indicating a table name of each data table;
determining a name paradigm corresponding to each of the table identifiers;
establishing an incidence relation between the name paradigm and a data table corresponding to the table identification;
configuring a base table name paradigm based on the incidence relation and the paradigm identifier;
and representing the identification template in the base table name paradigm.
3. The library table creation method of claim 2, wherein after configuring an identification template based on the library identification and the table identification, the library table creation method further comprises:
receiving a name modification instruction;
and responding to the name modification instruction to modify the base table name paradigm.
4. The library table creation method of claim 2, wherein after configuring an identification template based on the library identification and the table identification, the library table creation method further comprises:
receiving a name deletion instruction;
and responding to the name deletion instruction, and deleting the base table name paradigm.
5. The library table creation method of claim 2, wherein after configuring an identification template based on the library identification and the table identification, the library table creation method further comprises:
receiving a name release instruction;
and responding to the name removing instruction, and removing the incidence relation between the data table corresponding to the table identification and the base table name paradigm.
6. The method of creating a library table according to claim 1, wherein the step of creating a new library table corresponding to the service table creation request based on the identification template comprises:
setting a creation time point;
and when the current time reaches the creation time point, creating a new base table corresponding to the service table creation request based on the identification template.
7. The library table creation method of claim 1, further comprising:
monitoring table data change parameters of a historical data table;
copying the table data change parameters to the new library table.
8. The library table creation method of claim 7, wherein after monitoring the table data change parameters of the historical data table, the library table creation method further comprises:
judging whether the new base table is created completely;
and if the new base table is not created, stopping copying the table data change parameters to the new base table.
9. An apparatus for creating a base table of a database, comprising:
a receiving unit, configured to receive a service table establishment request;
an obtaining unit, configured to obtain, in response to the service table building request, a base identifier of a target database and a table identifier of each data table included in the target database;
a configuration unit configured to configure an identifier template based on the library identifier and the table identifier;
and the creating unit is used for creating a new base table corresponding to the service table building request based on the identification template.
10. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the database table creation method of the database of any of claims 1-8 via execution of the executable instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110602828.4A CN113220691B (en) | 2021-05-31 | 2021-05-31 | Database table creation method, database table creation device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110602828.4A CN113220691B (en) | 2021-05-31 | 2021-05-31 | Database table creation method, database table creation device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113220691A true CN113220691A (en) | 2021-08-06 |
| CN113220691B CN113220691B (en) | 2024-02-06 |
Family
ID=77081790
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110602828.4A Active CN113220691B (en) | 2021-05-31 | 2021-05-31 | Database table creation method, database table creation device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113220691B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117632963A (en) * | 2023-11-29 | 2024-03-01 | 数翊科技(北京)有限公司 | Method and system for building table and electronic equipment |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714097A (en) * | 2012-10-09 | 2014-04-09 | 阿里巴巴集团控股有限公司 | Method and device for accessing database |
| CN103810219A (en) * | 2012-11-15 | 2014-05-21 | 中国移动通信集团公司 | Line storage database-based data processing method and device |
| CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
| CN109308296A (en) * | 2018-09-30 | 2019-02-05 | 税友软件集团股份有限公司 | A kind of generation method, device and the computer readable storage medium of business datum table |
| CN109710609A (en) * | 2018-12-14 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Generate the method and device of tables of data mark |
| CN110109894A (en) * | 2019-03-22 | 2019-08-09 | 新奥特（北京）视频技术有限公司 | Implementation method, device, storage medium and the equipment of non-relational database |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110780860A (en) * | 2019-09-10 | 2020-02-11 | 中国平安财产保险股份有限公司 | Generation method and device of table building script, computer equipment and storage medium |
| CN110909003A (en) * | 2019-11-25 | 2020-03-24 | 车智互联（北京）科技有限公司 | Method for creating data table and computing equipment |
| CN110928869A (en) * | 2018-09-04 | 2020-03-27 | 深圳市超脑云信息技术有限公司 | Data warehouse table self-growing method, terminal and medium |
| CN112395293A (en) * | 2020-11-27 | 2021-02-23 | 浙江诺诺网络科技有限公司 | Warehouse and table dividing method, warehouse and table dividing device, warehouse and table dividing equipment and storage medium |
-
2021
- 2021-05-31 CN CN202110602828.4A patent/CN113220691B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714097A (en) * | 2012-10-09 | 2014-04-09 | 阿里巴巴集团控股有限公司 | Method and device for accessing database |
| CN103810219A (en) * | 2012-11-15 | 2014-05-21 | 中国移动通信集团公司 | Line storage database-based data processing method and device |
| CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
| CN110928869A (en) * | 2018-09-04 | 2020-03-27 | 深圳市超脑云信息技术有限公司 | Data warehouse table self-growing method, terminal and medium |
| CN109308296A (en) * | 2018-09-30 | 2019-02-05 | 税友软件集团股份有限公司 | A kind of generation method, device and the computer readable storage medium of business datum table |
| CN109710609A (en) * | 2018-12-14 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Generate the method and device of tables of data mark |
| CN110109894A (en) * | 2019-03-22 | 2019-08-09 | 新奥特（北京）视频技术有限公司 | Implementation method, device, storage medium and the equipment of non-relational database |
| CN110309145A (en) * | 2019-04-15 | 2019-10-08 | 中国银行股份有限公司 | A kind of tables of data method of adjustment, tables of data creation method and device |
| CN110780860A (en) * | 2019-09-10 | 2020-02-11 | 中国平安财产保险股份有限公司 | Generation method and device of table building script, computer equipment and storage medium |
| CN110909003A (en) * | 2019-11-25 | 2020-03-24 | 车智互联（北京）科技有限公司 | Method for creating data table and computing equipment |
| CN112395293A (en) * | 2020-11-27 | 2021-02-23 | 浙江诺诺网络科技有限公司 | Warehouse and table dividing method, warehouse and table dividing device, warehouse and table dividing equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 周荣, 丁金华, 李明颖, 周茂军: "在LabVIEW中利用ADO技术动态创建数据库", 大连轻工业学院学报, no. 03, pages 54 - 57 * |
| 鞠儒生;乔海泉;陈少卿;黄柯棣;: "HLA中基于OMT文件创建数据库关系表的方法", 计算机仿真, no. 05, pages 124 - 127 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117632963A (en) * | 2023-11-29 | 2024-03-01 | 数翊科技(北京)有限公司 | Method and system for building table and electronic equipment |
| CN117632963B (en) * | 2023-11-29 | 2024-09-17 | 数翊科技(北京)有限公司 | Method and system for building table and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113220691B (en) | 2024-02-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228814B (en) | Data synchronization method and device | |
| US20140156598A1 (en) | Replication control using eventually consistent meta-data | |
| CN111355802B (en) | Information pushing method and device | |
| CN112905323B (en) | Data processing method, device, electronic equipment and storage medium | |
| CN111371645B (en) | Method, system, computer equipment and storage medium for testing service connectivity | |
| CN113220691A (en) | Database table creating method and device for database table, and electronic equipment | |
| CN107562568B (en) | File backup method and device | |
| CN113839991A (en) | Method and device for confirming equipment information, storage medium and electronic device | |
| CN110795674B (en) | Configuration updating method and device | |
| JP2005099967A (en) | Preventive maintenance method | |
| CN108595924B (en) | Business authority management method and device, computer equipment and storage medium | |
| CN112631808B (en) | Data synchronization method, device, electronic equipment and storage medium | |
| CN114254881A (en) | Data processing method and device, electronic equipment, readable storage medium and product | |
| CN110221952B (en) | Service data processing method and device and service data processing system | |
| CN112579189A (en) | Configuration file updating method and device | |
| CN111459737A (en) | Problem positioning method and device, computer equipment and storage medium | |
| CN113127056B (en) | Information processing method, device, equipment and readable storage medium | |
| CN108008966B (en) | Resource updating method and system | |
| CN112130924B (en) | Application system data analysis method and device | |
| CN117453558B (en) | Software test information processing method | |
| CN115576961A (en) | Embedded point synchronous change method, device, equipment and storage medium | |
| CN108229917B (en) | Project data analysis method and system | |
| CN115987785A (en) | Firewall data synchronization method and device and electronic equipment | |
| CN116451952A (en) | Device information synchronous processing method and device based on environment construction | |
| CN118642926A (en) | Update prompting method and device of ERP system, 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |