Database Concepts Chapter 1
User client interface for Oracle MySQL 5.6 Community Server
MySQL Workbench
User client interface for Oracle Database
Oracle SQL Developer
Database
Self describing collection of related tables and other structures
Database Application
Set of one or more computer programs that serves as an intermediary btwn the user and the DBMS
Structured Query Language
leading technique for data definition and manipulation; international language for processing tables in relational databases
Concurrency
one users work does not interfere with another user's work
4 components of a database system
> Users > Database Application > Database Management System > Database
DBMS
A computer program used to create, process, and administer the database Receives request in SQL and translates into actions .
NoSQL
A database that does not use SQL; a nonrelational database ex. Web 2.0 apps like Facebook, Twitter, Pinterest
Functions of a database application
Create and process forms Process user queries Create and process reports Execute application logic Control application
Functions of a DBMS
Create database Create Tables Create supporting structures (indexes) Read & Modify database data Maintain database structures Enforce rules Control concurrency Provide security Perform backup and recovery
Metadata
Data about the structure of a database
Users
Employ a database application to keep track of things. Use forms to read, enter, and query data and produce reports
Referential Integrity Constraints
Every value of a foreign key must match a value of an existing primary key
Personal database system
Few tables, at most several hundred rows
Enterprise class database systems
Hundreds of tables, millions of rows, and supports concurrent users
Examples of commercial DBMS
Microsoft SQL Server Oracle Corporation's MySQL Oracle Corporation's Oracle Databases IBM's DB2
User client interface for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Management Studio