Oracle SQL Developer Data Modeler for Data...

Dekorationsartikel gehören nicht zum Leistungsumfang.

Sprache: Englisch

66,70 €

inkl. MwSt.

Versandkostenfrei per Post / DHL

Aktuell nicht verfügbar

Kategorien:

Beschreibung

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

Über den Autor

Heli Helskyaho has a master's degree in computer science from Helsinki University and specializes in databases. Heli is also an Oracle ACE director and has been a frequent speaker at many conferences. She has worked in IT since 1990 and with Oracle products since 1993. She has been in several positions, but each role has always included database design. Heli has been an Oracle Designer user since 1996 and a Oracle SQL Developer Data Modeler user since 2010. Heli is an active member in Oracle user groups community, including Oracle User Group Finland as well as EMEA Oracle user groups community (EOUC) where she has served as their spokesperson/ambassador since 2007. Heli is also the CEO for Miracle Finland Oy. Heli believes that creating good database design and documentation reduces performance problems and makes solving them easier. You can follow her on Twitter [...] or read her blog on helifromfinland.[...].

Inhaltsverzeichnis

1. Introduction to Database Design
2. What is Oracle SQL Developer Data Modeler
3. Getting started with Data Modeler
4. Requirement analysis (Logical Model)
5. Conceptual design (Logical Model)
6. Logical design (Relational Model)
7. Physical design (Physical Model)
8. Multidimensional
9. Version control
10. Export/import/reverse engineering
11. Reporting
12. Compare/Merge/ Syncronize
13. Tips and Tricks and Techniques

Details

Erscheinungsjahr:	2015
Genre:	Importe , Informatik
Rubrik:	Naturwissenschaften & Technik
Medium:	Taschenbuch
Inhalt:	Kartoniert / Broschiert
ISBN-13:	9780071850094
ISBN-10:	0071850090
Sprache:	Englisch
Einband:	Kartoniert / Broschiert
Autor:	Helskyaho, Heli
Hersteller:	McGraw-Hill Education
Verantwortliche Person für die EU:	Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de
Maße:	235 x 191 x 18 mm
Von/Mit:	Heli Helskyaho
Erscheinungsdatum:	16.06.2015
Gewicht:	0,636 kg