Integration and querying of heterogeneous, autonomous, distributed database systems

Today, databases have become an integral part of information systems. In the past two decades, we have seen different database systems being developed independently and used in different applications domains. Today's interconnected networks and advanced applications, such as data warehousing, data mining & knowledge discovery and intelligent data access to information on the Web, have created a need for integrated access to such heterogeneous, autonomous, distributed database systems. Heterogeneous/multidatabase research has focused on this issue resulting in many different approaches. However, a single, generally accepted methodology in academia or industry has not emerged providing ubiquitous intelligent data access from heterogeneous, autonomous, distributed information sources. ^ This thesis describes a heterogeneous database system being developed at High-performance Database Research Center (HPDRC). A major impediment to ubiquitous deployment of multidatabase technology is the difficulty in resolving semantic heterogeneity. That is, identifying related information sources for integration and querying purposes. Our approach considers the semantics of the meta-data constructs in resolving this issue. The major contributions of the thesis work include: (i) providing a scalable, easy-to-implement architecture for developing a heterogeneous multidatabase system, utilizing Semantic Binary Object-oriented Data Model (Sem-ODM) and Semantic SQL query language to capture the semantics of the data sources being integrated and to provide an easy-to-use query facility; (ii) a methodology for semantic heterogeneity resolution by investigating into the extents of the meta-data constructs of component schemas. This methodology is shown to be correct, complete and unambiguous; (iii) a semi-automated technique for identifying semantic relations, which is the basis of semantic knowledge for integration and querying, using shared ontologies for context-mediation; (iv) resolutions for schematic conflicts and a language for defining global views from a set of component Sem-ODM schemas; (v) design of a knowledge base for storing and manipulating meta-data and knowledge acquired during the integration process. This knowledge base acts as the interface between integration and query processing modules; (vi) techniques for Semantic SQL query processing and optimization based on semantic knowledge in a heterogeneous database environment; and (vii) a framework for intelligent computing and communication on the Internet applying the concepts of our work. ^

Effects of academic integration on the persistence and achievement of under-prepared college students

The purpose of this dissertation was to examine the effect of academic integration, defined in terms of instructor/student contact, on the persistence of under-prepared college students and the achievement of those who persist. The overall design of this study compared instructor-initiated contact with conventional contact. The dependent variables were persistence, achievement, motivation and anxiety. Information was collected by administering the College-Level Mathematics Test (CLM), the Perceived Affective Contact Questionnaire (PAC), the expectancy and anxiety components of the Motivated Strategies for Learning Questionnaire (MSLQ), a departmental final examination, and by accessing university records. The sample consisted of 130 college algebra students at a large, public university with a Hispanic majority. The main analyses consisted of a 2 x 2 x 2 ANOVA (treatment by ethnicity by gender) to test for differences in achievement, t-tests to compare motivation, anxiety and perceived affective contact scores for the two groups, Chi-square tests to assess differences in persistence, and Pearson Product-Moment Correlation to determine the relationship between pretest scores and achievement variables. Results indicated that neither instructor-initiated contact, gender nor ethnicity is related to persistence, motivation or anxiety. A significant disordinal interaction of treatment and ethnicity was observed, with Hispanic experimental students scoring significantly higher on a test of algebra achievement than Hispanic control students. ^ Academic integration, defined in terms of instructor/student contact, has a positive influence on the achievement of Hispanic students. This may imply their positive responsiveness to the relational aspect of contact due to traditional cultural values of interdependence, acquiescence to authority and physical closeness. Such interactive feedback is a means by which students with these values are recognized as members of the university academic community, prompting increased academic effort. Training in contact initiation to promote academic integration is implied, by the results of this study, for instructors dealing with first year students, especially instructors at institutions accommodating instructional methods to the needs of diverse groups. ^

Effective knowledge integration in emergency response organizations

Natural and man-made disasters have gained attention at all levels of policy-making in recent years. Emergency management tasks are inherently complex and unpredictable, and often require coordination among multiple organizations across different levels and locations. Effectively managing various knowledge areas and the organizations involved has become a critical emergency management success factor. However, there is a general lack of understanding about how to describe and assess the complex nature of emergency management tasks and how knowledge integration can help managers improve emergency management task performance. ^ The purpose of this exploratory research was first, to understand how emergency management operations are impacted by tasks that are complex and inter-organizational and second, to investigate how knowledge integration as a particular knowledge management strategy can improve the efficiency and effectiveness of the emergency tasks. Three types of specific knowledge were considered: context-specific, technology-specific, and context-and-technology-specific. ^ The research setting was the Miami-Dade Emergency Operations Center (EOC) and the study was based on the survey responses from the participants in past EOC activations related to their emergency tasks and knowledge areas. The data included task attributes related to complexity, knowledge area, knowledge integration, specificity of knowledge, and task performance. The data was analyzed using multiple linear regressions and path analyses, to (1) examine the relationships between task complexity, knowledge integration, and performance, (2) the moderating effects of each type of specific knowledge on the relationship between task complexity and performance, and (3) the mediating role of knowledge integration. ^ As per theory-based propositions, the results indicated that overall component complexity and interactive complexity tend to have a negative effect on task performance. But surprisingly, procedural rigidity tended to have a positive effect on performance in emergency management tasks. Also as per our expectation, knowledge integration had a positive relationship with task performance. Interestingly, the moderating effects of each type of specific knowledge on the relationship between task complexity and performance were varied and the extent of mediation of knowledge integration depended on the dimension of task complexity. ^

