• Journal of Korea Society of Industrial Information Systems
• /
• v.13 no.5
• /
• pp.1-6
• /
• 2008

Database Administrators (DBA) play a role in designing and maintaining database systems. It is one of the Information Technology (IT) jobs in high demand and is important in developing and maintaining Information Systems (IS). Little research has been conducted on the skill requirements for a DBA. By collecting and analyzing job ads posted on the websites of Fortune 500 companies, we investigated the skill requirements needed for today's DBA.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2014.05a
• /
• pp.254-256
• /
• 2014

In this paper, using the Android App to remote database monitoring system is proposed. Existing remote database monitoring scheme CS(Client / Server) based. Conventional CS based systems are space constraints and a plurality of administrator to access the database at that degrade performance disadvantages. The advantage of the proposed system first, because the web -based interface allows the application program, and also the ease of maintenance, through a web browser, if you have Internet access anytime, anywhere environment without restrictions of time and space monitoring. Second, the proposed system because the App -based technology due to an increase in connection session and query execution does not affect the performance of your database. Third, if there is a problem with the remote database through which social networks immediately notify the administrator of the smartphone in real time so that the administrator can identify the problem.

• 전자공학회논문지 IE
• /
• v.43 no.4
• /
• pp.60-64
• /
• 2006

This system constructs system devoted to what supplement that I follow at an installation interval of attribute quotient repeater of a thing devoted wireless communication device gaining position information, and range of information is limited. A parking lot management system constructed a database of parking information, and the database information was planned so that there was the number of to easily offer client and an Administrator. There is a sensor in several to perceive a vehicle about adhesion in a radio communication device installed in a parking lot and covers, and hits data after parking to a server and transmits base information. The Administrator program that I verified an information treatment of the server parking management database that I did wireless hand phone emulator J2MEWTK with client and verified working together of a server, and was understood by a transfer of, parking information, and was devoted to a, server and an Administrator offered the menu screen which was easy for a user convenience and management.

• Journal of Biosystems Engineering
• /
• v.39 no.4
• /
• pp.267-273
• /
• 2014

Purpose: This study was conducted to develop a web-based business management system to ensure the efficient operation and transparent management of government-subsidized agricultural machinery rental businesses. Methods: An MS_SQL2000 database management system (DBMS) solution was utilized in the system for high system compatibility and integrated management. This system was targeted to be compatible with Internet Explorer 6.0 or later and to ensure security and seamless web operations. The system administrator is able to manage a fleet of agricultural machinery, including various inventory codes, release and return, fleet registry, and business performance. Users (farmers) may search the database of rental machinery and reserve them. Results: With respect to rental reservations, the system administrator can manage the fleet by setting the rental status to Approved, Released, or Returned. Through the web, the administrator can also create a database that includes machinery specifications, features, and rental rates. In addition, business performance data can be analyzed using a diverse array of tools to streamline the rental business. Without having to go to the rental office, users can save time and money by searching for and renting agricultural machinery through the information available on the website, including availability, specifications, and rental fees. After deploying the system, the time required to analyze monthly performance and create reports was dramatically reduced from 20 days per person to one day per person. Conclusions: Since 2014, AMRB has been installed and is operating in agricultural machinery rental businesses in 31 cities and counties in South Korea. This study recommends continued expansion and dissemination of AMRB for the systematic and efficient management of agricultural machinery rental businesses.

• Journal of the Korea Society of Computer and Information
• /
• v.13 no.5
• /
• pp.103-110
• /
• 2008

Due to the development of the e-commerce, the shopping mall such as auction collects and manages the personal information of the customers for efficient service. However, because of the leakage of the Personal information in auction, the image of the companies as well as the information subjects is damaged. Even though the organizations and the companies store the personal information as common sentences and protect using role based access control technique, the personal information can be leaked easily in case of getting the authority of the database administrator. And also the role based access control technique is not appropriate for protecting the sensitive information of the information subject. In this paper, we encrypted the sensitive information assigned by the information subject and then stored them into the database. We propose the personal policy based access control technique which controls the access to the information strictly according to the personal policy of the information subject. Through the proposed method we complemented the problems that the role based access control has and also we constructed the database safe from the database administrator. Finally, we get the control authority about the information of the information subject.

