Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Jul 9, 2003

Adaptive Addressing: a new type of data indexing technology

By DatabaseJournal.com Staff

CopperEye Ltd has invented a new type of data indexing technology. Called Adaptive Addressing, CopperEye claims that it can outperform conventional indexes such as B-Tree, BitMap and Hashed by up to one hundred (100) times. Adaptive Addressing technology can run stand-alone or can complement existing indexes.

It has been decades since anything significant happened in terms of new data indexing technology - so what's different here? CopperEye says that Adaptive Addressing is using new algorithms that reduce disk spindles without needing to exploit large amounts of memory resources - with up to 90% memory saving, 99% disk saving as well as being up to 100 times faster.

Adaptive Addressing is a general-purpose scalar disk-optimized index that is suited to the majority of data stored in commercial systems. The technology is not specific to relational databases and can apply to any data storage paradigm, such as object database, XML database or flat file systems.

Adaptive Addressing comes in the form of APIs that enables a developer to create new solutions. APIs are available for: C, JAVA and C++. An Oracle specific solution is also available.

Two key features of the technology are that it can be dynamically tuned to maximise insert or query performance and it is resource efficient - requiring only a small memory footprint and saving substantial disk space. Tuning characteristics include load bias, match, cache and block size.

Benefits to developers and database administrators include:

  • Reduce memory usage
  • Reduce disk usage
  • Proliferate indexes for better query performance with minimal loading performance impact
  • Implement efficient composite key indexes
  • Tune indexes to meet the workload Thus promoting faster application performance overall.

Additional information can be found at the CopperEye website. www.coppereye.com



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM