• 제목/요약/키워드: Analysis Database

검색결과 5,159건 처리시간 0.03초

Identifying the Significance of Factors Affecting Creep of Concrete: A Probabilistic Analysis of RILEM Database

  • Adam, Ihab;Taha, Mahmoud M. Reda
    • International Journal of Concrete Structures and Materials
    • /
    • 제5권2호
    • /
    • pp.97-111
    • /
    • 2011
  • Modeling creep of concrete has been one of the most challenging problems in concrete. Over the years, research has proven the significance of creep and its ability to influence structural behavior through loss of prestress, violation of serviceability limit states or stress redistribution. Because of this, interest in modeling and simulation of creep has grown significantly. A research program was planned to investigate the significance of different factors affecting creep of concrete. This research investigation is divided into two folds: first, an in-depth study of the RILEM creep database and development of a homogenous database that can be used for blind computational analysis. Second: developing a probabilistic Bayesian screening method that enables identifying the significance of the different factors affecting creep of concrete. The probabilistic analysis revealed a group of interacting parameters that seem to significantly influence creep of concrete.

Methodology of Spatio-temporal Matching for Constructing an Analysis Database Based on Different Types of Public Data

  • Jung, In taek;Chong, Kyu soo
    • 한국측량학회지
    • /
    • 제35권2호
    • /
    • pp.81-90
    • /
    • 2017
  • This study aimed to construct an integrated database using the same spatio-temporal unit by employing various public-data types with different real-time information provision cycles and spatial units. Towards this end, three temporal interpolation methods (piecewise constant interpolation, linear interpolation, nonlinear interpolation) and a spatial matching method by district boundaries was proposed. The case study revealed that the linear interpolation is an excellent method, and the spatial matching method also showed good results. It is hoped that various prediction models and data analysis methods will be developed in the future using different types of data in the analysis database.

복부수술환자의 간호진단, 간호중재, 간호결과 연계 데이터베이스 구축 (Construction of Linkage Database on Nursing Diagnoses, Interventions, Outcomes in Abdominal Surgery Patients)

  • 유형숙;지성애
    • 간호행정학회지
    • /
    • 제7권3호
    • /
    • pp.425-437
    • /
    • 2001
  • This reserch was to develop database software in order to handle a lot of clinical nursing data with nursing diagnoses, related factors, defining characteristics, nursing interventions, nursing activities and nursing outcomes. MS Access2000 and SQL was selected to use a general purpose database logic with an efficiency. MS Visual Basic 6.0 was used to construct the circumstance of Graphic User Interface. The Linkage Database of abdominal surgery patients was constructed from the clinical data and questionnaire. This database system could add related factors, defining characteristics, nursing activities in the database and analyze the statistical results through Access query. In the final stage, end-users satisfaction analysis using 5 points Likert scale was dong with the response of using the database system. The accuracy/trustworthiness of the database system was verified with the highest average scores as 4.42 and also, the efficiency as 4.21, user friendly function as 4.1.

  • PDF

Incentive-Compatible Priority Pricing and Transfer Analysis in Database Services

  • Kim, Yong J.
    • 정보기술과데이타베이스저널
    • /
    • 제4권2호
    • /
    • pp.21-32
    • /
    • 1998
  • A primary concern of physical database design has been efficient retrieval and update of a record because predictable performance of a DBMS is indispensable to time-critical missions. To maintain such phenomenal performance, database manages often spends more than or as much as the goal of an organization can warrant. The motivation of this research stems from the fact that even predictable performance of a physical database can be hampered by stochastic query processing time, physical configurations of a database, and random arrival processes of queries. They all together affect the overall performance of a DBMS. In particular, if there are queuing delays due to limited capacity or during on-peak congestion, this paper suggest to prioritize database services. A surprising finding of this paper is that such a transition from a non-priority system to a corresponding priority-based system can be Pareto-improving in the sense that no users in the system will be worse off after the transition. Thus prioritizing database services can be a viable option for efficient database management.

  • PDF

