1 / 6

ICS 321 Fall 2009 A Toy Course Project

This project analyzes the performance of a DBMS versus a file-system with a text indexer for managing an online book catalog for the Information & Computer Science Department at the University of Hawaii. Requirements include handling a read-intensive workload, supporting many concurrent users, and providing a responsive browsing experience. Key query features involve keyword search, multi-faceted browsing, and hierarchical topic navigation. The project will assess latency, throughput, and cost implications while implementing and testing query features in two setups. Results will guide recommendations for optimal data management solutions.

brick
Télécharger la présentation

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