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 GoldenGate's technology solution for real-time data warehousing, and real-world examples of customers who
The Great Debate: Buy Versus Build - Oracle's Pre-Built Analytic Applications Versus Building a Custom Warehouse by Oracle Corporation
and cons of deploying pre-built analytic 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 verses a custom data warehouse is something that all administrators should consider when deploying a
Real-Time Data Warehousing: 3 Case Studies by GoldenGate Software, Inc.
GoldenGate Software is used for 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 describing its features for real-time, low-impact transactional change data capture and architecture
Architecting Cost-effective Scalable Oracle Data Warehouses by Sun Microsystems, Inc.
warehouses on Sun servers for small, 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 top of the game, IT managers need cost-effective, powerful solutions that can be quickly implemented to
Sun and Infobright - Delivering high-performance data warehouse solutions that cost less to run by Sun Microsystems, Inc.
the Sun and Infobright solution provides an easy to manage, enterprise-class, highly scalable data warehouse with low total cost of ownership. Bringing together innovative software, server, and storage platforms, the Sun and Infobright solution provides an easy to manage, enterprise-class, highly scalable data warehouse with low total cost of
The Vertica Analytic Database: Rethinking Data Warehouse Architecture by Vertica Systems
value at lower cost. These 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 warehousing, it has developed a novel architecture that combines storage optimization, processing efficiencies, and
Oracle Optimized Warehouse for Sun by Sun Microsystems, Inc.
servers, storage, and the Solaris™ 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, calibrated, and validated solution that includes the Oracle database, Sun™ servers, storage, and the
Oracle Database 11g for Data Warehousing and Business Intelligence by Oracle Corporation
This white-paper provides 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 very large data volumes, and more. This white paper provides an overview of Oracle Database 11g's data
Best Practices for a Data Warehouse on Oracle Database 11g by Oracle Corporation
the data loading process. Increasingly 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 intelligence tasks ranging from predictive analysis to near real-time strategic and tactical decision support
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 previous ETL performance benchmark, held by Microsoft and Unisys. This paper describes how advances in data
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 ground-up to handle large-scale data analysis workloads for lots of concurrent users. The Vertica Analytic
Increasing Enterprise Data Warehouse Performance, Longevity and ROI with the Vertica® Analytic Database by Vertica Systems
paper describes how its possible to 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 importance of Enterprise Data Warehouses(EDWs) and the millions of dollars spent creating and maintaining them
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 compression approaches taken by different databases. In a world of growing data volumes and shrinking IT
Uncovering Insight Hidden In Text: How Unstructured Data Analysis Is Helping IT Deliver Knowledge by SAP BusinessObjects
access to corporate data, IT is pressured 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 unstructured data and examines the many benefits of unstructured data analysis. As the shepherds of corporate data, IT
What's Cool about Columns by ParAccel
them, we believe that it is time for columns 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 where they have advantages (and disadvantages) compared to traditional approaches. This in turn will lead to a
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 and unavailable from any standard database management system. What can you do about it? Enterprise search
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 explores the data explosion and why column-oriented database systems are able to provide the boost needed to
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 warehousing and its variations, as well as summarizes the benefits and approaches to integrating data. To make sound
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 environment can be used in conjunction with BI applications and an underlying data warehousing environment to
The Path toward Pervasive Business Intelligence at Ferrari North America by Tableau Software
Organizations in all industries 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-based decision-making is taking root in commercial, non-profit and public sector organizations
A Technical Overview of the HP Oracle Exadata Storage Server by Oracle Corporation
outlines how Oracle Exadata can 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 11g deployments. The HP Oracle Exadata Storage Server is a revolutionary high-performance storage
Oracle Audit Vault by Oracle Corporation
challenges. Numerous built-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 leverages Oracle's proven data warehousing and partitioning capabilities to achieve massive storage
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 lessons learned from real implementations. Data integration is a critical and fundamental element in a variety
Related Trends
New security strategies include "data minimization"
The process of data minimization includes not collecting or maintaining unneeded information, reducing storage locations and purging data once it's no longer needed More...
Jan 17, 2007
Data theft response plans key to managing breaches
2007, experts gave recommendations for data theft response plans, saying that enterprises with such plans in place are more likely to survive a data breach More...
Feb 13, 2007
Analysis of Teradata's master data management plans
Corp. subsidiary Teradata released two master data management products recently and an analyst says the company is well positioned to deliver products for the domain More...
Aug 23, 2006
Congressman wants more accountability for data breaches
After a recent data breach affecting MasterCard and Visa holders, Mass. Rep. Barney Frank said that the responsible companies should contact customers or be publicly identified More...
Feb 16, 2006
Related Expert Advice
Can a program use IXLLIST macros in CICS? by Robert Crawford
to use some other mechanism to share data across the Sysplex. If this is a purely CICS application, shared temporary storage queue servers will do the trick. Failing that, there's everyone's favorite kluge, a shared VSAM file. CICS expert Robert Crawford discusses if a program can use More...
Dec 19, 2007
COBOL program that will run in z/OS and open in MS-Word by Mark Zelden
the format is, it must contain ASCII data written in an EBCDIC environment and whatever control information is needed for Word to open it as a fully formatted Word file (if that is what you want). This implies that you must do a BINARY FTP transfer to the network drive where the file will More...
Mar 3, 2006
Additional communication possibilities besides "dark fiber" and DWDM by Mark Zelden
a Sysplex environment between two Data Centers (20 Km), only to reduce software costs (implement WLC for both mainframes). For Sysplex timer (ETR e CLO) e Coupling facility (ISC) protocols there is any additional communication possibility besides "dark fiber" and DWDM?

I really don't have More...

Mar 3, 2006