Analytic Databases (Data Warehousing) - Further Information

Data warehouses have high ongoing support costs. Yotilla is a software product that automates much of this process.

An Enterprise Information Architecture can be viewed as the operating system of the Enterprise by means of which all applications are deployed and executed.

In a data-driven world, organisations need to be able to manage the corporate data resource intelligently and flexibly. A data fabric is the key enabler.

Denodo’s data virtualization capabilities enable data governance.

Teradata ClearScape Analytics refers to the analytic capabilities that are available within Teradata Vantage and that underpin all Vantage deployment options.

Teradata VantageCloud Lake is a cloud analytics and data platform that is designed to enable exploratory analysis and operate wherever your data exists.

This Bloor Market Update report is an overview of the current data warehouse database market, assessing the leading vendors.

Vertica is a unified analytics platform built on top of a SQL data warehouse.

The data warehouse market has been around for over three decades, but has undergone some rapid change in the last few years.

This report discusses Ingres NeXt, Actian’s flexible and comprehensive approach to digital transformation through database and application modernisation.

Teradata Vantage is a data warehousing and analytics solution with a variety of deployment options. This report examines it as a cloud solution specifically.

WhereScape provides a selection of software products that revolve around automating the full lifecycle of the data warehouse.

Federated master data management is a new and vital approach for trusted data in the modern enterprise.

This (Cloud) Data Management report compares platform-based approaches that support data integration to/from cloud-based deployments.

The basic concept behind the Talend Data Fabric is to allow you to collect, govern, transform, and share your data.

SOLIXCloud is a cloud data management platform from Solix Technologies that provides four primary solutions.

The Qlik Data Integration Platform is essentially a melding of the capabilities provided through the acquisitions of Podium Data and Attunity.

Oracle’s data management capabilities span the establishment of (cloud-based) data warehouses and data lakes.

The Intelligent Data Platform encompasses data integration, quality, governance, MDM, cataloguing, privacy, application integration, and more.

IBM Cloud Pak for Data places particular emphasis on deploying, developing and managing AI and machine learning models.

The Lumada DataOps Suite from Hitachi Vantara supports everything from ingestion through to analysis and dashboards.

Cloudera Data Platform offers data integration, data governance, data cataloguing and transformation capability but not data quality per se.

Ataccama ONE encompasses data integration, data cataloguing, data profiling and data quality, and both reference and master data management.

MarkLogic Data Hub is a fully cloud-native platform for data storage, integration, operationalisation and governance.

CloverDX describes its flagship product as an enterprise data management platform. In practice, its capabilities hew closer to data integration.

Matillion ETL is a cloud-native data integration tool. However, it is misnamed: it should really be Matillion ELT.

Fivetran is a fully managed cloud-native data integration solution that offers ELT technology with ongoing synchronisation.

Astera Centerprise is a data integration solution for environments with complex requirements, which can be extended with Astera ReportMiner and EDIConnect.

Actian DataConnect is a (data) integration offering the intent of which is to allow anyone to connect anything, anywhere, at any time.

SnapLogic's Intelligent Integration Platform supports both application integration and API integration as well as data integration.

This is Bloor's fourth Market Update in this space, which discusses the state of the graph database market as of early 2020.

AnzoGraph is a massively parallel graph database that runs on HDFS, NFS and other big data platforms and is ACID compliant.

Memgraph is an in-memory, ACID-compliant, property graph database written in C++ that supports openCypher.

When you want to query data that spans multiple sources, should you move said data or leave it in place?

This is a comparative analysis of products/vendors within the data warehouse and analytics platform space.

Actian Avalanche is a hybrid cloud/on-premises, columnar (with compression) data warehouse offering provided as a managed service when in the cloud.

Cazena is a single tenant massively parallel analytics platform primarily targeted at providing a data lake as a service.

The Cloudera Data Warehouse is based on the Cloudera Data Platform (CDP), which involves more than 30 open source technologies.

Exasol is a massively parallel, shared-nothing, columnar (with compression), in-memory data warehousing solution.

Greenplum is a massively parallel shared-nothing data warehouse based on a PostgreSQL kernel.

IBM Db2 Event Store is an in-memory database built on top of Apache Spark, intended to support both near real-time and deep analytics on historic data.

Starburst Data provides commercial support for Apache Presto as well as Starburst Enterprise.

Teradata Vantage effectively consists of a merger between what was previously simply Teradata Database, and Aster Analytics.

Vertica is a massively parallel, columnar database with advanced compression capabilities.

Yellowbrick Data Warehouse is a massively parallel data warehouse available on-premises as an appliance or there is a multi-cloud option.

