Have you found that some vendors market their product as a multidimensional index tool when, in fact, it is an inverted index? What are the costs associated with an inverted index (space to store the indexes)? Can you summarize how inverted indexes really work? If my organization were to implement a tool based on inverted indexes (DISC Omnidex or Bloodhounds DBAssit), what are realistic time frames for ROI and user availability?
Sid Adelman's Answer: ROI is rarely a function of the architecture of the database or the indexing scheme. ROI is dependent on delivering useful function to the end users, function that translates to increased revenue, lower cost, better internal processes, higher quality, etc. By the same token, availability (percentage of time the system is working - as determined by the users - during scheduled hours) is impacted by the capabilities of the operating system, the RDBMS, the backup and recovery procedures, the cleverness of your DBA and technical staff and a hardware configuration designed for high availability.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access