폐광지역 지반침하 GIS분석을 위한 데이터베이스 모델 연구 (A study on Model of Database for GIS Analysis of Subsidence in Mine Area)

  • 권광수;장윤섭;유식;박형동
    • 자원환경지질
    • /
    • 제35권4호
    • /
    • pp.339-346
    • /
    • 2002
  • GIS(Geographic Information System; 지리정보시스템)를 이용한 폐광지역의 지반침하 분석에 있어 효율적인 데이터베이스 구축 및 DBMS(Database Management System; 데이터베이스 관리시스템)의 이용이 요구된다. 이를 위해 폐광지역의 지반침하 분석에 있어 효율적인 분석이 가능하도록 그에 적합한 데이터 구조와 분석방법을 모색하였다. 지반침하 관리시 요구되는 갱도위치, 지하수위, 침하 실측치, 침하 균열 등과 같은 공간 정보에 대한 적합한 모델을 설정하고 데이터베이스를 구축하였다.

수강신청 시스템에서의 SQL 분석을 통한 데이터베이스 성능 향상 방안 (Methods for improving Database Performance through SQL Analysis in the Course Registration System)

  • 김희완
    • 문화기술의 융합
    • /
    • 제6권4호
    • /
    • pp.693-701
    • /
    • 2020
  • 본 논문에서는 현재 운영되는 수강신청 시스템에서의 데이터베이스 성능을 향상시키기 위하여 SQL문 분석을 하였다. 수강신청 업무와 관련된 트랜잭션들에서 사용 중인 SQL문장들을 실행계획을 통하여 현행 데이터베이스 성능을 측정하였으며, SQL 분석을 통하여 보완한 SQL문장들이 성능이 향상된 결과를 확인하였다. 전반적으로 실행계획 분석을 통하여 수강신청 데이터베이스 시스템의 성능을 향상시켰으며, 수강신청 SQL 의 일부 개선방법을 시험결과로 보였다. 개선된 방법은 데이터베이스 튜닝 작업을 통하여 수강신청과 관련된 테이블들과 인덱스 테이블들을 재조정하고, SQL의 기능을 활용함으로서 성능이 향상된 수강신청 데이터베이스 시스템으로 진화한 최적화된 시스템을 구현할 수 있게 되었다. 제안된 방법으로 재조정된 수강신청 시스템은 이전에 운영하던 수강신청시스템에 비하여 성능적 측면에서 우수한 결과를 나타내었으며, 통합 성능 시험 결과 1.8배 ~ 18배의 응답시간 단축을 가져왔다.

제품기회탐색을 위한 제품디자인 데이터베이스 구축과 이의 활용 (The Development and the Application of Product Design Database for Product Opportunity Analysis)

  • 박정순;이건표
    • 디자인학연구
    • /
    • 제12권4호
    • /
    • pp.119-128
    • /
    • 1999
  • 제품계획에서 제품기획탐색은 세부적인 제품컨셉에 우선하여 제품으로서의 기능성을 분석하는 것으로, 제품환경변화의 분석에 따라 제품의 기회를 발견하여 생산자의 모든 자원과 비교함으로서 새로운 시장을 파악하는 것이다. 따라서 제품기회탐색에는 시장이나 제품에 대한 다양한 데이터와 이를 바탕으로 한 정확한 분석과 직관련이 요구된다. 특히 시장에서 제품을 둘러싼 제반환경의 급격한 변화에 의해 보다 적절하고 다양한 제품정보의 획득과 활용의 중요성이 부각되고 있다. 이러한 상황을 배경으로 할 때 가장 시급하고도 중요한 것은 필요한 제품정보의 유형을 밝히고, 이에 따라 데이터베이스를 구축하는 일이며, 단순히 데이터만을 모아놓는 것이 아니라 문맥정보로의 변환을 위해 체계적인 시스템화가 이루어져야 한다. 이에 본 연구에서는 제품속성을 기준으로 제품디자인 데이터 베이스의 개념적 구조를 밝혔으며 이에 따라 프로토타입을 작성하였다. 또 개발된 프로토타입을 이용하여 데이터를 탐색하고 분석하여 구체적인 제품기회를 얻기 위해 제품경향을 파악하는 일련의 과정을 소형카메라를 사례로 하여 제시하였다.

  • PDF

