To provide the required durability, data is stored in physical storage devices. These files are stored in different logical formats depending on the database model selected by every particular database management system. You can find many database models in the database market:
Flat files, hierarchical, and networked models are mainly used in mainframes, whereas the other models have been ported to client/server environments, based on personal computers. Discussing these database models is out of the scope of this book. SQL Server 2000 implements the relational model, and the following section teaches you the basic theory behind this ...