The Experts below are selected from a list of 240 Experts worldwide ranked by ideXlab platform
Dowming Yeh - One of the best experts on this subject based on the ideXlab platform.
-
Extracting entity-relationship diagram from a table-based Legacy Database
Journal of Systems and Software, 2008Co-Authors: Dowming Yeh, William C. ChuAbstract:Current Database reverse engineering researches presume that the information regarding semantics of attributes, primary keys, and foreign keys in Database tables is complete. However, this may not be the case. In a recent DBRE effort to derive a data model from a table-based Database system, we find the data content of many attributes are not related to their names at all. In this paper, we present a process that extracts an extended entity-relationship diagram from a table-based Database with little descriptions for the fields in its tables and no description for keys. The primary inputs of our approach are system display forms, table schema and data instance. We utilize screen displays to construct form instances. Secondly, code analysis and data analysis involving comparisons of fields and decomposition of fields are applied to extract attribute semantics from forms and table schemas, followed by the determination of primary keys, foreign keys and constraints of the Database system. In the final step of conceptualization, with the processes of table mergence and relationship identification, an extended ER diagram is successfully extracted in a case study.
-
extracting entity relationship diagram from a table based Legacy Database
Conference on Software Maintenance and Reengineering, 2005Co-Authors: Dowming YehAbstract:Current Database reverse engineering researches presume that the information regarding semantics of attributes, primary keys, and foreign keys in Database tables is complete. However, this may not be the case. In this paper, we present a process that extracts an extended entity relationship diagram from a table-based Database with little descriptions for the fields in its tables and no description for keys. The primary inputs of our approach are system display forms and table schema. An extended ER diagram is successfully extracted in a case study.
-
CSMR - Extracting entity relationship diagram from a table-based Legacy Database
Ninth European Conference on Software Maintenance and Reengineering, 1Co-Authors: Dowming YehAbstract:Current Database reverse engineering researches presume that the information regarding semantics of attributes, primary keys, and foreign keys in Database tables is complete. However, this may not be the case. In this paper, we present a process that extracts an extended entity relationship diagram from a table-based Database with little descriptions for the fields in its tables and no description for keys. The primary inputs of our approach are system display forms and table schema. An extended ER diagram is successfully extracted in a case study.
Shamkant Navathe - One of the best experts on this subject based on the ideXlab platform.
-
A Framework for Method-Specific Knowledge Compilation from Databases
Journal of Intelligent Information Systems, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called INTERACTIVE KRITIK is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
Method-specific knowledge compilation
Massive Computing, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
AID - Method-Specific Knowledge Compilation: Towards Practical Design Support Systems
Artificial Intelligence in Design ’98, 1998Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Modern knowledge systems for design typically employ multiple problem-solving methods which in turn use different kinds of knowledge. The construction of a heterogeneous knowledge system that can support practical design thus raises two fundamental questions: how to accumulate huge volumes of design information, and how to support heterogeneous design processing? Fortunately, partial answers to both questions exist separately. Legacy Databases already contain huge amounts of general-purpose design information. In addition, modern knowledge systems typically characterize the kinds of knowledge needed by specific problem-solving methods quite precisely. This leads us to hypothesize method-specific data-to-knowledge compilation as a potential mechanism for integrating heterogeneous knowledge systems and Legacy Databases for design. In this paper, first we outline a general computational architecture called HIPED for this integration. Then, we focus on the specific issue of how to convert data accessed from a Legacy Database into a form appropriate to the problem-solving method used in a heterogeneous knowledge system. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The limited experiment indicates the computational feasibility of method-specific data-to-knowledge compilation, but also raises additional research issues.
-
ISMIS - From Data to Knowledge: Method-Specific Transformations
Lecture Notes in Computer Science, 1997Co-Authors: Michael J. Donahoo, J. William Murdock, Ashok K. Goel, Shamkant Navathe, Edward OmiecinskiAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two hard questions: how to accumulate huge volumes of knowledge, and how to support heterogeneous knowledge and processing? One answer to the first question is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this answer. HIPED converts the second question above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system? One answer to this reformed question is to use method-specific transformation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The experiment indicates the computational feasibility of method-specific data-to-knowledge transformations.
Diptikalyan Saha - One of the best experts on this subject based on the ideXlab platform.
-
service mining from Legacy Database applications
International Conference on Web Services, 2015Co-Authors: Diptikalyan SahaAbstract:As software consumption is shifting to mobile platforms, enterprises are looking for efficient ways to reuse their existing Legacy systems by exposing their functionalities as services. Mining services from Legacy code is therefore an important problem for the enterprises. In this paper we present a technique for mining service candidates from the Database applications. Central to our mining technique is the specification and identification of data-access patterns which specify how a program interacts with the Databases. In addition to finding service candidates which are internal functions in the source code, we also provide an algorithm to expose the function as a stateless service by generating a wrapper function around the internal function. We demonstrate the effectiveness of our technique on two open source applications and twelve industrial applications.
-
ICWS - Service Mining from Legacy Database Applications
2015 IEEE International Conference on Web Services, 2015Co-Authors: Diptikalyan SahaAbstract:As software consumption is shifting to mobile platforms, enterprises are looking for efficient ways to reuse their existing Legacy systems by exposing their functionalities as services. Mining services from Legacy code is therefore an important problem for the enterprises. In this paper we present a technique for mining service candidates from the Database applications. Central to our mining technique is the specification and identification of data-access patterns which specify how a program interacts with the Databases. In addition to finding service candidates which are internal functions in the source code, we also provide an algorithm to expose the function as a stateless service by generating a wrapper function around the internal function. We demonstrate the effectiveness of our technique on two open source applications and twelve industrial applications.
J. William Murdock - One of the best experts on this subject based on the ideXlab platform.
-
A Framework for Method-Specific Knowledge Compilation from Databases
Journal of Intelligent Information Systems, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called INTERACTIVE KRITIK is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
Method-specific knowledge compilation
Massive Computing, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
AID - Method-Specific Knowledge Compilation: Towards Practical Design Support Systems
Artificial Intelligence in Design ’98, 1998Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Modern knowledge systems for design typically employ multiple problem-solving methods which in turn use different kinds of knowledge. The construction of a heterogeneous knowledge system that can support practical design thus raises two fundamental questions: how to accumulate huge volumes of design information, and how to support heterogeneous design processing? Fortunately, partial answers to both questions exist separately. Legacy Databases already contain huge amounts of general-purpose design information. In addition, modern knowledge systems typically characterize the kinds of knowledge needed by specific problem-solving methods quite precisely. This leads us to hypothesize method-specific data-to-knowledge compilation as a potential mechanism for integrating heterogeneous knowledge systems and Legacy Databases for design. In this paper, first we outline a general computational architecture called HIPED for this integration. Then, we focus on the specific issue of how to convert data accessed from a Legacy Database into a form appropriate to the problem-solving method used in a heterogeneous knowledge system. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The limited experiment indicates the computational feasibility of method-specific data-to-knowledge compilation, but also raises additional research issues.
-
ISMIS - From Data to Knowledge: Method-Specific Transformations
Lecture Notes in Computer Science, 1997Co-Authors: Michael J. Donahoo, J. William Murdock, Ashok K. Goel, Shamkant Navathe, Edward OmiecinskiAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two hard questions: how to accumulate huge volumes of knowledge, and how to support heterogeneous knowledge and processing? One answer to the first question is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this answer. HIPED converts the second question above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system? One answer to this reformed question is to use method-specific transformation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The experiment indicates the computational feasibility of method-specific data-to-knowledge transformations.
Michael J. Donahoo - One of the best experts on this subject based on the ideXlab platform.
-
A Framework for Method-Specific Knowledge Compilation from Databases
Journal of Intelligent Information Systems, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called INTERACTIVE KRITIK is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
Method-specific knowledge compilation
Massive Computing, 2001Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two challenging issues: how to accumulate huge volumes of knowledge and how to support heterogeneous knowledge and processing. One approach to the first issue is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this approach. HIPED converts the second issue above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system. One approach to this reformed issue is to use method-specific compilation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database. The experiment indicates the computational feasibility of method-specific data-to-knowledge compilation.
-
AID - Method-Specific Knowledge Compilation: Towards Practical Design Support Systems
Artificial Intelligence in Design ’98, 1998Co-Authors: J. William Murdock, Ashok K. Goel, Michael J. Donahoo, Shamkant NavatheAbstract:Modern knowledge systems for design typically employ multiple problem-solving methods which in turn use different kinds of knowledge. The construction of a heterogeneous knowledge system that can support practical design thus raises two fundamental questions: how to accumulate huge volumes of design information, and how to support heterogeneous design processing? Fortunately, partial answers to both questions exist separately. Legacy Databases already contain huge amounts of general-purpose design information. In addition, modern knowledge systems typically characterize the kinds of knowledge needed by specific problem-solving methods quite precisely. This leads us to hypothesize method-specific data-to-knowledge compilation as a potential mechanism for integrating heterogeneous knowledge systems and Legacy Databases for design. In this paper, first we outline a general computational architecture called HIPED for this integration. Then, we focus on the specific issue of how to convert data accessed from a Legacy Database into a form appropriate to the problem-solving method used in a heterogeneous knowledge system. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The limited experiment indicates the computational feasibility of method-specific data-to-knowledge compilation, but also raises additional research issues.
-
ISMIS - From Data to Knowledge: Method-Specific Transformations
Lecture Notes in Computer Science, 1997Co-Authors: Michael J. Donahoo, J. William Murdock, Ashok K. Goel, Shamkant Navathe, Edward OmiecinskiAbstract:Generality and scale are important but difficult issues in knowledge engineering. At the root of the difficulty lie two hard questions: how to accumulate huge volumes of knowledge, and how to support heterogeneous knowledge and processing? One answer to the first question is to reuse Legacy knowledge systems, integrate knowledge systems with Legacy Databases, and enable sharing of the Databases by multiple knowledge systems. We present an architecture called HIPED for realizing this answer. HIPED converts the second question above into a new form: how to convert data accessed from a Legacy Database into a form appropriate to the processing method used in a Legacy knowledge system? One answer to this reformed question is to use method-specific transformation of data into knowledge. We describe an experiment in which a Legacy knowledge system called Interactive Kritik is integrated with an ORACLE Database using IDI as the communication tool. The experiment indicates the computational feasibility of method-specific data-to-knowledge transformations.