Information Warehouse .

Uploaded on:
Category: Education / Career
Information Distribution center. Lutfi Freij Konstantin Rimarchuk Vasken Chamlaian John Sahakian Suzan Ton. Inmon. Father of the information distribution center Co-maker of the Corporate Data Processing plant. He has 35 years of involvement in database innovation administration and information stockroom plan. .
Slide 1

Information Warehouse Lutfi Freij Konstantin Rimarchuk Vasken Chamlaian John Sahakian Suzan Ton

Slide 2

Inmon Father of the information distribution center Co-maker of the Corporate Information Factory. He has 35 years of involvement in database innovation administration and information distribution center plan.

Slide 3

Inmon-Cont\'d Bill has expounded on an assortment of subjects on the building, use, & upkeep of the information distribution center & the Corporate Information Factory. He has composed more than 650 articles (Datamation, ComputerWorld, and Byte Magazine). Inmon has distributed 45 books. A considerable lot of books has been meant Chinese, Dutch, French, German, Japanese, Korean, Portuguese, Russian, and Spanish.

Slide 4

Introduction What is Data Warehouse? An information distribution center is an accumulation of incorporated databases intended to bolster a DSS. As indicated by Inmon\'s (dad of information warehousing) definition(Inmon,1992a,p.5): It is a gathering of coordinated, subject-situated databases intended to bolster the DSS work, where every unit of information is non-unstable and significant to some minute in time.

Slide 5

Introduction-Cont\'d. Where is it utilized? It is utilized for assessing future procedure. It needs an effective professional: Flexible. Cooperative person. Great adjust of business and specialized comprehension.

Slide 6

Introduction-Cont\'d. A definitive utilization of information stockroom is Mass Customization. For instance, it expanded Capital One\'s clients from 1 million to roughly 9 millions in 8 years. Much the same as a muscle: DW increments in quality with dynamic utilize. With each new test and item, significant data is added to the DW, permitting the investigator to gain from the achievement and disappointment of the past. The way to survival: Is the capacity to investigate, plan, and respond to changing business conditions in an a great deal more quick form.

Slide 7

Data Warehouse all together for information to be successful, DW must be: Consistent. Very much coordinated. Very much characterized. Time stamped. DW condition: The information store, information shop & the metadata.

Slide 8

The Data Store An operational information store (ODS) stores information for a particular application. It nourishes the information distribution center a flood of coveted crude information. Is the most widely recognized segment of DW condition. Information store is by and large subject arranged, unpredictable, current usually centered around clients, items, orders, approaches, claims, and so forth…

Slide 9

Data Store & Data Warehouse Data store & Data stockroom, table 10-1 page 296

Slide 10

The information store-Cont\'d. Its everyday capacity is to store the information for a solitary particular arrangement of operational application. Its capacity is to encourage the information distribution center information with the end goal of examination.

Slide 11

The Data Mart It is lower-taken a toll, downsized form of the DW. Information Mart offer a focused on and less exorbitant strategy for picking up the favorable circumstances related with information warehousing and can be scaled up to a full DW condition after some time.

Slide 12

The Meta Data Last part of DW conditions. It is data that is kept about the distribution center as opposed to data kept inside the stockroom. Legacy frameworks by and large don\'t keep a record of attributes of the information, (for example, what bits of information exist and where they are found). The metadata is just information about information.

Slide 13

Conclusion A Data Warehouse is a gathering of incorporated subject-arranged databases intended to bolster a DSS. Every unit of information is non-unpredictable and important to some minute in time. An operational information store (ODS) stores information for a particular application. It sustains the information distribution center a surge of sought crude information. An information bazaar is a lower-cost, downsized variant of an information distribution center, normally intended to bolster a little gathering of clients (as opposed to the whole firm). The metadata is data that is kept about the distribution center.

Slide 14

Data Warehouse Subject situated Data incorporated Time variation Nonvolatile

Slide 15

Characteristics of Data Warehouse Subject arranged. Information are composed in view of how the clients allude to them. Incorporated . All irregularities with respect to naming tradition and esteem portrayals are evacuated. Nonvolatile . Information are put away in read-just configuration and don\'t change after some time. Time variation . Information are not present but rather typically time arrangement.

Slide 16

