• Title/Summary/Keyword: Analysis Database

Search Result 5,182, Processing Time 0.033 seconds

Database Workload Analysis : An Empirical Study (데이타베이스 워크로드 분석 : 실험적 연구)

  • Oh, Jeong-Seok;Lee, Sang-Ho
    • The KIPS Transactions:PartD
    • /
    • v.11D no.4
    • /
    • pp.747-754
    • /
    • 2004
  • Database administrators should be aware of performance characteristics of database systems in order to manage database system effectively. The usages of system resources in database systems could be quite different under database workloads. The objective of this paper is to identify and analyze performance characteristics of database systems in different workloads, which could help database tuners tune database systems Under the TPC-C and TPC-W workloads, which represent typical workloads of online transaction processing and electronic commerce respectively, we investigated usage types of resource that are determined by fourteen performance indicator, and are behaved in response to changes of four tuning parameters (data buffer, private memory, I/O process, shared memory). Eight out of the fourteen performance indicators cleary show the performance differences under the workloads. Changes of data buffer parameter give a influences to database system. The tuning parameter that affects the system performance significantly is the database buffer size in the both workloads.

A recovery method for deleted records in the ESE Database (ESE 데이터베이스 내의 삭제된 레코드 복구 기법)

  • Kim, Jeong-hyeon;Choi, Jong-hyun;Lee, Sang-jin
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.25 no.5
    • /
    • pp.1143-1151
    • /
    • 2015
  • Extensible Storage Engine (ESE) database is a database developed by Microsoft. This database is used in web browser like Internet Explorer, Spartan and in Windows system with Windows Search, System Resource Usage Monitor. Previous ESE database viewer can display an incorrect result and can't read the file depending on collected environment and status of files. And the deleted record recovery tool is limited to some program and cannot recover all tables. This paper suggests the universal recovery method for deleted records and presents the experimental results through development of tool.

Development of the Nursing Database for Gastric Cancer Patients (위암환자를 위한 간호 데이터베이스 개발)

  • Jung, Kwuy-Im;Lee, Byung-Sook
    • Journal of Korean Academy of Nursing Administration
    • /
    • v.7 no.3
    • /
    • pp.571-588
    • /
    • 2001
  • Purpose : This study was to develop the nursing database for gastric cancer patients for clinical application. Method : Nursing data that development of this data base is comprehensive connected with gastric cancer patient nursing process frame to foundation as classification. Result : Each stage was processed based on the System Development Life Cycle. At the Strategy Planning stage, gastric cancer patient nursing process were analyzed. At the system Analysis Stage, database flowchart was drawn up based on frame of nursing process was drawn up. At the system Design Stage, a system was developed based on the flowchart and named the Nursing Database. The Nursing Database consisted of the patient's Basic Information, Patient's Nursing History, Discharge summary, Nursing Assessment, Nursing Diagnosis, Nursing Intervention/activity, Nursing Evaluation, Statics, Code Registration. Each element in flowchart was coded and made into a database. Nursing Assessment classified according to Gorden's Health Pattern Typology, and nursing diagnosis draws the standard 27 name of Hanguls and connected with nursing assessment. Nursing intervention and nursing activity draw 192 of thing that present in NIC, connected this with nursing assessment. Nursing evaluation is linked with nursing assessment, diagnosis and intervention by achievement availability of nursing goals. Conclusion : The biggest advantage of this database nursing process that can manage nursing information exactly and rapidly to foundation be.

  • PDF

