ics321-20090901-intro - ICS 321 Fall 2009 Introduction to...

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

View Full Document Right Arrow Icon
ICS 321 Fall 2009 Introduction to Database Systems Asst. Prof. Lipyeow Lim Information & Computer Science Department University of Hawaii at Manoa
Background image of page 1

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

View Full DocumentRight Arrow Icon
A database : a collection of related data. Represents some aspect of the real world (aka universe of discourse). Logically coherent collection of data Designed and built for specific purpose Data are known facts that can be recorded and that have implicit meaning. A database management system (DBMS) is a collection of programs that enables users to create and maintain a database Source: Fundamentals of Database Systems (5 th ed.), Elmasri/Navathe
Background image of page 2
On-line Transaction Processing (OLTP) On-line Analytical Processing (OLAP) Data warehouses, data marts Business intelligence (BI) Specialized databases Multimedia XML Geographical Information Systems (GIS) Real-time databases (telecom industry) Special Applications Customer Relationship Management (CRM) Enterprise Resource Planning (ERP) Hosted DB Services Amazon, Salesforce
Background image of page 3

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

View Full DocumentRight Arrow Icon
Files vs DBMS Swapping data between memory and files Difficult to add records to files Security & access control Do optimization manually Good for small data/files Run out of pointers (32bit) Code your own search algorithm Search on different fields is difficult Must protect data from inconsistency due to concurrency Fault tolerance – crash recovery
Background image of page 4
Lipyeow Lim – University of Hawaii at Manoa Why use a DBMS ? Large datasets Concurrency/ multi-user Crash recovery Declarative query language No need to figure out what low level data structure Data independence and efficient access. Reduced application development time. Data integrity and security. Uniform data administration.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Requirements Conceptual database design Logical database design Data definition language (DDL), data manipulation lanugage (DML) Testing environment Production environment
Background image of page 6
Lipyeow Lim – University of Hawaii at Manoa Data Models A data model is a collection of concepts for
Background image of page 7

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

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

Page1 / 20

ics321-20090901-intro - ICS 321 Fall 2009 Introduction to...

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

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