Do you need a Data Warehouse or Enterprise Data Warehouse (EDW) in your organization today? Its functional units, people, services, and other organizational assets support the vision and mission of an organization. An organization can have strategies, tactics, and operational activities that are performed to meet the overall vision and mission of the organization…
There’s no one-size-fits-all solution for a modern data platform, and there likely never will be with the proliferation of multiple public and private cloud environments, entrenched on-premises data centers, and the exponential rise in edge computing – data sources are multiplying almost at the rate of data itself. Today’s data platforms increasingly take a…
Part 2: You Need Composable Data and Analytics In my first blog on engineered decision intelligence, I shared information about what this concept means and why you need it, and then I elaborated on the Gartner recommendation for pairing decision intelligence tools with a common data fabric. But there was a second piece of…
Actian Vector is a vectorized columnar analytics database designed to deliver extreme performance with a high level of security. But who wouldn’t want analytics that are even faster and more secure? For those who do, the new Vector 6.2 release available on November 10, 2021 is a winner, continuing to push the limits of…
One of the main concerns of Ingres and Vector customers whose systems need to undergo a significant change, such as major version upgrades, OS migration, major software releases, increased volumes of usage, etc, is how to properly test the database under realistic conditions in a test environment. Some customers have heard of the Query,…
The previous blogs in this series discussed the top 5 pitfalls of traditional operational data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution. Below is a list of my Top 10 desirable benefits of an effective ODW: Current. Continuous data updates via “micro-batches” or streamed singleton updates throughout the day…
In the first part of this two-part article, we created the model. In this installment, we will create the UDF’s in database. We can convert the model to Python, and I used m2cgen to transpile the sklearn model to Python model I will be making 3 types of UDF’s, Python UDF JavaScript UDF Saving…
Recently in Avalanche, VectorH 6.0, and Vector 6.0, Actian introduced a capability for Scalar user-defined functions (UDF’s). This has given Avalanche, VectorH, and Vector a new dimension to run Machine Learning (ML) models in Python and JavaScript within database. More about UDF’s can be found in our documentation. Model creation is simple with so…
In this second of a three-part blog series (part 1), we'll explain how SQL execution in Actian Vector in Hadoop (VectorH) is much more functional and ready to run in an operational environment, and how the ability for VectorH to handle data updates efficiently can enable your production environment to stay current with the…
In this third and last part of the series on Actian Vector in Hadoop (VectorH), we will cover how the VectorH file format supports the performance and efficiency of our data analytics platform to accelerate business insights, as well as some of the other enterprise features that can help businesses move their Hadoop applications…
Actian VectorH 6 Enables User Defined Functions, Machine Learning, Semi-Structured Data Support, and Enhancement of Workload Management Capabilities. Actian is pleased to announce the availability of Actian VectorH 6. This release includes new features, including User Defined Functions (UDFs), JSON Support, and Workload Management. This post provides an overview of some features that have…
Imagine what you could do if you actually understood your customers’ buying behavior. You could predict future purchases, identify cross-sell and upsell opportunities and personalize messaging that would resonate and drive the behavior you desire. Instead of taking broad strokes to your marketing campaigns, you could focus on specific opportunities and pursue them more…
With increasing competition in the marketplace and shrinking profit margins in many industries, companies are increasing looking for ways to achieve higher levels of business process optimization throughout their supply chain. This isn’t a new challenge, but it is one that has recently taken on greater importance with the acceleration of the speed of…