Baze podataka Projektovanje baza podataka Serverska strana Profesor
Baze podataka Projektovanje baza podataka Serverska strana Profesor: Branko Perišić, red. prof.
My. SQL - SDBP My. SQL Workbench Upravljanje informacijama 2/ 78
My. SQL – Workbench My. SQL Workbench functionality covers five main topics: Ø SQL Development: Enables you to create and manage connections to database servers. Along with enabling you to configure connection parameters, My. SQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. Ø Data Modeling (Design): Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides easy-to-use facilities for editing Tables, 3 / Upravljanje informacijama Columns, Indexes, Triggers, Partitioning, Options, 78
My. SQL – Workbench Ø Server Administration: Enables you to administer My. SQL server instances by administering users, performing backup and recovery, inspecting audit data, viewing database health, and monitoring the My. SQL server performance. Ø Data Migration: Allows you to migrate from Microsoft SQL Server, Microsoft Access, Sybase ASE, SQLite, SQL Anywhere, Postre. SQL, and other RDBMS tables, objects and data to My. SQL. Migration also supports migrating from earlier versions of My. SQL to the latest releases. Ø My. SQL Enterprise Support: Support for Enterprise products such as My. SQL Enterprise Backup, My. SQL Firewall, and My. SQL Audit. Upravljanje informacijama 4/ 78
My. SQL – Workbench Upravljanje informacijama 5/ 78
My. SQL – Kreiranje konekcije Upravljanje informacijama 6/ 78
My. SQL – Kreiranje konekcije Upravljanje informacijama 7/ 78
My. SQL – Kreiranje konekcije Upravljanje informacijama 8/ 78
My. SQL – Kreiranje konekcije Upravljanje informacijama 9/ 78
Manage Server Connections 5. 3. 2 Local Socket/Pipe Connection Method 5. 3. 3 Standard TCP/IP over SSH Connection Method 5. 3. 4 SSL Wizard (Certificates) 5. 3. 5 Remote Management 5. 3. 6 System Profile 5. 3. 7 Configure Server Management Wizard 5. 3. 8 The Password Storage Vault 5. 3. 9 Updating Old Authentication Protocol Passwords Upravljanje informacijama 10 / 78
Manage Server Connections: Connection Tab Upravljanje informacijama 11 / 78
Administrative Tasks Upravljanje informacijama 12 / 78
Administrative Tasks 1. Connection tab. Each connection made to the My. SQL server is represented by a separate connection tab. A server can be active or inactive when the connection tab for it is opened. Upravljanje informacijama 13 / 78
Administrative Tasks 2. Server menu. The Server menu on the main menu bar is one way to open each category of administration secondary tab. The menu includes the same set of items listed in the Administration tab within the Navigator area, plus two additional items: • Management Access Settings and • Reset Saved Passwords for Connection. Upravljanje informacijama 14 / 78
Configuration (Options File) Upravljanje informacijama 15 / 78
Users and Privileges Upravljanje informacijama 16 / 78
Data Export and Import Upravljanje informacijama 17 / 78
Data Export and Import Wizard Upravljanje informacijama 18 / 78
My. SQL Audit Inspector Interface Upravljanje informacijama 19 / 78
My. SQL Enterprise Backup Interface Upravljanje informacijama 20 / 78
Backup Recovery Upravljanje informacijama 21 / 78
My. SQL Enterprise Firewall Interface Upravljanje informacijama 22 / 78
My. SQL Enterprise Firewall Rules Upravljanje informacijama 23 / 78
Performance Dashboard Upravljanje informacijama 24 / 78
Database Development Visual SQL Editor 8. 1. 1 SQL Query Tab 8. 1. 2 SQL Query Toolbar 8. 1. 3 Query and Edit Menus 8. 1. 4 Result Grid 8. 1. 5 SQL Additions - Snippets Tab 8. 1. 6 SQL Additions - Context Help Tab 8. 1. 7 Output Panel 8. 1. 8 Table Data Search Tab 8. 1. 9 Export or Import a Table 8. 1. 10 My. SQL Table Editor 8. 1. 11 Code Generation Overview Upravljanje informacijama 25 / 78
Visual SQL Editor Upravljanje informacijama 26 / 78
SQL Query Tab Upravljanje informacijama 27 / 78
Database Design and Modeling 9. 1 Modeling Interface 9. 2 Additional Modeling Tools 9. 3 Modeling Tutorials 9. 4 Forward and Reverse Engineering 9. 5 Schema Synchronization and Comparison 9. 6 Table Templates 9. 7 Customizing DBDoc Model Reporting Templates Upravljanje informacijama 28 / 78
Modeling Interface Upravljanje informacijama 29 / 78
- Slides: 29