• Title/Summary/Keyword: ADO

Search Result 82, Processing Time 0.027 seconds

Design and Implementation of Customer's Buying Trend Analysis in e-Commerce Environment (전자상거래 소비자 구매 패턴 분석 도구 개발)

  • 한지선;조동섭
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10b
    • /
    • pp.239-241
    • /
    • 2000
  • 전자상거래에서는 소비자의 구매 패턴을 분석하는 것이 필요하다. 이러한 패턴을 효과적으로 분석하기 위해 지능형 로그 서버를 정의하고 이를 설계, 구현하였다. 지능형 로그 서버란 전자상거래 쇼핑몰의 환경에서 사용자 로그를 데이터베이스화하여 저장하고 데이터베이스에 저장된 정보를 서버 종류별, 시간별, 페이지별 등으로 분석하여 사용자 패턴을 분석할 수 있는 서버를 말한다. 이 서버는 텍스트 파일로 로그를 저장하는 서버보다 자세한 정보를 효율적으로 저장할 수 있다. 그리고 데이터베이스 접근 기술로 ADO(ActiveX Data Object)를 사용하여 데이터베이스 접근 속도를 향상시켰으며 관계형.비관계형 데이터베이스에 모두 접근할 수 있다는 장점을 가진다. 또한 소비자의 구매 패턴을 분석하기 위해 DBMiner2.0을 사용하였다.

  • PDF

Extended Web Log Processing System by using Click-Stream (클릭스트림 분석을 통한 확장된 웹 로그 처리 시스템)

  • Kang, Mi-Jung;Cho, Dong-Sub
    • Proceedings of the KIEE Conference
    • /
    • 2001.07d
    • /
    • pp.2798-2800
    • /
    • 2001
  • 인터넷 사용자가 급증하고, 인터넷을 통한 비즈니스에 수익 모델에 대한 관심이 높아지면서 방문자별로 맞춤 정보를 제공하는 퍼스널라이제이션이 인터넷 개발자 및 사용자들의 관심을 모으고 있다. 원투원 마케팅은 개별 고객의 성별, 나이, 소득 등 인구 통계 정보와 고객의 취미, 레저 등에 관한 정보 및 구매 패턴을 DB화하여 고객에게 가장 적절한 상품, 정보, 광고를 제공하는 것이다. 원투원 마케팅을 기본으로 개인과의 끊임없는 상호교류를 통해 고객에게 맞춤 서비스를 제공할수 있다. 본 논문에서는 맞춤 서비스 제공을 위한 전처리과정으로 클릭스트림 분석을 통한 확장된 웹 로그 정보를 통해서 고객들의 성향을 분석하였다. 그리고 이 웹 로그서버는 웹사이트로부터 얻은 로그정보를 분류하고 저장하여 관리자가 확장된 웹 로그 정보를 쉽게 분석할 수 있다. 이때 데이터베이스 저장 기술로 OLE DB Provider상에서 수행되는 ADO 기술을 사용함으로써 확장된 웹 로그 처리 시스템을 설계하였다. 확장된 웹 로그 DB를 패턴분석, 군집분석 등의 마이닝(Mining) 기법을 통하여 맞춤 서비스에 대한 사용자 프로파일을 구축 할 수 있다.

  • PDF

Design and Implementation of Query Processor for Moving Objects (이동객체를 위한 질의처리 컴포넌트의 설계 및 구현)

  • Kim, Kyoung-Sook;Kwon, O-Je;Byun, Hee-Young;Jo, Dae-Soo;Kim, Tae-Wan;Li, Ki-Joune
    • Journal of Korea Spatial Information System Society
    • /
    • v.6 no.1 s.11
    • /
    • pp.31-50
    • /
    • 2004
  • With the growth of wireless communication networks and mobile devices taking in GPS, Location-Based Service(LBS) is becoming an integral part of mobile applications. LBS can deal with location-aware features such as persons holding mobile phones or vehicles equipped with GPS, and provide the users with the location information of the features. Thus it is necessary to develop moving object database systems to store, manage, and query moving objects which change their locations continuously as time passes. In this paper, we design and implement a query processing component which deals with moving objects as a key data type. For this component, we define a new SQL-like query language(called MOQL) and as a consequence, design and implement modules that analyze and execute queries. It supports various types of operators that process range queries, infer topological relations, compute trajectories, and find k-nearest neighbors. It can be used as a subsystem if other application systems which deal moving objects and also supports ADO.NET interface that can be used to interact end-users.

  • PDF

