facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
Actian Blog / Tag / Data Warehouse

Tagged Posts: Data Warehouse

Why Avalanche And DataConnect Are Better Together … Part 3
  • December 9, 2019

Why Avalanche and DataConnect are Better Together … Part 3

How Avalanche and DataConnect work together to deliver an end-to-end data management solution Migrating to a cloud data warehouse makes strategic sense in the modern context of cloud services and digital transformation. Operationally, connecting disparate data sources into your cloud data warehouse, managing ongoing change in your IT environment, and delivering on the promises…

Read More
It’s Back To The Future For Flat Files … Part Three
  • November 25, 2019

It’s Back to the Future for Flat Files … Part Three

Why embedded software application developers should dump flat files before they have to run dump on them I wrote an initial blog a few weeks ago on flat files and why embedded software application developers readily adopted them.  Then in the next blog, I covered why embedded developers are reluctant to use databases.  In…

Read More
It’s Back To The Future For Flat Files … Part Two
  • November 11, 2019

It’s Back to the Future for Flat Files … Part Two

Why Embedded Software Application Developers Loath Databases Last week I wrote an initial blog on flat files and why embedded software application developers readily adopted them.  Simply put, they’re always there – if you’ve got an Operating System that’s more than a bare-bones executive kernel it’s there and it’s free.  Also, flat files are…

Read More
Is Now The Right Time To Modernize Your Data Warehouse?
  • October 29, 2019

Is now the right time to modernize your data warehouse?

Technology is continually changing and determining the right time to upgrade and modernize can be tricky.  If you adopt new technology too soon, this may result in churn within your organization and the implementation of immature solutions that may not meet your needs.  If you wait too long, you miss out on market opportunities…

Read More
IPaaS Is Key To Accelerating Innovation
  • October 28, 2019

IPaaS is Key to Accelerating Innovation

Your business is evolving quickly with new competitors, changing customer needs, and the continuous refinement of both your business processes and product/service offerings to make the best of market opportunities.  Sustainable competitive advantage in this environment is built on three things – information, innovation, and agility. Your leaders understand this, which is why they…

Read More
Optimizing Cloud Compute And Data Storage For Data Analytics
  • October 24, 2019

Optimizing Cloud Compute and Data Storage for Data Analytics

When architecting your data warehouse solution, separating compute and data storage is extremely important for both operational sustainability and economic efficiency. Different things drive the technical needs for each of these, the capacity demands of the organization are different, and the best solution requires optimizing compute and data storage separately. Storage capacity is a…

Read More
Using DataConnect To Acquire, Prepare And Deliver Data To Avalanche
  • October 18, 2019

Using DataConnect to Acquire, Prepare and Deliver Data to Avalanche

Actian recently announced the availability of Avalanche on the Azure platform, extending the capabilities already available on AWS.  This announcement is exciting news for customers because it means greater flexibility and choice in selecting cloud operating environments as well as creating the opportunity for a multi-cloud deployment. Actian DataConnect enhances the capabilities of Avalanche…

Read More
What Is A Data Hub And Why Should You Care?
  • October 7, 2019

What Is a Data Hub and Why Should You Care?

If you are still using point-to-point integrations to move data through your IT environment, then you are spending too much money and missing the opportunities a modern data hub can provide. A data hub is a centralized service that connects all of your IT systems, whether they be Web applications, IoT devices, SaaS solutions,…

Read More
It’s Time For Data Historians To Become … History
  • September 17, 2019

It’s Time for Data Historians to Become … History

Why a modern time-series capable database can simplify yet enhance time-series data analysis There are many Operational Technology (OT) environments within manufacturing, oil and gas, engineering research, and countless other industries where complex equipment, machinery, and networks of sensors and devices generate time-series data.  These time-series streams range from sensor data representing Pressure, Volume…

Read More
If ETL Is Integration Hell, How Do I Avoid It And Go To Heaven?
  • August 22, 2019

If ETL Is Integration Hell, How Do I Avoid It and Go to Heaven?

Extract, Transform, and Load (ETL) is the process that has been used to share data between applications, transactional systems, and data warehouses for decades.  It essentially works like this; you define an integration, pull the data out of the source system, use some mapping and aggregation rules to transform the data into the format…

Read More
Does It Make Sense To Push All Your IoT Data To The Cloud?
  • August 19, 2019

Does It Make Sense to Push All Your IoT Data to the Cloud?

IoT devices create plenty of data – much more that you might think. When you multiply this amount of data by the number of devices installed in your company’s IT ecosystem, it is apparent IoT is a truly big data challenge. Two common questions IT staff and data management professionals have been asking during…

Read More
Should You Have Separate Document, Time-Series, NoSQL And SQL Databases Or Can A Single Database Support All Of These Data Types And Requirements?
  • July 31, 2019

Should You Have Separate Document, Time-Series, NoSQL and SQL Databases or Can a Single Database Support All of These Data Types and Requirements?

Managing and analyzing heterogeneous data is a challenge for most companies, which the oncoming wave of Edge Computing-generated datasets has only exacerbated. This challenge stems from a rather large “data-type mismatch” as well as how and where data has been incorporated into applications and business process. How did we arrive here? At one time,…

Read More
Managing Data Across Distributed Data Warehouses
  • July 17, 2019

Managing Data Across Distributed Data Warehouses

Data integration, like the digital-transformation initiatives it supports, is a journey and not a destination. Every company is somewhere on a path from the past to a desired state of future integration they’d like to achieve. If your company has existed for a number of years, then you likely have multiple databases, data marts…

Read More
How To Address Integration Challenges With The Proliferation Of IoT Devices
  • July 16, 2019

How to Address Integration Challenges with the Proliferation of IoT Devices

During the past few years, IoT devices have evolved from being a consumer novelty to a core part of next-generation IT ecosystems for businesses of all sizes. IoT devices (such as smart watches, fitbits, home sensors, RFID point of sale scanners, heartbeat monitors, etc) have become attractive and useful because of their inexpensive price…

Read More
Will Data Management In Operational Technology Finally Be Standardized?
  • July 11, 2019

Will Data Management in Operational Technology Finally Be Standardized?

The proliferation of Operational Technology (OT) within companies is increasing, which has led many to ask whether this will lead to standardization of how operational technology generated data is managed? The answer is “it’s complicated.” There is unlikely to be standardization of the data individual operational technology devices generate, but there will be new…

Read More
  • 1
  • 2