Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Fundamental Themes For Your Data Warehouse

By Exforsys | on February 8, 2007 |
Data Warehousing

Fundamental Themes For Your Data Warehouse

While each data warehouse may differ in their size, scope, or complexity, there are certain fundamental themes that they all share. The three important themes that all data warehouses share are processing time, drilling down, and drilling up. If a system has all of these factors, and it runs with a high level of efficiency, it can be truly called a data warehouse.

Despite the fact that all data warehouses are comprised of these three elements, they all lay the foundation for structures that are truly powerful. In this article, I will describe the fundamental themes that make up all data warehouses, and I will explain why they are so important.

The term "drilling down" is used to describe the addition of a row header, particularly within a relational database. In most cases, the row header will be added to a "select" statement. When a user studies the sales of a product at a specific level, such as from the manufacturer, the query will present them with information that is related to the sum, manufacturer, and sales. In addition to this, the query will also have information that is related to time or other units. If you want to drill down further to the brand that the manufacturers sale, you will want to add the appropriate row headers. Once this is done, the data warehouse will show numerous rows which list the brands which are sold.

A row header will often be referred to as being a grouping column. The reason for this is because all the items that are not connected to an operator such as SUM will need to be identified in the SGQ group with a certain clause. It could basically be said that grouping columns and row headers are identical. If the information contained in the example above is located in a dimensional star schema, the brand unit and the manufacturer unit can generally be found in the same dimension table. Once a user runs a query at the level of the manufacturers, they can see a collection of characteristics for the dimensions of the products. It is also possible for the user to place the attributes of a brand within the query.

Once this is done, the user can run a query again, and they can drill down in a certain manner. If the attributes for the manufacturer and brand are contained within the same dimensional table, then this reduces the number of adjustments that need to be made to the SQL. In other words, this will make the query much more simple. It is crucial for the data warehouse to support drilling down, especially at the user interface level. It is best to use a large amount of atomic data during this stage, and the reason for this is because the atomic data is much more dimensional than other forms of data. It should also be noted that the atomic data is more expressive as well.

When two points are combined together, the atomic data must be comprised of the same schema. The atomic data should be easily accessible, and this will make it easier when the drill down procedure is used. When a company fails to do this, it is one of the leading causes of having an architecture that is a strange structure. The atomic data may be hidden, and it may only be accessed after a user has used the drilling through process.

There are actual some people which support this structure, but most of them can never explain how this happens. These are generally people who have never used query tool that was designed by a commercial company.

There are a number of things a company should do if they wish to build a system for drilling down. They will first need to acquire and use query tools that are ad hoc. These should be tools that will showcase the drill down options without the need for distinct schema programming. Many experts have said that distinct schema programming is the bane of many data warehouses. The reason for this is because each schema will need to have an application that is custom built. This problem was quite prevalent during the 1990s, but this doesn’t mean that a company can’t fall victim to it today.

« « Why Data Warehouses Can Be Useful
What You Should Know About Building a Data Warehouse » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 417 Followers
Ads
  • Popular
  • Recent
  • How To Protect Your Data Warehouse

    September 7, 2006 - 0 Comment
  • Understanding The Data Warehouse

    February 1, 2007 - 0 Comment
  • Creating an Efficient Process for Data Warehouses

    February 13, 2007 - 0 Comment
  • How To Use Data Warehouses Strategically

    September 11, 2006 - 0 Comment
  • The Benefits of Data Warehouses

    February 4, 2007 - 0 Comment
  • Understanding Quality Management For Data Warehouses

    February 13, 2007 - 0 Comment
  • How To Manage Current and Historical Information Within Your Data Warehouse

    September 11, 2006 - 0 Comment
  • The Disadvantages of a Data Warehouse

    February 4, 2007 - 0 Comment
  • Data Warehousing Introduction

    July 30, 2006 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • Understanding The Challenges of Using Data Warehouses

    February 15, 2007 - 0 Comment
  • Understanding Quality Management For Data Warehouses

    February 13, 2007 - 0 Comment
  • Creating an Efficient Process for Data Warehouses

    February 13, 2007 - 0 Comment
  • How Does a Data Warehouse Differ From a Database

    February 11, 2007 - 0 Comment
  • How Data Is Stored Within a Data Warehouse

    February 11, 2007 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 2007 - 0 Comment
  • Why Data Warehouses Can Be Useful

    February 8, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Data Warehouses Non Technical Issues
  • How To Evaluate The Software For your Data Warehouse
  • Understanding The Challenges of Using Data Warehouses
  • Understanding Quality Management For Data Warehouses
  • Creating an Efficient Process for Data Warehouses

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled