Hello. See detailed specs in the attached file. The goal of this project is to find an experienced database administrator with MySQL and Microsoft Access experience that can help me add my first two (relatively large) tables to MYSQL, preferably using MySQL Workbench. Additionally, I am hoping to set up an ODBC connection with Microsoft Access so that I can easily query (and join to) the data using Microsoft Access.
This is the initial project, which will hopefully lead to a long term working relationship in which I can incrementally expand the capabilities of the MySQL database.
Overview is shown below, but the attached file has more detail as to the contents of the tables.
1 Design simple MySQL DB for storage of Product Data (on my desktop)
2 The initial tables are currently available in either MDB files or in Txt files, whichever is easiest for you to use to import them into the MySQL DB
3 Msft Access ODBC Connection will be established so that Msft Access Queries can be performed on the MySQL Tables
4 Strive for the simplest possible setup, to ensure that queries and maintenance of the Database is as simple as possible for the Analyst using the data.
5 Note: I believe the MySQL and MySQL Workbench is already properly installed on my (desktop) computer, though we may need to ensure it is installed properly.
6 The initial two tables have around 2 Million records, but I will soon be growing them to 5 or 6 million records.
7 The reason for this project is because the size of the files in Msft Access have a 2 GB limit, so I am required to use a larger Database to house the data.
8 I will need to also have the ability to easily update/append/delete records in the below two tables, often times using lists of ASINs that exist in txt files or in Microsoft Access Tables. Using MySQL workbench is probably the best option, though I am open to other simple solutions.
9 Would like to eventually transition this to a Big Data Database setup using clusters through Hadoop and MapReduce or MySQL clusters for more advanced storage and analytics.