Newsletters




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

Full 360 Inc., a New York-based systems integrator, has introduced a new release of its elasticBI platform-as-a-service (PaaS). elasticBI pairs Jaspersoft4, the open source BI application, with the Vertica Analytic Database in a PaaS offering that is tightly integrated via the Opscode Chef framework. The platform is offered by Full 360 on Amazon Web Services, the Amazon cloud. According to Full 360, elasticBI provides a complete BI-data warehouse platform that is accessible from a cost and technical perspective for small and mid-market companies, as well as enterprise departments.

Posted April 26, 2011

HP has updated its Information Management portfolio to enable organizations to reduce risk, increase efficiency and simplify the way they manage their business information. By bringing a holistic approach to information management, HP says the solutions and services will help executives harness the power of their information to make better decisions, manage for cost and compliance, and deliver the right information to the right users at the right time.

Posted April 12, 2011

EMC has announced three new additions to its EMC Greenplum Data Computing Appliance (DCA) line of products - the High Capacity DCA, the High Performance DCA, and the Data Integration Accelerator - as well as version 4.1 of Greenplum Database.

Posted April 12, 2011

With the annual Oracle users conference COLLABORATE about to begin, Andy Flower, president of the IOUG, spoke with 5 Minute Briefing about the IOUG's strong areas of focus in terms of overall conference content, and how the addition of the MySQL user base into the Oracle community is evolving. Citing a MySQL keynote, 75 sessions at COLLABORATE focused on MySQL, and a new MySQL Council headed by Sarah Novotny, Flower says the IOUG is making strides in giving voice to the MySQL community within the IOUG and setting a stage for positive interaction with Oracle.

Posted April 06, 2011

Revolution Analytics, a commercial provider of software and services based on the open source R project for statistical computing, and IBM Netezza announced they are teaming up to integrate Revolution R Enterprise and the IBM Netezza TwinFin Data Warehouse Appliance. According to the vendors, this will enable customers to directly leverage the capabilities of the open source R statistics language as they run high-performance predictive analytics from within data warehouse platforms.

Posted March 21, 2011

Revolution Analytics, a commercial provider of software and services based on the open source R project for statistical computing, and IBM Netezza have announced a partnership to integrate Revolution R Enterprise and the IBM Netezza TwinFin Data Warehouse Appliance. According to the vendors, this will enable customers seeking to run high performance and full-scale predictive analytics from within a data warehouse platform to directly leverage the capabilities of the open source R statistics language. Under the terms of the agreement, the companies will work together to create a version of Revolution's software that takes advantage of IBM Netezza's i-class technology so that Revolution R Enterprise can run in-database in an optimal fashion. General availability of this integrated solution is currently planned for later this year.

Posted March 15, 2011

A member of the Oracle Applications Users Group (OAUG) since 1992, Mark C. Clark recently took over as president of the organization. Recently, 5 Minute Briefing chatted with Clark about what's in store for members at the annual Oracle users conference COLLABORATE as well as for the year ahead. Helping members prepare for an upgrade to Oracle Applications Release 12, providing additional smaller, more targeted regional events, and a continued emphasis on a return to the basics with networking and education are at the top of his to-do list for 2011.

Posted March 08, 2011

Teradata Corporation, which already had an 11% ownership interest in Aster Data Systems, Inc, has signed a definitive agreement to pay $263 million for the remaining ownership interest in the company. Aster Data is a provider of software for advanced analytics and the management of a variety of diverse data that is not structured. The combination of Teradata and Aster Data technologies will enable businesses to unlock the new intelligence within the burgeoning volumes of big data. "Teradata is recognized as an innovator and leader in data warehousing, and the addition of Aster Data will enable us to leapfrog into a leadership position in the emerging big data market. This is a great opportunity and something our customers have been asking for," said Scott Gnau, chief development officer, Teradata Corporation.

Posted March 08, 2011

Oracle has announced that performance testing with Oracle Financial Services Profitability Management running on the Oracle Exadata Database Machine has delivered outstanding results for calculating profitability measures at extreme speed. Oracle Financial Services Profitability Management running on the Oracle Exadata Database Machine computed profitability for 172 allocation rules across 250 million accounts and more than 1 billion transactions in only 4 hours and 45 minutes.

Posted March 02, 2011

