{"title":"扩展时态查询语言以处理不精确的时间间隔","authors":"M.A. Bassiouni, M. Llewellyn","doi":"10.1016/S0096-0551(99)00003-X","DOIUrl":null,"url":null,"abstract":"<div><p>Previous work on temporal and historical databases has been mainly based on the assumption that the time intervals of temporal attributes and the start/finish points of modeled events are precisely known. In many real life situations, however, the time boundary of events and the duration of entity relationships may not be exactly known. Modeling these situations and providing a way to write queries dealing with time impreciseness represents a useful extension currently lacking in existing/proposed temporal database systems. In this paper, we discuss the problem of handling time impreciseness in temporal databases and present three models for the representation of imprecise time intervals. We illustrate the basic idea and motivation of each model, its underlying logic, tradeoffs, and important properties. We also propose query language extensions that can enrich the user interface with capabilities to formulate queries dealing with time impreciseness. Extensions to existing query constructs at both the transaction level and the operator level are presented. New operators related to time impreciseness are also presented. The models and extensions discussed in this paper enrich the flexibility of temporal databases and can be used to help users obtain more meaningful replies for their temporal queries.</p></div>","PeriodicalId":100315,"journal":{"name":"Computer Languages","volume":"25 1","pages":"Pages 39-54"},"PeriodicalIF":0.0000,"publicationDate":"1999-04-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://sci-hub-pdf.com/10.1016/S0096-0551(99)00003-X","citationCount":"2","resultStr":"{\"title\":\"Extending temporal query languages to handle imprecise time intervals\",\"authors\":\"M.A. Bassiouni, M. Llewellyn\",\"doi\":\"10.1016/S0096-0551(99)00003-X\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<div><p>Previous work on temporal and historical databases has been mainly based on the assumption that the time intervals of temporal attributes and the start/finish points of modeled events are precisely known. In many real life situations, however, the time boundary of events and the duration of entity relationships may not be exactly known. Modeling these situations and providing a way to write queries dealing with time impreciseness represents a useful extension currently lacking in existing/proposed temporal database systems. In this paper, we discuss the problem of handling time impreciseness in temporal databases and present three models for the representation of imprecise time intervals. We illustrate the basic idea and motivation of each model, its underlying logic, tradeoffs, and important properties. We also propose query language extensions that can enrich the user interface with capabilities to formulate queries dealing with time impreciseness. Extensions to existing query constructs at both the transaction level and the operator level are presented. New operators related to time impreciseness are also presented. The models and extensions discussed in this paper enrich the flexibility of temporal databases and can be used to help users obtain more meaningful replies for their temporal queries.</p></div>\",\"PeriodicalId\":100315,\"journal\":{\"name\":\"Computer Languages\",\"volume\":\"25 1\",\"pages\":\"Pages 39-54\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1999-04-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"https://sci-hub-pdf.com/10.1016/S0096-0551(99)00003-X\",\"citationCount\":\"2\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Computer Languages\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://www.sciencedirect.com/science/article/pii/S009605519900003X\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Computer Languages","FirstCategoryId":"1085","ListUrlMain":"https://www.sciencedirect.com/science/article/pii/S009605519900003X","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Extending temporal query languages to handle imprecise time intervals
Previous work on temporal and historical databases has been mainly based on the assumption that the time intervals of temporal attributes and the start/finish points of modeled events are precisely known. In many real life situations, however, the time boundary of events and the duration of entity relationships may not be exactly known. Modeling these situations and providing a way to write queries dealing with time impreciseness represents a useful extension currently lacking in existing/proposed temporal database systems. In this paper, we discuss the problem of handling time impreciseness in temporal databases and present three models for the representation of imprecise time intervals. We illustrate the basic idea and motivation of each model, its underlying logic, tradeoffs, and important properties. We also propose query language extensions that can enrich the user interface with capabilities to formulate queries dealing with time impreciseness. Extensions to existing query constructs at both the transaction level and the operator level are presented. New operators related to time impreciseness are also presented. The models and extensions discussed in this paper enrich the flexibility of temporal databases and can be used to help users obtain more meaningful replies for their temporal queries.