• Journal of Information Technology Applications and Management
• /
• v.15 no.1
• /
• pp.271-282
• /
• 2008

Database administrators are demanded to acquire much knowledges and take great efforts for keeping consistent performance in system. Various principles, methods, and tools have been proposed in many studies and commercial products in order to alleviate such burdens on database administrators, and it has resulted to the automation of DBMS which reduces the intervention of database administrator. This paper suggests a resource selection method that estimates the status of the database system based on the workload characteristics and that recommends tuneable resources. Our method tries to simplify selection information on DBMS status using data-mining techniques, enhance the accuracy of the selection model, and recommend tuneable resource. For evaluating the performance of our method, instances are collected in TPC-C and TPC-W workloads, and accuracy are calculated using 10 cross validation method, comparisons are made between our scheme and the method which uses only the classification procedure without any simplification of informations. It is shown that our method has over 90% accuracy and can perform tuneable resource selection.

• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.1491-1496
• /
• 2009

Because of the development of advanced construction technology, the inner environments of building become more and more complicated, which may result in many problems. The administer may forget where they put up the certain picture, and search for it all over the building, or they underestimate the number of the visitors, and find the situation is out of control, while the pedestrian may get lost, and after making their efforts, they found they turned back to the origin point again. So it is very necessary to establish an indoor spatial database. On one hand, it is able to assist administrator to manage the property and human flow inside the building, on the other hand it could help the pedestrian find the way easily especially when they are not familiar with the building or there is an emergency. This paper focused on how to create the indoor spatial database including both static database and moving objects database. The static database is built on the basis of 3D building models, and the moving objects database gets information from many kinds of cameras and sensors installed in the building. And at the same time the paper discussed the practical use of indoor spatial database mainly in three aspects including consistency management, building restructure, and pedestrian navigation.

• Journal of the Korean School Mathematics Society
• /
• v.4 no.1
• /
• pp.69-80
• /
• 2001

A web-based intelligent education system(WEST) was designed and implemented to improve the self-directed study for students by providing them the study according to one's ability. WEST is composed of a tutor agent, an administrator module, a teacher module and a student module. The tutor agent analyzes students' ability and selects questions from a database according to their ability. The administrator module administrates subjects and students. The teacher module makes questions with three levels and administrates questions. The students module gives the questions students and the result of study. WEST was used in a mathematics subject for high-school students. Especially our system was better than the others in study according to students' ability.

• Proceedings of the Korea Institute of Convergence Signal Processing
• /
• 2000.12a
• /
• pp.33-36
• /
• 2000

The purpose of this paper is to develop the web-based apartment flaw-repairing petition system which can be operated under the internet environments. The developed system mainly consists of administrator, constructor and apartment resident section. The administrator can administrate all of the actions which will be occurred during the operation. Constructor must be enrolled before resident can use this system. All of the resident member must enroll before they petition the company. All of the processing is monitored and accumulated at the database to calculate the statistics and finally will be shown by the graphical results. This system which is programmed by the PERL and PHP and MySQL will be easily transformed into the similar kind of request system.

• The Journal of Korean Association of Computer Education
• /
• v.4 no.1
• /
• pp.145-152
• /
• 2001

The development of distributed databases using a distributed object technology is more popular than ever before because the current computer system environment is adaptable for a use as well as the cost of the integration of legacy systems is cheaper than making a new application. In schools, development of an integrated system consisted of many stand-alone databases give a teacher and an administrator the convenience of managing the database in a school and the ease integration of data in it. Therefore, this research is to design and implement the 3-tier distributed database using CORBA, Java and JDBC.