L01 - Introduction Data Management Problems Traditional...

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

View Full Document Right Arrow Icon
Introduction
Background image of page 1

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

View Full DocumentRight Arrow Icon
CS174A: Introduction 2 Data Management Problems ± Traditional applications: Banking, financial, inventory, … ± New and emerging applications: Enterprise resource planning Wireless applications ± Challenges in data management : Querying: large volume, diverse formats, rich semantics Integration: distributed, different domains Updates: high rate of changes Cloud: scale, resource sharing, redundancy
Background image of page 2
CS174A: Introduction 3 An Imaginary Application Example ± A specialty retailer : many manufacturing sites, warehouses, and retail stores walk-in and online customers ± Data What? Why? How? ± Other requirements: availability, reliability, …
Background image of page 3

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

View Full DocumentRight Arrow Icon
CS174A: Introduction 4 What is a Database? A DBMS? ± A very large, integrated collection of data ± Models real-world enterprise Entities (e.g., students , courses , products ) Relationships (e.g., Hitchcock is taking CS174 ) ± A D atab ase M anagement S ystem (DBMS) is a software package designed to store and manage databases
Background image of page 4
CS174A: Introduction 5 Why Does Size Matter? ± Google search on “database” : 367,000,000 entries ± Some data collections are large in size ± (old) China Mobile: 1.6 Petabytes ± (old/older) Tera-Server ± (older) NASA EOS: 10 Petabytes ±
Background image of page 5

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

View Full DocumentRight Arrow Icon
CS174A: Introduction 6 Data Management Tools : Early Generations ± No standards, no abstraction Joe, 123, Shoe, . .. Jane, 456, Luggage, … File operations User/Application Programs Joe, 123, Shoe, . .. Jane, 456, Luggage, … File operations Operations on records User/Application Programs
Background image of page 6
CS174A: Introduction 7 Data Management Tools : Early Generations ± No standards, no abstraction Joe, 123, Shoe, . .. Jane, 456, Luggage, … File operations User/Application Programs Joe, 123, Shoe, . .. Jane, 456, Luggage, … File operations Operations on records User/Application Programs
Background image of page 7

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

View Full DocumentRight Arrow Icon
CS174A: Introduction 8 Data Management Tools : Relational and SQL ± More efficient application development SQL (transactions, concurrency, recovery) User/Application Programs
Background image of page 8
CS174A: Introduction 9 ± Organization / structuring ± Storage ± Access query update ± Control integrity security concurrency DBMS Functionalities queries updates concurrency integrity constraints
Background image of page 9

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

View Full DocumentRight Arrow Icon
CS174A: Introduction 10 Why Should We Use a DBMS? A DBMS provides:
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/02/2010 for the course CS 174a taught by Professor Zhin during the Fall '09 term at UCSB.

Page1 / 30

L01 - Introduction Data Management Problems Traditional...

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

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