.db, .dat, .dsr, and .ddt File Extensions
Each Sesame application consists of a pair of files - application.db and application.dat. The working application that you use to enter and update records, run reports, and otherwise work with your data is made up of a .db file and .dat file pair. When you open an existing application, Sesame shows only files with the .db extension.
The copy of the application that you use in Sesame Designer to make design changes is made up of a .dsr file and .ddt file pair. When you open an existing Designer file, Sesame shows only files with the .dsr extension. The DSR file is a copy of your application. It contains all the "objects" that a Sesame application contains, including the data. While working in a DSR file, others can continue working in the original application. When the DSR and the application are reconciled, the data in the DSR file is ignored. (For more information on the Reconciling process, see the Knowledgebase articles: Reconcile Application Options and Converting your application design (DSR) into a run-able Sesame application (DB).) Only design changes are applied to the original in-use Sesame application. The current data from the application remains unaffected.
You do not directly work with .dat or .ddt files, but you do work with .dsr and .db files.