A comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Also offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

Oracle 10G Programming is a concise, streamlined guide to Oracle programming. It is ideal for students studying databases, and introduces the Oracle technology students need to know for a first database course. The Relational Data Model, Oracle SQL, PL/SQL, Web Programming with PL/SQL, Oracle JDBC, SQLJ: Embedded SQL in Java, Oracle Web Programming with Java Servlets, Oracle XML, Projects.

CD-ROM contains the actual models that are described in the book, providing examples of the most commonly asked data mining questions regarding marketing, sales, and customer support applications. Complete working code written in SAS, the most popular mining modeling language, is also provided. Readers can use the CD-ROM to directly implement the models for business use--resulting in better campaigns, improved customer service, and increased profits. A step-by-step guide showing how to create an d implement models of the most commonly asked mining questions from a variety of disciplines. Provides proven techniques and numerous case studies that detail available data sources for developing target models. A walk through entire process of a data mining project.

A guide to the use of ERwin--a visual data modeling tool that supports logical and physical data modeling. The program supports the design of large, complex enterprise models by dividing them into smaller more manageable subject areas which allows multiple views of the same subject area. After describing the basics of modeling concepts and the program, the author explains how to use ERwin to create a logical model that represents necessary information requirements and business rules. Finally the use of database administration for developing physical models is explained. From the first chapter, author Carla DeAngelis skillfully explains the normally complex concepts of Data Modeling-a critical success factor in the information-based enterprises of today. Carla tackles complex topics such as Logical Data Models, Modeling Methodologies, Relationships, and Attributes in a clear style that makes it simple for anyone to begin applying them immediately. Once the foundation has been laid, Carl a teaches you to develop your own databases with ERwin.

If you want to see how your next database project can profit from object-oriented design, check out Database Design for Smarties, a lively and intelligent guide to using objects in databases. The book begins with a tour of some underlying factors in modeling databases. Here, the author distinguishes between the external, conceptual, and internal models of database design.) Then it's on to data architectures, be they the traditional relational or the newer object-relational and object-oriented (O O) database types. After discussing some of the pitfalls of gathering and implementing user requirements, the author looks at UML notation for use case diagrams. (His example here, a crime database for tracking Sherlock Holmes's stories, along with criminals and clues, is both intelligent and entertaining.) The author's guide to UML class design is topnotch. He covers basic and advanced OO concepts such as inheritance, aggregation, composition, and polymorphism with clear and concise explanation s. He also shows you how to model business rules using objects and UML class diagrams. The most valuable part of this book comes with the mapping of UML class diagrams onto three different kinds of databases: relational (on Oracle7), object-relational (on Oracle8), and object-oriented (on the POET platform). The author shows how to emulate object-oriented ideas successfully using stored procedures and triggers, even if you are not running on a "true" object-oriented platform.

Offers a set of proven data models and data warehouse designs for the core functions shared by most businesses, with detailed models for marketing and sales, human resources, inventory, professional services, billing, accounting, and other organization functions. A CD-ROM is available by mail. Of interest to systems development professionals including data administrators, data modelers, database designers, and data analysts. Proven data models that save companies' time and money developing data architectures, databases and data warehouses. The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, contracts, shipments, invoicing, work efforts, budgeting, and accounting. Readers can apply more than one data model to their own company to meet specific data needs.

This practical, field-tested reference doesn't just explain the characteristics of finished, high-quality data models--it shows readers exactly how to build one. It presents rules and best practices in several notations, including IDEFIX, Martin, Chen, and Finkelstein. The book offers dozens of real-world examples and go beyond basic theory to provide users with practical guidance. Packed with real-world examples, annotated diagrams, and a wealth of rules and best practices. Provides experienced data modelers, architects, and engineers with hands-on guidance. DLC: Database design.

2001-2011 Oracle-Books.com