WO2015131579A1

WO2015131579A1 - Data storage method, apparatus and system

Info

Publication number: WO2015131579A1
Application number: PCT/CN2014/092508
Authority: WO
Inventors: 陈波
Original assignee: 中兴通讯股份有限公司
Priority date: 2014-10-15
Filing date: 2014-11-28
Publication date: 2015-09-11
Also published as: CN105574027A; CN105574027B

Abstract

A data storage method, apparatus and system, the method comprising: providing database tables having columns and rows (S10); and storing together multidimensional performance data in one of the database tables (S20). Hybrid applications of OLTP/OLAP big data can be supported, TDD/FDD performance data can be simultaneously stored in one table, and multidimensional (time, location, system) analysis is supported.

Description

Data storage method, device and system

Technical field

The present invention relates to the field of data storage technologies, and in particular, to a data storage method, apparatus, and system.

Background technique

With the wide application of database technology, information systems generate a large amount of data. How to extract useful information from decision-making analysis from these massive data has gradually become an important problem faced by decision-making managers.

Today's data processing systems can be broadly divided into two categories: OLTP (On-Line Transaction Processing) and OLAP (On-Line Analytical Processing). OLTP is the primary application of traditional relational databases, primarily for basic, day-to-day transactions, such as banking transactions. OLAP is the primary application of data warehousing systems, supporting complex analysis operations, focusing on decision support, and providing intuitive and understandable query results.

At present, OLTP and OLAP applications are often difficult to directly integrate. Software developers and users have to spend a lot of manpower and resources to build and support two sets of data processing systems, increasing the cost of the cost. Moreover, in the scenario of multi-mode fusion, performance data such as TDD (Time Division Duplexing)/FDD (Frequency Division Duplexing) requires different tables for storage, even for 2G (Second Generation, Second generation mobile communication technology), 3G (abbreviation of 3rd Generation, third generation mobile communication technology), and 4G (The 4 Generation mobile communication technology) performance data require different databases for storage As a result, a large amount of hardware and software resources are consumed, and maintenance difficulty is also increased.

Therefore, how to provide a method for supporting multi-dimensional performance data storage is a technical problem to be solved.

Summary of the invention

The technical problem to be solved by the present invention is to provide a data storage method and system to overcome related The technical storage method cannot simultaneously support the unified storage of TDD/FDD multi-dimensional performance data and the problem of supporting OLTP/OLAP hybrid applications.

In order to solve the above technical problems, the following technical solutions are adopted:

A data storage method comprising:

Provide a database table with columns and rows;

The multi-dimensional performance data is uniformly stored in the database table.

Optionally, the multi-dimensional performance data includes: a field of a time dimension, a field of a location dimension, a field of a multi-model, and a field of a performance counter, wherein the multi-mode field is used to record a time division duplex TDD or Frequency division duplex FDD multimode performance data.

Optionally, the method further includes establishing a plurality of separate indexes or composite indexes on the multi-dimensional fields of the database table according to the actual service application.

A data storage device includes a setting unit and a storage unit, wherein:

The setting unit is configured to: provide a database table having a column and a row;

The storage unit is configured to uniformly store the multi-dimensional performance data in the database table.

Optionally, the multi-dimensional performance data includes: a field of a time dimension, a field of a location dimension, a field of a multi-mode, a field of a performance counter, wherein the multi-mode field is used to record a time division duplex TDD or Frequency division duplex FDD multimode performance data.

Optionally, the apparatus further includes an indexing unit, wherein:

The indexing unit is configured to: establish a plurality of individual indexes or composite indexes on the multi-dimensional fields of the database table according to an actual service application.

A database system comprising any of the above data storage devices.

A computer program comprising program instructions which, when executed by a computer, cause the computer to perform any of the above described data storage methods.

A carrier carrying the computer program.

It can be seen that the technical solution of the present invention can support the mixed application of OLTP/OLAP big data, and the TDD/FDD performance data can be simultaneously stored in one table, and supports multiple dimensions (time, location, standard). )analysis.

BRIEF abstract

1 is a schematic flowchart of a data storage method according to an embodiment of the present invention;

2 is a schematic structural diagram of a data storage device according to an embodiment of the present invention.

The implementation, functional features and excellent effects of the object of the present invention will be further described below in conjunction with the specific embodiments and the accompanying drawings.

