Skip to main content

Pavle Mogin

Followers

5

Following

2

Co-authors

2

Public Views

Stellan Ohlsson

University of Illinois at Chicago

Carnegie Mellon University

Anjana Weerasinghe

Nilufar Baghaei

Unitec New Zealand

University of Southern California

North Carolina State University

Zufferey Sandrine

University of Bern

Carnegie Mellon University

Simon Gregory Jerome

Daniel Chernobrov

Interests

Uploads

Papers by Pavle Mogin

Evaluating a General Model of Adaptive Tutorial Dialogues

Lecture Notes in Computer Science, 2011

Tutorial dialogues are considered as one of the critical factors contributing to the effectivenes... more Tutorial dialogues are considered as one of the critical factors contributing to the effectiveness of human one-on-one tutoring. We discuss how we evaluated the effectiveness of a general model of adaptive tutorial dialogues in both an ill-defined and a well-defined task. The first study involved dialogues in database design, an ill-defined task. The control group participants received non-adaptive dialogues regardless of their knowledge level and explanation skills. The experimental group participants received adaptive dialogues that were customised based on their student models. The performance on pre-and post-tests indicate that the experimental group participants learned significantly more than their peers. The second study involved dialogues in data normalization, a well-defined task. The performance of the experimental group increased significantly between pre-and post-test, while the improvement of the control group was not significant. The studies show that the model is applicable to both ill-and well-defined tasks, and that they support learning effectively.

GENERISANJE RELACIONE ŠEME BAZE PODATAKA ZASNOVANO NA KONCEPTU TIPA FORME GENERATING RELATIONAL DATABASE SCHEMA BASED ON THE FORM TYPE CONCEPT

by Ivan Luković and Pavle Mogin

On The Role of Subschema as A Component of The Implementation Specification of A Program

by Pavle Mogin and Ivan Luković

An Approach to Database Design

by Pavle Mogin and Ivan Luković

An approach to the platform independent specification of a business application

by Ivan Luković and Pavle Mogin

Relational database schema design and application generating using IIS* CASE tool

by Pavle Mogin and Ivan Luković

Database Design Principles

by Pavle Mogin and Ivan Luković

A generator of SQL schema specifications

by Pavle Mogin and Ivan Luković

Computer Science and Information Systems, 2007

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of compl... more IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3 rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.

Generating XML based specifications of information systems

by Pavle Mogin and Ivan Luković

This paper outlines a methodology for designing information systems based on XML. The methodology... more This paper outlines a methodology for designing information systems based on XML. The methodology uses XML DTDs to define the design standards, and the structure and constraints of the design specifications. The result of the design process is a set of valid XML documents that are the specifications of transaction programs and applications of the information system. At the start of a design process, the methodology uses a CASE tool to map user requirements into initial XML specifications. Final design specifications are produced by a sequence of XSL transformations of the initial XML specifications. A key feature of the methodology is that it produces a platform independent design of an information system. To enable an early feedback from users, the methodology uses further XSL transformations that produce an executable prototype of the information system in the Java programming environment.

Faceoff: Surrogate vs. Natural Keys

by Pavle Mogin, Ivan Luković, and Milan Celikovic

Lecture Notes in Computer Science, 2010

The natural and surrogate key architectures are two competing approaches to specifying keys in re... more The natural and surrogate key architectures are two competing approaches to specifying keys in relational databases. We analyze the performance of these approaches with respect to the update complexity and the query data and expression complexity. Our results provide new insights into the advantages and disadvantages of both approaches.

An approach to developing complex database schemas using form types

by Pavle Mogin and Ivan Luković

Software: Practice and Experience, 2007

In this paper we consider an approach to developing complex database schemas. Apart from the theo... more In this paper we consider an approach to developing complex database schemas. Apart from the theoretical model of the approach, we also developed a CASE tool named Integrated Information Systems*Case, R.6.2 (IIS*Case) that supports the practical application of the approach. In this paper the basis of our approach to the design and integration of database schemas and ways of using IIS*Case is outlined. The main features of a new version of IIS*Case, developed in Java, are described. IIS*Case is based on the concept of 'form type' and supports the conceptual modelling of a database schema, generating subschemas and integrating them into a relational database schema in 3NF. IIS*Case provides an intelligent support for complex and highly formalized design and programming tasks. Having an advanced knowledge of information systems and database design is not a compulsory prerequisite for using IIS*Case. IIS*Case is based on a methodology of gradual integration of independently designed subschemas into a database schema. The process of independent subschema design may lead to collisions in expressing real-world constraints. IIS*Case uses specialized algorithms for checking the consistency of constraints embedded in a database schema and its subschemas. This paper briefly outlines the application of the process of detecting collisions, and actions the designer may take to resolve them.

