CN102609504A - Multi-dimension design method of relational database - Google Patents
Multi-dimension design method of relational database Download PDFInfo
- Publication number
- CN102609504A CN102609504A CN2012100236833A CN201210023683A CN102609504A CN 102609504 A CN102609504 A CN 102609504A CN 2012100236833 A CN2012100236833 A CN 2012100236833A CN 201210023683 A CN201210023683 A CN 201210023683A CN 102609504 A CN102609504 A CN 102609504A
- Authority
- CN
- China
- Prior art keywords
- data
- latitude
- tissue
- dimension
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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
The present invention relates to a kind of relevant database, relate in particular to a kind of multidimensional method for designing of relevant database.
Background technology
Database Systems are the most widely used computer application systems.The data storing overwhelming majority of Database Systems depends on relevant database (RDBEMS).Because the essence of relevant database is the data recording linearity of (concerning tuple) (one dimension) set.Along with the Database Systems growth of working time, the data of database amount constantly increases, and can make processing speed of data slack-off, causes the slack-off even system jams of travelling speed of Database Systems, and problems such as error in data take place.Present ways of addressing this issue, the one, produce the data in the database, reduce the data volume in the database, to improve the travelling speed of Database Systems.But this is long-term for needs, the Database Systems of mass data real-time online, is infeasible.The 2nd, dispose better hardware (server, switch, network etc.), to improve the travelling speed of Database Systems.This has just increased the operating cost of Database Systems.
Summary of the invention
The object of the invention just is to provide a kind of problem that exists to system R; On the basis of relevant database; Adopt a kind of data organization and design Storage of multidimensional, set up data model storage, realize the multidimensional storage administration of relevant database from aspects such as the time dimension of data, ownership dimension, professional dimension, data mode dimension, sequence dimensions; Improve the line speed of Database Systems fortune; The Long-term Real-time of the mass data of assurance Database Systems is online, and the mass storage of fulfillment database system and the unification of real time access reduce Database Systems to the requirement of hardware and the multidimensional method for designing of system operation cost.
To achieve these goals, the technical scheme of the present invention's employing is: a kind of multidimensional method for designing of relevant database comprises relevant database;
The data latitude is analyzed, and the data in the relevant database is carried out the dimension of time, ownership, business, state and sequence and analyzes design;
The foundation of data latitude pattern is analyzed design through dimension, and Time Created, latitude pattern, ownership latitude pattern, professional latitude pattern, state latitude pattern and sequence latitude pattern formed multidimensional database.
By the dimension pattern of following method design data, dividing data storehouse or tables of data,
Time latitude pattern, the time dimension tissue and the storage of pressing data message according to the size of the data volume of the different time of data, are set up the tissue and the memory module of data;
Ownership latitude pattern press the ownership dimension tissue of data message and is stored, and according to the difference of the object of attribution data, sets up the tissue and the memory module of data;
Professional latitude pattern press the professional dimension tissue of data message and is stored, and different according to data management demand and business are set up the tissue and the memory module of data;
State latitude pattern, the state dimension tissue and the storage of pressing data message, according to data mode difference, set up the tissue and the memory module of data;
Sequence latitude pattern, the sequence dimension tissue and the storage of pressing data message, according to data sequence difference, set up the tissue and the memory module of data
Compared with prior art, the invention has the advantages that:
1, is applicable to the design of the Database Systems of various use relevant databases;
2, improve the travelling speed of system R, guaranteed the long-term operation fast of Database Systems;
3, under the open ended scope of storage facilities, fulfillment database system mass storage and real time access;
4, reduce the requirement of Database Systems, reduce operating cost hardware.
Description of drawings
Fig. 1 is the principle schematic of invention.
Embodiment
To combine accompanying drawing that the present invention is described further below.
Embodiment 1: referring to Fig. 1, a kind of multidimensional method for designing of relevant database comprises relevant database;
The data latitude is analyzed, and the data in the relevant database is carried out the dimension of time, ownership, business, state and sequence and analyzes design;
The foundation of data latitude pattern is analyzed design through dimension, and Time Created, latitude pattern, ownership latitude pattern, professional latitude pattern, state latitude pattern and sequence latitude pattern formed multidimensional database.
By the dimension pattern of following method design data, dividing data storehouse or tables of data,
Time latitude pattern, the time dimension tissue and the storage of pressing data message.According to the size of the data volume of the different time of data, set up the tissue and the memory module of data.Dividing data storehouse or tables of data such as the year of for example, taking place, season, monthly, ten days, week by data.
Ownership latitude pattern, the ownership dimension tissue and the storage of pressing data message.According to the difference of the object of attribution data, set up the tissue and the memory module of data.For example, by dividing data storehouse or tables of data such as the personnel under the data, user, department, units.
Professional latitude pattern, the professional dimension tissue and the storage of pressing data message.According to data management demand and professional different, set up the tissue and the memory module of data.For example: by dividing data storehouse or tables of data such as the scope of business of data, service management scopes.
State latitude pattern, the state dimension tissue and the storage of pressing data message.According to data mode difference, set up the tissue and the memory module of data.For example, by data be dynamic, non-dynamically, dividing data storehouse or tables of data such as use whether often.
Sequence latitude pattern, the sequence dimension tissue and the storage of pressing data message.According to data sequence difference, set up the tissue and the memory module of data.For example: by dividing data storehouse or tables of data such as the coded sequence of data, mantissa's sequences.
The above method of integrated use realizes the multidimensional of design data, makes up multidimensional database or tables of data.Solve information sharing and information stores, system running speed problem, guarantee the long-term operation fast and the long-term online needs of data of Database Systems, the unification of fulfillment database system mass storage and real time access.
Claims (2)
1. the multidimensional method for designing of a relevant database is characterized in that: comprise relevant database;
The data latitude is analyzed, and the data in the relevant database is carried out the dimension of time, ownership, business, state and sequence and analyzes design;
The foundation of data latitude pattern is analyzed design through dimension, and Time Created, latitude pattern, ownership latitude pattern, professional latitude pattern, state latitude pattern and sequence latitude pattern formed multidimensional database.
2. according to the multidimensional method for designing of the said a kind of relevant database of claim 1, it is characterized in that: by the dimension pattern of following method design data, dividing data storehouse or tables of data,
Time latitude pattern, the time dimension tissue and the storage of pressing data message according to the size of the data volume of the different time of data, are set up the tissue and the memory module of data;
Ownership latitude pattern press the ownership dimension tissue of data message and is stored, and according to the difference of the object of attribution data, sets up the tissue and the memory module of data;
Professional latitude pattern press the professional dimension tissue of data message and is stored, and different according to data management demand and business are set up the tissue and the memory module of data;
State latitude pattern, the state dimension tissue and the storage of pressing data message, according to data mode difference, set up the tissue and the memory module of data;
Sequence latitude pattern, the sequence dimension tissue and the storage of pressing data message, according to data sequence difference, set up the tissue and the memory module of data.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012100236833A CN102609504A (en) | 2012-02-03 | 2012-02-03 | Multi-dimension design method of relational database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012100236833A CN102609504A (en) | 2012-02-03 | 2012-02-03 | Multi-dimension design method of relational database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102609504A true CN102609504A (en) | 2012-07-25 |
Family
ID=46526876
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2012100236833A Pending CN102609504A (en) | 2012-02-03 | 2012-02-03 | Multi-dimension design method of relational database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102609504A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104516894A (en) * | 2013-09-27 | 2015-04-15 | 国际商业机器公司 | Method and device for managing time series database |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
-
2012
- 2012-02-03 CN CN2012100236833A patent/CN102609504A/en active Pending
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104516894A (en) * | 2013-09-27 | 2015-04-15 | 国际商业机器公司 | Method and device for managing time series database |
CN104516894B (en) * | 2013-09-27 | 2018-08-17 | 国际商业机器公司 | Method and apparatus for managing time series databases |
US10229129B2 (en) | 2013-09-27 | 2019-03-12 | International Business Machines Corporation | Method and apparatus for managing time series database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107038162A (en) | Real time data querying method and system based on database journal | |
CN103902653A (en) | Method and device for creating data warehouse table blood relationship graph | |
CN103036921B (en) | A kind of user behavior analysis system and method | |
CN108415964A (en) | Tables of data querying method, device, terminal device and storage medium | |
CN105630934A (en) | Data statistic method and system | |
CN104834700A (en) | Method for capturing movement data increment based on track change | |
CN108984744A (en) | A kind of non-master chain block self-propagation method | |
JP2021529367A (en) | Dynamic incremental update of data cube | |
CN102591935A (en) | Distributive data storage management method and distributive data storage management system | |
CN109388635A (en) | A kind of data storage method of the multi-value data based on binary system and dictionary table | |
CN101639851B (en) | Method for storing and querying data and devices thereof | |
CN109446167A (en) | A kind of storage of daily record data, extracting method and device | |
CN107301249A (en) | A kind of file access information recording method, system and distributed cluster system | |
CN103825957A (en) | Design and realization method of mobile phone and other mobile learning systems based on cloud computing | |
CN102609504A (en) | Multi-dimension design method of relational database | |
CN103473316A (en) | Data column dynamically displaying method and device | |
CN108052657A (en) | A kind of service label computational methods, system, equipment and computer storage media | |
CN103942634A (en) | Group consolidated statement offset number data processing method and system | |
CN106156162A (en) | Data base querying amount statistical method and equipment | |
CN103455575A (en) | Method and device for statistic analysis of data | |
CN105205168B (en) | A kind of exposure system and its operating method based on Redis databases | |
Sreekanth et al. | Big data electronic health records data management and analysis on cloud with MongoDB: a NoSQL database | |
Zhao et al. | A MapReduce framework for on-road mobile fossil fuel combustion CO 2 emission estimation | |
GB2534448A (en) | Managing customs information | |
CN107301239A (en) | A kind of database converter and conversion method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120725 |