1 / 23

Databases and Innovative Systems for the Community

Databases and Innovative Systems for the Community. Design Review Fall 2009. Team Overview. Team formed Fall 2009. Derived from JDS Broader Scope Currently consists of one project. Team Mission.

sine
Download Presentation

Databases and Innovative Systems for the Community

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. Databases and Innovative Systems for the Community Design Review Fall 2009

  2. Team Overview • Team formed Fall 2009. • Derived from JDS • Broader Scope • Currently consists of one project.

  3. Team Mission “To assist non-profit, educational, and service agencies with their database and software problems. DISC provides these organizations with new or revised innovative solutions so that they can meet their community needs.”

  4. JDS Project • Users • Parolee officers from Tippecanoe County • Need • Provide web access to parolee information. • User-friendly • Secure

  5. Project Partner • Tippecanoe County Probation Department • Tippecanoe County Courts through the • Supervision of adult and juvenile offenders

  6. Project History & Current Status • Delivered an output in 2002 • Changed Project Scope in 2005 • Currently Access Based system • Problems: • Lack of Security • Non web – accessible • MS Access for Database

  7. Our Product • User connects to database. • User enters search information. • Information is loaded in different tabs. • Profile • Legal Notes • Case Notes • Assessments • Etc. • Ability to browse through search results • Ability to update the database.

  8. Project Expectations • Delivery for this semester: • Profile, legal, case notes tabs. • Secure connection. • User login.

  9. After Alpha • Finish rest of tabs. • Load pictures from database. • Have the ability to modify and add or remove records.

  10. Proposed System in 2005

  11. Proposed System in 2005 Front End Middle Back End SOAP HTTPS SQL ADO .NET Axis Client Microsoft Internet Information Server (IIS) SQL Server Database C# Web Service JavaJDS GUI Client Port 443 ASP .NET

  12. New System Proposal Front End Middle Back End SSL SQL ADO .NET Axis Client Microsoft Internet Information Server (IIS) MS Access C# Web Service JDS- C# GUI Client Port 443 ASP .NET The backend is provided by the project partner.

  13. Front End • Use Visual Studio IDE Objects • MultiView tab system • Each View represents a tab. • HTML for structuring.

  14. Front End – Search Tab

  15. Front End – Profile Tab

  16. Middle Processing • Database Class • Connects to Database • Currently using MySQL • End product connects to MS Access. • Sends Queries • Receives output • Query Class • Takes care of parsing user information. • Construct queries based on this information.

  17. Middle Processing • Example: Search Class • Query parser generates query from search tab. • Database sends query and receives search result. • The search class stores information so user can browse through results. • Tabs • Have predefined queries. • Each tab loads information from these queries using the current search result selected.

  18. Middle Processing • Secure Socket Layer • Currently using SelfSSL certificate for testing. • Upgrading upon delivery. • Socket Testing • For connection to database.

  19. Back End • Database is provided by our partner. • Currently working on a similar database. • Relations in database match tab information precisely.

  20. Back End – Querying Profile Tab

  21. Time Line December 4, 2009 December 11, 2009 October 31, 2009 November 16, 2009 Current Jan 2010 April 2010 Case Notes Tab Complete Profile Tab Complete Legal Tab Complete ALPHA RELEASE

  22. Current Obstacles • Loading Pictures Protocol • Exact GUI Replication

  23. Conclusion • Summary • Questions?

More Related