A spatiotemporal database is a database that manages both space and time information. Common examples include: * Tracking of moving objects, which typically can occupy only a single position at a given time. * A database of wireless communication networks, which may exist only for a short timespan within a geographic region. * An index of species in a given geographic region, where over time additional species may be introduced or existing species migrate or die out. * Historical tracking of plate tectonic activity. Spatiotemporal databases are an extension of

spatial database A spatial database is a general-purpose database (usually a relational database) that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data. Most ...

s and

temporal database A temporal database stores data relating to time instances. It offers temporal data types and stores information relating to past, present and future time. Temporal databases can be uni-temporal, bi-temporal or tri-temporal. More specifically the ...

s. A spatiotemporal database embodies spatial, temporal, and spatiotemporal database concepts, and captures spatial and temporal aspects of data and deals with: * Geometry changing over time and/or * Location of objects moving over invariant geometry (known variously as ''moving objects databases'' or

real-time locating system Real-time locating systems (RTLS), also known as real-time tracking systems, are used to automatically identify and track the location of objects or people in real time, usually within a building or other contained area. Wireless RTLS tags are ...

s).

Implementations

Although there exist numerous

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

s with spatial extensions, spatiotemporal databases are not based on the

relational model The relational model (RM) is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data are represented in terms of t ...

for practical reasons, chiefly among them that the data is multi-dimensional, capturing complex structures and behaviours. As of 2008, there are no

RDBMS A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured forma ...

products with spatiotemporal extensions. There are some products such as the open-source TerraLib which use a

middleware Middleware is a type of computer software program that provides services to software applications beyond those available from the operating system. It can be described as "software glue". Middleware makes it easier for software developers to imple ...

approach storing their data in a relational database. Unlike in the pure spatial domain, there are however no official or ''de facto'' standards for spatiotemporal data models and their querying. In general, the theory of this area is also less well-developed. Another approach is the constraint database system such as MLPQ (Management of Linear Programming Queries). GeoMesa is an

open-source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use and view the source code, design documents, or content of the product. The open source model is a decentrali ...

distributed spatiotemporal index built on top of Bigtable-style databases using an implementation of the Z-order curve to create a multi-dimensional index combining space and time.
SpaceTime
is a commercial spatiotemporal database built on top of the proprietary multidimensional index similar to the ''k''-d tree family, but created using the bottom-up approach and adapted to particular space–time distribution of data. In a study conducted by

Ericsson (), commonly known as Ericsson (), is a Swedish multinational networking and telecommunications company headquartered in Stockholm, Sweden. Ericsson has been a major contributor to the development of the telecommunications industry and is one ...

, SpaceTime significantly outperformed GeoMesa.

References

External links

Organizations

* https://vldb.org/ (Very Large Databases) * https://www.dexa.org/ (Database and Expert Systems Applications)