splay tree
Home > Oracle Database / Applications Definitions - Splay tree
SearchOracle.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

splay tree


Show me everything on Oracle database design and architecture

DEFINITION - A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database. The algorithm finds data by repeatedly making choices at decision points called nodes.

In a splay tree, as in a binary tree, a node has two branches (also called children). Records are stored in locations called leaves. This name derives from the fact that records always exist at end points; there is nothing beyond them. The starting point is called the root. The number of access operations required to reach the desired record is called the depth. In a practical tree, there can be thousands, millions, or billions of nodes, children, leaves, and records. Not every leaf necessarily contains a record, but more than half do. A leaf that does not contain data is called a null.

The splay tree scheme is unique because the tree organization varies depending on which nodes are most frequently accessed. This structural change takes place by means of so-called splaying operations, also called rotations. (In general, to splay is to spread or extend out or apart.) There are several ways in which splaying can be done. It always involves interchanging the root with the node in question. One or more other nodes might change position as well. The purpose of splaying is to minimize the number of access operations required to recover desired data records over a period of time.

Also see binary tree, B-tree, and tree structure.

Learn more about Oracle database design and architecture
Spotlight on Oracle performance tuning: Performance tuning is a key task for any Oracle DBA. This spotlight includes tips and advice to help you meet your tuning challenges and keep users happy.
The MySQL open source database in the enterprise: The MySQL open source database is not a head-to-head competitor with the SQL database offerings of Oracle, IBM and Microsoft, but many have discovered its hidden advantages.
Diving deeper into the SQL database features: There are dozens of SQL database features for Oracle, IBM and Microsoft that have advantages and disadvantages that must be sorted through. This guide should help.
Breaking down the contenders in the SQL database market: In this chapter we take a look at the relative strengths and weaknesses in the SQL database offerings of The Big Three in the SQL database market: Oracle, IBM and Microsoft.
How to determine your SQL database through needs analysis: In this guide we take a look at the relative strengths and weaknesses in the database offerings of the Big Three: Oracle, IBM and Microsoft.
Oracle database performance tuning guide: Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide.

LAST UPDATED: 04 Apr 2005

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

More resources from around the web:
- Ron Singer's paper, "Splay Trees," is illustrated.





FILE EXTENSION AND FILE FORMAT LIST
File Extension and File Format List:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #


RELATED CONTENT
How to determine your SQL database through needs analysis
In this guide we take a look at the relative strengths and weaknesses in the database offerings of the Big Three: Oracle, IBM and Microsoft.
Breaking down the contenders in the SQL database market
In this chapter we take a look at the relative strengths and weaknesses in the SQL database offerings of The Big Three in the SQL database market:...
Diving deeper into the SQL database features
There are dozens of SQL database features for Oracle, IBM and Microsoft that have advantages and disadvantages that must be sorted through. This guide...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
E. F. Codd  (SearchOracle.com)
extent  (SearchOracle.com)




Research Abstracts - splay tree Articles
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts