7e Chapter 11 Part 2

7e Chapter 11 Part 2 - MSIS 2103 Chapter 11 Part 2 1...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
MSIS 2103 Chapter 11 – Part 2 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 11 Behind the Scenes: Databases and Information Systems
Background image of page 2
3 Chapter Topics Databases and their uses Database components Types of databases Database management systems Relational databases Data warehouses and data marts
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Storage Companies need an enterprise-wide storage system for their data This gives them a competitive advantage over companies who don’t have this tool A structure that can help them is the data warehouse
Background image of page 4
Data Warehouse The conglomeration of an organization s data staging and presentation areas, where operation data is specifically structured for query and Online Analytical Processing (OLAP) analysis (Kimball and Ross, 2002)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 Data Warehouse Data warehouse Large-scale repository of data Organizes all the data related to an organization Data organized
Background image of page 6
Wal-Mart, For Example 2004 – Wal-Mart’s data warehouse was estimated to be about 500 terabytes, or ½ petabyte January 2006 - the terabytes of sales and inventory data were built on a massively parallel 1,000-processor system It tracked and analyzed item-level inventory and sales data Wal-Mart Plans for its 4P Data Warehouse by Evan
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
More Large Data Warehouses? As of May 2009 eBay has a 2-1/2 petabyte DW facebook has a 2-1/2 petabyte DW Other companies are in the hundreds of terabyte range (Dell, MySpace) Some Very, Very, Very Large Data Warehouses by Curt Monash,
Background image of page 8
Review: How Big is a Petabyte? Megabyte - (220 bytes) (10242) (~1 million) Gigabyte - (230 bytes) (10243) (~1 billion) Terabyte - (240 bytes) (10244) (~1 trillion) Petabyte - 1,125,899,906,842,624 bytes - 10245, or 250 bytes (~1 quadrillion) Exabyte - (260 bytes) (10246) (~1 quintillion) Zettabyte - (270 bytes) (10247) (~1 hexillion) Yottabyte - (280 bytes) (10248) (~1 septillion)
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Recall: A terabyte represents a stack of typewritten pages almost 51 miles high A petabyte is a stack 52,000 miles high, or approximately one-fourth the distance from the Earth to the moon
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 39

7e Chapter 11 Part 2 - MSIS 2103 Chapter 11 Part 2 1...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online