Preferred embodiment of the invention

The technical solutions of the present invention are further described in detail below with reference to the accompanying drawings and specific embodiments, but the embodiments are not intended to limit the invention.

As shown in FIG. 1 , it shows a data storage method provided by an embodiment of the present invention. Specifically, the method provided by the embodiment of the present invention includes the following specific steps:

S10. Providing a database table having a column and a row;

S20. The multi-dimensional performance data is uniformly stored in one of the database tables.

In this embodiment, the multi-dimensional fields of the multi-dimensional performance data are uniformly stored in the same database table, wherein the TDD and FDD multi-mode performance data are designed as multi-dimensional dimension fields, which is designed. TDD and FDD data can be processed simultaneously in applications such as OLTP real-time warehousing and OLAP multi-dimensional analysis. It can be seen that the embodiment of the present invention can support mixed application of OLTP/OLAP big data, support unified storage of TDD/FDD multi-mode performance data, support real-time OLTP big data storage, and support OLAP multi-dimensional data extraction analysis (for example, support multi-dimensional time, Position, system analysis).

In this embodiment, as shown in the database table structure shown in Table 1, the multi-dimensional performance data includes: a time dimension field 101, a location dimension field 102, a multi-model field 103, and a performance counter field 104, where The multi-mode field 103 is used to record time division duplex TDD or frequency division duplex FDD multimode performance data.

Table I

In an optional implementation manner, after providing a database table having columns and rows, a plurality of separate indexes or composite indexes are also established for the multi-dimensional fields of the database table according to actual business applications. According to the actual business application, such as the demand according to the time and location query, then the index of the time and location dimension is established, such as begintime+sbnid+neid+cellid to establish a composite index; for the dimension field ltefdd, lttedd, if this After the data table needs to support the new dimension, it is not suitable for indexing. For the counter field, the possibility of increasing or decreasing is also large, and the number of counters is generally large, and is not often used as a query filtering condition, so it is not suitable for indexing. For column storage databases such as SybaseIQ, since each field of the column storage database has an index by default, the index problem is not very prominent.

In this embodiment, multiple multi-dimensional fields of multi-dimensional performance data are uniformly stored in the same database table, and multiple independent indexes or complex multiple multi-dimensional fields are established according to actual business application requirements. Indexing, in this way, OLTP real-time warehousing, OLAP multi-dimensional analysis and other applications can simultaneously process TDD and FDD data.

As shown in FIG. 2, an embodiment of the present invention provides a data storage device, including:

The setting unit 100 is configured to: provide a database table having a column and a row;

The storage unit 200 is configured to: uniformly store the multi-dimensional performance data in one of the database tables.

The setting unit 100 of the present embodiment uniformly stores the multi-dimensional fields of the multi-dimensional performance data in the same database table, wherein the TDD and FDD multi-mode performance data are designed as multi-dimensional dimension fields, so that the storage unit performs OLTP at 200. TDD and FDD data can be processed simultaneously in applications such as real-time storage and OLAP multidimensional analysis. It can be seen that the embodiment of the present invention can support mixed application of OLTP/OLAP big data, support unified storage of TDD/FDD multi-mode performance data, support real-time OLTP big data storage, and support OLAP multi-dimensional data extraction analysis (for example, support multi-dimensional time, Position, system analysis).

In this embodiment, referring to Table 1, the multi-dimensional performance data includes: a field 101 of a time dimension, a field 102 of a location dimension, a field 103 of a multi-model, and a field 104 of a performance counter, wherein the multi-dimensional The molded field 103 is set to record time division duplex TDD or frequency division duplex FDD multimode performance data.

In an optional implementation manner, with reference to FIG. 2, the data storage device further includes:

The index unit 300, after the setting unit 100 provides a database table having a column and a row, the index unit 300 is configured to: create a plurality of multi-dimensional fields of the database table according to an actual service application. A separate index or composite index. According to the actual business application, such as the demand according to the time and location query, then the index of the time and location dimension is established, such as begintime+sbnid+neid+cellid to establish a composite index; for the dimension field ltefdd, lttedd, if this After the data table needs to support the new dimension, it is not suitable for indexing. For the counter field, the possibility of increasing or decreasing is also large, and the number of counters is generally large, and is not often used as a query filtering condition, so it is not suitable for indexing. For column storage databases such as SybaseIQ, since each field of the column storage database has an index by default, the index problem is not very prominent.

