CN112035486A - Partition establishing method, device and equipment for partition table - Google Patents
Partition establishing method, device and equipment for partition table Download PDFInfo
- Publication number
- CN112035486A CN112035486A CN202010916552.2A CN202010916552A CN112035486A CN 112035486 A CN112035486 A CN 112035486A CN 202010916552 A CN202010916552 A CN 202010916552A CN 112035486 A CN112035486 A CN 112035486A
- Authority
- CN
- China
- Prior art keywords
- partition
- information
- partition table
- class
- type
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Abstract
The application provides a partition establishing method, a partition establishing device and partition establishing equipment of a partition table, wherein the method comprises the following steps: acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; determining the partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of a partition table partition; and respectively adding partitions to each partition table based on the partition information of each partition table. In the embodiment of the application, the partition planning can be performed on different target objects and different partition table types in a targeted manner, and the flexibility and the accuracy of the partition planning are effectively improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a partition establishing method, apparatus and device for a partition table.
Background
With the increasing diversification of business scenes, how to flexibly customize a newly added partition of a data table in a bank system to adapt to practical situations is a problem to be solved urgently. In the prior art, a partition table in a system needs to be planned once in the country, the same partition method is adopted for different data volume requirements of each production line, the matching degree is low, and in order to meet the data volume requirements of all provinces, the reserved resource space is large, and the method causes great waste to hardware cost and maintenance cost. Therefore, the prior technical scheme can not be used for purposefully defining the zones.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the application provides a partition establishing method, a partition establishing device and partition establishing equipment for a partition table, and aims to solve the problem that partitions cannot be specified in a targeted manner in the prior art.
The embodiment of the application provides a partition establishing method for a partition table, which comprises the following steps: acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; determining the partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of a partition table partition; and respectively adding partitions to each partition table based on the partition information of each partition table.
The embodiment of the present application further provides a partition establishing apparatus for a partition table, including: the acquisition module is used for acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; the determining module is used for determining the partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of a partition table partition; and the partition adding module is used for respectively adding partitions to the partition tables based on the partition information of the partition tables.
The embodiment of the application also provides partition establishing equipment of the partition table, which comprises a processor and a memory for storing executable instructions of the processor, wherein the processor executes the instructions to realize the steps of the partition establishing method of the partition table.
Embodiments of the present application also provide a computer-readable storage medium having stored thereon computer instructions, which when executed, implement the steps of the partition establishing method of the partition table.
The embodiment of the application provides a partition establishing method for a partition table, which can be used for acquiring a target form information set of a target object, wherein the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; therefore, each partition table of the target object, which needs to be newly added with partitions, and the type of each partition table can be determined. Furthermore, the partition information of each partition table can be determined according to the type of each partition table, so that partitions can be added to each partition table respectively based on the partition information of each partition table, the purpose of planning partitions according to different target objects and different types of partition tables can be achieved, and the flexibility and the accuracy of the planning partitions are effectively improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application, are incorporated in and constitute a part of this application, and are not intended to limit the application. In the drawings:
FIG. 1 is a schematic diagram of a partition creation system for a partition table provided in accordance with an embodiment of the present application;
FIG. 2 is a schematic diagram illustrating steps of a partition establishing method for a partition table according to an embodiment of the present application;
FIG. 3 is a schematic structural diagram of a partition creating apparatus for a partition table according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a partition establishing apparatus of a partition table according to an embodiment of the present application.
Detailed Description
The principles and spirit of the present application will be described with reference to a number of exemplary embodiments. It should be understood that these embodiments are given solely for the purpose of enabling those skilled in the art to better understand and to practice the present application, and are not intended to limit the scope of the present application in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
As will be appreciated by one skilled in the art, embodiments of the present application may be embodied as a system, apparatus, device, method or computer program product. Accordingly, the present disclosure may be embodied in the form of: entirely hardware, entirely software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
Although the flow described below includes operations that occur in a particular order, it should be appreciated that the processes may include more or less operations that are performed sequentially or in parallel (e.g., using parallel processors or a multi-threaded environment).
In an example scenario of the present application, a partition creating system for a partition table is provided, as shown in fig. 1, which may include: the terminal device 101 and the server 102, the target user may initiate a request for adding a new partition to the target object through the terminal device 101. The server 102 may respond to a request for adding a new partition to the target object submitted by the user, obtain a target form information set of the target object, and determine partition information of each partition table, thereby implementing an operation of adding a partition to each partition table. Further, the server 102 may also feed back the partitioning result to the terminal device 101.
The terminal device 101 may be a terminal device or software used by a user. Specifically, the terminal device may be a terminal device such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a smart watch, or other wearable devices, or may be a robot device. Of course, the terminal apparatus 101 may be software that can be run in the above terminal apparatus. For example: system applications, payment applications, browsers, wechat applets, and the like.
The server 102 may be a single server or a server cluster, and certainly, the functions of the server may also be implemented by a cloud computing technology. The server 102 may be connected to a plurality of terminal devices, or may be a server having a strong information set library, and may add partitions to each partition table in the target form information set of the target object according to the obtained target form information set of the target object based on a request for adding partitions to the target object initiated by a user. In some scenario examples, the server 102 may also feed back the partitioning result of the target object to the terminal device 101.
Referring to fig. 2, the present embodiment may provide a partition establishing method for a partition table. The partition establishing method of the partition table can be used for determining partition information aiming at a target object needing to be added with a partition, so that the partition can be added to each partition table of the target object. The partition establishing method of the partition table may include the following steps.
S201: acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information used for representing a plurality of partition tables.
In this embodiment, a target form information set of a target object may be obtained. The target object may be an object requiring a new partition, and the target form information set of the target object may be a list of tables of the target object requiring the new partition. In some embodiments, since a newly opened branch, organization, etc. needs to perform a series of system-level preparation works, such as partition planning, etc., before being put into operation, the target object may be a newly opened branch, organization, etc., or may be an opened branch, organization, etc. that needs a newly added partition. The specific situation is determined according to actual conditions, and the application does not limit the specific situation.
In this embodiment, the manner of acquiring the target form information set of the target object may include: the database in the target object is automatically scanned by a tool to determine the list of tables requiring additional partitions, or a target form information set input by a user is received. It is understood that, the target form information set of the target object may also be obtained in other possible manners, for example, the target form information set may be found according to a preset path, which may be determined according to practical situations, and the present application does not limit this.
In an embodiment, the target form information set may be stored in a table form or a graph form, and may also be stored in any other possible form, which may be determined according to actual situations, and this application does not limit this.
In this embodiment, because different types of service data of actual service requirements generally need to be stored in different tables, so as to facilitate data management, the target form information set may include multiple sets of data, each set of data may include identification information and type information for characterizing partition tables that need to be newly added, and the identification information may include, but is not limited to, at least one of the following: table name, table description, partition elements of the table, etc. It is understood that each set of data may further include: information stored in the table, the location where the table is stored, the partition type of the table, etc. The specific situation is determined according to actual conditions, and the application does not limit the specific situation.
In one scenario example, the target form information set may be as shown in table 1:
TABLE 1
The partition COLUMN is a partition element, the IFRS9 is a financial instrument of international financial statement No. ninth, the SOC _ NO and INST _ NO are organization numbers (fixed values), the CUST _ ACCT _ NO, ACCT _ NO and MEMB _ CUST _ AC in the CUS2, inci, BIVM, DCRH, SINT, and ITXH tables are deposit account numbers of the user, and the ACCT _ NO in the BECL table is a loan account number of the user. Of course, the target form information set is not limited to the above examples, and other modifications are possible by those skilled in the art in light of the technical spirit of the present application, and are intended to be included within the scope of the present application as long as the functions and effects achieved by the present application are the same or similar.
Since there are differences in the data stored in the different types of tables, the manner of storing the data, and the amount of data stored, the present embodiment requires the type of each partition table in which the target form information is concentrated. The types of the partition table may be classified from a business perspective or from a table processing manner, and a specific classification may be determined according to an actual situation, which is not limited in the present application.
In this embodiment, the partition table is used to store a database resource table of data objects, and the partition table may be physically divided into several small tables, but logically still is a large table. When the data volume is continuously increased, the table needs to be partitioned, otherwise, the query speed of the data in the table is reduced, and the access performance of the application is affected. The partition table can physically store table data into a plurality of physical files, the whole table is not scanned during query, a table is logically maintained, and the partition table can create a unique partition index.
In one embodiment, the type of the partition table may include, but is not limited to, at least one of: deposit class, loan class, limit class, contract class, security class, batch parallelism class, card class, account class, and the like. In some embodiments, the batch parallelism class may be further subdivided into two classes according to a partitioning manner: and the batch parallelism class 1 is partitioned according to the value of the PIPE _ LINE (fixed value) of the parallelism class table, and the batch parallelism class 2 is partitioned according to the account number of the parallelism class table. Of course, the type of the partition table is not limited to the above examples, and other modifications are possible for those skilled in the art in light of the technical spirit of the present application, and are intended to be included within the scope of the present application as long as the functions and effects achieved by the partition table are the same as or similar to those of the present application.
In one embodiment, to support 7x24 (all weather service), the system logic may be divided into a daytime system and a nighttime system, which apply the same logic. The day and night system has independent tables/parameter files, but the structure is completely the same. The daytime system is a main mode under the new core banking system and is used for supporting the operation of the new core banking system in the daytime mode, and completing the online banking business supported by the system and the main batch processing of the system. Thus, the partition table can be divided into a day table and a night table from the time dimension.
In this embodiment, since the emphasis points of the day system and the night system for providing services are different and the amount of data to be processed is different, the types of tables related to the corresponding day table and night table are also different, and therefore, in some embodiments, it may be determined whether each partition table in the target form information set belongs to the day table or the night table, and then the types of each day table and night table may be further determined. In one particular embodiment, the daytime table may contain 8 types of partition tables: deposit, loan, limit, contract, security, batch parallelism 1, batch parallelism 2, and card; the night watch may contain 2 types of partition tables: a card class and an account class. It should be understood that the above-mentioned embodiment is only an example, and is not intended to limit the present application, and the specific embodiment may be determined according to practical situations, and the present application is not limited thereto.
In one embodiment, if the target form information set contains information of the type of the table, the type of each partition table may be determined directly from the target list table. If the target inventory table does not contain the information of the type of the table, the type of each partition table can be determined in other modes, each partition table is classified by using a machine learning model trained in advance, or the type of the table is determined according to data stored in each partition table, or a manual marking mode is adopted, the type of the table can be determined according to actual conditions, and the method is not limited in the application.
S202: determining partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of the partition table partition.
In the present embodiment, since the types of data stored in the different types of tables and the amounts of data stored in the different types of tables are different, the partition information of each partition table can be determined by concentrating the types of each partition table according to the target form information. The partition information may be used to characterize a new addition mode of the partition table, that is, how to plan a new partition for each partition table.
In one embodiment, the partition information may include, but is not limited to, at least one of: number of partitions, partition number. It will of course be appreciated that other information may also be included, such as: and a partition element that partitions the image into partitions according to the partition element. The information included in the partition information is not limited to the above examples, and other modifications may be made by those skilled in the art within the spirit of the present application, and the scope of the present application is intended to be covered by the claims as long as the functions and effects achieved by the present application are the same or similar.
S203: and respectively adding partitions to each partition table based on the partition information of each partition table.
In this embodiment, since there are differences in the way of adding new partitions to different tables, partitions can be added to each partition table based on the partition information of each partition table. In some embodiments, the addition of the partition may be implemented by using a programming language, but it is understood that any other possible manner may be used, and the details may be determined according to practical situations, which are not limited in this application.
From the above description, it can be seen that the embodiments of the present application achieve the following technical effects: the target form information set of the target object can be obtained, wherein the target form information set comprises a plurality of groups of identification information and type information used for representing a plurality of partition tables, so that each partition table of the target object, which needs to be newly added with partitions, and the type of each partition table can be determined. Furthermore, the partition information of each partition table can be determined according to the type of each partition table, so that partitions can be added to each partition table respectively based on the partition information of each partition table, the purpose of planning partitions according to different target objects and different types of partition tables can be achieved, and the flexibility and the accuracy of the planning partitions are effectively improved.
In one embodiment, adding partitions to each partition table based on partition information of each partition table may include: and generating a database definition statement of each partition table based on the partition information of each partition table. Further, according to a database Definition statement (DDL) of each partition table, a partition is added to each partition table.
In the present embodiment, the database definition statements may be submitted via SPUFI (database tool) or job (batch job control language). Among them, the above is a tool for creating z/OS DB2, which is an operating system run by IBM (International Business machines corporation) mainframe, a specialized business operating system. DB2 is a set of relational database management system developed by IBM, mainly applied to large-scale application systems, has better scalability, can support environments from mainframes to single users, and is applied to all common server operating system platforms.
In one example of a scenario, the number of partitions of a card information table CADM (card class table) in shanxi province is determined to be 4, and the partition number of each partition is: 011. 012, 013, 014, 015, so that the card information table CADM can be generated with the DDL of the partition increased according to the determined value of the partition number of the card information table CADM:
SET CURRENT SQLID＝'BANCS'；
ALTER TABLE BANCS.CADM
ADD PARTITION ENDING AT('003'，'011')；
ALTER TABLE BANCS.CADM
ADD PARTITION ENDING AT('003'，'012')；
ALTER TABLE BANCS.CADM
ADD PARTITION ENDING AT('003'，'013')；
ALTER TABLE BANCS.CADM
ADD PARTITION ENDING AT('003'，'014')；
ALTER TABLE BANCS.CADM
ADD PARTITION ENDING AT('003'，'015')；
COMMIT；
in this scenario example, CURRENT SQLID points to the daytime table, BANCS is an english name of the core bank daytime system, and the partition elements are: organization number and PARTITION _ ID, the organization number being a fixed value 003. The PARTITION corresponding to the PARTITION _ ID is expanded based on the original PARTITION, and the PARTITION numbers 012, 013, 014, and 015 are used. ALTER TABLE is a term used in network programs and programming to ALTER the definition of a TABLE by changing, adding, removing columns and constraints, or by enabling or disabling constraints and triggers. ADD mode: for adding new columns and integrity constraints, its syntax format: ALTER TABLE < TABLE name > ADD < column definition > | < integrity constraint >.
In the present scenario example, since the day and night two sets of systems respectively correspond to the day database and the night database in the large-scale host system, different SQLIDs are required to identify the day table and the night table when the table partition is newly added. In some embodiments, after the DDL statement is automatically generated, it may also be forwarded to a corresponding processing person to review the confirmation, and if the confirmation passes, the generated DDL statement is executed.
In one embodiment, before determining partition information of each partition table according to the type of each partition table in the target form information set, the method may further include: and acquiring the attribute information of each partition table according to the type of each partition table. Furthermore, the attribute information of each partition table can be analyzed, the partition number corresponding to each partition table is determined, and the partition number corresponding to each partition table is stored in a preset database. The preset database may be a database for storing data generated by the target object.
In this embodiment, because the data stored in the different partition tables, the way the data is stored, and the amount of data stored, etc. are different, the factors that need to be considered when planning the partition in the different partition tables are also different. The attribute information of each partition table can be respectively obtained according to the type of each partition table.
In this embodiment, the attribute information of each partition table may be analyzed to determine the number of partitions of each partition table, for example, for a deposit partition table, the number of partitions that need to be added may be determined according to the number range of the target object (i.e., the amount of data that may need to be stored).
In this embodiment, the number segment range of the target object needs to be planned in advance according to the data amount of the target object. The number segment range of the target object may be a range of a segment to which the user account belongs, and may be, for example: 0000010200000001-0000010400000000. Of course, the scope of the target object is not limited to the above examples, and other modifications are possible for those skilled in the art in light of the technical spirit of the present application, and are intended to be included within the scope of the present application as long as the functions and effects achieved by the present application are the same or similar.
In one embodiment, determining partition information of each partition table according to the type of each partition table in the target form information set may include: and acquiring the partition number corresponding to each partition table from a preset database according to the type of each partition table. Furthermore, numbering can be carried out according to the partition number corresponding to each partition table to obtain the partition number of each partition corresponding to each partition table, so that the partition number and the partition number corresponding to each partition table can be used as partition information of each partition table.
In this embodiment, since the partition number in the preset database is stored according to the type of the partition table and there may be a difference in the storage form of the partition numbers of the different types of partition tables, the partition number corresponding to each partition table may be obtained from the preset database according to the type of each partition table. For example: the partition number of the card partition table is stored by adopting a card partition comparison relation, and the partition number of the deposit type is directly stored in a numerical value mode.
In this embodiment, the partition number of each partition may be sequentially incremented by the next number according to the current latest partition number, for example: the current latest partition number is 011, the partition data of the card partition table is 4, and then the newly added 4 partitions in the card partition table can be numbered in sequence as follows: 012. 013, 014, 015.
In this embodiment, the partition information of the partition table may further include other information, for example: the number segment range, the location of the partitioned storage, and the like may be determined according to actual conditions, which is not limited in this application.
In one embodiment, the attribute information of the partition table may include: number segment range, batch parallel mode and requirement, and card partition comparison relationship. Since the attribute information required to be obtained by the partition tables of different types is different, in some embodiments, the attribute information of the partition tables of deposit class, loan class, quota class, contract class, security class and account class may include: number segment range; the attribute information of the batch parallelism class partition table may include: batch parallel mode and requirement; the attribute information of the card partition table may include: and (5) card partition comparison. The card partition comparison relationship may define the number of partitions of the card table and the partition number of each partition.
In the embodiment, the deposit class, loan class, limit class, contract class, security class and account class partition table can determine the partition number according to the number segment range; the batch parallelism class partition table can determine the data amount processed by the batch parallelism class partition table according to a batch parallelism mode and requirements, so that the partition number can be determined; the card type partition table can determine the partition number according to the comparison relationship between the partitions and the card numbers in the card partition comparison relationship.
In one embodiment, the target form information set of the target object may include a table to be newly added and an existing table to be newly added with a partition, so that partition customization of the newly added table may be implemented, or newly added partition customization of a certain table may be implemented separately. The customization is to complete the operation of adding partitions to the database table through an interface according to the actual needs of users.
Based on the same inventive concept, the embodiment of the present application further provides a partition creating apparatus for a partition table, as in the following embodiments. The principle of solving the problem of the partition establishing device of the partition table is similar to that of the partition establishing method of the partition table, so the implementation of the partition establishing device of the partition table can refer to the implementation of the partition establishing method of the partition table, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated. Fig. 3 is a block diagram of a structure of a partition establishing apparatus of a partition table according to an embodiment of the present application, and as shown in fig. 3, the partition establishing apparatus may include: the following describes the configuration of the acquisition module 301, the determination module 302, and the partition addition module 303.
An obtaining module 301, configured to obtain a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables;
the determining module 302 may be configured to determine partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of the partition table;
the partition adding module 303 may be configured to add a partition to each partition table based on the partition information of each partition table.
The embodiment of the present application further provides an electronic device, which may specifically refer to a schematic structural diagram of an electronic device shown in fig. 4 and based on the partition establishing method for the partition table provided in the embodiment of the present application, where the electronic device may specifically include an input device 41, a processor 42, and a memory 43. The input device 41 may be specifically configured to input a target form information set of a target object. The processor 42 may be specifically configured to obtain a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; determining partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of the partition table; and respectively adding partitions to each partition table based on the partition information of each partition table. The memory 43 may be specifically used to store parameters such as partition information of each partition table.
In this embodiment, the input device may be one of the main apparatuses for information exchange between a user and a computer system. The input devices may include a keyboard, mouse, camera, scanner, light pen, handwriting input panel, voice input device, etc.; the input device is used to input raw data and a program for processing the data into the computer. The input device can also acquire and receive data transmitted by other modules, units and devices. The processor may be implemented in any suitable way. For example, the processor may take the form of, for example, a microprocessor or processor and a computer-readable medium that stores computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, an embedded microcontroller, and so forth. The memory may in particular be a memory device used in modern information technology for storing information. The memory may include multiple levels, and in a digital system, memory may be used as long as binary data can be stored; in an integrated circuit, a circuit without a physical form and with a storage function is also called a memory, such as a RAM, a FIFO and the like; in the system, the storage device in physical form is also called a memory, such as a memory bank, a TF card and the like.
In this embodiment, the functions and effects specifically realized by the electronic device can be explained by comparing with other embodiments, and are not described herein again.
The embodiment of the present application further provides a computer storage medium of a partition establishing method based on a partition table, where the computer storage medium stores computer program instructions, and when the computer program instructions are executed, the computer storage medium can implement: acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables; determining partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of the partition table; and respectively adding partitions to each partition table based on the partition information of each partition table.
In this embodiment, the storage medium includes, but is not limited to, a Random Access Memory (RAM), a Read-Only Memory (ROM), a Cache (Cache), a Hard Disk Drive (HDD), or a Memory Card (Memory Card). The memory may be used to store computer program instructions. The network communication unit may be an interface for performing network connection communication, which is set in accordance with a standard prescribed by a communication protocol.
In this embodiment, the functions and effects specifically realized by the program instructions stored in the computer storage medium can be explained by comparing with other embodiments, and are not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the present application described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different from that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, embodiments of the present application are not limited to any specific combination of hardware and software.
Although the present application provides method steps as in the above-described embodiments or flowcharts, additional or fewer steps may be included in the method, based on conventional or non-inventive efforts. In the case of steps where no necessary causal relationship exists logically, the order of execution of the steps is not limited to that provided by the embodiments of the present application. When implemented in an actual apparatus or end product, the methods of (1) can be performed sequentially or in parallel (e.g., in the context of parallel processors or multi-threaded processing) according to the embodiments or methods shown in the figures.
It is to be understood that the above description is intended to be illustrative, and not restrictive. Many embodiments and many applications other than the examples provided will be apparent to those of skill in the art upon reading the above description. The scope of the application should, therefore, be determined not with reference to the above description, but instead should be determined with reference to the pending claims along with the full scope of equivalents to which such claims are entitled.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and it will be apparent to those skilled in the art that various modifications and variations can be made in the embodiment of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (10)
1. A partition establishing method of a partition table is characterized by comprising the following steps:
acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables;
determining the partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of a partition table partition;
and respectively adding partitions to each partition table based on the partition information of each partition table.
2. The method of claim 1, wherein adding partitions to the respective partition tables based on the partition information of the respective partition tables, respectively, comprises:
generating a database definition statement of each partition table based on the partition information of each partition table;
and adding partitions to each partition table according to the database definition sentences of each partition table.
3. The method of claim 1, further comprising, before determining partition information for each partition table according to a type of the each partition table in the target form information set,:
acquiring attribute information of each partition table according to the type of each partition table;
analyzing the attribute information of each partition table, and determining the partition number corresponding to each partition table;
and storing the partition number corresponding to each partition table into a preset database.
4. The method of claim 3, wherein determining partition information for each partition table in the target form information set based on the type of the partition table comprises:
acquiring the partition number corresponding to each partition table from the preset database according to the type of each partition table;
numbering according to the partition number corresponding to each partition table to obtain the partition number of each partition corresponding to each partition table;
and taking the partition number and the partition number corresponding to each partition table as partition information of each partition table.
5. The method of claim 3, wherein the type of partition table comprises at least one of: deposit class, loan class, limit class, contract class, security class, batch parallelism class, card class, and account class.
6. The method of claim 5, wherein the attribute information of the deposit class, loan class, limit class, contract class, security class and account class partition table comprises: number segment range;
the attribute information of the batch parallelism class partition table comprises: batch parallel mode and requirement;
the attribute information of the card partition table includes: and (5) card partition comparison.
7. The method of claim 1, wherein the identification information of the partition table comprises: table name, table description, partition element.
8. An apparatus for partition creation of a partition table, comprising:
the acquisition module is used for acquiring a target form information set of a target object; the target form information set comprises a plurality of groups of identification information and type information for representing a plurality of partition tables;
the determining module is used for determining the partition information of each partition table according to the type of each partition table in the target form information set; the partition information is used for representing a newly added mode of a partition table partition;
and the partition adding module is used for respectively adding partitions to the partition tables based on the partition information of the partition tables.
9. Partition creation device for a partition table, comprising a processor and a memory for storing processor-executable instructions, which when executed by the processor implement the steps of the method according to any one of claims 1 to 7.
10. A computer-readable storage medium having stored thereon computer instructions which, when executed, implement the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010916552.2A CN112035486B (en) | 2020-09-03 | 2020-09-03 | Partition establishing method, device and equipment of partition table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010916552.2A CN112035486B (en) | 2020-09-03 | 2020-09-03 | Partition establishing method, device and equipment of partition table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112035486A true CN112035486A (en) | 2020-12-04 |
| CN112035486B CN112035486B (en) | 2023-09-19 |
Family
ID=73591922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010916552.2A Active CN112035486B (en) | 2020-09-03 | 2020-09-03 | Partition establishing method, device and equipment of partition table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112035486B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102486798A (en) * | 2010-12-03 | 2012-06-06 | 腾讯科技（深圳）有限公司 | Data loading method and device |
| CN107239485A (en) * | 2017-04-18 | 2017-10-10 | 北京小度信息科技有限公司 | Database operation method, apparatus and system |
| CN107818167A (en) * | 2017-11-08 | 2018-03-20 | 顺丰科技有限公司 | MySQL subregions automatic management method, system, equipment, storage medium |
-
2020
- 2020-09-03 CN CN202010916552.2A patent/CN112035486B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102486798A (en) * | 2010-12-03 | 2012-06-06 | 腾讯科技（深圳）有限公司 | Data loading method and device |
| CN107239485A (en) * | 2017-04-18 | 2017-10-10 | 北京小度信息科技有限公司 | Database operation method, apparatus and system |
| CN107818167A (en) * | 2017-11-08 | 2018-03-20 | 顺丰科技有限公司 | MySQL subregions automatic management method, system, equipment, storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112035486B (en) | 2023-09-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109977110B (en) | Data cleaning method, device and equipment | |
| EP3161635B1 (en) | Machine learning service | |
| US10963810B2 (en) | Efficient duplicate detection for machine learning data sets | |
| CN110209650B (en) | Data normalization and migration method and device, computer equipment and storage medium | |
| CN108536761A (en) | Report data querying method and server | |
| Amin | Tracing the linkage of several Unified Modelling Language diagrams in software modelling based on best practices | |
| US11615076B2 (en) | Monolith database to distributed database transformation | |
| CN111651519A (en) | Data synchronization method, data synchronization device, electronic device, and storage medium | |
| CN113297458A (en) | Paging query method, device and equipment | |
| CN110737432A (en) | script aided design method and device based on root list | |
| CN114048370A (en) | Python-based archive file processing, storage and one-stop management platform | |
| CN111752958A (en) | Intelligent associated label method, device, computer equipment and storage medium | |
| US8229946B1 (en) | Business rules application parallel processing system | |
| CN111143461A (en) | Mapping relation processing system and method and electronic equipment | |
| CN112035486B (en) | Partition establishing method, device and equipment of partition table | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| CN115203435A (en) | Entity relation generation method and data query method based on knowledge graph | |
| CN114020446A (en) | Cross-multi-engine routing processing method, device, equipment and storage medium | |
| CN103809915A (en) | Read-write method and device of magnetic disk files | |
| CN106844242B (en) | A kind of method for interchanging data and system | |
| CN110837365A (en) | Script aided design method and device based on root table | |
| CN113064597B (en) | Redundant code identification method, device and equipment | |
| CN112035458B (en) | Data isolation method, device and equipment | |
| CN116450753A (en) | Customs service data structured management method and device, computer equipment group and storage medium | |
| CN113052504A (en) | Service system management method and device |
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 |