The market for data warehouse appliances - solutions consisting of integrated software and hardware - is heating up, with new twists emerging from both established and new appliance vendors. Netezza, an early proponent of the appliance approach, was acquired in November 2010 by IBM. Here, Phil Francisco, vice president, product management and product marketing for IBM Netezza, shares his views on what's changing and what's ahead for appliances. Going forward, he anticipates that there will be very specific, vertically-oriented solutions that are built on appliances, which will take into account the kinds of data models and the kind of functionality that is required for industries such as telco, retail, and financial services.

Posted February 23, 2011

HP announced it has signed a definitive agreement to acquire Vertica, a privately held, real-time analytics platform company based in Billerica, Mass. According to HP, the acquisition will enhance its capabilities for information optimization, adding sophisticated, real-time business analytics for large and complex sets of data in physical, virtual and cloud environments. Vertica's platform aims to help customers analyze massive amounts of data quickly, resulting in "just-in-time" business intelligence.

Posted February 15, 2011

Over the past 3 years, the IOUG ResearchWire studies conducted by Unisphere Research have focused on Oracle technology as well as trends affecting data professionals, allowing IT professionals to benchmark where their organizations stand within their own technology environment. Executive Summaries of all IOUG ResearchWire reports are publicly available for free download and full study reports are also available to IOUG members at no charge when they sign in with their user name and password.

Posted February 02, 2011

EMC has introduced a free Community Edition of the EMC Greenplum Database, the high-performance massively parallel processing (MPP) database product, along with free analytic algorithms and data mining tools. The new offering is intended to remove the cost barrier to entry for big data power tools for developers, data scientists, and other data professionals, according to EMC. This free set of tools will enable the community to better understand their data, gain deeper insights and better visualize insights, as well as contribute and participate in the development of new tools and solutions. With the Community Edition stack, developers can build complex applications to collect, analyze and operationalize big data leveraging big data tools including the Greenplum Database with its in-database analytic processing capabilities.

Posted February 01, 2011

The market for data warehouse appliances - solutions consisting of integrated software and hardware - is heating up, with new twists emerging from both established and new appliance vendors. Netezza, an early proponent of the appliance approach, was acquired in November 2010 by IBM. Here, Phil Francisco, vice president, product management and marketing for IBM Netezza, shares his views on what's changing and what's ahead. Going forward, Francisco sees very specific, vertically-oriented solutions that are built on appliances, whether it be for Telco, retailers, or financial services. "These appliances will take into account the kinds of data models that are required, but also the kind of functionality that is required for those industries and relieve even more of the day-to-day administration requirements," he notes.

Posted February 01, 2011

HP and Microsoft have announced four new converged application appliances that combine applications, infrastructure and productivity tools into a single system. In addition, there is the previously-announced HP Enterprise Data Warehouse Appliance, an enterprise-level mission-critical system. Now available with a starting price of $2 million, the HP Enterprise Data Warehouse Appliance is said to deliver up to 200 times faster queries and 10 times the scalability of traditional SQL Server deployments."Our appliances have been engineered from the beginning with time to solution in mind," Fausto Ibarra, senior director of Business Intelligence at Microsoft, tells 5 Minute Briefing. "We are really offering a unique value proposition."

Posted January 25, 2011

The Data Warehousing Institute (TDWI) will present the first event in its 2011 conference series February 13-18 at Caesars Palace in Las Vegas, with the theme "Building An Enterprise Data Strategy: A Framework For Consistent Information Across The Enterprise." The aim of the 6-day event is to provide attendees with the education they need about how to inventory, govern, integrate, and exploit their data assets. Organizations have "massive amounts of data" as well as a variety of different databases and duplicates of databases, and, as a result, people are not aware of all the data they have and how they can utilize it, Paul Kautza, director of education of TDWI, tells 5 Minute Briefing. The conference will provide classes on how to gain critical executive sponsorship, connect point projects into a unified data management approach, and define and implement a true corporate data strategy that will deliver consistent information across an enterprise.

Posted January 18, 2011

The exponentially increasing amounts of data being generated each year make getting useful information from that data more and more critical. The information frequently is stored in a data warehouse, a repository of data gathered from various sources, including corporate databases, summarized information from internal systems, and data from external sources. Analysis of the data includes simple query and reporting, statistical analysis, more complex multidimensional analysis, and data mining.

Posted January 07, 2011

