Database partition method and device

A database and data technology, applied in the field of communication, can solve the problem of increasing query time, etc., achieve the effect of reducing query scanning time, reducing the time required, and improving efficiency

Active Publication Date: 2011-05-18
DATANG MOBILE COMM EQUIP CO LTD +1
View PDF1 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, with this partition 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

[0035] refer to figure 1 , showing a first embodiment of a database partitioning method of the present invention, comprising the following steps:

[0036] Step 101: Obtain multiple required report types.

[0037] 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) does not change. For example, the daily report of a certain bureau, The start time is 8:00 in the morning, and the end time is 8:00 in the next morning. Although the date changes every time the report is made, the time point at 8:00 does not change. Even in special cases, 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 a certain ...

Embodiment 2

[0053] refer to figure 2 , showing the second embodiment of a database partition method of the present invention, comprising the following steps:

[0054] Step 201: Obtain multiple required report types.

[0055] Step 202: Determine database partition rules according to time nodes in various required report types.

[0056] Step 203: Write the determined database partition rule into a configuration file, and use a scheduled task to automatically create a partition according to the configuration file.

[0057] 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.

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

Embodiment 3

[0059] refer to image 3 , showing the third embodiment of a database partition method of the present invention, comprising the following steps:

[0060] Step 301: Obtain multiple required report types.

[0061] Step 302: Determine database partition rules according to time nodes in various required report types.

[0062] Step 303: Determine whether the query condition of the required data in the required report includes other conditions than time, if necessary, determine the database sub-partitioning rule according to the corresponding query condition, and go to Step 304A; otherwise, go to Step 304B.

[0063] Step 304A: Partition the database according to the determined database partitioning rule, and perform sub-partitioning on the data partition according to the database sub-partitioning rule.

[0064] Step 304B: Partition the database according to the determined database partitioning rule.

[0065] Other query conditions can be whether the data of some NEs (one or some ...

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 present invention relates to the technical field of communications, and in particular, to a database partitioning method and a partitioning device. Background technique [0002] At present, with the rapid development of communication technology and the increasing complexity of telecommunication networks, the report function in the telecommunication network management system has also attracted more and more attention, because the performance indicators and operation details of the entire telecommunication network equipment need to be obtained from the reports. The report function is one of the most frequently used functions by network management system maintenance personnel. [0003] Because the performance data in the telecommunications industry is huge, and the oracle database is a disk database suitable for processing large amounts of data, the oracle database is generally used in large-scale network management systems. Specifically, a database ...

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 & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 余再跃
Owner DATANG MOBILE COMM EQUIP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap