equal format data systems
DESCRIPTION
Design for the Future. Equal Format Data Systems. The Future of Data. For the DBA. Relational Design Methods: Efficiency through Normalization. Reducing empty space and increasing flexibility by clustering around entity types and attribute groups. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/1.jpg)
Design for the Future
The Future of Data
For the DBA
![Page 2: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/2.jpg)
Reducing empty space and increasing flexibility by clustering around entity types and attribute groups
![Page 3: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/3.jpg)
Real world entities have many possible simple relationships.
Simple General-Purpose Relationship Table
![Page 4: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/4.jpg)
Multiple entity tables. N2 possible relationships.
![Page 5: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/5.jpg)
Putting everything with options into the same entity table leads to lots of unused space.
Old Entity Table
![Page 6: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/6.jpg)
Attributes are equivalent to relations.
Relationship Types are also entities.
![Page 7: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/7.jpg)
Change the Entities to Phrases.
Change the Relations to Semantic Triplet Sentences.
Triplet Sentence Table Phrase Table
![Page 8: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/8.jpg)
Phrase Table Allows any data type
in any “cell”.
Common value types are pooled and indexed.
ValueFloatTable
![Page 9: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/9.jpg)
Phrase Table
Used for Project management, Security filtering
Used for metadata in the style of “(S1) was captured by (Device19)”.
![Page 10: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/10.jpg)
This table requires either more phrases in a sentence or more sentences.
Complex Relationship Table Example
![Page 11: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/11.jpg)
![Page 12: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/12.jpg)
Allows more phrases per sentence, more phrases per syntax position, and more syntax positions (metadata).
Now you can select “tables” and “columns” the same way as rows.
![Page 13: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/13.jpg)
Value Sentence Table
The sentence table can now hold any complex relationship.
![Page 14: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/14.jpg)
The old design pattern - meaning is dependent on the row and column positions in each table.
The new design pattern - pieces of Equal Format Data.
This Old Table
Tables of Equal Format Data
![Page 15: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/15.jpg)
Atomic data can be modified non-destructively more efficiently with less locking.
Nondestructive storage can maintain a running snapshot
Common container types reduce N2 complexity in coding, point-to-point conversions and messaging.
Development is de-linked from structural dependency.
Reusable structures encourage reusable code and common dictionaries.
Atomic data enables multiple inheritance
![Page 16: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/16.jpg)
There are many ways to say it – keep it simple.
Try to be less ambiguous and use stricter and simpler syntax.
It’s easier to change the vocabulary than change the structure.
More wordiness uses space but adds meaning.
Compared to traditional design, it uses more space per cell when nonempty, but no space per cell when empty.
Repeat the container as multiple “subsystems” to tune the structure
![Page 17: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/17.jpg)
Master Data Storage
Messaging Systems
Data Warehousing, Data Marts, and Data Mining
Security, Auditing, Quality Control
Merging Legacy Information
Facility Data and PLM Data
Engineering Project Management
Product Catalog Data
Development Infrastructure
![Page 18: Equal Format Data Systems](https://reader036.vdocuments.us/reader036/viewer/2022062321/56813044550346895d95e81a/html5/thumbnails/18.jpg)
+1 (734) 878-0109 voice+1 (734) 878-0684 fax
www.datura-llc.com
Datura, LLCPO Box 498Howell, MI 48844-0498USA