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.
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.
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.
On star schemas, dimension and fact variables, and iteration toward a warehouse design.
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!
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.
My greatest hopes are that rwebdb will touch a nerve in people and provide encouragement for them to create tomorrow for themselves.
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.
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.