Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Key Points

  1. MySQL client for admin, dev, modeler
  2. has admin, schema, developer views
  3. round trip modeling - create model > generate sql > build > reverse engineer db > create sql > create model from sql
  4. good performance hot spot analysis tools
  5. can connect multiple databases on different connections concurrently and share data
  6. scales very well
  7. supports all data models-  SQL, NoSQL json, wide column db denormalized, graph databases
  8. event streaming support
  9. very widely used
  10. small change from MySQL to other DBS - Oracle, DB2, Postgres, SQL Server



References

Reference_description_with_linked_URLs_____________________Notes____________________________________________________________


https://dev.mysql.com/doc/
https://dev.mysql.com/downloads for devs
https://dev.mysql.com/downloads/
https://dev.mysql.com/doc/workbench/en/wb-develop-sql
-editor-history.html
Workbench output windows

























Key Concepts



MySQL Local install

...