Association of Airflow Limitation and COPD Composite Index with Peripheral Oxygen Saturation in Patients with Chronic Obstructive Pulmonary Disease (만성폐쇄성폐질환자에서 기류제한 및 COPD 복합지수와 말초산소포화도의 연관성)

  • Jong Seong Lee;Jae Hoon Shin;Jin Ee Baek;Hyerim Son;Byung-soon Choi
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.34 no.1
    • /
    • pp.57-66
    • /
    • 2024
  • Objective: Chronic obstructive pulmonary disease (COPD) is characterized by progressive airflow obstruction that is only partly reversible, inflammation in the airways, and systemic effects. This study aimed to investigate the association between low peripheral oxygen saturation levels (SpO2), and composite indices predicting death in male patients with (COPD). Method: A total of 140 participants with post-bronchodilator FEV1/FVC ratio less than 0.7 were included. Three composite indices (ADO, DOSE, BODEx) were calculated using six variables such as age (A), airflow obstruction (O), body mass index (B), dyspnea (D), exacerbation history (E or Ex), and smoking status (S). Severity of airflow limitation was classified according to Global Initiative for Obstructive Lung Disease (GOLD) guidelines. SpO2 was measured by pulse oximetry, and anemia and iron deficiency were assessed based on blood hemoglobin levels and serum markers such as ferritin, transferrin saturation, or soluble transferrin receptor. Results: Participants with low SpO2 (<95%) showed significantly lower levels of %FEV1 predicted (p=0.020) and %FEV1/FVC ratio (p=0.002) compared to those with normal SpO2 levels. The mMRC dyspnea scale (p<0.001) and GOLD grade (p=0.002) showed a significant increase in the low SpO2 group. Receiver Operating Characteristic analysis revealed higher area under the curve for %FEV1 (p=0.020), %FEV1/FVC(p=0.002), mMRC dyspnea scale (p=0.001), GOLD grade (p=0.010), ADO (p=0.004), DOSE (p=0.002), and BODEx (p=0.011) in the low SpO2 group. Conclusion: These results suggest that low SpO2 levels are related to increased airflow limitation and the composite indices of COPD.

Comparative Homology Modeling and Ligand Docking Study of Human Catechol-O-Methyltransferase for Antiparkinson Drug Design

  • Lee, Jee-Young;Kim, Yang-Mee
    • Bulletin of the Korean Chemical Society
    • /
    • v.26 no.11
    • /
    • pp.1695-1700
    • /
    • 2005
  • Catechol-O-methyltransferase (COMT, EC 2.1.1.6) is an S-adenosylmethionine (SAM, AdoMet) dependent methyltransferase, and is related to the functions of the neurotransmitters in various mental processes, such as Parkinson’s disease. COMT inhibitors represent a new class of antiparkinson drugs, when they are coadministered with levodopa. Based on x-ray structure of rat COMT (rCOMT), the three dimensional structure of human COMT (hCOMT) was constructed by comparative homology modeling using MODELLER. The catalytic site of these two proteins showed subtle differences, but these differences are important to determine the characterization of COMT inhibitor. Ligand docking study is carried out for complex of hCOMT and COMT inhibitors using AutoDock. Among fifteen inhibitors chosen from world patent, nine models were energetically favorable. The average value of heavy atomic RMSD was 1.5 $\AA$. Analysis of ligand-protein binding model implies that Arg201 on hCOMT plays important roles in the interactions with COMT inhibitors. This study may give insight to develop new ways of antiparkinson drug.

