What is a versioned view?

What is a versioned view?

A versioned view incorporates a database view, stored procedures, triggers, and functions to allow you to use Structured Query Language (SQL) to read or edit data in a geodatabase that has been registered to use traditional versioning.

What is a database view in ArcGIS?

You can use the Create Database View tool or the database context menu in ArcGIS for Desktop to create a database view, or use the native SQL of your database management system (DBMS). Views exist as objects in the database and are not registered with the geodatabase.

Which tool is used to clean up versioned feature class states that are no longer needed?

A compress operation removes states that are not directly referenced by a version (states 1 and 2 in this example) and deletes them from the state tree. The edits they reference in the delta tables are also removed. Unused data in the geodatabase is deleted.

What is archiving ArcGIS?

ArcGIS Pro 2.8 | Other versions | Help archive. Archiving provides the functionality to record and access changes made to all or a subset of data in a geodatabase. Archiving is the mechanism for capturing, managing, and analyzing data change over time.

What are views in a database?

A database view is a subset of a database and is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save frequently used, complex queries.

What is an enterprise geodatabase?

The enterprise geodatabase is the foundation for building a large-scale GIS with ArcGIS Server Enterprise. It uses a combination of ArcObjects, ArcSDE technology, and RDBMS software to define how data is stored, accessed, and managed by ArcGIS. Conceptually, it stores GIS data in a centralized location.

What is the purpose of view in database?

Views are generally used to focus, simplify, and customize the perception each user has of the database. Views can be used as security mechanisms by letting users access data through the view, without granting the users permissions to directly access the underlying base tables of the view.

What do you need to know about versioned view?

What is a versioned view? A versioned view incorporates a database view, stored procedures, triggers, and functions to allow you to read or edit versioned data in a geodatabase table or feature class using Structured Query Language (SQL).

What can you do with versioned views in SQL?

Versioned views allow you to see the edits that are currently stored in the table’s delta tables. Versioned views allow you to edit versioned tables and feature classes using SQL.

Can a view be defined on a database?

You can define views on database or enterprise geodatabase tables. When used with an enterprise geodatabase, database views can be defined for a single nonversioned table or between two nonversioned tables.

How are views defined in an enterprise geodatabase?

There are four types of views you can use in an enterprise geodatabase: Database views are stored queries that select data from specified nonversioned, nonspatial tables. You can define views on database or enterprise geodatabase tables.