BioGRID Architecture and Data Model
The BioGRID database architecture consists of three distinct components: (i) the Core (ii) the Web (iii) the Interaction Management System (IMS). This BioGRID data model was developed to be both extensible and modular. Each of the three components has a specific role in driving the BioGRID system and can easily be modified to meet rapidly changing needs in data management without entailing major changes to the applications it supports. In large databases, the integrity of the data model is often compromised (for example, by duplicating data within the database to speed up queries) to improve performance. This compromise frequently leads to serious problems with data integrity. Alternatively, a completely normalized database that strictly follows theoretical design principles, while maintaining data integrity, can often suffer greatly in performance, especially in cases where the database grows to a substantial size. The BioGRID data model solves this problem by utilizing a suite of tables specifically engineered to reduce query time while maintaining a structured normalized form that does not compromise fundamental design principles.
All of the BioGRID databases use MySQL 5.1. We chose MySQL as the database because it is freely available, platform independant, and easy to install and maintain without sacrificing performance or features.