A

Home Senior Project 2007 Links

Senior Project 2007

Welcome to my senior project site where I will be trying my best to do my part with the Morpheus project team!

Morpheus Database Documentation and Design

“The Morpheus project uses a Postgres DBMS to manage Morpheus objects including data types and data transformations (plus Java code) and their metadata. The relational schema also includes tables storing information on a large set of categories that are used to classify all Morpheus objects. Since the schema has evolved over time, the existing documentation is sketchy.” –P.J.Dobbins

Project Goals

1. Document the existing schema using the extended E/R model.
 
The schema design document will be made with MS PowerPoint and Visio. Information to be included in the 
documentation will be constraints that hold on the schema.

2. Identify possible redundancies and anomalies in the existing schema.
 
If redundancies and anomalies are present, suggest ways to streamline and improve the design. This also 
includes providing test data that can be loaded into the tables for testing of the schema and creating maintenance 
routines to dump the schema and data and to create and load an empty database.

Events Log

My own log to keep track and remind myself of what I have been working on through out the semester.

Date	Activity	Description
1.16.2007	Meeting	Met with Prof. Dobbins to discuss more details about senior project (website, goals, meetings). Individual meeting times will be on Fridays at 9:30AM
1.18.2007		Senior project website created, started Gantt chart
1.19.2007	Meeting	9:30AM—Senior Project meeting
1.23.2007	Meeting	2:00pm-3:00pm--Morpheus group meeting
1.23.2007		Installed pgAdmin, accessed thalia database and have started examining current tables. Goal: examine 1-2 tables in depth, and examine in breadth 3-4 tables.
1.26.2007	Meeting	9:00AM-10AM group meeting (UF&MIT)
1.26.2007	Meeting	1:00pm—senior project meeting
1.30.2007	Meeting	UF group meeting
2.1.2007		Called Mujde to discuss the current state of the database. Findings: many duplicates of tables in many schemas, tables misplaced in schema, misnomers of tables, some tables are no longer used. Discussion of new schemas for executing Morpheus database. (Some light bedtime reading: Word doc on schema)
2.2.2007	Meeting	12:00pm, v2 of E/R diagrams, schema. Conference call with Dr. Hammer and Pete. Discussion: how to display the connection/relation between the different schemas, steps to clearly define the current database in order to create a cleaner database design. Other topics discussed was the use of reverse engineering the database using Microsoft Visio. Plans to be discussed at next meeting: 1. Draw up a list of tables. 2. Identify redundancies. 3. Identify relationships 4. Create a document for members to identify tables, describe what the table does, identify the author of the table, confirm the table is being used, list the location/classes tables are used.
2.6.2007	Meeting	UF group meeting: Table Inventory This document will be sent out to all group members to edit and add the necessary information. 1 page paper due on 2/9 describing what work/progress made and proposed work.
2.8.2007		The Revised Table Inventory with Mujde and Dev’s input (merged document). This document holds the schemas with their tables and their descriptions.
2.9.2007	Meeting	Senior Design meeting: 1 page spec due, assigned 2/6 Note to Self: 2 pg spec on individual work, submit final documents to repository Topics discussed at meeting: Finish up the final proposed E-R diagram and schema. Steps needed to complete task: 1. Have all feedback from all group members that edit and/or use database 2. Talk to Dr. Hammer, Mujde, Dev to make sure current db design is factual, then 3. Have all group members review the proposed E-R diagrams and schema. Start to think about PLJAVA installation procedure by attempting to use current documentation on installing PLJAVA, install postgres
2.13.2007	Meeting	UF group meeting. (proposed version of public schema, still waiting for Mujde and Dr. Hammer’s input)
2.15.2007	Phone	Discussing with Dr. Hammer public schema. (Table Inventory, public schema, proposed public schema)
2.16.2007	Meeting	2 page write up of semester’s tasks.