{"id":"https://openalex.org/W4400440029","doi":"https://doi.org/10.1145/3664934.3664948","title":"Manifesto for SIR SQL","display_name":"Manifesto for SIR SQL","publication_year":2024,"publication_date":"2024-04-12","ids":{"openalex":"https://openalex.org/W4400440029","doi":"https://doi.org/10.1145/3664934.3664948"},"language":"en","primary_location":{"id":"doi:10.1145/3664934.3664948","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3664934.3664948","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 9th International Conference on Information and Education Innovations","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hal.science/hal-04878187","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5063763327","display_name":"Witold Litwin","orcid":"https://orcid.org/0009-0009-2999-9704"},"institutions":[{"id":"https://openalex.org/I56435720","display_name":"Universit\u00e9 Paris Dauphine-PSL","ror":"https://ror.org/052bz7812","country_code":"FR","type":"education","lineage":["https://openalex.org/I2746051580","https://openalex.org/I56435720"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Witold Litwin","raw_affiliation_strings":["Lamsade, Universite Paris Dauphine, PSL, France"],"raw_orcid":"https://orcid.org/0009-0009-2999-9704","affiliations":[{"raw_affiliation_string":"Lamsade, Universite Paris Dauphine, PSL, France","institution_ids":["https://openalex.org/I56435720"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5063763327"],"corresponding_institution_ids":["https://openalex.org/I56435720"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"99","last_page":"103"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.5317000150680542,"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"}},"topics":[{"id":"https://openalex.org/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.5317000150680542,"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/computer-science","display_name":"Computer science","score":0.6891995668411255},{"id":"https://openalex.org/keywords/manifesto","display_name":"Manifesto","score":0.572679340839386},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5070726871490479},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4897156059741974},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3768237829208374},{"id":"https://openalex.org/keywords/political-science","display_name":"Political science","score":0.061329156160354614}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6891995668411255},{"id":"https://openalex.org/C2778896172","wikidata":"https://www.wikidata.org/wiki/Q46337","display_name":"Manifesto","level":2,"score":0.572679340839386},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5070726871490479},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4897156059741974},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3768237829208374},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.061329156160354614},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3664934.3664948","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3664934.3664948","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 9th International Conference on Information and Education Innovations","raw_type":"proceedings-article"},{"id":"pmh:oai:HAL:hal-04878187v1","is_oa":true,"landing_page_url":"https://hal.science/hal-04878187","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ICIEI '24:' 9th International Conference on Information and Education Innovations, ICIEI, Apr 2024, Verbania, Italy. pp.99","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:HAL:hal-04878187v1","is_oa":true,"landing_page_url":"https://hal.science/hal-04878187","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ICIEI '24:' 9th International Conference on Information and Education Innovations, ICIEI, Apr 2024, Verbania, Italy. pp.99","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2185907055","https://openalex.org/W6657732435"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2124276731","https://openalex.org/W1036048407","https://openalex.org/W1185307393","https://openalex.org/W3184967493","https://openalex.org/W2610523071","https://openalex.org/W1595152277","https://openalex.org/W2225837912","https://openalex.org/W1566995095"],"abstract_inverted_index":{"SIR":[0,85],"SQL":[1,4],"stands":[2],"for":[3],"generalized":[5],"to":[6,27,38,96,128,131,141],"Stored":[7],"and":[8,20,58,94],"Inherited":[9],"Relations":[10],"(SIRs).":[11],"The":[12,106],"benefit":[13],"is":[14,87],"the":[15,33],"logical":[16],"navigation":[17],"free":[18,23],"(LNF)":[19],"calculated":[21],"attribute":[22],"(CAF)":[24],"typical":[25,36,126],"queries":[26,37,127,140],"base":[28,39,89],"tables":[29,40],"being":[30],"SIRs,":[31],"while":[32,68],"same":[34],"outcome":[35],"at":[41,133,135],"present":[42],"require":[43],"LN":[44,51,77,121],"or":[45,78,122,149],"CAs":[46],"specs":[47,70,124],"within.":[48],"Recall":[49],"that":[50,125],"means":[52],"cumbersome":[53],"procedural":[54],"equijoins":[55],"on":[56],"foreign":[57],"referenced":[59],"keys,":[60],"in":[61,114],"Codd's":[62],"original":[63],"meaning":[64],"of":[65,118],"these":[66],"terms,":[67],"CA":[69,123],"are":[71,108],"also":[72],"procedural,":[73],"value":[74],"expressions":[75],"with":[76,79,81,101],"sub-queries":[80],"aggregate":[82],"functions.":[83],"A":[84],"R":[86,142],"any":[88],"table":[90],"defined":[91,109],"as":[92,98,110],"presently":[93],"referred":[95],"implicitly":[97],"R_,":[99,119],"enlarged":[100],"some":[102],"inherited":[103],"attributes":[104],"(IAs).":[105],"latter":[107],"if":[111],"they":[112],"were":[113],"a":[115],"specific":[116],"view":[117],"including":[120],"R_":[129],"has":[130],"contain":[132],"present,":[134],"least":[136],"partly.":[137],"Same":[138],"output":[139],"may":[143],"address":[144],"IAs":[145],"instead,":[146],"remaining":[147],"LNF":[148],"CAF":[150],"consequently.":[151]},"counts_by_year":[],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}