Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill Education,
[2015]
|
| Colección: | Online access with DDA: Askews (Maths)
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_ocn914166457 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150720s2015 nyua o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCF |d TEFOD |d TEF |d LVT |d TOH |d EBLCP |d YDX |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 1076641304 |a 1165388132 | ||
| 020 | |a 9780071850100 |q (electronic bk.) | ||
| 020 | |a 0071850104 |q (electronic bk.) | ||
| 020 | |a 0071850090 | ||
| 020 | |a 9780071850094 | ||
| 020 | |z 9780071850094 | ||
| 035 | |a (OCoLC)914166457 |z (OCoLC)1076641304 |z (OCoLC)1165388132 | ||
| 037 | |a CL0500000618 |b Safari Books Online | ||
| 037 | |a 311B8866-29B4-4622-A6F2-F87AA4D6C3E2 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.75/85 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Helskyaho, Heli, |e author. | |
| 245 | 1 | 0 | |a Oracle SQL developer data modeler for database design mastery / |c Heli Helskyaho. |
| 264 | 1 | |a New York : |b McGraw-Hill Education, |c [2015] | |
| 264 | 4 | |c ©2015 | |
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Online resource; title from title page (Safari, viewed July 14, 2015). | |
| 500 | |a "Design, deploy, and maintain world-class databases on any platform"--Cover page | ||
| 500 | |a Includes index. | ||
| 520 | 8 | |a 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 expensive third-party solutions. |b Design Databases with Oracle SQL Developer Data ModelerIn 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 ModelerPerform requirement analysisTranslate requirements into a formal conceptual data model and process modelsTransform the conceptual (logical) model into a relational modelManage physical database designGenerate data definition language (DDL) scripts to create database objectsDesign a data warehouse databaseUse subversion for version control and to enable a multiuser environmentDocument an existing database Use the reporting tools in Oracle SQL Developer Data ModelerCompare designs and the database. | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Database design. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Helskyaho, Heli. |t Oracle SQL developer data modeler for database design mastery. |d New York : McGraw-Hill Education, [2015] |w (DLC) 2015009597 |
| 830 | 0 | |a Online access with DDA: Askews (Maths) | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780071850100/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6257571 | ||
| 938 | |a YBP Library Services |b YANK |n 16841279 | ||
| 994 | |a 92 |b IZTAP | ||