• Title/Summary/Keyword: Table integration

Search Result 84, Processing Time 0.059 seconds

A Table Integration Technique Using Query Similarity Analysis

  • Choi, Go-Bong;Woo, Yong-Tae
    • Journal of the Korea Society of Computer and Information
    • /
    • v.24 no.3
    • /
    • pp.105-112
    • /
    • 2019
  • In this paper, we propose a technique to analyze similarity between SQL queries and to assist integrating similar tables. First, the table information was extracted from the SQL queries through the query structure analyzer, and the similarity between the tables was measured using the Jacquard index technique. Then, similar table clusters are generated through hierarchical cluster analysis method and the co-occurence probability of the table used in the query is calculated. The possibility of integrating similar tables is classified by using the possibility of co-occurence of similarity table and table, and classifying them into an integrable cluster, a cluster requiring expert review, and a cluster with low integration possibility. This technique analyzes the SQL query in practice and analyse the possibility of table integration independent of the existing business, so that the existing schema can be effectively reconstructed without interruption of work or additional cost.

Integration with External Information Using Ontology for Rural Amenity Resources Information Service (농촌어메니티자원 정보서비스를 위한 Ontology를 활용한 외부정보 통합방안)

  • Lee, Ji-Min;Lee, Jeong-Jae
    • Journal of Korean Society of Rural Planning
    • /
    • v.12 no.4 s.33
    • /
    • pp.53-61
    • /
    • 2006
  • Rural amenity resources consist of natural, cultural and social resources. Some of resources have been surveyed in other institutes and organizations and information system about these resources has been constructed. Integrating with information of existing system or database is helpful to produce useful rural amenity resources information to users. This integration of distributed information is based on semantic integration. In this paper, we used ontology for semantic integration and introduced the method of external information integration using ontology. We designed ontology table to represent ontology in database and integrated distributed information using ontology. To examine the improvement of information service efficiency and the applicability, rural amenity resources information and tourist attraction information database were constructed and integrated. Also, the information service efficiency with information integration was evaluated using recall ratio and compared to the information service efficiency without information integration.

Classifier Integration Model for Image Classification (영상 분류를 위한 분류기 통합모델)

  • Park, Dong-Chul
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.49 no.2
    • /
    • pp.96-102
    • /
    • 2012
  • An advanced form of the Partitioned Feature-based Classifier with Expertise Table(PFC-ET) is proposed in this paper. As is the case with the PFC-ET, the proposed classifier model, called Classifier Integration Model(CIM), does not use the entire feature vectors extracted from the original data in a concatenated form to classify each datum, but rather uses groups of features related to each feature vector separately. The proposed CIM utilizes a proportion of selected cluster members instead of the expertise table in PFC-ET to minimize the error in confusion table. The proposed CIM is applied to the classification problem on two data sets, Caltech data set and collected terrain data sets. When compared with PFC model and PFC-ET model. the proposed CIM shows improvements in terms of classification accuracy and post processing efforts.

Design and Implementation of a Scenario Composition Supporting Tool for Object-Oriented Integration Testing Using the Requirement Trace Table (요구사항 추적테이블을 이용한 객체지향 통합 테스트 시나리오 작성지원 도구의 설계 및 구현)

  • Choe, Sin-Hyeong;Han, Pan-Am
    • The KIPS Transactions:PartD
    • /
    • v.9D no.4
    • /
    • pp.651-658
    • /
    • 2002
  • This paper suggests the scenario composition supporting method, which can be used to perform integration test based on specification, and implemented a scenario composition supporting tool. To compose scenario for object-oriented integration testing, requirement specification, Process definition table and program to table relation diagram are used. In addition, requirement trace table is created. It can check user's requirements, quickly and exactly, dividing former three fables into the stages of requirement analysis, design, and test. The output of scenario composition supporting tool plays a guide part in composing scenario. This tool can reduce scenario composition effort of quality for the checking team and prevent an omission of requirement and input of errors during the test.

