Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE, database records, data - Coggle Diagram
DATABASE
What is Data?
collection of a distinct unit of information
information that can be translated
What is a Database?
organized collection of structured data
a library
Databases have evolved in 1960s
Navigational databases were the original system
to store
to manipulate
Relational databases
(1980s) became popular
NoSql
response to the growth of the internet
Cloud databases
new ground how data is:
collected
stored
managed
utilized
Database Components
Hardware
physical electronical devices
Software
set of programs
used to control and manage the overall Database
Data
Database collects them
Procedure
rules on how to use the Database
Database Access Language
to access the data to and from the Database
What are the Types of Databases
Relational Database
collection of information
organizes data in relationship
in one or tables (relations)
Object-Oriented Database
organized aroud objects
Distributed Database
NoSQL Database
non-tabular databases
store data differently
Graph Database
Cloud Database
built to run in a public or hybrid cloud
to help organize data eithni an organization
Centralization Database
Operational Database
Database Management System (DBMS)
software that is used to manage the Database
Receives instruction from Database Administartor (DBA)
to load or modify existing data
it serves as an interface between
database
database end-users
What is SQL?
Relational Databases
used to
insert
search
update
delete
modify
ADVANTAGES
Reduce data redundancy
Reduced updating errors
Easier data integrity
Improved data access
Data security
Reduced data entry
DISADVANTAGES
Complexity
Cost
Security
Compatibility
database records
data