-
Clickstream Data
are data that visitors and consumers produce when they visit a website and click on hyperlinks
-
Data rot
it refers primarily to problems with the media to which the data are stored
-
Data Life Cycle
- Data Sources (Internal, External, and Personal Data)
- Data Analysis
- Result
- Solutions
-
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
-
Data Redundancy
The same data are stored in many places
-
Data isolation
Applications cannot access data associated with other application.
-
Data Inconsistency
Various copies of the data do not agree.
-
Bit
represents the smallest unit of data a computer can process
-
-
Field
a logical group of characters into a word, small group of words, of an indentification #.
-
Record
A logical grouping of related fields compose a record.
-
file or table
A logical grouping of related records
-
Database
A logical grouping of related tables
-
Data model
Is a diagram that represents entities in the database and their relationship
-
Entity
is a person, place, thing or event
-
Attribute
Each characteristics or quality of a particular entity
-
-
Secondary keys
student's majors
-
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
-
Query Language
most popular query language used to request information
-
Query by example
Another way to find info in a data base
-
Data Dictionary
It defines the format necessary to enter the data into the database.
-
normalization
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.
-
Data Warehouse
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
-
Data Mart
is a small data warehouse that is designed for the end user's needs in a strategic business unit or department.
-
Data Governance
is an approach to managing information across an entire organization
-
Master Data
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.
-
Explicit knowledge
deals with more objective, rational, and technical knowledge
-
Tacit knowledge
cumulative store of subjective or experiential learning.
-
Best Practices
most effective and efficient ways of doing things.
|
|