Il-yeol Song - Academia.edu (original) (raw)

Papers by Il-yeol Song

Information Systems, 2019

Encyclopedia of Database Systems, 2009

Big Data Analytics and Knowledge Discovery, 2020

Clinicians are becoming increasingly dependent on health information technologies (HIT) in their ... more Clinicians are becoming increasingly dependent on health information technologies (HIT) in their daily activities, like data collection. However, currently, most HITs are vendor designed systems, which are often inconsistent and inflexi-ble with respect to the needs of the clinicians. Consequently, time and again, the HITs are found to be unfit for the health-care workflow. A better HIT design is to empower the clini-cians with the ability to modify system functionality as per their needs. In this paper, we propose a flexible Electronic Health Record (fEHR) system, which allows clinicians to build new templates/forms for data collection over an ex-isting EHR system through a user interface. The system automatically translates the forms to underlying databases while shielding the user from knowing the technical details. A key contribution is that the generated databases are high-quality with desirable properties. To test the system usabil-ity, we conducted a user study with clinician...

Encyclopedia of Database Systems, 2018

Data & Knowledge Engineering, 2017

Future Generation Computer Systems, 2016

Expert Systems, 2015

The era of big data has arrived. Big data bring us the data-driven paradigm and enlighten us to c... more The era of big data has arrived. Big data bring us the data-driven paradigm and enlighten us to challenge new classes of problems we were not able to solve in the past. We are beginning to see the impacts of big data in every aspect of our lives and society. We need a science that can address these big data problems. Data science is a new emerging discipline that was termed to address challenges that we are facing and going to face in the big data era. Thus, education in data science is the key to success, and we need concrete strategies and approaches to better educate future data scientists. In this paper, we discuss general concepts on big data, data science, and data scientists and show the results of an extensive survey on current data science education in United States. Finally, we propose various approaches that data science education should aim to accomplish.

Proceedings of the 2003 Information …, 2003

Lecture Notes in Computer Science, 2006

Meta-modeling is a well-known approach for capturing modeling methods and techniques. A meta-mode... more Meta-modeling is a well-known approach for capturing modeling methods and techniques. A meta-model can serve as a basis for quantitative evaluation of methods and techniques. By means of a number of formal metrics based on the meta-model, a quantitative evaluation of methods and techniques becomes possible. Existing meta-modeling languages and measurement schemes do not allow the explicit modeling of so-called multi-modeling techniques. Multi-modeling techniques are techniques that offer a coherent set of aspect modeling techniques to model different aspects of a certain phenomenon. As a consequence, existing approaches lack metrics to quantitatively assess aspects that are particular to multi-modeling techniques. In this chapter, a modeling language for modeling multi-modeling techniques is proposed as well as metrics for evaluating the coherent set of aspect modeling techniques that constitute the multi-modeling technique.

Star schema, which maintains one-to-many relationships between dimensions and a fact table, is wi... more Star schema, which maintains one-to-many relationships between dimensions and a fact table, is widely accepted as the most viable data representation for dimensional analysis. Realworld DW schema, however, frequently includes many-to-many relationships between a dimension and a fact table. Having those relationships in a dimensional model causes several difficult issues, such as losing the simplicity of the star schema structure, increasing complexity in forming queries, and degrading query performance by adding more joins. Therefore, it is desirable to represent the many-to-many relationships with correct semantics while still keeping the structure of the star schema. In this paper, we analyze many-to-many relationships between a dimension table and a fact table in dimensional modeling. We illustrate six different approaches and show the advantages and disadvantages of each. We propose two ad-hoc methods that maintain a star schema structure by denormalizing the dimensions to avoid...

Proceedings of the 2001 InSITE Conference

The UML (Unified Modeling Language) has been widely accepted as a standard language for object-or... more The UML (Unified Modeling Language) has been widely accepted as a standard language for object-oriented analysis and design. Among the UML diagrams, one of the most difficult and time-consuming diagrams to develop is the object interaction diagram (OID), which is rendered as either a sequence diagram or a collaboration diagram. Our experience shows that developers have significant trouble in understanding and developing OIDs. In this paper, we present an effective heuristic for developing interaction diagrams and illustrate the technique with a case study. We found that students effectively developed OIDs using this heuristic method.

Proceedings of the 2001 InSITE Conference

In this paper, we present a case study on the design of a web-based online service delivery syste... more In this paper, we present a case study on the design of a web-based online service delivery system using IBM's Net.Commerce system as well as the lessons learned in completing this project. The design specification is presented using the UML notation, while database schema is presented using the IDEF1X notation. Our design specification includes architecture, system components using package diagrams, system functions using use case diagrams, their processing logic using activity diagrams, and database design. We present a detailed database design and comment on design and customization considerations specific to e-commerce systems. Our experience shows that e-commerce tools still lack certain functionality such as processing back orders, allowing for customizable returns, and sending email notification to users, but overall can speed up the development of the system. Understanding the structure and transaction processing of e-commerce database systems will help system designers ...

Revista de Informática Teórica e Aplicada

Proceedings of the American Society for Information Science and Technology

