Relational Query Performance Citibank also found that query performance against its large warehouse was a problem. Ramakrishnan felt that the problem could be solved through efficient indexing. Altavista search engine Query accelerators Ramakrishnan noted that all these approaches produced efficiencies in finding database rows. He thought that the query performance problem could be solved by finding columns through indexes. Not finding either product completely suitable, Citibank built and implemented its own column-oriented indexing approach through metadata.
Performance is quite impressive.
Citibank calls the capability its Hyperdimensional Indexing engine. End-User Capabilities Citibank offers its data warehousing end users a range of capabilities. Tools have been designed by vendors for use with databases, but not necessarily to exist cooperatively in a data warehouse environment. Recent Progress and Future Plans Going forward, Citibank is proceeding on two broad fronts. The first is integration between metadata and decision support tools.