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.

• Record URL:
  https://doi.org/10.1016/j.proeng.2017.06.089
• Record URL:
  http://www.sciencedirect.com/science/article/pii/S1877705817326358
• Availability:
  • Find a library where document is available. Order URL: http://worldcat.org/issn/18777058
• Supplemental Notes:
  • © 2017 Michal Kvet and Karol Matiaško. Published by Elsevier Ltd.
• Authors:
  • Kvet, Michal
  • Matiaško, Karol
• Conference:
  • 12th International Scientific Conference on Young Scientists on Sustainable, Modern and Safe Transport (TRANSCOM 2017)
  • Location: High Tatras , Slovakia
  • Date: 2017-5-31 to 2017-6-2
• Publication Date: 2017

Language

• English

Media Info

• Media Type: Digital/other
• Features: Figures; References;
• Pagination: pp 516-521
• Serial:
  • Procedia Engineering
  • Volume: 192
  • Issue Number: 0
  • Publisher: Elsevier
  • ISSN: 1877-7058
  • Serial URL: http://www.sciencedirect.com/science/journal/18777058
• Publication flags:

  Open Access (libre)

Subject/Index Terms

• TRT Terms: Data quality; Databases; Information processing; Information systems; Performance measurement; Sensors
• Uncontrolled Terms: Temporal analysis
• Subject Areas: Data and Information Technology; Highways; Planning and Forecasting;

Filing Info

• Accession Number: 01645957
• Record Type: Publication
• Files: TRIS
• Created Date: Sep 12 2017 2:16PM