2.8 Details of File, Edit and Data Storage
The typical program has a FILE bar button. The UI provided does not follow the typical UI with a FILE button, but rather
the FILE button is replaced with a wizard that is built into the interface. Functions such as EDIT
are accessible by clicking on the provided tables which will allow editing of cells within the table. The Undo and Redo
functions have not yet been decided on.
The back end of the UI will be run by a database(oracle). This data base will allow faster access to the data
because it will allow the the streamlined execution of queries that will optimize the retrevial
of requested data or aggregate operations for statistics. The database does not need to "save" per say because
all the information is already stored in the database and when the users requests information
the data base will just query for it and fill in the tables accordingly. When the user wants to add data, the
appropriate query will be formed and submitted to the database. The save functionality is "automatic" essentially when the user finishes
input(and the input is valid), a query will be sent accordingly to the database.