{"id":"https://openalex.org/W2430280192","doi":"https://doi.org/10.1109/icde.2016.7498239","title":"NoSE: Schema design for NoSQL applications","display_name":"NoSE: Schema design for NoSQL applications","publication_year":2016,"publication_date":"2016-05-01","ids":{"openalex":"https://openalex.org/W2430280192","doi":"https://doi.org/10.1109/icde.2016.7498239","mag":"2430280192"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2016.7498239","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2016.7498239","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"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/A5031688318","display_name":"Michael J. Mior","orcid":"https://orcid.org/0000-0002-4057-8726"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Michael J. Mior","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035977189","display_name":"Kenneth Salem","orcid":"https://orcid.org/0000-0003-0409-9725"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Kenneth Salem","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000416532","display_name":"Ashraf Aboulnaga","orcid":"https://orcid.org/0000-0001-6693-7099"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ashraf Aboulnaga","raw_affiliation_strings":["Qatar Computing Research Institute, HBKU"],"affiliations":[{"raw_affiliation_string":"Qatar Computing Research Institute, HBKU","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101658709","display_name":"Rui Liu","orcid":"https://orcid.org/0000-0002-4515-2708"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rui Liu","raw_affiliation_strings":["HP Vertica"],"affiliations":[{"raw_affiliation_string":"HP Vertica","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5031688318"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":4.343,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.94659796,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"181","last_page":"192"},"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.9994999766349792,"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.9994999766349792,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9977999925613403,"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.9945999979972839,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.941681444644928},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8248765468597412},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6514403820037842},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.613925039768219},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5828326344490051},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5595361590385437},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5214240550994873},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4870457947254181},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.43501344323158264},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.3844802975654602},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.35265493392944336},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3514808416366577},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3503642976284027},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.1193346381187439}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.941681444644928},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8248765468597412},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6514403820037842},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.613925039768219},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5828326344490051},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5595361590385437},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5214240550994873},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4870457947254181},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.43501344323158264},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.3844802975654602},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.35265493392944336},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3514808416366577},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3503642976284027},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.1193346381187439},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2016.7498239","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2016.7498239","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W156483298","https://openalex.org/W585560688","https://openalex.org/W1553825122","https://openalex.org/W1890845846","https://openalex.org/W1985229168","https://openalex.org/W2006296837","https://openalex.org/W2013255770","https://openalex.org/W2017052417","https://openalex.org/W2047085757","https://openalex.org/W2047742073","https://openalex.org/W2055961446","https://openalex.org/W2081991734","https://openalex.org/W2084568010","https://openalex.org/W2087946700","https://openalex.org/W2090438868","https://openalex.org/W2098443134","https://openalex.org/W2103412498","https://openalex.org/W2105252819","https://openalex.org/W2108883953","https://openalex.org/W2112090702","https://openalex.org/W2122816893","https://openalex.org/W2124297537","https://openalex.org/W2125605956","https://openalex.org/W2144192824","https://openalex.org/W2160068753","https://openalex.org/W2167942260","https://openalex.org/W2334286811","https://openalex.org/W2430280192","https://openalex.org/W2524571614","https://openalex.org/W2624304035","https://openalex.org/W2949201629","https://openalex.org/W3006933873","https://openalex.org/W3021961968","https://openalex.org/W4243533704","https://openalex.org/W4301353258","https://openalex.org/W6606234248","https://openalex.org/W6678597633","https://openalex.org/W6684991827","https://openalex.org/W6717819732","https://openalex.org/W6738874634"],"related_works":["https://openalex.org/W1973550464","https://openalex.org/W2582962420","https://openalex.org/W139721835","https://openalex.org/W166845585","https://openalex.org/W2092058806","https://openalex.org/W945629821","https://openalex.org/W2069015212","https://openalex.org/W2153512431","https://openalex.org/W1512552654","https://openalex.org/W1513459549"],"abstract_inverted_index":{"Database":[0],"design":[1,138],"is":[2,29,120],"critical":[3],"for":[4,33,38,43,69,73,107],"high":[5],"performance":[6],"in":[7,18],"relational":[8,39],"databases":[9,40],"and":[10,146],"many":[11],"tools":[12,37],"exist":[13],"to":[14,49,60,86,96,122,142,147],"aid":[15],"application":[16],"designers":[17,47,130],"selecting":[19],"an":[20,62],"appropriate":[21,63],"schema.":[22,64,99],"While":[23],"the":[24,88,91,108,115,134,137],"problem":[25],"of":[26,58,104,125],"schema":[27],"optimization":[28],"also":[30],"highly":[31],"relevant":[32],"NoSQL":[34,52,74,116],"databases,":[35],"existing":[36],"are":[41],"inadequate":[42],"this":[44,105],"setting.":[45],"Application":[46],"wishing":[48],"use":[50],"a":[51,67,80,97,102,156],"database":[53,71,98],"instead":[54],"rely":[55],"on":[56],"rules":[57,124],"thumb":[59,126],"select":[61],"We":[65,100],"present":[66],"system":[68],"recommending":[70],"schemas":[72,145],"applications.":[75],"Our":[76,113],"cost-based":[77],"approach":[78,106],"uses":[79],"novel":[81],"binary":[82],"integer":[83],"programming":[84],"formulation":[85],"guide":[87],"mapping":[89],"from":[90],"application's":[92],"conceptual":[93],"data":[94],"model":[95],"implemented":[101],"prototype":[103],"Cassandra":[109],"extensible":[110],"record":[111],"store.":[112],"prototype,":[114],"Schema":[117],"Evaluator":[118],"(NoSE)":[119],"able":[121],"capture":[123],"used":[127],"by":[128],"expert":[129],"without":[131],"explicitly":[132],"encoding":[133],"rules.":[135],"Automating":[136],"process":[139],"allows":[140],"NoSE":[141],"produce":[143],"efficient":[144],"examine":[148],"more":[149],"alternatives":[150],"than":[151],"would":[152],"be":[153],"possible":[154],"with":[155],"manual":[157],"rule-based":[158],"approach.":[159]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}