• International conference on construction engineering and project management
• /
• 2005.10a
• /
• pp.509-514
• /
• 2005

In recent years, use of the web technologies and on-line process has immensely swapped single-user platform practice. This study attempted to develop preliminary cost estimating program by means of Web technologies based on statistical modeling results. A prototype Web-based Preliminary Item-Level Cost Estimating System (WBPILCES) using open source software was developed as an on-line estimating tool in this research. The primary objective is to study the possible flexibility of implementing a centralized information system that will be maintained by the Texas Department of Transportation (TxDOT) IT division. The full-scale deployment of proposed information architecture is expected to seamlessly integrate with legacy database system currently used by TxDOT so as to streamline data storage, cost growth tracking and estimates documentation.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.4 no.4
• /
• pp.21-28
• /
• 2001

In this study, GNLP(GIS linked non-linear network analysis program) for pipeline system analysis has been developed. This GNLP gets the input data for pipeline analysis from existing GIS(geographic information system) data automatically, and has GUI(graphic user interface) for user. Non-Linear Method was used for hydraulic analysis of pipe network based on Hazen-Williams equation, and Microsoft Access of relational database management system(RDBMS) was used for the framework of database applied program. GNLP system environment program was improved so that a pipe network designer can input information data for hydraulic analysis of pipeline system more easily than that of existing models. Furthermore this model generate output such as pressure and water quantities in the form of a table and a chart, and also produces output data in Excel file. This model is also able to display data effectively for analysed data confirmation and query function which is the core of GIS program.

• The Journal of Society for e-Business Studies
• /
• v.3 no.1
• /
• pp.1-22
• /
• 1998

SDAI (Standard Data Access Interface) is an interface specification of accessing various storage systems such as file systems and database management systems for STEP data. Using SDAI, both application program developers and CAD/CAM system developers can be relieved from dealing with STEP physical file or system dependent DBMS operations. In this paper, we present implementations of SDAI on different data models, i.e., relational, extended relational, and object-oriented. In order to implement SDAI, we need to translate the EXPRESS information model into target data models. The schema translation process for three different data models are compared and other implementation issues are discussed.

• Journal of Internet Computing and Services
• /
• v.20 no.5
• /
• pp.49-55
• /
• 2019

Organizations design and operate business process models to achieve their goals efficiently and systematically. With the advancement of IT technology, the number of items that computer systems can participate in and the process becomes huge and complicated. This phenomenon created a more complex and subdivide flow of business process.The process instances that contain workcase and events are larger and have more data. This is an essential resource for process mining and is used directly in model discovery, analysis, and improvement of processes. This event log is getting bigger and broader, which leads to problems such as capacity management and I / O load in management of existing row level program or management through a relational database. In this paper, as the event log becomes big data, we have found the problem of management limit based on the existing original file or relational database. Design and apply schemes to archive and analyze large event logs through Hadoop, an open source distributed file system, and HBase, a NoSQL database system.

• Journal of Information Technology Applications and Management
• /
• v.16 no.2
• /
• pp.135-150
• /
• 2009

Corporate databases are usually denormalized, due to the data modelers' impetuous belief that denormalization could improve system performance. By providing a logical insight into denormalization, this paper attempts to prevent every database modeler from falling into the denormalization pit. We indicate loopholes in the denormalization advocates' assertions, and then present four criteria to analyze the usefulness and validity of denormalization; 1) the level of concurrency among transactions, 2) the database independence of the application program, 3) the independence between the logical design and the physical one, and 4) the overhead cost to maintain database integrity under various query patterns. This paper also includes experimental results to evaluate performance of denormalized and fully normalized structures under various workloads.

• Proceedings of the Korean Society of Agricultural Engineers Conference
• /
• 2001.10a
• /
• pp.460-465
• /
• 2001

