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

On-line analyzing and processing system of social security data on the basis of distributed data warehouse

A technology of online analysis and processing and distributed data, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve problems such as multi-level distributed online analysis and processing methods and systems, and achieve reduction The amount of data and the effect of improving query efficiency

Inactive Publication Date: 2016-11-16
SOUTH CHINA UNIV OF TECH
View PDF4 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] At present, there are various research results on big data online analysis and processing at home and abroad, but so far there is no multi-level distributed online analysis and processing method and system for social security application mass data.

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
  • On-line analyzing and processing system of social security data on the basis of distributed data warehouse
  • On-line analyzing and processing system of social security data on the basis of distributed data warehouse
  • On-line analyzing and processing system of social security data on the basis of distributed data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention will be further described below in conjunction with specific embodiments.

[0030] Such as figure 1 with figure 2 As shown, the social security data online analysis and processing system described in this embodiment is mainly based on a distributed data warehouse (as a storage space for statistical analysis of social security data). The data warehouse of the system is implemented through a distributed file system, and the distributed file system The file system cluster is managed by the cloud computing platform to achieve load balancing of resources. Through functional multi-layer distribution, the system realizes a unified query interface to a distributed data warehouse storing massive amounts of data, and completes multiple-dimensional operations on data cubes in a JDBC-like query mode. The social security data online analysis and processing system is logically divided into 4 layers from top to bottom:

[0031] The presentation layer is the level wh...

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 on-line analyzing and processing system of social security data on the basis of a distributed data warehouse. The on-line analyzing and processing system comprises a display layer, a dimensional layer, a star-shaped layer and a storage layer, wherein the display layers interacts with a multidimensional analysis server; the dimensional layer analyzes a MDX (Multidimensional Expressions) statement and executes query computation by the analyzed statement; the star-shaped layer manages the cache of an aggregation result; and the storage layer is in charge of receiving a SQL (Structured Query Language) statement emitted from the start-shaped layer, executing the SQL statement in the data warehouse and returning a result. The data warehouse of the system is realized through a distributed file system, and a distributed file system cluster is uniformly managed via a cloud computation platform to realize the load balancing of resources. By use of the system, through functional multilayer distribution, a uniform query interface for the distributed data warehouse which stores mass data is realized, and a multidimensional operation for a data cube is finished by a query way similar to JDBC (Java DataBase Connectivity).

Description

Technical field [0001] The invention relates to the field of online analysis and processing and distributed storage, in particular to a social security data online analysis and processing system based on a distributed data warehouse. Background technique [0002] With the continuous development and improvement of information technology, governments, enterprises and other institutions have accumulated a large amount of business data. How to extract useful information from this type of data to facilitate the judgment of the situation and make decisions on future development has become an important issue of concern to decision makers. Enterprise-level system applications often reach terabytes, petabytes or even higher data volume, and for decision makers, important decision-making reference information is often submerged in it. At present, a very common practice is to extract data information that is helpful for decision analysis from massive data, and store it in a data warehouse w...

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
IPC IPC(8): G06F17/30G06Q50/26
CPCG06F16/2471G06F16/254G06Q50/26
Inventor 张星明丛子涵刘俊古振威
Owner SOUTH CHINA UNIV OF TECH
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com