Adding Smarts to Real-Time Queries

Thursday Mar 2nd 2006 by DatabaseJournal.com Staff
Share:

EIT Toolkit: Teksouth's new offering automatically routes DB queries from your BI system for the quickest response.

[From Enterprise IT Planet]

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.

The article continues at http://www.enterpriseitplanet.com/networking/features/article.php/3588866

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved