Database partition method and device

A database and data technology, applied in the field of communication, can solve problems such as increasing query time, and achieve the effects of reducing query scanning time, improving performance, and reducing the time required

Active Publication Date: 2012-12-19
DATANG MOBILE COMM EQUIP CO LTD +1
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, with this partitioning strategy using a fixed time interval, when generating a report, the data required for the report is usually only a certain part of each partition. When scanning a partition in the form of a full table scan, it is necessary to scan every record of the partition. Therefore, many records that do not meet the conditions are scanned, which increases the query time

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
  • Database partition method and device
  • Database partition method and device
  • Database partition method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0032] refer to figure 1 , showing Embodiment 1 of a database partitioning method of the present invention, including the following steps:

[0033] Step 101, obtaining various required report types.

[0034] The type of report required can be determined according to the actual situation. Generally speaking, the year, month, and date of the performance report made by the staff change, but the time point (hour, minute, and second) remains unchanged. For example, the daily report of a bureau, The start time is 8:00 in the morning, and the end time is 8:00 in the morning of the next day. Although the date changes every time a report is made, the time point of 8:00 does not change. Even under special circumstances, the time points of some types of reports will change, but the time points of most types of reports will be relatively stable, and it is necessary to obtain reports with relatively stable time points and infrequent changes. For example, a network-wide daily report for ...

Embodiment 2

[0050] refer to figure 2 , showing a second embodiment of a database partitioning method of the present invention, including the following steps:

[0051] Step 201, obtaining various required report types.

[0052] Step 202, determine database partition rules according to time nodes in various required report types.

[0053] Step 203, write the determined database partition rules into the configuration file, and use the scheduled task to automatically create partitions according to the configuration file.

[0054] For example, for an oracle database, you can use iob as a scheduled task to automatically create partitions for the database according to the configuration file.

[0055] By writing the partition rules into the configuration file and using the scheduled task to automatically create partitions according to the configuration file, the system can automatically create partitions according to the partition rules, avoiding errors caused by human operations.

Embodiment 3

[0056] refer to image 3 , showing a third embodiment of a database partitioning method of the present invention, including the following steps:

[0057] Step 301, obtaining various required report types.

[0058] Step 302, determine database partition rules according to time nodes in various required report types.

[0059] Step 303, judge whether the query condition of the required data in the required report contains other conditions except time, if necessary, determine the database sub-partition rules according to the corresponding query condition, and proceed to step 304A; otherwise, proceed to step 304B.

[0060] In step 304A, the database is partitioned according to the determined database partition rules, and the data partitions are sub-partitioned according to the database sub-partition rules.

[0061] Step 304B, partition the database according to the determined database partition rules.

[0062] Other query conditions can be whether it is necessary to query and co...

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 provides a database partition method used for partitioning a database. The method comprises the following steps of: acquiring multiple required report forms; determining database partition rules according to time nodes of the multiple required report forms; and partitioning the database according to the determined database partition rules. The database partition method is used for analyzing the time nodes of the required reports and customizing the partition rules according to the time nodes, so that the data of various reports such as full network daily reports, busy hour reports and the like best accord with the characteristics of full partition table scanning strategies, the required data can be acquired during full partition table scanning, the scanned records which do not meet the search conditions reach the minimum, the time required for searching and scanning is reduced, the full table scanning efficiency is improved, and many original conditions of needing index scanning are changed into conditions of full table scanning. The invention also provides a database partition device.

Description

Technical field [0001] The invention involves the field of communication technology, especially a database partition method and partitioning device. Background technique [0002] At present, with the rapid development of communication technology, the increasingly complex of the telecommunications network, and the reporting functions in the telecommunications network management system have become increasingly attracted, because information such as the performance indicators and operations of the entire telecommunications network equipment need to be obtained from the report.The report function is one of the most frequent functions of network management system maintenance personnel. [0003] Due to the huge performance data of the telecommunications industry, and the Oracle database is a disk database that is suitable for large data processing, the Oracle database is used in general large network management systems.Specifically, by establishing a database performance table in the O...

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 & AuthorityPatents(China)
IPC IPC(8): G06F17/30
Inventor余再跃
OwnerDATANG MOBILE COMM EQUIP CO LTD