ics321-20090929-project

Ics321-20090929-proj - 3 DBMS vs FS Indexer • Pick a DBMS software Say DB2 • Pick an FS indexer Say Win FS Apache Lucene • Implement the

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 Toy Course Project Asst. Prof. Lipyeow Lim University of Hawaii at Manoa 9/8/2009 1 Lipyeow Lim -- 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
Book Catalog for Internet Store Requirements: Read-intensive workload. Many concurrent users. Reasonably responsive browsing experience Query features: Keyword search Multi-faceted browsing Hierarchical topic navigation Measures: Latency of processing the various query features Throughput: number of concurrent users Cost ? 9/8/2009 Lipyeow Lim -- University of Hawaii at Manoa 2
Background image of page 2
Possible Questions for Investigation DBMS vs file-system + text indexer ? Using a DBMS what are the different ways of supporting keyword search, multi-faceted search, hierarchical navigation ? What table/schema design is needed for multi- faceted search ? MySQL: which storage engine is suitable ? Too many questions? Just pick a couple to tackle for the project ! 9/8/2009 Lipyeow Lim -- University of Hawaii at Manoa
Background image of page 3

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

View Full DocumentRight Arrow Icon
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: 3 DBMS vs FS+Indexer • Pick a DBMS software. Say DB2. • Pick an FS+indexer. Say Win FS + Apache Lucene • Implement the required query features for these two setups. • Setup a testbed – Get some real data or generate synthetic and load the data into our setup – Get a “driver” to simulate users browsing books, i.e. a multi-threaded program that fires queries against our system. – Instrument a way to measure the latency and throughput. • Run the driver and collect measurements over the two setups possibly over different parameters. 9/8/2009 Lipyeow Lim -- University of Hawaii at Manoa 4 Analyze the results • Analyze the results • If something is not right, – investigate, – tweak your setup, – rerun, – re-analyze. • Based on your results what are your conclusions and recommendations ? 9/8/2009 Lipyeow Lim -- University of Hawaii at Manoa 5 2 4 6 8 10 12 14 Series 3 Series 2 Series 1...
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-20090929-proj - 3 DBMS vs FS Indexer • Pick a DBMS software Say DB2 • Pick an FS indexer Say Win FS Apache Lucene • Implement the

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