ch3 - Database System Concepts 5th Ed ©Silberschatz Korth...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database System Concepts, 5th Ed . ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use Chapter 3: SQL Chapter 3: SQL ©Silberschatz, Korth and Sudarshan 3.<number> Database System Concepts, 5 th Ed., June 2006 Chapter 3: SQL Chapter 3: SQL ■ Data Definition ■ Basic Query Structure ■ Set Operations ■ Aggregate Functions ■ Null Values ■ Nested Subqueries ■ Complex Queries ■ Views ■ Modification of the Database ■ Joined Relations** ©Silberschatz, Korth and Sudarshan 3.<number> Database System Concepts, 5 th Ed., June 2006 History History ■ IBM Sequel language developed as part of System R project at the IBM San Jose Research Laboratory ■ Renamed Structured Query Language (SQL) ■ ANSI and ISO standard SQL: ● SQL-86 ● SQL-89 ● SQL-92 ● SQL:1999 (language name became Y2K compliant!) ● SQL:2003 ■ Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features. ● Not all examples here may work on your particular system. ©Silberschatz, Korth and Sudarshan 3.<number> Database System Concepts, 5 th Ed., June 2006 Data Definition Language Data Definition Language ■ The schema for each relation. ■ The domain of values associated with each attribute. ■ Integrity constraints ■ The set of indices to be maintained for each relations. ■ Security and authorization information for each relation. ■ The physical storage structure of each relation on disk. Allows the specification of not only a set of relations but also information about each relation, including: ©Silberschatz, Korth and Sudarshan 3.<number> Database System Concepts, 5 th Ed., June 2006 Domain Types in SQL Domain Types in SQL ■ char(n). Fixed length character string, with user-specified length n. ■ varchar(n). Variable length character strings, with user-specified maximum length n. ■ int. Integer (a finite subset of the integers that is machine-dependent). ■ smallint. Small integer (a machine-dependent subset of the integer domain type). ■ numeric(p,d). Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point. ■ real, double precision. Floating point and double-precision floating point numbers, with machine-dependent precision. ■ float(n). Floating point number, with user-specified precision of at least n digits....
View Full Document

This note was uploaded on 04/28/2010 for the course CSE cse123 taught by Professor Benny during the Spring '10 term at LSU Eunice.

Page1 / 66

ch3 - Database System Concepts 5th Ed ©Silberschatz Korth...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online