Amazines Free Article Archive
www.amazines.com - Thursday, October 17, 2019
Read about the most recent changes and happenings at Amazines.com
Log into your account or register as a new author. Start submitting your articles right now!
Search our database for articles.
Subscribe to receive articles emailed straight to your email account. You may choose multiple categories.
View our newest articles submitted by our authors.
View our most top rated articles rated by our visitors.
* Please note that this is NOT the ARTICLE manager
Add a new EZINE, or manage your EZINE submission.
Add fresh, free web content to your site such as newest articles, web tools, and quotes with a single piece of code!
Home What's New? Submit/Manage Articles Latest Posts Top Rated Article Search
Google
Subscriptions Manage Ezines
CATEGORIES
 Article Archive
 Advertising (133313)
 Advice (160846)
 Affiliate Programs (34734)
 Art and Culture (73685)
 Automotive (145676)
 Blogs (75042)
 Boating (9840)
 Books (17122)
 Buddhism (4124)
 Business (1328458)
 Business News (426309)
 Business Opportunities (366262)
 Camping (10960)
 Career (72723)
 Christianity (15840)
 Collecting (11637)
 Communication (115054)
 Computers (241950)
 Construction (38995)
 Consumer (49679)
 Cooking (17061)
 Copywriting (6567)
 Crafts (18204)
 Cuisine (7538)
 Current Affairs (20384)
 Dating (45774)
 EBooks (19685)
 E-Commerce (48201)
 Education (185227)
 Electronics (83492)
 Email (6392)
 Entertainment (159829)
 Environment (28935)
 Ezine (3039)
 Ezine Publishing (5446)
 Ezine Sites (1550)
 Family & Parenting (110900)
 Fashion & Cosmetics (196387)
 Female Entrepreneurs (11842)
 Feng Shui (130)
 Finance & Investment (310266)
 Fitness (106051)
 Food & Beverages (62863)
 Free Web Resources (7938)
 Gambling (30224)
 Gardening (25103)
 Government (10512)
 Health (629455)
 Hinduism (2205)
 Hobbies (44033)
 Home Business (91553)
 Home Improvement (251337)
 Home Repair (46124)
 Humor (4819)
 Import - Export (5453)
 Insurance (45130)
 Interior Design (29545)
 International Property (3484)
 Internet (190981)
 Internet Marketing (146327)
 Investment (22824)
 Islam (1167)
 Judaism (1356)
 Law (80476)
 Link Popularity (4591)
 Manufacturing (20842)
 Marketing (98766)
 MLM (14136)
 Motivation (18213)
 Music (27001)
 New to the Internet (9479)
 Non-Profit Organizations (4048)
 Online Shopping (129614)
 Organizing (7803)
 Party Ideas (11855)
 Pets (38081)
 Poetry (2234)
 Press Release (12672)
 Public Speaking (5618)
 Publishing (7523)
 Quotes (2407)
 Real Estate (126613)
 Recreation & Leisure (95264)
 Relationships (87454)
 Research (16158)
 Sales (80317)
 Science & Technology (110203)
 Search Engines (23451)
 Self Improvement (153096)
 Seniors (6231)
 Sexuality (35942)
 Small Business (49283)
 Software (82994)
 Spiritual (23464)
 Sports (116077)
 Tax (7658)
 Telecommuting (34066)
 Travel & Tourism (307309)
 UK Property Investment (3118)
 Video Games (13427)
 Web Traffic (11726)
 Website Design (56813)
 Website Promotion (36564)
 World News (1000+)
 Writing (35764)
Author Spotlight
OLEG KOBETS

Oleg has been providing SEO, Copywriting and Content Management services for 10+ years. For the last...more
ANISH SAH

My Name is Anish Sah, I am an Internet Marketing and SEO Expert, Social Media Guru and young Entrepr...more
SHWETA SINGH

This article has been written by a verified author, Shweta Singh. She has been in the business of wr...more
WILLIAM ELSENRATH

I'm retired and help my wife with her home business. I do the work behind the scenes by writing arti...more
CACEY TAYLOR

Im just a man who likes to be happy and see others happy. Im into home business, sports, family, and...more


What is Dimensions Tables in Oracle? by Gitesh Trivedi





What is Dimensions Tables in Oracle? by
Article Posted: 03/22/2012
Article Views: 79
Articles Written: 83
Word Count: 430
Article Votes: 0
AddThis Social Bookmark Button

