Week 1 Flashcards
(24 cards)
Raw, unorganized facts that need to be processed
Data
Two types of data
Structured (Numbers, Dates, Text) and Unstructured (Audio, Image, Video) Data
When data is processed, organized, structured or presented in a given context so as to make it useful.
Information
Two types of databases
Relational and Non-Relational Databases
What is data about data. Data that is describes the properties or characteristic of end user data and the context of those data.
Metadata
Shared, integrated computer structure that stores a collection of end-user data and metadata.
Databases
Raw facts of interest to the end user
End-user data
Collection of programs that manages the database structure and control the access of the data stored in the database.
Database Management System.
Types of Database?
By User.
Single-user Database
Multiuser Database
Type of Database?
By Location.
Centralized Database
Distributed Database
Cloud Database
Type of Database?
By Data Usage.
General- Purpose Database
Disciplined-Specific Database
Type of Database?
By Data Sensitivity.
Operational Database
Analytical Database
Type of Database?
By Degree Structure.
Unstructured Data
Structured Data
Semi structured Data
Type of Database?
Specialized Database.
XML Database
NoSQL Database
Evolution of File System Data Processing?
Manual File System -> Computerized File System -> File System Redux: Modern End-User Productivity Tools
What are File processing System Limitations?
- Lengthy
- Difficulty of getting quick answers
- Data Redundancy
- Lack of Security
- Extensive Programming
-Data Dependency
What are issues with data redundancy?
- Poor data security
- Data inconsistency
- A data anomaly
Advantages of DBMS?
- Reduce data redundancy (duplication)
- Remove data inconsistency
- Better data integration
- Improved data Sharing
- Improved data security
- Guaranteed atomicity
- Providing backup and recovery services
- Improved decision making
- Improved end user productivity
- Structural and Data Independence
Disadvantages of DBMS?
- Increased Cost
- Management Complexity
- Maintaining Currency
- Vendor Dependence
- Frequent Upgrade/Replacement Cycles
Refers to an organization of component that defines and regulate the collection, storage, management, and use of data within a database environment?
Database System
What are the database system components (five)?
- Hardware
- Software
- People
- Procedure
- Data
A conceptual framework for DBMS that aims to separate concerns and provide data independence?
ANSI/SPARC 3-Level Architecture
What are the 3 Levels of ANSI SPARC Database system.
- View Level
- Logical Level
- Physical Level
