Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource.

Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management-including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining-are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.

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. 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 ul timate 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 dat a modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application. It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and generate reports that can be deployed over the web and gain better insight into your business. This how-to guide provides step by step instruct ions including screen captures to make it easier to design, build and optimize performance of the data warehouse or data mart. It is a must have reference for database developers, administrators and IT professionals who want to get to work now with all of the newest features of Oracle Database 10g.

A soup-to-nuts guide to building and managing high-performance Oracle8i data warehouses In an effort to help companies manage what Information Week has referred to as the "Web Data Deluge," Oracle has released Oracle8i (the "i" stands for "Internet"), a major upgrade to their flagship database product that provides powerful new data warehousing capabilities. In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman provide database dev elopers and administrators with complete, detailed coverage of all they need to know to build and manage a fast, high-performance data warehouse using the Oracle8i technology. Step-by-step, they cover all the bases, including designing a data warehouse for optimum performance, building a data warehouse, loading data into the data warehouse, improving warehouse performance with aggregate data, and administering data warehouse performance.

In this groundbreaking work, authors and data warehousing visionaries Ralph Kimball and Richard Merz explore a next-generation Web site architecture that exploits the unique nature of the Web's interactivity to dramatically improve an organization's understanding of its relationship with users. The Data Webhouse Toolkit isn't a how-to manual; it is a high-level look at an ambitious new approach to system design. The foundation of the concept of Webhouses is the "clickstream"--the plethora of inf ormation that can be gleaned if only a system could capture and accurately analyze all of the interaction (or lack thereof) that occurs between Web users and the sites they access. The authors take a careful look at all of the valuable information in the clickstream and point out the complications of compiling this precious information from various gathering sources such as the user's machine, ISP, and Web site. The book argues strongly for the application of data warehousing and dimensional ana lysis to the clickstream to radically improve the strategic knowledge of customer motives and actions. While there are no real-life case studies yet to illustrate the concept, this book is bound to whet the appetites of creative entrepreneurs and system architects.

Two members of the Oracle8i summary management development team explain how to design, implement, and administer data warehouses and data marts using the new Oracle8i database program. Dimension and fact tables, indexes, partitions, materialized views, and the Oracle discoverer, express, time series and enterprise manager are all discussed.

Data warehouses store millions of records, allowing managers to ask the big-picture questions about their businesses. The authors of Data Warehouse Design Solutions share their expertise in designing successful data warehouses and concentrate on understanding business processes within a variety of industries. First, the authors outline the promise--and potential hurdles--of data warehousing. They thoroughly explain the idea of dimensional data, which is used to represent the quantities or attrib utes that can be queried in a data warehouse. The authors argue that data warehouses need to adapt to changing business conditions and often must be more flexible than planned. They advise building the Enterprise Data Warehouse (EDW) as a series of interlocking data marts (which contain different dimensions). Developers can build part of a solution and add new data marts later. The result is a more adaptable approach to warehousing data. The heart of Data Warehouse Design Solutions is the descri ptions of data warehouses tailored to specific industries--sales, marketing, fulfillment, production, inventory, and capacity--using real-world businesses. The authors offer business models, sample dimensions, database schema, and sample reports for each business area. Later chapters discuss more advanced areas for data warehousing, including budget tracking, financial reporting (and managerial accounting), and even how to look at profitability and intellectual capital. The authors round out the ir nuts-and-bolts tour of today's businesses with a summary of the various measures that fit each type of organization. Finally, the authors come back to theory, with some ideas on building effective systems that are fast and that generate easy-to-read reports. The last chapter argues convincingly that their incremental approach to building data warehousing has some distinct advantages.

The first book available on Oracle8 Data Warehousing. Authored by the Oracle industry respected, best-selling author team of Abbey, Corey, Abramson, and Taub. Provides readers with a fundamental understanding of Data Warehousing and shows them how to implement the concept to their database environment. Includes coverage of Oracle's Express (analyzer) tool and other third-party tools. New chapters have been added to cover Oracle8's new and improved Data Warehousing features-new coverage includes: Data Warehouse design, data transformation techniques, partitioning, ROLAP and Aggregate Navigators, and OLAP tools.

High Performance Oracle Data Warehousing takes readers beyond the basics, showing them how to create compact, efficient, lightning-fast data warehouse systems with Oracle. The CD-ROM contains all examples and source code used in the book, including SQL scripts, optimized database tables, templates, and more. High Performance Oracle Data Warehousing provides everything that the Oracle developer and DBA need to know to design and implement fast and functional Oracle data warehouses. Using proven t echniques from actual systems, this book is full of practical tips and tricks for getting the most out of the Oracle architecture and ensuring maximum performance from the data warehouse. You'll also find advance information on the eagerly awaited Oracle8. And unlike other books on data warehousing, High Performance Oracle Data Warehousing contains invaluable information and actual code examples that demonstrate the use of Oracle data warehouse features.

2001-2011 Oracle-Books.com