In the field of data warehousing, we often hear some personal or organizational debate about the theory of data warehousing, whether it belongs to Bill Inmon or Ralph Kimball faction. Below we will describe the difference between the two.
Bill Inmon Paradigm:The Data
1. The concept of Data Warehouse began in the 1980s S and first appeared in the book William H. Inmon, known as "the father of Data Warehouse. As people deeply recognize and constantly improve the research, management, and maintenance of large
Search for "Inmon and Kimball" on Google, and you'll easily find the concepts of these two names, which are two of the best-known ways of data Warehouse architecture. In this ocean of information, however, you will find that almost all of the content can come to a conclusion, that is, to choose between Bill Inmon and R
Create | data
How to create a successful data Warehouse (Warehose), the following story will tell you!
The company's ' s ' Warehouse project began with a casual conversation between several executives on their way to LUN Ch. The people involved were the IT manager for decision support as as and as several members of
bank is huge, usually measured in millions or even tens of millions of times. The transaction system is real-time, which requires timeliness. It takes tens of seconds for the customer to save a sum of money, which requires the database to store data for a short period of time. The analysis system is post-event. It must provide all valid data within the specified time period. The
cases, the star pattern is layered into the snowflake model, that is, the star pattern is further layered and the data redundancy is reduced.
To say so much, simply to answer two questions: Repeatability interactivity.
The two issues correspond to two entities, data warehousing data marts. Let's compare the differences between the two entities.
Everyone s
This article outlines the general process of using OWB to create a data warehouse. Oracle's OWB is one of the three most current ETL products. OWB can not only complete data extraction, conversion and loading, but also help users create ROLAP (relational online analysis Process) and MOLAP (multidimensional online) in Oracle database Analysis Process)
actual project construction.3) data warehouse modeling method
In fact, everything follows its own law. There are also many data warehouse modeling methods. Each modeling method represents a philosophical point of view and a method of generalization and generalization. Currently, there are many popular
entity modeling method, in essence, each method is to look at the problems in our business from different perspectives. either at the technical or business level, it actually represents a philosophical world outlook. The following describes the modeling methods in detail. 1. paradigm modeling (third normal form, 3nf) The paradigm modeling method is a commonly used method for building data models. This method is primarily promoted by
3 guys came to a business. The first (data Warehouse) was burly: He brought history and experience, and he could say that most of the words were true. But, in many ways, it is bloated and wasteful in other ways, and people are tired of the costs of the various outcomes. Apache Hadoop entered the same building, claiming to take over the entire market. He preaches big dat
0x00 Preface
The following content, is the author in the study and work of some summary, of which the concept of most of the content from the book, the practical content mostly from their own work and personal understanding. Due to the lack of qualifications, there will inevitably be many mistakes, I hope to criticize. Overview
The Data warehouse contains a lot of content, which can include architecture, m
Bill Inmon and Ralph Kimball, who were exposed to two names at school, were unfamiliar to most of the two Americans, but they were a resounding figure in the database field. Bill Inmon, known as the "Father of the Data Warehouse", he can now see a lot of scholarly papers and articles on the Web, and Wikipedia's introdu
PHP-based data warehouse receiving Program (2): php-based data warehouse receiving program
In the previous article, the Program for collecting data into the database based on PHP (ii) mentions the list data on the news information
Brief introduction
The business environment is changing rapidly, and so is the type of business data. A successful Data warehouse solution is based on flexible design that adapts to changing business data. The architecture of data Wareh
Introduction to ETL technology: Introduction to ETL, data warehouse, and etl Data WarehouseETL is the abbreviation of Extract-Transform-Load. It is used to describe the process of extracting, transforming, and loading data from the source to the target. ETL is commonly used in data
data, based on the use of appropriate query and analysis tools, data mining tools, OLAP tools and other analysis and processing (this time information into the knowledge of auxiliary decision), and finally the knowledge presented to the manager, Provide support for the decision-making process of the manager.Relational theory leads to relational databaseData Warehouse
first from the system and the overall perspective, taking into account information integration and sharing, good long-term and overall plan, there is an old story, can explain the argument of this law. Three blind men met an elephant and everyone screamed loudly. The first man grabbed an elephant's ear and said, "It's a big, rough thing, wide and broad, like a rug." The second man held the elephant's nose and said, "What I feel is the truth, it's a straight and hollow pipe." The third blind man
Tags: OLAP online analytics for Data warehouse applicationsRelated articles:Data Warehouse Application (i): Data Warehouse model designData Warehouse Application (ii): Data extraction,
Before you start
About this series
This tutorial series Informix Warehouse Feature introduces the features and features of the new client and server Software in Informix Warehouse. You can use these tools to create and deploy data Warehouse projects, to model databases on the Informix
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.