{"id":"https://openalex.org/W3131228186","doi":"https://doi.org/10.1088/1742-6596/1783/1/012050","title":"Venn Versus Relation Diagram Models For Database Relation in SQL Command Line","display_name":"Venn Versus Relation Diagram Models For Database Relation in SQL Command Line","publication_year":2021,"publication_date":"2021-02-01","ids":{"openalex":"https://openalex.org/W3131228186","doi":"https://doi.org/10.1088/1742-6596/1783/1/012050","mag":"3131228186"},"language":"en","primary_location":{"id":"doi:10.1088/1742-6596/1783/1/012050","doi":"https://doi.org/10.1088/1742-6596/1783/1/012050","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/1783/1/012050","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/1783/1/012050/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://iopscience.iop.org/article/10.1088/1742-6596/1783/1/012050/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014344010","display_name":"Nunu Kustian","orcid":"https://orcid.org/0000-0003-0500-3422","observed_orcids":["https://orcid.org/0000-0003-0500-3422"]},"institutions":[{"id":"https://openalex.org/I3132561136","display_name":"Universitas Indraprasta PGRI","ror":"https://ror.org/043zbev87","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132561136"]}],"countries":["ID"],"is_corresponding":true,"raw_author_name":"Nunu Kustian","raw_affiliation_strings":["Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia","institution_ids":["https://openalex.org/I3132561136"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001645213","display_name":"Siti Julaeha","orcid":"https://orcid.org/0000-0002-5140-780X","observed_orcids":["https://orcid.org/0000-0002-5140-780X"]},"institutions":[{"id":"https://openalex.org/I3132561136","display_name":"Universitas Indraprasta PGRI","ror":"https://ror.org/043zbev87","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132561136"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Siti Julaeha","raw_affiliation_strings":["Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia","institution_ids":["https://openalex.org/I3132561136"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027116268","display_name":"Dudi Parulian","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3132561136","display_name":"Universitas Indraprasta PGRI","ror":"https://ror.org/043zbev87","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132561136"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Dudi Parulian","raw_affiliation_strings":["Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia","institution_ids":["https://openalex.org/I3132561136"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024146585","display_name":"Noni Selvia","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3132561136","display_name":"Universitas Indraprasta PGRI","ror":"https://ror.org/043zbev87","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132561136"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Noni Selvia","raw_affiliation_strings":["Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia","institution_ids":["https://openalex.org/I3132561136"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003916296","display_name":"Erlin Windia Ambarsari","orcid":"https://orcid.org/0000-0002-3489-5821","observed_orcids":["https://orcid.org/0000-0002-3489-5821"]},"institutions":[{"id":"https://openalex.org/I3132561136","display_name":"Universitas Indraprasta PGRI","ror":"https://ror.org/043zbev87","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132561136"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Erlin Windia Ambarsari","raw_affiliation_strings":["Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Informatics Department, Universitas Indraprasta PGRI, Jakarta, Indonesia","institution_ids":["https://openalex.org/I3132561136"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5014344010"],"corresponding_institution_ids":["https://openalex.org/I3132561136"],"apc_list":null,"apc_paid":null,"fwci":0.8416,"has_fulltext":true,"cited_by_count":6,"citation_normalized_percentile":{"value":0.69781998,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":95},"biblio":{"volume":"1783","issue":"1","first_page":"012050","last_page":"012050"},"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.8574000000953674,"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.8574000000953674,"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/T13681","display_name":"Engineering and Information Technology","score":0.1103999987244606,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11734","display_name":"Decision Support System Applications","score":0.006399999838322401,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/venn-diagrams","display_name":"Venn diagrams","score":0.9020000100135803},{"id":"https://openalex.org/keywords/database-relations","display_name":"database relations","score":0.5529999732971191},{"id":"https://openalex.org/keywords/inner-join","display_name":"inner join","score":0.824999988079071},{"id":"https://openalex.org/keywords/where-clause","display_name":"WHERE clause","score":0.8309999704360962},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.47200000286102295},{"id":"https://openalex.org/keywords/data-representation","display_name":"data representation","score":0.8450000286102295},{"id":"https://openalex.org/keywords/attribute-relationships","display_name":"attribute relationships","score":0.6650000214576721}],"concepts":[{"id":"https://openalex.org/C55508974","wikidata":"https://www.wikidata.org/wiki/Q190763","display_name":"Venn diagram","level":2,"score":0.9637652039527893},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.6575298309326172},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6536396741867065},{"id":"https://openalex.org/C186399060","wikidata":"https://www.wikidata.org/wiki/Q959962","display_name":"Diagram","level":2,"score":0.6164310574531555},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5968387126922607},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5199909806251526},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5086975693702698},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4998657703399658},{"id":"https://openalex.org/C48419115","wikidata":"https://www.wikidata.org/wiki/Q950859","display_name":"Communication diagram","level":5,"score":0.4642290472984314},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.46015694737434387},{"id":"https://openalex.org/C198352243","wikidata":"https://www.wikidata.org/wiki/Q37105","display_name":"Line (geometry)","level":2,"score":0.4211130738258362},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4169424772262573},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3671714663505554},{"id":"https://openalex.org/C202446494","wikidata":"https://www.wikidata.org/wiki/Q664166","display_name":"Class diagram","level":4,"score":0.3663473129272461},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3561839461326599},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2325255274772644},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.14387094974517822},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.09741461277008057},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1088/1742-6596/1783/1/012050","doi":"https://doi.org/10.1088/1742-6596/1783/1/012050","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/1783/1/012050","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/1783/1/012050/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1088/1742-6596/1783/1/012050","doi":"https://doi.org/10.1088/1742-6596/1783/1/012050","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1742-6596/1783/1/012050","pdf_url":"https://iopscience.iop.org/article/10.1088/1742-6596/1783/1/012050/pdf","source":{"id":"https://openalex.org/S4210187594","display_name":"Journal of Physics Conference Series","issn_l":"1742-6588","issn":["1742-6588","1742-6596"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","jufo-1","norway-1","poland-40","vabb-shw"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Physics: Conference Series","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3131228186.pdf","grobid_xml":"https://content.openalex.org/works/W3131228186.grobid-xml"},"referenced_works_count":6,"referenced_works":["https://openalex.org/W1999899863","https://openalex.org/W2327322980","https://openalex.org/W2765405388","https://openalex.org/W2788306924","https://openalex.org/W2792773246","https://openalex.org/W2810256026"],"related_works":["https://openalex.org/W1895523773","https://openalex.org/W3134045208","https://openalex.org/W7112231793","https://openalex.org/W3018505712","https://openalex.org/W4388992068","https://openalex.org/W7096196465","https://openalex.org/W4245569780","https://openalex.org/W1946410342","https://openalex.org/W6962297381","https://openalex.org/W2055008679"],"abstract_inverted_index":{"Abstract":[0],"The":[1,34,46,65,74,89],"study":[2],"was":[3,40,72,77,98],"to":[4,57,79,100,110],"analyze":[5],"the":[6,30,54,82,85,91,96,101,106,113,118],"difference":[7,69],"between":[8,70],"two":[9],"diagrams,":[10],"such":[11],"as":[12,50],"a":[13],"Venn":[14,75],"and":[15,43],"relation":[16],"diagram.":[17],"Comparisons":[18],"are":[19],"made":[20],"based":[21],"on":[22],"syntax":[23],"in":[24,84],"SQL":[25],"Command-Line,":[26],"primarily":[27],"when":[28],"used":[29,37],"Select":[31],"condition":[32],"clause.":[33],"sample":[35],"command":[36],"for":[38,53],"diagrams":[39,47],"inner":[41],"join":[42],"where":[44],"syntaxes.":[45],"will":[48],"act":[49],"data":[51,62,107,115],"representation":[52],"Relational":[55],"Database":[56],"display":[58],"an":[59],"outline":[60],"of":[61],"relationship":[63,92],"analysis.":[64],"results":[66],"obtained":[67],"that":[68,108],"them":[71],"significant.":[73],"diagram":[76,120],"useful":[78],"evaluate":[80],"how":[81,95],"attribute":[83],"table":[86],"is":[87,121],"connected.":[88],"opposite,":[90],"diagram,":[93],"shown":[94],"dataset":[97],"related":[99,116],"tables.":[102],"Therefore":[103],"it":[104],"recognizes":[105],"had":[109],"deceive.":[111],"However,":[112],"more":[114,119],"then,":[117],"complex.":[122]},"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":1}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2021-03-01T00:00:00"}