Teradata Vantage is the only product that we are aware of that has all the 4D capabilities that you might need.

This paper explores “dimensional analytics”, by which we mean analytics that requires an understanding of the dimensions of time and space.

Limited, or no, technological capability with respect to AI is holding many companies back. This paper discusses how IBM Cloud Pak for Data can help.

This Market Update covers best-of-breed products for data warehouse automation (DWA) and data lake automation (DLA).

Infoworks automates all the steps required for Hadoop deployments from ingestion through to the generation of OLAP cubes and/or the creation of data science models.

The Magnitude Information Engine is based on what used to be Kalido, which was originally developed by Royal Dutch Shell as a means of speeding up the creation of its data warehouses.

Attunity Compose is a data warehouse automation solution that can automatically create analytics-ready data structures on both data warehouses and data lakes.

Trivadis started to develop what is now biGENiUS in 2005, consolidating its efforts in the data warehousing automation space resulting in the launch of biGENiUS in 2018.

This paper discusses TimeXtender Discovery Hub, an automated, centralised data management platform for Microsoft environments.

In this paper, we have identified the potential significance of a wide range of data-based technologies that impact on the move to a data-driven environment.

There are many SQL on Hadoop engines, but they are suited to different use cases: this report considers which engines are best for which sets of requirements.

This paper discusses the use of Hadoop-based appliances and specific features of the Teradata Appliance for Hadoop.

This paper discusses why data lakes need to be managed and the sorts of capabilities that are required to manage them.

This paper initially started as an investigation into comparative pricing for BI solutions and then evolved into a consideration of TCO for such environments.

We consider the relative merits of IBM DB2 with BLU Acceleration running on Power Systems as compared to HANA, Exadata and SQL Server on x86-based platforms.

An update on SAP's in-memory database

DB2 BLU doesn't just in-memory techniques but also L3 cache

There aspects of Kognitio and its offering that are sometimes misunderstood, so I thought I should clear some things up.

The basic theme of this paper is to provide a comprehensive comparison of IBM's and Oracle's offerings for large-scale traditional data warehousing environments.

In this paper we will describe some of the key analytic areas that are important to telecommunications companies and discuss the argument in favour of using third party analytic application providers.

In-memory processing can be used for a lot of different things within data warehousing

Sybase IQ is a column-based relational database that has been designed specifically for analytics and business intelligence applications.

It's not just big data, the EDW doesn't work even for structured environments

The basic theme of this paper is to provide a comprehensive comparison of IBM and Oracle's offerings for data warehousing and OLTP.

This paper defines what column-based relational databases do, and how, compared to traditional approaches.

The column-based approach advocated by Sybase will provide substantially better performance at lower cost than traditional approaches for analytical, reporting and data warehousing environments.

The primary value in analytic warehouses is in supporting complex and ad hoc analytic queries with sufficient performance to meet business needs and support service level agreements.

ParAccel is one of the more rapidly growing next generation vendors of analytic warehouses.

KMPG has put together an attractive option for organisations wishing to establish a short-term data mart for analytic purposes.

Infobright's high performance analytic data warehouse is designed to handle business-driven queries on large volumes of data - without IT intervention.

This paper covers small-scale analytic data marts and warehouses.

This paper covers large-scale analytic data marts and warehouses.

This paper covers medium-scale analytic data marts and warehouses.

This paper discusses enterprise data warehouses. By this we mean an analytic warehouse that also incorporates requirements to support such things as MDM and operational BI.

The column-based approach advocated by Sybase will provide substantially better performance at lower cost for analytical, reporting and data warehousing environments.

EXASolution is a massively parallel database management system especially developed for data warehousing applications.

High performance data warehouse technologies should be considered as a central component of Green IT strategies going forward.

We explore the differences between the various options now available from HP and explain how the company's partnership with Oracle strengthens its position.

In this paper we examine how Exadata works and where it will improve performance and how it compares to Dataupia.

HP and Oracle have recently announced the HP Oracle Database Machine.

The Sybase Analytic Appliance should be considered for both enterprise data warehouses and data marts.

Columns provide better performance at a lower cost with a smaller footprint: it is difficult to understand why any company seriously interested in query performance would not consider a column-based solution.

Sybase IQ can offer significant performance and total cost of ownership advantages over traditional products for query-intensive computing requirements.

We report on some of the education available at this Teradata User Group conference.

A management-level report from the successful Teradata User Group Conference in Ls Vegas, dealing with competitive issues.

The promise of Performance Management, Regulatory Compliance and SOA starts with Master Data Management. The MDM report is an in-depth review of the market, architectural approaches, vendor solutions and what to look for to meet your business needs.