Question

Assuming that the DBMS does not provide a circular spatial bounding function (point, radius), explain how a bounding polygon function could be developed to provide a substitute for this function, and how accuracy of this approximation might be increased.

Answer 1

Spatial RDBMS is an RDBMS that know how to method spatial data. well-liked RDBMSs, such as Oracle, present their possess Spatial RDBMS features or add-ons hence that spatial data can be process.
while all DBMS has a unusual architecture, it is not easy to show how it operate during a simple diagram. However we can explain at least the theory of a spatial DBMS through the following diagram.

Spatial RDBMS allow to make use of SQL data types, such as int and varchar, as well as spatial data types, such as position, Line string and Polygon for geometric calculations like space or relationships linking shapes.
RDBMS uses the B-Tree series or Hash Function to procedure indexes (see CUBRID Query Tuning Techniques for more clarification), mostly to resolve the size or redundancies of column value. In other words, only one-dimensional statistics can be process. Since spatial data types are two or three dimensional:
R-Tree series or Quad Trees can beable to used in Spatial RDBMS to process such data;
Or it is compulsory to transform two or three dimensional data to one dimensional data, afterward B-Tree can be used.
Many benefits go after if the accessible RDBMS is extended to method spatial data. First, even when conducting geo-spatial tasks, there will be many occasion when basic data types, such as numbers or characters, are used. An additional benefit is that present will not be a trouble of extra training, since SQL is previously a verified solution which can fruitfully store the data.
RDBMS is not the only database management system on hand. similarly, spatial RDBMS is not the only spatial database management system available. A lot of databases, such as Mongo DB, the document-oriented database, look for engines such as Lucene or Solr, afford spatial data processing features. However, these solutions suggest less features and do not provide high accuracy calculations. To know what high precision calculations stand for, we will get a closer look at the features a spatial DBMS provides.