MySQL Relational Database Development
Advanced Database Development Tools
Directional Consulting develops and maintains advanced database tools for MySQL server administration, performance optimization, and automated schema documentation. Shown to the left is an ERD (Entity Relationship Diagram) depicting the foreign keys and indexes of the schema.
Directional Consulting currently maintains and hosts the MySQL Workbench Data Dictionary plugin publicly on GitHub for anyone to quickly generate automatic documentation from the meta information from their MySQL internal tables.
Relational Database Schema Expertise
Relational database designs provide traceability, deep insights, and correlation of data values across vectors and time series. Server-side automated system jobs collate data records frequently into master tables and reports. In addition, foreign and combination column keys significantly optimize performance, storage, and access times.
Advanced MySQL Performance
Directional Consulting has over 15 years of experience tuning, optimizing, configuring, and deploying MySQL servers. Our past projects include deploying multiple MySQL servers globally at various manufacturing facilities and collecting the data centrally at headquarters. In addition, we monitor and continue tuning the server for higher performance for every deployment using benchmark tools and analyzing primary keys, slow queries, and index utilization.
ODBC for MATLAB, Minitab, Power BI, and Tableau
ODBC (Open Database Connectors) are available for Windows, Mac OS, and Linux, enabling a direct connection to the MySQL OLAP (Online Analytical Processing) engine. The ODBC drivers remove the need for CSV files and are significantly faster due to the direct link to the data records. In addition, using BI (Business Intelligence) tools like MATLAB, Minitab, Power BI, and Tableau enable data scientists and research engineers to have deep insights, perform complex analysis, and generate advanced storytelling graphs.
