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

Calpont Corp, a provider of analytic database solutions, announced it is shipping a data warehouse solution based on open source technology. The product will be available as a commercially supported solution, as well as community download.

Posted February 16, 2010

There's no question that databases are the heart of nearly every application running these days. Moreover, the information stored in databases is now being routinely used as a competitive and operational business weapon by all businesses and organizations regardless of size or industry. Whether used internally in business intelligence applications or utilized externally via the exposure of data tools that let customers view and search through vast amounts of data on websites, data is being maximized in many different ways.

Posted February 09, 2010

After receiving regulatory approval from the European Commission for its acquisition of Sun Microsystems, Inc, Oracle last week announced that it had closed the deal, completing a process begun last spring. While the purchase had been held up by the European Commission's concerns that Oracle's ownership of the MySQL open source database, through the Sun acquisition, would have an adverse effect on competition, in a statement released by the commission, Competition Commissioner Neelie Kroes said, "I am now satisfied that competition and innovation will be preserved on all the markets concerned. Oracle's acquisition of Sun has the potential to revitalize important assets and create new and innovative products."

Posted February 03, 2010

Syncordant, a data integration company, has announced the release of its new enterprise-class product, the Data Integrator. The new product enables a single, real-time, customizable view into multiple heterogeneous databases distributed anywhere in the world.

Posted February 02, 2010

Netezza Corporation, a provider of data warehouse and analytic appliances, announced it has begin shipping a data warehouse appliance with a compact footprint that can power development groups and data marts or serve as a platform for application appliances.

Posted February 02, 2010

Oracle has received regulatory approval from the European Commission for its acquisition of Sun Microsystems, Inc. Oracle said it expects unconditional approval from China and Russia and intends to close the transaction shortly. In a statement released by the commission, Competition Commissioner Neelie Kroes said, "I am now satisfied that competition and innovation will be preserved on all the markets concerned. Oracle's acquisition of Sun has the potential to revitalize important assets and create new and innovative products."

Posted January 26, 2010

Ingres Corporation, a leading open source database management company, announced today a technology preview program for Ingres VectorWise. VectorWise is a database technology that, according to Ingres, delivers the performance needed to deal with explosive data growth and is the first business software to fully take advantage of advances in modern chip technology.

Posted January 26, 2010

Kickfire, Inc., a provider of affordable, high performance analytic appliances, has entered into the Partner Network with Rackspace Hosting, a leader in hosting and cloud computing, to deliver affordable, high-performance analytic appliance hosting and managed services. By joining the network, Kickfire can provide its customers with access to Rackspace's fully managed hosting and 24x7 Fanatical Support services. The two companies will also participate in joint sales and marketing programs.

Posted January 26, 2010

IBM reported a decrease in annual revenues between 2008 and 2009, but revenues for the most recent quarter held steady. Overall, the company reports, revenues for 2009 totaled $95.8 billion, a decrease of 8% (5%, adjusting for currency), compared with $103.6 billion in 2008.

Posted January 25, 2010

Jaspersoft, a provider of open source business intelligence software, today announced the availability of Jaspersoft 3.7, and also unveiled the new Jaspersoft Enterprise Edition, which offers a complete package of advanced business analytics and reporting functionality.

Posted January 12, 2010

With the increased merging of disparate core business systems in the enterprise - as well as the emergence of additional systems in the form of enterprise resource management, customer relationship management, hierarchical storage strategies, and other business-driven initiatives - many companies today find themselves moving mountains of data on a daily basis. Business intelligence (BI) initiatives in particular typically rely on data warehousing strategies to provide critical information and reports to management in support of business decisions. Such strategies often require the timely transfer of enormous amounts of data from line-of-business systems. Too much time taken in data transfer can adversely impact a company's agility and could mean lost windows of business opportunities. It can also encroach on processing resources better devoted to core business applications.

Posted January 11, 2010

Attunity Ltd., a provider of real-time data integration and event capture software, is expanding its partnership with Open Text Corporation, an enterprise software company. Through the partnership, Open Text will market advanced data connectivity solutions, including legacy decommissioning, data lifecycle management and real-time data warehousing, which will leverage Attunity's legacy data connectivity and low-impact change data capture (CDC) technology.

Posted January 05, 2010

Sybase, Inc. today announced that its IQ 15.1 column-based analytics server, working with the IBM Power 595 system and running the AIX 6L version 6.1 Operating System, achieved the best overall performance result currently published among all non-clustered systems for the TPC-H benchmark at the 3TB scale factor . In addition, the Sybase and IBM solution also recorded the best current overall price/performance result among non-clustered systems that deliver over 100,000 QphH for the TPC-H benchmark at the 3TB scale factor .

Posted December 16, 2009

Sybase, Inc. has announced it is leveraging the newest version of its column-based analytics server—Sybase IQ 15.1—and its global mobile messaging reach, enabling the company to provide deep analytics functionality on the Sybase 365 mobile services platform that will address the needs of mobile operators, financial institutions and enterprise customers. The first offering, to be launched in Q1 2010, will be a hosted analytics solution for mobile operators, providing them with improved quality of service, a greater insight into their off-network messaging traffic, and enabling them to better execute revenue generating activities around these trends.

Posted December 16, 2009

