• 제목/요약/키워드: database model

Search Result 3,032, Processing Time 0.025 seconds

3D GIS Network Modeling of Indoor Building Space Using CAD Plans (CAD 도면을 이용한 건축물 내부 공간의 3차원 GIS 네트워크 모델링)

  • Kang Jung A;Yom Jee-Hong;Lee Dong-Cheon
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.23 no.4
    • /
    • pp.375-384
    • /
    • 2005
  • Three dimensional urban models are being increasingly applied for various purposes such as city planning, telecommunication cell planning, traffic analysis, environmental monitoring and disaster management. In recent years, technologies from CAD and GIS are being merged to find optimal solutions in three dimensional modeling of urban buildings. These solutions include modeling of the interior building space as well as its exterior shape visualization. Research and development effort in this area has been performed by scientists and engineers from Computer Graphics, CAD and GIS. Computer Graphics and CAD focussed on precise and efficient visualization, where as GIS emphasized on topology and spatial analysis. Complementary research effort is required for an effective model to serve both visualization and spatial analysis purposes. This study presents an efficient way of using the CAD plans included in the building register documents to reconstruct the internal space of buildings. Topological information was built in the geospatial database and merged with the geometric information of CAD plans. as well as other attributal data from the building register. The GIS network modeling method introduced in this study is expected to enable an effective 3 dimensional spatial analysis of building interior which is developing with increasing complexity and size.

Surface Complexation Modeling of Cadmium Sorption onto Synthetic Goethite and Quartz (표면착물 모델을 이용한 합성 침철광과 석영의 카드뮴 흡착 모사)

  • Ok, Yong-Sik;Jung, Jin-ho;Lee, Ok-Min;Lim, Soo-kil;Kim, Jeong-Gyu
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.36 no.4
    • /
    • pp.210-217
    • /
    • 2003
  • An alternative method to the empirical approach such as Langmuir and Freundlich model, surface complexation model using thermodynamic database is used to simulate adsorption behavior of cadmium for oxide minerals. Sorption of cadmium onto amorphous silica ($SiO_2$) and synthetic goethite (${\alpha}$-FeOOH) at various conditions of pH, initial cadmium loading, oxide concentration, and ionic strength, were investigated. For both oxide minerals, increasing cadmium concentration resulted in right shifting of the sorption curve of cadmium as the function of pH. The $pH_{50}$, where 50% of cadmium sorbed, of goethite (pH 5.25) was much smaller than that of the silica (pH 7.83). The sorption of cadmium onto both minerals were not affected by the background ion strength from $10^{-1}$ to $10^{-2}$ M of $KNO_3$. It indicated that the binding affinity of goethite surface for cadmium is much stronger than that of silica. The strong affinity of oxide mineral for cadmium can be explained by the existence of coordination or covalent bond between cadmium and surface of it.

Greedy Heuristic Algorithm for the Optimal Location Allocation of Pickup Points: Application to the Metropolitan Seoul Subway System (Pickup Point 최적입지선정을 위한 Greedy Heuristic Algorithm 개발 및 적용: 서울 대도시권 지하철 시스템을 대상으로)

  • Park, Jong-Soo;Lee, Keum-Sook
    • Journal of the Economic Geographical Society of Korea
    • /
    • v.14 no.2
    • /
    • pp.116-128
    • /
    • 2011
  • Some subway passengers may want to have their fresh vegetables purchased through internet at a service facility within the subway station of the Metropolitan Seoul subway system on the way to home, which raises further questions about which stations are chosen to locate service facilities and how many passengers can use the facilities. This problem is well known as the pickup problem, and it can be solved on a traffic network with traffic flows which should be identified from origin stations to destination stations. Since flows of the subway passengers can be found from the smart card transaction database of the Metropolitan Seoul smart card system, the pickup problem in the Metropolitan Seoul subway system is to select subway stations for the service facilities such that captured passenger flows are maximized. In this paper, we have formulated a model of the pickup problem on the Metropolitan Seoul subway system with subway passenger flows, and have proposed a fast heuristic algorithm to select pickup stations which can capture the most passenger flows in each step from an origin-destination matrix which represents the passenger flows. We have applied the heuristic algorithm to select the pickup stations from a large volume of traffic network, the Metropolitan Seoul subway system, with about 400 subway stations and five millions passenger transactions daily. We have obtained not only the experimental results in fast response time, but also displayed the top 10 pickup stations in a subway guide map. In addition, we have shown that the resulting solution is nearly optimal by a few more supplementary experiments.

  • PDF

