Exercises Topic3: Database Server

Topic3: Databases Server

Type of Databases

1. Flatefile

· It is just a text file

· suits applications that want the database to function like a rolodex

2. Relational DBMS

· It has advantages of “one to many” between two tables

· Communication data sources uses ODBMS/SQL

3. Object-oriented OODBMS

· Object oriented model has data objects which are encapsulated by classes that have predefined characteristics

· Data are accessible only through messages which they recognize

· ZOPE uses an OODBMS inside its core

Two and Three tier databases

2-tier Databases model: data tightly bound with stand alone application.

3-tire Databases: more popular for business. It mainly used for Database backend is an ERD (Enterprise Relational Database) such as Sybase or Oracle.

Advantages:

1. Load distribution

2. Transparency

3. The ease of building custom application

4. Security controlled at the middleware layer

Disadvantages


1. Increased rolling resistance


2. Less control and traction at higher speeds


3. developing a host application is take long time


Reference

Ince, D. (2004). Developing distributed and e-commerce applications (2nd ed.). Harlow,Essex, UK: Addison-Wesley.