Managing Data - 2293 - Ch 4
Card Set Information
Managing Data - 2293 - Ch 4
are data that visitors and consumers produce when they visit a website and click on hyperlinks
it refers primarily to problems with the media to which the data are stored
Data Life Cycle
Data Sources (Internal, External, and Personal Data)
Database management System (DBMS)
is a set of programs that provides users with tools to add, delete, access, and analyze data stored in one location
The same data are stored in many places
Applications cannot access data associated with other application.
Various copies of the data do not agree.
represents the smallest unit of data a computer can process
a group of 8 bits
a logical group of characters into a word, small group of words, of an indentification #.
A logical grouping of related fields compose a record.
file or table
A logical grouping of related records
A logical grouping of related tables
Is a diagram that represents entities in the database and their relationship
is a person, place, thing or event
Each characteristics or quality of a particular entity
Entity-relationship (ER) modelling
Plan and develop the database through this process using an entity-relationship (ER) diagram.
Relational Database Model
is based on the concept of 2 dimensional tables
most popular query language used to request information
Query by example
Another way to find info in a data base
It defines the format necessary to enter the data into the database.
Is a method for analyzing and reducing a relational database to its most streamlined form for minimum redundancy, maximum data integrity and best processing performance.
is a repository of historical data organized by subject to support decision makers in the organization
Online analytical processing
is the process of performing complex, multi-dimensional analyses of data stored in a database or warehouse
online transaction processing
where business transactions are processed online as soon as they occur
multi dimensional structure
more than 2 dimensions
is a small data warehouse that is designed for the end user's needs in a strategic business unit or department.
is an approach to managing information across an entire organization
are a set of core data, such as customers, products, employees, and so on.
Master Data management
is a process that spans all organizational business processes and applications.
Knowledge management systems
it refers to the use of modern info technologies to systematize, enhance, and expedite intrafirm and interfirm knowledge management.
Knowledge or Intellectual capital
is information that is contextual, relevant, and actionable.
deals with more objective, rational, and technical knowledge
cumulative store of subjective or experiential learning.
most effective and efficient ways of doing things.