data warehouse

Solution Search:
Going Real-Time for Data Warehousing and Operational BI by GoldenGate Software, Inc.
This paper will review the trends that are driving the data warehouse towards real-time data requirements, examples of the business value, evaluation of data acquisition technologies, an overview of...
The Great Debate: Buy Versus Build - Oracle's Pre-Built Analytic Applications Versus Building a Custom Warehouse by Oracle Corporation
applications from Oracle versus building a custom data warehouse against Oracle E-Business Suite, PeopleSoft, Siebel or Similar Systems. The question of whether to go with a pre-built data warehouse...
Real-Time Data Warehousing: 3 Case Studies by GoldenGate Software, Inc.
continuous, real-time integration of operational data into data warehouse and BI systems:
  • MGM Mirage
  • Haggen Food & Pharmacy
  • Overstock.com
Also included is GoldenGate's Real-Time Data Warehousing data sheet...
Architecting Cost-effective Scalable Oracle Data Warehouses by Sun Microsystems, Inc.
medium, and large solutions to meet business intelligence/data warehouse needs. Architecting cost-effective, fast, reliable, and scalable data warehouse environments can be a time-consuming task. To stay on...
The Vertica Analytic Database: Rethinking Data Warehouse Architecture by Vertica Systems
conflicting forces are placing enormous stress on current data warehouse paradigms. Vertica believes it has a better idea. Taking a fresh look at the fundamental requirements for analytic data...
Oracle Optimized Warehouse for Sun by Sun Microsystems, Inc.
trade; Operating System (OS) for a fast, reliable, and scalable data warehouse. The Oracle Optimized Warehouse for Sun combines products from two industry leaders to provide a pre-configured, pre-installed...
Oracle Database 11g for Data Warehousing and Business Intelligence by Oracle Corporation
an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover how to integrate information, perform fast queries, scale to...
Best Practices for a Data Warehouse on Oracle Database 11g by Oracle Corporation
companies are recognizing the value of an enterprise data warehouse (EDW). A true EDW provides a single 360-degree view of the business and a powerful platform for a wide spectrum of business...
ETL World Record Benchmark Report-Extending Data Warehouse Performance by Vertica Systems
This paper describes how advances in data warehouse DBMS technology (such as parallel processing) have enabled Syncsort DMExrpess and the Vertica Analytic Database to shatter the...
Slashing Data Warehouse Costs with the Vertica® Analytic Database by Vertica Systems
Vertica® Analytic database cuts the high data warehousing costs of high-end hardware and DBA personnel overhead for performance tuning. Vertica is the only DBMS built from the...
Increasing Enterprise Data Warehouse Performance, Longevity and ROI with the Vertica® Analytic Database by Vertica Systems
increase the performance and longevity of the Enterprise Data Warehouse by offloading certain analytic workloads from an existing EDW to a Vertica® Analytic Database. Considering the strategic...
Squeezing More Value out of Data Warehouses through the Power of Database Compression by Vertica Systems
Data compression features in data warehouse databases are the current trend, and this paper explains the benefits of compression in data warehousing and differentiates...
Uncovering Insight Hidden In Text: How Unstructured Data Analysis Is Helping IT Deliver Knowledge by SAP BusinessObjects
to deliver. Yet current business intelligence (BI) and data warehouse systems only examine specific quantifiable data. This white paper from Business Objects, explores the growth trend of...
Oracle Exadata - Extreme Performance by Oracle Corporation
Machine, Oracle is revolutionizing high performance data warehousing. With Larry Ellison's OpenWorld 2008 announcement of the Oracle Exadata Storage Server and the HP Oracle Database...
What's Cool about Columns by ParAccel
to step out of the shadows to become a major force in the data warehouse and associated markets. Given that view, this paper will define what column-based relational databases do and how they do it, and...
Structuring the Haystack - Business Intelligence and Enterprise Search Solutions by Information Builders
A researcher at The Data Warehousing Institute recently estimated that 80 percent of information available in an average enterprise is unstructured...
Gaining the Performance Edge Using a Column-Oriented Database Management System by Sybase, Inc.
As organizations continue to employ larger data warehouses, the need for performance will continue to outpace the capabilities of traditional relational databases. This paper...
Data Integration: Creating a Trustworthy Data Foundation for Business Intelligence by SAP America Inc
This white paper discusses the importance of data integration and help you identify the key challenges of integrating data. It also provides you with an overview of data...
Using Master Data in Business Intelligence by SAP America Inc
This paper reviews the current status of master data management (MDM) and offers suggestions for planning, building, and deploying an MDM environment. It examines how the MDM...
The Path toward Pervasive Business Intelligence at Ferrari North America by Tableau Software
and of all sizes are turning to business intelligence (BI) and data warehousing (DW) technologies and services to either automate or support decision-making processes. The trend toward evidence...
A Technical Overview of the HP Oracle Exadata Storage Server by Oracle Corporation
deliver outstanding I/O and SQL processing performance for data warehousing applications by leveraging a massively parallel architecture to enable a dynamic storage grid for Oracle Database...
ER/Studio 8.0 - Database management for the Enterprise by Embarcadero Technologies, Inc.
management; Enterprise communication capabilities; Data warehouse and integration support; Quality database designs.

Download size: 300Mb

Terms of Trial License: 14 day trial period

Oracle Audit Vault by Oracle Corporation
in reports provide easy compliance reporting and the open data warehouse provides extensible reporting using Oracle BI Publisher or 3rd party business reporting solutions.

Oracle Audit Vault...
The State of the Data Integration Market White Paper by Oracle Corporation
This white paper reviews the state of the market for data integration for 2008 and 2009. It defines data integration, discusses the trends in the data integration market, and provides...
SQL Server Resource Center
Performance implications of transaction log autogrowth in SQL Server
plans or customized jobs that shrink the database files (data and/or transaction log) periodically.

In my previous article on shrinking your... More...

Jun 25, 2009
The keys to database backup protection for SQL Server
no one else can take your backups and restore them to get your company's data.

The methods for this can vary depending on which technique is used to store your... More...

Jun 22, 2009
The short course on how SQL Server really works
those same 8 KB chunks in memory, meaning the smallest unit of data SQL Server works with is 8 KB.

When data is written to disk, an entire row of it must fit... More...

Jun 10, 2009
Understanding transparent data encryption in SQL Server 2008

Transparent Data Encryption (TDE) is a new feature in SQL Server 2008 designed to encrypt your... More...

Jun 9, 2009
SQL Related Articles
Microsoft renames SQL Server release, adds data services by Barbara Darrow, Senior News Director
be getting a new name, added logical processor support and a bevy of new data management services.

At TechEd, Microsoft said it will re-label the next major release of SQL Server, which was expected to be SQL... More...

May 11, 2009