Pollutant load using unit load method is calculated by simply equation, especially, very useful in the area that didn't exist about water quality data. However, it takes long time to calculate pollutant load with area in which there is various pollutants and if the boundary of a basin altered, the work of calculation about pollutant load must be begun from the first again. Therefore, a Total Daily Load Program(TDLP) was developed to calculate pollutant load automatically in rural area. The TDLP includes a geographic information system(GIS), relational database system(RDBS), User Interface. This Program can provide user with creating a boundary of the basin that user is concerned with to satisfy the water quality regulations and calculating daily load for various pollutants. The effort was conducted to apply the developed TDLP to calculating pollutant load in rural basin called Bok-ha river.

• Journal of Korea Society of Digital Industry and Information Management
• /
• v.6 no.2
• /
• pp.39-53
• /
• 2010

In this paper, we suggest an XML Development Support(XDS) System as a good developing tool to solve the problems that related with the database integration, increased to the developing terms and costs when the developing of XML programming base on the web server. XDS System is designed for the purpose of easily coding the XML program, of simply changing the programming structure and of completely maintaining the program environment. According to the predefined policy, XDS System provides necessary informations such as tables, columns, or relational keys from Database for developer. The developer step by step selects or sets what he needs. And XDS System creates an XML Tree with the result of selected information. The XML Tree includes all information of making an XML Schema and some XML Stylesheet. XDS System creates an XML Schema for all clients and creates many XML Stylesheets for each client using the XML Tree.

• Korean Journal of Computational Design and Engineering
• /
• v.3 no.3
• /
• pp.177-182
• /
• 1998

The computer related techniques have been developed rapidly in the field of metal removal industry. The electronic catalog for mechanical elements is one of such developments realized in recent years. As the emergence of the electronic catalogs in the 90s, it breaks the restriction of the traditional catalog and becomes a helpful and efficient tool in the field. In this paper, we develop an electronic catalog for the cutting tools of the Korea Tungsten Co. Ltd. The catalog consists of three parts: a preprocessor for tool selection, a database for tool, and a postprocessor for search result. A preprocessor for tool selection is developed under a user-friendly consideration. A database for tool consists of milling, drilling, and reaming tools with a list of cutters, inserts, and components. A postprocessor for search result consists of weight, dimension. drawing, product order number etc. of the tools. It also suggests the optimized cutting condition of the selected tool using a neural network technique which is done by an independent research group.

• Proceedings of the KSME Conference
• /
• 2000.11b
• /
• pp.341-346
• /
• 2000

A numerical simulation has been carried out for the engine cooling system. It is the important element to analysis of heat transfer process in cooling system for an automotive engine. Thus, the purpose of this simulator is to present useful information at the early stages of the design of the cooling system by enabling the development engineer to predict performance trends. This program has useful window interface for analysis of the cooling system and it is convenient for user to control data with relational database. The system was simulated and compared with experimental data. As a result, the inlet, outlet temperature of the radiator by the simulator agrees well with it. It is concluded that this simulation program is available in developing the cooling system for a new car.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.11 no.2
• /
• pp.43-51
• /
• 1993

It is very important entity that a map of urban facility is in civic life and development of city. But now, there are many needs of computerization which was used for management of urban facility map because inefficiency was produced due to management of urban facility map by hand. This paper, it was showed that a processing of establishing database in computer by applying GIS. The used sample area in studying in Ansan city in Kyunggi province and a sewer pipe which was in there adapted to establish database in computer. A map of administration district, which is 1:38,000, a map of complex urban planning of city, which is 1:3,000, and the facility map were used for the input of spatial data and the address, the year when sewer pipe was burried, and the quality of pipe, the pipe diameter, and the length of pipe were used as attribute data. Relational structure was used for establishment of database then, searching, analyzing, and processing were possible. Additionary, the result of this studying can be used for replacement of a old sewer pipe, a material quantity which is related with repairement of sewer pipe, and calculation of time, cost by application program framed by Fortran.