rwebdb 29-July-2010

A milestone. We now have a working definition of the population of institutions to include in the data warehouse. Includes links to 7 new xquery programs and 3 other assorted links to new material.

rwebdb 26-July-2010

Two more XQuery utility programs helpful when identifying IPEDS variables to include in the data mart. One of the programs illustrates the use of dynamic XQuery, which can be a particularly powerful way to collapse a multitude of specific queries into one generalized query.

rwebdb 13-July-2010

On star schemas, dimension and fact variables, and iteration toward a warehouse design.

rwebdb 12-July-2010

Housekeeping post. Today I added an attribute to one of the XML files to include the name of the SPS file used as the source for the metadata. If you ever need to go back to the source file and check metadata values, it’s important to know what source file you actually used!

rworld – Listening Closely

On listening for tomorrow after filtering the institutional noise of today. Includes a threaded bookmark of the following:
1. Making good society.
2. The Cooperative Movement in Century 21.
3. The Foundation for P2P Alternatives.
4. A Gathering of Ideas.

rwebdb: Reflections

My greatest hopes are that rwebdb will touch a nerve in people and provide encouragement for them to create tomorrow for themselves.

rwebdb: Good News

Yesterday the Delta Project released an impressive web-based tool that allows journalists, officials, policymakers, and the public to conveniently explore higher education finances in the United States. A report in Inside Higher Ed described it this way: “the new database’s groundbreaking feature is that – fasten your seatbelts – it allows for an analysis of the budget priorities of individual institutions.” Good news indeed.

rwebdb 07-July-2010

More metadata. This time on codes used by some variables and the descriptions of those codes. And yet another illustration that you don’t just mashup data files like IPEDS. There are no shortcuts.