철도 산업의 공기 질 데이터베이스 연합형 통합을 위한 지능형 데이터 거버넌스 (Intelligent Data Governance for the Federated Integration of Air Quality Databases in the Railway Industry)

  • 김민정;원종운;박상찬;박가영
    • 품질경영학회지
    • /
    • 제50권4호
    • /
    • pp.811-830
    • /
    • 2022
  • Purpose: In this paper, we will discuss 1) prioritizing databases to be integrated; 2) which data elements should be emphasized in federated database integration; and 3) the degree of efficiency in the integration. This paper aims to lay the groundwork for building data governance by presenting guidelines for database integration using metrics to identify and evaluate the capabilities of the UK's air quality databases. Methods: This paper intends to perform relative efficiency analysis using Data Envelope Analysis among the multi-criteria decision-making methods. In federated database integration, it is important to identify databases with high integration efficiency when prioritizing databases to be integrated. Results: The outcome of this paper aims not to present performance indicators for the implementation and evaluation of data governance, but rather to discuss what criteria should be used when performing 'federated integration'. Using Data Envelope Analysis in the process of implementing intelligent data governance, authors will establish and present practical strategies to discover databases with high integration efficiency. Conclusion: Through this study, it was possible to establish internal guidelines from an integrated point of view of data governance. The flexiblity of the federated database integration under the practice of the data governance, makes it possible to integrate databases quickly, easily, and effectively. By utilizing the guidelines presented in this study, authors anticipate that the process of integrating multiple databases, including the air quality databases, will evolve into the intelligent data governance based on the federated database integration when establishing the data governance practice in the railway industry.

기본지리정보 구축 우선순위 평가에 관한 연구 (A Study on Evaluation of the Priority Order about Framework Data Building)

  • 김건수;최윤수;조성길;이상미
    • 한국측량학회:학술대회논문집
    • /
    • 한국측량학회 2004년도 추계학술발표회 논문집
    • /
    • pp.361-366
    • /
    • 2004
  • Geographic Information has been used widely for landuse and management, city plan, and environment and disaster management, etc., But geographic information has been built for individual cases using various methods. Therefore, the discordancy in data, double investment, confusion of use and difficulty of decision supporting system have been occurred. In order to solve these problems, national government is need to framework database. This framework database was enacted for building and use of National Geographic Information System and focused on basic plan of the second national geographic information system. Also, the framework database was selected of eight fields by NGIS laws and 19 detailed items through meeting of framework committee since 2002. In this research, The 19 detailed items( road, railroad, coastline, surveying control point etc.,) of framework database consider a Priority order, In the result of this research, the framework database is obtain to a priority order for building and the national government will carry effectively out a budget for the framework database building. Each of 19 detailed items is grouping into using the priority order of the framework database by AHP analysis method and verified items by decision tree analysis method. The one of the highest priority order items is a road, which is important for building, continuous renovation, and maintain management for use.

  • PDF

Improvement of RocksDB Performance via Large-Scale Parameter Analysis and Optimization

  • Jin, Huijun;Choi, Won Gi;Choi, Jonghwan;Sung, Hanseung;Park, Sanghyun
    • Journal of Information Processing Systems
    • /
    • 제18권3호
    • /
    • pp.374-388
    • /
    • 2022
  • Database systems usually have many parameters that must be configured by database administrators and users. RocksDB achieves fast data writing performance using a log-structured merged tree. This database has many parameters associated with write and space amplifications. Write amplification degrades the database performance, and space amplification leads to an increased storage space owing to the storage of unwanted data. Previously, it was proven that significant performance improvements can be achieved by tuning the database parameters. However, tuning the multiple parameters of a database is a laborious task owing to the large number of potential configuration combinations. To address this problem, we selected the important parameters that affect the performance of RocksDB using random forest. We then analyzed the effects of the selected parameters on write and space amplifications using analysis of variance. We used a genetic algorithm to obtain optimized values of the major parameters. The experimental results indicate an insignificant reduction (-5.64%) in the execution time when using these optimized values; however, write amplification, space amplification, and data processing rates improved considerably by 20.65%, 54.50%, and 89.68%, respectively, as compared to the performance when using the default settings.