transferring and formatting data into a data warehouse


Data Conversion For Data Warehousing

a: Transferring and formatting data into a data warehouse ~
b: Origami

What: There sure is a lot of jargon in this field. Here' my summary of converting data from an operational database to a data warehouse. It goes something like this: Operational data are stored in OLTP software which consists of typical 2 dimensional relational tables. These work well for rapid and constant transactions: updates, insertions and deletions. To build a data warehouse, it's best to have data in a form in which it can be queried and displayed in a multitude of dimensions, which is the objective of having a data warehouse. Thus the conceptual model of the Rubiks cubes. But this is a conceptual model that helps humans visualize several dimensions, the data itself never "exists" in 3 dimensions. Data for a data warehouse are converted into and stored in a form which an OLAP tool can analyze it in a multitude of dimensions. This is the function of the star schema. It is a particular type of relational table structure in which 2 dimensional tables can be analyzed as if they were related to each other in a multitude of dimensions. A visualization crutch for this process might be the conversion that occurs with Origami, in which a 2-d object, a piece of paper, is converted into a 3-d object by systematic folding.

Writer: mattyflynn
Where: Reference Link Has Evaporated
Date: May 15 2010 2:16 AM

Green Venn Diagram

METAMIA is a free database of analogy and metaphor. Anyone can contribute or search. The subject matter can be anything. Science is popular, but poetry is encouraged. The goal is to integrate our fluid muses with the stark literalism of a relational database. Metamia is like a girdle for your muses, a cognitive girdle.