The enhanced data model is a combination of system tables, non configuration tables, and virtual tables

The benefits of enhanced data model are as follows:

• faster provisioning of websites
• faster design studio experiences
• allow website configuration to be contained in solutions to provide smoother ALM experiences
• improved updates of Power Pages enhancements and bug fixes

Enhanced data model consists of following tables:

System Tables

• are Power Pages specific solution aware tables
• Cant be modified
• Table: Site, Site Component, Site Language

Non Config Tables

• Are feature specific tables that contain transactional business data
• Don’t participate in ALM process
• Table E.g. Poll, Invitation, Setting, Portal Comment etc.

Virtual Tables

• Contain metadata of specific website components
• Content can be updated through Power Pages Mgt App

The Standard data model is based on legacy model and exhibits following characteristics:

• Built with custom tables, optimized for configuration of each website component stored as a record in a Dataverse table
• Requires significant time to load solutions, tables, and metadata while provisioning a new site.
• Updates to tables require manual and time consuming application of package updates.