Relational versus flat file databases
Other approaches
Other approaches
You may hear about xBase, dBase, Btrieve, or other databases as you work with your applications. These databases are prime examples of the older
technologies that traditionally employ flat file approaches. Since the "early days," a whole 17 or so years ago, many of these databases
have employed engines that let you query their database with SQL.
XBase uses an approach of creating a file for the data, a set of header information that describes how the data is formatted in the database, and one or more separate index files, typically updated by the system.
It's not unusual to have an xBase system that has tens or hundreds of database files. With SQL, these files map to tables, which you will learn more about in the coming lessons. With a relational database system, these xBase databases are rolled together inside the overall application database.
XBase uses an approach of creating a file for the data, a set of header information that describes how the data is formatted in the database, and one or more separate index files, typically updated by the system.
It's not unusual to have an xBase system that has tens or hundreds of database files. With SQL, these files map to tables, which you will learn more about in the coming lessons. With a relational database system, these xBase databases are rolled together inside the overall application database.