CSE 772 - Winter 2008
Information Systems Project

Description:

Information system design and development principles: requirement analysis, database design methods and tools, process design, application development tools, testing, evaluation and documentation. Group Term Project.

CSE 772 is a capstone design course focusing on information systems projects. It is appropriate for undergraduates in the information systems or software systems options in either ENG or ASC. A capstone design course is required for ENG students. Other software systems students may count this course for the ``software lab elective''. Other information systems students may count it as a technical elective. The course is also appropriate for graduate students interested in software engineering and/or database design.

Industry is now requiring systems-oriented people who can work effectively in teams. CSE 772 will help you to improve your skills in individual and group time management, project scheduling, professionalism, communication, and teamwork.

Prerequisites:

560; 616 or 757; 601; 670

Meeting Times:

MWF 11:30 - 12:18, DL 357

Instructor:

Hakan Ferhatosmanoglu, 689 Dreese, 292-6377, email: hakan@cse.ohio-state.edu

Instructor's Office Hours:

M 1:30-2:30 and M W after class, or by appointment.

Teaching Associate:

Mike Gibas, 674 Dreese Labs, email: gibas@cse.ohio-state.edu

TA's Office Hours:

W 1:30pm-2:30pm, F 10:30am-11:30am, or by appointment.

Approximate Syllabus

An overview of CSE 772

Project Descriptions by Instructor - If you have a specific project in mind, you can present it to the class on January 9 or January 11. Just let me know in advance.

HW#1 Project Choice-due Friday, January 11 before midnight (by email)

(Individual)

HW#2 Project Proposal-due Friday, January 18- Before Class

(Group)

Sample Proposal (Image Search Engine)

Group Progress & Technical Presentations

HW#3 Individual Project Plan Due Wednesday, February 6- Before Class

(Individual) Grade yourself

Final Report Due March 13, 3pm

Individual Report Due March 13, 3pm

The Project:

There are seven options. Each of these projects will help you to work on a modern database application which has a strong potential. The programs/algorithms needed for the search engine projects may be available online and you are welcome to use them. However, it's important to come up with a good design and choose suitable and efficient programs/algorithms. In your final report, you are expected to discuss the superiority of your design and implementation over other possible approaches. The project development will include presentations, progress reports, and a final report.

Web-based Image Search Engine (Group size 3-4)

Design and implementation of an image database and a web-based search engine. Popular search engines, e.g. google.com, have started incorporating image search in their systems, but they are still very primitive.

Web-based Latent Semantic Text Search Engine (Group size 3-4)

Design and implementation of a LSI search engine. LSI tries to take advantage of the conceptual content of documents, i.e. instead of searching on individual terms; the search is performed on concepts. The engine will be able to search documents based on their meaning rather than text matching.

Web-based Bitmap Index System (Group size 3-4)

Design and implementation of a bitmap index system to support fast query processing over large-scale data. Bitmaps have been widely used in commercial database software tools to take advantage of hardware supported bit operations.

Web-based Biosequence Search Engine (Group size 4-5)

Design and implementation of a search engine for biosequences, i.e., DNA and protein sequences. The engine will be able to search sequences based on exact and similarity matching criteria.

Doctor-Community.com (Group size 2-3)

Design and implementation of a database management system and a user-friendly interface for an online community where doctors and patients can interact and communicate important health issues. This non-profit project was proposed by Alice Barczac, who was seeking consultation from OSU.

Individualized Research & Development Project (Group size 1-2)

Design and implementation of a proof-of-concept or performance evaluation of various design principles for a timely research problem. To identify potential projects parallel to the goals of the course, please contact the instructor. There are 8 available as of now.

Your own project (Group size 2-3)

You can also propose your own project. The project must be parallel to the intended goals of the course, and a detailed proposal must be submitted in the second week of the quarter.

Grading:

Progress: 45 %

Progress reports (4)

Presentations

Midterm Demo (7th week)

Final Demo and Report:   40 %

Participation:   15 %

Recommended Texts:

Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, Third Edition, Benjamin/Cummings, 2000.

V.S. Subrahmanian, Principles of Multimedia Database Systems. The Morgan Kaufmann Series in Data Management Systems, Jim Gray, Series Editor, 1998, ISBN 1-55860-466-9

D. A. Ruble, Practical Analysis & Design for Client/Server & GUI Systems, 1997.

References:

Google and Altavista Search Engines

IBM's Image Search Engine: http://wwwqbic.almaden.ibm.com/

BLAST Biological Search Engine: http://www.ncbi.nlm.nih.gov/BLAST/

SQL Tutorial PDF

MS Access Report Writer PDF

Connecting MS Access to Sybase

C. Faloutsos, R. Barber, M. Flickner, J. Hafner, W. Niblack, D. Petkovic, and W. Equitz. Efficient and effective querying by image content. Journal of Intelligent Information Systems, 3:231--262, 1994. (Paper 20 from http://www.cs.cmu.edu/~christos/jpub.html)
Other Reference Manuals on Sybase, WWW & HTML, Perl & Sybperl, C & Embedded SQL

Last year’s groups’ pages