DB Architecture and Monitoring

Database (DB) architecture describes how users are connected to specific database. While architecture the DB developer needs to develop the methodology on how various components are linked up, design and how they should be monitored.

The basic approach will be client server architecture, where multiple PC's are connected through a network for connections.

DB architecture consists of data modeling and this is a very core concept and this is nothing but modeling of data description, data semantics. There are four models listed below.

  • Relational data model
  • ER (Entity Relational) data model
  • Object based data model
  • Semi-structured data model

  • The overall design of the database is called Schema. This defines the entire database and consists of tables, keys, views, columns data types etc.

    While designing any database, the below points should be taken into consideration.

  • Determining the purpose of the database
  • Organizing the informaiton
  • Dividing the information for clarity
  • Setting up relations if necessary
  • Refining the design
  • Explore more services we provide?