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

Rockset, a real-time database built for the cloud, is ushering in new growth with several industry partnerships and continued product innovation. The company is entering several new partnerships and implementing technology integrations, including adding DynamoDB to search and analyze database change streams, Apache Kafka to analyze raw events in real time, and Tableau to visualize live data from a variety of sources.

Posted February 03, 2020

Quantum Corporation is entering into an agreement with Western Digital Technologies to acquire its ActiveScale object storage business. By acquiring the ActiveScale product line and talent, object storage software and erasure coding technology is now available in Quantum's portfolio and enables the company to expand in the object storage market. 

Posted February 03, 2020

StreamSets, provider of a DataOps platform, is supporting and integrating its platform for Microsoft's recently announced SQL Server 2019 Big Data Clusters. With this integration, SQL users are empowered to design and operationalize data pipelines for big data workloads without the complexities of coding for big data systems.

Posted January 30, 2020

Yellowbrick Data, provider of a modern analytical data warehouse built for the hybrid cloud, is partnering with MicroStrategy, enabling a new integration of a Yellowbrick Data warehouse and MicroStrategy 2020, MicroStrategy's flagship enterprise analytics platform.

Posted January 30, 2020

The Aerospace Systems Company, a division of Kawasaki Heavy Industries (KHI) and Japanese manufacturer of aircraft, has chosen the SAP S/4HANA Manufacturing solution for production engineering and operations. SAP S/4HANA Manufacturing for production engineering and operations can help KHI streamline processes by centrally managing design and manufacturing bills of material (BOMs) for aircraft as well as reflect changes at the design stage.

Posted January 29, 2020

Aisera, a provider of an AI driven service experience solution, is launching its debut product that will deliver transformational AI to corporations looking for the best in self-service experience solutions.

Posted January 28, 2020

The big data space is constantly in flux. New and emerging technologies plan to disrupt reliable legacy solutions while others hope to work in harmony with tools in the market. What are the next explosive trends for 2020?

Posted January 03, 2020

In 2019 artificial intelligence and machine learning continued its upward trajectory in the market, promising to change the future as we know it. To help support data management processes and decision making, artificial and augmented intelligence is being infused into products and services. Machine learning sits in the center of all AI conversations, as combining machine learning with AI and cognitive technologies can make it even more effective in processing large volumes of information. Both technologies can lead to automation of tasks inside and outside the enterprise-another subject that promises to make waves in the future.  Here, executives of leading companies offer 10 predictions for what's ahead in 2020.

Posted December 20, 2019

Oracle OpenWorld, which has for many years been held in San Francisco during the month of September or October, is moving to Las Vegas. "Oracle is excited to offer a modern, state-of-the-art experience for attendees at Oracle OpenWorld and Code One 2020 in Las Vegas," an Oracle spokesperson said in a written statement. "The city and its vast amenities are tailor-made for hosting large-scale events, and we look forward to bringing the industry's most comprehensive technology and developer conference to America's premier hospitality destination."

Posted December 11, 2019

Sixgill, LLC, a provider of data automation and authenticity products and services, is offering Sixgill Integrity 1.0 for blockchain-enforced data authenticity. Sixgill Integrity fulfills the critical enterprise need for end-to-end, real-time data authenticity assurance with robust capabilities to monitor and guarantee the veracity of any data stream, including today's sensors emitting time-series data in any form.

Posted December 09, 2019

Oracle has announced that Oracle Cloud has joined the IO500. "Our HPC file server solution opens up tremendous opportunities for manufacturing, energy, and other R&D-heavy customers," said Vinay Kumar, vice president, product management, Oracle Cloud Infrastructure. "Customers can tackle their toughest workloads at some of the best price-performance ratios in the market."

Posted December 04, 2019

What exactly is a data architecture? As the Zachman Framework exposed long ago, different people look for different kinds of details and documentation to answer fundamental questions about an enterprise's architecture. Someone involved with infrastructure will need to understand the tools used and the methods employed to move data and to be clear on concepts about how security will be enforced. But these aspects are only initial parts of the overall architecture, and as such, a simple diagram of tools used is incomplete and insufficient for a comprehensive view of data architecture.

