Transition to a Hybrid SQLite database and hashmap table data structure design for unit storage and processing.

[isaaclafrance]

• The sql database will allow for efficient and fast retrieval of unit names based on various search criteria. Then once the unit name is obtained it will subsequently be used with a hash map to get the corresponding unit object.

[isaaclafrance]

Decided against using sql all together. The application infrastructure is too heavily dependent on the hash map data structure and so a change to sql would require a major alteration in how things operate. Moreover, the existing data structure already sufficiently satisfies the need of the application.

[isaaclafrance]

After refactoring, reconsidered using sql on a more limited scale to store and retrieve only dynamic units and prefixes.