{"id":"https://openalex.org/W1555412276","doi":null,"title":"An Introduction to ULDBs and the Trio System","display_name":"An Introduction to ULDBs and the Trio System","publication_year":2006,"publication_date":"2006-01-01","ids":{"openalex":"https://openalex.org/W1555412276","mag":"1555412276"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.87.2878","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.87.2878","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://infolab.stanford.edu/~widom/cs145/trio-paper.pdf","raw_type":"text"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103212061","display_name":"Omar Benjelloun","orcid":"https://orcid.org/0000-0002-4173-7709","observed_orcids":["https://orcid.org/0000-0002-4173-7709","https://orcid.org/0000-0001-9803-3801"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Omar Benjelloun","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-4173-7709","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114259175","display_name":"Anish Das Sarma","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anish Das Sarma","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010641271","display_name":"Chris Hayworth","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chris Hayworth","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5010857944","display_name":"Jennifer Widom","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jennifer Widom","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":26.69,"has_fulltext":false,"cited_by_count":86,"citation_normalized_percentile":{"value":0.99562197,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":"29","issue":null,"first_page":"5","last_page":"16"},"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.9916999936103821,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9916999936103821,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.004999999888241291,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/data-lineage","display_name":"data lineage","score":0.6769999861717224},{"id":"https://openalex.org/keywords/sql-extension","display_name":"SQL extension","score":0.6549999713897705},{"id":"https://openalex.org/keywords/query-semantics","display_name":"query semantics","score":0.8519999980926514},{"id":"https://openalex.org/keywords/confidence-scores","display_name":"confidence scores","score":0.652999997138977},{"id":"https://openalex.org/keywords/query-translation","display_name":"query translation","score":0.4830000102519989}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9132177829742432},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7953554391860962},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5796151161193848},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5485820770263672},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.524050235748291},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.47630059719085693},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.43139517307281494},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.42475682497024536},{"id":"https://openalex.org/C2776817793","wikidata":"https://www.wikidata.org/wiki/Q6553369","display_name":"Lineage (genetic)","level":3,"score":0.4163309931755066},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3855687379837036},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2514854073524475},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.22977951169013977},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.87.2878","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.87.2878","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://infolab.stanford.edu/~widom/cs145/trio-paper.pdf","raw_type":"text"},{"id":"mag:1555412276","doi":null,"is_oa":false,"landing_page_url":"http://dbpubs.stanford.edu:8090/pub/2006-7","pdf_url":null,"source":{"id":"https://openalex.org/S62003192","display_name":"IEEE Data(base) Engineering Bulletin","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"IEEE Data(base) Engineering Bulletin","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W46556314","https://openalex.org/W108458627","https://openalex.org/W1486776102","https://openalex.org/W1552694902","https://openalex.org/W1582521812","https://openalex.org/W1716383435","https://openalex.org/W1779256329","https://openalex.org/W1899647947","https://openalex.org/W1983178058","https://openalex.org/W1990391007","https://openalex.org/W2024400846","https://openalex.org/W2050171146","https://openalex.org/W2072269087","https://openalex.org/W2072960837","https://openalex.org/W2078686663","https://openalex.org/W2098395122","https://openalex.org/W2100153179","https://openalex.org/W2104576390","https://openalex.org/W2111465715","https://openalex.org/W2125399128","https://openalex.org/W2125791539","https://openalex.org/W2129035130","https://openalex.org/W2134978478","https://openalex.org/W2140757415","https://openalex.org/W2149640777","https://openalex.org/W2166916904","https://openalex.org/W2171588311"],"related_works":["https://openalex.org/W2182230244","https://openalex.org/W7100729945","https://openalex.org/W2166916904","https://openalex.org/W2126880670","https://openalex.org/W2991638425","https://openalex.org/W2088422262","https://openalex.org/W7098961088","https://openalex.org/W2144346642","https://openalex.org/W841859283","https://openalex.org/W7099021628"],"abstract_inverted_index":{"We":[0,27,63,89],"introduce":[1],"ULDBs:":[2],"relational":[3],"databases":[4],"that":[5],"add":[6],"uncertainty":[7],"and":[8,49,51,60,78,96],"lineage":[9,59],"of":[10],"the":[11,20,29,87,97],"data":[12],"as":[13],"first-class":[14],"concepts.":[15],"The":[16],"ULDB":[17,30],"model":[18],"underlies":[19],"Trio":[21,70,98],"system":[22],"under":[23],"development":[24],"at":[25],"Stanford.":[26],"describe":[28,66],"model,":[31],"then":[32],"present":[33],"TriQL,":[34],"our":[35,67],"SQL-based":[36],"query":[37],"language":[38],"for":[39,57,94],"ULDBs.":[40],"TriQL's":[41],"semantics":[42],"over":[43,86],"ULDBs":[44,74,95],"is":[45],"defined":[46],"both":[47],"formally":[48],"operationally,":[50],"TriQL":[52,81],"extends":[53],"SQL":[54,84],"with":[55,91],"constructs":[56],"querying":[58],"confidence":[61],"values.":[62],"also":[64],"briefly":[65],"initial":[68],"prototype":[69],"implementation,":[71],"which":[72],"encodes":[73],"in":[75],"conventional":[76],"relations":[77],"automatically":[79],"translates":[80],"queries":[82],"into":[83],"commands":[85],"encoding.":[88],"conclude":[90],"research":[92],"directions":[93],"system.":[99]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-09T13:22:03.289127","created_date":"2016-06-24T00:00:00"}