Posted December 01, 2019

If you have been around the IT industry for as long as I have, you have seen technologies and ideas come and go—and sometimes even come back again. This is surely the case with the "new" products that call themselves data catalogs.

Posted December 01, 2019

Alluxio, the developer of open source cloud data orchestration software, is providing a range of cloud offerings and integrations with the latest Alluxio version 2.1, as well as strengthening of partnerships with Amazon AWS and Google Cloud.

Posted November 11, 2019

Redgate is releasing a major upgrade for its popular tool, SQL Prompt, helping developers increase the speed and quality of their SQL coding and take advantage of the most recent improvements in SQL Server.

Posted November 11, 2019

Rockset, the serverless search and Analytics Company that enables real-time SQL on NoSQL data, is introducing the capability to build interactive, live Tableau dashboards on NoSQL data, without requiring users to write a single line of code.

Posted November 08, 2019

The data warehouse and data lake each solve different business problems and impose their own unique challenges.Organizations shouldn't write off data warehouses—as they evolve, they are taking on new roles in digital enterprises. Data lakes may add a great deal of flexibility to an enterprise data strategy, but they are supported by fast-breaking technologies that require constant vigilance.

Posted November 06, 2019

Dotscience is offering new platform advancements that make deploying and monitoring machine learning models on Kubernetes clusters simple and accessible to data scientists. New Dotscience Deploy and Monitor features dramatically simplify the act of deploying ML models to Kubernetes and setting up monitoring dashboards for the deployed models with cloud-native tools Prometheus and Grafana.

Posted November 01, 2019

Every organization needs a data warehouse. A data warehouse has never been a one-size-fits-all kind of solution. Variations exist and should be accepted.

Posted October 31, 2019

Truly, the speed and performance of your production database systems encompasses a wide range of parameters and decisions that are made well before implementation. DBAs need to understand the options available, the factors that impact performance and development with each DBMS option, and work to keep the IT organization up-to-speed and educated on all of the available choices.

Posted October 31, 2019

There is a sea change underway in enterprise architecture. Just a few years ago, enterprise administrators were fearful of the security implications of trusting an outside provider to protect their data assets. Although security is still a cloud concern—one which predominates at the time of cloud migration, and even grows stronger post-implementation—the use of cloud platforms has gained widespread acceptance.

Posted October 31, 2019

Oracle has identified a need for "augmented" analytics, leveraging machine learning and AI throughout the analytics process to help drive up the impact and value of data, and enable knowledge workers to uncover more insights. Recently, Bruno Aziza, group VP, Oracle Analytics, described this new phase in analytics, the role that cloud plays in making it possible, and what the capabilities will enable for customers.

Posted October 16, 2019

The cloud, ethics in artificial intelligence, privacy, and compliance were some of the topics that attendees were concerned about at Strata Data NY as data professionals converged at the Jacob Javits Center in New York City from September 24 - 26.

Posted October 15, 2019

Advanced analytics software provider Mode today announced the availability of its first instant, responsive data engine, Helix. Helix creates the dual backbone between modern business intelligence and interactive data science. By combining these workflows, data scientists no longer have to choose between shipping fast, one-off answers and building dashboards for broader coverage.

Posted October 14, 2019

GoodData, provider of end-to-end analytics solutions, announced it is now leveraging Amazon Redshift, a cloud data warehouse by Amazon Web Services (AWS). In addition, the combination of GoodData and Amazon Redshift can change the way in which enterprise and product teams are making business decisions. Namely, the trend toward integrating analytics into business applications so every customer, partner, and team member becomes empowered with data and insights at the point of work.

Posted October 11, 2019

DataStax, the company behind a database built on Apache Cassandra, is opening early access to the DataStax Change Data Capture (CDC) Connector for Apache Kafka. The DataStax CDC Connector for Apache Kafka gives developers bidirectional data movement between DataStax, Cassandra, and Kafka clusters. CDC is designed to capture and forward insert, update, and delete activity applied to tables (column families).

