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

According to Accenture's ninth annual Cost of Cybercrime study, the number of cyberattacks continues to rise and take more time to resolve. Organizations participating in the study saw an average of 145 attacks in 2018, up from 130 in 2017. The good news in the report was that prioritizing technologies to improve cybersecurity protection can reduce the consequences of attacks and "unlock future economic value as higher levels of trust encourage more business from customers."

Posted June 17, 2020

Organizations are increasingly turning to cloud data warehouses for advanced analytics and data visualizations. Solutions like Snowflake, Amazon Redshift, Google BigQuery, and more provide immediate value with secure and easy access to any data with near-infinite scalability. However, the convenience of having all of that data accessible from one platform makes full transparency and control essential.

Posted June 12, 2020

Modernization is driving many of today's enterprise data strategies—and cloud stands out as the primary vehicle for attaining this modernization. However, many enterprises are struggling with data quality issues, as well as integrating cloud-based and on-premise data.

Posted June 10, 2020

Here's one big advantage to moving to Microsoft Azure SQL Database—you never have to patch. That's all well and good, but most of the SQL Server installed license base is still on-premise. If you're in this category, then it is essential that you keep up with patching and security fixes regularly. The information in this article is the sort that experienced SQL Server DBAs keep close at hand. So, let's take a few minutes to walk through the details of how to do that.

Posted June 10, 2020

Today, there is a constantly evolving list of data management issues that organizations are contending with. In addition to pressures of exploding data volumes, there is urgent demand for real-time data-driven insights as well as more widespread data access. Expanding regulatory mandates also demand greater data quality and governance, as do cybersecurity threats. Whether cloud-based or on-premise and open source or proprietary, there are many options for data management and analytics. Spanning the spectrum of well-established and cutting edge, the DBTA 100 list recognizes companies that are innovating and preparing for the future.

Posted June 10, 2020

Matillion, a provider of data transformation for cloud data warehouses (CDWs), and HVR are releasing a joint solution that enables real-time data replication and data transformation for the cloud. Ideal for organizations looking to execute digital transformation and cloud data warehouse modernization strategies, the joint solution combines HVR's real-time Change Data Capture (CDC) with Matillion's data transformation capabilities.

Posted June 10, 2020

New approaches are available to modernize, streamline, and accelerate data management processes. It is critical to stay up-to-date with the latest ways to extract value from data with a modern data strategy. At Data Summit Connect, a free 3-day series of data-focused webinars, Seth Earley, CEO, Earley Information Science, and Ralph Aloe, director, Enterprise Information Management, Prudential Financial, offered strategies for smarter data management in a session, titled "Winning With A Modern Data Strategy."

Posted June 10, 2020

The starting point in developing and launching an enterprise data and analytics strategy is to understand the interrelationships that are necessary to deliver analytics capabilities. John O'Brien, principal advisor and CEO, Radiant Advisors, held a workshop titled, "Build An Actionable Roadmap For Enterprise Data And Analytics" during Data Summit Connect.

Posted June 08, 2020

Cutting-edge startups are constantly emerging to address new challenges and problems in ways never thought possible. Many of these young, innovative companies have fresh approaches that tap into blockchain, quantum computing, advanced analytics, AI, DevOps methodologies, containerization, and data security advancements. To shine a spotlight on some of the ways innovation in IT is being reflected today, here, DBTA presents 28 companies we think are worth watching in 2020.

Posted June 04, 2020

COVID-19 has had a dramatic impact on organizations of all types. Recently, John Pocknell of Quest Software, talked with DBTA about trends in database management before and after the new crisis-forced shift to remote work and how DBAs' roles are being affected. As part of his responsibilities as senior market strategist at Quest, Pocknell looks at emerging challenges and speaks to customers to understand where future problems and opportunities may lie ahead to help map the company's database solutions to those needs. Before the crisis, DBA roles were undergoing radical change and that is only accelerating now, Pocknell says.

Posted June 03, 2020