In this embodiment, the setting unit 100 stores the multi-dimensional fields of the multi-dimensional performance data in the same database table, and the index unit 300 establishes multiple individual indexes or composite indexes for the multi-dimensional fields according to actual business application requirements. The storage unit 200 can simultaneously process TDD and FDD data when performing applications such as real-time OLTP storage and OLAP multi-dimensional analysis.

The embodiment of the present invention further provides a database system, including:

The storage device is configured to: provide a database table having a column and a row, and further configured to: uniformly store the multi-dimensional performance data in one of the database tables.

The storage device uniformly stores the multi-dimensional fields of the multi-dimensional performance data in the same database table, wherein the TDD and FDD multi-mode performance data are designed as multi-dimensional dimension fields, so that OLTP real-time storage and OLAP are performed. TDD and FDD data can be processed simultaneously in applications such as multidimensional analysis. It can be seen that the embodiment of the present invention can support mixed application of OLTP/OLAP big data, support unified storage of TDD/FDD multi-mode performance data, support real-time OLTP big data storage, and support OLAP multi-dimensional data extraction analysis (for example, support multi-dimensional time, Position, system analysis).

Continuing to refer to Table 1, specifically, the multi-dimensional performance data includes: a field 101 of a time dimension, a field 102 of a location dimension, a field 103 of a multi-model, and a field 104 of a performance counter, wherein the multi-mode The field of 103 is used to record time division duplex TDD or frequency division duplex FDD multimode performance data.

In an optional implementation manner, after providing the database table with the column and the row, the storage device is further configured to: establish multiple separate indexes on the multi-dimensional field of the database table according to the actual service application. Or composite index.

The storage device stores the multi-dimensional fields of the multi-dimensional performance data in the same database table, and establishes multiple independent indexes or composite indexes for the multi-dimensional fields according to actual business application requirements, so that the OLTP is stored in real time. TDD and FDD data can be processed simultaneously in applications such as OLAP multidimensional analysis.

The method and the device in the embodiment of the present invention may be based on the OLTP/OLAP hybrid application, and may be based on other applications, as long as the corresponding technical problem or the corresponding technical effect can be solved, and details are not described herein again.

The above description is only an optional embodiment of the present invention, and thus does not limit the scope of the patent of the present invention. The equivalent structure or equivalent process transformations made by the present specification and the drawings are directly or indirectly applied to other related technical fields, and are included in the scope of patent protection of the present invention.

Industrial applicability

It can be seen that the technical solution of the present invention can support the mixed application of OLTP/OLAP big data, and the TDD/FDD performance data can be simultaneously stored in one table, and supports multiple dimensions (time, location, standard). )analysis. Therefore, the present invention has strong industrial applicability.

Claims

A data storage method comprising:

Provide a database table with columns and rows;

The multi-dimensional performance data is uniformly stored in the database table.
The data storage method of claim 1, wherein the multi-dimensional performance data comprises: a field of a time dimension, a field of a location dimension, a field of a multi-model, and a field of a performance counter, wherein the multi-mode The fields are used to record time division duplex TDD or frequency division duplex FDD multimode performance data.
The data storage method of claim 2, further comprising establishing a plurality of separate indexes or composite indexes on the multi-dimensional fields of the database table according to actual business applications.
A data storage device includes a setting unit and a storage unit, wherein:

The setting unit is configured to: provide a database table having a column and a row;

The storage unit is configured to uniformly store the multi-dimensional performance data in the database table.
The data storage device of claim 4, wherein the multi-dimensional performance data comprises: a field of a time dimension, a field of a location dimension, a field of a multi-model, a field of a performance counter, wherein the multi-modal The field is used to record time division duplex TDD or frequency division duplex FDD multimode performance data.
The data storage device of claim 5, further comprising an indexing unit, wherein:

The indexing unit is configured to: establish a plurality of individual indexes or composite indexes on the multi-dimensional fields of the database table according to an actual service application.
A database system comprising the data storage device of any of claims 4-6.
A computer program comprising program instructions which, when executed by a computer, cause the computer to perform the data storage method of any of claims 1-3.
A carrier carrying the computer program of claim 9.