Posted October 10, 2019

Collibra, the Data Intelligence company, is making platform-wide upgrades to improve access to critical data and hasten time to insight. The new release introduces machine learning enhancements to Collibra Catalog and marks the availability of Collibra Privacy & Risk, a sustainable approach to compliance with modules for CCPA and GDPR.

Posted October 09, 2019

Has the meaning of big data changed? Many agree that data no longer has to be "big" to meet today's evolving requirements. In particular, open source and cloud tools and platforms have brought data-driven sensibilities into organizations that previously did not have such expertise, making big data more accessible.

Posted September 26, 2019

The big cloud vendors tout many reasons for running IT infrastructure in the cloud. A very prominent benefit is "accelerated innovation and delivery." That's a powerful selling point because every IT manager I have ever known wants to deliver better results, faster, and at lower cost. However, it seems that the less IT managers know about doing actual hands-on IT work, the more demanding they are.

Posted September 26, 2019

Yellowbrick Data, a provider of next-generation enterprise data warehousing, is releasing the Yellowbrick Cloud Data Warehouse and the Yellowbrick Cloud Disaster Recovery (Cloud DR) service. The Yellowbrick Cloud Data Warehouse has been operating in enterprise production environments since early 2019, and both new products leverage the power of the Yellowbrick Data Warehouse.

Posted September 25, 2019

Splunk, a provider of the data-to-everything platform, is making several advancements to pricing, partner, and investment initiatives designed to help customers make smarter business decisions.

Posted September 25, 2019

Although adopting advanced analytics is on the radar for most organizations these days, it is important to understand some of the problems that can occur as you implement analytics projects. Perhaps the most important obstacle to overcome is ensuring buy-in from your organization's leaders.

Posted September 16, 2019

In order to protect your organization, it is critical to watch over the elements that have been built, keep processes running, and be on top of change. Spend the time and resources necessary to properly maintain the solutions for which you are responsible. The amount spent in such endeavors will be less time than that spent trying to play catch up on too many changes after bad things have resulted.

Posted September 03, 2019

We've reached the point where hybrid cloud arrangements have become commonplace in enterprises, and with this trend come implications for databases and data management. The rise of both hybrid and multi-cloud platforms means data needs to be managed in new ways, industry experts point out. And, there are lingering questions about which data should go into the cloud, and which should stay on-premise.

Posted August 29, 2019

In previous articles, we looked at creating and managing Oracle Cloud Infrastructure (OCI) database and compute instances through the web UI. The UI is ideal for a new user and occasional management of a cloud environment. When a cloud administrator is managing and automating dozens or hundreds of instances, manually clicking through the UI becomes untenable. Oracle supports and maintains a number of developer tools to solve this problem.

Posted August 21, 2019

Franz Inc., an early adopter of Artificial Intelligence (AI) and provider of Semantic Graph Database technology for Knowledge Graph Solutions, is now supporting Shapes Constraint Language (SHACL), a World Wide Web Consortium (W3C) specification for validating graph-based data against a set of conditions.

Posted August 15, 2019

Social media, the Internet of Things, demands for mobile access, and real-time insights are just some of the factors that have increased the pressure on organizations to change how data is managed. And as a result there have never been so many data management choices to deal with it all.

Posted August 14, 2019

An effective approach to processing and transforming large datasets is likely comprised of multiple steps. The large data will likely be split apart into several smaller sets, maybe even in a couple of differing fashions with a common and understandable theme. But there should not be too many split-apart variants; rather, as with the three bears, it should be just the right number of smaller datasets. And then, similar to solving a Rubik's Cube, a twist or two at the very end brings all the new and old datapoints together in a complete and organized fashion.

Posted August 07, 2019

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when it comes to optimizing and tuning your SQL Server database performance.

Posted August 07, 2019

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
45
46

Sponsors