Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Index file processing method and device for analysis database

A file processing and database technology, applied in the field of data processing, can solve the problems of unstable synchronization function of the analysis database and consumption of analysis database resources, etc., and achieve the effect of stable synchronization function and less resource consumption

Active Publication Date: 2014-11-26
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a method and device for processing index files of an analysis database, so as to solve the problem that synchronizing the analysis database while performing dimension or index processing will consume the resources of the analysis database, resulting in unstable synchronization functions of the analysis database The problem

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
  • Index file processing method and device for analysis database
  • Index file processing method and device for analysis database
  • Index file processing method and device for analysis database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0025] figure 1 It is a flow chart of the first embodiment of the index file processing method for analyzing the database according to the present invention. Such as figure 1 As shown, the method includes the following steps S101 to S105:

[0026] Step S101, process the indicator data in the first database, wherein the first database saves the data of one time processing cycle and stores it in the analysis database, the first database includes the first partition, and the first partition includes the first index file , the metrics data is stored in the first metrics file.

[0027] Processing the index data in the first database means processing the index data according to the processing con...

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 discloses an index file processing method and device for an analysis database. The method comprises the steps that index data in a first database are processed; a second partition is established in a second database, wherein the second database is a database for storing all historical data in the analysis database; a first index file is copied to an index file corresponding to the second partition; the corresponding index file in the second partition is replaced by the first index file; metadata maintenance is performed on the index files in the second database, and the second database is updated. In this way, the problems that resources of the analysis database will be consumed if the analysis database performs synchronization while performing dimension or index processing, so that the built-in synchronizing function of the analysis database is unstable are solved, and the effects of the stable synchronizing function and low resource consumption are achieved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to an index file processing method and device for analyzing a database. Background technique [0002] A database is a general data processing system for a unit or an application field, which stores a collection of related data belonging to enterprises and business departments, groups and individuals. The data in the database is established for many users to share their information, and has got rid of the restrictions and restrictions of specific programs. Different users can use the data in the database according to their own usage; multiple users can share the data resources in the database at the same time, that is, different users can access the same data in the database at the same time. Data sharing not only meets the requirements of each user for information content, but also meets the requirements of information communication between users. [0003] To analyze the database, a...

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
CPCG06F16/235G06F16/24554G06F16/27
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products