{"id":"https://openalex.org/W2057731143","doi":"https://doi.org/10.5539/cis.v3n2p38","title":"A Proposal for Constructing Relational Database from Class Diagram","display_name":"A Proposal for Constructing Relational Database from Class Diagram","publication_year":2010,"publication_date":"2010-04-19","ids":{"openalex":"https://openalex.org/W2057731143","doi":"https://doi.org/10.5539/cis.v3n2p38","mag":"2057731143"},"language":"en","primary_location":{"id":"doi:10.5539/cis.v3n2p38","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v3n2p38","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/5510/4785","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ccsenet.org/journal/index.php/cis/article/download/5510/4785","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5067409304","display_name":"Mohd Zainuri Saringat","orcid":"https://orcid.org/0000-0002-3096-069X"},"institutions":[{"id":"https://openalex.org/I930072361","display_name":"Tun Hussein Onn University of Malaysia","ror":"https://ror.org/01c5wha71","country_code":"MY","type":"education","lineage":["https://openalex.org/I930072361"]}],"countries":["MY"],"is_corresponding":true,"raw_author_name":"Mohd Zainuri Saringat","raw_affiliation_strings":["Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia","institution_ids":["https://openalex.org/I930072361"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084810449","display_name":"Tutut Herawan","orcid":"https://orcid.org/0000-0001-9262-9137"},"institutions":[{"id":"https://openalex.org/I2608206482","display_name":"Universitas Ahmad Dahlan","ror":"https://ror.org/03hn13397","country_code":"ID","type":"education","lineage":["https://openalex.org/I2608206482"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Tutut Herawan","raw_affiliation_strings":["Department of Mathematics Education, Universitas Ahmad Dahlan"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics Education, Universitas Ahmad Dahlan","institution_ids":["https://openalex.org/I2608206482"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000733432","display_name":"Rosziati Ibrahim","orcid":"https://orcid.org/0000-0002-9176-0309"},"institutions":[{"id":"https://openalex.org/I930072361","display_name":"Tun Hussein Onn University of Malaysia","ror":"https://ror.org/01c5wha71","country_code":"MY","type":"education","lineage":["https://openalex.org/I930072361"]}],"countries":["MY"],"is_corresponding":false,"raw_author_name":"Rosziati Ibrahim","raw_affiliation_strings":["Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology and Multimedia, Universiti Tun Hussein Onn Malaysia","institution_ids":["https://openalex.org/I930072361"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5067409304"],"corresponding_institution_ids":["https://openalex.org/I930072361"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.1577525,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"3","issue":"2","first_page":null,"last_page":null},"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.9995999932289124,"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.9995999932289124,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","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.9969000220298767,"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/computer-science","display_name":"Computer science","score":0.879357099533081},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.7264195084571838},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6335253715515137},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5849515795707703},{"id":"https://openalex.org/keywords/class-diagram","display_name":"Class diagram","score":0.5286306142807007},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.5273141264915466},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4717867076396942},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.45895299315452576},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4529411792755127},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4502342641353607},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44346460700035095},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.44000864028930664},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.42250487208366394},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.4191082715988159},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37532228231430054},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.265417218208313},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.2571592330932617},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.08655020594596863}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.879357099533081},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.7264195084571838},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6335253715515137},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5849515795707703},{"id":"https://openalex.org/C202446494","wikidata":"https://www.wikidata.org/wiki/Q664166","display_name":"Class diagram","level":4,"score":0.5286306142807007},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5273141264915466},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4717867076396942},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.45895299315452576},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4529411792755127},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4502342641353607},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44346460700035095},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.44000864028930664},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.42250487208366394},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.4191082715988159},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37532228231430054},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.265417218208313},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.2571592330932617},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.08655020594596863}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5539/cis.v3n2p38","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v3n2p38","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/5510/4785","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.5539/cis.v3n2p38","is_oa":true,"landing_page_url":"https://doi.org/10.5539/cis.v3n2p38","pdf_url":"https://ccsenet.org/journal/index.php/cis/article/download/5510/4785","source":{"id":"https://openalex.org/S2764452479","display_name":"Computer and Information Science","issn_l":"1913-8989","issn":["1913-8989","1913-8997"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310322531","host_organization_name":"Canadian Center of Science and Education","host_organization_lineage":["https://openalex.org/P4310322531"],"host_organization_lineage_names":["Canadian Center of Science and Education"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer and Information Science","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2057731143.pdf","grobid_xml":"https://content.openalex.org/works/W2057731143.grobid-xml"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W613492582","https://openalex.org/W1497389631","https://openalex.org/W1549720957","https://openalex.org/W1561767005","https://openalex.org/W1568036133","https://openalex.org/W1569267743","https://openalex.org/W1979829546","https://openalex.org/W2027510748","https://openalex.org/W2064101236","https://openalex.org/W2112630554","https://openalex.org/W2155891457","https://openalex.org/W2165467455","https://openalex.org/W2169013090","https://openalex.org/W2232207765","https://openalex.org/W3127292049","https://openalex.org/W3144660059","https://openalex.org/W6619134672","https://openalex.org/W6666807374","https://openalex.org/W6676860806","https://openalex.org/W6689392195","https://openalex.org/W6790255856"],"related_works":["https://openalex.org/W2007556552","https://openalex.org/W2160577815","https://openalex.org/W3097241194","https://openalex.org/W2121229754","https://openalex.org/W1978969411","https://openalex.org/W2460926837","https://openalex.org/W2356754926","https://openalex.org/W962397878","https://openalex.org/W2336519490","https://openalex.org/W1846958406"],"abstract_inverted_index":{"Database":[0],"system":[1,36,44,57,72,84],"is":[2,37,80,85,102,109,134,157],"important":[3],"to":[4,52,136,139,147,161],"ensure":[5],"the":[6,20,88,104,112,115,125,128,132,144,163],"data":[7,122],"can":[8],"be":[9],"stored,":[10],"updated":[11],"and":[12,46,59,78,124],"retrieved":[13],"for":[14,67],"future":[15],"use.":[16],"Data":[17],"modelling":[18],"using":[19],"Entity":[21],"Relationship":[22],"Model":[23],"has":[24],"been":[25],"introduced":[26],"more":[27],"than":[28],"thirty":[29],"years.":[30],"However,":[31],"designing":[32,68,143],"a":[33,65,69,141],"good":[34,142],"database":[35,60,71,83],"still":[38],"an":[39,152],"attractive":[40],"issue":[41],"particularly":[42],"in":[43,99,159],"analysis":[45],"design":[47,58],"because":[48],"of":[49,127],"very":[50],"hard":[51],"do":[53],"consistency":[54],"checking":[55],"between":[56],"design.":[61],"In":[62],"this":[63,100],"paper,":[64],"proposal":[66],"relational":[70],"based":[73,110],"on":[74,111],"Object":[75],"Oriented":[76],"Analysis":[77],"Design":[79],"presented.":[81],"The":[82,96],"created":[86],"by":[87],"schema":[89,145],"table":[90],"that":[91,131],"extract":[92],"from":[93],"class":[94,120],"diagram.":[95],"rules":[97],"applying":[98],"paper":[101],"following":[103],"object":[105],"oriented":[106],"concept.":[107],"It":[108],"relationships":[113],"among":[114],"classes,":[116],"multiplicity,":[117],"attributes":[118],"name,":[119,121],"type":[123],"behaviours":[126],"classes.":[129],"Beside":[130],"user":[133],"required":[135],"insert":[137],"record":[138],"accomplish":[140],"tables":[146],"avoid":[148],"redundancy":[149],"data.":[150],"Finally,":[151],"automatic":[153],"editor":[154],"called":[155],"CDGeST":[156],"proposed":[158],"order":[160],"automate":[162],"process.":[164]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}