Characteristics of Data Warehouse Summarized Operational information are mapped into a choice usable arrangement Large volume . Time arrangement informational indexes are typically very expansive. Not standardized . DW information can be, and frequently are, excess. Metadata . Information about information are put away. Information sources . Information originate from inside and outside unintegrated operational frameworks.

Slide 17

A Data Warehouse is Subject Oriented

Slide 18

Subject Orientation

Slide 19

Data Integrated Integration –consistency naming traditions and estimation attributers, exactness, and normal total. Foundation of a typical unit of measure for every single synonymous dat components from different database. The information must be put away in the DW in a coordinated, all inclusive worthy way

Slide 20

Data Integrated

Slide 21

Time Variant In an operational application framework, the desire is that all information inside the database are exact as existing apart from everything else of get to. In the DW information are essentially thought to be precise starting at some minute in time and not really at this moment. One of the spots where DW information show time difference is in the structure of the record key. Each essential key contained inside the DW must contain, either verifiably or unequivocally a component of time( day, week, month, and so forth)

Slide 22

Time Variant Every bit of information contained inside the distribution center must be related with a specific point in time if any helpful investigation is to be led with it. Another part of time fluctuation in DW information is that, once recorded, information inside the distribution center can\'t be refreshed or changed.

Slide 23

Nonvolatility Typical exercises, for example, erases, embeds, and changes that are performed in an operational application condition are totally nonexistent in a DW situation. Just two information operations are ever performed in the DW: information stacking and information get to

Slide 24


Slide 25

Issues of Data Redundancy amongst DW and operational situations The absence of importance of issues, for example, information standardization in the DW condition may recommend that presence of huge information excess inside the information stockroom and between the operational and DW conditions. Inmon(1992) called attention to and demonstrated that it is not valid.

Slide 26

Issues of Data Redundancy amongst DW and operational conditions The information being stacked into the DW are sifted and "rinsed" as they go from the operational database to the stockroom. In light of this purifying various information that exists in the operational condition never go to the information stockroom. Just the information essential for handling by the DSS or EIS are ever really stacked into the DW. The time skylines for distribution center and operational information components are remarkable. Information in the operational condition are crisp, though distribution center information are for the most part much older.(so there is insignificant chance of the information to cover between two situations ) The information stacked into the DW frequently experience a radical change as they pass frame operational to the DW condition. So information in DW are not the same. Given this elements, Inmon proposes that information excess between the two conditions is an uncommon event with a run of the mill repetition element of under 1 %

Slide 27

The Data Warehouse Architecture The design comprises of different interconnected components: Operational and outside database layer – the source information for the DW Information get to layer – the instruments the end client access to separate and dissect the information Data get to layer – the interface between the operational and data get to layers Metadata layer – the information index or vault of metadata data

Slide 28

Components of the Data Warehouse Architecture

Slide 29

The Data Warehouse Architecture Additional layers are: Process administration layer – the scheduler or employment controller Application informing layer – the "middleware" that vehicles data around the firm Physical information stockroom layer – where the real information utilized as a part of the DSS are found Data organizing layer – the majority of the procedures important to choose, alter, outline and load stockroom information from the operational and outer information bases

Slide 30

Data Warehousing Typology The virtual information distribution center – the end clients have guide access to the information stores, utilizing devices empowered at the information get to layer The focal information distribution center – a solitary physical database contains the majority of the information for a particular utilitarian region The circulated information distribution center – the segments are conveyed over a few physical databases

Slide 31

The Metadata The name recommends some abnormal state innovative idea, however it truly is genuinely basic. Metadata is "information about information". With the rise of the information distribution center as a choice bolster structure, the metadata are considered as much an asset as the business information they portray. Metadata are deliberations - they are abnormal state information that give brief depictions of lower-level information.

Slide 32

The Metadata For instance, a line in a business database may contain: 4056 KJ596 223.45 This is generally useless until we counsel the metadata that discloses to us it was store number 4056, item KJ596 and offers of $223.45 The metadata are basic fixings in the change of crude information into learning. They are the "keys" that permit us to deal with the crude information.

Slide 33

General Metadata Issues General metadata issues related with Data Warehouse utilize: What tables, characteristics and keys does the DW contain? Where did each arrangement of information originate from? What changes were connected with purifying? How have the metadata changed after some time? H

View more...