{"title":"用于用户定义周期性的关系代数","authors":"P. Terenziani","doi":"10.1109/DEXA.1999.795233","DOIUrl":null,"url":null,"abstract":"Calendars and periodicity play a fundamental role in many applications. Recently, some commercial databases started to support user-defined periodicity in the queries, providing high level languages to this purpose (e.g., TimeSeries in Oracle 8). On the other hand, existing relational data models do not support user-defined periodicity in the data, with few exceptions. We sketch a high level \"symbolic\" language for representing periodicity in a \"human oriented\" way, and propose a temporal relational model which supports user-defined \"symbolic\" periodicity in the validity time of tuples. We also define the temporal counterpart of the standard operators of the relational algebra, and introduce new temporal operators and functions. Finally, we sketch a symbolic implementation of the algebraic operators.","PeriodicalId":276867,"journal":{"name":"Proceedings. Tenth International Workshop on Database and Expert Systems Applications. DEXA 99","volume":"26 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1999-09-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":"{\"title\":\"A relational algebra for user-defined periodicity\",\"authors\":\"P. Terenziani\",\"doi\":\"10.1109/DEXA.1999.795233\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Calendars and periodicity play a fundamental role in many applications. Recently, some commercial databases started to support user-defined periodicity in the queries, providing high level languages to this purpose (e.g., TimeSeries in Oracle 8). On the other hand, existing relational data models do not support user-defined periodicity in the data, with few exceptions. We sketch a high level \\\"symbolic\\\" language for representing periodicity in a \\\"human oriented\\\" way, and propose a temporal relational model which supports user-defined \\\"symbolic\\\" periodicity in the validity time of tuples. We also define the temporal counterpart of the standard operators of the relational algebra, and introduce new temporal operators and functions. Finally, we sketch a symbolic implementation of the algebraic operators.\",\"PeriodicalId\":276867,\"journal\":{\"name\":\"Proceedings. Tenth International Workshop on Database and Expert Systems Applications. DEXA 99\",\"volume\":\"26 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1999-09-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"2\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings. Tenth International Workshop on Database and Expert Systems Applications. DEXA 99\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/DEXA.1999.795233\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings. Tenth International Workshop on Database and Expert Systems Applications. DEXA 99","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/DEXA.1999.795233","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Calendars and periodicity play a fundamental role in many applications. Recently, some commercial databases started to support user-defined periodicity in the queries, providing high level languages to this purpose (e.g., TimeSeries in Oracle 8). On the other hand, existing relational data models do not support user-defined periodicity in the data, with few exceptions. We sketch a high level "symbolic" language for representing periodicity in a "human oriented" way, and propose a temporal relational model which supports user-defined "symbolic" periodicity in the validity time of tuples. We also define the temporal counterpart of the standard operators of the relational algebra, and introduce new temporal operators and functions. Finally, we sketch a symbolic implementation of the algebraic operators.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
