Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database optimization method and system

An optimization method and database technology, applied in the database field, can solve problems such as low retrieval efficiency and high time complexity

Active Publication Date: 2019-06-07
SHANGHAI TRUELAND INFORMATION & TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a database optimization method and system, which solves the problems of high time complexity and low retrieval efficiency in the existing database retrieval process, reduces the number of invalid queries, improves the efficiency of database optimization, and improves query performance

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
  • Database optimization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0048] A database optimization method, comprising the following steps:

[0049] S1. Store and divide the data in the database, establish file groups with different storage dates, and divide and store the data in the file group into each row list;

[0050] The data storage space division in the database includes the following steps:

[0051] T1. Set several file groups for the database. Different file groups are divided by time period and sorted according to the ti...

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 database optimization method and system, and belongs to the technical field of databases. The database optimization system comprises a storage area division module, a keywordfeature extraction module, a query calling module, a comprehensive analysis module, a clustering processing module and a query optimization module. The storage area division module is connected withthe keyword feature extraction module, the overall planning analysis module is respectively connected with the keyword feature extraction module, the query calling module and the clustering processingmodule, and the query optimization module is connected with the clustering processing module. The invention provides a database optimization method and system. The method comprises the following steps of: extracting keywords from data in each line list in each partition table in a database. The method has the advantages that the extracted keywords are extracted, weight statistics and clustering analysis are performed on the extracted keywords, database search is optimized, hierarchical distribution query is adopted, the query complexity is reduced, the search efficiency is improved, unnecessary repeated links are reduced, the time cost is saved, and the database optimization efficiency is greatly improved.

Description

technical field [0001] The invention belongs to the technical field of databases, and relates to a database optimization method and a system thereof. Background technique [0002] The database can be regarded as an electronic file cabinet, that is, the place where electronic files are stored. Users can perform operations such as adding, intercepting, updating, and deleting data in the file. The so-called "database" is stored together in a certain way, can be A collection of data shared by multiple users with as little redundancy as possible and independent of the application. [0003] With the continuous development of network information technology, database application technology has been widely used in many industries. There are a large amount of data stored in the database. When querying and updating the data in the database, due to the huge amount of data in the database, it is necessary to Querying the data in the database one by one, the time complexity is high, unne...

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
IPC IPC(8): G06F16/2453G06F16/28
Inventor 陈海林赵绪龙王士义
Owner SHANGHAI TRUELAND INFORMATION & TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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