Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
Does data increase or decrease?
The amount of data increases ezponentially with time.
What is Clickstream data?
Data collected about user behavior and browsing patterns by monitoring users activities when they visit a web site.
What is unstructured data?
Their content cannot be represented in a computer record like digital pictures, video, voice packets and musical notes.
Is data static?
No, data decays overtime.
Is data safe?
No, data security, quality , and integrity are easily jeopardized.
What is a data warehouse?
A repository of subject oriented historical data that are organized to be accessible in a form readily acceptable for analytical processing.
What is the data life cycle?
- collection of data
- storage of data
- data warehouse or mart
- data analysis
- results from the data
- solutions from the data
Collection of data?
- internal data
- external data
- personal data
Storage of data?
Data is stored in a data warehouse or data mart.
What is data analysis?
- Online queries
- executive dashboards
- decision support system
- data mining
What is data mining?
Process of extracting patterns from large sets of data.
What is a data mart?
A small data warehouse designed for a strategic business unit or department.
What is presented to users?
Both the data and knowledgeare presented to the users.
What is the database management system?
It porvides all users with access to all the data.
What is data redundancy?
the same data is stured in many places.
What is data isolation?
When applications can't access data associated with other applications.
What is data inconsistency?
When various copies of the data don't agree.
What is data integrity?
Data meet certain constraints, such as on letters in a social security number field.
What is data independence?
When applications and data are independent of one another, or when all applications are able to access the same data.
What is a bit?
A binary digit; that is a 0 or a 1.
What is binary?
Binary means that a bit can consist only of a 0 or a 1.
What is a byte?
A group of eight bits that represents a single character.
What does a byte consist of?
A byte can be a letter, number or a symbol.
What is a field?
A grouping of logically related characters into a small group of words, or a complete number.
What is a record?
A grouping of logically related fields.
What is a file or a table? Are they the same?
Yes, a file or table are the same. They are a grouping of logically related records.
What is a database?
A database is a group of logically related files that stores data and the associations among them.
What is a data model?
A definition of the way data in a DBMS are conceptually structured.
What is DBSM?
- Database Management System
- The software that provides access to a database.
What is an entity?
A person, place, thing, or event about which information is maintained in a record.
What is an attribute?
Each characteristic or quality describing a particular entity.
What is a primary key?
The identifier field or attribute that uniquely identifies a record.
What are secondary keys?
An identifier field or attribute that has some identifying information, but typically doesn't identify the file with complete accuracy.
What is an ER diagram?
- Entity Relationahip diagram
- A document that shows data entities and attributes and relationships among them.
What is an ER modeling?
- Entity Relationahip modeling
- The process of designing a database by organizing data entities to be used and identifying the relationships among them.
What are entity classes?
A grouping of entities of a given type.
What is an instance of a entity class?
A particular entity within an entity class.
What is an identifier?
An attribute that identifies an entity instance.
What do entities have?
Entities have attributes, or properties, that describe the entitys characteristics.
What is a binary relationship?
Relationships between two items.
What are three types of binary relationships?
- one to one
- one to many
- many to many
What is 1:1?
In a one to one, a single entity instance of one type is related to a single entity instance of another type.
What is 1:M?
In a one to many example, a professor can have many courses, but each course can have only one professor.
What is M:M?
In a many to many example, a student can have many courses, and a course can have many sturdents.
Why is entity relationship modeling valuable?
It's valuable because it allows database designers to talk with users throughout the organization.
Why are DBSM's valuable?
A DBSM maintains the integrity of store data, manages security, user access, and recovers information in case of system failure.
What is a relational database model?
Data model based on the simple concept of tables in order to capitalize on characteristics of rows and columns of data.
What is a flat file?
One big table that contains all of the records and attributes.
What is SQL?
Structured Query Language
What is QBE?
Query By Example
What is OLTP?
- Online Transaction Processing
- Online processing of business transactions as soon as they occur.
What is OLAP?
- Online Analytical Processing
- The analysis of accumulated data by end users.
What is multidimensional structure?
The manner in which data are structured in a data warehouse so that they can be analyzed by different views or perspectives, which are called dimensions.
What is explicit knowledge?
The more objective, rational, and technical types of knowledge.
What is tacit knowledge?
The cumulative store of subjective or experiential learning; highly personal and hard to formalize knowledge. For example: skill sets, trade secrets, know how, expertise, expierences, insights, understanding, learning.
This knowledge is typically not recorded.
What is KMS?
- Knowledge Management Systems
- Information technologies used to systematize, enhance and expedite intra and interfirm knowledge management.
What are best practices?
The most effective and efficient ways to do things.