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
 

Data Warehouses At a Glance

By Exforsys | on August 8, 2006 |
Data Warehousing

Data Warehouses At a Glance

Data warehouses have played an important role in information technology since the 1990s. They are tools that allow organizations to use relevant information to make important business decisions.

While data warehouses were originally only used by large companies, the decreasing cost of computing has allowed them to be adapted by smaller companies. To understand data warehouses, it is important to learn about the data warehouse architecture.

Data warehouses are computerized systems that store information. They information will almost always come from another source. These sources could be programs or applications. Not only is the data warehouse able to store information, it can also analyze that information as well. This is what separates a data warehouse from being a mere computer storage device. Managers can search through the warehouse looking for specific information. Data mining programs can be initiated, and they will look through the data warehouse for patterns or relationships that can help companies make important marketing decisions.

A data warehouse is basically a database that can answer certain questions. They are subject oriented, and they will analyze information and can help managers solve problems. There are a number of steps that are involved with building a data warehouse. These procedures are similar to those that would be used to build other computer programs. The users of the data warehouse must play a role in its construction. The user is important because they are the people who will be using the tools. Each data warehouse is different, and it must be designed in a way that will allow it to meet the needs of those who use it.

The users will decide what type of information will be placed in the warehouse. Once the requirements for the data warehouse have been developed, the elements must be placed in a conceptual model. This will act as a diagram that will be used to build the actual database. At this point, there are a large number of decisions which need to be made about the design and implementation of the warehouse. Once the warehouse has been built, the data must be acquired and stored. It is up to the data warehouse managers to decide what information must be stored in the database. Much of this data will be related to the organization that owns the data warehouse.

However, some of the data may be taken from other sources. An extraction application must be created in order to pull data from other sources to be placed in the data warehouse. The sources must be identified, and some of these will be file, legacy systems, or other databases. The information will be copied into what is called a staging area. Once the data is placed in the staging area, it will need to be cleaned. Once it is clean and free of errors, it will then be copied into the warehouse. It is crucially important to make sure the data is moved into the warehouse correctly. It is not, the project will not be successful.

Metadata is another important concept that is connected to data warehouses. In fact, high quality meta data is important for the function of the database. Metadata is information about information. It is used in the information collection process, and it is also used when the data is accessed or transformed. In the acquisition phase, the information will be mapped and transferred from the operational system. I will provide a large amount of information about the data, and some of this includes updates or algorithms. Data marts are also important. While managers will want to keep them updated, they don’t need to be updated in real time. Data marts are small in comparison to data warehouses and are only hold information about departments that exist within an organization.

Many companies have begin combining a number of small data marts in order create a data warehouse. However, this has led to controversy. Some feel that data marts where never designed to function as data warehouses, and they should not be used for this purpose. It is best to use data marts as a component to a data warehouse instead of a standalone entity. Security is an important issue with data warehouses, and the information must be protected.

« « How To Write a Good Essay
How To Write The Main Heading For Your Essay » »

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 Data Is Stored Within a Data Warehouse

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

    September 7, 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 Use Data Warehouses Strategically

    September 11, 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 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
  • 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