Even before the IT elements of data optimization begin, aligning organizational culture around a data-driven mindset will be a major challenge. Making the case for data optimization is important. Even before the IT elements of data optimization begin, aligning organizational culture around a data-driven mindset will be a major challenge. Making the case for data optimization is important.

Posted June 01, 2020

As companies have evolved toward digital business models and undertaken digital transformation initiatives, they have increasingly faced two challenges. First, the data they need to drive their real-time business processes is typically spread across multiple, siloed datastores. Second, their existing applications often cannot scale to address the increase in end-user demands for real-time engagement.

Posted May 28, 2020

A combination of factors is heightening the need for high-quality, well-governed data. These include the need for trustworthy data to support AI and machine learning initiatives, new data privacy and data management regulations, and the appreciation of good data as the fuel for better decision making.

Posted May 28, 2020

Datrium, a provider of cloud-native disaster recovery with ransomware protection solutions, has announced that Xello Australia is the newest reseller and first Melbourne-based company to join its growing Global Partner Network in Australia and New Zealand (ANZ).

Posted May 27, 2020

Kobelco Systems Corporation, an IT services provider based in Japan, is implementing SAP Fieldglass solutions to help transform the management of its skilled external workforce. To help increase productivity and reduce risk, Kobelco Systems needed a solution that provided visibility into all external workers and enabled active management of this key workforce segment. The company implemented SAP Fieldglass solutions in late 2019 to satisfy these requirements.

Posted May 27, 2020

Business and IT have, in the past, used times of crisis to adapt and transform themselves for the better. While the COVID-19 pandemic has undeniably had a devastating effect on business, and life itself, it may also be a catalyst for change, compelling organizations to rethink their long-term operations and spending amidst the short-term crisis brought on by the health emergency. Industry leaders recently discussed what "the new normal" may look like.

Posted May 27, 2020

Even the most ambitious data analytics initiatives tend to get buried by the 80/20 rule—with data analysts or scientists only able to devote 20% of their time to actual business analysis, while the rest is spent simply finding, cleansing, and organizing data. This is unsustainable, as the pressure to deliver insights in a rapid manner is increasing.

Posted May 21, 2020

DevOps, DataOps, AI, and containers all lead to one important innovation for enterprises seeking to be more data-driven—and that is greater automation. Data-driven enterprises cannot function if data resources and applications are in any way being manually administered, deployed, remediated, or upgraded.

Posted May 18, 2020

One creates the potential for some interesting anomalies when building a star schema wherein the fact table contains future-dated metrics and any of the dimensions are Type 2.  A Type 2 dimension tracks changes to the data items contained within it. Effectively, each dimension contains a surrogate key, a natural key with a start and stop date, and additional descriptor columns. If any of the descriptor column values change, the existing dimension row has the stop date populated while a new row is inserted with the same natural key, new start date, and new descriptor values. 

Posted May 13, 2020

What more companies need today is a "data lab" to create ideas from data and a "data factory" to turn those ideas into products. Google, Amazon, and other data-driven giants already work like this. So should companies outside of technology. 

Posted May 13, 2020

MemSQL, the No-Limits Database for operational analytics and cloud-native applications, is receiving $50 million in new capital after signing a debt facility agreement with Hercules Capital, the largest non-bank venture debt provider with more than $2.4 billion in total assets, who served as underwriter for the financing.

Posted May 11, 2020

Cloudera, the enterprise data cloud company, is releasing an expanded set of production machine learning capabilities for MLOps, now available in Cloudera Machine Learning (CML). Organizations can manage and secure the ML lifecycle for production machine learning with CML's new MLOps features and Cloudera SDX for models.

Posted May 06, 2020

Oracle Cloud Infrastructure-Government Cloud has achieved FedRAMP High Authorization. "Government customers rely on Oracle Cloud to run their most critical workloads. With FedRAMP High and Impact Level 5 authorizations, we are able to support the highest levels of security standards for unclassified workloads across local, state, and federal government, as well as the Department of Defense," said Scott Twaddle, vice president, Regulated Markets, Oracle Cloud Infrastructure.

Posted May 06, 2020

