Method and apparatus for evaluating a partitioning scheme of a database
A database and scheme technology, applied in the field of database systems, which can solve problems such as difficulty in guaranteeing accuracy, limited number, and users' inability to evaluate partition schemes.
Active Publication Date: 2018-12-07
EMC IP HLDG CO LLC
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
For example, existing auxiliary tools usually only recommend a single partitioning scheme to users, but do not describe the advantages or effects of using this partitioning scheme; when comparing the performance of various partitioning schemes, existing auxiliary tools usually make predictions based on plan overhead estimates , it is difficult to guarantee the accuracy; and the existing auxiliary tools only consider a limited number of database partition schemes, and users cannot use auxiliary tools to evaluate custom partition schemes; in addition, existing tools are generally developed for specific database management systems, not Compatibility
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0022] Embodiments of the present invention will be described in detail below with reference to the accompanying drawings. The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in a flowchart or block diagram may represent a module, program segment, or portion of code that contains one or more logic devices for implementing the specified Executable instructions for a function. It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or they may sometimes be executed in the reverse order, depending upon the functionality involved. It should also be noted that each block of the ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to a method and device for assessing partition schemes of a database, in particular to the method for assessing the partition schemes of the database. The method comprises the steps: loading a data file describing the database, defining working loads of operations carried out for the database, interpreting the partition schemes of the database so as to form partition information, carrying out at least a part of operations defined in the working loads on the database based on the partition information, then obtaining a statistic log, and assessing the partition schemes according to an assessment criteria based on the statistic log. In another implement mode, the invention provides the device for assessing the partition schemes of the database.
Description
technical field [0001] Embodiments of the present invention relate to database systems, and more particularly, to methods, apparatus and related computer program products for evaluating partitioning schemes of databases. Background technique [0002] The development of computer technology has provided many conveniences for people's work and life, and more and more data are stored and managed in databases in a digital way. While providing convenience, how to store and manage these data in a more efficient way has long been a research focus in the database field. [0003] In order to improve the performance of database applications, in order to improve the scalability, availability and manageability of the database system, and improve the performance of database applications, the data scale to be managed is increasing and the database applications are becoming more and more complex. Database partitioning techniques have been developed for transactional and analytical applicat...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 曹逾陈继东郭小燕
Owner EMC IP HLDG CO LLC