A Pipelined Hash Join Method for Load Balancing (부하 균형 유지를 고려한 파이프라인 해시 조인 방법)

  • Moon, Jin-Gue;Park, No-Sang;Kim, Pyeong-Jung;Jin, Seong-Il
    • The KIPS Transactions:PartD
    • /
    • v.9D no.5
    • /
    • pp.755-768
    • /
    • 2002
  • We investigate the effect of the data skew of join attributes on the performance of a pipelined multi-way hash join method, and propose two new hash join methods with load balancing capabilities. The first proposed method allocates buckets statically by round-robin fashion, and the second one allocates buckets adaptively via a frequency distribution. Using hash-based joins, multiple joins can be pipelined so that the early results from a join, before the whole join is completed, are sent to the next join processing without staying on disks. Unless the pipelining execution of multiple hash joins includes some load balancing mechanisms, the skew effect can severely deteriorate system performance. In this paper, we derive an execution model of the pipeline segment and a cost model, and develop a simulator for the study. As shown by our simulation with a wide range of parameters, join selectivities and sizes of relations deteriorate the system performance as the degree of data skew is larger. But the proposed method using a large number of buckets and a tuning technique can offer substantial robustness against a wide range of skew conditions.

Estimation of the Flood Warning Rainfall with Backwater Effects in Urban Watersheds (도시 유역의 배수위 영향을 고려한홍수 경보 강우량 산정)

  • Kim, Eung-Seok;Lee, Seung-Hyun;Yoon, Ki-Yong
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.16 no.1
    • /
    • pp.801-806
    • /
    • 2015
  • The incidence of flood damage by global climate change has increased recently. Because of the increased frequency of flooding in Korea, the technology of flood prediction and prevalence has developed mainly for large river watersheds. On the other hand, there is a limit on predicting flooding through the most present flood forecasting systems because local floods in small watersheds rise quite quickly with little or no advance warning. Therefore, this study estimated the flood warning rainfall using a flood forecasting model at the two alarm trigger points in the Suamcheon basin, which is an urban basin with backwater effects. The flood warning rainfall was estimated to be 25.4mm/120min ~ 78.8mm/120min for the low water alarm, and 68.5mm/120min ~ 140.7mm/120min for the high water alarm. The frequency of the flood warning rainfall is 3-years for the low water alarm, and 80-years for the high water alarm. The results of this analysis are expected to provide a basic database in forecasting local floods in urban watersheds. Nevertheless, more tests and implementations using a large number of watersheds will be needed for a practical flood warning or alert system in the future.

Normalization of Face Images Subject to Directional Illumination using Linear Model (선형모델을 이용한 방향성 조명하의 얼굴영상 정규화)

  • 고재필;김은주;변혜란
    • Journal of KIISE:Software and Applications
    • /
    • v.31 no.1
    • /
    • pp.54-60
    • /
    • 2004
  • Face recognition is one of the problems to be solved by appearance based matching technique. However, the appearance of face image is very sensitive to variation in illumination. One of the easiest ways for better performance is to collect more training samples acquired under variable lightings but it is not practical in real world. ]:n object recognition, it is desirable to focus on feature extraction or normalization technique rather than focus on classifier. This paper presents a simple approach to normalization of faces subject to directional illumination. This is one of the significant issues that cause error in the face recognition process. The proposed method, ICR(illumination Compensation based on Multiple Linear Regression), is to find the plane that best fits the intensity distribution of the face image using the multiple linear regression, then use this plane to normalize the face image. The advantages of our method are simple and practical. The planar approximation of a face image is mathematically defined by the simple linear model. We provide experimental results to demonstrate the performance of the proposed ICR method on public face databases and our database. The experimental results show a significant improvement of the recognition accuracy.

A Study to Develop Monthly Cover Management Factor Database for Monthly Soil Loss Estimation (월단위 토양유실가능추정치를 위한 지표피복인자의 산정 방안 연구)

  • Sung, Yun Soo;Jung, Yunghun;Lim, Kyoung Jae;Kim, Jonggun;Kim, Ki-Sung;Park, Seung Ki;Shin, Min Hwan;Kum, Dong Hyuk;Park, Youn Shik
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.58 no.6
    • /
    • pp.23-30
    • /
    • 2016
  • Soil loss is an accompanying phenomenon of hydrologic cycle in watersheds. Both rainfall drops and runoff lead to soil particle detachment, the detached soil particles are transported into streams by runoff. Here, a sediment-laden water problem can be issued if soil particles are severely detached and transported into stream in the watershed. There is a need to estimate or simulate soil erosion in watersheds so that an adequate plan to manage soil erosion can be established. Universal Soil Loss Equation (USLE), therefore, was developed and modified by many researchers for their watersheds, moreover the simple model, USLE, has been employed in many hydrologic models for soil erosion simulations. While the USLE has been applied even in South-Korea, the model is often regarded as being limited in applications for the watersheds in South-Korea since monthly conditions against soil erosion on soil surface are not capable to represent. Thus, the monthly USLE factors against soil erosion, soil erodibility and crop management factors, were established for four major watersheds, which are Daecheong-dam, Soyang-dam, Juam-dam, and Imha-dam watersheds. The monthly factors were established by recent fifteen years from 2000 to 2015. Five crops were selected for the monthly crop management factor establishments. Soil loss estimations with the modified factors were compared to conventional approach that is average annual estimations. The differences ranged from 9.3 % (Juam-dam watershed) to 28.1 % (Daecheong-dam watershed), since the conventional approaches were not capable of seasonally and regionally different conditions.

