2.2 - 9/21/2009 Module 2: Data Management Session 3: Data...

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

View Full Document Right Arrow Icon
9/21/2009 1 Module 2: Data Management Session 3: Data Warehousing and Quality, Privacy, & Security Dr. Russ Robbins Describe the parts of a DBMS Relate the parts of a DBMS to MS Access Relate database concepts to web applications. Describe the value of quality data. Describe the dimensions of data quality. Describe the importance of secure data. Describe a “database transaction.” Describe how data redundancy occurs and its relationship to costs. Go over the examples I sent to you. Discuss tables, queries, forms, and reports. Discuss Amazon.com and these. Lecture Present feedback on assignments.
Background image of page 1

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

View Full DocumentRight Arrow Icon
9/21/2009 2 The amount of data stored by businesses nearly doubles every 12 – 18 months 1 WalMart refreshes sales data hourly, adding a billion database rows a day 1 Ebay manages several hundred databases totaling 100 terabytes of data supporting totaling 100 terabytes of data, supporting around 750,000 queries per day 1 Data storage is quickly becoming one of the biggest expenses in enterprise IT budgets, responsible for up to 30% of capital expenditures 2 More and more information from business transactions is being saved The internet facilitates collecting data from high volumes of business transactions Newer application software, such as ERP systems, is designed to collect data from transactions "Our database grows because we capture data on every item, for every customer, for every store, every day" (Dan Phillips, WalMart’s VP of IS)
Background image of page 2
9/21/2009 3 Specialized Roles: Database Administrators (DBA) Specialized Technology: Database Management Systems (DBMS)
Background image of page 3

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

View Full DocumentRight Arrow Icon
9/21/2009 4 DBMS engine – accepts logical requests, converts them into their physical equivalent, and accesses the database and data dictionary DBMS engine separates the logical from the DBMS engine separates the logical from the physical Physical view – how information is arranged, stored, and accessed on a storage device Logical view – how you (knowledge worker) need to arrange and access information Databases you work only with logical views Databases – you work only with logical views Data definition subsystem – helps you create and maintain the data dictionary and define the structure of the files in a database Must create data dictionary for a database before entering any information Extended Learning Module J covers this
Background image of page 4
9/21/2009 5 Data manipulation subsystem –he lps±you± add, change, and delete information Primary interface between you and a database Views Report generators QBE tools SQL a view is a virtual or logical table composed of the result set of a query. Unlike ordinary tables (base tables) in a relational database, a view is not part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

2.2 - 9/21/2009 Module 2: Data Management Session 3: Data...

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

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