CN105574027B - Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application - Google Patents
Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application Download PDFInfo
- Publication number
- CN105574027B CN105574027B CN201410545015.6A CN201410545015A CN105574027B CN 105574027 B CN105574027 B CN 105574027B CN 201410545015 A CN201410545015 A CN 201410545015A CN 105574027 B CN105574027 B CN 105574027B
- Authority
- CN
- China
- Prior art keywords
- field
- performance data
- database table
- multidimensional
- oltp
- 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.)
- Active
Links
Images
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
Abstract
The invention discloses a method, a device and a system for storing multidimensional performance data based on OLTP/OLAP hybrid application, wherein the method comprises the following steps: providing a database table with columns and row bits; and uniformly storing the multi-dimensional performance data in one database table. The invention can support the mixed application of OLTP/OLAP big data, TDD/FDD performance data can be simultaneously stored in a table, and multi-dimensional (time, position, standard) analysis is supported.
Description
Technical Field
The invention relates to the technical field of communication, in particular to a method, a device and a system for storing multidimensional performance data based On OLTP (On-Line transactioning Processing)/OLAP (On-Line Analytical Processing) mixed application.
Background
With the wide application of database technology, information systems generate a large amount of data, and how to extract information useful for decision analysis from the large amount of data is becoming an important problem faced by decision managers.
Today's data processing systems can be broadly divided into two broad categories: an online transaction processing system OLTP and an online analytical processing system OLAP. OLTP is the primary application of traditional relational databases, primarily for basic, everyday transactions such as banking transactions. OLAP is a major application of data warehouse systems, supports complex analytical operations, emphasizes decision support, and provides intuitive and understandable query results.
At present, OLTP and OLAP applications are often difficult to directly fuse, a software developer and a user have to spend a large amount of manpower and material resources to establish and support two sets of data processing systems, and cost expenses are increased. Also, in the scenario of multi-mode convergence, different tables are needed for storing performance data such as TDD (Time Division duplex)/FDD (Frequency Division duplex), even for 2G (Second Generation mobile communication technology), 3G (3G)rdThe abbreviation of Generation, third Generation mobile Communication technology), and performance data of 4G (The4Generation mobile Communication technology) require different databases for storage, which results in a large consumption of software and hardware resources and increases maintenance difficulty.
Therefore, how to provide a method for supporting multi-dimensional performance data storage based on OLTP/OLAP hybrid application is a technical problem to be solved urgently.
Disclosure of Invention
In order to solve the problem that the existing storage method cannot simultaneously support the unified storage of TDD/FDD multi-dimensional performance data and the hybrid OLTP/OLAP application, the embodiment of the invention provides a TDD/FDD multi-dimensional performance data storage method and a system based on the hybrid OLTP/OLAP application. The method and system can support TDD/FDD multi-dimensional performance data and support hybrid OLTP/OLAP applications.
In order to achieve the purpose of the invention, the invention is realized by adopting the following technical scheme:
a multidimensional performance data storage method based on OLTP/OLAP mixed application comprises the following steps:
providing a database table with columns and row bits;
and uniformly storing the multi-dimensional performance data in one database table.
Preferably, the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
Preferably, a plurality of separate indexes or compound indexes are established for the multidimensional fields of the database table according to actual business application.
A multi-dimensional performance data storage device based on OLTP/OLAP hybrid application comprises:
a setting unit, which is used for providing a database table with a column (column) and a row (row);
and the storage unit is used for uniformly storing the multi-dimensional performance data in one database table.
Preferably, the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
Preferably, the apparatus for storing multidimensional performance data based on OLTP/OLAP hybrid application further includes:
and the index unit is used for establishing a plurality of single indexes or compound indexes for the multidimensional field of the database table according to actual service application.
A database system, comprising:
the device comprises a storage device, a processing device and a processing device, wherein the storage device is used for providing a database table with columns and row bits and further used for uniformly storing multi-dimensional performance data in one database table.
Preferably, the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
Preferably, the storage device is further configured to create a plurality of individual indexes or compound indexes for the multidimensional field of the database table according to actual business applications.
According to the technical scheme of the embodiment of the invention, the method can support mixed application of OLTP/OLAP big data, TDD/FDD performance data can be simultaneously stored in a table, and multi-dimensional (time, position and standard) analysis is supported.
Drawings
FIG. 1 is a schematic flow chart of a multidimensional performance data storage method based on OLTP/OLAP hybrid application according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a database table structure according to an embodiment of the present invention;
fig. 3 is a functional structure diagram of a multidimensional performance data storage device based on OLTP/OLAP hybrid application according to an embodiment of the present invention.
The object of the present invention, its functional characteristics and advantageous effects will be further described with reference to the following embodiments and drawings.
Detailed Description
The technical solutions of the present invention are further described in detail below with reference to the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not limited to the present invention.
As shown in fig. 1, a method for storing multidimensional performance data based on OLTP/OLAP hybrid application provided by the embodiment of the present invention is shown, and specifically, the method provided by the embodiment of the present invention includes the following specific steps:
s10, providing a database table with columns and row bits;
and S20, uniformly storing the multi-dimensional performance data in one database table.
In this embodiment, multidimensional fields of multidimensional performance data are uniformly stored in the same database table, wherein TDD and FDD multimode performance data are designed as the multidimensional fields of multimode systems, so that TDD and FDD data can be processed simultaneously when undergoing applications such as OLTP real-time warehousing and OLAP multidimensional analysis. The invention can support the mixed application of OLTP/OLAP big data, the unified storage of TDD/FDD multi-mode performance data, the real-time storage of OLTP big data and the extraction and analysis of OLAP multi-dimensional data (such as the multi-dimensional time, position and system analysis).
In this embodiment, as shown in fig. 2, the multi-dimensional performance data includes: a field 101 of a time dimension, a field 102 of a position dimension, a field 103 of a multimode system, and a field 104 of a performance counter, wherein the field 103 of the multimode system is used for recording multimode performance data of time division duplex, TDD, and frequency division duplex, FDD.
In a preferred embodiment, after providing a database table with a field (column) and a column bit (row), a plurality of individual indexes or compound indexes are established for the multidimensional field of the database table according to actual business application.
In this embodiment, the multidimensional fields of the multidimensional performance data are uniformly stored in the same database table, and a plurality of individual indexes or composite indexes are established for the multidimensional fields according to actual business application requirements, so that TDD and FDD data can be simultaneously processed when applications such as OLTP real-time storage, OLAP multidimensional analysis and the like are performed.
As shown in fig. 3, an embodiment of the present invention provides a multidimensional performance data storage device based on OLTP/OLAP hybrid application, including:
a setting unit 100, configured to provide a database table with columns and row bits;
the storage unit 200 is configured to store the multidimensional performance data in one database table.
The setting unit 100 of this embodiment uniformly stores multidimensional fields of multidimensional performance data in the same database table, wherein TDD and FDD multimode performance data are designed as the multidimensional fields of multimode systems, so that the storage unit can process TDD and FDD data simultaneously when the storage unit 200 performs applications such as OLTP real-time warehousing and OLAP multidimensional analysis. The invention can support the mixed application of OLTP/OLAP big data, the unified storage of TDD/FDD multi-mode performance data, the real-time storage of OLTP big data and the extraction and analysis of OLAP multi-dimensional data (such as the multi-dimensional time, position and system analysis).
In this embodiment, as shown in fig. 2, the multi-dimensional performance data includes: a field 101 of a time dimension, a field 102 of a position dimension, a field 103 of a multimode system, and a field 104 of a performance counter, wherein the field 103 of the multimode system is used for recording multimode performance data of time division duplex, TDD, and frequency division duplex, FDD.
In a preferred embodiment, with continued reference to fig. 3, the multidimensional performance data storage device based on OLTP/OLAP hybrid application further includes:
the indexing unit 300 is configured to, after the setting unit 100 provides a database table with a field (column) and a row bit (row), establish a plurality of individual indexes or composite indexes for multidimensional fields of the database table according to actual service application by the indexing unit 300.
In this embodiment, the setting unit 100 uniformly stores multidimensional fields of multidimensional performance data in the same database table, and the indexing unit 300 establishes a plurality of individual indexes or composite indexes for the multidimensional fields according to actual business application requirements, so that the storage unit 200 can process TDD and FDD data simultaneously when performing applications such as OLTP real-time warehousing and OLAP multidimensional analysis.
The embodiment of the invention also correspondingly provides a database system, which comprises:
the device comprises a storage device, a processing device and a processing device, wherein the storage device is used for providing a database table with columns and row bits and further used for uniformly storing multi-dimensional performance data in one database table.
The storage device stores multidimensional fields of multidimensional performance data in the same database table, wherein the TDD and FDD multimode performance data are designed as the multidimensional fields of multimode systems, so that the TDD and FDD data can be processed simultaneously when OLTP real-time storage, OLAP multidimensional analysis and other applications are carried out. The invention can support the mixed application of OLTP/OLAP big data, the unified storage of TDD/FDD multi-mode performance data, the real-time storage of OLTP big data and the extraction and analysis of OLAP multi-dimensional data (such as the multi-dimensional time, position and system analysis).
Continuing with FIG. 2, in particular, the multi-dimensional performance data includes: a field 101 of a time dimension, a field 102 of a position dimension, a field 103 of a multimode system, and a field 104 of a performance counter, wherein the field of the multimode system 103 is used for recording multimode performance data of time division duplex, TDD, and frequency division duplex, FDD.
In a preferred embodiment, after providing a database table with fields (columns) and column bits (rows), the storage device is further configured to establish a plurality of individual indexes or compound indexes for the multidimensional fields of the database table according to actual business applications.
The storage device uniformly stores the multidimensional fields of the multidimensional performance data in the same database table, and establishes a plurality of independent indexes or compound indexes for the multidimensional fields according to the actual business application requirements, so that TDD (time division duplex) and FDD (frequency division duplex) data can be processed simultaneously when OLTP (on-line transaction processing) real-time storage, OLAP (on-line analytical) multidimensional analysis and other applications are carried out.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (6)
1. A multidimensional performance data storage method based on OLTP/OLAP mixed application is characterized by comprising the following steps:
providing a database table with columns and row bits;
uniformly storing the multidimensional performance data in one database table;
wherein the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
2. The OLTP/OLAP hybrid application-based multidimensional performance data storage method of claim 1, wherein a plurality of separate indexes or compound indexes are established for multidimensional fields of the database table according to actual business applications.
3. A multidimensional performance data storage device based on OLTP/OLAP hybrid application is characterized by comprising:
a setting unit, which is used for providing a database table with a column (column) and a row (row);
the storage unit is used for uniformly storing the multi-dimensional performance data in one database table;
wherein the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
4. The OLTP/OLAP hybrid application based multi-dimensional performance data storage device of claim 3, further comprising:
and the index unit is used for establishing a plurality of single indexes or compound indexes for the multidimensional field of the database table according to actual service application.
5. A database system, comprising:
the storage device is used for providing a database table with columns and row bits and further used for uniformly storing the multi-dimensional performance data in one database table;
wherein the multi-dimensional performance data comprises: the system comprises a field of time dimension, a field of position dimension, a field of multimode system and a field of performance counter, wherein the field of multimode system is used for recording multimode performance data of time division duplex TDD and frequency division duplex FDD.
6. The database system of claim 5, wherein the storage device is further configured to build a plurality of individual indices or compound indices to the multidimensional field of the database table based on actual business applications.
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 CN105574027A (en) | 2016-05-11 |
| CN105574027B true 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) |
Families Citing this family (4)
| 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 |
| CN109635042B (en) * | 2018-12-07 | 2022-06-14 | 厦门铅笔头信息科技有限公司 | OLTP and OLAP integrated automobile financial big data system |
| 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 |
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 |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2015131579A1 (en) | 2015-09-11 |
| CN105574027A (en) | 2016-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220035815A1 (en) | Processing database queries using format conversion | |
| US8650181B2 (en) | OLAP execution model using relational operations | |
| US9965504B2 (en) | Transient and persistent representation of a unified table metadata graph | |
| US9483513B2 (en) | Storing large objects on disk and not in main memory of an in-memory database system | |
| US9256665B2 (en) | Creation of inverted index system, and data processing method and apparatus | |
| EP2608071A1 (en) | Hybrid database table stored as both row and column store | |
| CN105574027B (en) | Multi-dimensional performance data storage method, device and system based on OLTP/OLAP hybrid application | |
| CN107729399B (en) | Data processing method and device | |
| CN104252536A (en) | Hbase-based internet log data inquiring method and device | |
| CN103440288A (en) | Big data storage method and device | |
| US10685031B2 (en) | Dynamic hash partitioning for large-scale database management systems | |
| US9959312B2 (en) | High performance index creation on sorted data using parallel query plans | |
| US10762068B2 (en) | Virtual columns to expose row specific details for query execution in column store databases | |
| US10055471B2 (en) | Integrated big data interface for multiple storage types | |
| WO2019228015A1 (en) | Index creating method and apparatus based on nosql database of mobile terminal | |
| CN114461603A (en) | Multi-source heterogeneous data fusion method and device | |
| CN109359141B (en) | Visual report data display method and device | |
| CN103858121A (en) | Method and system for making Web application obtain database change | |
| CN114238379A (en) | Report query method and system based on SQL generator | |
| US20170195449A1 (en) | Smart proxy for datasources | |
| Ranawade et al. | Online analytical processing on hadoop using apache kylin | |
| CN111078728B (en) | Cross-database query method and device in database archiving mode | |
| CN109542912B (en) | Interval data storage method, device, server and storage medium | |
| US9058344B2 (en) | Supporting flexible types in a database | |
| CN110019192B (en) | Database retrieval method and 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 |