Recommended Topics
You can choose one topic among any category below for your term project. The purpose of this project list is to provide you with choices of different aspects of database systems, both theoretically and practically. You can work as a group (up to 3 with approval) or individually. If you decide to work as a group, you have to specify the part done by each member of the group both in your proposal and in your term report. Everyone (or a team) must submit a proposal. The proposal should include the title, description, significance, hardware and software involved, the procedure to work on, and the items to be delivered at the end of the project.
A. Application Development or Implementation
• Multimedia DBMS Implementation : Implement a small multimedia database system in a chosen application. You can use any tool.
· Social Media DBMS Implementation: Implement a small social media database system in a chosen application. You can use any tool.
· Social Network DBMS Implementation: Implement a small social network database system in a chosen application. You can use any tool.
• A case Study of Query Optimization in Oracle: Pick up a few techniques for query optimization in Oracle and perform case studies with sample queries.
• Automatic Populations of Database Data: How do you automatically populate data for a given schema? The data could be real, simulated or fake.
• Case Study: If you have any interesting DB-related SW, implement a small application. Then evaluate the SW and the application based on your experience.
B. Survey or Research Topics
Pick up a topic and produce about 20 pages long report based on your study. Survey topics need to study the state of the art and the state of practice of a given problem. A survey should be comprehensive, include as many summary tables and figures as possible, and discuss strengths and weaknesses of approaches or systems. Report should be organized in a logical sequence. References should be properly cited and listed at the end of a report. A research topic does an in-depth study of a chosen topic. Please provide an executive summary, at most one page long, at the beginning of the survey document.
• Data Cleaning: Study the state of the art and state of practice in Data Cleaning Tools and Data Cleaning Systems.
• Data Mining: Study the state of the art and state of practice in Data Mining Software Tools and Data Mining Software Systems.
· Social network Analysis: Study the state of the art and state of practice in Social Network Analysis Software Tools and Data Mining Software Systems
· Social Media Analysis: Study the state of the art and state of practice in Social Media Analysis Software Tools and Data Mining Software Systems
• Web Personalization: Study the state of the art and state of practice in Web Personalization Techniques, Tools and Systems.
• Database Security: Study the state of the art and state of practive in Database Security Approaches and Systems.
• Data Mining and Information Security: Study the state of the art and state of practice on techniques used to protect the disclosure of private information or knowledge hidden in databases, from various data mining techniques.
• Multimedia DBMS: Study the state of art and the state of practice in multimedia DBMS. What are the hot issues which will be addressed in next few years? Some suggested topics include: multimedia data model, content-based retrieval, or multimedia indexing. You may focus on just one topic.
• DB-Driven Web Systems. Do a survey on the various tools for developing DB-driven web sites and e-commerce systems. You may develop a small prototype.
• Technologies for E-Commerce. Do a survey on the use of underlying technologies for E-Commerce. Issues include interface with existing systems, communication technologies, programming environment for building E-commerce businesses, HW and SW infrastructures, known problems and limitations of the current technology, etc.
• DB Design for E-Commerce. Study the issues and techniques for database modeling and design for E-business (customer, merchandise, billing, shipping, etc), handling of security such as credit card and SSN, return policy and procedures, etc. You may also do a small case study for an E-commerce environment. Other Issues could include the handling of multimedia and semi-structured data, translation of paper catalog into a Web database, DB design supporting user interface (navigation, hyperlinks, store layout, FAQ, helps, services, policies, shopping cart metaphor, …), schema and data evolution (category of products, naming, prices, …)
• A Survey of Data Warehousing Projects
Survey the various DW projects. Document their problem type, purpose, usages, architecture, tools, any HW, SW used, cost, current status, any particular features, failed reasons, etc.
C. Your own topic
If you have other topic under either implementation or research category, submit a proposal, for approval, including nature and scope of the problem, methodology, involved hardware, software, deliverable at the end of project completion, and any known references.