DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:struct:dbinternals

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
plugin:struct:dbinternals [2023-03-29 14:31] – [Database Internals] 212.201.117.6plugin:struct:dbinternals [2024-04-22 10:23] (current) – [Data] asheenlevrai
Line 4: Line 4:
 The struct plugin maps a relatively dynamic schema mechanism on a much more rigid relational database system. It also needs to take care that schemas evolve over time, but data in the past has to be preserved and the appropriate schema at that time need to be used. The struct plugin maps a relatively dynamic schema mechanism on a much more rigid relational database system. It also needs to take care that schemas evolve over time, but data in the past has to be preserved and the appropriate schema at that time need to be used.
  
-To do this, schemas in struct do not directly map directly to tables in the database.+To do this, schemas in struct do not directly map to tables in the database.
  
 Generally you should not need to know about any of these internals, but it might be helpful for developers. Generally you should not need to know about any of these internals, but it might be helpful for developers.
Line 64: Line 64:
  
 {{ :plugin:struct:structinternals.png?600 }} {{ :plugin:struct:structinternals.png?600 }}
 +
 +NOTE: correct me if I'm wrong but it seems to me like there is a mistake in the image above.
 +For the //Serial Schema// table:
 +
 +the values for the //field1// column should be aaa (not xyz) for RID=1 and bbb (not zyc) for RID=2, right?
 +
 +Similarly,
 +
 +the values for the //field2// column should be xxx (not 34) for RID=1 and yyy (not 22) for RID=2, right?
  
  
plugin/struct/dbinternals.1680093060.txt.gz · Last modified: 2023-03-29 14:31 by 212.201.117.6

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki