Temporal Index Location in Multiple Tablespace Type Definitions

Temporal database has been defined using object level granularity in the recent past. The authors developed system uses fine-grained granularity - column or column group. In this paper, the authors 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, the authors 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.

Language

  • English

Media Info

Subject/Index Terms

Filing Info

  • Accession Number: 01645957
  • Record Type: Publication
  • Files: TRIS
  • Created Date: Jun 26 2017 3:17PM