01. Advanced Database Concepts

1. Database

2. Database Management System (DBMS)

3. Database Application

4. Users

What are the components of database system?

Database

What is an organized collection of structured information, or data, typically stored electronically in a computer system?

Database Management System (DBMS)

What serves as an interface between the database and its end-users or programs?

Database Management System (DBMS)

What allows users to retrieve, update, and manage how the information is organized and optimized?

• Performance monitoring

• Tuning

• Backup and recovery

A DBMS also facilitates oversight and control of databases, enabling a variety of administrative operations such as?

Database Application

What is a set of one or more computer programs that serves as an intermediary between the user and the DBMS?

• Application programs

• by sending DB query language to the DBMS

What does read or modify database data? And how?

1. Naive Users

2. Application Programmers

3. Sophisticated Users

What are the types of users?

Naive Users

Who are the unsophisticated users who interact with the system by using predefined user interfaces; such as web or mobile apps?

Application Programmers

Who are the computer professional who write application programs?

Sophisticated Users

Who interact with the system without writing programs? Instead they form their requests either using a DB query language.

Database System Architecture

What involves database design and construction on how the database will operate and function within existing structures and location?

1. Centralized Database System

2. Distributed Database System

What are the two main types of database system architecture?

Centralized Database System

What is the database that supports data located at a single site?

Distributed Database System

Which refers to a collection of multiple interconnected databases, and spread physically across various locations?

1. Structured Data

2. Unstructured Data

3. Semi-structured Data

What are the structures of data in DBMS?

Structured Data

Which refers to data that are stored in relational databases?

Structured Data

Which type of data uses a predefined and expected format or schema?

Unstructured Data

Which refers to data that exist in its original or raw state the can come in all shapes and sizes?

Semi-structured Data

Which refers to individual items of the same type may have different sets of attributes?

Semi-structured Data

Which contains semantic tags and there is no predefined schema?

Structured Data

What data structure does the example represent?

Unstructured Data

What data structure does the example represent?

Semi-structured Data

What data structure does the example represent?

1. SQL (Structured Query Language)

2. NoSQL

3. NewSQL

4. Object-Oriented DB

5. XML (Extensible Markup Language)

What are the types of database management system?

SQL (Structured Query Language)

What refers to a computer language for storing, manipulating, and retrieving data stored in a relational database?

NoSQL

What is generally used to describe a new generation of DBMS that is not based on the traditional relational database model?

Not only SQL

What does NoSQL stands for?

Big Data

NoSQL has been developed to address the challenges represented by what?

NoSQL

Which features a dynamic schema for unstructured data and the data can be stored in different ways?

NoSQL

What allows you to create documents without first having to carefully plan and define their structure?

NewSQL

Which incorporates and builds on the concepts and principles of SQL and NoSQL systems?

NewSQL

Which provides improved functionality and services, by combining the reliability of SQL with the speed and performance of NoSQL?

Object-Oriented Database

Which refers to a database that stores object rather than data as individual relations?

C++, Java and C#

Object-Oriented Database makes use of object-oriented languages such as?