Functional dependency collisions resolving in the course of database schema integration

by Pavle Mogin and Ivan Luković

Info Science, 1997

The process of subschema set integration into relational database schema, which is proposed in th... more

LOSSLESS JOINS OF RELATIONAL DATABASE VIEWS

by Pavle Mogin and Ivan Luković

emis.ams.org

50 I.Lükovic, P.Mogin of lossless join preservation and preservation of initial constraint set ar... more

RESOLVING DATABASE CONSTRAINT COLLISIONS USING IIS* CASE TOOL

by Ivan Luković and Pavle Mogin

Journal of Information and …, 2007

Abstracts Integrated Information Systems*Case (IIS*Case) R.6.21 is a CASE tool that we developed ... more

Principi baza podataka

by Pavle Mogin and Ivan Luković

Principi projektovanja baza podataka

by Pavle Mogin and Ivan Luković

The Structure of A Subschema and Its XML Specification

by Ivan Luković and Pavle Mogin

JIOS

69 THE STRUCTURE OF A SUBSCHEMA AND ITS XML SPECIFICATION Ivan Luković University of Novi Sad, Yu... more

Database Schema Integration ProcessA Methodology and Aspects of Its Applying

by Ivan Luković and Pavle Mogin

Sad Journal of Mathematics ( …, 2006

Abstract. The paper considers an original approach to the process of integration of complex datab... more

Performance Evaluation of Natural and Surrogate Key Database Architectures

by Pavle Mogin and Ivan Luković

Keys allow a database management system to uniquely identify tuples in a database. Consequently, ... more Keys allow a database management system to uniquely identify tuples in a database. Consequently, the class of keys is of a great significance for almost all data processing tasks. There are two competing approaches to specifying keys in relational databases. These are natural and surrogate key architectures. A natural key is an attribute subset of the relation schema that is known to users. A surrogate key is a singleton attribute with system-generated values that are invisible to users. In the paper, we analyze the performance of these approaches with respect to different measures. These include the disk storage space, the number of indices, the update complexity, as well as the query data and expression complexity. In the analysis we use simple mathematical models and estimates of database performance. Our results provide new insights into the advantages and disadvantages of both approaches.

A Methodology of A Database Schema Design Using The Subschemas

by Ivan Luković and Pavle Mogin

Proceedings of IEEE International …, 2003

Page 1. A Methodology of A Database Schema Design Using The Subschemas Ivan Luković University of... more

Evaluating a General Model of Adaptive Tutorial Dialogues

Lecture Notes in Computer Science, 2011

Tutorial dialogues are considered as one of the critical factors contributing to the effectivenes... more Tutorial dialogues are considered as one of the critical factors contributing to the effectiveness of human one-on-one tutoring. We discuss how we evaluated the effectiveness of a general model of adaptive tutorial dialogues in both an ill-defined and a well-defined task. The first study involved dialogues in database design, an ill-defined task. The control group participants received non-adaptive dialogues regardless of their knowledge level and explanation skills. The experimental group participants received adaptive dialogues that were customised based on their student models. The performance on pre-and post-tests indicate that the experimental group participants learned significantly more than their peers. The second study involved dialogues in data normalization, a well-defined task. The performance of the experimental group increased significantly between pre-and post-test, while the improvement of the control group was not significant. The studies show that the model is applicable to both ill-and well-defined tasks, and that they support learning effectively.

GENERISANJE RELACIONE ŠEME BAZE PODATAKA ZASNOVANO NA KONCEPTU TIPA FORME GENERATING RELATIONAL DATABASE SCHEMA BASED ON THE FORM TYPE CONCEPT

by Ivan Luković and Pavle Mogin

On The Role of Subschema as A Component of The Implementation Specification of A Program

by Pavle Mogin and Ivan Luković

An Approach to Database Design

by Pavle Mogin and Ivan Luković

An approach to the platform independent specification of a business application

by Ivan Luković and Pavle Mogin

Relational database schema design and application generating using IIS* CASE tool

by Pavle Mogin and Ivan Luković

Database Design Principles

by Pavle Mogin and Ivan Luković

A generator of SQL schema specifications

by Pavle Mogin and Ivan Luković

Computer Science and Information Systems, 2007

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of compl... more IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3 rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.

Generating XML based specifications of information systems

by Pavle Mogin and Ivan Luković

This paper outlines a methodology for designing information systems based on XML. The methodology... more This paper outlines a methodology for designing information systems based on XML. The methodology uses XML DTDs to define the design standards, and the structure and constraints of the design specifications. The result of the design process is a set of valid XML documents that are the specifications of transaction programs and applications of the information system. At the start of a design process, the methodology uses a CASE tool to map user requirements into initial XML specifications. Final design specifications are produced by a sequence of XSL transformations of the initial XML specifications. A key feature of the methodology is that it produces a platform independent design of an information system. To enable an early feedback from users, the methodology uses further XSL transformations that produce an executable prototype of the information system in the Java programming environment.

Faceoff: Surrogate vs. Natural Keys

by Pavle Mogin, Ivan Luković, and Milan Celikovic

Lecture Notes in Computer Science, 2010

The natural and surrogate key architectures are two competing approaches to specifying keys in re... more The natural and surrogate key architectures are two competing approaches to specifying keys in relational databases. We analyze the performance of these approaches with respect to the update complexity and the query data and expression complexity. Our results provide new insights into the advantages and disadvantages of both approaches.

An approach to developing complex database schemas using form types

by Pavle Mogin and Ivan Luković

Software: Practice and Experience, 2007

In this paper we consider an approach to developing complex database schemas. Apart from the theo... more In this paper we consider an approach to developing complex database schemas. Apart from the theoretical model of the approach, we also developed a CASE tool named Integrated Information Systems*Case, R.6.2 (IIS*Case) that supports the practical application of the approach. In this paper the basis of our approach to the design and integration of database schemas and ways of using IIS*Case is outlined. The main features of a new version of IIS*Case, developed in Java, are described. IIS*Case is based on the concept of 'form type' and supports the conceptual modelling of a database schema, generating subschemas and integrating them into a relational database schema in 3NF. IIS*Case provides an intelligent support for complex and highly formalized design and programming tasks. Having an advanced knowledge of information systems and database design is not a compulsory prerequisite for using IIS*Case. IIS*Case is based on a methodology of gradual integration of independently designed subschemas into a database schema. The process of independent subschema design may lead to collisions in expressing real-world constraints. IIS*Case uses specialized algorithms for checking the consistency of constraints embedded in a database schema and its subschemas. This paper briefly outlines the application of the process of detecting collisions, and actions the designer may take to resolve them.

Functional dependency collisions resolving in the course of database schema integration

by Pavle Mogin and Ivan Luković

Info Science, 1997

The process of subschema set integration into relational database schema, which is proposed in th... more

LOSSLESS JOINS OF RELATIONAL DATABASE VIEWS

by Pavle Mogin and Ivan Luković

emis.ams.org

50 I.Lükovic, P.Mogin of lossless join preservation and preservation of initial constraint set ar... more

RESOLVING DATABASE CONSTRAINT COLLISIONS USING IIS* CASE TOOL

by Ivan Luković and Pavle Mogin

Journal of Information and …, 2007

Abstracts Integrated Information Systems*Case (IIS*Case) R.6.21 is a CASE tool that we developed ... more

Principi baza podataka

by Pavle Mogin and Ivan Luković

Principi projektovanja baza podataka

by Pavle Mogin and Ivan Luković

The Structure of A Subschema and Its XML Specification

by Ivan Luković and Pavle Mogin

JIOS

69 THE STRUCTURE OF A SUBSCHEMA AND ITS XML SPECIFICATION Ivan Luković University of Novi Sad, Yu... more

Database Schema Integration ProcessA Methodology and Aspects of Its Applying

by Ivan Luković and Pavle Mogin

Sad Journal of Mathematics ( …, 2006

Abstract. The paper considers an original approach to the process of integration of complex datab... more

Performance Evaluation of Natural and Surrogate Key Database Architectures

by Pavle Mogin and Ivan Luković

Keys allow a database management system to uniquely identify tuples in a database. Consequently, ... more Keys allow a database management system to uniquely identify tuples in a database. Consequently, the class of keys is of a great significance for almost all data processing tasks. There are two competing approaches to specifying keys in relational databases. These are natural and surrogate key architectures. A natural key is an attribute subset of the relation schema that is known to users. A surrogate key is a singleton attribute with system-generated values that are invisible to users. In the paper, we analyze the performance of these approaches with respect to different measures. These include the disk storage space, the number of indices, the update complexity, as well as the query data and expression complexity. In the analysis we use simple mathematical models and estimates of database performance. Our results provide new insights into the advantages and disadvantages of both approaches.

A Methodology of A Database Schema Design Using The Subschemas

by Ivan Luković and Pavle Mogin

Proceedings of IEEE International …, 2003

Page 1. A Methodology of A Database Schema Design Using The Subschemas Ivan Luković University of... more