Chapter 6 Notes

Chapter 6 Notes - Chapter 6: Databases and Data Warehouses...

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

View Full Document Right Arrow Icon
Database Management Systems (DBMS) Data manipulation Data definition Database Data administration Application generation Data Warehouse Model Data Warehouses Internal databases Marketing Sales Marketing data mart ETL ETL Inventory Billing Marketing info Inventory info Sales info Billing info Competitor info Industry info Mailing list info Stock market analysis Inventory data mart ETL External databases Competitor Information Industry Information ETL Exploring and mining ETL Stock market analysis Mailing Lists Store 3 Store 3 Store 3 Store 2 Store 2 Store 2 Store 1 Product B Product C Product D Product E Store 1 Product B Product C Product D Product E Store 1 Product B Product C Product D Product E I II III IV I II III IV I II III IV Promos Promos Promos Quality Management $ Complete but with known errors Perfect information 100% Completeness Not very useful May be prototype only Very incomplete but accurate Accuracy 100% Chapter 6: Databases and Data Warehouses Data are raw facts that describe the characteristics of an event o Characteristics for a sales event could include the date, item number, item description, quantity ordered, customer name, and shipping details Information is data converted into a meaningful and useful context o Information from sales events could include best-selling item, worst-selling item, best customer, and worst customer UNDERSTANDING INFORMATION Businesses desire technologies that help organize and provide access to information Organizational information comes at different levels, formats, and “granularities” o Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract information) Coarse = highly summarized Fine = containing much detail o Employees must be able to correlate the different levels, formats, and granularities of information when making decisions Information Types Range Examples Information Levels Individual Individual knowledge, goals, and strategies Department Departmental goals, revenues, expenses, processes, and strategies Enterprise Enterprisewide revenues, expenses, processes, and strategies Information Formats Document Letters, memos, faxes, e-mails, reports, marketing materials, and training materials Presentation Product, strategy, process, financial,
Background image of page 1

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

View Full DocumentRight Arrow Icon
customer, and competitor presentations Spreadsheet Sales. marketing, industry, financial, competitor, customer, and order spreadsheets Database Customer, employee, sales, order, supplier, and manufacturer databases Information Granularities Detail (Fine) Reports for each sales person, product, and part Summary Reports for all sales personnel, all products, and all parts Aggregate (Coarse) Reports across departments, organizations and companies Information Quality: Business decisions are only as good as the quality of the information used to make the decisions Characteristics of High-Quality Information Accuracy Are the values correct? For example, is the name spelled
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 15

Chapter 6 Notes - Chapter 6: Databases and Data Warehouses...

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

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