Yellowbrick Data, providing a data warehouse for hybrid cloud, and Next Pathway Inc., the Automated Cloud Migration company, are collaborating to accelerate the migration of complex on-prem workloads to the Yellowbrick Data hybrid cloud data warehouse.

Posted May 05, 2020

Dremio has announced the free availability of the Dremio AWS Edition, a self-service data lake engine highly optimized for Amazon Web Services (AWS) and available in AWS Marketplace. "Dremio brings interactive BI and data science to Amazon S3, and with our new AWS Edition we are dramatically lowering the cost per query and making data lake insights accessible to data consumers in organizations of any size," said Tomer Shiran, chief product officer, Dremio.

Posted May 05, 2020

VAST Data, a storage company, is releasing Version 3 of its Universal Storage architecture, introducing more than 20 new features - including support for Windows and MacOS applications, cloud data replication, and native encryption. These latest Universal Storage updates allow enterprises to now marry all-flash performance with archive economics and scale to enable mission-critical and data-intensive enterprise production environments to consolidate their workflows and bring the power of flash storage and fast access to all of their data.

Posted May 01, 2020

Kong Inc., a cloud connectivity company, is releasing a new open source tool called Insomnia Designer, offering a collaborative API design editor. Building on Insomnia Core, which Kong acquired in 2019, the software works natively with Insomnia's testing capabilities to accelerate the development, performance and stability of REST and GraphQL services, the communications backbone of the modern applications and services people rely on each day.

Posted April 30, 2020

Sigma Computing, a provider of cloud-native analytics and business intelligence (A&BI), is extending the power of Sigma to be used throughout the cloud data analytics stack.

Posted April 28, 2020

Swarm64, a provider of database acceleration solutions for the PostgreSQL open source database, is releasing Swarm64 DA 4.0, database acceleration software that extends PostgreSQL with the ability to analyze data orders of magnitude faster than usual.

Posted April 23, 2020

To get a full appreciation for the incredible pace of change in business technology, look at the past 6 years. In 2014, IDC published a report that said that, by 2020, the digital universe would contain nearly as many digital bits as there are stars in the universe, and the data we create and copy annually would reach 44 zettabytes, or 44 trillion gigabytes. Guess what? It's 2020. And it turns out IDC was correct in assuming that we were about to endure a data deluge.

Posted April 22, 2020

Circonus, provider of a machine data intelligence platform, has announced its Spring 2020 release. The release includes a Kubernetes monitoring solution that provides health-based alerting and horizontal pod auto-scaling, cloud monitoring, GCP Marketplace availability, performance improvements, and a more comprehensive Terraform integration. 

Posted April 21, 2020

VAST Data, a storage company, has raised $100 million in Series C funding which will be used to drive global expansion and accelerate the company's next phase of growth.

Posted April 16, 2020

Pepperdata, a provider of Analytics Stack Performance (ASP) solutions, is releasing Streaming Spotlight, a new product in Pepperdata's data analytics performance suite enabling Kafka integration. The suite is purpose-built for IT operations teams, giving them a single, comprehensive view of their analytics stack, both in the cloud and on premises.

Posted April 14, 2020

With $3.6 trillion in mergers and acquisitions completed in 2019 alone, M&A activity has been booming. However, a merger or acquisition isn't just a business decision and a business process. It's also a massive undertaking on the IT side, as you figure out how to migrate and integrate business applications and business data.

Posted April 08, 2020

The hype around DevOps and its potential to drive greater ROI across a wide range of enterprise operations increased substantially in the last decade. However, as these expectations carry into 2020, organizations will start to take a more sober approach to DevOps implementations. While DevOps was initially seen as a widespread solution to all sorts of enterprise IT issues, the implementation of DevOps approaches is now shaping up to become more strategic and focused, with much of the emphasis on how to maximize the ultimate return on investment.

Posted April 08, 2020

When it comes to DevOps, developers increasingly recognize databases to be code sets that require ongoing integration and deployment. They are "another code deployment which can and should be managed, tested, automated, and improved with the same robust, reliable methodologies applied to application code," according to the authors of a recent survey of 2,000 developers.

Posted April 08, 2020

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

Sponsors