This is a small story, yet with something special: Once upon a time, there was a list of events stored into a database table. Each event had (evidenceJ) a date. A friend of mine asked me to sort these event items. I asked, as you may imagine: Ascending or Descending?   But this, appar... [More]

Ho to view periodic relationship data In the previous post, I exposed a method for uniquely indexing time spans of periodic-memberships.   Here, we will discuss the next task: How to view historical data in such structures? To illustrate this, we will talk about a portfolio sample data, sim... [More]

Introduction The relations between some ‘real world’ objects can sometimes be in the form of ‘periodic membership’. By ‘periodic membership’, I mean the context when one object can be member of another during one or more periods of time. Examples: · ... [More]

The data record (the ‘form’) As I mentioned in Part II, my proposed solution (aimed to transfer and communicate data between a Silverlight Client and the database server) is composed of the following schematic classes: Data level classes SilverDataTable Represents... [More]

Filtering database data As we have seen in Part III, the SQL Select statement is composed of the following parts: SELECT                 [field1], [field2],… [fieldn] FROM        &... [More]

Sorting and filtering database records After having succeeded to display our server data into Silverlight DataGrid (see previous post), we will now continue the adventure to complete our solution with some useful and necessary features that Silverlight DataGrid originally proposes (for example, sor... [More]

Introduction As I exposed in an earlier post, Database structure can be declined into the following hierarchy § A table § Containing rows § Containing data //(arranged into columns)   This schema cannot live without the following meta-data structure § Table definition... [More]

Software is about defining objects structures, relationships and behavioral contour. This is probably a too short sentence to define what software is. But it can be a good commencement for what I would like to expose here. Years passed for the software industry to mature and be able to express the ... [More]

SQL recursive schemas   One of the interesting features of relational databases is the possibility for a table to reference itself. Suppose we want to represent the file folder system in a database. We can define a table having, for example, 3 fields: id, parent_id and name:   We ca... [More]