Infobright, an open source data warehousing company, and Talend, an open source data integration company, have announced the availability of two integrated virtual machines for data warehousing and business intelligence. The first virtual machine combines the Infobright Community Edition analytic database with the Talend data integration tool, Talend Open Studio. The second virtual machine bundles these same two products with Jaspersoft's open source report server, JasperServer Community Edition, to deliver an end-to-end business intelligence solution.

Posted December 01, 2009

Aster Data, a provider of data warehousing solutions for "big data" applications, yesterday announced Aster Data Version 4.0, which the company describes as the industry's first "Massively Parallel Data-Application Server." Aster Data 4.0 allows companies to embed applications inside Aster Data's MPP (massively parallel processing) data warehouse, so businesses can now store, analyze and speed processing of terabytes to petabytes of data. The ability to push applications down into the MPP database also opens a new opportunity for companies to deliver new interactive, big data applications.

Posted November 03, 2009

Yesterday marked the beginning of the annual Teradata Partners User Group conference with a flurry of announcements from the enterprise data warehousing leader focused on new product innovations and partner developments. "Information is power, but intelligence is transformative," James Vollmer, president of the Partners steering committee, announced to a buzzing room after stepping out of a custom Teradata-orange muscle car during the opening keynote.

Posted October 20, 2009

Noetix Corp., a software provider that automatically generates business intelligence content from enterprise applications, has completed the acquisition of privately-held business analytics company, Jaros Technologies Corp., for an undisclosed sum.

Posted October 13, 2009

Aster Data, a provider of data analytics and management platforms for "big data" applications, has announced the availability of a new Aster-Hadoop Data Connector, which utilizes Aster's patent-pending SQL-MapReduce capabilities for two-way, high-speed, data transfer between Apache Hadoop and Aster Data's massively parallel data warehouse.

Posted October 13, 2009

SOA Software's Repository Manager 6.1 product has been certified by SAP AG as "Powered by SAP NetWeaver." The solution provides SOA governance of enterprise services exposed and consumed by SAP solutions.

Posted September 21, 2009

Teradata Corporation, a provider of enterprise data warehousing solutions, was invited to provide testimony before the U.S. House Financial Services Committee's Subcommittee on Oversight and Investigations, joining a panel of experts and stakeholders on the topic. The hearing, titled "Utilizing Technology to Improve TARP and Financial Services Oversight" was largely focused on driving accountability and transparency through database technology. Dow Jones & Company, the U.S. Chamber of Commerce, the SAS Institute, Inc, and the Center for Democracy and Technology were also among the witnesses.

Posted September 21, 2009

The world's first OLTP Database Machine was unveiled yesterday by Larry Ellison, CEO of Oracle, with John Fowler, Sun executive vice president, during a live webcast. "For a long time we have been working with Sun and this is the latest output of that partnership—Oracle Exadata version 2, hardware by Sun and software by Oracle," said Ellison.

Posted September 16, 2009

Kalido, a provider of information management software for enterprise data goverance, and Netezza, a provider of data warehousing and analytics appliances, have announced that Kalido has licensed and will directly sell a custom-built Netezza TwinFin data warehouse appliance engineered and optimized for the Kalido Information Engine and Kalido's new industry-specific analytics and reporting solutions.

Posted September 15, 2009

Oracle Database 11g Release 2 became generally available and downloadable yesterday from the Oracle Technology Network (OTN). Improvements have been made in all key areas, with a general emphasis on helping customers lower their IT infrastructure costs. Announcing the new release during a conference call yesterday, Andy Mendelsohn, senior vice president of Database Server Technologies, Oracle observed, "Right now the majority of our installed base customers are running on 10g R2, with a good number on 11g R1. The reason 11g R2 is important is not only for the innovations in the release but it is really the release that the masses of our installed base are going to be moving to as they go to the 11g family of databases."

Posted September 02, 2009

Oracle Database 11g Release 2 is generally available and downloadable today from the Oracle Technology Network (OTN). Improvements have been made in all key areas, with a general emphasis on helping customers lower their IT infrastructure costs.

Posted September 01, 2009

SenSage has announced that it is participating in the EMC Data Warehouse/Business Intelligence/Analytics Competency Center to provide customers an optimized solution to manage large-scale event data warehouse and business intelligence environments. SenSage offers patented event data warehouse solutions that provide actionable results from large amounts of log and event data. The SenSage data warehouse software is integrated with EMC networked storage systems, and is designed to help organizations achieve cost efficiencies and reduce time-to-value in data warehouse deployments.

Posted July 14, 2009

Greenplum, a provider of database software for the next generation of data warehousing and analytics, has unveiled its Enterprise Data Cloud (EDC) initiative. The EDC Initiative is a new vision for bringing the power of self-service to data warehousing and analytics, encompassing the primary areas of platform (the EDC platform, based on self-service provisioning, elastic scale and massively parallel processing), methodology (an agile approach to data analytics that embraces large-scale data collection, getting data into the hands of business users, and iterating quickly), and ecosystem (customers and partners that embrace these new capabilities with tools, infrastructure and creative methodologies).

Posted June 09, 2009

Talend, a leading provider of open data integration software, has announced the availability of Talend Integration Suite MPX, a new edition of its Integration Suite Platform specially designed to help organizations attain high levels of performance and remove obstacles typically associated with traditional data integration processes.

Posted May 19, 2009

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