Association of the Glutathione S-transferase T1 Null Genotype with Risk of Gastric Cancer: a Meta-analysis in Asian Populations

  • Zeng, Yan;Bai, Jian;Deng, Li-Cong;Xie, Yu-Ping;Zhao, Fen;Huang, Ying
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.17 no.3
    • /
    • pp.1141-1148
    • /
    • 2016
  • Background: A large number of studies have been published to investigate the association between the null genotype of glutathione S-transferase T1 (GSTT1) with gastric cancer. However, the results were inconsistent and conflicting. The aim of this study was to estimate the relationship between this polymorphism in the GSTT1 gene and gastric cancer risk in Asian populations by meta-analysis. Materials and Methods: A literature search was performed in PubMed, Embase, Chinese Biomedical database (CBM), Weipu database, Wanfang database, and China National Knowledge Infrastructure database (CNKI). Statistical analysis was conducted by using Review Manager 5.3. Results: Thirty-nine studies with a total of 7,737 gastric cancer cases and 10,823 controls were included in this meta-analysis. The meta-analysis of total studies showed that the null genotype in GSTT1 was associated with increased risk of gastric cancer in Asians (OR=1.19, 95% CI=1.08-1.31, p=0.0002). Subgroup analysis showed a significant relationship between GSTT1 null genotype and gastric cancer in East-Asians, as well as in subgroup analysis of hospital-based design. On subgroup analysis by smoking status, alcohol status, Helicobacter pylori infection status, and histology type, no significant association of this polymorphism with susceptibility to gastric cancer was found. Conclusions: In conclusion, the results showed that the null genotype of GSTT1 is significantly associated with an increased risk in gastric cancer in Asian populations.

APPLICATION AND CROSS-VALIDATION OF SPATIAL LOGISTIC MULTIPLE REGRESSION FOR LANDSLIDE SUSCEPTIBILITY ANALYSIS

  • LEE SARO
    • Proceedings of the KSRS Conference
    • /
    • 2004.10a
    • /
    • pp.302-305
    • /
    • 2004
  • The aim of this study is to apply and crossvalidate a spatial logistic multiple-regression model at Boun, Korea, using a Geographic Information System (GIS). Landslide locations in the Boun area were identified by interpretation of aerial photographs and field surveys. Maps of the topography, soil type, forest cover, geology, and land-use were constructed from a spatial database. The factors that influence landslide occurrence, such as slope, aspect, and curvature of topography, were calculated from the topographic database. Texture, material, drainage, and effective soil thickness were extracted from the soil database, and type, diameter, and density of forest were extracted from the forest database. Lithology was extracted from the geological database and land-use was classified from the Landsat TM image satellite image. Landslide susceptibility was analyzed using landslide-occurrence factors by logistic multiple-regression methods. For validation and cross-validation, the result of the analysis was applied both to the study area, Boun, and another area, Youngin, Korea. The validation and cross-validation results showed satisfactory agreement between the susceptibility map and the existing data with respect to landslide locations. The GIS was used to analyze the vast amount of data efficiently, and statistical programs were used to maintain specificity and accuracy.

  • PDF

Real-time emotion analysis service with big data-based user face recognition (빅데이터 기반 사용자 얼굴인식을 통한 실시간 감성분석 서비스)

  • Kim, Jung-Ah;Park, Roy C.;Hwang, Gi-Hyun
    • Journal of the Institute of Convergence Signal Processing
    • /
    • v.18 no.2
    • /
    • pp.49-54
    • /
    • 2017
  • In this paper, we use face database to detect human emotion in real time. Although human emotions are defined globally, real emotional perception comes from the subjective thoughts of the judging person. Therefore, judging human emotions using computer image processing technology requires high technology. In order to recognize the emotion, basically the human face must be detected accurately and the emotion should be recognized based on the detected face. In this paper, based on the Cohn-Kanade Database, one of the face databases, faces are detected by combining the detected faces with the database.

  • PDF

Automatic Verification and Tuning of Transaction-based Database Applications (트랜잭션 기반 데이타베이스 응용프로그램의 안전성 자동 검증 및 자동 튜닝)

  • Kang Hyun-Goo;Yi Kwangkeun
    • Journal of KIISE:Databases
    • /
    • v.32 no.1
    • /
    • pp.86-99
    • /
    • 2005
  • In this paper, we suggest a system which automatically verifies and tunes transaction processing database applications based on program analysis technology. This system automatically verifies two kinds of transaction processing errors. The first case is the un-closed transaction. In this case, data is not updated as expected or performance of overall system can decrease seriously by locking some database tables until the process terminates. The second case is the miss-use of transaction isolation(inking) level. This causes runtime exception or abnormal termination of the program depending on runtime environment. This system automatically tunes two kinds of inefficient definition of transaction processing which decrease the performance of overall system. The first case happens when opened transaction is closed too late. And the second case happens when transaction isolation level is set too high.

