Developing a Three Tier Web Database Application Using

Developing a Three Tier Web Database Application Using ASP. NET and Open Source Object Oriented Database DB 4 Objects Dr. Morris Liaw Venkata Vijay Durbhakula Mahesh Molakalapalli

Why Object Oriented DB? � It supports the classes of objects and inheritance of class properties. � It supports complex data structures including Video, Audio, Graphs and Photos. � There is no need to convert classes of objects into relational database tables. � No normalization is needed in the database design. � No relational operators such as Cartesian product, Join, Selection and Projection are needed.

Object Oriented DBMSs � Object. Store from e. Xcelon Corp. � Gemstone from Gemstone Systems Inc. � Ontos from Ontos Inc. � Versant from Versant Object Technology � LINQ from Microsoft � We use an open source Object Oriented DBMS DB 4 Objects instead

DB 4 O � An open source Object Oriented DBMS � For Java and. NET developers. � Acquired by Versant Corporation in Dec, 2008. � Supports one-line-of-code to store an entire object into database. � Supports other features, such as dynamic scheme evolution and native queries.

Introduction � Three tier web database application can be easily developed using DB 4 O instead of other OODBs or ADO. NET and traditional relational databases. � We use Visual Studio 2008 IDE to run the DB 4 Objects plug-in and DB 4 O objects as the back-end database.

Introduction � Essential tools to develop Web Application: ◦ Integrated Development Environment (IDE) ◦ Application Programming Interface (API). � API tools to abstract the common programming tasks ◦ Database connections. � Our application uses DB 4 O as the back-end database and C#. NET to communicate with it.

Introduction � DB 4 O on the server can be connected to from the client. � DB 4 O objects can be inserted, updated and retrieved from the client browser. � Microsoft Visual Studio can be configured to run a DB 4 O toolkit.

Introduction � Microsoft Visual Studio is used as an integrated development environment (IDE) for. NET � It has the capability of installing different kinds of plug-ins into its environment. � There is a DB 4 O toolkit called Object Manager Enterprise (OME) that can be installed into Visual Studio for browsing back-end database objects.

Fee Management Tool � Designed for institutions and schools to manage funds. � This tool handles ◦ ◦ ◦ Key fee management functions Student information Funds by students Administration Student relational management

Thank you