{"id":"https://openalex.org/W2081646851","doi":"https://doi.org/10.1145/1734663.1734678","title":"A schema for describing a relational data base","display_name":"A schema for describing a relational data base","publication_year":1970,"publication_date":"1970-01-01","ids":{"openalex":"https://openalex.org/W2081646851","doi":"https://doi.org/10.1145/1734663.1734678","mag":"2081646851"},"language":"en","primary_location":{"id":"doi:10.1145/1734663.1734678","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1734663.1734678","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1734663.1734678","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1970 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control - SIGFIDET '70","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1734663.1734678","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068712490","display_name":"Andrew J. Symonds","orcid":null},"institutions":[{"id":"https://openalex.org/I4210087032","display_name":"Cambridge Scientific (United States)","ror":"https://ror.org/001s4dh65","country_code":"US","type":"company","lineage":["https://openalex.org/I4210087032"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Andrew J. Symonds","raw_affiliation_strings":["IBM Corporation Cambridge Scientific Center 5k5 Techno]ogy Square Cambridge, Mass. 02139","IBM Corporation, Cambridge Scientific Center, Cambridge, Mass"],"affiliations":[{"raw_affiliation_string":"IBM Corporation Cambridge Scientific Center 5k5 Techno]ogy Square Cambridge, Mass. 02139","institution_ids":["https://openalex.org/I4210087032"]},{"raw_affiliation_string":"IBM Corporation, Cambridge Scientific Center, Cambridge, Mass","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018265587","display_name":"Raymond A. Lorie","orcid":null},"institutions":[{"id":"https://openalex.org/I4210087032","display_name":"Cambridge Scientific (United States)","ror":"https://ror.org/001s4dh65","country_code":"US","type":"company","lineage":["https://openalex.org/I4210087032"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Raymond A. Lorie","raw_affiliation_strings":["IBM Corporation Cambridge Scientific Center 5k5 Techno]ogy Square Cambridge, Mass. 02139","IBM Corporation, Cambridge Scientific Center, Cambridge, Mass"],"affiliations":[{"raw_affiliation_string":"IBM Corporation Cambridge Scientific Center 5k5 Techno]ogy Square Cambridge, Mass. 02139","institution_ids":["https://openalex.org/I4210087032"]},{"raw_affiliation_string":"IBM Corporation, Cambridge Scientific Center, Cambridge, Mass","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5068712490"],"corresponding_institution_ids":["https://openalex.org/I4210087032"],"apc_list":null,"apc_paid":null,"fwci":1.4502,"has_fulltext":true,"cited_by_count":7,"citation_normalized_percentile":{"value":0.86695589,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"230","last_page":"230"},"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.9934999942779541,"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.9934999942779541,"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.9567999839782715,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9314000010490417,"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/ibm","display_name":"IBM","score":0.8958886861801147},{"id":"https://openalex.org/keywords/citation","display_name":"Citation","score":0.6900858879089355},{"id":"https://openalex.org/keywords/corporation","display_name":"Corporation","score":0.6793370246887207},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6439360976219177},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5754848122596741},{"id":"https://openalex.org/keywords/center","display_name":"Center (category theory)","score":0.43833670020103455},{"id":"https://openalex.org/keywords/research-center","display_name":"Research center","score":0.41818565130233765},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.4044254422187805},{"id":"https://openalex.org/keywords/library-science","display_name":"Library science","score":0.37571409344673157},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2093680202960968},{"id":"https://openalex.org/keywords/political-science","display_name":"Political science","score":0.0826212465763092}],"concepts":[{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.8958886861801147},{"id":"https://openalex.org/C2778805511","wikidata":"https://www.wikidata.org/wiki/Q1713","display_name":"Citation","level":2,"score":0.6900858879089355},{"id":"https://openalex.org/C2778348171","wikidata":"https://www.wikidata.org/wiki/Q167037","display_name":"Corporation","level":2,"score":0.6793370246887207},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6439360976219177},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5754848122596741},{"id":"https://openalex.org/C2779463800","wikidata":"https://www.wikidata.org/wiki/Q5062222","display_name":"Center (category theory)","level":2,"score":0.43833670020103455},{"id":"https://openalex.org/C2777532764","wikidata":"https://www.wikidata.org/wiki/Q31855","display_name":"Research center","level":2,"score":0.41818565130233765},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4044254422187805},{"id":"https://openalex.org/C161191863","wikidata":"https://www.wikidata.org/wiki/Q199655","display_name":"Library science","level":1,"score":0.37571409344673157},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2093680202960968},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0826212465763092},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C8010536","wikidata":"https://www.wikidata.org/wiki/Q160398","display_name":"Crystallography","level":1,"score":0.0},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1734663.1734678","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1734663.1734678","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1734663.1734678","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1970 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control - SIGFIDET '70","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/1734663.1734678","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1734663.1734678","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1734663.1734678","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1970 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control - SIGFIDET '70","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2081646851.pdf","grobid_xml":"https://content.openalex.org/works/W2081646851.grobid-xml"},"referenced_works_count":3,"referenced_works":["https://openalex.org/W2022843269","https://openalex.org/W2104880663","https://openalex.org/W2165467455"],"related_works":["https://openalex.org/W2016917647","https://openalex.org/W2027780767","https://openalex.org/W2064146555","https://openalex.org/W2084686108","https://openalex.org/W2062285040","https://openalex.org/W2111444092","https://openalex.org/W2090903439","https://openalex.org/W1986355004","https://openalex.org/W1567716877","https://openalex.org/W1991953542"],"abstract_inverted_index":{"research-article":[0],"Free":[1],"Access":[2,69],"Share":[3],"on":[4,66,119],"A":[5],"schema":[6],"for":[7],"describing":[8],"a":[9,105,137],"relational":[10],"data":[11],"base":[12],"Authors:":[13],"Andrew":[14],"J.":[15],"Symonds":[16],"IBM":[17,24,36,43],"Corporation,":[18,25,37,44],"Cambridge":[19,26,38,45],"Scientific":[20,27,39,46],"Center,":[21,28,40,47],"Cambridge,":[22,29,41,48],"Mass.":[23,42],"Mass.View":[30,49],"Profile":[31,50],",":[32],"Raymond":[33],"A.":[34],"Lorie":[35],"Authors":[51],"Info":[52],"&":[53],"Claims":[54],"SIGFIDET":[55,62],"'70:":[56],"Proceedings":[57],"of":[58],"the":[59,120],"1970":[60,72],"ACM":[61],"(now":[63],"SIGMOD)":[64],"Workshop":[65],"Data":[67],"Description,":[68],"and":[70,96],"ControlNovember":[71],"Pages":[73],"230\u2013245https://doi.org/10.1145/1734663.1734678Online:15":[74],"November":[75],"1970Publication":[76],"History":[77],"4citation79DownloadsMetricsTotal":[78],"Citations4Total":[79],"Downloads79Last":[80],"12":[81],"Months7Last":[82],"6":[83],"weeks0":[84],"Get":[85],"Citation":[86,88,125],"AlertsNew":[87,124],"Alert":[89],"added!This":[90],"alert":[91,116],"has":[92,111],"been":[93,112],"successfully":[94],"added":[95],"will":[97,101],"be":[98,102],"sent":[99],"to:You":[100],"notified":[103],"whenever":[104],"record":[106],"that":[107],"you":[108],"have":[109],"chosen":[110],"cited.To":[113],"manage":[114],"your":[115,130],"preferences,":[117],"click":[118],"button":[121],"below.Manage":[122],"my":[123],"Alert!Please":[126],"log":[127],"in":[128],"to":[129,133,135],"account":[131],"Save":[132],"BinderSave":[134],"BinderCreate":[136],"New":[138],"BinderNameCancelCreateExport":[139],"CitationPublisher":[140],"SiteeReaderPDF":[141]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}