MSSQL SERVER based table partition and automatic maintenance method and system
An automatic maintenance and table partitioning technology, applied in the field of database applications, can solve the problems of increasing the difficulty of data file management and the workload of maintenance, and achieve the effect of improving storage space performance and reducing workload.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0064] In order to describe the technical content, structural features, achieved goals and effects of the present invention in detail, the following will be described in detail in conjunction with the embodiments and accompanying drawings.
[0065] The invention relates to a table partition and automatic maintenance method based on MSSQL SERVER, which includes partition steps and automatic maintenance steps;
[0066] The partitioning step includes, designing a data retention strategy for tables of the same type according to requirements, and creating a table for the same type of table based on the same data retention strategy, partition function and partition architecture; the table creation includes sequentially creating a table partition function, creating a table partition Schema, which defines the table partition structure;
[0067] The automatic maintenance step includes: judging whether the tables in the database need to be sorted by table partitions, if necessary, dumpi...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com