InfoQ Homepage Data Warehousing Content on InfoQ
-
SQL Server 2008 Major Updates
Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.
-
Event Stream Processing: Scalable Alternative to Data Warehouses?
Dan Pritchett suggests that analyzing streams of events using Event Stream Processor could be an interesting alternative solution to data warehousing applications, which have, in his opinion, important downsides in terms of cost, scalability and reactivity.
-
Introducing the Microsoft Sync Framework (Again)
Back in August, we reported on the release of the Microsoft Sync Framework. Strangely enough, they recently have released it again. In honor of this bizarre event, we are following up with what information we have on this muddled framework.
-
Is Enterprise Data Management the Third Face of the SOA/BPM Coin?
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
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
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?
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
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
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
Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.
-
Article: Bridging the gap between BI and SOA
Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. "Bridging the gap between BI & SOA" demonstrates how to reconcile the differences
-
SQL Server Best Practices Analyzer No Longer Tied to Service Packs
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.
-
Sparse Columns Added to SQL Server 2008
SQL Server 2008 has lifted the limit of 1024 columns per table with a new option called "sparse columns". While this seems like its excessive, some developers have been running up against this limit.
-
ActiveWarehouse, a New Step for Enterprise Ruby
ActiveWarehouse, is a significant new plugin that makes it easier to build data warehouses in Rails.