Code covered by the BSD License  

Highlights from
dataview.m

Be the first to rate this file! 3 Downloads (last 30 days) File Size: 4.33 KB File ID: #24625

dataview.m

by Peter Cotton

 

02 Jul 2009

Sparse and possibly normalized representation of a dataset

| Watch this File

File Information
Description

A collection of one or more related @datasets, achieving a sparse (and possibly normalized) representation of a larger @dataset
 
Dataviews are compressed by providing a list of "key" variable names (analogous to key fields in a database) and a name for a new integer variable variable which will substitute for the key fields. This operation can be performed more than once.
 
Any dataset can be converted to a dataview by means of the dataview constructor, retrieved with dataview.full, and added to by means ofdataview.insert. The latter operation preserves the exising key lookups.
   
Motivations:
  
An ETL tool for relational databases
An updateable view (of sorts)
A "lite" database (one can combine several of these fellas)

Required Products Statistics Toolbox
MATLAB release MATLAB 7.6 (R2008a)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Please login to add a comment or rating.
Tag Activity for this File
Tag Applied By Date/Time
dataset Peter Cotton 06 Jul 2009 10:12:18
relational Peter Cotton 06 Jul 2009 10:12:18
relational database Peter Cotton 06 Jul 2009 10:12:18
etl Peter Cotton 06 Jul 2009 10:12:18
extract transform load Peter Cotton 06 Jul 2009 10:12:18
data table Peter Cotton 06 Jul 2009 10:12:18
statistics Peter Cotton 06 Jul 2009 10:12:18
data import Peter Cotton 06 Jul 2009 10:12:18
data export Peter Cotton 06 Jul 2009 10:12:18

Contact us at files@mathworks.com