Info Systems Quiz 3 Flashcards
Database
collection of related data files or tables that contain data
What makes databases unique?
database decisions are much harder to undo, contains what an organization can do with its data for a long time
data warehouses
data stored in databases must be accessible in a form that helps users to make decisions
Difficulties of managing data
-data increases exponentially with time
-multiple sources of data
-new sources of data
-data rot, or data degradation
-data security, quality, and integrity
-government regulation
internal, personal ,and external sources
internal: corporate databases and company documents
personal: personal thoughts, opinions, and experiences
external: commercial databases, government reports, corporate websites, clickstream data
clickstream data
data that visitors and customers produce when they visit a website and click on hyperlinks
Data rot
problems with the media on which the data is stored (ex. cds -> no player, physically damaged)
data governance
approach to managing information across an entire organization
master data management
process that spans all of an organization’s business processes and applications. allows companies with the ability to store, maintain, exchange, and synchronize a consistent, accurate, and timely “single version of the truth”
master data
set of core data, such as a customer, product, employee, vendor, and geographic data that spans the enterprise’s information systems
transactional data
generated and captured by operational systems, describe the business’s activities, or transactions
data file
collection of logically related records
Problems database systems minimize
redundancy, isolation, inconsistency
Data redundancy
same data are stored in multiple locations
Data isolation
applications cannot access data associated with other applications
Data inconsistency
various copies of the data associated with other applications
Problems database systems maximize
security, integrity, and independence
Data security
risk of losing a lot of data at one time so must have extremely high security measures in place to minimize mistakes
Data integrity
data meet certain constraints
Bit
represents the smallest unit of data a computer can process
Byte
group of eight bits, represents a single character
Field and record
field: logical grouping of characters into a. word, a small group of words, or an identification number
record: local grouping of related fields, such as the student’s name, the courses taken, the data, and the grade
Database management system (DBMS)
set of programs that provide users with tools to create and manage a database
Relational database model
based on the concept of two dimensional tables
data model, entity, instance, and attribute
data model: diagram that represents entities in the database and their relationships
entity: person, place, thing, or event about which an organization maintains information
instance: entity refers to each row in a relational table, which is a specific, unique representation of the entity
attribute: characteristic or quality of a particular