What is an SQL Locator? DBMS uses the logical pointers as identifiers to locate and manipulate the data. A Locator is an SQL3 data-type which acts as a logical pointer to the data on a database server. It also allows manipulation of data on the server. Internally, JDBC uses arrays, BLOB and CLOB data-types but it doesn’t directly address them.
Explain the concepts and capabilities of SQL Locator. SQL Locator is a data type to point the data available in the database server. Locator allows manipulations to the data on the server. JDBC drivers typically uses Locators though the specification is not directly to address them. JDBC drivers uses Locators to handle data of Array, Blob and Clob data in a database table.
When a new Locator is created, a dataset table is created in the geodatabase and it contains the snapshots of the reference data of locator. This includes the attributes and shape information needed in a format that is optimized to quickly search and retrieve the information.