ActiveCounts – Fast Database Counts at Your Fingertips

Counts inform us. When people use web applications, their experience is  substantially altered by the mere presence of counts. Think about the websites that you have visited recently, especially those that access databases. Shopping sites. Forums. Libraries. When you perform searches, some of those sites show you counts along the way. Others do not. There is a difference.

Get real-time counts as you drill down through millions or even billions of rows.

Many websites provide drill down counts as you navigate a product line. Imagine you are looking for a printer. As you drill down through types of printers and their features, you may see the count get smaller and smaller. These database counts are helpful in deciding whether to process further criteria. It is fairly easy for the web application to do this with a product line database. A product line may have a few thousand rows, and obtaining database counts from a few thousand rows is pretty fast. What if your database has hundreds of millions of rows? Relational databases cannot provide counts fast enough in that environment. Omnidex can.

Why ActiveCounts?

Real-time counts
Responds to search refinements
Results in milliseconds
Works on databases with millions or billions of rows

Omnidex is the fast, flexible and affordable solution that will make your database search faster and perform better.

Counts can be an interactive, visible part of any search

ActiveCounts allows you to present the available criteria at each step of the search, complete with real-time database counts, refined by the criteria entered so far. And even on hundreds of millions of rows, these drill down counts can be delivered in under a second.

To the application designer, this provides the opportunity for a wholly different design. Many applications today try to guide the user through the steps of a search in order to preserve performance. The criteria is collected, the relational database is queried, and then the results are displayed. This may preserve performance using those relational database systems, but it requires the user to think like an application, rather than letting the application respond to how the user thinks.

With ActiveCounts, the user chooses their own path through the data, seeing the available values appear at each step of the search, informed by counts along the way. This approach is similar to the way the user thinks, and the database counts allow them to see the ramifications of their choice before they even make it.

See ActiveCounts in action!