Data Warehouses & Data Mining

Powerful Essays
DATA WAREHOUSES & DATA MINING

Term-Paper

In

Management Support System

[pic]

Submitted By: Submitted To:

Chitransh Naman Anita Ma’am

A22-JK903 Lecturer

10900100 MSS

ABSTRACT :-

Collection of integrated, subject-oriented, time-variant and non-volatile data in support of managements decision making process.

Described as the "single point of truth", the "corporate memory", the sole historical register of virtually all transactions that occur in the life of an organization.

A fundamental concept of a data warehouse is the distinction between data and information. Data is composed of observable and recordable facts that are often found in operational or transactional systems. At Rutgers, these systems include the registrar’s data on students (widely known as the SRDB), human resource and payroll databases, course scheduling data, and data on financial aid.

In a data warehouse environment, data only comes to have value to end-users when it is organized and presented as information.

Information is an integrated collection of facts and is used as the basis for decision-making. For example, an academic unit needs to have diachronic information about its extent of instructional output of its different faculty members to gauge if it is becoming more or less reliant on part-time faculty.

[pic]

INTRODUCTION :-

“The data warehouse is always a physically separate store of data transformed from the application data found in the operational environment”.

Data entering the data warehouse comes from operational environment in almost every case.Data warehousing provides architectures and tools for business executives to syste-matically organize ,understand ,and use their data to make stragetic decisions.A large number of organizations have found that data warehouse systems are valuable tools in today’s competive,fast-evolving world. In the last several years

You May Also Find These Documents Helpful

  • Powerful Essays

    Information Systems Management Research Project ON Data Warehousing and Data Mining Submitted in Partial fulfilment of requirement of award of MBA degree of GGSIPU, New Delhi Submitted By: Swati Singhal (12015603911) Saba Afghan (11415603911) 2011-2013…

    • 2521 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Data Warehouse

    • 4241 Words
    • 38 Pages

    Data Warehouse Concepts and Design Contents Data Warehouse Concepts and Design 1 Abstract 2 Abbreviations 2 Keywords 3 Introduction 3 Jarir Bookstore – Applying the Kimball Method 3 Summary from the available literature and Follow a Proven Methodology: Lifecycle Steps and Tracks 4 Issues and Process involved in Implementation of DW/BI system 5 Data Model Design 6 Star Schema Model 7 Fact Table 10 Dimension Table: 11 Design Feature: 12 Identifying the fields from facts/dimensions: MS: 12 Advanced…

    • 4241 Words
    • 38 Pages
    Powerful Essays
  • Powerful Essays

    Data Mining

    • 5812 Words
    • 24 Pages

    business intelligence, data warehouse, data mining, text and web mining, and knowledge management. Justify and synthesis your answers/viewpoints with examples (e.g. eBay case) and findings from literature/articles. To understand the relationships between these terms, definition of each term should be illustrated. Firstly, business intelligence (BI) in most resource has been defined as a broad term that combines many tools and technologies, used to extract useful meaning of enterprise data in order to help…

    • 5812 Words
    • 24 Pages
    Powerful Essays
  • Satisfactory Essays

    Data Mining

    • 2278 Words
    • 10 Pages

    Stock Exchange forecasting with Data Mining and Text Mining (Marketing and Sales Analysis) Full names : Fahed Yoseph TITLE : Senior software and Database Consultatnt (Founder of Info Technology System) E-mail: Yoseph@info-technology.net Date of submission: Sep 15th of 2013 CONTENTS PAGE Chapter 1 1. ABSTRACT 2 2. INTRODUCTION 3 2.1 The research problem. 4 2.2 The objectives of the proposal. 4 2.3 The Stock Market movement. 5 2.4 Research question(s). 6 2. Background 3. Problem…

    • 2278 Words
    • 10 Pages
    Satisfactory Essays
  • Powerful Essays

    Data Mining

    • 1453 Words
    • 6 Pages

    SMS CUSAT Reading Material on Data Mining Anas AP & Alex Titty John • What is Data? Data is a collection of facts and information or unprocessed information. Example: Student names, Addresses, Phone Numbers etc. • What is a Database? A structured set of data held in a computer which is accessible in various ways. Example: Electronic Address Book, Phone Book. • What is a Data Warehouse? The electronic storage of large amount of data by business. Concept originated in…

    • 1453 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    data mining

    • 1589 Words
    • 9 Pages

    Components of DSS (Decision Support System) Data Store – The DSS Database Data Extraction and Filtering End-User Query Tool End User Presentation Tools Operational Stored in Normalized Relational Database Support transactions that represent daily operations (Not Query Friendly) Differences with DSS 3 Main Differences Time Span Granularity Dimensionality Operational DSS Time span Real time Historic Current transaction Short time frame Long time frame Specific Data facts Patterns Granularity Specific…

    • 1589 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Data Mining

    • 350 Words
    • 2 Pages

    a necessity for a businesses trying to maximize its profits. A new, and important, tool in gaining this knowledge is Data Mining. Data Mining is a set of automated procedures used to find previously unknown patterns and relationships in data. These patterns and relationships, once extracted, can be used to make valid predictions about the behavior of the customer. Data Mining is generally used for four main tasks: (1) to improve the process of making new customers and retaining customers; (2)…

    • 350 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Data Mining

    • 3792 Words
    • 16 Pages

    university CASE STUDY OF DATA MINING Summitted by Jatin Sharma Roll no -32. Reg. no 10802192 A case study in Data Warehousing and Data mining Using the SAS System. Data Warehouses The drop in price of data storage has given companies willing to make the investment a tremendous resource: Data about their customers…

    • 3792 Words
    • 16 Pages
    Powerful Essays
  • Powerful Essays

    Data Mining

    • 2070 Words
    • 9 Pages

    Data Mining Melody McIntosh Dr. Janet Durgin Information Systems for Decision Making December 8, 2013 Introduction Data mining, or knowledge discovery, is the computer-assisted process of digging through and analyzing enormous sets of data and then extracting the meaning of the data. Data mining tools predict behaviors and future trends, allowing businesses to make proactive, knowledge- driven decisions Although data mining is still in its infancy…

    • 2070 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Data mining

    • 1174 Words
    • 5 Pages

    University CS 450 Data Mining, Fall 2014 Take-Home Test N#1 Date: September 22nd, 2014 Final deadline for submission September 29th, 2014 Weighting: 5% Total number of points: 100 Instructions: 1. Attempt all questions. 2. This is an individual test. No collaboration is permitted for assessment items. All submitted materials must be a result of your own work. Part I Question 1 [20 points] Discuss whether or not each of the following activities is a data mining task. •…

    • 1174 Words
    • 5 Pages
    Satisfactory Essays