Journal of Digital Forensics, Security and Law

Information Systems, 2019

Encyclopedia of Database Systems, 2009

Big Data Analytics and Knowledge Discovery, 2020

Clinicians are becoming increasingly dependent on health information technologies (HIT) in their ... more Clinicians are becoming increasingly dependent on health information technologies (HIT) in their daily activities, like data collection. However, currently, most HITs are vendor designed systems, which are often inconsistent and inflexi-ble with respect to the needs of the clinicians. Consequently, time and again, the HITs are found to be unfit for the health-care workflow. A better HIT design is to empower the clini-cians with the ability to modify system functionality as per their needs. In this paper, we propose a flexible Electronic Health Record (fEHR) system, which allows clinicians to build new templates/forms for data collection over an ex-isting EHR system through a user interface. The system automatically translates the forms to underlying databases while shielding the user from knowing the technical details. A key contribution is that the generated databases are high-quality with desirable properties. To test the system usabil-ity, we conducted a user study with clinician...

Encyclopedia of Database Systems, 2018

Data & Knowledge Engineering, 2017

Future Generation Computer Systems, 2016

Expert Systems, 2015

The era of big data has arrived. Big data bring us the data-driven paradigm and enlighten us to c... more The era of big data has arrived. Big data bring us the data-driven paradigm and enlighten us to challenge new classes of problems we were not able to solve in the past. We are beginning to see the impacts of big data in every aspect of our lives and society. We need a science that can address these big data problems. Data science is a new emerging discipline that was termed to address challenges that we are facing and going to face in the big data era. Thus, education in data science is the key to success, and we need concrete strategies and approaches to better educate future data scientists. In this paper, we discuss general concepts on big data, data science, and data scientists and show the results of an extensive survey on current data science education in United States. Finally, we propose various approaches that data science education should aim to accomplish.

Proceedings of the 2003 Information …, 2003

Lecture Notes in Computer Science, 2006

Meta-modeling is a well-known approach for capturing modeling methods and techniques. A meta-mode... more Meta-modeling is a well-known approach for capturing modeling methods and techniques. A meta-model can serve as a basis for quantitative evaluation of methods and techniques. By means of a number of formal metrics based on the meta-model, a quantitative evaluation of methods and techniques becomes possible. Existing meta-modeling languages and measurement schemes do not allow the explicit modeling of so-called multi-modeling techniques. Multi-modeling techniques are techniques that offer a coherent set of aspect modeling techniques to model different aspects of a certain phenomenon. As a consequence, existing approaches lack metrics to quantitatively assess aspects that are particular to multi-modeling techniques. In this chapter, a modeling language for modeling multi-modeling techniques is proposed as well as metrics for evaluating the coherent set of aspect modeling techniques that constitute the multi-modeling technique.

Star schema, which maintains one-to-many relationships between dimensions and a fact table, is wi... more Star schema, which maintains one-to-many relationships between dimensions and a fact table, is widely accepted as the most viable data representation for dimensional analysis. Realworld DW schema, however, frequently includes many-to-many relationships between a dimension and a fact table. Having those relationships in a dimensional model causes several difficult issues, such as losing the simplicity of the star schema structure, increasing complexity in forming queries, and degrading query performance by adding more joins. Therefore, it is desirable to represent the many-to-many relationships with correct semantics while still keeping the structure of the star schema. In this paper, we analyze many-to-many relationships between a dimension table and a fact table in dimensional modeling. We illustrate six different approaches and show the advantages and disadvantages of each. We propose two ad-hoc methods that maintain a star schema structure by denormalizing the dimensions to avoid...

Proceedings of the 2001 InSITE Conference

The UML (Unified Modeling Language) has been widely accepted as a standard language for object-or... more The UML (Unified Modeling Language) has been widely accepted as a standard language for object-oriented analysis and design. Among the UML diagrams, one of the most difficult and time-consuming diagrams to develop is the object interaction diagram (OID), which is rendered as either a sequence diagram or a collaboration diagram. Our experience shows that developers have significant trouble in understanding and developing OIDs. In this paper, we present an effective heuristic for developing interaction diagrams and illustrate the technique with a case study. We found that students effectively developed OIDs using this heuristic method.

Proceedings of the 2001 InSITE Conference

In this paper, we present a case study on the design of a web-based online service delivery syste... more In this paper, we present a case study on the design of a web-based online service delivery system using IBM's Net.Commerce system as well as the lessons learned in completing this project. The design specification is presented using the UML notation, while database schema is presented using the IDEF1X notation. Our design specification includes architecture, system components using package diagrams, system functions using use case diagrams, their processing logic using activity diagrams, and database design. We present a detailed database design and comment on design and customization considerations specific to e-commerce systems. Our experience shows that e-commerce tools still lack certain functionality such as processing back orders, allowing for customizable returns, and sending email notification to users, but overall can speed up the development of the system. Understanding the structure and transaction processing of e-commerce database systems will help system designers ...

Revista de Informática Teórica e Aplicada

Proceedings of the American Society for Information Science and Technology

Journal of Digital Forensics, Security and Law