Spatial Databases

PostGIS database is best suited ¬†to store geographic data . Scaling GIS Data in non-relational data stores is easy due to the nature of its architecture. Some of the Spatial Databases in addition to POSTGIS are Oracle RDBMS with Spatial or Locator IBM DB2 with Spatial Extender IBM Informix with Spatial Blade MongoDB¬†supports two-dimensional¬†geospatial indexes….

SQL Commands

Database Tables A database most often contains one or more tables. Each table is identified by a name (e.g. “Customers” or “Orders”). Tables contain records (rows) with data.Below is an example of a table called “Persons”: P_Id LastName FirstName  Address City 1 Hansen Ola Timoteivn            Sandnes 2 Svendson Tove Borgvn                Sandnes 3 Pettersen Kari Storgt                    Stavanger…

Naming Convention for Databases

Essential Guidelines for Database Naming Conventions Naming Convention use lowercase characters eliminates question of proper case as well as errors related to case-sensitivity speeds typing rate and accuracy differentiates table and column names from uppercase SQL keywords Note:- (Case Sensitivity:-The case sensitivity of the database depends on the operating system being installed. In Unix filesystems,…

Installing Postgresql On Ubuntu 12.04

Following are the variation for Ubuntu 12.04  from the book beginning PostgreSQL by Neil Mathewadduser postgres Creating the Database DirectoryNext, you must create, as root, the directory PostgreSQL is going to use for its databases andchange its owner to be postgres:mkdir /usr/lib/postgresql/9.1/datachown postgres /usr/lib/postgresql/9.1/dataHere, we are using the default location for the database. You might…