Level: Beginner
【Presenter】
Hiroshi Taku, Professor, Kokushikan University
[Announcement summary]
The presenter connects JMP and MYSQL and analyzes tens of millions of data. Last year, we explained how to connect JMP and MYSQL, but this year, when analyzing large amount of data at the individual level, how to create a database on MYSQL based on the large amount of data entered. I will explain an example of how to use it.
Therefore, we will show you how to create a database on MYSQL with Excel or Access, how to do it with JMP, and how to add a large amount of data with an editor and read it with MYSQL. At the same time, I will explain how to use JMP to manage data that is created at multiple facilities and has slightly different variable names and JOIN values, based on actual examples. Also, I will explain the points when searching MYSQL from JMP via ODBC.
In this report, I will explain many operations specific to MYSQL, but I think that it will be a useful basic technology when dealing with big data for JMP users.
