Ayac
Páginas: 19 (4603 palabras)
Publicado: 11 de julio de 2010
MySQL Workbench: A Data Modeling Guide for Developers and DBAs
Copyright © 2007, MySQL AB
A MySQL® Business White Paper
Table of Contents 1 2 3 4
4.1 4.2 4.3 4.4 4.5 4.6
INTRODUCTION ....................................................................................................................3 TYPES OF DATA TO MANAGE............................................................................................3 MODEL-DRIVEN DATA MANAGEMENT ..............................................................................4 MODEL-DRIVEN DATA MANAGEMENT BENEFITS ...........................................................5
Metadata Management.................................................................................................................................................... 5 Rapid Application Delivery ............................................................................................................................................. 5 Change Management ....................................................................................................................................................... 6 Package Application Management................................................................................................................................. 6 Reporting and Communication....................................................................................................................................... 7 Performance Management.............................................................................................................................................. 7
5
5.1 5.2 5.3 5.4 5.5
MYSQL WORKBENCH – DATA MODELING/DESIGN FOR MYSQL...................................8
Database Design ............................................................................................................................................................... 8 Forward and Reverse Engineering................................................................................................................................. 9 Change Management ..................................................................................................................................................... 10 Reporting and Documentation...................................................................................................................................... 11 At-a-Glance View of MySQL Workbench Features.................................................................................................... 13
6
CONCLUSION......................................................................................................................14
Copyright © 2008, Sun Microsystems, Inc.
Page 2 of 14
1Introduction
Data is the lifeblood of all successful businesses, no matter the size of the company or the industry they serve. A company’s data takes many forms: it can be new transactional data in the form of incoming orders from a Web site, business intelligence data that’s gleaned from customer data, which helps a company’s management staff make smart strategic decisions, historical informationthat’s needed for compliance officers, or metadata that describes the various data elements that make up data-driven systems and how each one of those elements is used. Should a company mishandle or lose key data, it is oftentimes a devastating experience and one that can end in great financial costs as well as loss of reputation. This being the case, modern and successful companies are leavingnothing to chance when it comes to the definition, design, and implementation of their data. This equates to a professional and process-driven approach to the creation and management of data that will flow through its business systems – a process that is led by data management professionals who utilize a model-driven approach to data and employ the right tools in the process to ensure that the...
Copyright © 2007, MySQL AB
A MySQL® Business White Paper
Table of Contents 1 2 3 4
4.1 4.2 4.3 4.4 4.5 4.6
INTRODUCTION ....................................................................................................................3 TYPES OF DATA TO MANAGE............................................................................................3 MODEL-DRIVEN DATA MANAGEMENT ..............................................................................4 MODEL-DRIVEN DATA MANAGEMENT BENEFITS ...........................................................5
Metadata Management.................................................................................................................................................... 5 Rapid Application Delivery ............................................................................................................................................. 5 Change Management ....................................................................................................................................................... 6 Package Application Management................................................................................................................................. 6 Reporting and Communication....................................................................................................................................... 7 Performance Management.............................................................................................................................................. 7
5
5.1 5.2 5.3 5.4 5.5
MYSQL WORKBENCH – DATA MODELING/DESIGN FOR MYSQL...................................8
Database Design ............................................................................................................................................................... 8 Forward and Reverse Engineering................................................................................................................................. 9 Change Management ..................................................................................................................................................... 10 Reporting and Documentation...................................................................................................................................... 11 At-a-Glance View of MySQL Workbench Features.................................................................................................... 13
6
CONCLUSION......................................................................................................................14
Copyright © 2008, Sun Microsystems, Inc.
Page 2 of 14
1Introduction
Data is the lifeblood of all successful businesses, no matter the size of the company or the industry they serve. A company’s data takes many forms: it can be new transactional data in the form of incoming orders from a Web site, business intelligence data that’s gleaned from customer data, which helps a company’s management staff make smart strategic decisions, historical informationthat’s needed for compliance officers, or metadata that describes the various data elements that make up data-driven systems and how each one of those elements is used. Should a company mishandle or lose key data, it is oftentimes a devastating experience and one that can end in great financial costs as well as loss of reputation. This being the case, modern and successful companies are leavingnothing to chance when it comes to the definition, design, and implementation of their data. This equates to a professional and process-driven approach to the creation and management of data that will flow through its business systems – a process that is led by data management professionals who utilize a model-driven approach to data and employ the right tools in the process to ensure that the...
Leer documento completo
Regístrate para leer el documento completo.