{"id":"https://openalex.org/W2029304361","doi":"https://doi.org/10.1016/0306-4379(95)00034-8","title":"On periodicity in temporal databases","display_name":"On periodicity in temporal databases","publication_year":1995,"publication_date":"1995-12-01","ids":{"openalex":"https://openalex.org/W2029304361","doi":"https://doi.org/10.1016/0306-4379(95)00034-8","mag":"2029304361"},"language":"en","primary_location":{"id":"doi:10.1016/0306-4379(95)00034-8","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0306-4379(95)00034-8","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1016/0306-4379(95)00034-8","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5016384155","display_name":"Alexander Tuzhilin","orcid":"https://orcid.org/0000-0003-3354-8462"},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Alexander Tuzhilin","raw_affiliation_strings":["Information Systems Department, Stern School of Business, New York University, 44 West 4th Street, New York, N.Y. 10012, USA","New York University (NYU) - Leonard N. Stern School of Business"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Information Systems Department, Stern School of Business, New York University, 44 West 4th Street, New York, N.Y. 10012, USA","institution_ids":["https://openalex.org/I57206974"]},{"raw_affiliation_string":"New York University (NYU) - Leonard N. Stern School of Business","institution_ids":["https://openalex.org/I57206974"]}]},{"author_position":"last","author":{"id":null,"display_name":"James Clifford","orcid":null},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James Clifford","raw_affiliation_strings":["Information Systems Department, Stern School of Business, New York University, 44 West 4th Street, New York, N.Y. 10012, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Information Systems Department, Stern School of Business, New York University, 44 West 4th Street, New York, N.Y. 10012, USA","institution_ids":["https://openalex.org/I57206974"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5016384155"],"corresponding_institution_ids":["https://openalex.org/I57206974"],"apc_list":{"value":2970,"currency":"USD","value_usd":2970},"apc_paid":{"value":2970,"currency":"USD","value_usd":2970},"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.18962579,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"20","issue":"8","first_page":"619","last_page":"639"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.8132134675979614},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7139221429824829},{"id":"https://openalex.org/keywords/extension","display_name":"Extension (predicate logic)","score":0.654955267906189},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.5837526321411133},{"id":"https://openalex.org/keywords/expressive-power","display_name":"Expressive power","score":0.5621727705001831},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5426138043403625},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5390206575393677},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.31616222858428955}],"concepts":[{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.8132134675979614},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7139221429824829},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.654955267906189},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.5837526321411133},{"id":"https://openalex.org/C195818886","wikidata":"https://www.wikidata.org/wiki/Q5421724","display_name":"Expressive power","level":2,"score":0.5621727705001831},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5426138043403625},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5390206575393677},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.31616222858428955},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1016/0306-4379(95)00034-8","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0306-4379(95)00034-8","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},{"id":"pmh:http://hdl.handle.net/2451/14214","is_oa":false,"landing_page_url":"http://archive.nyu.edu/handle/2451/14214","pdf_url":null,"source":{"id":"https://openalex.org/S4377196662","display_name":"Faculty Digital Archive (New York University Florence)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210123063","host_organization_name":"New York University Florence","host_organization_lineage":["https://openalex.org/I4210123063"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Working Paper"},{"id":"mag:2029304361","is_oa":true,"landing_page_url":"https://core.ac.uk/display/19480680","pdf_url":null,"source":{"id":"https://openalex.org/S4210172589","display_name":"SSRN Electronic Journal","issn_l":"1556-5068","issn":["1556-5068"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1318003438","host_organization_name":"RELX Group (Netherlands)","host_organization_lineage":["https://openalex.org/I1318003438"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SSRN Electronic Journal","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.93.546","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.93.546","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://archive.nyu.edu/bitstream/2451/14214/1/IS-95-06.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1016/0306-4379(95)00034-8","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0306-4379(95)00034-8","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.7400000095367432,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W13580116","https://openalex.org/W270081759","https://openalex.org/W368257276","https://openalex.org/W1488267121","https://openalex.org/W1501715339","https://openalex.org/W1506588809","https://openalex.org/W1970999740","https://openalex.org/W1971297231","https://openalex.org/W1977662461","https://openalex.org/W1986184086","https://openalex.org/W1992752048","https://openalex.org/W2000616942","https://openalex.org/W2046615742","https://openalex.org/W2067481201","https://openalex.org/W2071578511","https://openalex.org/W2081102106","https://openalex.org/W2083125010","https://openalex.org/W2105505307","https://openalex.org/W2107725559","https://openalex.org/W2116132637","https://openalex.org/W2119984902","https://openalex.org/W2122540544","https://openalex.org/W2126234604","https://openalex.org/W2155756511","https://openalex.org/W2270209511","https://openalex.org/W2806619258","https://openalex.org/W3121451138","https://openalex.org/W3123499134","https://openalex.org/W3124520529","https://openalex.org/W4231113774","https://openalex.org/W6600574539","https://openalex.org/W6610022735","https://openalex.org/W6630046899","https://openalex.org/W6646708787","https://openalex.org/W6648036693","https://openalex.org/W6662029752","https://openalex.org/W6678757868","https://openalex.org/W6682574858","https://openalex.org/W6812613341","https://openalex.org/W6824150723"],"related_works":["https://openalex.org/W1552074874","https://openalex.org/W2120538868","https://openalex.org/W2185884111","https://openalex.org/W2184642783","https://openalex.org/W2563282121","https://openalex.org/W2115125467","https://openalex.org/W2281843957","https://openalex.org/W651145634","https://openalex.org/W2036107151","https://openalex.org/W638142098","https://openalex.org/W2466904488","https://openalex.org/W2529342564","https://openalex.org/W1865649563","https://openalex.org/W2047415097","https://openalex.org/W57650934","https://openalex.org/W120760773","https://openalex.org/W1985479396","https://openalex.org/W2516771247","https://openalex.org/W2055025276","https://openalex.org/W2267038452"],"abstract_inverted_index":{"The":[0],"issue":[1],"of":[2,12,37,54,71,75,84],"periodicity":[3,60],"is":[4],"generally":[5],"understood":[6],"to":[7,39,90,114],"be":[8,17,100],"a":[9,44,117],"desirable":[10],"property":[11],"temporal":[13,20,45,92,103,112],"data":[14],"that":[15],"should":[16],"supported":[18],"by":[19],"database":[21,105],"models":[22],"and":[23,61,64,95,119],"their":[24],"query":[25,93,106],"languages.":[26],"Nevertheless,":[27],"there":[28],"has":[29],"so":[30],"far":[31],"not":[32],"been":[33],"any":[34],"systematic":[35],"examination":[36],"how":[38,66,97],"incorporate":[40],"this":[41,48,76],"concept":[42],"into":[43,102],"DBMS.":[46],"In":[47],"paper":[49],"we":[50,57],"describe":[51],"two":[52,70,86],"concepts":[53],"periodicity,":[55,63],"which":[56],"call":[58],"strong":[59],"near":[62],"discuss":[65],"they":[67,98],"capture":[68],"formally":[69,79],"the":[72,81,110],"intuitive":[73],"meanings":[74],"term.":[77],"We":[78],"compare":[80],"expressive":[82],"power":[83],"these":[85],"concepts,":[87],"relate":[88],"them":[89],"existing":[91],"languages,":[94,107],"show":[96],"can":[99],"incorporated":[101],"relational":[104],"such":[108],"as":[109],"proposed":[111],"extension":[113],"SQL,":[115],"in":[116],"clean":[118],"straightforward":[120],"manner.":[121]},"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-02T09:51:11.867554","created_date":"2025-10-10T00:00:00"}