Hướng dẫn sử dụng arcmap Informational, Transactional
Hướng dẫn cách kết nối với cơ sở dữ liệu PostgreSQL/PostGIS để trích xuất, hiển thị, biên tập (không gian, thuộc tính) bảng ngay trong ArcMap —- Video guides how to connect to PostgreSQL/PostGIS database to extract, display, editing (attribute, spatial information) of table inside ArcMap —– Email: [email protected] Show Related posts[Lecture Notes] Cơ sở dữ liệu địa lý (DH21HM, 9/2023)[Lecture Notes] Cơ sở dữ liệu địa lý (DH20HM, 8/2022)[Lecture Notes] Cơ sở dữ liệu địa lý (DH13KL, 7/2016)Post navigationTransactions are packages of work that make changes to databases. Geographic information system (GIS) databases, like other database applications, must support update transactions that enforce data integrity and application behavior. In many cases, you can use the database management system's transaction framework for managing edits and updates to geodatabases. However, GIS users universally also have some specialized transactional requirements. For example:
Additionally, editors need to be able to undo and redo changes. Editing sessions can span several hours or even days. Often, the edits must be performed in a system that is disconnected from the central, shared database. Because GIS workflow processes may span days or months, the GIS database must remain continuously available for daily operations, where each person connecting to the data might have a personal view or state of the shared GIS database. In a multiuser database, the GIS transactions must be managed on the database management system's short transaction framework. The geodatabase plays a key role during these operations by managing the high-level, complex GIS transactions on the database management system transaction framework. In many cases, long transaction workflows are critical to a GIS. In most instances, these are made possible through the use of an enterprise geodatabase and ArcGIS to manage updates to the central GIS database using versioning, which you can read more about below. The following are examples of GIS data compilation workflows that require a version-based transaction model:
The geodatabase transaction model: Traditional versioningThe geodatabase mechanism for managing these and many other critical GIS workflows is to maintain multiple states in the geodatabase and, most importantly, to do so while ensuring the integrity of the geographic information, rules, and behavior. This ability to manage, work with, and view multiple states is based on versioning. As the name implies, versioning explicitly records versions of individual features and objects as they are modified, added, and retired through various states. Each version explicitly records each state of a feature or object as a row in a table along with important transaction information. Any number of users can simultaneously work with and manage multiple versions. Versions enable all transactions to be recorded as a series of changes to the database through time. This means that various people can work with multiple views or states of the geodatabase. The goal is open, high-performance, multiuser access. For example, the system must go fast and must productively support the use of datasets containing hundreds of millions of records accessed by thousands of clients simultaneously. The geodatabase transaction model based on versions is relatively simple—updates are recorded in change (delta) tables. Versions explicitly record the object states of a geodatabase in two delta tables:
Simple queries are used to view and work with any desired state of the geodatabase, for example, to view the data state for a point in time or see a particular editor's current version with his or her edits. Versioned geodatabases and datasets are used to manage long transactions in each database management system by leveraging the database's short transaction framework. In the version table example, a parcel (number 45) is updated to become parcel number 47. Using versioning, the original parcel is saved in the Deletes table and the new parcel is saved in the Adds table. Other geodatabase system tables record version information about the transaction such as the time and sequence of each update, the version name, and the state ID of each update. Each version also has its own security and access privileges. This enables most clients to work with the Default version while various editors simultaneously make updates to their own versions of the data over time. Numerous updates can be made to each version, and editors connect to and work with the update version as they make additional edits to the data. When editors are ready to share the updates with the rest of the enterprise, reconcile and post operations are performed to commit the edits held in the update version to the parent version. A resolution process is used to identify and reconcile any potential conflicts during this process. |