Main Menu
Lecture 1
Lecture 2
Lecture 3
Lecture 5
Lecture 6
Lecture 7
 

 

 

Enterprise Object

Java class that interacts with your database to read and update information via a Java to Dababase Adaptor

Database Models

A database management system (DBMS) is a software system able to efficiently manage collections of data that are large, shared and persistent, and to ensure their reliability and privacy.

A database is a collection of data managed by a DBMS.

Enterprise systems are business databases that are shared by the web.

Many older databases were not designed for multiple users accessing them via the web.

Example: Originally Microsoft Access was designed to be used as:

  1. an independent DBMS on a personal computer

    • offers limited support for transactions

    • simple and incomplete mechanisms for security, data protection and concurency control

    • low cost

    • offers a user friendly interface

  2. an interface to work on data residing on other DBMS systems using the ODBC protocol

    • a tool for avoiding writing SQL

    • acquires schemas and simple queries using a graphical representation

NOTE: management of large and persistent collections of data can also be done with files

Java Database Connectivity - JDBC

A protocol allowing a Java application to communicate with a database

Supported by most databases designed for web access