Oracle SQL developer data modeler for database design mastery /

Design world-class databases with this powerful free tool. This book provides best practices for planning, executing, installing, deploying, and maintaining any kind of database of any size. The author contrasts the ease of functionality and compatibility of Oracle SQL Developer Data Modeler against...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Helskyaho, Heli (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2015]
Colección:Online access with DDA: Askews (Maths)
Temas:
Oracle (Computer file)
Database design.
SQL (Computer program language)
Bases de données > Conception.
SQL (Langage de programmation)
Database design
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright Page
  • Dedication Page
  • About the Author
  • Contents at a Glance
  • Contents
  • Forewords
  • Acknowledgments
  • Introduction
  • 1 Introducing Database Design and Oracle SQL Developer Data Modeler
  • What Is Oracle SQL Developer Data Modeler?
  • Designing Databases with Oracle SQL Developer Data Modeler
  • Summary
  • 2 Getting Started with Oracle SQL Developer Data Modeler
  • Downloading and Exploring the Tool
  • What Is a Design?
  • Exploring the Interface
  • Customizing the Interface
  • Tuning Oracle SQL Developer Data Modeler
  • Setting Preferences
  • Introducing Design Properties
  • Introducing Glossaries
  • Introducing Domains
  • Introducing Design Rules
  • Performance Tuning
  • Summary
  • 3 Introducing Requirements Analysis
  • Gathering Requirements for the Logical Model
  • Gathering Requirements for the Process Model
  • Introducing Data Flow Diagrams
  • Introducing Transformation Packages
  • Adding Business Information
  • Summary
  • 4 Introducing Conceptual Database Design (Logical Model)
  • Setting Preferences and Properties
  • Introducing the Logical Model
  • An Entity and Its Attributes
  • A Relationship
  • Constraints
  • Entity Views
  • Inheritance
  • Subviews
  • Displays
  • Summary
  • 5 Introducing Logical Database Design (Relational Model)
  • Setting Preferences and Properties
  • Transforming from a Logical Model to a Relational Model
  • Setting Transformation Rules
  • Engineer to Relational Model
  • Introducing the Relational Model
  • Tables
  • Views
  • Name Abbreviations and Prefix Management
  • Name Abbreviation
  • Prefix Management
  • Tuning and Refactoring Your Model
  • Summary
  • 6 Introducing Physical Database Design
  • Setting Preferences and Properties
  • Creating a Physical Model
  • Administering RDBMS Sites
  • A New Physical Model
  • Defining Physical Model Properties
  • Defining Users and Roles
  • Storage Templates and LOB Storages
  • Tablespaces
  • Synonyms
  • Tables
  • Sequences
  • Views
  • Materialized Views
  • Stored Procedures, Functions, and Packages
  • Triggers
  • User-Defined Data Types
  • Other Elements
  • Propagating Properties
  • Indexing
  • Partitioning
  • Summary
  • 7 Generating DDL Scripts for Creating Database Objects
  • Setting Preferences and Properties
  • Exporting a DDL File
  • Exploring DDL Generation Options
  • Summary
  • 8 Designing a Data Warehouse Database
  • Introducing Dimensional Modeling Techniques
  • Exploring Dimensional Design
  • Star Schema or Snowflake
  • Data Vault
  • Physical Database Design and DDLs
  • Introducing Multidimensional Design
  • Creating a Multidimensional Model
  • Creating the Physical Model and Exports
  • Reporting
  • Using Dynamic Properties and User-Defined Properties
  • Summary
  • 9 Using Version Control and Working in a Multiuser Environment (Subversion)
  • Setting Preferences and Properties
  • Introducing Subversion
  • Connecting to Subversion
  • Using Subversion in Oracle SQL Developer Data Modeler

Ejemplares similares