At the recent Supercomputing 2010 conference, IBM unveiled details of a new storage architecture design created by IBM scientists that will convert terabytes of pure information into actionable insights twice as fast as previously possible. Ideally suited for cloud computing applications and data-intensive workloads such as digital media, data mining and financial analytics, this new architecture will improve the speed of complex computations without requiring heavy infrastructure investment. IBM won the Storage Challenge competition for presenting the most innovative and effective design in high performance computing with the best measurements of performance, scalability and storage subsystem utilization.

Posted December 08, 2010

expressor software has announced an update to its enterprise data integration platform, which features enhancements in performance and reusable data mappings. expressor 3.0 is a design, development and deployment platform for supporting various data integration applications, from tactical data migrations to large enterprise data warehouses and strategic, predictive analytics.

Posted December 01, 2010

The IOUG has completed a number of ground-breaking studies in 2010 through the IOUG ResearchWire program. Conducted among IOUG members by Unisphere Research, 2010 IOUG ResearchWire Executive Summaries are available to all on the IOUG website.

Posted December 01, 2010

Panorama Software, a provider of proactive business intelligence (BI) solutions, has announced support for the Microsoft SQL Server 2008 R2 Parallel Data Warehouse through its flagship business intelligence solution, Panorama NovaView 6.2.

Posted November 30, 2010

The year 2010 brought many new challenges and opportunities to data managers' jobs everywhere. Companies, still recovering from a savage recession, increasingly turned to the power of analytics to turn data stores into actionable insights, and hopefully gain an edge over less data-savvy competitors. At the same time, data managers and administrators alike found themselves tasked with managing and maintaining the integrity of rapidly multiplying volumes of data, often presented in a dizzying array of formats and structures. New tools and approaches were sought; and the market churning with promising new offerings embracing virtualization, consolidation and information lifecycle management. Where will this lead in the year ahead? Can we expect an acceleration of these initiatives and more? DBTA looked at new industry research, and spoke with leading experts in the data management space, to identify the top trends for 2011.

Posted November 30, 2010

Did you miss a webcast covering important information about technologies you need to learn more about? IBM offers replays on-demand of webcasts presented by IBM experts and partners.

Posted November 23, 2010

ParAccel, Inc., provider of a high-speed analytic database, announced a new release of its analytical database, designed to enable organizations to more rapidly generate custom analytics, accelerate time to analysis, and use existing infrastructure standards. The new database release, ParAccel Analytic Database (PADB) 3.0, is intended to help organizations leverage in-database analytics to eliminate errors and delays from unnecessary data movement.

Posted November 23, 2010

Embarcadero Technologies has announced the availability of ER/Studio XE, database design and data modeling tool suite. This latest version offers improvements in the user experience, and enhanced scalability and performance.

Posted November 17, 2010

Embarcadero Technologies has announced the availability of ER/Studio XE, database design and data modeling tool suite. This latest version offers improvements in the user experience, and enhanced scalability and performance.

Posted November 17, 2010

White Sands Technology, a provider of multi-platform database tools headquartered in Canoga Park, Calif. with offices located in the UK and Finland, has announced the upcoming release of three ProActive DBA products for Sybase Replication Server DBAs. General release of these new products will be in Q1 2011. The three products include ProActive DBA TimeLine 24x7, ProActive DBA SQL Capture for Sybase RepServer, and ProActive DBA Login Capture for Sybase RepServer.

Posted November 17, 2010

Attunity Ltd., a provider of real-time data integration and event capture software, announced major enhancements to its CDC Suite for SSIS, providing a comprehensive solution for replicating data in real-time across a wide range of heterogeneous data sources at an affordable price point. The product suite is used by customers worldwide to enable real-time business intelligence (BI) and designed to improve business operations and reduce costs.

Posted November 16, 2010

Progress Software has announced the availability of database drivers for the Microsoft SQL Server 2008 R2 Parallel Data Warehouse. Available for pre-sales registration immediately with shipment in Q2 2011, the Progress DataDirect Connect drivers enable companies using UNIX-, Linux- and Java-based applications to connect to Microsoft SQL Server 2008 R2 Parallel Data Warehouse.

Posted November 16, 2010

Embarcadero Technologies today announced the availability of ER/Studio XE, database design and data modeling tool suite. This latest version offers improvements in the user experience, enhanced scalability and performance, and expanded database management system (DBMS) support for Netezza's TwinFin appliance.

Posted November 09, 2010

