Oracle SQL Developer Data Modeler for Database Design Mastery (Paperback)

Design Databases with Oracle SQL Developer Data Modeler

In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler―the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.

• Configure Oracle SQL Developer Data Modeler
• Perform requirement analysis
• Translate requirements into a formal conceptual data model and process models
• Transform the conceptual (logical) model into a relational model
• Manage physical database design
• Generate data definition language (DDL) scripts to create database objects
• Design a data warehouse database
• Use subversion for version control and to enable a multiuser environment
• Document an existing database
• Use the reporting tools in Oracle SQL Developer Data Modeler
• Compare designs and the database

使用Oracle SQL Developer Data Modeler設計資料庫

在這本實用指南中，Oracle ACE Director Heli Helskyaho解釋了使用Oracle SQL Developer Data Modeler進行資料庫設計的過程。這是一個功能強大且免費的工具，完美支援Oracle和其他資料庫環境，包括Microsoft SQL Server和IBM DB2。《Oracle SQL Developer Data Modeler for Database Design Mastery》涵蓋了需求分析、概念、邏輯和物理設計、資料倉儲、報表等內容。使用這本Oracle Press書中的專家建議和最佳實踐，在任何平台上創建和部署高性能企業資料庫。

本書內容包括：
- 配置Oracle SQL Developer Data Modeler
- 執行需求分析
- 將需求轉化為正式的概念資料模型和流程模型
- 將概念（邏輯）模型轉化為關聯模型
- 管理物理資料庫設計
- 生成資料定義語言（DDL）腳本以創建資料庫物件
- 設計資料倉儲資料庫
- 使用版本控制和多用戶環境的Subversion
- 文件化現有資料庫
- 使用Oracle SQL Developer Data Modeler的報表工具
- 比較設計和資料庫