A Study on the Effective VTS Communications Analysis by the Method of VCDF in Busan Port (VCDF 방식을 통한 효율적인 VTS 통신 데이터 분석에 관한 연구 - 부산항을 대상으로 -)

  • Kim, Bong-Hyun;Park, Young-Soo
    • Journal of the Korean Society of Marine Environment & Safety
    • /
    • v.22 no.4
    • /
    • pp.311-318
    • /
    • 2016
  • The VTS concept was located as a principal methods of maritime safety administration in world's major harbors and expected to become the pivotal role for the future of the maritime and harbor society with e-Navigation epoch. If recent limelight concept of big-data has been included in aspect of information gathering and analysis with various studies, it's required advanced studies to improve the information analysis capability and application range of the data that can be mining by the VTS. In this study, contrast to other studies that aimed quantitative analysis as communication number, it can be mining the time information and each of the communication VTS for the target vessel, including qualitative analysis, such as the purpose or the type of communication. This comparison across multiple items of the collected information, and presenting the VTS data mining model (VCDF) that can be analyzed for the purpose of analyzing way, type and number of communication by ship's type, also number of violations through VTS communication. First, In Busan port case, it shows frequently information service and shows frequently communicating with particular types of vessels. Second, Passive VTS carried out notwithstanding many kinds of traffic violations due to communication congestion. This arranged information can be used as data for the analysis, as possible the level of traffic for VTSO situational awareness, which pointed to the 'workloads' in 'IALA Guideline' and could be used as a database for future research of e-Navigation.

ERD Representation using Auto-Generated Form and SQL (자동 생성 폼과 SQL을 이용한 ERD 표현)

  • Ra, Young-Gook
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.5
    • /
    • pp.61-75
    • /
    • 2009
  • Generally, the development of the database application includes the requirement analysis phase of creating ERD (Entity Relationship Diagram) and process models, coding, and testing. From the above phases, the analysis phase is not most formalized. It is usually hard task because (1) customers don't know the details of the desired system; (2) developers can't with ease understand the business logic of the customers; (3) the outcomes of the analysis, which are ERD and process models, are not easy to understand to the customers. This paper propose that the executional forms, which are better to understand the systems, should be presented to the customers instead of the ERD. These forms should accept the data input so that customers can review the various aspects of the outcome models. The developers should be able to instantly implement the business logic and also should be able to visually demonstrate the logic in order to get the details of it. For this goal, the customer supplied business logic should be able to be implemented by the references between forms, actions, constraints from the perspective of the data flow. The customers try to execute the forms implementing the business logic and review their supplied logic find new necessary business logic of their own. Iterating these processes for the requirement analysis would result in the success of the analysis which is sufficiently detailed without conflicts.

Modeling of High-throughput Uranium Electrorefiner and Validation for Different Electrode Configuration (고효율 우라늄 전해정련장치 모델링 및 전극 구성에 대한 검증)

  • Kim, Young Min;Kim, Dae Young;Yoo, Bung Uk;Jang, Jun Hyuk;Lee, Sung Jai;Park, Sung Bin;Lee, Han soo;Lee, Jong Hyeon
    • Journal of Nuclear Fuel Cycle and Waste Technology(JNFCWT)
    • /
    • v.15 no.4
    • /
    • pp.321-332
    • /
    • 2017
  • In order to build a general model of a high-throughput uranium electrorefining process according to the electrode configuration, numerical analysis was conducted using the COMSOL Multiphysics V5.3 electrodeposition module with Ordinary Differential Equation (ODE) interfaces. The generated model was validated by comparing a current density-potential curve according to the distance between the anode and cathode and the electrode array, using a lab-scale (1kg U/day) multi-electrode electrorefiner made by the Korea Atomic Energy Research Institute (KAERI). The operating temperature was $500^{\circ}C$ and LiCl-KCl eutectic with 3.5wt% $UCl_3$ was used for molten salt. The efficiency of the uranium electrorefining apparatus was improved by lowering the cell potential as the distance between the electrodes decreased and the anode/cathode area ratio increased. This approach will be useful for constructing database for safety design of high throughput spent nuclear fuel electrorefiners.