top of page
Training Videos
010.010 Introduction to 3D systems
Welcome to our comprehensive series on Enterprise Systems Architecture! In this collection of videos, we delve into the intricacies of designing enterprise systems that are designed from the ground up to be able to exchange data and aggregate it for reporting and AI.
020.010 Architecture Introduction
Introduces a new way of creating enterprise systems that is designed from the ground up to be able to integrate and aggregate data from many systems for reporting.
020.030 Data Dictionary
This video describes the data dictionary information that is maintained for the platform. It discusses the purpose for each column, naming conventions and features that are driven by the data dictionary.
020.040 Data Conversion
This video describes the complete process for converting new systems into the model. It discusses how we reverse engineer systems, automatically generate views to validate the data, create the new schema and populate it.
020.050 Primary Keys
Explore the architecture of Primary Keys in enterprise systems in this video. The agenda covers the goal of establishing a standardized global unique primary method, the existing methods, and the new primary key architecture. Understand the hierarchical governance and functions supporting primary keys, including automatic assignment. Learn about the globally unique identifier for all data, its components, and applications, from contracts to oil and gas wells. The video provides a summary highlighting the efficiency, ease of reference, and support for record governance in this new primary key system.
020.060 Temporal Data
This video discusses the intricacies of temporal data in database design, exploring its definition, configuration, and practical applications. The agenda covers the essence of temporal data, highlighting its need for managing information effectively over time. Drawing distinctions from change history, we delve into historical management approaches and examples spanning payroll, health plans, municipal taxation, and more. Learn how temporal data is configured, understanding segments, start and end dates, and the significance of temporal resolution. Explore querying techniques via query date, current segments, and existing data, along with functions supporting temporal data like spsysTemporalDataUpdate and spsysTemporalDataNormalize. The video includes a Temporal Data Test Script for verification and concludes with a summary encapsulating key insights into the realm of temporal data in database design.
020.070 Change History
Explore the concept of Change History in this video, covering its definition, historical tracking methods, and operational details. Learn how it works, including its initiation by the front end and the creation of records identifying users, commands, timestamps, and modified records. The video discusses change history parameters, viewing options, and key procedures/functions. Discover its benefits, from enhancing security to aiding in debugging and supporting data exchange and AI processes. The unbiased presentation offers a concise overview of change history's significance in enterprise systems.
020.080 Data Exchange - Part 1
Explore Data Exchange, a pivotal element transforming system interaction dynamics. Contrast its handling in the old paradigm with innovative approaches in the new paradigm. Understand the fundamentals: What is Data Exchange? It involves systems broadcasting master data for seamless data aggregation. In the old paradigm, manual processes and challenges were common. Learn about the concept of a subnet, enhancing security and enabling secure data sharing. The Master Data Server on AWS plays a crucial role in housing data for packages, systems, and record governance. Part 1 concludes with insights into structured exchanged data, including subscription data examples.
020.080 Data Exchange - Part 2a
Continuing our exploration of Data Exchange, Part 2 delves into the operational aspects, starting with the Export phase. Discover how systems determine what needs to be exported based on subscription data, ensuring any changes are efficiently broadcasted.
020.080 Data Exchange - Part 2b
Continuing our exploration of Data Exchange, this video discusses the Distribute phase which handles the reception of exports, checks for updates on the Master Data Server, and disseminates updates within the same subnet while posting updates for external subnets.
020.080 Data Exchange - Part 2c
The import process is a critical step that involves applying and managing imported records. This process deals with structural and integrity rule differences.
020.080 Data Exchange - Part 2d
This is the final video related to data exchange. It discusses debugging data exchange, scheduling data exchange jobs, security, scalability and benefits of the data exchange mechanism.
bottom of page