1 / 6

ICS 321 Fall 2009 A Toy Course Project

ICS 321 Fall 2009 A Toy Course Project. Asst. Prof. Lipyeow Lim Information & Computer Science Department University of Hawaii at Manoa. Book Catalog for Internet Store. Requirements: Read-intensive workload. Many concurrent users. Reasonably responsive browsing experience

brick
Download Presentation

ICS 321 Fall 2009 A Toy Course Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ICS 321 Fall 2009A Toy Course Project Asst. Prof. Lipyeow Lim Information & Computer Science Department University of Hawaii at Manoa Lipyeow Lim -- University of Hawaii at Manoa

  2. 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 ? Lipyeow Lim -- University of Hawaii at Manoa

  3. 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! Lipyeow Lim -- University of Hawaii at Manoa

  4. DBMS vsFS+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. Lipyeow Lim -- University of Hawaii at Manoa

  5. 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 ? Lipyeow Lim -- University of Hawaii at Manoa

  6. Lipyeow Lim -- University of Hawaii at Manoa

More Related