Oracle introduced the Oracle Exadata Database Machine X2-8 at Oracle OpenWorld. The new configuration extends the Oracle Exadata Database Machine product family with a high-capacity system for large OLTP, data warehousing and consolidated workloads. "The data volumes now are huge, and they are going to keep getting bigger and as they grow rapidly, you will need more and more power," said Oracle president Mark Hurd, commenting on the release during a keynote at the Oracle conference.

Posted October 06, 2010

Estimates put the amount of data in existence at this time at more than a zettabyte (or a trillion gigabytes), which would be the equivalent of 75 billion fully loaded iPads. All this data is streaming into and through enterprises from transactions, remote devices, partner sites and user-generated content, with formats varying from structured, relational data to graphics and videos.

Posted October 06, 2010

Oracle last week introduced the Oracle Exadata Database Machine X2-8. The new configuration extends the Oracle Exadata Database Machine product family with a high-capacity system for large OLTP, data warehousing and consolidated workloads. With this announcement, there are now four configurations of the Oracle Exadata Database Machine: the new Oracle Exadata X2-8 full-rack and the Oracle Exadata X2-2 quarter-rack, half-rack and full-rack systems.

Posted September 28, 2010

IBM today announced its intention to acquire Netezza, a publicly held company based in Marlborough, Mass., in a cash transaction at a price of $27 per share or at a net price of approximately $1.7 billion, after adjusting for cash. Business analytics is one of the fastest growing segments in the IT industry, observed Arvind Krishna, general manager of IBM's Software Group's Information Management business, during an IBM press teleconference to discuss the significance of the planned acquisition. By bringing the simplicity, ease of deployment, and speed of Netezza to IBM, the acquisition will help IBM accelerate its initiatives "to bring analytics to the masses," added Jim Baum, president and CEO of Netezza. The transaction, which is subject to Netezza shareholder approval, regulatory clearances and other customary closing conditions, is expected to close in the fourth quarter of 2010.

Posted September 20, 2010

IBM has entered into a definitive agreement to acquire Storwize, a privately held company based in Marlborough, Mass. With Storwize, IBM says, it is acquiring storage technology that is unique in the industry due to its ability to compress primary data, or data that clients are actively using, of multiple types - from files to virtualization images to databases - in real-time while maintaining performance. "This is in contrast to what we see our competitors doing, which is primarily focusing on compressing data that is inactive, or data at rest - backup data, as an example," explained Doug Balog, vice president of IBM Storage, during a conference call announcing the planned acquisition.

Posted August 03, 2010

The Pythian Group Inc., a remote database infrastructure services company and a Platinum member of the Oracle PartnerNetwork has announced the implementation of the Sun Oracle Database Machine at LinkShare Corporation, a division of Rakuten, Inc., and the launch of Pythian's Oracle Exadata services practice.

Posted July 21, 2010

Melissa Data, a developer of data quality and address management solutions, has released a 25th anniversary special edition catalog. The catalog provides detailed listings on over 60 different Melissa Data products and services including enterprise data quality platforms, developer tools, address management software, mailing lists, and data hygiene services. The catalog also offers links to many white papers on data quality and direct marketing, as well as information on the Melissa Data Independent Software Vendor Program, and their Data Quality Challenge.

Posted July 20, 2010

The Data Warehousing Institute will present the TDWI World Conference 2010 with a focus on creating an Agile BI environment. The conference will take place at the Manchester Grand Hyatt San Diego Hotel, August 15-20, 2010. "Agile is becoming very hot in the business intelligence industry and in data warehousing. It has been mainstream in software development for some time, but is coming of age now in business intelligence," Paul Kautza, director of education of TDWI, tells 5 Minute Briefing.

Posted July 13, 2010

Mid-sized businesses are using and saving more data than ever before. Indeed, the phenomenon that IT engineers have come to refer to as "big data" is being felt in businesses of all sizes. At the same time, however, organizations are facing reduced budgets. Regardless of how much data their likely overburdened IT staff must manage today and tomorrow, mid-sized businesses must find ways to save money by keeping a tight rein on both capital and operational expenditures.

Posted July 12, 2010

expressor software, a provider of data integration solutions, announced version 2.3 of the expressor semantic data integration system, which features enhanced low-latency data processing performance and strengthened support for Netezza. The new release includes new data windowing functionality that provides developers with fine-grained, real-time data control. expressor now also includes several connectivity enhancements, including support for Netezza NPS 5.0 and bi-directional connectivity with Netezza via ODBC.

Posted July 06, 2010

