ACCESS AGENDA 1.SELECT LESSONS i.The day of the presentation is the primary criterion for selection projects ii.Start choices with Rx because went first.

Similar presentations

Presentation on theme: "ACCESS AGENDA 1.SELECT LESSONS i.The day of the presentation is the primary criterion for selection projects ii.Start choices with Rx because went first."— Presentation transcript:

4
DATABASES & DATA WAREHOUSES Access to a Gold Mine of Information “The real value will come from getting the right information to the right people, at the right time, and giving those people the tools to find the meaning in it.” Declaration of Integration Abbie Lundberg CIO 1Dec2002

6
Use Access as an Alternative…. Database robust 1.3 u“Access gives them a robust database engine that does not lock into a specific technology.” 1.3 u“Your job is to get work done, not build computer programs. easy familiar 2.3 u“Your job is to get work done, not build computer programs. Access provides an easy way to get started …with a user interface that will be familiar to anyone who has used Microsoft Office.” 2.3 inexpensivecatch on quickly 2.4-5 uAccess is inexpensive, and most people catch on quickly….Your company probably owns several copies of Access. 2.4-5 workable solution 3.3 uAccess is a workable solution. 3.3 çStonyfield Farms CSS çStonyfield Farms & CSS A-2b TechRepublic 5Dec03

9
ASSIGNMENT: Work with team on ACCESS project. u Eu Eu Eu Emphasize course concepts to explain why the procedures are important in: HmHmHmHmeeting the MIS challenge HpHpHpHperforming the 5Cs, HpHpHpHprocessing data into information then knowledge, HdHdHdHdata sharing and decentralized computing that support decision making and innovation HbHbHbHbuilding CIS (TPS), MIS (dashboards), DSS, WSS HcHcHcHcreating information partnerships, virtual – learning organizations that are timeless & locationless uThese exercises are essential to the synthesis of concepts, frameworks and ideas into a new whole that changes the brain  real learning (Bloom Hierarchy of Learning Objectives; WSJ 19Jan07 “Thinking Can Change the Brain”) uThis requires reviewing Information Age, IT Systems, IT Strategies PowerPoints and using those concepts, frameworks and ideas to analyze and evaluate the ACCESS procedures.

21
DATABASES & DATA WAREHOUSES Access to a Gold Mine of Information “The real value will come from getting the right information to the right people, at the right time, and giving those people the tools to find the meaning in it.” Declaration of Integration Abbie Lundberg CIO 1Dec2002 performinformation processing (5Cs) for MIS challenge IA-15

26
What IS Victoria’s Secret? DATABASES “Databases enable e-tailers “ not only to track individuals’ purchases closely but also to analyze broad buying patterns - - by gender, location and credit-card type, at least, and even internet-service provider, if an e-mail address is given.” WSJ 1.5 “This wealth of data can be used to target marketing efforts….Victoria Secret mails several catalogues a year, featuring largely the same merchandise but with different covers and product photos. Then it gauges which generates the most sales.” WSJ 1.5, 3.1-4

27
What IS Victoria’s Secret? DATABASES CAPTURE & CRADLE BASIC DATA BASIC DATA from store TPS & online CIS PROVIDE ACCESS BY COMMUNICATING & CONVEYING INFORMATION TO KNOWLEDGE WORKERS INFORMATION TO KNOWLEDGE WORKERS ENABLE ANALYSIS THAT CREATES KNOWLEDGE FOR DECISION MAKING & INNOVATION THAT CREATES KNOWLEDGE FOR DECISION MAKING & INNOVATION “Databases enable e-tailers “ not only to track individuals’ purchases closely but also to analyze broad buying patterns - - by gender, location and credit-card type, at least, and even internet- service provider, if an e-mail address is given.” WSJ 1.5 “This wealth of data can be used to target marketing efforts….Victoria Secret mails several catalogues a year, featuring largely the same merchandise but with different covers and product photos. Then it gauges which generates the most sales.” WSJ 3.1-4

38
What is the logical structure in a relational database? u Database files relationstables Compustat, Edgar u Database consists of a logical collection of files with relations expressed in the rows and columns of tables Compustat, Edgar u File records rowstablefieldscolumns u File is a logical grouping of records about related objects/events in rows of a table with fields in columns u Record fields u Record is a logical grouping of fields related to some object/event (firms) u Field characters u Field is a logical grouping of characters describing some characteristic of an object/event (EPS, share price) u Character Figure 4.4 u Character is the smallest logical unit of data (symbols/ letters/numbers) Figure 4.4 DatabaseDB-4.b

