{"id":{"repo_id":"abertay","oai_identifier":"oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"},"canonical_url":"https://search.dev.ndltd.org/etd/abertay/oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85","repository":{"repo_id":"abertay","name":"Abertay University","base_url":"https://rke.abertay.ac.uk/ws/oai"},"display":{"title":"A database query language for operations on historical data","abstract":"Information in most existing database management systems reflects only the current state of the data. However, many real world applications require the storage of and access to historical information. In this thesis a historical model is presented which integrates comprehensive time processing capabilities into the relational model. The role of time in this model is examined, as is the effect of time on relational algebra. An algebra for historical relations is defined.<br/><br/>Finally the Historical Query Language (HQL) is defined and implemented. HQL is designed to allow users to interrogate the historical database in a natural way without referring to the time domain explicitly. HQL has a user friendly syntax and supports user-defined functions and recursion.","abstract_html":"Information in most existing database management systems reflects only the current state of the data. However, many real world applications require the storage of and access to historical information. In this thesis a historical model is presented which integrates comprehensive time processing capabilities into the relational model. The role of time in this model is examined, as is the effect of time on relational algebra. An algebra for historical relations is defined.&lt;br/&gt;&lt;br/&gt;Finally the Historical Query Language (HQL) is defined and implemented. HQL is designed to allow users to interrogate the historical database in a natural way without referring to the time domain explicitly. HQL has a user friendly syntax and supports user-defined functions and recursion.","abstract_has_math":false,"creators":["Sadeghi, Rubik"],"institution":null,"degree_name":"PhD","degree_level":"Doctoral Thesis","degree_discipline":null,"degree_department":null,"school":null,"contributors":[],"advisors":[],"committee_chairs":[],"committee_members":[],"year":1987,"date_issued":"1987-12","date_published":"1987-12","updated_at":"2026-07-24T00:50:16Z","subjects":[],"languages":["eng"],"rights":[],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier","label":"Identifier","values":["oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"],"render_values":[{"text":"oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85","href":null,"code":true}]}]},"links":{"outbound_url":"https://rke.abertay.ac.uk/en/studentTheses/385dba70-b922-4757-b7f1-9a6f4fa19f85","outbound_label":"Repository record","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:creator","label":"Author","values":["Sadeghi, Rubik"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["1987-12"]},{"key":"dc:date.issued","label":"Date","values":["1987-12"]},{"key":"dc:publisher.department","label":"Dc Publisher Department","values":["Dundee College of Technology"]},{"key":"dc:relation.isreferencedby","label":"Dc Relation Isreferencedby","values":["https://rke.abertay.ac.uk/en/studentTheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"]},{"key":"dc:type","label":"Dc Type","values":["Thesis"]},{"key":"dc:type.qualificationlevel","label":"Dc Type Qualificationlevel","values":["Doctoral Thesis"]},{"key":"dc:type.qualificationname","label":"Dc Type Qualificationname","values":["PhD"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["eng"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85","https://rke.abertay.ac.uk/en/studentTheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"]},{"key":"dc:identifier.uri","label":"Identifier URI","values":["https://rke.abertay.ac.uk/files/15666082/Sadeghi_1987_A_database_query_language_for.pdf"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["Information in most existing database management systems reflects only the current state of the data. However, many real world applications require the storage of and access to historical information. In this thesis a historical model is presented which integrates comprehensive time processing capabilities into the relational model. The role of time in this model is examined, as is the effect of time on relational algebra. An algebra for historical relations is defined.<br/><br/>Finally the Historical Query Language (HQL) is defined and implemented. HQL is designed to allow users to interrogate the historical database in a natural way without referring to the time domain explicitly. HQL has a user friendly syntax and supports user-defined functions and recursion."]},{"key":"dc:title","label":"Title","values":["A database query language for operations on historical data"]}]}],"canonical_facts":{"dc:creator":["Sadeghi, Rubik"],"dc:date":["1987-12"],"dc:date.issued":["1987-12"],"dc:description.abstract":["Information in most existing database management systems reflects only the current state of the data. However, many real world applications require the storage of and access to historical information. In this thesis a historical model is presented which integrates comprehensive time processing capabilities into the relational model. The role of time in this model is examined, as is the effect of time on relational algebra. An algebra for historical relations is defined.<br/><br/>Finally the Historical Query Language (HQL) is defined and implemented. HQL is designed to allow users to interrogate the historical database in a natural way without referring to the time domain explicitly. HQL has a user friendly syntax and supports user-defined functions and recursion."],"dc:identifier":["oai:rke.abertay.ac.uk:studenttheses/385dba70-b922-4757-b7f1-9a6f4fa19f85","https://rke.abertay.ac.uk/en/studentTheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"],"dc:identifier.uri":["https://rke.abertay.ac.uk/files/15666082/Sadeghi_1987_A_database_query_language_for.pdf"],"dc:language":["eng"],"dc:publisher.department":["Dundee College of Technology"],"dc:relation.isreferencedby":["https://rke.abertay.ac.uk/en/studentTheses/385dba70-b922-4757-b7f1-9a6f4fa19f85"],"dc:title":["A database query language for operations on historical data"],"dc:type":["Thesis"],"dc:type.qualificationlevel":["Doctoral Thesis"],"dc:type.qualificationname":["PhD"]},"updated_at":"2026-07-24T00:50:16Z"}