BUS220 - Week 2 Flashcards
Cover Week 2 Material
Difficulties in Managing Data
–Amount of data increases exponentially.
–Data are scattered and collected by many individuals using various methods and devices.
–Data come from many sources.
–Data security, quality and integrity are critical.
–An ever-increasing amount of data needs to be considered in making organizational decisions.
–Huge quantities must be kept for a long time
–Data are scattered across locations in an organization
–External data must be included to support decision making
Review:
–Huge quantities must be kept for a long time
–Data are scattered across locations in an organization
–External data must be included to support decision making
–Data security, quality and integrity are essential but difficult to ensure
Describe the data lifecycle.
–Data is acquired from internal, external and personal sources
–Data is converted into the format required for a data warehouse and/or data mart
–Data is analyzed with data analysis and data mining tools
–The results is generation of decision support and knowledge that provides solutions to organizational problems.
–In short, data is transformed into knowledge and solutions
.Data, Information, Knowledge, Wisdom
Wisdom ^ Knowledge ^ Information ^ Data
Data is foundation
Database management system
(DBMS) provides all users with access to all the data.
DBMSs minimize the following problems
–Data redundancy
–Data isolation
–Data inconsistency
DBMSs maximize the following issues:
–Data security
–Data integrity
–Data independence
Data Hierarchy
Bit Byte Field Record File (or table) Database
Designing the Database
–Entity
–Attribute
–Primary key
–Secondary keys
entity-relationship (ER) modeling.
Database designers plan the database design
ER diagrams consists of
consists of entities, attributes and relationships.
–Entity classes
–Instance
–Identifiers
What is a data model?
–A diagram that represents entities in the database and their relationships to each other
What are primary and secondary keys?
–A primary key is the field in a record that uniquely identifies that record so it can be retrieved, updated and stored.
–A secondary key is any other field that has some identifying information but typically does not identify the specific record.
BIS/220 – INTRODUCTION TO COMPUTER APPLICATION AND SYSTEMS
24
What is an entity?
–An entity is a person, place, thing or event about which information is maintained.
What is a relationship?
–A relationship is the way in which entities are associated with each other.
Name the three types of entity relationships.
–One to one
–One to many
–Many to many
Database Management Systems
Database management system (DBMS)
Relational database model
Structured Query Language (SQL)
Query by Example (QBE)
Normalization
method for analyzing and reducing a relational database to its most streamlined form for:
–Minimum redundancy
–Maximum data integrity
–Best processing performance
Normalized data is when attributes in the table depend only on the primary key
-Normalization Produces Order
Data Warehousing
–Data warehouses are organized by business dimension or subject.
–Data warehouses are multidimensional.
–Data warehouses are historical.
–Data warehouses use online analytical processing.
Benefits of Data Warehousing
End users can access data quickly and easily via Web browsers because they are located in one place.
End users can conduct extensive analysis with data in ways that may not have been possible before.
End users have a consolidated view of organizational data.
Data Marts
A data mart is a small data warehouse, designed for the end-user needs in a strategic business unit (SBU) or a department.
Data Governance
Data governance
Master data management
Master data
Knowledge Management
Knowledge management (KM)
Knowledge
Intellectual capital (or intellectual assets)
Knowledge Management (continued)
Explicit Knowledge (above the waterline)
Tacit Knowledge
(below the waterline) (Iceberg Picture, just the tip shows for explicit knowledge)
Knowledge management systems
–Use of information technologies to systematize, enhance, and expedite intra-firm and inter-firm knowledge management.
Best practices
–The most effective and efficient ways of doing things.
Connected computers:
Work together
Are interdependent
Exchange data with
each other