Oracle Data Warehouse Tuning for 10g
5/5
()
About this ebook
- 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
Gavin JT Powell
Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL
Read more from Gavin Jt Powell
Oracle SQL: Jumpstart with Examples Rating: 5 out of 5 stars5/5Oracle High Performance Tuning for 9i and 10g Rating: 3 out of 5 stars3/5Oracle Performance Tuning for 10gR2 Rating: 3 out of 5 stars3/5Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook Rating: 0 out of 5 stars0 ratings
Related to Oracle Data Warehouse Tuning for 10g
Related ebooks
Data Warehousing For Dummies Rating: 4 out of 5 stars4/5Building the Data Warehouse Rating: 5 out of 5 stars5/5Mastering Data Warehouse Design: Relational and Dimensional Techniques Rating: 4 out of 5 stars4/5Business Metadata: Capturing Enterprise Knowledge Rating: 4 out of 5 stars4/5Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses Rating: 4 out of 5 stars4/5Relational Databases: State of the Art Report 14:5 Rating: 0 out of 5 stars0 ratingsOracle Database Programming using Java and Web Services Rating: 0 out of 5 stars0 ratingsMicrosoft Data Mining: Integrated Business Intelligence for e-Commerce and Knowledge Management Rating: 0 out of 5 stars0 ratingsInformation Structure Design for Databases: A Practical Guide to Data Modelling Rating: 5 out of 5 stars5/5Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Rating: 5 out of 5 stars5/5Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide Rating: 0 out of 5 stars0 ratingsData warehouse Complete Self-Assessment Guide Rating: 4 out of 5 stars4/5Instant MapReduce Patterns – Hadoop Essentials How-to Rating: 0 out of 5 stars0 ratingsHDInsight Essentials - Second Edition Rating: 0 out of 5 stars0 ratingsSQL Server Reporting Services Complete Self-Assessment Guide Rating: 0 out of 5 stars0 ratingsInstant SQL Server Analysis Services 2012 Cube Security Rating: 0 out of 5 stars0 ratingsInformation Modeling and Relational Databases Rating: 0 out of 5 stars0 ratingsQlikView for Developers Rating: 0 out of 5 stars0 ratingsEnterprise Data Warehouse Third Edition Rating: 0 out of 5 stars0 ratingsPentaho 3.2 Data Integration Beginner's Guide Rating: 0 out of 5 stars0 ratingsNoSQL For Dummies Rating: 0 out of 5 stars0 ratingsAn Introduction to Data Base Design Rating: 0 out of 5 stars0 ratingsThe Data Model Resource Book: Volume 3: Universal Patterns for Data Modeling Rating: 0 out of 5 stars0 ratingsApache Hive Cookbook Rating: 0 out of 5 stars0 ratingsThe Data Model Resource Book, Volume 1: A Library of Universal Data Models for All Enterprises Rating: 0 out of 5 stars0 ratingsTesting the Data Warehouse Practicum: Assuring Data Content, Data Structures and Quality Rating: 0 out of 5 stars0 ratingsLogical Data Warehouse A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsOracle 10g Data Warehousing Rating: 5 out of 5 stars5/5
Databases For You
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5COBOL Basic Training Using VSAM, IMS and DB2 Rating: 5 out of 5 stars5/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Practical Data Analysis Rating: 4 out of 5 stars4/5Spring in Action, Sixth Edition Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsData Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Learn SQL Server Administration in a Month of Lunches Rating: 0 out of 5 stars0 ratingsServerless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Business Intelligence Strategy and Big Data Analytics: A General Management Perspective Rating: 5 out of 5 stars5/5CompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratingsHTML, CSS, Bootstrap, Php, Javascript and MySql: All you need to know to create a dynamic site Rating: 4 out of 5 stars4/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsOracle DBA Mentor: Succeeding as an Oracle Database Administrator Rating: 0 out of 5 stars0 ratingsCOMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsGo in Action Rating: 5 out of 5 stars5/5Blockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5Access 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5Relational Database Design and Implementation Rating: 5 out of 5 stars5/5A Concise Guide to Object Orientated Programming Rating: 0 out of 5 stars0 ratingsThe SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL Rating: 0 out of 5 stars0 ratingsGetting Started with SQL Server 2014 Administration Rating: 0 out of 5 stars0 ratingsBehind Every Good Decision: How Anyone Can Use Business Analytics to Turn Data into Profitable Insight Rating: 5 out of 5 stars5/5The Visual Imperative: Creating a Visual Culture of Data Discovery Rating: 4 out of 5 stars4/5
Reviews for Oracle Data Warehouse Tuning for 10g
1 rating0 reviews