Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASES AND INFORMATION MANAGEMENT Chapter 6 (Terms and Concepts (Bit,…
DATABASES AND INFORMATION MANAGEMENT
Chapter 6
Terms and Concepts
Bit
Byte
Field
Record
File
Entity
Attribute
Problems of traditional file
Data redundancy and inconsistency
Program-Data dependence
Lack of flexibility
Poor security
Lack of data sharing and availability
Database Management Systems (DBMS)
Minimize redundancy and inconsistency
Increased access and availibility
Reduced cost maintenance
Relational DBMS
Field (Attribute)
Row (tuples)
Key field
Primary key
Foreign key
Operations
Select
Join
Project
Capabilities
Querying
Reporting
Designing Databases
Normalization
Entity-Relationship diagaram
Improve Business Performance and Decision Making
Big data
Data warehouses and Data marts
Hadoop
In-Memory Computing
Analytic Platforms
Analytical tools
Online Analytical Processing (OLAP)
Data mining
Text mining & Web mining
Databases and the Web
Managing Data Resources
Information Policy
Data administration
Database administration
Data quality audit
Data cleansing
Gabriella Handoyo
EC-AK / 9 / 041611333147