Improving the mechanical properties of table tennis by adding nanocomposite in its polymer matrix

  • Shuping Xu;Lixin Liang
    • Advances in nano research
    • /
    • v.16 no.4
    • /
    • pp.365-374
    • /
    • 2024
  • This study delves into the significant impact of integrating nanomaterials, specifically carbon and graphene nanoparticles, into the polymer matrix of aluminum alloy 356, utilizing the vortex casting technique, with the aim of improving the mechanical properties of table tennis equipment. Athletes and their coaching teams have long been on a quest for high-performance sports gear, recognizing its pivotal role in unlocking the full potential of players. The dedication of engineers to craft designs, select materials with precision, and uphold stringent testing standards reflects the commitment to meeting the demands of the sporting world. Yet, to remain at the forefront, sports engineering must continually align with contemporary technologies, and nanotechnology has emerged as a transformative force in this regard. This study not only underscores the meticulous efforts in material integration but also highlights the remarkable strides made possible by nanotechnology. Aluminum nanocomposites, particularly, showcase a groundbreaking fusion of exceptional strength and reduced weight, marking a notable achievement in sports equipment innovation. The research outcomes are compelling, revealing a substantial enhancement in the mechanical performance of the sports structures under scrutiny. This promising development hints at a potential paradigm shift in the manufacturing of sports equipment, promising a new era of elevated athlete performance and enhanced safety during the rigors of physical education training. This study stands as a testament to the tangible impact of nanotechnology on the ever-evolving landscape of sports equipment.

The Establishment of an Activity-Based EVM - PMIS Integration Model (액티비티 기반의 EVM - PMIS 통합모델 구축)

  • Na, Kwang-Tae;Kang, Byeung-Hee
    • Journal of the Korea Institute of Building Construction
    • /
    • v.10 no.1
    • /
    • pp.199-212
    • /
    • 2010
  • To establish an infrastructure for technology and information in the domestic construction industry, several construction regulations pertaining to construction information have been institutionalized. However, there are major problems with the domestic information classification system, earned value management (EVM) and project management information system (PMIS). In particular, the functions of the current PMIS have consisted of a builder-oriented system, and as EVM is not applied to PMIS, the functions of reporting, analysis and forecast for owners are lacking. Moreover, owners cannot confirm information on construction schedule and cost in real time due to the differences between the EVM and PMIS operation systems. The purpose of this study is to provide a framework that is capable of operating PMIS efficiently under an e-business environment, by providing a proposal on how to establish a work breakdown structure (WBS) and an EVM - PMIS integration model, so that PMIS may provide the function of EVM, and stakeholders may have all information in common. At the core of EVM - PMIS integration is the idea that EVM and PMIS have the same operation system, in order to be an activity-based system. The principle of the integration is data integration, in which the information field of an activity is connected with the field of a relational database table consisting of sub-modules for the schedule and cost management function of PMIS using a relational database management system. Therefore, the planned value (PV), cost value (CV), actual cost (AC), schedule variance (SV), schedule performance index (SPI), cost variance (CV) and cost performance index (CPI) of an activity are connected with the field of the relational database table for the schedule and cost sub-modules of PMIS.

GIS-based Spatial Integration and Statistical Analysis using Multiple Geoscience Data Sets : A Case Study for Mineral Potential Mapping (다중 지구과학자료를 이용한 GIS 기반 공간통합과 통계량 분석 : 광물 부존 예상도 작성을 위한 사례 연구)

  • 이기원;박노욱;권병두;지광훈
    • Korean Journal of Remote Sensing
    • /
    • v.15 no.2
    • /
    • pp.91-105
    • /
    • 1999
  • Spatial data integration using multiple geo-based data sets has been regarded as one of the primary GIS application issues. As for this issue, several integration schemes have been developed as the perspectives of mathematical geology or geo-mathematics. However, research-based approaches for statistical/quantitative assessments between integrated layer and input layers are not fully considered yet. Related to this niche point, in this study, spatial data integration using multiple geoscientific data sets by known integration algorithms was primarily performed. For spatial integration by using raster-based GIS functionality, geological, geochemical, geophysical data sets, DEM-driven data sets and remotely sensed imagery data sets from the Ogdong area were utilized for geological thematic mapping related by mineral potential mapping. In addition, statistical/quantitative information extraction with respective to relationships among used data sets and/or between each data set and integrated layer was carried out, with the scope of multiple data fusion and schematic statistical assessment methodology. As for the spatial integration scheme, certainty factor (CF) estimation and principal component analysis (PCA) were applied. However, this study was not aimed at direct comparison of both methodologies; whereas, for the statistical/quantitative assessment between integrated layer and input layers, some statistical methodologies based on contingency table were focused. Especially, for the bias reduction, jackknife technique was also applied in PCA-based spatial integration. Through the statistic analyses with respect to the integration information in this case study, new information for relationships of integrated layer and input layers was extracted. In addition, influence effects of input data sets with respect to integrated layer were assessed. This kind of approach provides a decision-making information in the viewpoint of GIS and is also exploratory data analysis in conjunction with GIS and geoscientific application, especially handing spatial integration or data fusion with complex variable data sets.