Purification of Deoxycytidine Kinase from Various Human Leukemic Cells by End-product Analog Affinity Chromatography

  • Kim, Min-Young
    • BMB Reports
    • /
    • v.28 no.4
    • /
    • pp.281-289
    • /
    • 1995
  • Homogeneous human deoxycytidine kinase was purified in one step from a variety of spontaneous human leukemic cells (T-ALL, B-ALL, B-CLL, AML, CML), and from cultured T-lymphoblast cells (MOLT-4) using the newly developed affinity medium, $dCp_4$-Sepharose. Starting with an ammonium sulfate fraction, purification was achieved in one step with the kinase being eluted from a column by the end product inhibitor, dCTP. The purified deoxycytidine kinase from T-ALL cells phosphorylated deoxyadenosine and deoxyguanosine, as well as deoxycytidine. The enzyme purified from T-ALL and B-CLL cells yielded one major band with a molecular weight of 52 kDa determined by SDS-polyacrylamide gel electrophoresis. AML and CML cells yielded one 52 kDa band and an extra band of 30 kDa molecular weight. On the other hand, B-ALL and MOLT-4 cells showed a low molecular weight band of 30 kDa only. However, the electrophoretic mobilities of enzymatic activity in 12% non-denaturing gels were identical for the dCyd kinase from all different kinds of leukemic cell lines, except that the B-ALL, B-CLL, and MOLT-4 cell preparations had an extra minor peak, all at the same position. dAdo and dCyd phosphorylating activities comigrated indicating that these activities are all associated with the same protein. Two new methods, a disk implantation method and a nitrocellulose powder method were used with a small amount of enzyme protein to raise polyclonal antibodies against dCyd kinase purified from T-ALL cells.

  • PDF

Customer's Pattern Analysis System using Intelligent Weblog Server (지능형 웹로그 서버를 이용한 전자상거래 사용자 패턴 수집 시스템)

  • Han, Ji-Seon;Kang, Mi-Jung;Cho, Dong-Sub
    • Proceedings of the KIEE Conference
    • /
    • 2000.11d
    • /
    • pp.836-838
    • /
    • 2000
  • 전자상거래에서 쇼핑몰의 개인화된 서비스를 제공하기 위해서는 소비자의 구매 패턴을 분석하는 것이 필요하다. 이러한 패턴을 효과적으로 분석하기 위해 웹사이트 상에서 사용자 행동 패턴 정보를 수집해야 한다. 본 논문에서는 사용자 패턴 수집 시스템으로 쇼핑몰 서버에 기능을 추가하고 지능형 웹로그 서버를 정의하며 이를 설계, 구현하였다. 전자상거래 쇼핑몰 서버에는 사용자 행위 정보를 로그에 포함시켜 지능형 웹로그 서버에 전송하는 기능을 추가하였다. 그리고 지능형 웹로그 서버는 쇼핑몰 서버로부터 받은 로그 데이터를 분석하고 데이터베이스화하여 저장한다. 이때 데이터베이스 저장 기술로 OLE DB Provider상에서 수행되는 ADO기술을 사용한다. 그리고 저장된 데이터베이스를 레코드셋 단위로 원격에서 제어 가능하게 한다. 또 생성된 데이터베이스에서 필요한 데이터를 선별하여 XML DB로 저장한다. 이와 같은 사용자 패턴 수집 시스템은 데이터베이스 접근 속도가 빠르고, 관계형이나 비관계형 둘 다의 데이터베이스 접근이 가능하다는 장정을 가지며, 원격 데이터 베이스 접근 시 서버의 부하를 줄일 수 있다는 장점이 있다.

  • PDF

