Social Icons

21 March 2011

Data Warehouse Architecture

The above Architecture is taken from the www.databaseanswers.com . We would recommend you to visit this site to get good understanding towards data modeling.

Now we are goanna define each and every terminology in the above picture to facilitate better understanding of the subject.

1. Operational Data Store : is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for reporting.

2. ERP : Enterprise resource planning integrates internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, etc.

             Its purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders.

3. CRM : Customer relationship management is a widely-implemented strategy for managing a company’s interactions with customers, clients and sales prospects. It involves using technology to organize, automate, and synchronize business processes—principally sales activities, but also those for marketing, customer service, and technical support.

        Customer relationship management describes a company-wide business strategy including customer-interface departments as well as other departments.

4. Flat Files In data Ware Housing : Flat Files Doesn’t Maintain referential Integrity like RDBMS and are Usually seperated by some delimiters like comma and pipes etcs.

           Right from Informatica 8.6 unstructured data sources like Ms-word,Email and Pdf can be taken as source.

5. ETL (Extract,Transform, And load) :

is a process in database usage and especially in data warehousing that involves:

6. Data Marts: A data mart (DM) is the access layer of the data warehouse (DW) environment that is used to get data out to the users. The DM is a subset of the DW, usually oriented to a specific business line or team.

           For the Definition of the Data Warehouse Please Refer to Introduction to the Data ware Housing.

7. OLAP : OLAP (Online Analytical Processing) is a methodology to provide end users with access to large amounts of data in an intuitive and rapid manner to assist with deductions based on investigative reasoning.

OLAP systems need to:

  1. Support the complex analysis requirements of decision-makers,
  2. Analyze the data from a number of different perspectives (business dimensions), and
  3. Support complex analyses against large input (atomic-level) data sets.

8. OLTP : Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.

9. Data Mining: Is the process of extracting patterns from large data sets by combining methods from statistics and artificial intelligence with database management. Data mining is seen as an increasingly important tool by modern business to transform data into business intelligence giving an informational advantage.

12 comments:

  1. this is very nice and informative article. informatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore
    informatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore

    ReplyDelete
  2. Good post. I learn something totally new and challenging on blogs I stumble upon on a daily basis. It will always be interesting to read articles from other authors and practice something from their websites...

    Data warehousing Training in Chennai

    ReplyDelete
  3. I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job .I feel happy to read your post, thanks for sharing your knowledge of sap with us keep posting with new concepts...

    Dataware Tools
    HADOOP Training in Chennai
    Base SAS Training in Chennai
    MSBI Training in Chennai
    INFORMATICA Training in Chennai
    DATAWAREHOUSE Training in Chennai

    ReplyDelete
  4. I got a good answer from the above description,but it still requires some more update to be made. Please share more content on MSBI Online Training Hyderabad

    ReplyDelete
  5. Thanks for Sharing this Valuable Information i like this i Can Share this with My Friend Circle.
    Data Warehousing Training in Noida

    ReplyDelete
  6. Thanks for sharing this valuable information and we collected some information from this blog.
    Data Warehousing Training in Noida

    ReplyDelete
  7. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Artificial Intelligence Certification Course
    Java Certification Course
    AWS Certification Course
    Machine Learning Certification Course
    Data Science Certification Course
    DevOps Certification Course

    ReplyDelete
  8. Fiducia Solutions is an ISO certified institute providing course certifications to all its students. We, at Fiducia Solutions, see to it that the candidate is certified and entitled to bag a good position in acclaimed companies. We provide certificates that are valued, and our alumni reputation proves that we are good at what we offer.

    And that is not all! We are known to provide 100% live project training and 100% written guaranteed placements to our students. That’s what makes us the best PHP/ HR/ Digital Marketing training institutes in Noida and Ghaziabad.

    PHP Training Institute in Noida
    HR Training Institute in Noida
    Digital Marketing Training Institute in Noida
    Android Training Institute in Noida

    ReplyDelete