A Component Transformation Technique based on Model for Composition of EJB and COM+ (EJB와 COM+ 결합을 위한 모델기반 컴포넌트 변환 기법)

  • 최일우;신정은;류성열
    • Journal of KIISE:Software and Applications
    • /
    • v.30 no.12
    • /
    • pp.1172-1184
    • /
    • 2003
  • At present, new techniques based on different component reference models for the integration of component and system of different platforms, such as EJB and COM+, are introduced. The operation between the components in the identical component platform is realized by the composition at the source level. In case of the different component platform, however, it is impossible to use combined components in real condition although they are components of similar domain. In this paper we proposed a solution for the composition problem by using component transformation methodology based on model between EJB and COM+ components which are different components. For the composition between EJB and COM+ components, we compared and analyzed each reference model, then proposed the Virtual Component Model which is implementation independent and the Implementation Table for the mutual conversion. Reffering to the Virtual Component Model and the Implementation Table, we can generalize each Implementation model to the Virtual Component Model, make the Virtual Component Model which is implementation independent through the virtual component modeling, transform EJB and COM+ components selectively. Proposing the effective Model Transformation method to the different component platform, we can combine EJB and COM+ components.

A Study on the Method for Solving Data Heterogeneity in the Integrated Information System (통합 정보시스템에서의 데이터 이질성 해결 방안에 관한 연구)

  • Park, Seong-Jin;Park, Sung-Kong;Park, Hwa-Gyoo
    • Journal of Information Technology Services
    • /
    • v.7 no.4
    • /
    • pp.87-99
    • /
    • 2008
  • As the technologies for telecommunication have been evolving, more enhanced information services and integrated information systems have been introduced, which can manage a variety of information from the heterogeneous systems. The major obstacle for the integrated information systems is the integrating heterogeneous databases in the systems and the heterogeneity problems can be classified into the structural and data heterogeneities. However, the previous researches have mainly highlighted into the solving structural heterogeneity problems. This paper identifies the data heterogeneity problems for multi-database schema integrations and proposes a new solving method. We analyze the semantics equivalence in data values based on the functional dependency, primary and candidate keys, and present a procedural solution of data heterogeneity in the perspective of the concept of attribute equivalence, integration key and conceptual integration table.

Analytical Study on the Seismic Behavior of RC Bridge Columns Using Shaking Table Tests (진동대 실험을 통한 철근콘크리트 교각의 지진거동에 관한 해석적 연구)

  • Kim, Tae-Hoon;Park, Chang-Young;Chung, Young-Soo;Shin, Hyun-Mock
    • Journal of the Earthquake Engineering Society of Korea
    • /
    • v.11 no.5
    • /
    • pp.49-59
    • /
    • 2007
  • The purpose of this study is to investigate the seismic behavior of reinforced concrete bridge columns using shaking table tests. A computer program, named RCAHEST (Reinforced Concrete Analysis in Higher Evaluation System Technology), for the analysis of reinforced concrete structures was used. Material nonlinearity is taken into account by comprising tensile, compressive and shear models of cracked concrete and a model of reinforcing steel. Solution of the equations of motion is obtained by numerical integration using Hither-Hughes-Taylor (HMT) algorithm. The proposed numerical method for the seismic behavior of reinforced concrete bridge columns using shaking table tests is verified by comparison with reliable experimental results.