CN113220691B - Database table creation method, database table creation device and electronic equipment - Google Patents
Database table creation method, database table creation device and electronic equipment Download PDFInfo
- Publication number
- CN113220691B CN113220691B CN202110602828.4A CN202110602828A CN113220691B CN 113220691 B CN113220691 B CN 113220691B CN 202110602828 A CN202110602828 A CN 202110602828A CN 113220691 B CN113220691 B CN 113220691B
- Authority
- CN
- China
- Prior art keywords
- library
- identification
- name
- paradigm
- identifier
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 230000008859 change Effects 0.000 claims description 26
- 230000004044 response Effects 0.000 claims description 15
- 238000012544 monitoring process Methods 0.000 claims description 13
- 230000004048 modification Effects 0.000 claims description 12
- 238000012986 modification Methods 0.000 claims description 12
- 238000012217 deletion Methods 0.000 claims description 5
- 230000037430 deletion Effects 0.000 claims description 5
- 238000012512 characterization method Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 description 5
- 230000007246 mechanism Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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 creation method, a database table creation device and electronic equipment. The library table creating method comprises the following steps: receiving a service list establishment request; responding to a service list establishment request, and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database; configuring an identification template based on the library identification and the table identification; based on the identification template, a new library table corresponding to the business table establishment request is created. The method and the device solve the technical problems that the efficiency is low and the use interest of the user is influenced when a new library table is manually created in the related technology.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for creating a database table, and an electronic device.
Background
In the related art, databases of many IT systems now adopt a mechanism of time division of the databases or the tables, for example: database: db_tradeinfo_2021 (tradeinfo library used by 2021); data table: tbl_party_2021_01 (a party table used in month 1 of 2021).
The library table has obvious time marks and needs to be created before use. For example, the database db_tradeinfo_2021 needs to be created before 2021, and the data table tbl_parameter_2021_01 needs to be created before 2021, 1. If these library tables are not created before the required point in time, the IT system will fail severely due to partial library table missing.
Currently, when creating a database or a data table, a new library table is created in time by manual memory, and the creation mode of the library table has a plurality of defects: 1. the creation of the library table mostly depends on the memory of people, and a certain possibility is omitted; 2. after the new library table is manually created, the difference from the original library table is easily found when the new library table is actually used (possible reasons include that SQL sentences for library and table building are problematic when the new library table is created, or the original library table is changed after the new library table is created and is not synchronized into the new table); 3. the new library table is created through the manual memory, so that the efficiency is low, a great deal of effort of staff is consumed, and the use interests of customers are influenced.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the invention provides a database table creation method, a database table creation device and electronic equipment, which at least solve 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 database table creation method including: receiving a service list establishment request; responding to the service list establishment request, and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database; configuring an identification template based on the library identification and the table identification; and creating a new library table corresponding to the service table creation request based on the identification template.
Optionally, the step of configuring an identification template based on the library identification and the table identification comprises: obtaining a paradigm identifier, wherein the paradigm identifier is used for indicating the table names of all data tables; determining a name paradigm corresponding to each of the table identifications; establishing an association relationship between the name paradigm and a data table corresponding to the table identifier; configuring a library table name paradigm based on the association and the paradigm identifier; characterizing the identification template in the library table name paradigm.
Optionally, 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 in response to the name modification instruction, modifying the library table name paradigm.
Optionally, after configuring an identification template based on the library identification and the table identification, the library table creation method further comprises: receiving a name deleting instruction; and deleting the library table name paradigm in response to the name deletion instruction.
Optionally, 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 release instruction, and releasing the association relation between the data table corresponding to the table identifier and the library table name paradigm.
Optionally, based on the identification template, the step of creating a new library table corresponding to the service creation table request includes: setting a creation time point; and when the current time reaches the creation time point, creating a new library table corresponding to the service table creation request based on the identification template.
Optionally, the library table creating method further includes: monitoring table data change parameters of a historical data table; copying the table data change parameters into the new library table.
Optionally, after monitoring the table data change parameter of the history data table, the library table creating method further includes: judging whether the new library table is already established; if the new library table is not completely created, stopping copying the table data change parameters into the new library table.
According to another aspect of the embodiment of the present invention, there is also provided a database table creating apparatus including: the receiving unit is used for receiving the service list establishment request; the acquisition unit is used for responding to the service list establishment request and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database; a configuration unit for configuring an identification template based on the library identification and the table identification; and the creating unit is used for creating a new library table corresponding to the service table creating request based on the identification template.
Optionally, the configuration unit includes: a first obtaining module, configured to obtain a paradigm identifier, where the paradigm identifier is used to indicate a 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 identifier; the first configuration module is used for configuring a library table name normal form based on the association relation and the normal form identifier; and the first characterization module is used for characterizing the identification template in the library table name paradigm.
Optionally, the library table creating device 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 name paradigm of the library table.
Optionally, the library table creating device further includes: a second receiving module, configured to receive a name deletion instruction after configuring an identification template based on the library identification and the table identification; and the second response module is used for responding to the name deleting instruction and deleting the library table name paradigm.
Optionally, the library table creating device further includes: a third receiving module for receiving a name releasing instruction after configuring an 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 relationship between the data table corresponding to the table identifier and the library table name paradigm.
Optionally, the creating unit includes: the first setting module is used for setting a creation time point; and the creation module is used for creating a new library table corresponding to the service table creation request based on the identification template when the current time reaches the creation time point.
Optionally, the library table creating device further includes: the monitoring module is used for monitoring the form data change parameters of the historical data table; and the copying module is used for copying the table data change parameters into the new library table.
Optionally, the library table creating device further includes: the judging module is used for judging whether the new library table is established after monitoring the table data change parameters of the historical data table; and the stopping module is used for stopping copying the table data change parameters to the new library table when the new library table is not completely created.
According to another aspect of the embodiment 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 any of the above via execution of the executable instructions.
In the embodiment of the invention, the method comprises the steps of firstly receiving a service list establishment request, responding to the service list establishment request, obtaining a base identifier of a target database and list identifiers of all data lists contained in the target database, configuring an identifier template based on the base identifier and the list identifiers, and establishing a new base list corresponding to the service list establishment request based on the identifier template. In the embodiment, a new library table can be automatically created by using the configured identification template, so that table omission is avoided, and the library table creation efficiency is improved, thereby solving the technical problems that the efficiency is lower and the use interest of a user is influenced when the new library table is created manually in the related technology.
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 embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
FIG. 1 is a flow chart of an alternative database library table creation method according to an embodiment of the present invention;
fig. 2 is a schematic diagram of an alternative database library table creation apparatus according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise 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 1
The embodiment can be applied to various IT system/control software using databases or data tables, and can automatically create databases and data tables to be used in the future under a database-dividing-table-dividing mechanism (adopting a mechanism for dividing the database or the table in time), maintain the IT system to run stably for a long time and avoid serious problems caused by forgetting to newly build the database table.
According to an embodiment of the present invention, there is provided a database library table creation method embodiment, it being noted that the steps shown in the flowchart of the drawings may be performed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases the steps shown or described may be performed in an order different from that herein.
FIG. 1 is a flow chart of an alternative database library table creation method according to an embodiment of the present invention, as shown in FIG. 1, comprising the steps of:
step S102, receiving a service list establishment request;
step S104, responding to the service list establishment request, and acquiring a list identifier of a target database and list identifiers of all data lists contained in the target database;
step S106, configuring an identification template based on the library identification and the table identification;
step S108, based on the identification template, creating a new library table corresponding to the business table establishment request.
Through the steps, a service list establishment request can be received first, a list identification of a target database and list identifications of all data lists contained in the target database are obtained in response to the service list establishment request, an identification template is configured based on the list identifications and the list identifications, and a new list corresponding to the service list establishment request is created based on the identification template. In the embodiment, a new library table can be automatically created by using the configured identification template, so that table omission is avoided, and the library table creation efficiency is improved, thereby solving the technical problems that the efficiency is lower and the use interest of a user is influenced when the new library table is created manually in the related technology.
Embodiments of the present invention will be described in detail below in conjunction with the foregoing steps.
Step S102, receiving a service list establishment request.
The service list creation request may refer to determining, according to a certain service scenario (for example, a market newly added cargo, a personnel flow scenario), request information that a new database or a new data list needs to be created in time when a plurality of time points or time periods arrive.
Step S104, responding to the service list establishment request, and acquiring the list identification of the target database and the list identification of each data list contained in the target database.
Library identification may include, but is not limited to: library name, library ID, library address, library pointer, the embodiment of the invention is schematically illustrated by library name; table identification may include, but is not limited to: table names, table IDs, table addresses, table pointers, the embodiments of the present invention are schematically illustrated with table names.
When the name paradigm of the database table or the identification template of the new database table is configured, 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 illustrated as the following table 1:
table 1 contains a library table name paradigm for time format
In the embodiment of the present invention, a bracket [ ] may be used as an identifier of a paradigm, and if the library table name already contains a bracket, another pair of symbols may be designated as identifiers, for example { } #.
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: obtaining a paradigm identifier, wherein the paradigm identifier is used for indicating the table names of the data tables; determining a name paradigm corresponding to each table identification; establishing a name normal form and an association relation between data tables corresponding to the table identifiers; configuring a library table name paradigm based on the association and the paradigm identifier; the identification templates are characterized by a library table name paradigm.
The above-mentioned pattern identifier may indicate a table name of the data table or a library name of the database, and the object to be created is, for example, if a new database is to be created, a pattern identifier corresponding to the library name is acquired, and if a new data table is to be created, a pattern identifier corresponding to the table name is acquired.
In this embodiment, the process of creating a new data table is also applicable to the process of creating a new database.
When the name normal form and the association relation between the data tables corresponding to the table identifiers are established, each normal form (the table name normal form or the library name normal form) can be bound to a specific database table, for example, in the case of a month-based table, a plurality of month tables exist, the name normal form of the month table is bound to a specific month table, and subsequent creation and monitoring operations are convenient.
Optionally, after configuring the identification template based on the library identification and the table identification, the library table creating method further comprises: receiving a name modification instruction; and in response to the name modification instruction, modifying the library table name paradigm.
In this embodiment, the name paradigm may be modified. The modification has no effect on the library tables that have been created and used. If a library table is created but not yet used, the present system will create a new library table from the latest paradigm definition.
Alternatively, after configuring the identification template based on the library identification and the table identification, the library table creating method further includes: receiving a name deleting instruction; and deleting the library table name paradigm in response to the name deletion instruction.
In this embodiment, the name paradigm may be deleted. Deletion has no effect on the created library table.
Optionally, after configuring the identification template based on the library identification and the table identification, the library table creating method further comprises: receiving a name release instruction; and responding to the name release instruction, and releasing the association relation between the data table corresponding to the table identifier and the library table name paradigm.
In this embodiment, the name paradigm bound to a certain data table may be solved.
Step S108, based on the identification template, creating a new library table corresponding to the business table establishment request.
The new library 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 library table corresponding to the service creation table request based on the identification template includes: setting a creation time point; when the current time reaches the creation time point, a new library table corresponding to the business table creation request is created based on the identification template.
In this embodiment, a time point that needs to be created in advance may be configured, and a batch or a name paradigm may be configured with a time point that needs to be created in advance, for example, one month in advance, 10 days in advance, or the like. The time accuracy is on the order of minutes.
In addition, in this embodiment, a new library table may be created before the time point arrives, and the timed tasks are performed periodically, for example, once every minute. When a library table is found to be created in advance, the creation is triggered. The creation order set in this embodiment is: firstly, building a library and then building a table. According to the embodiment of the invention, the new library table can be created one by acquiring the structure of the original library table.
Optionally, the library table creating method further includes: monitoring table data change parameters of a historical data table; the table data change parameters are copied into the new library table.
The embodiment of the invention can monitor the changes of the original library table after the new library table is created but before the new library table is used, copy the changes into the new library table which is not started for use, and can automatically synchronize the changes of the library table. For example, tbl_tradeinfo_2021_01 has a new field comment added to the table, 12 sheets are total for the new month table of 2022, tbl_tradeinfo_2022_01, etc., and if these tables have been created, this change is synchronized to the new table, i.e., the field comment is also added.
Alternatively, after monitoring the table data change parameter of the history data table, the library table creating method further includes: judging whether the new library table is already established; if the new library table is not created, stopping copying the table data change parameters to the new library table.
That is, in the embodiment of the present invention, for the case where the new library table has not been created, it is not necessary to monitor the table data change parameter of the history data table, and copy the table data change parameter to the new library table is stopped.
Optionally, in the embodiment of the present invention, for the case where the new library table is created and used, it is not necessary to monitor the table data change parameter of the history data table, and the copying of the table data change parameter into the new library table is stopped.
In an optional implementation manner, the embodiment of the invention can also compare new and old library tables after the new library table is created, namely, the new library table and the original library table are compared at regular time after the new library table is created, so that the difference can be found in time.
In another alternative implementation manner, the embodiment of the invention can also perform real-time alarm, and the alarm receiving personnel and the alarm mode are configured to comprise mail, short message, telephone and the like. If the creation abnormality occurs in the process of creating the new library table, an operator is notified in an alarm mode.
Through the embodiment, the automatic creation of the new library table can be realized, omission is avoided, the new library table with different formats is created through various time formats, and meanwhile, the embodiment of the invention can compare the change parameters of the new library table and the original library table, discover the difference of the new library table and the original library table in time and improve the efficiency of library table creation.
The invention is described below in connection with alternative embodiments.
Example two
The present embodiment provides a library table creation device of a database, which includes a plurality of implementation units, each implementation unit corresponding to each implementation step in the above-described embodiment one.
Fig. 2 is a schematic diagram of an alternative database library table creation apparatus according to an embodiment of the present invention, as shown in fig. 2, the library 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 list establishment request;
an obtaining unit 23, configured to obtain a library identifier of the target database and a table identifier of each data table included in the target database in response to the service table establishment request;
a configuration unit 25 for configuring an identification template based on the library identification and the table identification;
a creating unit 27 for creating a new library table corresponding to the service creation request based on the identification template.
In the database library table creating device, the receiving unit 21 may first receive the service table creating request, the obtaining unit 23 may obtain the library identifier of the target database and the table identifier of each data table included in the target database in response to the service table creating request, the configuring unit 25 may configure the identifier template based on the library identifier and the table identifier, and the creating unit 27 may create a new library table corresponding to the service table creating request based on the identifier template. In the embodiment, a new library table can be automatically created by using the configured identification template, so that table omission is avoided, and the library table creation efficiency is improved, thereby solving the technical problems that the efficiency is lower and the use interest of a user is influenced when the new library table is created manually in the related technology.
Optionally, the configuration unit includes: a first obtaining module, configured to obtain a paradigm identifier, where the paradigm identifier is used to indicate a 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 a name normal form and an association relationship between the data tables corresponding to the table identifiers; the first configuration module is used for configuring a library table name normal form based on the association relation and the normal form identifier; the first characterization module is used for characterizing the identification template in a library table name paradigm.
Optionally, the library table creating device further includes: the first receiving module is used for receiving a name modification instruction after the identification template is configured 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 name paradigm of the library table.
Optionally, the library table creating device further includes: the second receiving module is used for receiving a name deleting instruction after the identification template is configured based on the library identification and the table identification; and the second response module is used for responding to the name deleting instruction and deleting the library table name paradigm.
Optionally, the library table creating device further includes: the third receiving module is used for receiving a name release instruction after the identification template is configured 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 library table name paradigm.
Optionally, the creating unit includes: the first setting module is used for setting a creation time point; and the creation module is used for creating a new library table corresponding to the business table creation request based on the identification template when the current time reaches the creation time point.
Optionally, the library table creating device further includes: the monitoring module is used for monitoring the form data change parameters of the historical data table; and the copying module is used for copying the table data change parameters into the new library table.
Optionally, the library table creating device further includes: the judging module is used for judging whether the new library table is established after monitoring the table data change parameters of the historical data table; and the stopping module is used for stopping copying the table data change parameters to the new library table when the new library table is not completely created.
The library table creating apparatus described above may further include a processor and a memory, the receiving unit 21, the acquiring unit 23, the configuring unit 25, the creating unit 27, and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize the corresponding functions.
The processor includes a kernel, and the kernel fetches a corresponding program unit from the memory. The kernel may set one or more, and create a new library table corresponding to the service creation request 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), which includes at least one memory chip.
According to another aspect of the embodiment 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 any of the above via execution of the executable instructions.
The present application also provides a computer program product adapted to perform, when executed on a data processing device, a program initialized with the method steps of: receiving a service list establishment request; responding to a service list establishment request, and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database; configuring an identification template based on the library identification and the table identification; based on the identification template, a new library table corresponding to the business table establishment request is created.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
In the foregoing embodiments of the present invention, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed technology content may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, for example, may be a logic function division, and may be implemented in another manner, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
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 may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform 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, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.
Claims (9)
1. A database table creation method, comprising:
receiving a service list establishment request;
responding to the service list establishment request, and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database;
configuring an identification template based on the library identification and the table identification, comprising: obtaining a paradigm identifier, wherein the paradigm identifier is used for indicating the table names of all data tables; determining a name paradigm corresponding to each of the table identifications; establishing an association relationship between the name paradigm and a data table corresponding to the table identifier; configuring a library table name paradigm based on the association and the paradigm identifier; characterizing the identification template in the library table name paradigm;
and creating a new library table corresponding to the service table creation request based on the identification template.
2. The library table creation method according to claim 1, 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 in response to the name modification instruction, modifying the library table name paradigm.
3. The library table creation method according to claim 1, 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 deleting instruction;
and deleting the library table name paradigm in response to the name deletion instruction.
4. The library table creation method according to claim 1, 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 release instruction, and releasing the association relation between the data table corresponding to the table identifier and the library table name paradigm.
5. The library table creation method according to claim 1, wherein the step of creating a new library table corresponding to the service creation table 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 library table corresponding to the service table creation request based on the identification template.
6. The library table creation method according to claim 1, wherein the library table creation method further comprises:
monitoring table data change parameters of a historical data table;
copying the table data change parameters into the new library table.
7. The library table creation method according to claim 6, wherein after monitoring the table data change parameter of the history data table, the library table creation method further comprises:
judging whether the new library table is already established;
if the new library table is not completely created, stopping copying the table data change parameters into the new library table.
8. A library table creation apparatus of a database, comprising:
the receiving unit is used for receiving the service list establishment request;
the acquisition unit is used for responding to the service list establishment request and acquiring a base identifier of a target database and list identifiers of all data lists contained in the target database;
a configuration unit for configuring an identification template based on the library identification and the table identification, the configuration unit comprising: a first obtaining module, configured to obtain a paradigm identifier, where the paradigm identifier is used to indicate a 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 identifier; the first configuration module is used for configuring a library table name normal form based on the association relation and the normal form identifier; the first characterization module is used for characterizing the identification template in the library table name paradigm;
and the creating unit is used for creating a new library table corresponding to the service table creating request based on the identification template.
9. 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 any of claims 1 to 7 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 CN113220691A (en) | 2021-08-06 |
| CN113220691B true 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) |
Families Citing this family (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 |
|---|
| HLA中基于OMT文件创建数据库关系表的方法;鞠儒生;乔海泉;陈少卿;黄柯棣;;计算机仿真(第05期);124-127 * |
| 在LabVIEW中利用ADO技术动态创建数据库;周荣, 丁金华, 李明颖, 周茂军;大连轻工业学院学报(第03期);54-57 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113220691A (en) | 2021-08-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI472934B (en) | Method, article, and apparatus for cross-synchronization of data | |
| US8214508B2 (en) | Support apparatus, program, information processing system and support method | |
| US10726042B2 (en) | Replication control using eventually consistent meta-data | |
| US11544052B2 (en) | Tenant declarative deployments with release staggering | |
| CN111190962B (en) | File synchronization method and device and local terminal | |
| CN112905323B (en) | Data processing method, device, electronic equipment and storage medium | |
| US20150081625A1 (en) | Service polling method and system, and computer storage medium | |
| CN110413312B (en) | Method, device and equipment for managing application program and storage medium | |
| CN113220691B (en) | Database table creation method, database table creation device and electronic equipment | |
| EP3811346A1 (en) | Self-service terminal | |
| CN113448862A (en) | Software version testing method and device and computer equipment | |
| WO2020143324A1 (en) | Service program releasing method and apparatus, and computer device and storage medium | |
| CN110674153B (en) | Data consistency detection method and device and electronic equipment | |
| JP2005099967A (en) | Preventive maintenance method | |
| CN111241198A (en) | Data synchronization method and device and data processing equipment | |
| CN110795674A (en) | Configuration updating method and device | |
| CN113849328A (en) | Management method and device of disaster recovery system | |
| CN113839991A (en) | Method and device for confirming equipment information, storage medium and electronic device | |
| CN110837454A (en) | Interface monitoring processing method and server | |
| CN111857955A (en) | Method for automatically constructing and updating resource configuration information in heterogeneous cloud environment | |
| CN112527628A (en) | Configuration data synchronization method and device and electronic equipment | |
| CN112765188A (en) | Configuration information processing method, configuration management system, electronic device, and storage medium | |
| JP2012168870A (en) | Information processing system and form image storage server | |
| CN110412963A (en) | Production management banner system and its method based on cloud application | |
| CN113326007B (en) | Unstructured data federation storage method, device, terminal 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 |