Data Mining - Analysis White Papers

Efficient "One-Row-Per-Subject" Data Mart Construction for Data Mining

Overview Creating a "One-row-per-subject" data mart is a fundamental task when preparing data for data mining. To answer the underlying business question, the analyst or data-mart programmer is challenged to distill the relevant information from various data sources. Creating a data mart involves more than reading columns from a source table to the data mart. It also includes the aggregation or transposition of observations from "Multiple-row-per-subject" tables like transactional tables and time histories. This paper shows the details of input data structures for a "One-row-per-subject" data mart. It also discusses the "One-row-per-subject" paradigm from a technical and a business point of view, and shows how data, some of which include hierarchical dependencies, is aggregated into a "Single-row-per-subject.".

Further White Paper Details
PublisherSAS Institute File FormatPDF
Date PublishedFebruary 2006 Downloads2
FormatWhite Papers   
Topics

Quick Sitemap Links: