Automatic design method of physical database based on SQL load mining

An automatic design and physical design technology, applied in the database field, can solve problems such as inapplicability to relational databases

Active Publication Date: 2006-08-30
北京神舟航天软件技术股份有限公司
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Among the existing relational database products, Microsoft SQLServer, IBM DB2 and Oracle all provide certain automatic design functions of physical databases. However, the automatic design functions in these database products are closely bound to the special functions provided by the database, so It cannot be applied to other relational databases, including widely used MySQL, PostgreSQL, and the domestic Oscar database

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic design method of physical database based on SQL load mining
  • Automatic design method of physical database based on SQL load mining
  • Automatic design method of physical database based on SQL load mining

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] like figure 1 As shown, the automatic design method of the physical database of the relational database is jointly completed by two processes of load information, database schema information and statistical information mining process and candidate physical property generation and optimal physical property combination search process. figure 2 and image 3 The specific details of these two processes are explained respectively.

[0038] like figure 2 Shown, the relational database system load of the present invention and statistical information mining method comprise:

[0039] Step 10) Collect relevant statistical information such as the number and execution time of various query (SELECT), update (UPDATE), insert (INSERT), delete (DELETE) SQL statements per unit time; this type of collection is completed in two ways , for the relational database system whose source code cannot be obtained, the proxy method is used to intercept and extract the SQL statement information...

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

No PUM Login to view more

Abstract

The invention discloses a method for automatically designing physical database based on SQL load digging, comprising two flows of digging load information, database mode information and statistic information and combined-searching candidate and optimum physical characteristics. It makes frame and algorithm completely independent of physical characteristic library and introduces automatic design into different relation database products or adds physical characteristics and optimization solutions to the existing relation database products, not changing integral frames and internal algorithms but only modifying the physical characteristic libraries.

Description

technical field [0001] The invention relates to an automatic design method for a physical database (PDB) applicable to a general relational database, in particular to an automatic design method for a physical database in a general relational database based on SQL load mining, and belongs to the technical field of databases. Background technique [0002] In database technology, the relational model database has the characteristics of simple and flexible data structure, easy to learn and understand, and has a solid mathematical foundation, and has now become the standard of the database. The database software widely used at present is a relational database management system based on the relational model. [0003] In database design work, logical database design and physical database design are the core links. Logical database design is to design the global logical structure of the database and the local logical structure of each user according to the user's requirements and t...

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 胡天磊
Owner 北京神舟航天软件技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap