When technophiles enthuse about XML the rest of the world’s eyes glaze over. “Another three letter acronym”, they cry, “Run away!”.
But its a wonderful thing for anyone who deals with storage, transfer, exchange, discovery, processing, and/or analysis of information in machine readable form.
If you follow the links, or just “Google” yourself to the [...]
Introduction
It is a commonplace of the modern world that electronic data bases allow us to store millions and trillions of records, keep then safe, and allow us to sort and search among them.
SQL
Experience has shown that its best to separate the presentation of data, the layout, colors, fonts , logical organization and [...]
Lets say Alice and Bob are using a web interface to maintain data stored in a back end database.
First Alice brings up record 42 and begins reviewing it for potential corrections.
While she is working, Bob comes along, signs in at a different work station and reads the same record 42. He notices that the field [...]
We’ve described the basic shape of the relational database schema which we use to represent structural and descriptive metadata in a previous post.
When the schema was first designed, we knew that in the future we would need to record the values of new attributes, currently unknown and unguessable. The usual way to meet [...]
Its been some time now since the book “Design Patterns” by Gamma, Helm, Johnson and Vlissides (the so called Gang of Four) was first published, in 1994.
Consequently, one need not necessarily be both brilliant and original simultaneously to recognize that screen to screen navigation, the flow of control through applications , [...]
Before any data can be loaded into our database system, we need to determine a “schema”, i.e. a set of tables such that all of the data we need to retain has its proper place
The important questions to ask are
What “things” (nouns) are we interested in. These are the “entities” of the ER model
What [...]
XML is increasingly popular as the underlying technology for any number of information sharing and exchange standards.
In particular, Michael has shown us how SOLR requires data for ingest to be presented in an XML canonical form:
<?xml version=”1.0″ encoding=”UTF-8″?>
<add>
<doc>
<field name”id”>8675309</field>
<field name=”title”>Jenny</field>
<field name=”author”>Tommy [...]
