Speaking at the GSE Conference

We will be speaking about Anchor Modeling in a presentation named “New trends in data modeling” at the GSE Nordic Region Conference, 2011 (7-9 June), in Stockholm, Sweden.

Here is an excerpt from the abstract:

We need to rethink the concept of a data model. We live in a world where the available information changes more rapidly for every day that passes. This is true both for the content and structure of the information. On top of that, search requirements are also becoming inherently harder to predict. In such a turbulent environment, current data models do not stand the test of time…

New Tutorials Added

We have added some new tutorials that highlight recent features in the anchor modeler (the online Anchor Modeling tool). Among these are the naming convention and how the tool enforces this, context sensitive keyboard shortcuts for modeling operations, and a discussion on the layout algorithm and some of the options affecting it. You can find them under the “Tutorials” menu, or by clicking here.

Guest Lecture held at SU

A guest lecture has been held at DSV, Stockhom University, for the Data Warehousing class. This year the lecture was split over two sessions in which the basics of Anchor Modeling was covered. The online modeling tool was also introduced and an assigment was given to the students in which they will create a simple model. In other words, close to 200 students will help out with the testing of the tool.

Journal Article for DKE Accepted

We are happy to announce that our journal article “Anchor Modeling – Agile Information Modeling in Evolving Data Environments” for the Special Edition Issue of Data & Knowledge Engineering has been accepted for publication. A preprint of the article can be read by clicking here.

Summary

Maintaining and evolving data warehouses is a complex, error prone, and time consuming activity. In order to support the design and maintenance of data warehouses, we have developed a novel information modeling technique, called Anchor Modeling. A key benefit of Anchor Modeling is that changes in a data warehouse environment only require extensions, not modifications, to a data warehouse. This makes it possible to iteratively model and apply fragments of a data warehouse, which supports agile ways of working. Furthermore, Anchor Modeling results in databases that in many situations perform substantially better than databases constructed using traditional modeling techniques.

Simplified Insert Trigger

The automatically generated insert triggers on the latest views have been simplified such that attribute metadata values default to the anchor metadata value if not specified. This makes insertion into the view (in order to create a new instance of the anchor and all attributes) as simple as the following code shows:

insert into lAC_Actor (
    Metadata_AC,
    AC_NAM_Actor_Name,
    AC_NAM_ValidFrom,
    GEN_Gender,
    PLV_ProfessionalLevel,
    AC_PLV_ValidFrom
)
values (42, 'Lars S', '1972-08-20', 'Male', 'Master', '2009-09-21');

If there is a need to ‘update’ the name this can also be done using the insert trigger on the latest view (given that the surrogate key generated for AC_ID in the previous step was 1):

insert into lAC_Actor (
    AC_ID, 
    AC_NAM_Actor_Name, 
    AC_NAM_ValidFrom,
    Metadata_AC_NAM
)
values (1, 'Lars R', '2004-06-19', 43);