Random Analogies

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.

Useful?
Writer: mattyflynn
LCC: QA
Where: Reference Link Has Evaporated
Date: May 15 2010 2:16 AM


The Iddy Joe Friday

a: Don draper ~
b: Joe Friday with an Id

What: Do you think this is true? See the comments page.

Useful?
Writer: LucretiaGermanica
LCC:
Where: Reference Link Has Evaporated
Date: Apr 5 2012 6:25 PM


Moving It Around.....

a: Transposon ~
b: a truck used to carry the cargo

What: "The Sleeping Beauty transposase enzyme plus the transposon is like a truck used to carry the cargo, or specific genes, into the animal."

Useful?
Writer: David Largaespada
LCC:
Where: Reference Link Has Evaporated
Date: May 15 2013 10:09 PM



a: culture industry ~
b: Goskonzert

What:

"Citing my remarks, Neil says that I make the music industry sound like
Goskontzert. And so it looks as if I'll have to sweep away the last
scraps of disillusionment. The culture industry IS like Goskonzert, only worse. It's structure is hierarchical, and not dissimilar to the models of iconostatsis that the Politburo inherited from the Orthodox Church to impose its stature and codify its authority. Only the chips are different - money instead of favors - but the distribution of power
among a select few, most of whom know nothing about music and plenty
about business, is no different "


Useful?
Writer: Not Stated
LCC:
Where:
Date: May 31 2015 7:35 PM



Green Venn Diagram

Browse Analogies by Library of
Congress Catagory: