Data Driven
​​​
Taking a data-driven approach, is an important principle of the 3D platform. The 3D Platform employs a data dictionary that acts as an essential repository for metadata, detailing the purpose, default values, constraints, and relationships of database tables and columns. It supports a variety of system utilities including database creation, generation of constraints, data conversions, generation of user friendly views, audit logging, and data exchange.
Metadata at the Core
Consistency is Critical
Consistency in naming conventions is crucial for developer efficiency when creating systems. The data dictionary adheres to strict naming conventions and includes an abbreviation engine that automatically translates short names to long names, eliminating any ambiguity. This is particularly vital for managing large models, like the PPDM Oil and Gas model, which consists of thousands of tables.
​
Extending Core Model Principles to System Data
Similar to how we apply core models and primary keys for business data such as contact information, we extend these principles to system data, including the data dictionary itself. We define core data structures around metadata and use primary keys for each record within the data dictionary. This approach ensures that each piece of metadata is uniquely identifiable and traceable back to its system of origin, standardizing metadata handling across various systems. By treating metadata with the same rigor as business data, we ensure our systems are not only robust but also adhere to the highest standards of data governance and integrity.
​
Future Developments
By managing data dictionary data using core data and primary keys, we will be able to automatically aggregate data from all systems converted into the 3D Platform. Future plans include leveraging machine learning to automate the process of reverse engineering existing systems, mapping them to the 3D model, and adding metadata, which will expedite the conversion of existing systems.
​
Summary
Employing a data dictionary as the foundational architecture in the 3D Enterprise System (3D ES) supports dynamic, metadata-driven functionalities and significantly enhances system flexibility, reliability, and scalability. This strategic approach is crucial for modern enterprises aiming to maintain robust data governance and seamless adaptability within their systems.