Multi-dimension design method of relational database

A design method and database technology, applied in electrical digital data processing, special data processing applications, computing, etc., can solve problems such as increasing the operating cost of database systems, achieve mass storage and real-time access, reduce operating costs, and reduce requirements. Effect

Inactive Publication Date: 2012-07-25
CHENGDU CHENGDIAN YIXING DIGITAL HEALTH SOFTWARE CO LTD
View PDF1 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This increases the operating cost of the database system

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
  • Multi-dimension design method of relational database
  • Multi-dimension design method of relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] Embodiment 1: see figure 1 , a multidimensional design method for relational databases, including relational databases;

[0023] Data latitude analysis, analyze and design the data in the relational database in the dimensions of time, ownership, business, status and sequence;

[0024] The establishment of the data latitude model is analyzed and designed through dimensions, and the time latitude model, the attribute latitude model, the business latitude model, the state latitude model and the sequence latitude model are established to form a multi-dimensional database.

[0025] Design the dimensional schema of the data and divide the database or data table according to the following methods,

[0026] Time latitude mode, which is organized and stored according to the time dimension of data information. According to the size of the data volume at different times of the data, establish the organization and storage mode of the data. For example, divide the database or dat...

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 multi-dimension design method of a relational database, wherein the relational database is provided; and the method comprises the steps of performing the analysis of data latitude: performing the analysis design on dimensions of time, belonging, business, state and sequence of data in the relational database; and establishing a latitude mode of the data: establishing a time latitude mode, a belonging latitude mode, a business latitude mode, a state latitude mode and a sequence latitude mode through the analysis design to the dimensions so as to form a multi-dimension database. Compared with the existing relational database, the method provided by the invention is applicable to the design of various database systems using the relational database; the operation speed of a relational database system is increased; the long-term rapid operation of the database system is ensured; the mass storage and the real time access of the database system are realized within a containable range of a storage device; and the requirement of the database system to hardware and the operation cost are reduced.

Description

technical field [0001] The invention relates to a relational database, in particular to a multidimensional design method for a relational database. Background technique [0002] Database systems are the most widely used computer application systems. The vast majority of data storage in database systems relies on relational databases (RDBEMS). Since the essence of a relational database is a linear (one-dimensional) collection of data records (relational tuples). With the increase of the running time of the database system, the amount of data in the database continues to increase, which will slow down the processing speed of the data, resulting in the slowing down of the running speed of the database system or even system blockage, and data errors and other problems. At present, the method to solve this problem is to transfer out the data in the database to reduce the amount of data in the database, so as to improve the operating speed of the database...

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 CHENGDU CHENGDIAN YIXING DIGITAL HEALTH SOFTWARE CO LTD
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