Essential Oracle8i Data Warehousing
Essential Oracle8i Data Warehousing

Author: Gary Dodge

Publisher: John Wiley & Sons

Published: 2000-09-20

Total Pages: 940

ISBN-13:

DOWNLOAD EBOOK

"This book is the definitive guide for serious Oracle8i professionals and is required reading for all Oracle data warehousing practitioners."-Shannon Platz, Senior Director, Business Intelligence & Warehouse Global Service Line, Oracle Corporation A complete hands-on guide to Oracle8i and earlier versions In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman clearly explain everything you'll need to know to build and manage a large, high-performance data warehouse using Oracle8i. They provide a technical roadmap to the specific Oracle8 or Oracle8i features that are relevant to designing, building, tuning, and administering an Oracle data warehouse. After a brief review of the basic concepts, you'll find descriptions of the various hardware platforms to support the Oracle data warehouse. The authors then cover the Oracle features that can enhance a large data warehouse, the design considerations for a warehouse, and the steps necessary to load data into the warehouse. You'll also find out how to perform parallel operations using Oracle8 and Oracle8i to accomplish massive tasks more quickly. And you'll discover the specific features and techniques for implementing a distributed architecture. With this book, you'll learn how to: - Design a data warehouse for optimum performance - Construct the data warehouse using Oracle8 and Oracle8i database technology - Load data into the data warehouse - Summarize and aggregate data within a warehouse - Administer and monitor a data warehouse for optimum performance - Build and manage very large (multiterabyte) data warehouses Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/dodge for scripts, extensions, and additional material.

Oracle8i Data Warehousing
Oracle8i Data Warehousing

Author: Michael J. Corey

Publisher: McGraw-Hill Companies

Published: 2001

Total Pages: 878

ISBN-13:

DOWNLOAD EBOOK

More than sixty percent of Oracle8i's new features affect data warehousing - how users store, gather and leverage the information contained in their database systems. Oracle's data warehousing is going mainstream spurred by the increasing need to harvest information to provide strategic direction and growth for e-business. Many corporations consider data warehousing essential -from spreadsheet/financial data to high-level strategic data. Oracle8 Data Warehousing provides data warehousers with the means to collect, analyze and act on information contained on their database system.

Oracle8i Data Warehousing
Oracle8i Data Warehousing

Author: Lilian Hobbs

Publisher: Elsevier

Published: 1999-11-17

Total Pages: 402

ISBN-13: 9781555582050

DOWNLOAD EBOOK

Cutting-edge Oracle data warehousing from people creating the software. Oracle8i Data Warehousing explains how to design, develop, and administer powerful data warehouses and data marts on Windows NT using Oracle's major new industry-leading database. This authoritative guide helps database developers, administrators, and designers master the major new data warehousing and Internet capabilities in Oracle8i and specifically plan and implement affordable and successful data warehouses and data marts. In one exciting package, this book brings together three hot computing topics: new Oracle databases, Windows NT, and Internet technologies. Data warehouses and smaller data marts allow companies to pool and analyze large quantities of data, yielding valuable information about customers and business processes. Data warehouses have in the past been expensive and very complex. Oracle8i is an important new version of Oracle Corporation's market-leading database system. Most of the significant new features in Oracle8i are for data warehousing, Internet development, or optimizations for the Windows NT platform. Oracle8i and Windows NT together will make data warehouse projects easier and more affordable. Written by data design and warehousing experts from the Oracle8i development team Explains how to design and build data warehouses and data marts on Windows NT Explains how to establish Web/Intranet access to a data warehouse

Oracle8 Data Warehousing
Oracle8 Data Warehousing

Author: Gary Dodge

Publisher:

Published: 1998-03-30

Total Pages: 680

ISBN-13:

DOWNLOAD EBOOK

"A hands-on guide to designing, building, and manageing Oracle data warehouses".

Oracle Essentials
Oracle Essentials

Author: Rick Greenwald

Publisher: O'Reilly Media

Published: 1999

Total Pages: 382

ISBN-13:

DOWNLOAD EBOOK

This concise guide explains what's important about Oracle8 (the object-relational database) and Oracle8i (the Internet database). The text also covers all system products, architecture and data structures; installation, management, security, backup and recovery, and tuning issues; and specific Oracle technologies such as data warehouses, online transaction processing and the system's interfaces to the Web.

Oracle Data Warehouse Tuning for 10g
Oracle Data Warehouse Tuning for 10g

Author: Gavin JT Powell

Publisher: Elsevier

Published: 2011-04-08

Total Pages: 499

ISBN-13: 008045917X

DOWNLOAD EBOOK

“This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. - Tim Donar, Author and Systems Architect for Enterprise Data Warehouses Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame. A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. * Takes users beyond basics to critical issues in running most efficient data warehouse applications * Illustrates how to keep data going in and out in the most productive way possible * Focus is placed on Data Warehouse performance tuning

Oracle Essentials
Oracle Essentials

Author: Rick Greenwald

Publisher: O'Reilly Media, Incorporated

Published: 2013-05-15

Total Pages: 420

ISBN-13: 9781449343033

DOWNLOAD EBOOK

Written by experienced Oracle insiders, this essential guide distills a vast amount of information into an easy-to-read volume that covers every aspect of the Oracle database. Readers of all technical levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning and much more. Augmented with illustrations and helpful hints, the fifth edition of Oracle Essentials offers a valuable one-stop overview of Oracle Database 12c, Oracle's newest database release. More comprehensible than huge complete references, and more detailed than most primers, this book gives current Oracle users the conceptual background they need to understand how the Oracle database truly works. For those new to Oracle, this all-in-one guide provides an essential introduction that will get them up to speed.

Oracle Essentials
Oracle Essentials

Author: Rick Greenwald

Publisher: "O'Reilly Media, Inc."

Published: 2013-09-06

Total Pages: 243

ISBN-13: 1449343171

DOWNLOAD EBOOK

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions

Oracle DBA Guide to Data Warehousing and Star Schemas
Oracle DBA Guide to Data Warehousing and Star Schemas

Author: Bert Scalzo

Publisher: Prentice Hall Professional

Published: 2003

Total Pages: 236

ISBN-13: 9780130325846

DOWNLOAD EBOOK

The ultimate reference guide to successful implementation of star schemas within Oracle data warehouses, this edition also covers Oracle 8i and Oracle 9i with real-world examples, sample code and benchmarks to illustrate key concepts.