In data vault 2.0 can we connect a link and a hub through another link?
In data vault 2.0 can we connect a LINK and a HUB through another LINK? and can we connect 2 links too or there should be always 2 hubs through a link and that's it?
I have an observation LINK, connecting related fields HUB holding info being collected, into observation HUB where it contains the value of those fields: (forgot about field naming, just focus on connections)
No, don't do this. If you read the book, it has a section on link-to-link structure. It's only four paragraphs. The first paragraph tells you what it is, and the remaining tells you why you must not do it, it won't scale, will hurt performance , will cost you more in maintenance, ... And to stick with the definition of links, a link is a relation between 2 or more business entities (hub), and not between a business entity and a relation.
What you should do is to normalize the links to get all business entity hashes you need to define the relationship in one table (link). That way, you won't have to perform unnecessary join in your queries and you won't have to redesign your database if a link change in the future (ie: Link_Observation change it's granularity or it is not used anymore and can be removed)
And this is also respect the Unit-of-Work
- How do I make the registration database for a model agency?
- How big can a user agent string get?
- SQL one to one relationship vs. single table
- Database, Table and Column Naming Conventions?
- Adopting the "aspnet_ ..." sql tables from ASP.NET MVC
- Recommendation for a good Entity-Relationship diagram building tool for occasional usage?
- What's the better database design: more tables or more columns?
- multiple tables broken down into categories vs one table with many columns
- critique of making a separate friend relations table for each user for a social network app
- create the database relationships between users for a social networking site
- When should double validation be implemented with both the database and the backend?
- Which column to index in multicolumn indexing?
- critique of this DB design? retrieve all 2nd degree friends (friends of friends)?
- How can you represent inheritance in a database?
- appropriate design and updating that also handles users updating their profile for a social networking site
- What do oracle database create in the table columns 'SYS_###########'?
- structure data with common and arbitrary attributes for querying all events and then querying for specific event information
- Does "tuples are not necessarily distinct" imply they are equal? How do I show whether this multivalued dependency holds in the example table?
- Database design for a social networking site
- How can I ensure that there is one-and-only-one row in DB table?
- When to use utf-8 and when to use latin1 in MySQL?
- Nullable Foreign Key bad practice?
- comment system where comments may have parents that are also comments but may be practically any resource
- Better way to normalize these tables?
- Should draft records be kept in a separate table?
- What is "implicit meaning" in the context of database design and what do "DBMS" and "DB system language" mean?
- Where Constants should be stored in the database
- Is there a mechanism to set different priorities to ensure that access to postgresql database in golang?
- Integer PK but a GUID as FK
- When to use MongoDB