Chapter 1. Introduction

MobilityDB is an extension of PostgreSQL and PostGIS that provides temporal types. Such data types represent the evolution on time of values of some element type, called the base type of the temporal type. For instance, temporal integers may be used to represent the evolution on time of the the gear used by a moving car. In this case, the data type is temporal integer and the base type is integer. Similarly, a temporal float may be used to represent the evolution on time of the speed of a car. As another example, a temporal point may be used to represent the evolution on time of the location of a car, as reported by GPS devices. Temporal types are useful because representing values that evolve in time is essential in many applications, for example in mobility applications. Furthermore, the operators on the base types (such as arithmetic operators and aggregation for integers and floats, spatial relationships and distance for geometries) can be intuitively generalized when the values evolve in time.

MobilityDB provides the following temporal types: tbool, tint, tfloat, ttext, tgeompoint, and tgeogpoint. These temporal types are based, respectively, on the bool, integer, float, and text base types provided by PostgreSQL, and on the geometry and geography base types provided by PostGIS (restricted to 2D or 3D points).^[1] Furthermore, MobilityDB provides set, span, and span set template types for representing, respectively, sets of values, ranges of values, and sets of ranges of values of base types or time types. Examples of values of set types are intset, floatset, and tstzset, where the latter represents set of timestamptz values. Examples of values of span types are intspan, floatspan, and tstzspan. Examples of values of span set types are intspanset, floatspanset, and tstzspanset.