-
Notifications
You must be signed in to change notification settings - Fork 0
Research and Background
Very little research had to be done to determine what the general structure of a MySQL database is because of previous experience with this database implementation. However, there was a lot of research that went into actually making the SQL statements that are used to get the information about each of the table and view structures. This took some time to get to its current version. There was also a lot of research into how to best batch the SQL commands. For example, would it be better to run all SQL statements for a specific table all at once or in several smaller statements?
There was a lot of research that went into understanding what commands were common between MySQL and SQLite which helped when determining how to implement getting information about the tables as well as indexes and views. One of the harder parts of the research was determining in what order SQL statements had to be run since the structure changed for several common operations (deleting a column from a table).
Having previous experience with this database implementation reduced the amount of research needed to determine the structure of where data is stored. For example, Buckets are akin to tables from an SQL based database implementation. It also took a lot of research into how the JAR libraries that connected to Couchbase could be used to get the information needed. This step took the most amount of time.
Having previous experience with this database implementation reduced the amount of research needed to determine the structure of where data is stored in MongoDB, but a decent bit of research still needed to go into what the properties of a Collection and Document are. After completing that, it took a while to actually determine how to use the appropriate JAR libraries to connect to and retrieve the desired information from the database itself. This step took the most amount of time due to having to read through the JavaDocs and determine what functions and objects were needed.
The GUI probably took the most amount of time overall to get working. The application started out as just a command-line tool, but later became a GUI. As such, it took some time to actually integrate the core application into a GUI. The creation of the GUI took time as well since learning how to create a GUI and actually integrating the application into the GUI went hand-in-hand.