ics321-20090827-tour - – One file per array or many files...

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

View Full Document Right Arrow Icon
ICS 321 Fall 2009 A Quick Tour of Data Management Issues 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
Lipyeow Lim – University of Hawaii at Manoa 2 Internet Book Store Example Catalog of books ISBN, title, author, qty_in_stock, price, year_published Customers CID, Name, address Orders ISBN, CID, cardnum, qty, order_date, ship_date
Background image of page 2
Lipyeow Lim – University of Hawaii at Manoa 3 Non-Database Solutions Datastructure design eg. should cardnum be part of orders or customers structure ? Unique identifiers and references. eg. orders.isbn references books.isbn Updating multiple copies of data can be tricky In-memory array of objects Search and insert algorithm closely tied to ordering of items in array Auxiliary “index” arrays can be used for searching on multiple attributes
Background image of page 3

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

View Full DocumentRight Arrow Icon
Lipyeow Lim – University of Hawaii at Manoa 4 Non-Database Solutions (cont) File-based solutions
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: – One file per array or many files per array ? – All data on disk with indexes in memory? Cache some data in an in-memory array ? Search becomes tricky. – How should the data items in each file be ordered ? – Random access is slow for files sitting on hard disks ● Supporting multiple concurrent users – How do we ensure correct semantics when multiple users need to update or write to the same data item ? – What happens if the customer's browser crash in the middle of purchasing a book ? Lipyeow Lim – University of Hawaii at Manoa 5 Database Solution ● Start the DBMS software ● Create a database for the internet store ● Connect to the database ● Create the tables for the data – For now let's stick with the naïve 3 table design ● Inserting data into the tables ● Updating data in existing tables ● Querying a single table using SQL queries ● Querying multiple tables by joining them together...
View Full Document

This note was uploaded on 11/15/2010 for the course ICS 321 taught by Professor Lim during the Fall '09 term at University of Hawaii, Manoa.

Page1 / 5

ics321-20090827-tour - – One file per array or many files...

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

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