Clinical Evaluation of Spontaneous Pneumothorax - A review of 360 cases - (자연기흉의 임상적 고찰: 360례 보고)

  • O, Chang-Geun;Im, Jin-Su
    • Journal of Chest Surgery
    • /
    • v.24 no.8
    • /
    • pp.757-764
    • /
    • 1991
  • We have observed 360 cases of spontaneous pneumothorax from January 1980 to May 1991 at the department of Thoracic and Cardiovascular Surgery, Chosun University Hospital. Males occupied 266 cases[73.9%] and females 94 cases[26.1%], and its ratio was 2.8: l. The age of patients ranged from neonate[5 days] to 84 years old. The site of pneumothorax was right in 50.3%, left in 43.3% and bilateral in 6.4%a. The clinical symptoms were frequently dyspnea, chest pain and coughing. The associated pulmonary lesions were shown pulmonary tuberculosis in 199 cases[55.3%], bullae in 54, pulmonary emphysema in 31, COPD in 17, pneumonia in 6, lung cancer in 5, paragonimiasis in 5, catamenial pneumothorax in 3 and unknown underlying pathology in 39 cases. The results of surgical management of spontaneous pneumothorax are followings: 288 out of 360 cases[80.0%] were cured by closed thoracotomy, 53 cases[14.8%] were cured by open thoracotomy. Open thoracotomy was the most effective procedure in persistent air leakage, recurrent pneumothorax, visible bleb or bullae on the chest X-ray, associated lesion, bilateral simultaneous pneumothorax, parenchymal incomplete lung expansion and bleeding after closed thoracotomy. The incidence of complication was developed in 10. ado and recurrent rate was seen in 10.6%. There was no operative death.

  • PDF

Molecular Modeling and Site Directed Mutagenesis of the O-Methyltransferase, SOMT-9 Reveal Amino Acids Important for Its Reaction and Regioselectivity

  • Park, So-Hyun;Kim, Bong-Gyu;Lee, Sun-Hee;Lim, Yoong-Ho;Cheong, You-Hoon;Ahn, Joong-Hoon
    • Bulletin of the Korean Chemical Society
    • /
    • v.28 no.12
    • /
    • pp.2248-2252
    • /
    • 2007
  • SOMT-9 is an O-methyltransferase that utilizes quercetin to produce 3'-methoxy quercetin. In order to determine which amino acids of SOMT-9 are important for this reaction and its regioselectivity, molecular docking experiments followed by site directed mutagenesis were performed. Molecular modeling and molecular docking experiments identified several amino acid residues involved in metal binding, AdoMet binding, and substrate binding. Site-directed mutagenesis showed that Asp188 is critical for metal binding and that Lys165 assists other metal binding residues in maintaining quercetin in the proper position during the reaction. In addition, Tyr207 was shown to play an important role in the determination of the regioselectivity and Met60 was shown to be involved in formation of the hydrophobic pocket necessary for substrate binding. The molecular modeling and docking experiments discussed in this study could be applicable to future research including prediction of substrate binding and regioselectivity of an enzyme.

Protection of aquo/hydroxocobalamin from reduced glutathione by a B12 trafficking chaperone

  • Jeong, Jin-Ju;Ha, Tal-Soo;Kim, Ji-Hoe
    • BMB Reports
    • /
    • v.44 no.3
    • /
    • pp.170-175
    • /
    • 2011
  • We identified a bovine $B_{12}$ trafficking chaperone bCblC in Bos taurus that showed 88% amino acid sequence identity with a human homologue. The protein bCblC was purified from E. coli by over-expression of the encoding gene. bCblC bound cyanocobalamin (CNCbl), methylcobalamin (MeCbl) and adenosylcobalamin (AdoCbl) in the base-off states and eliminated the upper axial ligands forming aquo/hydroxocobalamin ($OH_2$/OHCbl) under aerobic conditions. A transition of $OH_2$/OHCbl was induced upon binding to bCblC. Interestingly, bCblC-bound $OH_2$/OHCbl did not react with reduced glutathione (GSH), while the reaction of free$OH_2$/OHCbl with GSH resulted in the formation of glutathionylcobalamin (GSCbl) and glutathione disulfide (GSSG). Furthermore we found that bCblC eliminates the GSH ligand of GSCbl forming $OH_2$/OHCbl. The results demonstrated that bCblC is a $B_{12}$ trafficking chaperone that binds cobalamins and protects $OH_2$/OHCbl from GSH, which could be oxidized to GSSG by free $OH_2$/OHCbl.