Technobabble

Data Warehousing

Posted by on Sep 8, 2004 | One Comment

Data Warehousing is a process in which different databases are combined within an organization. Data warehouses are implemented to provide business intelligence and support management decisions. The broad view afforded by data warehousing allows for a more complete picture of business conditions at any given instant. By using a specialized database to provide information from a variety of sources, the data warehouse allows employees to access information in ways that would not otherwise be possible …

Andrews University defines data warehousing as “The coordinated, architected, and periodic copying of data from various sources, both inside and outside the enterprise, into an environment optimized for analytical and informational processing.” Their excellent online data warehousing dictionary provides definitions on all of the most relevant terms in the field.

Microsoft’s Creating and Using Data Warehouses Overview is worth a look, as well.

  • http://twitter.com/KodeSource Doug McFarlane

    Sending out the request takes bandwidth, ie: ‘Is the next letter an ‘A’?’.

    But if both sides use an agreed upon question and response algorithm, then the sender only needs to send the responses from the algorithm, based on English language patterns.

    If your ’2 bits’ per letter is accurate, and normal English takes say a minimum of 5 bits (2^5 = 32 unique characters), that is quite a savings.

    Although text is known for its high compression rate anyways, so I’m not sure if this saves space overall, but again, an interesting read.