InfoQ

Topic/Tag specific view

All content and news on InfoQ about Data Warehousing


Latest featured content about Data Warehousing

Bridging the gap between BI & SOA

Community
SOA
Topics
Web Services,
Data Warehousing

Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. SOA promotes hiding the data inside the services while BI needs that very data if we want to get meaningful predictions and alerts. This article will show you how you can combine SOA with EDA to solve the BI/SOA conflict and maybe even enhance your SOA.

News about Data Warehousing

Is Enterprise Data Management the Third Face of the SOA/BPM Coin?

Community
Architecture,
SOA
Topics
Governance,
Business Process Management,
Enterprise Architecture,
Data Warehousing,
Database Design,
Cloud Computing,
Enterprise Information Integration

Fred Cummins, an EDS fellow, and SOA veteran, wrote an essay last week on "Data Management for SOA". He is looking at how some of the key tenets of service design ("loose coupling" and "autonomy") relate to enterprise data in the context of achieving reuse and enabling change.

Agile Business Intelligence

Community
Agile
Topics
Agile in the Enterprise,
Enterprise Architecture,
Data Warehousing

Large centrally designed BI systems often don't meet the expectations of their end users. In this article at Cutter IT journal Scott Ambler has written about using Agile methods to help meet the user's expectations and deliver business value quickly.

Microsoft Claims to Hold the ETL Record at 1 TB in 30 Minutes

Community
.NET
Topics
Performance & Scalability,
Data Access,
Data Warehousing

Microsoft and Unisys are claiming that they hold the record for loading information into a relational database. The unofficial benchmark was 1 TB of TPC-H data moved in under 30 minutes using an Extract, Transform, and Load (ETL) tool. The previous record for that volume was 45 minutes and was held by Informatica.

Database Virtualization - Is it worth it?

Community
.NET,
Architecture
Topics
Virtualization,
Data Warehousing

Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.

New Compression Features in SQL Server 2008

Community
.NET
Topics
Database Design,
Data Warehousing

SQL Server 2008, code name Katmai, is expected to be released in May. It brings with it a whole host of new features, including several new compression options.

Michael Stonebraker: Major RDBMSes are legacy technology

Community
Java,
.NET,
Architecture,
Ruby
Topics
Data Access,
Data Warehousing

Michael Stonebraker, co-founder of the Ingres and Postgres relational database management systems (RDBMS) and CTO of Vertica Systems, laid the framework for a debate in the database community by declaring that most major databases should be considered legacy technology.

Using SSIS in a Team Setting

Community
.NET
Topics
Data Access,
Teamwork,
Data Warehousing

Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.

SQL Server Best Practices Analyzer No Longer Tied to Service Packs

Community
.NET
Topics
Delivering Quality,
Data Warehousing

According to Paul Mestemaker, the SQL Server Best Practices Analyzer is no longer being tied to SQL Server Service Pack releases. This announcement is being made in conjunction with the first production release of the tool.