CN105574027A - On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system - Google Patents
On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system Download PDFInfo
- Publication number
- CN105574027A CN105574027A CN201410545015.6A CN201410545015A CN105574027A CN 105574027 A CN105574027 A CN 105574027A CN 201410545015 A CN201410545015 A CN 201410545015A CN 105574027 A CN105574027 A CN 105574027A
- Authority
- CN
- China
- Prior art keywords
- field
- various dimensions
- performance data
- oltp
- olap
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an on-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system. The method comprises the following steps of providing a database table with columns and rows; and storing multi-dimensional performance data in the database table. By the method, the device and the system, hybrid application of OLTP/OLAP big data can be supported, time division duplexing/frequency division duplexing (TDD/FDD) performance data can be stored in the table, and multi-dimensional (time, position and system) analysis is supported.
Description
Technical field
The present invention relates to communication technical field, specifically, relate to a kind of based on OLTP (On-LineTransactionProcessing, online transaction processing system)/OLAP (On-LineAnalyticalProcessing, on-line analysing processing system) mixing application lower various dimensions performance data storage means, Apparatus and system.
Background technology
Along with the widespread use of database technology, infosystem creates a large amount of data, and from these mass datas, how to extract the information useful to decision analysis becomes the important problem that decision-making management personnel face gradually.
Current data handling system roughly can be divided into two large class: online transaction processing system OLTP and on-line analysing processing system OLAP.OLTP is the main application of traditional relevant database, mainly such as, for basic, daily issued transaction, bank transaction.OLAP is the main application of data warehouse, supports complicated analysis operation, stresses decision support, and provide visual and understandable Query Result.
At present, OLTP and OLAP application is difficult to directly to merge often, and software development side and user a large amount of manpower and materials of cost of having to are set up and support two sets of data disposal systems, add the spending of cost.And under the scene of multimodality fusion, for such as TDD (TimeDivisionDuplexing, time division duplex)/FDD (FrequencyDivisionDuplexing, Frequency Division Duplexing (FDD)) performance data need different tables to store, even for 2G (SecondGeneration, second generation mobile communication technology), 3G (3
rdthe abbreviation of Generation, G mobile communication) and 4G (The4GenerationmobileCommunication, forth generation mobile communication technology) performance data need different databases to store, cause a large amount of consume software and hardware resources while too increase maintenance difficulties.
Therefore, how to provide a kind of and support that the method that various dimensions performance data stores is a technical matters urgently to be resolved hurrily based on OLTP/OLAP mixing application is lower.
Summary of the invention
The problem of the unified storage of TDD/FDD various dimensions performance data and support OLTP/OLAP mixing application can not be supported to overcome existing storage means simultaneously, embodiments providing and a kind of mixing based on OLTP/OLAP applying lower TDD/FDD various dimensions performance data storage means and system.Described method and system can be supported TDD/FDD various dimensions performance data and support the mixing application of OLTP/OLAP.
In order to reach object of the present invention, the present invention realizes by the following technical solutions:
A kind of based on the lower various dimensions performance data storage means of OLTP/OLAP mixing application, comprising:
The database table with field (column) and row position (row) is provided;
Be stored in unified for various dimensions performance data among a described database table.
Preferably, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
Preferably, according to practical business application, multiple independent index or composite index are set up to the various dimensions field of described database table.
A kind of based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application, comprising:
Setting unit, for providing the database table with field (column) and row position (row);
Storage unit, for being stored in unified for various dimensions performance data among a described database table.
Preferably, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
Preferably, describedly also to comprise based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application:
Indexing units, for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
A kind of Database Systems, comprising:
Memory storage, for providing the database table with field (column) and row position (row), and is further used for being stored in unified for various dimensions performance data among a described database table.
Preferably, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
Preferably, memory storage is also for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
Can be found out by the technical scheme of the invention described above embodiment, the present invention can support that the mixing of the large data of OLTP/OLAP is applied, TDD/FDD performance data can be stored in a table simultaneously, supports various dimensions (time, position, standard) analysis.
Accompanying drawing explanation
What Fig. 1 provided for the embodiment of the present invention applies lower various dimensions performance data storage means schematic flow sheet based on OLTP/OLAP mixing;
The database table structure schematic diagram that Fig. 2 provides for the embodiment of the present invention;
The illustrative view of functional configuration based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application that Fig. 3 provides for the embodiment of the present invention.
The realization of the object of the invention, functional characteristics and excellent effect, be described further below in conjunction with specific embodiment and accompanying drawing.
Embodiment
Below in conjunction with the drawings and specific embodiments, technical scheme of the present invention is described in further detail, can better understand the present invention to make those skilled in the art and can be implemented, but illustrated embodiment is not as a limitation of the invention.
As shown in Figure 1, the one that it illustrates the embodiment of the present invention provides applies lower various dimensions performance data storage means based on OLTP/OLAP mixing, and particularly, the described method that the embodiment of the present invention provides comprises following concrete steps:
S10, provide have field (column) and row position (row) database table;
S20, to be stored in unified for various dimensions performance data among a described database table.
The present embodiment is stored in same database table by unified for the various dimensions field of various dimensions performance data, wherein the dimension field of TDD, FDD multimode behaviour data as multimode standard is designed, when carrying out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis like this, all can process TDD, FDD data simultaneously.Visible employing the present invention, can support that the mixing of the large data of OLTP/OLAP is applied, support the unified storage of TDD/FDD multimode behaviour data, support that the large data of OLTP are put in storage in real time, support OLAP multidimensional data to extract and analyze (such as support various dimensions time, position, standard analysis).
In the present embodiment, as shown in Figure 2, described various dimensions performance data comprises: the field 101 of time dimension, the field 102 of location dimension, the field 103 of multimode standard, the field 104 of performance counter, wherein, the field 103 of described multimode standard is for recording TDD or FDD multimode behaviour data.
Preferred embodiment, after the database table with field (column) and row position (row) is provided, also according to practical business application, multiple independent index or composite index are set up to the various dimensions field of described database table.
In the present embodiment, by being stored in same database table by unified for the various dimensions field of various dimensions performance data, and need to set up multiple independent index or composite index to various dimensions field according to practical business application, when carrying out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis like this, all can process TDD, FDD data simultaneously.
As shown in Figure 3, embodiments provide a kind of based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application, comprising:
Setting unit 100, for providing the database table with field (column) and row position (row);
Storage unit 200, for being stored in unified for various dimensions performance data among a described database table.
The present embodiment setting unit 100 is stored in same database table by unified for the various dimensions field of various dimensions performance data, wherein design for the dimension field of TDD, FDD multimode behaviour data as multimode standard, such storage unit all can process TDD, FDD data when 200 carry out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis simultaneously.Visible employing the present invention, can support that the mixing of the large data of OLTP/OLAP is applied, support the unified storage of TDD/FDD multimode behaviour data, support that the large data of OLTP are put in storage in real time, support OLAP multidimensional data to extract and analyze (such as support various dimensions time, position, standard analysis).
In the present embodiment, continue with reference to shown in figure 2, described various dimensions performance data comprises: the field 101 of time dimension, the field 102 of location dimension, the field 103 of multimode standard, the field 104 of performance counter, wherein, the field 103 of described multimode standard is for recording TDD or FDD multimode behaviour data.
Preferred embodiment, continue with reference to shown in figure 3, described also comprises based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application:
Indexing units 300, after setting unit 100 provides the database table with field (column) and row position (row), described indexing units 300 is for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
In the present embodiment, setting unit leads to 100 and is excessively stored in same database table by unified for the various dimensions field of various dimensions performance data, indexing units 300 needs to set up multiple independent index or composite index to various dimensions field according to practical business application, all can process TDD, FDD data when such storage unit 200 carries out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis simultaneously.
The embodiment of the present invention also accordingly provides a kind of Database Systems, comprising:
Memory storage, for providing the database table with field (column) and row position (row), and is further used for being stored in unified for various dimensions performance data among a described database table.
Described memory storage is stored in same database table by unified for the various dimensions field of various dimensions performance data, wherein the dimension field of TDD, FDD multimode behaviour data as multimode standard being designed, all can process TDD, FDD data when carrying out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis so simultaneously.Visible employing the present invention, can support that the mixing of the large data of OLTP/OLAP is applied, support the unified storage of TDD/FDD multimode behaviour data, support that the large data of OLTP are put in storage in real time, support OLAP multidimensional data to extract and analyze (such as support various dimensions time, position, standard analysis).
Continue with reference to shown in figure 2, particularly, described various dimensions performance data comprises: the field 101 of time dimension, the field 102 of location dimension, the field 103 of multimode standard, the field 104 of performance counter, wherein, the field of described multimode standard 103 is for recording TDD or FDD multimode behaviour data.
Preferred embodiment, after providing the database table with field (column) and row position (row), memory storage is also for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
Described memory storage is by being stored in same database table by unified for the various dimensions field of various dimensions performance data, and need to set up multiple independent index or composite index to various dimensions field according to practical business application, all can process TDD, FDD data when carrying out the application such as OLTP puts in storage in real time, OLAP multidimensional analysis so simultaneously.
The foregoing is only the preferred embodiments of the present invention; not thereby the scope of the claims of the present invention is limited; every utilize instructions of the present invention and accompanying drawing content to do equivalent structure or equivalent flow process conversion; or be directly or indirectly used in other relevant technical fields, be all in like manner included in scope of patent protection of the present invention.
Claims (9)
1., based on the lower various dimensions performance data storage means of OLTP/OLAP mixing application, it is characterized in that, comprising:
The database table with field (column) and row position (row) is provided;
Be stored in unified for various dimensions performance data among a described database table.
2. as right profit requires that mixing based on OLTP/OLAP as described in 1 applies lower various dimensions performance data storage means, it is characterized in that, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
3., as right profit requires that mixing based on OLTP/OLAP as described in 2 applies lower various dimensions performance data storage means, it is characterized in that, according to practical business application, multiple independent index or composite index are set up to the various dimensions field of described database table.
4., based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application, it is characterized in that, comprising:
Setting unit, for providing the database table with field (column) and row position (row);
Storage unit, for being stored in unified for various dimensions performance data among a described database table.
5. as claimed in claim 4 based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application, it is characterized in that, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
6., as claimed in claim 5 based on the lower various dimensions performance data memory storage of OLTP/OLAP mixing application, it is characterized in that, also comprise:
Indexing units, for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
7. Database Systems, is characterized in that, comprising:
Memory storage, for providing the database table with field (column) and row position (row), and is further used for being stored in unified for various dimensions performance data among a described database table.
8. Database Systems as claimed in claim 7, it is characterized in that, described various dimensions performance data comprises: the field of time dimension, the field of location dimension, the field of multimode standard, the field of performance counter, wherein, the field of described multimode standard is for recording TDD or FDD multimode behaviour data.
9. Database Systems as claimed in claim 8, is characterized in that, memory storage is also for setting up multiple independent index or composite index according to practical business application to the various dimensions field of described database table.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410545015.6A CN105574027B (en) | 2014-10-15 | 2014-10-15 | Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application |
| PCT/CN2014/092508 WO2015131579A1 (en) | 2014-10-15 | 2014-11-28 | Data storage method, apparatus and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410545015.6A CN105574027B (en) | 2014-10-15 | 2014-10-15 | Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105574027A true CN105574027A (en) | 2016-05-11 |
| CN105574027B CN105574027B (en) | 2020-04-24 |
Family
ID=54054460
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410545015.6A Active CN105574027B (en) | 2014-10-15 | 2014-10-15 | Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN105574027B (en) |
| WO (1) | WO2015131579A1 (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614402A (en) * | 2018-12-11 | 2019-04-12 | 北京京东金融科技控股有限公司 | Multidimensional data query method and device |
| CN109635042A (en) * | 2018-12-07 | 2019-04-16 | 厦门铅笔头信息科技有限公司 | OLTP and the integrated auto metal halide lamp big data system of OLAP |
| CN110019251A (en) * | 2019-03-22 | 2019-07-16 | 深圳市腾讯计算机系统有限公司 | A kind of data processing system, method and apparatus |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391666B (en) * | 2017-07-20 | 2020-09-29 | 上海达梦数据库有限公司 | Method and device for generating composite index key value |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101217755A (en) * | 2007-12-26 | 2008-07-09 | 中兴通讯股份有限公司 | A front-end processor system and method applied for data acquisition |
| CN101790257A (en) * | 2009-01-22 | 2010-07-28 | 大唐移动通信设备有限公司 | Method for memorizing data and network management system |
| CN101968806A (en) * | 2010-10-22 | 2011-02-09 | 天津南大通用数据技术有限公司 | Data storage method, querying method and device |
| CN102497661A (en) * | 2011-12-16 | 2012-06-13 | 清华大学 | Heterogeneous network selection method based on transmitting power of terminal |
| CN103942342A (en) * | 2014-05-12 | 2014-07-23 | 中国人民大学 | Memory database OLTP and OLAP concurrency query optimization method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6205447B1 (en) * | 1997-06-30 | 2001-03-20 | International Business Machines Corporation | Relational database management of multi-dimensional data |
-
2014
- 2014-10-15 CN CN201410545015.6A patent/CN105574027B/en active Active
- 2014-11-28 WO PCT/CN2014/092508 patent/WO2015131579A1/en active Application Filing
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101217755A (en) * | 2007-12-26 | 2008-07-09 | 中兴通讯股份有限公司 | A front-end processor system and method applied for data acquisition |
| CN101790257A (en) * | 2009-01-22 | 2010-07-28 | 大唐移动通信设备有限公司 | Method for memorizing data and network management system |
| CN101968806A (en) * | 2010-10-22 | 2011-02-09 | 天津南大通用数据技术有限公司 | Data storage method, querying method and device |
| CN102497661A (en) * | 2011-12-16 | 2012-06-13 | 清华大学 | Heterogeneous network selection method based on transmitting power of terminal |
| CN103942342A (en) * | 2014-05-12 | 2014-07-23 | 中国人民大学 | Memory database OLTP and OLAP concurrency query optimization method |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109635042A (en) * | 2018-12-07 | 2019-04-16 | 厦门铅笔头信息科技有限公司 | OLTP and the integrated auto metal halide lamp big data system of OLAP |
| CN109635042B (en) * | 2018-12-07 | 2022-06-14 | 厦门铅笔头信息科技有限公司 | OLTP and OLAP integrated automobile financial big data system |
| CN109614402A (en) * | 2018-12-11 | 2019-04-12 | 北京京东金融科技控股有限公司 | Multidimensional data query method and device |
| CN109614402B (en) * | 2018-12-11 | 2020-09-29 | 京东数字科技控股有限公司 | Multidimensional data query method and device |
| CN110019251A (en) * | 2019-03-22 | 2019-07-16 | 深圳市腾讯计算机系统有限公司 | A kind of data processing system, method and apparatus |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2015131579A1 (en) | 2015-09-11 |
| CN105574027B (en) | 2020-04-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102627690B1 (en) | Dimensional context propagation techniques for optimizing SKB query plans | |
| US9483513B2 (en) | Storing large objects on disk and not in main memory of an in-memory database system | |
| CN107408114B (en) | Identifying join relationships based on transactional access patterns | |
| Aboutorabiª et al. | Performance evaluation of SQL and MongoDB databases for big e-commerce data | |
| CN103440288A (en) | Big data storage method and device | |
| CN102567329B (en) | Data query method and data query system | |
| US9223832B2 (en) | Insight determination and explanation in multi-dimensional data sets | |
| CN103678339B (en) | Data backflow method and system and data access method and system in relational database | |
| WO2015041714A1 (en) | Interest-driven business intelligence systems including event-oriented data | |
| CN104536904A (en) | Data management method, equipment and system | |
| EP2526479A1 (en) | Accessing large collection object tables in a database | |
| CN102867282A (en) | Implementation method for mobile Internet-based customer service quality analysis system | |
| Caldarola et al. | Big data: A survey-the new paradigms, methodologies and tools | |
| CN104111936A (en) | Method and system for querying data | |
| CN105574027A (en) | On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system | |
| US20190311051A1 (en) | Virtual columns to expose row specific details for query execution in column store databases | |
| CN102779138A (en) | Hard disk access method of real time data | |
| US9177037B2 (en) | In-memory runtime for multidimensional analytical views | |
| CN114461603A (en) | Multi-source heterogeneous data fusion method and device | |
| CN105302730A (en) | Calculation model detection method, testing server and service platform | |
| CN104714974A (en) | Method and device for parsing and reprocessing query statement | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| CN104133891A (en) | Method for storing massive structural data based on relational database | |
| CN105930354A (en) | Storage model conversion method and device | |
| CN114077652A (en) | Data processing method based on multidimensional data cube and electronic device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |