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

Method and system for data separation

A data separation and data technology, applied in the database field, to achieve the effect of rationalizing density distribution, increasing speed, and increasing timeliness

Inactive Publication Date: 2012-10-03
SUZHOU CODYY NETWORK SCI & TECH
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When faced with a large amount of user data and differences in the frequency of use of different data, the above methods cannot improve query efficiency

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
  • Method and system for data separation
  • Method and system for data separation
  • Method and system for data separation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.

[0011] figure 1 Shown is a flowchart of a method for providing data separation according to a preferred embodiment of the present invention. like figure 1 As shown, the preferred embodiment of the present invention provides a data separation method including steps 101-103.

[0012] Step 101: Count the number of accurate queries and fuzzy queries of each piece of data in the data table, and calculate the query coefficient of the data according to the number of precise queries, the number of fuzzy queries and the preset weight value of each piece of data.

[0013] Specifically, the precise data query is to directly query the data with the key field of a certain piece of data as the query condition, ...

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 provides a method and a system for data separation. The method comprises the steps of recording precise query times and fuzzy query times of each data item in a data table; according to the precise query times, fuzzy query times and preset weight of each data item, computing query coefficient of the data; according to the data item number in the data table and the query coefficient of the data, determining partition coefficient of the data table; creating a cold data table and a heat data table respectively; comparing the query coefficient of the data and the partition coefficient of the data table; and inserting the data in the data table to the cold data table or the heat data table according to the comparative result.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to a data separation method and system. Background technique [0002] With the increasing development of social informatization, databases have been widely used in enterprises, schools and libraries. In daily applications, database systems need to store a large amount of data, and with the continuous development of business, the amount of data continues to increase. The main operation type of the daily data table is query, and the query frequency of different data in the data table is not the same. If the data with low query frequency is always combined with the high-frequency query data and placed in the data table, the data that is rarely accessed Will reduce the average query speed of the overall database. In the prior art, the way of separating and storing the data tables is mainly to distinguish by data type, or to split the fields and store them. When faced with a large a...

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): G06F17/30
Inventor 胡加明
Owner SUZHOU CODYY NETWORK SCI & TECH
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