Conference
DerSql, Generating SQL from an Entity-Relation Diagram
| Τίτλος: | DerSql, Generating SQL from an Entity-Relation Diagram |
|---|---|
| Γλώσσα: | English |
| Συγγραφείς: | Andrea Domínguez-Lara, Wulfrano Arturo Luna-Ramírez |
| Πηγή: | International Association for Development of the Information Society. 2022 (Sustainability). |
| Διαθεσιμότητα: | International Association for the Development of the Information Society. e-mail: secretariat@iadis.org; Web site: http://www.iadisportal.org |
| Peer Reviewed: | Y |
| Page Count: | 5 |
| Ημερομηνία έκδοσης: | 2022 |
| Τύπος εγγράφου: | Speeches/Meeting Papers Reports - Descriptive |
| Descriptors: | Programming, Coding, Computer Software, Programming Languages, Automation, Databases, Concept Mapping, Data, Models, Mathematical Formulas, Semantics, Computer Science Education, Engineering Technology |
| Περίληψη: | The automatic code generation is the process of generating source code snippets from a program, i.e., code for generating code. Its importance lies in facilitating software development, particularly important is helping in the implementation of software designs such as engineering diagrams, in such a case, automatic code generation copes with the problem of how to obtain code from a graphic representation, for instance an UML diagram or a Relational Diagram. Some advantages of automatic code generation are: a) to obtain the source code more quickly and to do it with lower margins of error; b) it is promising to be applied in teaching contexts, whilst provide instructors with a tool to teach, the expected results of assignments can be assessed by comparing the results of students and the automatic generated code. Furthermore, one of the most frequently tasks in classrooms when teaching relational databases is the design of Entity-Relationship Diagrams which eventually become SQL code. The manual transition from an Entity-Relationship Diagram to SQL code is a time-consuming process and requires of a skilled eye to be successfully performed. In this paper, we present "DerSql," an extension of the DIA Diagrammer, a well-known free software engineering tool, to automatically generate SQL code from an Entity-Relationship Diagrams. The results are tested for the case of 1 -- 1 and 1 -- n arities relationships. We consider that "DerSql" represents a remarkable tool for teaching while it is a promising advance in developing DIA as a 4th Generation software engineering application. [For the full proceedings, see ED638044.] |
| Abstractor: | As Provided |
| Entry Date: | 2024 |
| Αριθμός Καταχώρησης: | ED638362 |
| Βάση Δεδομένων: | ERIC |
| FullText | Text: Availability: 0 CustomLinks: – Url: https://eric.ed.gov/contentdelivery/servlet/ERICServlet?accno=ED638362 Name: ERIC Full Text Category: fullText Text: Full Text from ERIC |
|---|---|
| Header | DbId: eric DbLabel: ERIC An: ED638362 AccessLevel: 3 PubType: Conference PubTypeId: conference PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: DerSql, Generating SQL from an Entity-Relation Diagram – Name: Language Label: Language Group: Lang Data: English – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Andrea+Domínguez-Lara%22">Andrea Domínguez-Lara</searchLink><br /><searchLink fieldCode="AR" term="%22Wulfrano+Arturo+Luna-Ramírez%22">Wulfrano Arturo Luna-Ramírez</searchLink> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="SO" term="%22International+Association+for+Development+of+the+Information+Society%22"><i>International Association for Development of the Information Society</i></searchLink>. 2022 (Sustainability). – Name: Avail Label: Availability Group: Avail Data: International Association for the Development of the Information Society. e-mail: secretariat@iadis.org; Web site: http://www.iadisportal.org – Name: PeerReviewed Label: Peer Reviewed Group: SrcInfo Data: Y – Name: Pages Label: Page Count Group: Src Data: 5 – Name: DatePubCY Label: Publication Date Group: Date Data: 2022 – Name: TypeDocument Label: Document Type Group: TypDoc Data: Speeches/Meeting Papers<br />Reports - Descriptive – Name: Subject Label: Descriptors Group: Su Data: <searchLink fieldCode="DE" term="%22Programming%22">Programming</searchLink><br /><searchLink fieldCode="DE" term="%22Coding%22">Coding</searchLink><br /><searchLink fieldCode="DE" term="%22Computer+Software%22">Computer Software</searchLink><br /><searchLink fieldCode="DE" term="%22Programming+Languages%22">Programming Languages</searchLink><br /><searchLink fieldCode="DE" term="%22Automation%22">Automation</searchLink><br /><searchLink fieldCode="DE" term="%22Databases%22">Databases</searchLink><br /><searchLink fieldCode="DE" term="%22Concept+Mapping%22">Concept Mapping</searchLink><br /><searchLink fieldCode="DE" term="%22Data%22">Data</searchLink><br /><searchLink fieldCode="DE" term="%22Models%22">Models</searchLink><br /><searchLink fieldCode="DE" term="%22Mathematical+Formulas%22">Mathematical Formulas</searchLink><br /><searchLink fieldCode="DE" term="%22Semantics%22">Semantics</searchLink><br /><searchLink fieldCode="DE" term="%22Computer+Science+Education%22">Computer Science Education</searchLink><br /><searchLink fieldCode="DE" term="%22Engineering+Technology%22">Engineering Technology</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: The automatic code generation is the process of generating source code snippets from a program, i.e., code for generating code. Its importance lies in facilitating software development, particularly important is helping in the implementation of software designs such as engineering diagrams, in such a case, automatic code generation copes with the problem of how to obtain code from a graphic representation, for instance an UML diagram or a Relational Diagram. Some advantages of automatic code generation are: a) to obtain the source code more quickly and to do it with lower margins of error; b) it is promising to be applied in teaching contexts, whilst provide instructors with a tool to teach, the expected results of assignments can be assessed by comparing the results of students and the automatic generated code. Furthermore, one of the most frequently tasks in classrooms when teaching relational databases is the design of Entity-Relationship Diagrams which eventually become SQL code. The manual transition from an Entity-Relationship Diagram to SQL code is a time-consuming process and requires of a skilled eye to be successfully performed. In this paper, we present "DerSql," an extension of the DIA Diagrammer, a well-known free software engineering tool, to automatically generate SQL code from an Entity-Relationship Diagrams. The results are tested for the case of 1 -- 1 and 1 -- n arities relationships. We consider that "DerSql" represents a remarkable tool for teaching while it is a promising advance in developing DIA as a 4th Generation software engineering application. [For the full proceedings, see ED638044.] – Name: AbstractInfo Label: Abstractor Group: Ab Data: As Provided – Name: DateEntry Label: Entry Date Group: Date Data: 2024 – Name: AN Label: Accession Number Group: ID Data: ED638362 |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=eric&AN=ED638362 |
| RecordInfo | BibRecord: BibEntity: Languages: – Text: English PhysicalDescription: Pagination: PageCount: 5 Subjects: – SubjectFull: Programming Type: general – SubjectFull: Coding Type: general – SubjectFull: Computer Software Type: general – SubjectFull: Programming Languages Type: general – SubjectFull: Automation Type: general – SubjectFull: Databases Type: general – SubjectFull: Concept Mapping Type: general – SubjectFull: Data Type: general – SubjectFull: Models Type: general – SubjectFull: Mathematical Formulas Type: general – SubjectFull: Semantics Type: general – SubjectFull: Computer Science Education Type: general – SubjectFull: Engineering Technology Type: general Titles: – TitleFull: DerSql, Generating SQL from an Entity-Relation Diagram Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Andrea Domínguez-Lara – PersonEntity: Name: NameFull: Wulfrano Arturo Luna-Ramírez IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 01 Type: published Y: 2022 Numbering: – Type: issue Value: Sustainability Titles: – TitleFull: International Association for Development of the Information Society Type: main |
| ResultId | 1 |