Database Concepts Chapter 1

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

PUR3622/RTV4930 Exam 1, PUR 3622 Examen 1, RTV 4930 Midterm 1, RTV 4930 Midterm (Quiz Questions 1-7), RTV 4930 Midterm 2, RTV 4930 Midterm 3, RTV4930 Modules, PUR4932, PUR 3622 Final, PUR3622 Week 9 - 15, PUR3622 Final, PUR3622 Midterm

View Set

Applied Behavior Analysis (Cooper)

View Set

Plate Tectonics and the Earth's crust

View Set

CHAPTER FIVE: SHORT-TERM WORKING MEMORY

View Set