CN112035486B - Partition establishing method, device and equipment of partition table - Google Patents

Partition establishing method, device and equipment of partition table Download PDF

Info

Publication number
CN112035486B
CN112035486B CN202010916552.2A CN202010916552A CN112035486B CN 112035486 B CN112035486 B CN 112035486B CN 202010916552 A CN202010916552 A CN 202010916552A CN 112035486 B CN112035486 B CN 112035486B
Authority
CN
China
Prior art keywords
partition
class
information
partition table
tables
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
Application number
CN202010916552.2A
Other languages
Chinese (zh)
Other versions
CN112035486A (en
Inventor
张康洁
蔡震
陈亚坤
张阳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202010916552.2A priority Critical patent/CN112035486B/en
Publication of CN112035486A publication Critical patent/CN112035486A/en
Application granted granted Critical
Publication of CN112035486B publication Critical patent/CN112035486B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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 device and 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 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 new adding mode of partition of the partition table; and adding partitions to each partition table based on the partition information of each partition table. In the embodiment of the application, the partition can be planned for different target objects and different partition table types in a targeted manner, and the flexibility and accuracy of the partition planning are effectively improved.

Description

Partition establishing method, device and equipment of partition table
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, an apparatus, and a device for establishing a partition of a partition table.
Background
With the gradual diversification of business scenes, how to flexibly customize new partitions of a data table in a banking system to adapt to actual situations is a problem to be solved urgently. In the prior art, partition tables in a system need to be planned all over the country once, different data volume requirements of each production line are met by adopting the same partition method, the matching degree is low, in order to meet the data volume requirements of all provinces, the reserved resource space is often required to be large, and the one-time cutting mode causes great waste on hardware cost and maintenance cost. It follows that the prior art solutions do not allow a targeted planning of the partitions.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the application provides a partition establishing method, device and equipment of a partition table, which are used for solving the problem that partitions cannot be planned in a targeted manner in the prior art.
The embodiment of the application provides a partition establishing method of 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 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 new adding mode of partition of the partition table; and adding partitions to each partition table based on the partition information of each partition table.
The embodiment of the application also provides a partition establishing device of the partition table, which comprises the following steps: 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 new adding mode of partition of the partition table; and the partition adding module is used for 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 realizes the steps of the partition establishing method of the partition table when executing the instructions.
The embodiment of the application also provides a computer readable storage medium, wherein the computer instructions are stored on the computer readable storage medium, and the instructions realize the steps of the partition establishing method of the partition table when being executed.
The embodiment of the application provides a partition establishing method of a partition table, which can be implemented by 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; thus, each partition table of the target object requiring the new partition and the type of each partition table can be determined. Further, the partition information of each partition table can be determined according to the type of each partition table, so that the partition can be added to each partition table based on the partition information of each partition table, the partition can be planned according to different target objects and the types of different partition tables, and the flexibility and accuracy of the planned partition are effectively improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate and together with the description serve to explain the application. In the drawings:
FIG. 1 is a schematic diagram of a partition creation system of 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 of a partition table according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a partition establishing apparatus of 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 below with reference to several exemplary embodiments. It should be understood that these embodiments are presented merely to enable those skilled in the art to better understand and practice the application and are not intended to limit the scope of the 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.
Those skilled in the art will appreciate that embodiments of the application may be implemented as a system, apparatus device, method, or computer program product. Accordingly, the present disclosure may be embodied in the following forms, namely: complete hardware, complete software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
While the flow described below includes a number of operations occurring in a particular order, it should be apparent that these processes may include more or fewer operations, which may be performed sequentially or in parallel (e.g., using a parallel processor or a multi-threaded environment).
In one scenario example of the present application, a partition establishing system of a partition table is provided, as shown in fig. 1, may include: the terminal equipment 101 and the server 102, and the target user can initiate a request for adding a partition to the target object through the terminal equipment 101. The server 102 may obtain the target form information set of the target object in response to the user submitting the request for the newly added partition of the target object, and determine the partition information of each partition table, so as to implement the operation of adding the partition to each partition table. Further, the server 102 may also feed back the partition result to the terminal device 101.
The terminal device 101 may be a terminal device or software used by a user operation. 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 or the like. Of course, the terminal device 101 may be software that can be executed in the terminal device. For example: system applications, payment applications, browsers, weChat applets, and other application software.
The server 102 may be a single server or a server cluster, and of course, the functions of the server may be implemented by using a cloud computing technology. The server 102 may be connected to a plurality of terminal devices, or may be a server with a strong information set library, and may implement the operation of adding 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 a partition to the target object initiated by a user. In some scenario examples, server 102 may also feed back the partitioning result of the target object to terminal device 101 described above.
Referring to fig. 2, the present embodiment may provide a partition establishing method of a partition table. The partition establishing method of the partition table can be used for determining partition information for the target object needing to be newly added with partitions, so that the partitions 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 for representing a plurality of partition tables.
In this embodiment, a target form information set of a target object may be acquired. The target object may be an object requiring new partition, and the target form information set of the target object may be a list of tables requiring new partition of the target object. In some embodiments, since the newly opened branches, institutions, etc. need to perform a series of preparation work on the system level, for example, performing partition planning, etc., before the newly opened branches, institutions, etc. are put into operation, the target object may be the newly opened branches, institutions, etc. or may be the branches, institutions, etc. that have already opened the newly added partition. And in particular, to the actual situation, the application is not limited thereto.
In this embodiment, the manner of acquiring the target form information set of the target object may include: the tool is utilized to automatically scan a database in the target object to determine a list of tables requiring new partitions or to receive a set of target form information entered by a user. It will be understood that, of course, other possible ways may be used to obtain the target form information set of the target object, for example, where the target form information set is searched according to a preset path, and specifically may be determined according to a practical situation, which is not limited by the present application.
In one embodiment, the target form information set may be stored in a table form or may be stored in a graphic form, or may be stored in any other possible form, and specifically may be determined according to practical situations, which is not limited by the present application.
In this embodiment, since different types of service data of actual service requirements are usually required to be stored separately by using different tables, so that data management is facilitated, the target form information set may include multiple sets of data, where each set of data may include identification information and type information for characterizing each partition table requiring a new partition, and the identification information may include, but is not limited to, at least one of the following: table names, table descriptions, table partition elements, etc. It will be understood, of course, that each set of data described above may also include: information stored in the table, a position where the table is stored, a partition manner of the table, and the like. And in particular, to the actual situation, the application is not limited thereto.
In one scenario example, the target form information set described above may be as shown in table 1:
TABLE 1
Wherein the partition COLUMN is a partition element, the IFRS9 is a ninth financial instrument of the international financial statement, the soc_no and the inst_no are institution numbers (fixed values), the cut_acct_no, the acct_no, the memb_cut_ac in the cut 2 table, the INCT table, the BIVM table, the DCRH table, the SINT table, and the ITXH table are deposit account numbers of users, and the acct_no in the BECL table is a loan account number of users. 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, but all the functions and effects achieved are the same or similar to those of the present application and are included in the scope of the present application.
Since there are differences in the data stored in the different types of tables, the manner in which the data is stored, the amount of data stored, and the like, the types of the respective partition tables in the target form information set are required in the present embodiment. The types of the partition tables may be classified from the service perspective or from the processing mode of the tables, and how to classify the partition tables may be determined according to practical situations, which is not limited by the present application.
In this embodiment, the partition table is used to store a database resource table of a data object, and the partition table may physically divide a large table into several small tables, but logically, is also a large table. When the data volume is continuously increased, the table is required 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 inquiry, one table is still logically maintained, and the partition table can create a unique partition index.
In one embodiment, the types of partition tables described above may include, but are not limited to, at least one of: deposit, loan, line, contract, deposit, bulk parallelism, card, account, etc. In some embodiments, the batch parallelism class may be further subdivided into two classes according to partition manner: the batch parallelism class 1 is partitioned according to the value of 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 above partition table 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, but all the functions and effects achieved are the same or similar to those of the present application and are included in the scope of the present application.
In one embodiment, in order to support 7x24 (all-weather service), the system logic may be divided into a daytime system and a nighttime system, which are identical in application logic. The day and night systems have independent table/parameter files, but the structures are identical. The daytime system is a main mode under the new core banking system and is used for supporting the operation under the daytime mode of the new core banking system and completing the online banking business supported by the system and the main batch processing of the system. Thus, the above-described partition table may be divided into a daytime table and a nighttime table from the time dimension.
In this embodiment, since the day system and the night system provide different service emphasis points and the processed data amounts are different, the types of the corresponding day table and night table are also different, and thus in some embodiments, it may be determined whether each partition table in the target table information set belongs to the day table or the night table, and further determine the types of each day table and night table. In one particular embodiment, the day table may contain 8 types of partition tables: deposit class, loan class, credit class, contract class, deposit class, bulk parallelism class 1, bulk parallelism class 2, card class; night table may contain 2 types of partition tables: card class and account class. It will of course be appreciated that the above-described embodiment is only an example and is not intended to limit the application, which is specifically defined in terms of practice and 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 information of the type of the table is not included in the target list table, the type of each partition table may be determined in other manners, and the partition tables are classified by using a pre-trained machine learning model, or the type of the table is determined according to the data stored in each partition table, or the type of the table is determined by adopting an artificial mark manner, specifically, the type of the table may be determined according to the actual situation, which is not limited in the present 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 new adding mode of the partition table.
In this embodiment, since there are differences in the types of data stored in the tables of different types, the amounts of data stored, and the like, the partition information of each partition table can be determined according to the types of each partition table in the target form information set. The partition information may be used to characterize a new way of partitioning the partition table, i.e. 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, number of partitions. It will of course be appreciated that other information may also be included, such as: partition elements, and a method of partitioning by partition elements. The information contained in the partition information 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, but all the functions and effects achieved are included in the scope of the present application as long as they are the same or similar to the present application.
S203: based on the partition information of each partition table, partitions are added to each partition table, respectively.
In the present embodiment, since there is a difference in the manner in which the new partition is added to the different tables, the partition may be added to each of the partition tables based on the partition information of each of the partition tables. In some embodiments, the addition of partitions may be implemented using a programming language, although it will be appreciated that any other possible manner may be used, and in particular, may be determined based on actual circumstances, as the application is not limited in this respect.
From the above description, it can be seen that the following technical effects are achieved in the embodiments of the present application: 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 for representing a plurality of partition tables, so that each partition table of the target object, which needs to be newly added with a partition, and the type of each partition table can be determined. Further, the partition information of each partition table can be determined according to the type of each partition table, so that the partition can be added to each partition table based on the partition information of each partition table, the partition can be planned according to different target objects and the types of different partition tables, and the flexibility and accuracy of the planned partition are effectively improved.
In one embodiment, adding partitions to each partition table based on partition information of each partition table may include: based on the partition information of each partition table, a database definition statement of each partition table is generated. Further, partitions are added to each partition table according to database definition statements (DDL, data Definition Language) of each partition table.
In this embodiment, the database definition statement may be submitted through a spifi (database tool) or a job (batch job control language). Wherein the above is a tool for creating z/OS DB2, which is the operating system of IBM (International Business machines corporation) mainframe running, and is a specialized commercial operating system. DB2 is a set of relational database management system developed by IBM corporation, which is mainly applied to large-scale application systems, has better scalability, can support from a mainframe to a single-user environment, and is applied to all common server operating system platforms.
In one example of a scenario, the number of partitions for which the shanxi province card information table CADM (card class table) is determined to be 4 is: 011. 012, 013, 014, 015, whereby DDL of the card information table CADM add-on partition can be generated from 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 the english name of the core bank daytime system, and the partition elements are: the organization number and the component_id (PARTITION number), the organization number is a fixed value 003. The PARTITION corresponding to the parameter_id is expanded based on the original PARTITION, and PARTITION numbers 012, 013, 014, and 015 are used. ALTER TABLE is a term used in network programming 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 this scenario example, since in a large host system, the day and night systems correspond to the day database and the night database, respectively, different SQLIDs are required to identify the day table and the night table when the table is newly added. In some embodiments, after the DDL statement is automatically generated, it may also be forwarded to a corresponding handler to review the acknowledgement, in which case the generated DDL statement is executed.
In one embodiment, before determining the partition information of each partition table according to the type of each partition table in the target form information set, it may further include: and acquiring attribute information of each partition table according to the type of each partition table. Further, 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, since there are differences in the data stored in the different partition tables, the manner in which the data is stored, the amount of data stored, and the like, there are differences in factors that need to be considered when planning the partition in the different partition tables. The attribute information of each partition table can be obtained for the type of each partition table.
In this embodiment, attribute information of each partition table may be analyzed to determine the number of partitions of each partition table, for example, for a deposit class partition table, the number of partitions that need to be increased may be determined according to the range of number segments of the target object (i.e., the amount of data that may need to be stored).
In this embodiment, the number 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 section to which the user account belongs, for example, may be: 0000010200000001 ～ 0000010400000000. Of course, the number range of the target object 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, but all the functions and effects achieved by the present application are included in the protection scope of the present application.
In one embodiment, determining the partition information of each partition table according to the type of each partition table in the target form information set may include: and obtaining the partition numbers corresponding to the partition tables from a preset database according to the types of the partition tables. Further, the partition numbers of the partitions corresponding to the partition tables can be obtained by numbering according to the partition numbers of the partitions corresponding to the partition tables, so that the partition numbers and the partition numbers corresponding to the partition tables can be used as partition information of the partition tables.
In this embodiment, since the number of partitions 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 number of partitions of the partition table of different types, the number of partitions 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 class is directly stored by adopting a numerical mode.
In this embodiment, the partition numbers of the respective partitions may be sequentially incremented by a downward number according to the current latest partition number, for example: the current latest partition number is 011, and the partition data of the card partition table is 4, so that the 4 newly added partitions of the card partition table can be numbered as follows: 012. 013, 014 and 015.
In this embodiment, the partition information of the partition table may further include other information, for example: the number range, the partition storage position and the like can be specifically determined according to actual conditions, and the application is not limited to the above.
In one embodiment, the attribute information of the partition table may include: number segment range, batch parallel mode and requirement, card partition comparison relation. Because the attribute information that needs to be obtained for different types of partition tables is different, in some embodiments, the attribute information for deposit, loan, credit, contract, wager, and account partition tables may include: a number segment range; the attribute information of the batch parallelism class partition table may include: a batch parallel mode and requirements; the attribute information of the card class partition table may include: card partition control relationship. The card partition comparison relationship may define the number of partitions of the card table and the partition numbers of the respective partitions.
In this embodiment, the deposit class, loan class, credit class, contract class, deposit class, and account class partition table may determine the partition number according to the number range; the batch parallelism class partition table can determine the data quantity 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 class partition table can determine the partition number according to the comparison relation between the partition and the card number in the card partition comparison relation.
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, so that partition customization of the newly added table may be implemented, or new partition customization of a certain table may be implemented separately. The customization refers to the operation of adding partitions to the database table through an interface according to the actual demands of users.
Based on the same inventive concept, the embodiment of the application also provides a partition establishing device of the partition table, as follows. Since the principle of solving the problem by the partition establishing device of the partition table is similar to that of the partition establishing method of the partition table, the implementation of the partition establishing device of the partition table can be referred to the implementation of the partition establishing method of the partition table, and the repetition is omitted. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated. FIG. 3 is a block diagram of a partition establishing apparatus of a partition table according to an embodiment of the present application, as shown in FIG. 3, may include: the configuration of the acquisition module 301, the determination module 302, and the partition adding module 303 will be described below.
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 a type of each partition table in the target form information set; the partition information is used for representing a new adding mode of partition of the partition table;
the partition adding module 303 may be configured to add partitions to the respective partition tables based on partition information of the respective partition tables.
The embodiment of the application also provides an electronic device, which specifically can refer to a schematic diagram of the composition structure of the electronic device based on the partition table partition establishing method provided by the embodiment of the application shown in fig. 4, and the electronic device specifically can include an input device 41, a processor 42 and a memory 43. Wherein the input device 41 may be specifically used for inputting a target form information set of a target object. The processor 42 may be specifically configured to obtain a target form information set of the 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 new adding mode of partition of the partition table; based on the partition information of each partition table, partitions are added to each partition table, respectively. The memory 43 may be used to store parameters such as partition information of each partition table.
In this embodiment, the input device may specifically be one of the main means for exchanging information between the user and the computer system. The input device may include a keyboard, mouse, camera, scanner, light pen, handwriting input board, voice input apparatus, etc.; the input device is used to input raw data and a program for processing these numbers into the computer. The input device may also obtain data transmitted from other modules, units, and devices. The processor may be implemented in any suitable manner. For example, the processor may take the form of, for example, a microprocessor or processor, and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a programmable logic controller, and an embedded microcontroller, among others. The memory may in particular be a memory device for storing information in modern information technology. The memory may comprise a plurality of levels, and in a digital system, may be memory as long as binary data can be stored; in an integrated circuit, a circuit with a memory function without a physical form is also called a memory, such as a RAM, a FIFO, etc.; 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 specific functions and effects of the electronic device may be explained in comparison with other embodiments, which are not described herein.
The embodiment of the application also provides a computer storage medium of the partition establishing method based on the partition table, wherein the computer storage medium stores computer program instructions, and the computer program instructions can be realized when being executed: 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 new adding mode of partition of the partition table; based on the partition information of each partition table, partitions are added to each partition table, respectively.
In the present embodiment, the storage medium includes, but is not limited to, a random access Memory (Random Access Memory, RAM), a Read-Only Memory (ROM), a Cache (Cache), a Hard Disk (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 of the program instructions stored in the computer storage medium may be explained in comparison with other embodiments, and are not described herein.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the application described above may be implemented in a general purpose computing device, they may be concentrated on a single computing device, or distributed across a network of computing devices, they may alternatively be implemented in program code executable by computing devices, so that they may be stored in a storage device for execution by computing devices, and in some cases, the steps shown or described may be performed in a different order than what is shown or described, or they may be separately fabricated into individual integrated circuit modules, or a plurality of modules or steps in them may be fabricated into a single integrated circuit module. Thus, embodiments of the application are not limited to any specific combination of hardware and software.
Although the present application provides method operational steps as described in the embodiments or flowcharts above, more or fewer operational steps may be included in the method based on routine or non-inventive labor. In the steps where there is logically no necessary causal relationship, the execution order of the steps is not limited to the execution order provided by the embodiment of the present application. When implemented in an actual device or end product, the methods of (a) may be performed sequentially or in parallel (e.g., in a parallel processor or a multithreaded environment) as shown in the embodiments or 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 appended claims, along with the full scope of equivalents to which such claims are entitled.
The above description is only of the preferred embodiments of the present application and is not intended to limit the present application, and various modifications and variations can be made to the embodiments of the present application by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the protection scope of the present application.

Claims (5)

1. A partition establishing method of a partition table, comprising:
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 new adding mode of partition of the partition table;
adding partitions to each partition table based on the partition information of each partition table;
before determining the partition information of each partition table according to the type of each partition table in the target form information set, the method further comprises: acquiring attribute information of each partition table according to the type of each partition table; analyzing attribute information of each partition table, and determining the partition number corresponding to each partition table; storing the partition numbers corresponding to the partition tables into a preset database;
wherein determining partition information of each partition table according to the type of each partition table in the target table information set comprises: according to the types of the partition tables, the partition numbers corresponding to the partition tables are obtained from the preset database; numbering according to the partition numbers corresponding to the partition tables to obtain partition numbers of the partitions corresponding to the partition tables; taking the partition number and the partition number corresponding to each partition table as partition information of each partition table;
the partition table type includes at least one of: deposit class, loan class, credit class, contract class, deposit class, bulk parallelism class, card class, and account class;
the attribute information of the deposit class, the loan class, the line class, the contract class, the pressed class and the account class partition table comprises: a number segment range;
the attribute information of the batch parallelism class partition table comprises: a batch parallel mode and requirements;
the attribute information of the card partition table comprises: card partition comparison;
the identification information of the partition table includes: table name, description of table, partition element.
2. The method of claim 1, wherein adding partitions to the respective partition tables based on partition information of the respective partition tables, respectively, comprises:
generating database definition sentences 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 statement of each partition table.
3. A partition establishing apparatus 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 new adding mode of partition of the partition table;
the partition adding module is used for adding partitions to each partition table based on the partition information of each partition table;
the device is also for: acquiring attribute information of each partition table according to the type of each partition table; analyzing attribute information of each partition table, and determining the partition number corresponding to each partition table; storing the partition numbers corresponding to the partition tables into a preset database;
wherein determining partition information of each partition table according to the type of each partition table in the target table information set comprises: according to the types of the partition tables, the partition numbers corresponding to the partition tables are obtained from the preset database; numbering according to the partition numbers corresponding to the partition tables to obtain partition numbers of the partitions corresponding to the partition tables; taking the partition number and the partition number corresponding to each partition table as partition information of each partition table;
the partition table type includes at least one of: deposit class, loan class, credit class, contract class, deposit class, bulk parallelism class, card class, and account class;
the attribute information of the deposit class, the loan class, the line class, the contract class, the pressed class and the account class partition table comprises: a number segment range;
the attribute information of the batch parallelism class partition table comprises: a batch parallel mode and requirements;
the attribute information of the card partition table comprises: card partition comparison;
the identification information of the partition table includes: table name, description of table, partition element.
4. A partition establishing device of a partition table, comprising a processor and a memory for storing processor executable instructions, which processor, when executing the instructions, implements the steps of the method of any of claims 1 to 2.
5.A computer readable storage medium having stored thereon computer instructions which when executed implement the steps of the method of any of claims 1 to 2.
CN202010916552.2A 2020-09-03 2020-09-03 Partition establishing method, device and equipment of partition table Active CN112035486B (en)

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 CN112035486A (en) 2020-12-04
CN112035486B true 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)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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
CN112035486A (en) 2020-12-04

Similar Documents

Publication Publication Date Title
DE112012005037B4 (en) Manage redundant immutable files using deduplications in storage clouds
JP2022141957A (en) Metadata snapshot method and snap device thereof
CN107885499A (en) A kind of interface document generation method and terminal device
CN110908997A (en) Data blood margin construction method and device, server and readable storage medium
CN110209650A (en) The regular moving method of data, device, computer equipment and storage medium
CN108536745B (en) Shell-based data table extraction method, terminal, equipment and storage medium
CN109690522B (en) Data updating method and device based on B+ tree index and storage device
US11615076B2 (en) Monolith database to distributed database transformation
CN111651519A (en) Data synchronization method, data synchronization device, electronic device, and storage medium
US20230012642A1 (en) Method and device for snapshotting metadata, and storage medium
CN112559522A (en) Data storage method and device, query method, electronic device and readable medium
CN103077192A (en) Data processing method and system thereof
CN110737432A (en) script aided design method and device based on root list
CN114706894A (en) Information processing method, apparatus, device, storage medium, and program product
CN110222047A (en) A kind of dynamic list generation method and device
CN112035486B (en) Partition establishing method, device and equipment of partition table
CN112328621A (en) SQL conversion method and device, computer equipment and computer readable storage medium
CN111143461A (en) Mapping relation processing system and method and electronic equipment
CN115495440A (en) Data migration method, device and equipment of heterogeneous database and storage medium
CN109359085A (en) File migration method, apparatus, computer equipment and storage medium
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
CN113868138A (en) Method, system, equipment and storage medium for acquiring test data
CN103809915A (en) Read-write method and device of magnetic disk files
CN110837365A (en) Script aided design method and device based on root table

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