Construction method and system of data warehouse (DW or DHW) and server

A technology of data warehouse and construction method, applied in database model, multi-dimensional database, electronic digital data processing and other directions, can solve the problems of high development and operation and maintenance costs, long development cycle of data warehouse construction, etc., to shorten the development cycle and reduce complexity. degree, reduce the effect of development

Inactive Publication Date: 2018-07-13
SHANGHAI QIANLONG INFORMATION TECH CO LTD
View PDF6 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] In view of the above-mentioned shortcomings of the prior art, the object of the present invention is to provide a construction method, system and server of a data warehouse, which are used to solve the problem that the construction and development cycle of the data warehouse in the prior art is relatively long, and the cost of development and operation and maintenance is relatively high. high 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
  • Construction method and system of data warehouse (DW or DHW) and server
  • Construction method and system of data warehouse (DW or DHW) and server
  • Construction method and system of data warehouse (DW or DHW) and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] Embodiments of the present invention are described below through specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific implementation modes, and various modifications or changes can be made to the details in this specification based on different viewpoints and applications without departing from the spirit of the present invention.

[0040] The purpose of the present invention is to provide a data warehouse construction method, system and server, which are used to solve the problems of large load, long exit time, data loss or data retransmission during the construction of the data warehouse in the prior art. The principles and implementations of the construction method, system and server of a data warehouse of the present invention will be described in detail below...

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 construction method and system of a data warehouse (DW or DHW) and a server. The method includes: constructing a multi-layer data processing architecture for hierarchical processing on data; extracting needed data from data sources, and cleaning the extracted data to form the data according with preset requirements; scheduling and supervising data processing tasks; and controlling access authority of the data in the multi-layer data processing architecture, and supervising overall running status of the data. The multi-layer data processing architecture includes: a temporary storage layer (ODS), which temporarily stores the data acquired from the data sources; a core data layer, which stores and processes the data after cleaning; a data mart layer (MID), which organizes the data to form corresponding data topics; and an application layer (APP), which is user-oriented to process specific demand data input by a user. The method can quickly construct the enterprisedata warehouse, reduce complexity of warehouse construction, shorten a development cycle of building the data warehouse by an enterprise, and reduce warehouse development and operation and maintenance costs, and has broad application prospects.

Description

technical field [0001] The invention relates to the technical field of computer software, in particular to a construction method, system and server of a data warehouse. Background technique [0002] Data warehouse, the English name is Data Warehouse, which can be abbreviated as DW or DWH. A data warehouse is a strategic collection that provides support for all types of data for decision-making processes at all levels of an enterprise. It is a single data store created for analytical reporting and decision support purposes. Provides guidance on business process improvement, monitoring time, cost, quality, and control for businesses that need business intelligence. [0003] A data warehouse is a structured data environment for decision support systems (dss) and online analytical application data sources. Data warehousing studies and solves problems of obtaining information from databases. The characteristics of data warehouse are subject-oriented, integrated, stable and ti...

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/211G06F16/283
Inventor 董林
Owner SHANGHAI QIANLONG INFORMATION TECH 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