quad tree
Home > Oracle Database / Applications Definitions - Quad 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 #

quad tree


Show me everything on Oracle database design and architecture

DEFINITION - A quad tree is a method of placing and locating files (called records or keys) in a database. The algorithm finds data by repeatedly dividing the number of ultimately accessible records in four parts until only one remains.

In a tree, 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. Branch points are called nodes. The order of a tree is the number of branches (called children) per node. In a quad tree, there are always four children per node, so the order is 4. The number of leaves in a quad tree is always a power of 4. The number of access operations required to reach the desired record is called the depth of the tree. The image below shows a quad tree of depth 3.

quad_tree.gif

In a practical tree, there can be thousands, millions, or billions of records. Not all leaves necessarily contain a record, but more than half do. A leaf that does not contain a record is called a null. In the example shown here, the eighth, twelfth, and sixteenth leaves are nulls, indicated by open circles.

The quad tree is uniquely suited as an algorithm to locate pixels in a two-dimensional image. The reason for this is that, in two dimensions (the usual way in which graphics are depicted), square pixels can be divided into four square parts repeatedly. The depth of such a tree depends on the image resolution, the computer memory, and the complexity of the image.

Also see binary tree, B-tree, splay 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





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 - quad 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