{"id":"https://openalex.org/W2051518698","doi":"https://doi.org/10.1108/jsit-05-2014-0034","title":"Comparison of Post-Relational and Object-Relational modelling for real-world database applications","display_name":"Comparison of Post-Relational and Object-Relational modelling for real-world database applications","publication_year":2014,"publication_date":"2014-11-04","ids":{"openalex":"https://openalex.org/W2051518698","doi":"https://doi.org/10.1108/jsit-05-2014-0034","mag":"2051518698"},"language":"en","primary_location":{"id":"doi:10.1108/jsit-05-2014-0034","is_oa":false,"landing_page_url":"https://doi.org/10.1108/jsit-05-2014-0034","pdf_url":null,"source":{"id":"https://openalex.org/S39868070","display_name":"Journal of Systems and Information Technology","issn_l":"1328-7265","issn":["1328-7265","1758-8847"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319811","host_organization_name":"Emerald Publishing Limited","host_organization_lineage":["https://openalex.org/P4310319811"],"host_organization_lineage_names":["Emerald Publishing Limited"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Systems and Information Technology","raw_type":"journal-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/A5081787499","display_name":"Nikitas \u039d. Karanikolas","orcid":"https://orcid.org/0000-0003-1777-892X"},"institutions":[{"id":"https://openalex.org/I40479246","display_name":"Technological Educational Institute of Athens","ror":"https://ror.org/044m46d61","country_code":"GR","type":"education","lineage":["https://openalex.org/I40479246"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Nikitas N. Karanikolas","raw_affiliation_strings":["Department of Informatics, Technological Educational Institute (TEI) of Athens, Athens, Greece","(Department of Informatics, Technological Educational Institute (TEI) of Athens, Athens, Greece)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics, Technological Educational Institute (TEI) of Athens, Athens, Greece","institution_ids":["https://openalex.org/I40479246"]},{"raw_affiliation_string":"(Department of Informatics, Technological Educational Institute (TEI) of Athens, Athens, Greece)","institution_ids":["https://openalex.org/I40479246"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5046792635","display_name":"Michael Vassilakopoulos","orcid":"https://orcid.org/0000-0003-2256-5523"},"institutions":[{"id":"https://openalex.org/I145722265","display_name":"University of Thessaly","ror":"https://ror.org/04v4g9h31","country_code":"GR","type":"education","lineage":["https://openalex.org/I145722265"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Michael Vassilakopoulos","raw_affiliation_strings":["Department of Electrical and Computer Engineering, University of Thessaly, Volos, Greece","Dept. of Electrical and Computer Eng., University Of Thessaly, Volos, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computer Engineering, University of Thessaly, Volos, Greece","institution_ids":["https://openalex.org/I145722265"]},{"raw_affiliation_string":"Dept. of Electrical and Computer Eng., University Of Thessaly, Volos, Greece","institution_ids":["https://openalex.org/I145722265"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.14053216,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"16","issue":"4","first_page":"313","last_page":"340"},"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.9998999834060669,"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.9998999834060669,"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.9976000189781189,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9959999918937683,"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/computer-science","display_name":"Computer science","score":0.8068848848342896},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6956773400306702},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.686339259147644},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.6397584676742554},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5869446396827698},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5627338886260986},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5583754181861877},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.5453826785087585},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4315839409828186},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.42910271883010864},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4165910482406616},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3823970556259155},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3698221445083618},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1544371247291565}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8068848848342896},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6956773400306702},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.686339259147644},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6397584676742554},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5869446396827698},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5627338886260986},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5583754181861877},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.5453826785087585},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4315839409828186},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.42910271883010864},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4165910482406616},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3823970556259155},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3698221445083618},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1544371247291565}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1108/jsit-05-2014-0034","is_oa":false,"landing_page_url":"https://doi.org/10.1108/jsit-05-2014-0034","pdf_url":null,"source":{"id":"https://openalex.org/S39868070","display_name":"Journal of Systems and Information Technology","issn_l":"1328-7265","issn":["1328-7265","1758-8847"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319811","host_organization_name":"Emerald Publishing Limited","host_organization_lineage":["https://openalex.org/P4310319811"],"host_organization_lineage_names":["Emerald Publishing Limited"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Systems and Information Technology","raw_type":"journal-article"},{"id":"pmh:oai:ir.lib.uth.gr:11615/29059","is_oa":false,"landing_page_url":"http://hdl.handle.net/11615/29059","pdf_url":null,"source":{"id":"https://openalex.org/S4306400243","display_name":"University of Thessaly Institutional Repository (University of Thessaly)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I145722265","host_organization_name":"University of Thessaly","host_organization_lineage":["https://openalex.org/I145722265"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.scopus.com/inward/record.url?eid=2-s2.0-84927515410&partnerID=40&md5=9fedfd37d24f9a1864f882195bac1e2f","raw_type":"journalArticle"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W73744418","https://openalex.org/W123968353","https://openalex.org/W193687481","https://openalex.org/W1480969754","https://openalex.org/W1506773713","https://openalex.org/W1523801366","https://openalex.org/W1538721919","https://openalex.org/W1550138383","https://openalex.org/W1571440443","https://openalex.org/W1590220434","https://openalex.org/W1982776008","https://openalex.org/W1997897949","https://openalex.org/W2054226137","https://openalex.org/W2144192824","https://openalex.org/W2162966567","https://openalex.org/W2165467455","https://openalex.org/W2168502142","https://openalex.org/W2169129708","https://openalex.org/W2170832531","https://openalex.org/W2185907055","https://openalex.org/W2945526390","https://openalex.org/W3112109630","https://openalex.org/W6607763513","https://openalex.org/W6805086740","https://openalex.org/W7002139788"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W3085968255","https://openalex.org/W2007556552","https://openalex.org/W2512945146","https://openalex.org/W2460926837","https://openalex.org/W1998046157","https://openalex.org/W279222092","https://openalex.org/W52829598","https://openalex.org/W1982714394","https://openalex.org/W1978969411"],"abstract_inverted_index":{"Purpose":[0],"\u2013":[1,73,124,189,209,225],"The":[2,125,210],"purpose":[3],"of":[4,12,19,52,79,92,102,107,144,155,160,196,201,212,220,231],"this":[5,83],"paper":[6,84,227],"is":[7,134,205],"to":[8,44,68],"compare":[9],"the":[10,17,38,42,45,50,76,86,100,108,115,142,182,194,197,213,218,229,251],"use":[11,18,101,143,211],"two":[13],"Object-Relational":[14],"models":[15,64],"against":[16,99],"a":[20,24,80,103,202],"post-Relational":[21,104],"model":[22,48,78,105],"for":[23,131,136,147,153,176,184],"realistic":[25,232],"application.":[26],"Although":[27],"real-world":[28],"applications,":[29],"in":[30,55,192],"most":[31],"cases,":[32],"can":[33,157],"be":[34],"adequately":[35],"modeled":[36],"by":[37,240,250],"Entity-Relationship":[39],"(ER)":[40],"model,":[41],"transformation":[43],"popular":[46],"Relational":[47],"alters":[49],"representation":[51],"structures":[53],"common":[54],"reality,":[56],"like":[57],"multi-valued":[58],"and":[59,90,97,114,172,235,242],"composite":[60,167,179],"fields.":[61],"Alternative":[62],"database":[63,221],"have":[65],"been":[66],"developed":[67],"overcome":[69],"these":[70,245],"shortcomings.":[71],"Design/methodology/approach":[72],"Based":[74],"on":[75,163],"ER":[77],"medical":[81],"application,":[82],"compares":[85],"information":[87],"representation,":[88],"manipulation":[89],"enforcement":[91],"integrity":[93],"constraints":[94],"through":[95],"PostgreSQL":[96],"Oracle,":[98],"composed":[106],"Conceptual":[109,116],"Universal":[110,117],"Database":[111,118],"Language":[112,119],"(CUDL)":[113],"Abstraction":[120],"Level":[121],"(CAL).":[122],"Findings":[123],"CAL/CUDL":[126,203,214,252],"pair,":[127],"although":[128],"more":[129],"periphrastic":[130],"data":[132,137,148,168,174,180],"definition,":[133],"simpler":[135],"insertions,":[138],"does":[139],"not":[140],"require":[141],"procedural":[145,185],"code":[146],"updates,":[149],"produces":[150],"clearer":[151],"output":[152],"retrieval":[154,159],"attributes,":[156],"accomplish":[158],"rows":[161],"based":[162],"conditions":[164],"that":[165,237,244],"address":[166],"with":[169],"declarative":[170],"statements":[171],"supports":[173],"validation":[175],"relationships":[177],"between":[178],"without":[181],"need":[183],"code.":[186],"Research":[187],"limitations/implications":[188],"To":[190],"verify,":[191],"practice,":[193],"conclusions":[195],"paper,":[198],"complete":[199],"implementation":[200],"system":[204],"needed.":[206],"Practical":[207],"implications":[208],"pair":[215],"would":[216],"advance":[217],"productivity":[219],"application":[222],"development.":[223],"Originality/value":[224],"This":[226],"highlights":[228],"properties":[230,246],"database-applications":[233],"modelling":[234],"management":[236],"are":[238,247],"desirable":[239],"developers":[241],"shows":[243],"better":[248],"satisfied":[249],"pair.":[253]},"counts_by_year":[{"year":2018,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}