data granularity in data warehouse

Radish (: Robbie_qi)The recent study of a big data company 1010data in the United States, which presented the concept of a new generation of data warehouses in the product whitepaper (next-generation data DISCOVERY), has the following characteristics compared to the first generation Data warehouse:users can analyze and

structure optimized for data warehouses and OLAP applications. granularity: Granularity will directly determine the level of detail that a built-in warehouse system can provide for decision support. A higher granularity indicates that the

Original address I. Definition of metadata According to the traditional definition, metadata (Metadata) is data about data. In the Data warehouse system, metadata can help data warehouse administrators and developers of

Data warehouse and data mining are two big concepts. They are very mature in foreign countries. In China, with the accumulation of enterprise data and the maturity of ERP in the past few years, data warehouse and

First, the Data WarehouseThe standard definition of the Data Warehouse concept is relatively high in the industry, as proposed by Bill Inmon, the father of the Data Warehouse, in the book "Building The Data

First, the Data WarehouseThe standard definition of the Data Warehouse concept is relatively high in the industry, as proposed by Bill Inmon, the father of the Data Warehouse, in the book "Building The Data

Data Warehouse--digging in "beer and diapers" 01-5-21 04:19:25 Interlocutor: Host: Cheng  Hung--"Computer World" reporter  Home: Mengxiao--Renmin University of China School of Information Professor  Qi-"Data Warehouse Road" website host it Manufacturers: Yang Shunsheng--NCR Greater China Market and partner g

Introduction With the rapid development of China's financial industry, it is an urgent problem for the bank to support the decision analysis by classifying and storing the customer data, analyzing the automatic discriminant of the various factors, and digging out the information needed by the bank managers and the business analyst in the presence of a large amount of data.

Basic concepts: 1. Multi-dimensional dataset: a multi-dimensional dataset is the main object in Online Analytical Processing (OLAP) and a technology that allows quick access to data in a data warehouse. A multi-dimensional dataset is a collection of data. It is usually constructed from a subset of a

The original: "Bi thing-the art of data" understanding Dimension Data Warehouse-fact table, dimension table, aggregation tableFact tableIn a multidimensional data warehouse, a table that holds a detailed value or fact for a measure is called a fact table. A fact table that s

To illustrate their relationship, we have to talk about business intelligence. From a technical point of view, the process of business intelligence is based on the data warehouse in the enterprise by the online analysis and processing tools, data mining tools, and the professional knowledge of decision planners, obtain useful information and knowledge from

server|sqlserver| data The construction and analysis of SQL Server Data Warehouse (i) Basic concepts: 1. Cubes: Cubes are the primary object in online analytical processing (OLAP) and are a technology that allows fast access to data in a data

Fact tableIn a multidimensional data warehouse, a table that holds a detailed value or fact for a measure is called a fact table. A fact table that stores sales and sales by state, product, and month has 5 columns that are conceptually similar to the following example. Sate Product Mouth Units Dollars WA Mountain-100 January 3 7.95

special attention to which data sources are compatible with the data type, granularity, and content. (4) Capacity PlanningIn addition to the architecture, hardware and software resources are also critical to data warehouses. As part of the requirement definition, it is important to estimate the amount of

About star schema In the construction of the Data Warehouse, the star pattern shown in the following illustration is almost the most commonly used. It is called star mode because the E-R graphic in the pattern is like a star (it feels strange to say). NBSP as shown in the figure, the center is a large fact table with some dimension tables around it. The fact table contains the primary information fo

Objective:Ready to systematize a set of distributed Data Warehouse Modeling Practice Guide, the first list of the table, is to design a goal for themselves.The first part of the basic articleChapter One concept and definition of data Warehouse1.1 Data Management System1.2 Data