Anchor Modeling is an agile database modeling technique suited for information that changes over time both in structure and content.
Read about anchor modeling on wikipedia or see founders page.
Questions tagged [anchor-modeling]
11 questions
22
votes
5 answers
Temporal database design, with a twist (live vs draft rows)
I'm looking into implementing object-versioning with the added twist of needing to have both live and draft objects, and could use the insights from someone experience in this, as I'm beginning to wonder if it's even possible without potentially…
Denis de Bernardy
- 75,850
- 13
- 131
- 154
18
votes
5 answers
What are the pros and cons of Anchor Modeling?
I am currently trying to create a database where a very large percentage of the data is temporal. After reading through many techniques for doing this (most involving 6nf normalization) I ran into Anchor Modeling.
The schema that I was developing…
Chuu
- 4,301
- 2
- 28
- 54
15
votes
7 answers
Are there any data warehouse frameworks?
I've got a lot of mysql data that I need to generate reports from. It's mostly historic data so it won't be changing much, but it weighs in at 20-30 gigabytes easily and is expected to grow. I currently have a collection of php scripts that will do…
reconbot
- 5,138
- 6
- 45
- 63
9
votes
5 answers
Join elimination not working in Oracle with sub queries
I am able to get join elimination to work for simple cases such as one-to-one relations, but not for slightly more complicated scenarios.
Ultimately I want to try anchor modelling, but first I need to find a way around this problem. I'm using Oracle…
Ronnis
- 12,593
- 2
- 32
- 52
2
votes
1 answer
What is meant by non-destructive schema evolution in Anchor Modeling?
Say you have an Anchor Model and replace a single Name attribute with three attributes: FirstName, MiddleName and LastName. What happens to the original name attribute? I can imagine other schema changes that feel destructive, so what is meant by…
jl6
- 6,110
- 7
- 35
- 65
1
vote
0 answers
EMF (OCL) concatenate two enumerations into one
I wonder if EMF has a possibility to concatenate two enumerations into one?
I am building model representing card game, and I have two enumerations of Ranks and Suits in class Card. I would like to create combined enumeration in class Deck. Is there…
Bubuta
- 13
- 6
1
vote
1 answer
How to send data from OLE DB source to Anchor model tables using ETL procedure?
I'm currently solving this task: some data should be sent from AdventureWorks2012 to Anchor model tables on the same server in MsSQL.
This is my Anchor Model
At this point I have a pretty simple Integration Services project in Visual Studio and…
erkatya90
- 61
- 5
0
votes
0 answers
Managing Entity Resolution in Anchor Modeling
I've been reading about anchor modeling and really like the concept. My hope is to possibly incorporate it into a data management framework where I consolidate multiple data sources into an anchor model, then either make it directly available or…
Pickle
- 33
- 8
0
votes
1 answer
Anchor modeling - tie: make first role?
Short question related to official anchor modeler.
While modeling ties you can setup roles properties, one of them is "first role".
What does "Make first role" option do?
I see in the xml/sql file it swaps the roles order within a Tie.
Is it only a…
jangorecki
- 16,384
- 4
- 79
- 160
0
votes
1 answer
Anchor Modeling - are data types part of the Model?
A question about data types in the Anchor Model database design. The question assume separation of anchor model implementation from the anchor model itself.
In the Anchor Model xml we have following kind information related to data…
jangorecki
- 16,384
- 4
- 79
- 160
0
votes
2 answers
Agile/evolutionary database modelling for an evolving content management application
Just to be clear, when I say Agile I don't mean as in the Agile development process. I mean an evolving data model where new object attributes can be added and managed.
I'm trying to tackle a web application challenge which allows users to create…
dubmojo
- 6,660
- 8
- 41
- 68