The Experts below are selected from a list of 156 Experts worldwide ranked by ideXlab platform
Chanik Park - One of the best experts on this subject based on the ideXlab platform.
-
SIGMOD Conference - A case for flash memory ssd in enterprise database applications
Proceedings of the 2008 ACM SIGMOD international conference on Management of data - SIGMOD '08, 2008Co-Authors: Bongki Moon, Chanik ParkAbstract:Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and Temporary Table spaces.
-
A case for flash memory SSD in enterprise database applications
Proc. ACM SIGMOD Int. Conf. on Management of Data, 2008Co-Authors: S C Lee, Jaeho Kim, Bongki Moon, Chanik Park, Sang Woo KimAbstract:Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and Temporary Table spaces.
Shanyu Tang - One of the best experts on this subject based on the ideXlab platform.
-
GreenCom/iThings/CPScom - Improving Performance of E-Government System from the User Perspective
2013 IEEE International Conference on Green Computing and Communications and IEEE Internet of Things and IEEE Cyber Physical and Social Computing, 2013Co-Authors: Hang Zhang, Sifa Zhang, Muzhou Xiong, Shanyu TangAbstract:For a B/S based e-government system, system performance is one of the metrics for evaluating the system, which determines user experience and even affects the image of the government in public. To improve the performance of the e-government system, people should pay attention not only on the process of system design (like web design) and system deployment (like using powerful web server), but also on the way of accessing data. This paper proposes a method of measuring performance from the user perspective, so as to evaluate the data access performance of the e-government system. It measures the response time of loading a page with different methods of data access, in which data are accessed by using the traditional SQL statements, view, and Temporary Table methods. Experiment results show that there is no significant difference in terms of performance between the traditional SQL statement method and the view method, and the method of using Temporary Table with any amount of data achieves better performance than the other two methods.
-
Improving Performance of E-Government System from the User Perspective
2013 IEEE International Conference on Green Computing and Communications and IEEE Internet of Things and IEEE Cyber Physical and Social Computing, 2013Co-Authors: Hang Zhang, Sifa Zhang, Muzhou Xiong, Shanyu TangAbstract:For a B/S based e-government system, system performance is one of the metrics for evaluating the system, which determines user experience and even affects the image of the government in public. To improve the performance of the e-government system, people should pay attention not only on the process of system design (like web design) and system deployment (like using powerful web server), but also on the way of accessing data. This paper proposes a method of measuring performance from the user perspective, so as to evaluate the data access performance of the e-government system. It measures the response time of loading a page with different methods of data access, in which data are accessed by using the traditional SQL statements, view, and Temporary Table methods. Experiment results show that there is no significant difference in terms of performance between the traditional SQL statement method and the view method, and the method of using Temporary Table with any amount of data achieves better performance than the other two methods.
Bongki Moon - One of the best experts on this subject based on the ideXlab platform.
-
SIGMOD Conference - A case for flash memory ssd in enterprise database applications
Proceedings of the 2008 ACM SIGMOD international conference on Management of data - SIGMOD '08, 2008Co-Authors: Bongki Moon, Chanik ParkAbstract:Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and Temporary Table spaces.
-
A case for flash memory SSD in enterprise database applications
Proc. ACM SIGMOD Int. Conf. on Management of Data, 2008Co-Authors: S C Lee, Jaeho Kim, Bongki Moon, Chanik Park, Sang Woo KimAbstract:Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and Temporary Table spaces.
Sang-shin Park - One of the best experts on this subject based on the ideXlab platform.
-
Hash join in commercial database with flash memory SSD
2010 3rd International Conference on Computer Science and Information Technology, 2010Co-Authors: Sang-shin ParkAbstract:Hash join is one of important operations in database system, and its performance may slow down because of disk I/O in hash Table overflow phenomenon. In that phenomenon, the more overflow of hash Table occurs, the more disk I/O arise, so join performance go from bad to worse. Dominant disk I/O patterns of hash join are sequential writes and random reads, then flash memory SSD is in a more advantageous position than magnetic disk on those I/O patterns. Therefore, using a flash memory SSD instead of magnetic disk as a Temporary storage of database will prevent existing performance degradation. In this paper, we show calculated costs by query optimizer in some test cases first. And then, we also show empirically hash join performance in these test cases on Temporary Table space created on magnetic disk and flash memory SSD. Consequently, the average response time with flash memory SSD was about nine times, minimum and twenty times, max faster than that with magnetic disk. And you might encounter problems that estimated cost by query optimizer and real performance do not correspond on magnetic disk. But, that problem was solved on flash memory SSD.
Sang Woo Kim - One of the best experts on this subject based on the ideXlab platform.
-
A case for flash memory SSD in enterprise database applications
Proc. ACM SIGMOD Int. Conf. on Management of Data, 2008Co-Authors: S C Lee, Jaeho Kim, Bongki Moon, Chanik Park, Sang Woo KimAbstract:Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and Temporary Table spaces.