Exploring the integration of data mining and data visualization

Due to the rapid advances in computing and sensing technologies, enormous amounts of data are being generated everyday in various applications. The integration of data mining and data visualization has been widely used to analyze these massive and complex data sets to discover hidden patterns. For both data mining and visualization to be effective, it is important to include the visualization techniques in the mining process and to generate the discovered patterns for a more comprehensive visual view. In this dissertation, four related problems: dimensionality reduction for visualizing high dimensional datasets, visualization-based clustering evaluation, interactive document mining, and multiple clusterings exploration are studied to explore the integration of data mining and data visualization. In particular, we 1) propose an efficient feature selection method (reliefF + mRMR) for preprocessing high dimensional datasets; 2) present DClusterE to integrate cluster validation with user interaction and provide rich visualization tools for users to examine document clustering results from multiple perspectives; 3) design two interactive document summarization systems to involve users efforts and generate customized summaries from 2D sentence layouts; and 4) propose a new framework which organizes the different input clusterings into a hierarchical tree structure and allows for interactive exploration of multiple clustering solutions.

Effects of academic integration on the persistence and achievement of under-prepared college students

The purpose of this dissertation was to examine the effect of academic integration, defined in terms of instructor/student contact, on the persistence of under-prepared college students and the achievement of those who persist. The overall design of this study compared instructor-initiated contact with conventional contact. The dependent variables were persistence, achievement, motivation and anxiety. Information was collected by administering the College-Level Mathematics Test (CLM), the Perceived Affective Contact Questionnaire (PAC), the expectancy and anxiety components of the Motivated Strategies for Learning Questionnaire (MSLQ), a departmental final examination, and by accessing university records. The sample consisted of 130 college algebra students at a large, public university with a Hispanic majority. The main analyses consisted of a 2x2x2 ANOVA (treatment by ethnicity by gender) to test for differences in achievement, t-tests to compare motivation, anxiety and perceived affective contact scores for the two groups, Chi-square tests to assess differences in persistence, and Pearson Product-Moment Correlation to determine the relationship between pretest scores and achievement variables. Results indicated that neither instructor-initiated contact, gender nor ethnicity is related to persistence, motivation or anxiety. A significant disordinal interaction of treatment and ethnicity was observed, with Hispanic experimental students scoring significantly higher on a test of algebra achievement than Hispanic control students. Academic integration, defined in terms of instructor/student contact, has a positive influence on the achievement of Hispanic students. This may imply their positive responsiveness to the relational aspect of contact due to traditional cultural values of interdependence, acquiescence to authority and physical closeness. Such interactive feedback is a means by which students with these values are recognized as members of the university academic community, prompting increased academic effort. Training in contact initiation to promote academic integration is implied, by the results of this study, for instructors dealing with first year students, especially instructors at institutions accommodating instructional methods to the needs of diverse groups.

Integration and querying of heterogeneous, autonomous, distributed database systems

Today, databases have become an integral part of information systems. In the past two decades, we have seen different database systems being developed independently and used in different applications domains. Today's interconnected networks and advanced applications, such as data warehousing, data mining & knowledge discovery and intelligent data access to information on the Web, have created a need for integrated access to such heterogeneous, autonomous, distributed database systems. Heterogeneous/multidatabase research has focused on this issue resulting in many different approaches. However, a single, generally accepted methodology in academia or industry has not emerged providing ubiquitous intelligent data access from heterogeneous, autonomous, distributed information sources. This thesis describes a heterogeneous database system being developed at Highperformance Database Research Center (HPDRC). A major impediment to ubiquitous deployment of multidatabase technology is the difficulty in resolving semantic heterogeneity. That is, identifying related information sources for integration and querying purposes. Our approach considers the semantics of the meta-data constructs in resolving this issue. The major contributions of the thesis work include: (i.) providing a scalable, easy-to-implement architecture for developing a heterogeneous multidatabase system, utilizing Semantic Binary Object-oriented Data Model (Sem-ODM) and Semantic SQL query language to capture the semantics of the data sources being integrated and to provide an easy-to-use query facility; (ii.) a methodology for semantic heterogeneity resolution by investigating into the extents of the meta-data constructs of component schemas. This methodology is shown to be correct, complete and unambiguous; (iii.) a semi-automated technique for identifying semantic relations, which is the basis of semantic knowledge for integration and querying, using shared ontologies for context-mediation; (iv.) resolutions for schematic conflicts and a language for defining global views from a set of component Sem-ODM schemas; (v.) design of a knowledge base for storing and manipulating meta-data and knowledge acquired during the integration process. This knowledge base acts as the interface between integration and query processing modules; (vi.) techniques for Semantic SQL query processing and optimization based on semantic knowledge in a heterogeneous database environment; and (vii.) a framework for intelligent computing and communication on the Internet applying the concepts of our work.