MySQL Workbench
I've taken a useful detour to install and configure MySQL so that I can model and forward engineer a model to a live DB server. That task is now complete for two data tables and two metadata tables for storing the results of parsing eBay data using the ebaysdk and Finding API for python. In particular, I am mining right now for world region and stamp quality data to understand trends over time in the eBay sales of stamps and to improve the performance of my eBay Stamps store.
This MySQL database is where we'll store the results once per day of the number of stamp Lots offered for sale broken down by regions and also separately in a different table broken down by grades.
The Regions table and the Grades table will be populated with big integers, both Alpha and incremental numeric timestamps and a descriptor that tells you about how all of the columns relate to each other.
I will be looking for chronological trends in each of the columns in both the world regions and grades and this will be compared for databases - yet to be modeled - for statistics on the items and the sellers of the items themselves.
Advantages of model building with MySQL workbench:
1. Extensive comments and notes can be attached to the database, tables ... even to individual columns.
2. Column defaults and keys are readily set.
3. An Enhanced Entity Relationship EER diagram can be created in one click from model tables and it's GUI editable right within the diagram.
4. Only available in Commercial version: schema validation plugins - dozens of them - in one report to check your design.
5. Warnings if you configure columns with invalid or missing parameters.
6. Once a model is complete you can forward engineer to a live connection to create a live database.
7. There is a tool to autogenerate SQL code mapped to your model.
8. Server connections are easy to set up, test and are persistent across Workbench program launches.
Here is my EER Diagram for the World Regions Database:
No comments:
Post a Comment