Author : Bonnie O'Neil
Publisher : Sams
Page : 0 pages
File Size : 42,68 MB
Release : 1997
Category : Data warehousing
ISBN : 9780672310775
Data warehousing is a collection of corporate information set up so that a business leader can ask questions and manipulate the data to test scenarios. This book provides an overview of the components needed to produce an Oracle data warehouse. The CD-ROM includes many data warehousing utilities created by the author.
Author : Lilian Hobbs
Publisher : Elsevier
Page : 867 pages
File Size : 32,23 MB
Release : 2011-04-18
Category : Computers
ISBN : 008051328X
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 insider’s 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 instructions 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. 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 How to use the Summary Management features, including Materialized Views and query rewrite, to best effect to radically improve query performance How to deploy business intelligence to the Web to satisfy today's changing and demanding business requirements Using Oracle OLAP and Data Mining options How to understand the warehouse hardware environment and how it is used by new features in the database including how to implement a high availability warehouse environment Using the new management infrastructure in Oracle Database 10g and how this helps you to manage your warehouse environment
Author : Robert Stackowiak
Publisher : John Wiley & Sons
Page : 410 pages
File Size : 19,9 MB
Release : 2007-01-06
Category : Computers
ISBN : 047012718X
Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations. Avoid many common pitfalls while learning best practices for: Leveraging Oracle technologies to design, build, and manage data warehouses Integrating specific database and business intelligence solutions from other vendors Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more Handling typical data warehouse performance challenges Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk
Author : Bert Scalzo
Publisher : Sams Publishing
Page : 401 pages
File Size : 11,71 MB
Release : 2015-06-29
Category : Computers
ISBN : 0134131894
Bert Scalzo and Dan Hotka have written the definitive, up-to-date guide to Version 12.x, Dell’s powerful new release of Toad for Oracle. Packed with step-by-step recipes, detailed screen shots, and hands-on exercises, Toad for Oracle Unleashed shows both developers and DBAs how to maximize their productivity. Drawing on their unsurpassed experience running Toad in production Oracle environments, Scalzo and Hotka thoroughly cover every area of Toad’s functionality. You’ll find practical insights into each of Toad’s most useful tools, from App Designer to Doc Generator, ER Diagrammer to Code Road Map. The authors offer proven solutions you can apply immediately to solve a wide variety of problems, from maintaining code integrity to automating performance and scalability testing. Learn how to... Install and launch Toad, connect to a database, and explore Toad’s new features Customize Toad to optimize productivity in your environment Use the Editor Window to execute SQL and PL/SQL, and view, save, or convert data Browse your schema, and create and edit objects Quickly generate useful reports with FastReport and Report Manager Clarify your database’s tables and data with the powerful Entity Relationship Diagrammer (ERD) and HTML documentation generator Work more efficiently with PL/SQL using code templates, snippets, and shortcuts Automate actions and applications with Automation Designer Perform key DBA tasks including database health checks, tablespace management, database and schema comparisons, and object rebuilding Identify and optimize poorlyperforming SQL and applications ON THE WEB: Download all examples and source code presented in this book from informit.com/title/9780134131856 as it becomes available.
Author : Michael J. Corey
Publisher :
Page : 313 pages
File Size : 25,46 MB
Release : 1997
Category :
ISBN : 9788448109981
Author : James Raper
Publisher : Lulu.com
Page : 240 pages
File Size : 12,13 MB
Release : 2008-11-21
Category : Business & Economics
ISBN : 0557024285
The Vault Unleashed leads managers and those new to the Business Intelligence field on a journey through the landscape. Successful Business Intelligence, or BI, is more than just technology. BI is the melding of people of multiple skills, using a variety of methods and empowering technology to solve business needs. This is best illustrated thru examples.This BI novel uses a fictitious island nation in the South Atlantic faced with threats to its very existence. The story takes the reader thru a connection of the dots from perception of a potential problem thru management execution of solutions. Augmenters must be brought on board. The core team must transfer knowledge to the new augmenters in the background and methodologies necessary to develop insights and make decisions. Most enterprises today are faced with similar challenges in our global economy. Your competition may not be state supported or as aggressive as in this tale. But for today's managers their counterparts are just as real.
Author : Michael J. Corey
Publisher : Osborne Publishing
Page : 0 pages
File Size : 46,8 MB
Release : 1998
Category : Data warehousing
ISBN : 9780078825118
When the first edition was published, Data Warehousing was a new concept--now it is an extremely valued skill set within the database industry. New chapters have been added to cover Oracle8's new and improved Data Warehousing features--design, data transformation techniques, partitioning, ROLAP and Aggregate Navigators, and OLAP tools.
Author : Bert Scalzo
Publisher : Prentice Hall Professional
Page : 236 pages
File Size : 24,43 MB
Release : 2003
Category : Computers
ISBN : 9780130325846
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.
Author : Rick Greenwald
Publisher : "O'Reilly Media, Inc."
Page : 928 pages
File Size : 29,84 MB
Release : 2002-12-18
Category : Computers
ISBN : 1491942959
Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes: Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options. Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database. Oracle Tools--Commands provided with SQLPlus, SQLLoader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack). Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.
Author : Donald K. Burleson
Publisher :
Page : 572 pages
File Size : 28,94 MB
Release : 1997
Category : Computers
ISBN :
"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.
