Data Warehousing

Hardware and software that support the efficient consolidation of data from multiple sources in a Data Warehouse for Reporting and Analytics include ETL (Extract, Transform, Load), EAI (Enterprise Application Integration), CDC (Change Data Capture), Data Replication, Data Deduplication, Compression, Big Data technologies such as Hadoop and MapReduce, and Data Warehouse Appliances.

Data Warehousing Articles

Dataupia Corporation's Dataupia Satori Server now supports Oracle Database 11g, including Linux and Solaris operating system platforms.

Posted May 07, 2009

Jaspersoft, provider of business intelligence (BI) software, and Infobright, the open source data warehouse company, have announced the general availability of what they describe as the first open source project to feature end-to-end BI, extract-transform-load (ETL), and data warehousing capabilities. The companies have also announced that Bi3 Solutions, provider of a virtual on-demand BI solution, has chosen the BI project to build an end-to-end BI suite.

Posted April 28, 2009

IBM has announced version 9.7 of DB2 and InfoSphere Warehouse software, focused on transactional performance improvements in the DB2 database, and on expansion of analytics to XML data in the InfoSphere Data Warehouse. Both new products also reduce an even greater amount of space needed to store data, helping clients to gain significant savings on related costs including energy. This offering is also the industry's first database software that will deliver business analytics capabilities for both relational and XML data at the same time, according to IBM.

Posted April 28, 2009

Infobright, an open source data warehousing company, has released Infobright 3.1, the latest version of its data warehouse product that offers simplicity, ease of use and low total cost of ownership. According to the vendor, the columnar database is ideal for analytics, and is available in two editions: a free, open source version named Infobright Community Edition (ICE) and a licensable version named Infobright Enterprise Edition (IEE). The version 3.1 product release contains two primary new features, one of which is available with both the ICE and IEE, and the other only with the IEE.

Posted April 21, 2009

Sybase, Inc., announced that Sybase IQ 15, combined with Sun Microsystems' Sun Fire X4540 storage server and running the Solaris 10 Operating System (OS), recorded the best price/performance result in the TPC-H benchmark at 3000 GB scale factor for all non-clustered systems. The benchmark simulates decision support systems that analyze large volumes of data, executes queries with a high degree of complexity, and gives answers to critical business questions. Sybase says that the achievement illustrates the effectiveness of Sybase IQ 15 in helping to optimize IT asset utilization and significantly reduce ownership costs.

Posted April 14, 2009

Oracle is offering a new, smaller version of the HP Oracle Database Machine, according to a recent post on the company's Data Warehouse Insider blog. This follows the initial introduction of the HP Oracle Database Machine, which was unveiled by CEO Larry Ellison at Oracle OpenWorld in September 2008. More than three years in development, Ellison called the offering "the world's fastest database machine."

Posted April 02, 2009

Oracle is offering a new, smaller version of the HP Oracle Database Machine, according to a post last week on the company's Data Warehouse Insider blog. This follows the initial introduction of the HP Oracle Database Machine, which was unveiled by CEO Larry Ellison at Oracle OpenWorld in September 2008. More than three years in development, Ellison called the offering "the world's fastest database machine."

Posted March 24, 2009

Greenplum, a leading provider of database software for the next generation of data warehousing and analytics, has announced new technology designed to accelerate data loading for companies dealing with exponential data growth. Greenplum's new "MPP Scatter/Gather Streaming" (SG Streaming) technology eliminates the bottlenecks associated with other approaches to data loading, enabling high-speed flows of data into the Greenplum Database for large-scale analytics and data warehousing. According to Greenplum, some of its customers are achieving production loading speeds of over four terabytes per hour with negligible impact on concurrent database operations. The SG Streaming technology is available immediately and is a standard feature of the Greenplum Database.

Posted March 24, 2009

Infobright, the open source data warehousing company, has announced Infobright Community Edition (ICE) for Windows. In response to requests from the Infobright open source user community, the company now offers native support for its popular ICE open source data warehouse on the Microsoft Windows platform.

Posted March 10, 2009

IBM has released new Informix database software to help companies make decisions more intelligently and maximize sales opportunities while reducing expenses. With the new software, known as the Informix Warehouse Feature, global companies can both warehouse their data and conduct fast online transactions with a simplified software platform. The combination of the two capabilities in one offering can help deliver new results and insights to grow businesses and lower costs by making it easier to use existing Informix infrastructures to help clients work more efficiently.

Posted March 10, 2009

Microsoft Corporation has announced SQL Server Fast Track Data Warehouse, a new set of reference architectures for data warehousing that will help eliminate many of the barriers companies traditionally face while creating data warehouses. Priced on a per terabyte basis, SQL Server Fast Track Data Warehouse gives customers immediate access to pretested, preconfigured industry-standard hardware from partners Bull, Dell and HP that makes it easier and more affordable for companies to deploy enterprise-class data warehousing projects.

Posted March 03, 2009

Alvion Technologies provides a web-enabled platform that allows compilers, resellers and managers of marketing lists to easily deliver their product to end-users in support of targeted marketing efforts. Individual customers submit their data and then Alvion runs customer-specific data transformation and uploads the data to production servers, for access by end-users who are the customers of the data owners. If you need, for example, to find consumers within a 35-mile radius of your business that meet a certain profile, you can go online and find lists within Alvion, put in the criteria you are looking for, and those names will be provided to you, via electronic delivery, be it email or download.

Posted February 15, 2009

Panorama Software, a global leader in proactive business intelligence solutions and the company that sold its OLAP technology to Microsoft, has announced that its BI product, NovaView, is immediately available as a long-term BI solution for Microsoft PerformancePoint Server and ProClarity customers affected by Microsoft's recent discontinuation announcement regarding those products.

Posted February 03, 2009

Altosoft, a provider of process-aware business intelligence software solutions, has announced a partnership with Netezza Corporation, which develops and sells data warehouse and analytics appliances. As a result of the partnership, Altosoft's InsightBI business intelligence solution has been certified with the Netezza Performance Server (NPS) data warehouse appliances, and the two companies will collaborate on marketing and sales. Many Altosoft customers have already been running the company's software on Netezza appliances, and this partnership formalizes that combination by providing the market with a fully certified interoperable solution. While the two products are not physically bundled together and must still be purchased separately from the respective companies, their integration has been tested and proven and Altosoft is now a Certified Netezza Partner.

Posted January 20, 2009

IBM has announced the availability of the IBM Retail Performance Analytics (RPA) portfolio of solutions that address complex information-based business problems across retail enterprises. The portfolio combines infrastructure products, business intelligence/performance management software, and consulting services to help retailers plan, manage, and optimize their businesses.

Posted January 20, 2009