Architectural Principles SQL View Definitions
Data models, starting with version 3.5, may include view definitions as part of the model deliverables. These view definitions may be particularly useful in cases where a generic table can be made easier to understand or use through views.
Contents |
XREF Tables
Cross reference tables, particularly where they are used to cross reference values in a super-sub type implementation, may be used to view special types of relationships.
Example:
- LR_XREF views for relationships Title to lease, lease to part of lease, unit to unit tract etc.
Spatial Views
Spatially enabling information comes with a cost; specifically you can only effectively query information contained in the business table that has been spatially enabled. Views that flatten information for query purposes may be created. Note that PPDM Lite contains definitions for flattened representations of data that have been created through the PPDM work group process.
Go to
- Architectural Principles NULL Data
- Architectural Principles Dates
- Architectural Principles Versioning
- Architectural Principles Vertical Tables
- Architectural Principles Sequence Control
- Architectural Principles Economics and Financial
- Architectural Principles Column Precision
- Architectural Principles Column Field Type
- Architectural Principles Standardized Columns
- Architectural Principles SQL View Definitions
- Architectural Principles Other SQL Definitions
