CS 542 - Student Course Projects at WPI -- Fall 2003

• Dhayagude, Swapna S; swapna@wpi
  Shah, Malav Vikrambhai, mshah@wpi
  Patel, Hasmukh, hasmukh@wpi
  

  * A pull-based iterator execution framework for XQuery processing *
  Rainbow, the XML Query Processing Engine developed at WPI, features XQUERY to XAT algebra generation and XAT algebra logical optimization support. Currently, the query execution is done push-based, one query operator at a time. In this course project, we now will implement an iterator-based framework for query execution for Rainbow. Secondly, we will retarget the implementation of the individual algebra operators within XAT algebra to offer up this iterator-based API. Experimental studies assessing the performance of this execution will be conducted.

• Choy, Lisa Wan, lchoy@wpi
  Chong, Randy, stealth@wpi
  Lee, Joshua M, leejm@wpi
  
  * Database Conversion Tool (in doc format), (or, the html version). *
  Utility to convert from one vendor's DB to another vendor's DB, and vice versa. The generic tool will be applied to MySQL and Oracle as a case study. The general architecture consists of core DB-object-manager, Source-reader, DB-writer, converter, importer, and GUI.

• Diddee, Amit K, amitdd@wpi
  Banerjee, Kutty Subhash, kuttyb@wpi
  Kathuria, Aastha, aastha@wpi
  
  * Disk-based support for the Stream Query Engine RAINDROP *
  RAINDROP is a continuous stream processing engine developed currently being developed at WPI. Currently, the system assumes that all tuples currently in the system are kept in intermediate queues between the query operators. While a tuple store to keep and serve up the RID of such tuples has been developed, it yet remains to be intregrated with the RAINDROP operators. Our first task will be to accomplish this integration by as needed adjusting the implementation details of the existing query operators. Thereafter, we'll proceed to run experiments comparing the scalability of the engine before and after this extension. Secondly, if time permits, we'll complete the storage support of RAINDROP by also supporting the queues themselves as persistent queue structures (possibly with prefetching support).

• Ngo, Brandon, bngo1@wpi
  Tilkin, Doug, dtilkin@wpi
  Sarram, Pegah, pegah@wpi
  
  * Financial Application for finance and accounting support of Cambridge Associates *
  This Web-based Financial Application for finance and accounting support of Cambridge Associates will help the staff generate invoices for clients,and generate client assets and fees reports for analysis by management. Usage of ASP, Javascript, VBscript, and SQL Server 2000. Triggers, Constraints, indices and keys will be heavily used.

• Ao, Hong, hongao@wpi,
  Wen, Xiumei, wenxm@wpi,
  Zheng, Yi, zhengyi@wpi
  
  * AutoBest Store *
  This AutoBest Store will support online auto part shopping via auto part catalogs, shopping carts, order confirmations, and feedback by customers. Multiple databases including Sequel Server, ORacle and MySQL for multi-database querying will be included. l.tUosuupall application related to cutting-time calculation for mechanical parts. .NET technologies with SQL stored procedures, SOAP XML web services for B2B, and various DB access methods such as ADO, ODBC, oracle access kit.

• Oestergaard, Palle Soende, palle@wpi
  Mazumdar, Piyali, piyali@wpi
  
  * Online application and management of residential apartments (dorms). *
  This web application will enable residential managers to access and update information of housing applicants; including the creation of reports. Tools used will include MySQL and PHP. Final application is scheduled to be employed at the dorm complex in Danemark in the future.

• Yang, Jing, yangjing@wpi
  Wang, Weiwei, wwwnj
  
  * Sampling High-dimensional Space Using Cluster-Based iDistance Indexes. *
  The VHSI project aims to solve the problem of clutter in visualizating large scale, high-dimensional data sets. VHSI intents to allow users to interactively construct subspaces in a multi-resolution manner. In order to accomplish that, in this course project we'll develop a two-level index, called CBI structure, that keeps a summary of each data cluster in a summary tuple as well as a B+-tree with the actual data points in the cluster of such a subspace. The B+-tree will use the distance of the data points from some centre point as search key. Hence, high-dimensional range-queries can be processed against it in a two-step manner. First CBI is used to filter out the relevance of the clusters in terms of their contribution to a possible answer. Second, within one distance-based B+tree, we'll then investigate several sampling methods in order to retrieve the desired data at a desired sampling rate.

• Deshpande, Laxmikant, ldeshpan@wpi
  Nargund, Preeti, preetin@wpi
  Jarvis, Matthew, mjarvis@wpi
  
  * Software License Management Database application. *
  Management tools for an administrator to manage software licenses for inventory and legal purposes. Tools to be used include Java, JDBC-ODBC bridge, and Sequel Server 2000.

• Lele, Devdatta, leleda@wpi
  Sheth, Dhaval, dhaval@wpi
  Neha, lastname neha@wpi
  
  * Mobile Phone Billing Service System. *
  Mobile Phone Billing Service System will implement a post-paid nation wide billing service. Technologies include Oracle, PL/SQL, VB.

• Samant, Yogesh, yogesam@wpi
  Polavajram, Vinod, vrp@wpi
  
  * Asynchronous I/O and Prefetching *
  This project will be build on top of the MASS library; which is a buffer manager and associated XML index structure using B+tree tuned for XML query support. The goal of this project is to enhance the MASS Buffer Manager to enable it to do asynchronous I/O for prefetching pages from the disk storage blocks into the buffer cache. The Buffer Manager currently does all I/O synchronously. Reading ahead using asynchronous I/O when either the data accesses are predictable (as they are in our index case with multiple sequential accesses) will result in an improved throughput. Implementation is in C++.
  

• Fang, Yuxiao (Tracy), tfang@wpi
  Le, Tuan, tle@wpi
  Woldegabriel, Ermias, ermias@wpi
  
  * WFL Online Bookstore. *
  Application project to develop an online bookstore called WFL Book Store. The application will support browsing, search for books, memberships, issueing of purchase orders, paying of bills, and updating of personal information, as well as personal shelfing of books for viewing. Backend maintenance of inventory and such will also be supported. Using ASP, HTML, MS IIS web server, and MS Access (??).

• Percy, John D, jpercy@wpi
  Kaftanchikova, Rimma, rimma3@wpi
  
  * Online Classroom Management Application (OCMA) *
  Online Classroom Management Application is going to be a database-driven, web-based course management system which would enable teachers to prepare courses containing web pages, bulletin boards, forums, calendar, online assessment and student record management. Teachers would be able to post syllabi, readings, computer-based slideshows, spreadsheets, and links to other websites. Any digitized file can be made part of a course web site. In addition, teachers would be able to automate grading, and feedback to the students, and improve their record keeping. Whenever a teacher would post a homework or a reading assignment for the class, an email would be sent to the students enrolled in the class notifying them about the posting. Students would be able to post questions on the class forums, check their grades online (compare their statistics to the rest of the class), and send an email to the teacher. Stored procedures will be heavily used.
  Tools to be used for web development may include Visual Studio.NET, MS SQL Server 2000, and others.