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

Method for compressing data of relational database

A data compression and database technology, applied in the network field, can solve the problems of data loss and access speed, slowness, etc., to ensure data security and data access speed, and improve space utilization.

Inactive Publication Date: 2011-03-23
SANDA UNIVERSITY
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The most important way to save data in online forums is to use a relational database. Due to the huge amount of online forum data, it is very easy to cause data loss or slow access speed. These are very fatal flaws for online forums.

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 for compressing data of relational database
  • Method for compressing data of relational database
  • Method for compressing data of relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] According to the present invention, propose a kind of data compression method of relational database, comprise the following steps:

[0022] 10. Define the operation entity, the operation behavior object related to the operation entity, and the operation behavior data for evaluating the behavior result of the operation behavior object, wherein there is a one-to-one relationship between the operation entity and the operation behavior object. refer to figure 1 As shown, an instance of an operational entity and related operational behavior objects is disclosed. The operation entity is the user 11, the operation behavior object is the registration object 110, and the relevant operation behavior data includes the user name 110a, password 110b, nickname 110c, gender 110d and mailbox 110e. Evaluation of the behavior results of the registered object 110 is performed based on the user name 110a, password 110b, nickname 110c, gender 110d, and email address 110e. The operation b...

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 compressing data of a relational database. The method comprises the following steps: defining an operation entity, an operation action object and operation action data; defining a static entity, a static action object and static action data; defining a dynamic entity, a dynamic action object and dynamic action data; associating the operation entity and the static entity to form an operation entity-static entity association relation table; associating the operation entity and the dynamic entity to form an operation entity-dynamic entity association relation table; and compressing and combining the operation entity-static entity association relation table and the operation entity-dynamic entity association relation table based on the same operation entity, the static entity, the dynamic entity or the action object so as to form a database general relation table. The method for compressing the data of the relational database pertinently compresses the relational database in terms of the characteristics of an online forum, effectively improves the space utilization rate, and further ensures the data security and data access speed of the online forum.

Description

technical field [0001] The invention relates to network technology, in particular to a data compression method of a relational database. Background technique [0002] Online forums are the most common carrier of online communication, providing countless netizens with multi-party, instant, convenient communication platforms and a variety of dynamic messages. At the same time, online forums are increasingly involved in various important fields, such as the IT industry , finance and college BBS, etc. In order to increase the power of information dissemination and expand the influence of information, it has played a pivotal role. Therefore, in order to meet the increasing needs of netizens to a greater extent, the establishment and maintenance of online forum systems are also extremely important. [0003] The core content of the online forum system is the stored data. The success of the online forum directly depends on the preservation and maintenance of the data, the speed of...

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 SANDA UNIVERSITY
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