Lecture_1_-_Introduction_to_Database_System

Lecture_1_-_Introduction_to_Database_System - CSCI 507...

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

View Full Document Right Arrow Icon
1 CSCI 507 Database Theory Introduction to Database Systems 2 Course Description Introduction to the design and development of database systems. ER (entity-relationship) approaches to data modeling Relational model of database management systems (DBMSs) Use of query languages such as SQL. Relational algebra and Calculus SQL and query processing Transaction management Distributed Database, XML databases, data warehousing and data mining.
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 3 Academic: s Databases involve many aspects of computer science s Fertile area of research s Three Turing awards in databases Programmer: a plethora of applications involve using and accessing databases Businessman: Everybody needs databases ) lots of money to be made. Student: ??? s Get those last three credits and I don’t have to come back to School ever again!!! s IBM, Oracle, Microsoft, and Oracle will hire me!! s Get pay raise! s Databases sound cool! Why Study Database? 4 Implementation: How do you build a system such as ORACLE , MS SQL Server, MySQL, or other? Design: How do you model your data and structure your information in a database? Programming: How do you use the capabilities of a DBMS? CSCI507 achieves a balance between a firm theoretical foundation to designing moderate-sized databases and creating, querying, and implementing realistic databases What will you learn in CSCI507?
Background image of page 2
3 5 Course Objectives Understand advantages of a DBMS over file system data management Understand the fundamental database and RDBMS concepts Understand a business need for a relational database, and design a system that meets the business requirements. Understand fundamental database design concepts, and the role of normalization of data. Be able to design database through E/R diagrams Be able to use SQL to create a database, database objects, and queries Be able to write sophisticated database queries using SQL and optimal queries with indexing Understand transaction management in maintaining data quality and integrity Be able to create databases in an RDBMS and enforce data integrity constraints using SQL. Understand tradeoffs between different ways of phrasing the same query. Lecture 1 Introduction to Database System 6
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Objectives In this lecture, you will learn: • The difference between data and information • What a database is, the various types of databases, and why they are valuable assets for decision making • The importance of database design • How modern databases evolved from file systems 7 Objectives (cont’d.) • About flaws in file system data management • The main components of the database system • The main functions of a database management system (DBMS) 8
Background image of page 4
5 Introduction • Good decisions require good information derived from raw facts • Data is managed most efficiently when stored in a database • Databases evolved from computer file systems • Understanding file system characteristics is important 9 Why Databases? • Databases solve many of the problems
Background image of page 5

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

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

Page1 / 28

Lecture_1_-_Introduction_to_Database_System - CSCI 507...

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