39
What defines logical structure in a relational database? DatabaseDB-4.c uData Dictionary tables keys H.87.3-88.1 uData Dictionary identifies the names and properties of fields in the columns of tables including keys H.87.3-88.1 uKeys uKeys are fields in a relational databases identify relationships within and between files / tables VPrimaryrecord H.88.2 VPrimary - is a field uniquely identifies/describes each record indicating relationships within a file / table H.88.2 VForeign H.89.1 VForeign - primary key of one file appearing in another file indicating a relationship between files / tables H.89.1 uIntegrity Constraints uIntegrity Constraints are provided by the the logical structure defined by properties and keys H.89.2-3 VProperties and keys limit the kind of data that can be entered into a file therefore help ensure data reliability H.89.2-3

44
What is a DBMS Engine? logical-physical bridge u the logical-physical bridge logical requestsDBMS subsystemsphysical equivalent V accepts logical requests from the various other DBMS subsystems, converts them to their physical equivalent, and actually accesses the database and data dictionary as they exist on a storage device userlogicalinformation needs u permits the user to concentrate on logical information needs, without concern for the physical/technical details DB-6DBMS Figures 3.6 & 3.2

46
What is Application Generation Subsystem? u contains facilities to develop transaction-intensive applications that require a detailed series of tasks to process a transaction. This subsystem includes: forms V Tools for creating data entry screens and controls in forms SQL V Programming languages specific to the DBMS: SQL (standardized query language) in Access V Interfaces to commonly used programming languages that are independent of any DBMS: C, C++, Cobol DB-8DBMS u Team Projects B, C, D

47
What is a Data Manipulation Subsystem? V most often the primary interface between a user and the data in a database  tools in the data manipulation subsystem include: Project E  views: filtering & sorting Project E ç report generators Project F  queries Project F DB-9.aDBMS u helps you change data in a database and mine it for valuable information.

48
What are the data manipulation tools? u Team Project E DB-9.bDBMS  views  view the content of a database file, make changes, perform simple filtering & sorting to find the location of specific information. u report generators Vhelp quickly define the content and format of a report.

49
What are the data manipulation tools? u Query Figure 3.7 V is a (graphical) tool that brings together data from multiple tables to answer a question Figure 3.7 V Queries are more powerful than filters ç extract data from many tables ç queries can be saved V Typically, start with wizard then modify in design view DB-9.cDBMS u Team Project F

52
What is an Object-Oriented database? Figure 3.15 u Encapsulates both information about an entity class and the procedures (software instructions) to work with that information in a software module called an object Figure 3.15 H.99.1-3 H.99.1-3 V combining information and procedures more closely models how an organization works H.100.3 V once a set of procedures is defined for a given object, those procedures can be reused by other objects H.100.3 V Microsoft Access Figures 3-15, 3.8-3.10 V Microsoft Access is an object-oriented database (Data Dictionary, Forms, Queries, Reports) Figures 3-15, 3.8-3.10 DatabaseDB-11

54
What Are the Critical Success Factors for Databases & Data Warehouses? ¶Expectations are communicated to the users ·User involvement is ensured throughout the project ¸Project has a good sponsor, from the business side not IT ¹Project team has the right skill set dedicated to the team ºA realistic schedule including all necessary tasks »Tools have been chosen to match the needs of the users DataWarehousing.com (7 Feb 2001) ¼Users are trained in the way they plan to use the warehouse DataWarehousing.com (7 Feb 2001) Data Warehouse DB-14

55
Issues addressed within SDLC Issues addressed within SDLC users H.104.6-8 u Who will be the users? H.104.6-8 data H.104.9-105.2 V What data will they need? H.104.9-105.2 mining tools V What data mining tools will the users need ? updated H.105.3-4 V How often should the data be updated? H.105.3-4 databasesDSSnetworks u What types of databases, DSS & networks are most appropriate? u Who should oversee the information resource? V CIO V CIO should manage information which is as important as the financial resources managed by CFO. DB-12.a

56
Issues addressed within SDLC ownership u Who has ownership of (responsibility for) the quality of specific information? ethicalsecurityprivacy u What ethical, security and privacy issues are involved in using information and IT? technology changes u How should technology changes be assessed? V Chasing technology is very expensive benefitcost V The real issues is whether the new technology manages information better and if the benefit exceeds the cost DB-12.b

58
ASSIGNMENT: Work with team on ACCESS project. ASSIGNMENT: Work with team on ACCESS project. u Eu Eu Eu Emphasize course concepts to explain why the procedures are important in: HmHmHmHmeeting the MIS challenge HpHpHpHperforming the 5Cs, HpHpHpHprocessing data into information then knowledge, HdHdHdHdata sharing and decentralized computing that support decision making and innovation HbHbHbHbuilding CIS (TPS), MIS (dashboards), DSS, WSS HcHcHcHcreating information partnerships, virtual – learning organizations that are timeless & locationless uThese exercises are essential to the synthesis of concepts, frameworks and ideas into a new whole that changes the brain  real learning (Bloom Hierarchy of Learning Objectives; WSJ 19Jan07 “Thinking Can Change the Brain”) uThis requires reviewing Information Age, IT Systems, IT Strategies PowerPoints and using those concepts, frameworks and ideas to analyze and evaluate the ACCESS procedures.