What is Dimensions Tables in Oracle?


 
Software,Business,Computers
Dimensions are an optional feature associated with materialized views. The use of dimensions makes query rewrite much more flexible. A dimension is an Oracle object that stores hierarchical information about your data. This information is used by the optimizer as it determines whether it can rewrite your query to use a materialized view.

Data in a data warehouse typically represents various hierarchical structures. One example would be the time relationship of data, which might be of the form of decade, year, quarter, month, week, day, hour, and so on. These types of relationships generally are used in data warehouse queries to roll up or drill down to more or less detail as needed. Oracle has introduced an object called a dimension that allows you to define these relationships in tables. Oracle then uses these dimension relationship definitions to more effectively rewrite queries and to determine if a materialized view can best be used.

Although Oracle can rewrite queries without the presence of dimensions, the definition of dimensions makes the query rewrite process much more versatile. The use of dimensions allows the query rewrite to move beyond SQL checking of the query’s SELECT clause and its join conditions in the WHERE clause; with dimensions, the query rewrite can look at the summary grouping and also other operations.

When you create a dimension, you define the various components of the dimension and then the various hierarchies of the dimension. For example, if you created a table with columns for the number of landing cycles that an aircraft might go through one cycle represent a single landing, you might create a table called TAKEOFF_LAND, and in it, you might create columns for year, quarter, month, week, day, and column of takeoff. These columns would be components, or levels, of the hierarchy; the order in which they appear would constitute the hierarchy itself.

During database services of data warehousing, you need to take care of dimension object very carefully. You need to understand basic concept of dimension object. Data warehousing always contains so many schedule jobs which data extracting continuously and during this data loading, if dimension object would become invalid or corrupt then you would not able to recover because size of database always large for data warehousing. It is not easy to recovery using any backup recovery scenario. Due to these all reasons, you need to take care of all dimension objects in data warehousing about levels and hierarchy representation.

Author is having 15+ years experience and providing Oracle Consulting, and author of Oracle DBA Interview Questions book.

Related Articles - data warehouse, data warehousing, databases, oracle dimensions,

Email this Article to a Friend!

Receive Articles like this one direct to your email box!
Subscribe for free today!

 Rate This Article  
Completely useless, should be removed from directory.
Minimal useful information.
Decent and informative.
Great article, very informative and helpful.
A 'Must Read'.

 

Do you Agree or Disagree? Have a Comment? POST IT!

 Reader Opinions 
Submit your comments and they will be posted here.
Make this comment or to the Author only:
Name:
Email:
*Your email will NOT be posted. This is for administrative purposes only.
Comments: *Your Comments WILL be posted to the AUTHOR ONLY if you select PRIVATE and to this PUBLIC PAGE if you select PUBLIC, so write accordingly.
 
Please enter the code in the image:



 Author Login 
LOGIN
Register for Author Account

 

Advertiser Login

 

ADVERTISE HERE NOW!
   Limited Time $60 Offer!
   90  Days-1.5 Million Views  

 

Great Paranormal Romance


SUSAN FRIESEN

Susan Friesen, founder of the award-winning web development and digital marketing firm eVision Media...more
STEVERT MCKENZIE

Stevert Mckenzie, Travel Enthusiast. ...more
STEPHEN BYE

Steve Bye is currently a fiction writer, who published his first novel, ‘Looking Forward Through The...more
GENE MYERS

Author of four books and two screenplays; frequent magazine contributor. I have four other books "in...more
LAURA JEEVES

At LeadGenerators, we specialise in content-led Online Marketing Strategies for our clients in the t...more
TIM FAY

I am not a writer nor am I trying to become a writer. I am an average person with average intelligen...more
JOANNA MORGAN

Joanna Morgan has a huge passion for making money online from home and enjoys traveling around the w...more
JAMES OLEANDER

James Oleander is a professional writer on business and financial topics. He has published many arti...more
JASON NG

Jason Ng has a huge passion for the health and fitness industry as he strongly believes that having ...more
LANCE CHAPMAN

An experienced, resourceful and highly motivated IT professional, with a proven record of success in...more

HomeLinksAbout UsContact UsTerms of UsePrivacy PolicyFAQResources
Copyright © 2019, All rights reserved.
Some pages may contain portions of text relating to certain topics obtained from wikipedia.org under the GNU FDL license