BAS Blog

MyEnroll.com Single Database Structure

Written by BAS | Sep 18, 2014 1:02:11 PM

MyEnroll.com is built on a single database infrastructure customized for MyEnroll.com needs and capabilities. While there is one production database, there are several backup and clones of the database for failover purposes. All MyEnroll.com applications are designed to access the single database. 

The MyEnroll database is designed in accordance with Normalization standards. Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships. 

Some of the advantages of normalization include: 

  • Minimize redesign when extending the database structure
  • Make the data model more informative to users
  • Avoid bias towards any particular pattern of querying

The single database infrastructure positions BAS and MyEnroll.com as an industry leader.