Analytics vendors show there’s still innovation in BI

Managing data isn’t as glamorous as many of the glitzy Web 2.0 apps on display at the Demo Fall 2008 conference in San Diego, but it’s what keeps businesses running. Enterprise applications to speed databases, manage unstructured data, and handle BI queries on a massive scale made their debut this week, and at first blush they look positive. Of course, all will have to stand the rigor of real-world use and testing.

Business intelligence meets the cloud

Lately, BI vendors have been more likely to make news by being acquired than for technical innovation, so it’s refreshing to come across a BI vendor that might actually be doing something different.

Quantivo combines what it calls an “affinity” database with a cloud-based infrastructure hosted by … well, the company won’t say, but Amazon is a reasonable guess. CEO Brian Kelly, an alum of Oracle and Sybase, says Quantivo is designed to recognize patterns and index relationships, rather than looking at data in a conventional row and column configuration.

One early customer, he says, was a retailer that exported some 2 billion records to Quantivo, which was able to get the customer up and running in less than a week. Kelly says a significant benefit of the product is its ability to recognize relationships within structured data. One example: drilling down into retail data to get a sense of which customers that have bought relatively inexpensive plumbing equipment are likely to purchase pricey items like counters or cabinets.

It’s easy to make claims about business intelligence, and Quantivo is making some big ones. If it lives up to its founders’ hopes, the young company has a chance to make a mark in a market that badly needs some excitement.

Structured data search meets the search box

Much effort has been spent on making unstructured data — such as the content of PowerPoints, call center logs, and PDFs — available for analysis in structured, database-oriented BI tools. Radiant Logic has inverted that approach to make structured data available through the ultimate unstructured query tool: a search box.

Its Virtual Context Server analyzes various databases, applications, and other structured data sources and generates the relationships of meaning among the data — that is, its semantics. IT analysts can modify and create their own semantics for data as well. The result: natural language text that users can search for, bringing that structured data to the fore in an unstructured search. Thus, an intranet search for a company will not only bring back the company’s contact information from a CRM database, but also the current orders and payment history for that company from the ERP system, notes Michel Prompt, Radiant’s CEO.

IT can also set access rules to the data, so database information such as pricing isn’t available to just anyone who does a search. VCS also can be set up to let users correct information they get in their search results, and either update the source database or have the change stored in VCS so it is applied to future searches as well.

Unclogging the database

Here’s a situation that should resonate with experienced database users: Every morning a cadre of dispatchers log in to a company database and prepare to dispatch trucks and drivers on their way. The problem: With a large group of users making calls to similar tables or objects, the database bogs down at the worst possible time.

Eric Ruck, a long-time consultant and now CTO of Tetrabase, says his young company has a solution. Tetrabase SDT is an accelerator that improves the performance of installed databases. Although the product is compatible with all major flavors of databases, at this early point it works best with Microsoft’s SQL server, says Ruck.

Simply put, Tetrabase adds a layer of management intelligence. Once administrators spot a problem (like the database bogging down every morning) they can use Tetrabase to find a solution. To make a complicated example simple, the trucking company’s database needed to identify the data dispatchers were calling up each morning (usually orders tagged for that day) and load it before the dispatchers punched in.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now