Chapter 3 : Database Management Systems Flashcards
What is a database ?
A database is a collection of information stored within a computer
What is DBMS?
a Collection of programs that allow users to create and maintain a database , it facilitates the following processes:
* Defining a database
* Constucting a database
* Manipulating a database
* Sharing a database
What are Operational Databases ?
Operational Databases are critical to day-to-day business tasks , it alters and manipluates data in real time
What is a Commercial Database?
they are used for commercial businesses , users have to pay to use them.
What is Open Source Database?
A Database that is free to access and alter for everyone at all time
What is Hierarchichal Database?
A database that stores information in a parent-children relationship nodes
What is a network database?
Follows the network structure , evey record can have multiple relationships with various records
What is Relational Database?
Based on the relational model , stores information in rows , columns and uses SQL to store data
What are the properties of Relational Database?
- A : ATOMIC
- C : Consisten
- Isolated
- Durable
What is Object oriented Database?
A database that uses objects , classes , it combines relational database with object oriented programing
What is Centralized Database?
Database that saves information at a centralized database system
What is a Distributed Database?
A database that stores information within different database systems.
What is the CAP theorem?
C: consistency
A: Availabilty
P: Partition tolerance
What is BASE Transaction Model?
Basically Available
Soft State
Eventually consisten
What is NoSQL database?
Nosql is used to store a wide range of data , it has a hierarchical structure and can store unstructured data
