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…
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…
Data warehouses have been around for decades, and have established themselves as reliable reporting systems with consistent value. They have also evolved into data marts, specialized appliances and EDW variants to meet emerging needs, but all of these solutions have their drawbacks when it comes to meeting today’s business demands. Some of the common…
Introduction Today we're going to look at how to get started with Actian Vector, our high-performance in-memory analytics database, and Python, one of the most oft-used languages by data scientists in recent times. Using the techniques below, you'll be able to get started with Python using Vector ODBC and JDBC. (You'll be able to use…
The Challenge I have spent many years working with Actian's customers on database solutions and thought it'd be useful to discuss a recent customer experience at a large media company (I will call it "XYZCo"). This experience is similar to what I continue to see with other customers and the lessons learned apply to…
We’re pleased to announce that Actian Vector 5.0 Community Edition now includes support for Mac OS X via Docker. Over the last few years Mac OS X has become increasingly popular with Developers, as has Docker, the virtualization platform that allows you to bundle applications along with their native OS and run them in…
Hello World! We’ve been busy building some innovative features into the Actian Vector in Hadoop (VectorH) product and we would love to tell you all about them. So, the list of the features and innovations that we have done recently for VectorH… wait .. do you even know what VectorH is about? Yes, it’s…
Known as the Father of Vector Database Processing, Peter Boncz is the Senior Research Scientist at Centrum Wiskunde & Informatica (CWI), Professor at VU University Amsterdam, and Chief Technical Advisor to Actian Corporation, the first company to assemble an end-to-end big data analytics platform that runs natively on Hadoop. He architected two breakthrough database…
Telemetry is the automated communications process by which measurements are made and data collected at remote points. The data is then transmitted to receiving equipment for monitoring. The word ‘telemetry’ is derived from Greek roots: tele = remote, and metron = measure. Telemetry is not a new concept, that’s for sure. We’ve been watching…