Analytics

OpenText Analytics Database: The ELT Advantage

Understand how OpenText Analytics Database (Vertica) revolutionizes data management by enhancing the ELT process, offering superior speed, scalability, and analytical power.

August 9, 2024 3 minute read
What is AI-powered analytics software?

What is AI-powered analytics software?

Artificial intelligence (AI) and analytics, individually, topped the digital agenda for companies in 2018 according to CIO magazine. The publication noted that the intersection of…

8 minute read

Idea to Insight in 30 days

Idea to Insight in 30 days

In an article published this year by Steven Levy, “Inside Amazon’s Artificial Intelligence Flywheel”, we learned how Amazon took a “leap of faith” in using…

3 minute read

Why drones are revolutionizing asset inspection in oil and gas

Why drones are revolutionizing asset inspection in oil and gas

In my previous blog, I looked at operational excellence in oil and gas. In its Oil and Gas Trends 2018-19, PwC suggests that companies should ‘double…

5 minute read

A deeper dive into intelligent recommendations

A deeper dive into intelligent recommendations

Intelligent recommendations, or recommendation engines as they are also called, are everywhere. As digital consumers, we experience them when we buy merchandise on Amazon, pick…

5 minute read

If I receive one more irrelevant voucher…

If I receive one more irrelevant voucher…

It seems that every week companies are trying to secure my loyalty with great discounts and vouchers. They would be great if they reflected my…

6 minute read

The hidden message in reams of text

The hidden message in reams of text

Excellence may be its own reward, but we consider recognition by one of the world’s most authoritative reviewers high praise indeed. That’s why we at…

5 minute read

Insert Spaces Into a Character String: Quick Tip

Insert Spaces Into a Character String: Quick Tip

In many SQL relational database you will have to use the RPAD function to insert spaces into a character string. That also works in Vertica….

1 minute read

Release 16 EP5 gives Magellan more text mining power and better user experience

Release 16 EP5 gives Magellan more text mining power and better user experience

Analytics are no longer just a matter of “crunching the numbers” in a database or spreadsheet. In fact, by some estimates nearly 80% of all…

5 minute read

Display View Column Data Types: Quick Tip

Display View Column Data Types: Quick Tip

Like table columns, view columns also have a data type. You can display the data types of view columns by querying the VIEW_COLUMNS system table….

1 minute read

AI-powered analytics to drive operational excellence for oil and gas

AI-powered analytics to drive operational excellence for oil and gas

In a previous blog, I looked at how effective content management is an important factor driving operational excellence for oil and gas companies. Your people…

5 minute read

AI – Four Key Ingredients

AI – Four Key Ingredients

Artificial intelligence (AI) is the great hope of software today: It can do everything. At OpenText, we have developed a low cost, easy to use…

4 minute read

Find Which Tables Have a Particular Column Name: Quick Tip

Find Which Tables Have a Particular Column Name: Quick Tip

Your Vertica database probably contains hundreds, if not thousands, of tables. Trying to remember which tables contain a certain column can be a daunting task….

1 minute read

Stay in the loop!

Get our most popular content delivered monthly to your inbox.

Sign up