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
 

Advantages and Disadvantages to Using a Data Warehouse

By Exforsys | on September 15, 2006 |
Data Warehousing

Advantages and Disadvantages to Using a Data Warehouse

There are a large number of obvious advantages involved with using a data warehouse. As the name suggests, a data warehouse is a computerized warehouse in which information is stored.

The organization that owns this information can analyze it in order to find historical patterns or connections that can allow them to make important business decisions. In this article I will go over some of the advantages and disadvantages that are connected to data warehouses.

One of the best advantages to using a data warehouse is that users will be able to access a large amount of information. This information can be used to solve a large number of problems, and it can also be used to increase the profits of a company. Not only are users able to have access to a large amount of information, but this data is also consistent. It is relevant and organized in an efficient manner. While it will assist a company in increasing its profits, the cost of computing will greatly be reduced. One powerful feature of data warehouses is that data from different locations can be combined in one location.

There are a number of reasons why this is important. When data is taken from multiple sources and placed in a centralized location, an organization can analyze it in a way that may allow them to come up with different solutions than they would if they looked at the data separately. Data mining is connected to data warehouses, and neural networks or computer algorithms are responsible. When data is analyzed from multiple sources, patterns and connections can be discovered which would not be found otherwise. Another advantage of data warehouses is that they can create a structure which will allow changes within the stored data to be transferred back to operational systems.

However there are a number of disadvantages that need to be mentioned as well. Before data can be stored within the warehouse, it must be cleaned, loaded, or extracted. This is a process that can take a long period of time. There may also be issues with compatibility. For example, a new transaction system may not work with systems that are already being used. Users who will be working with the data warehouse must be trained to use it. If they are not trained properly, they may choose not to work within the data warehouse. If the data warehouse can be accessed via the internet, this could lead to a large number of security problems.

Another problem with the data warehouse is that it is difficult to maintain. Any organization that is considering using a data warehouse must decide if the benefits outweigh the costs. Once you have paid for the data warehouse, you will still need to pay for the cost of maintenance over time. The costs involved with this must always be taken into consideration. When it comes to storing information, there are two techniques which are used. The first is called the dimensional technique. When the dimensional technique is used, information will be stored within the data warehouse as facts. These facts will take the form of either text or numerical information.

Data which is stored with the dimensional technique will contain information which is specific to one event. The dimensional technique is useful for workers who have a limited amount of information technology skills. It makes the data easy for them to study and understand. In addition to this, data warehouses that use the dimensional technique tend to operate quickly. The biggest problem with the dimensional technique is if the company decides to change the way it conducts business, it will be difficult to change the data warehouse to support it. The second technique that is used storing data is called database normalisation. With this technique, the data is store in a third normal form. While adding data is easy, producing reports can be tedious.

Data warehouses are an important tool today, and more companies will begin using them in the future. Companies that use data warehouses need to have detailed information that is related to the transactions that take place within the group. When a company is able to analyze detailed information that is related to its own operations, the company can make strategic decisions.

« « HR Interview – Most Popular HR Interview Questions With Generic Answer Formats
How To Properly Manage 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 416 Followers
Ads
  • Popular
  • Recent
  • How Data Is Stored Within a Data Warehouse

    February 11, 2007 - 0 Comment
  • How To Create a Data Warehouse Structure

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

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

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

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

    February 4, 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 Disadvantages of a Data Warehouse

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

    February 13, 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
  • Fundamental Themes For Your Data Warehouse

    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