SHARE

Adding Smarts to Real-Time Queries

To improve data query performance, many DBAs implement data caches–summarized and/or specifically extracted data tables that are periodically refreshed from the raw transactional information–that allow BI analysts to receive quicker reponses to their queries than they would if they were forced to go directly to the main transactional DBs themselves. A potential problem with this […]

Written By

Dan Ragle

Mar 3, 2006

Datamation content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More

To improve data query performance, many DBAs implement
data caches–summarized and/or specifically extracted data
tables that are periodically refreshed from the raw transactional
information–that allow BI analysts to receive quicker reponses
to their queries than they would if they were forced to go
directly to the main transactional DBs themselves. A potential
problem with this approach, however, is deciding what data to
cache, and then having to pre-define selected queries for the
analysts that will run properly from that cached data.

A new offering from Teksouth Corporation, however, seeks
to add intelligence to the data cache selection and usage
process. Planted between your BI toolset (and connecting to
it via OLEDB) and your data caches and DBs, their EntelliCache
software automatically analyzes the queries delivered from the
BI application and decides on the fly which queries should be
delivered from the data caches and which should go direct to
the raw transactional stores. The result is that BI analysts
are free to create queries in any way they desire; and the
vendor notes that typically 80% of these queries still end
up at the data caches anyway. And a future version of EntelliCache
is expected to be initially setup without a data cache at all
in a special “learning mode” that will enable it to determine
the data that should be cached and how often it should be
refreshed.

Several other new product offerings also made their debut in
this week’s
Enterprise IT Planet Product Guide
briefings. TraceSecurity launched their SiteAssure product
portfolio targeted primarily to financial institutions, which
offers both anti-phishing components (free to both consumers
and organizations) and two-factor authentication capabilities;
Interop Systems introduced their Interop Secure Shell, specifically
for UNIX-ified Windows servers; and Raritan debuted their
CommandCenter NOC appliance line, offering both performance
monitoring and vulnerability scanning for network servers and
devices.

And in our featured online resource: Do you know how long
the average SMTP transaction is taking on the Internet right now?
MX ToolBox does, and they’re willing to share their knowledge.

This article was first published on EnterpriseITPlanet.com.

Huawei’s AI Update: Things Are Moving Faster Than We Think

FEATURE | By Rob Enderle,
December 04, 2020
Keeping Machine Learning Algorithms Honest in the ‘Ethics-First’ Era

ARTIFICIAL INTELLIGENCE | By Guest Author,
November 18, 2020
Key Trends in Chatbots and RPA

FEATURE | By Guest Author,
November 10, 2020
Top 10 AIOps Companies

FEATURE | By Samuel Greengard,
November 05, 2020
What is Text Analysis?

ARTIFICIAL INTELLIGENCE | By Guest Author,
November 02, 2020
How Intel’s Work With Autonomous Cars Could Redefine General Purpose AI

ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 29, 2020
Dell Technologies World: Weaving Together Human And Machine Interaction For AI And Robotics

ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 23, 2020
The Super Moderator, or How IBM Project Debater Could Save Social Media

FEATURE | By Rob Enderle,
October 16, 2020
Top 10 Chatbot Platforms

FEATURE | By Cynthia Harvey,
October 07, 2020
Finding a Career Path in AI

ARTIFICIAL INTELLIGENCE | By Guest Author,
October 05, 2020
CIOs Discuss the Promise of AI and Data Science

FEATURE | By Guest Author,
September 25, 2020
Microsoft Is Building An AI Product That Could Predict The Future

FEATURE | By Rob Enderle,
September 25, 2020
Top 10 Machine Learning Companies 2020

FEATURE | By Cynthia Harvey,
September 22, 2020
NVIDIA and ARM: Massively Changing The AI Landscape

ARTIFICIAL INTELLIGENCE | By Rob Enderle,
September 18, 2020
Continuous Intelligence: Expert Discussion [Video and Podcast]

ARTIFICIAL INTELLIGENCE | By James Maguire,
September 14, 2020
Artificial Intelligence: Governance and Ethics [Video]

ARTIFICIAL INTELLIGENCE | By James Maguire,
September 13, 2020
IBM Watson At The US Open: Showcasing The Power Of A Mature Enterprise-Class AI

FEATURE | By Rob Enderle,
September 11, 2020
Artificial Intelligence: Perception vs. Reality

FEATURE | By James Maguire,
September 09, 2020
Anticipating The Coming Wave Of AI Enhanced PCs

FEATURE | By Rob Enderle,
September 05, 2020
The Critical Nature Of IBM’s NLP (Natural Language Processing) Effort

ARTIFICIAL INTELLIGENCE | By Rob Enderle,
August 14, 2020

SEE ALL
ARTICLES

Adding Smarts to Real-Time Queries

Dan Ragle

Recommended for you...

Company

Categories

Adding Smarts to Real-Time Queries

RELATED NEWS AND ANALYSIS

Dan Ragle

Recommended for you...

Company

Categories