Temporal Index Location in Multiple Tablespace Type Definitions

Temporal database has been defined using object level granularity in the recent past. Our develoved system uses fine-grained granularity - column or column group. In this paper, we propose developed approach, but mostly highlight the performance with regards tablespace type for data location. Tablespace as intermediate layer between database instance and data files themselves is mainly characterized by the location, size and structure. Block size database parameter is fixed and cannot be changed after database creation at all. In this paper, we use multiple size and structure of the block in the tablespace and compare the performance based on temporal access queries. Such concepts and solutions can be used in any information system dealing with time limited validity objects as well as sensor data processing.