EnterpriseDB, a supplier of PostgreSQL-based solutions, and Netezza Corporation, a provider of data warehouse and analytic appliances, has formed a new partnership intended to ease database migration projects. Under the agreement, Netezza will resell EnterpriseDB's Postgres Plus Advanced Server, which includes its Oracle Compatibility Layer, as Netezza Migrator. Migrator will be compatible with the Netezza TwinFin appliance.

Posted June 29, 2010

Netezza Corporation, a provider of data warehouse, analytic and monitoring appliances, and Composite Software, Inc., a data virtualization middleware provider, have announced the Netezza Data Virtualizer to simplify, accelerate and optimize the integration of data stored across multiple Netezza appliances. Powered by Composite Software, the Netezza Data Virtualizer creates an integrated view of data that is physically distributed across multiple Netezza appliances and delivers query results to reporting and analytic applications while Netezza appliances continue to manage their data.

Posted June 29, 2010

EnterpriseDB, a supplier of PostgreSQL-based solutions, and Netezza Corporation, a provider of data warehouse and analytic appliances, announced a new partnership intended to ease database migration projects. Under the agreement, Netezza will resell EnterpriseDB's Postgres Plus Advanced Server, which includes its Oracle Compatibility Layer, as Netezza Migrator. Migrator will be compatible with the Netezza TwinFin appliance.

Posted June 28, 2010

The newest version of the Vertica Analytic Database is now commercially available worldwide. New features support new types of analytics, improve the way queries are executed in terms of better utilization of computing resources, and internationalize the release. "When you look at these things in combination, it really broadens the addressable market that is available to Vertica," David Menninger vice president of marketing, Vertica, tells 5 Minute Briefing. Vertica 4.0 is already delivering business benefits to some of the world's biggest financial services, communications, internet, healthcare and retail companies, according to the vendor. For example, customers who are tight on available computing resources are reporting Vertica 4.0 is helping them "do more with less" with a new workload manager that lets them manage complex mixed query workloads to best meet business priorities. Others who had no prior experience working with columnar databases are taking advantage of Vertica's new "load-and-query" data designer, which automatically generates optimized storage structures greatly simplifying development and tuning.

Posted June 08, 2010

In the midst of turbulent times, many successful businesses learned an important lesson: The closer IT works with the business, the better an organization can weather the storms that blow in. Thus, many savvy companies understand that the managers and professionals who oversee information technology and applications need to be well incentivized to stay on. At the same time, these professionals understand the need to develop expertise in business management and communications. Many companies are looking to information technology to provide an additional competitive edge, and see their Oracle enterprise systems as the cornerstone of this strategy. As a result, a survey finds that Oracle enterprise application managers and professionals appear to have weathered the economic storm. The survey, conducted among 334 members of the Oracle Applications Users Group (OAUG) by Unisphere Research, and sponsored by Motion International, finds an increase in the number of Oracle technology professionals who are near or surpassing the $100,000 mark in their base salaries.

Posted June 07, 2010

SAP and Sybase, Inc. have announced that SAP's subsidiary, SAP America, Inc., has signed a definitive merger agreement to acquire Sybase, in a transaction that will bring them together to enable companies to become better-run "unwired enterprises." The planned transaction is expected to close in July 2010, and, according to the companies, Sybase, based in Dublin, Calif., will be run as a standalone company under the name "Sybase an SAP company."

Posted May 26, 2010

Kore Technologies, a provider of enterprise integration and e-commerce web solutions for MultiValue and Microsoft SQL Server databases, is now a resale partner for Rocket Software's CorVu business intelligence (BI) and analytics products.

Posted May 26, 2010

Sybase reported financial results for the first quarter ended March 31, 2010. "We are off to a very good start this year," stated John Chen, chairman, CEO and president of Sybase, during a conference call last week. "We are very pleased to report our 10th consecutive record quarter. The highlights include historical first quarter highs in revenue, operating margin, earnings and cash flow. We also have double digit growth in total revenue as well as license growth and message revenue growth."

Posted April 29, 2010

In a presentation to analysts, customers, and the press at the Guggenheim Museum in New York last week, Oracle president Charles Phillips unveiled Oracle Enterprise Manager 11g which is intended to help customers maximize business agility and productivity by providing an integrated approach to IT management. "It's about finally trying to get control of this complex thing called IT — trying to manage the entire stack in a way that is different that is different than we have in the past. We are just now getting to the point in the evolution of the industry and in Oracle's strategy where that is now possible," Phillips said.

Posted April 27, 2010

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

Sponsors