Programming Tech Brief By HackerNoon
This story was originally published on HackerNoon at: https://hackernoon.com/a-unified-namespace-determines-your-historian-schema-not-the-other-way-around [https://hackernoon.com/a-unified-namespace-determines-your-historian-schema-not-the-other-way-around]. Design a historian schema for Unified Namespace architectures. Learn why narrow tables, surrogate keys, and relational namespaces outperform wide models. Check more stories related to programming at: https://hackernoon.com/c/programming [https://hackernoon.com/c/programming]. You can also check exclusive content about #unified-namespace [https://hackernoon.com/tagged/unified-namespace], #uns-data-model-design [https://hackernoon.com/tagged/uns-data-model-design], #database-architecture [https://hackernoon.com/tagged/database-architecture], #timescaledb-iot-schema [https://hackernoon.com/tagged/timescaledb-iot-schema], #isa-95-namespace-architecture [https://hackernoon.com/tagged/isa-95-namespace-architecture], #surrogate-key-historian-design [https://hackernoon.com/tagged/surrogate-key-historian-design], #tag-management [https://hackernoon.com/tagged/tag-management], #good-company [https://hackernoon.com/tagged/good-company], and more. This story was written by: @tigerdata [https://hackernoon.com/u/tigerdata]. Learn more about this writer by checking @tigerdata's [https://hackernoon.com/about/tigerdata] about page, and for more stories, please visit hackernoon.com [https://hackernoon.com]. Most teams design the historian first and connect it to a Unified Namespace later. This article argues the reverse: the UNS owns identity, so it should dictate the historian schema. That means storing tag identity in a relational namespace table with surrogate keys and keeping history in a narrow hypertable. The result: tag renames, hierarchy changes, and churn happen without rewriting history.
100 jaksot
Kommentit
0Ole ensimmäinen kommentoija
Rekisteröidy nyt ja liity Programming Tech Brief By HackerNoon-yhteisöön!