Establishment of analysis system and fast-access cloud-based database of concrete deformation

  • Liao, Wen-Cheng;Chern, Jenn-Chuan;Huang, Ho-Cheng;Liu, Ting-Kai;Chin, Wei-Yi
    • Computers and Concrete
    • /
    • v.28 no.5
    • /
    • pp.441-450
    • /
    • 2021
  • This study presents the first analysis system and fast-access cloud database for shrinkage and creep of concrete in the world, named "shrinkage and creep database in Taiwan", SCDT. SCDT not only has the most comprehensive experimental data, including NU, JSCE, Europe, and TW databases, but provides a design tool for researchers and engineers. It can further facilitate the development of prediction models for localized concrete. Users can obtain the shrinkage and creep curves based on their selected prediction models in SCDT. Comparisons of the predicted results of selected models and test results in the chosen database can be generated in seconds. One example of the development of basic creep prediction model in Taiwan based on model B4 by using SCDT to reflect concrete characteristics in Taiwan is also presented in this study. Users anywhere in the world can easily access SCDT to browse and upload data, receive predictive results, or develop predictive models.

Correlations between Spatial Distribution of Alien Plants and Land Cover - Focused on National Ecosystem Survey - (외래식물의 공간분포와 토지피복간의 상관성 연구 - 전국자연환경조사 자료를 중심으로 -)

  • Jung, Tae-Jun;Shin, Hyun-Chul;Shin, Young-Kyu;Kim, Myung-Jin
    • Journal of Environmental Impact Assessment
    • /
    • v.22 no.5
    • /
    • pp.455-466
    • /
    • 2013
  • The aim of this study is to seek application plans of National Ecosystem Survey database based on comparison and examination of feasible analysis methods for distribution characteristics of alien plants. In order to set up a correlation analysis method between alien plants and environmental factors, we had reviewed the 3rd National Ecosystem Survey guide book and consequently, two kinds of analysis method were tested. One was 1/25,000 scale map boundary based analysis and the other was representative mountain area based analysis. In this study we restricted the research area to select reliable surveyed database from whole "2011 National Ecosystem Survey flora database" according to two major criteria. First, an area defined by 1/25,000 scale map boundary and representative mountain area where the number of surveyed flora records should be within top 20%. Second, land cover map should also be built up inside that area. As a result, 25 map boundaries and 25 representative mountain areas were extracted to be analyzed. To limit a boundary for every representative mountain area we had analyzed distribution of environmental factors around that area by manual inspection with SPOT-5 remote sensed satellite image then designated 3km buffer zone from each alien plant location in that area. After then, naturalized index (NI) and urbanized index (UI) was calculated and correlations analysis was carried out. With the result of correlation analysis by map boundary only agricultural land area showed significant value of r (0.4~0.6, correlated) and the rest of factors did not. In the case of representative mountain area, the result showed that agricultural land, road and forest area showed significant value of r (0.6~0.8, highly correlated) which was corresponding to existing researches. Therefore, representative mountain area based method is preferable when using the alien plants database of National Ecosystem Survey for species distribution analysis. And also, considering the way of database utilization is strongly suggested at the first stage of survey planning for promoting active use of national ecosystem survey database.

An Analysis on the Operations of Reference Databases in Korea (국내 참고문헌 데이터베이스 운영현황 및 실태에 관한 분석)

  • Kim, Hong-Ryul;Joung, Kyoung-Hee
    • Journal of the Korean Society for information Management
    • /
    • v.22 no.2 s.56
    • /
    • pp.23-39
    • /
    • 2005
  • The purpose of this study was to analyzes the present conditions of reference databases which is constructed from Korea. The object which is used in analysis concludes on KSCI( Korean Science Citation Index) of KISTI, KCI(Korean Citation Index) of KRF, KoMCI(Korean Medical Citation Index) of Korean Academy of Medical Sciences, and reference database of KOSEF. And then, this paper proposes the activation plan for reference database construction based on this analysis result. The proposed plan will be able to apply with fundamental data of the system, policy and technical direction for reference database construction.