OLTP PERFORMANCE IMPROVEMENT USING FILE-SYSTEMS LAYER COMPRESSION

2017 ◽  
Vol 79 (4) ◽  
Author(s):  
Suharjito Suharjito ◽  
Adrianus B. Kurnadi
Keyword(s):  
Response Time ◽  
Performance Improvement ◽  
Compression Ratio ◽  
File Systems ◽  
Transaction Processing ◽  
Maximum Response ◽  
Improve Performance ◽  
Oracle Database ◽  
Maximum Response Time ◽  
The Cost

Database for Online Transaction Processing (OLTP) application is used by almost every corporations that has adopted computerisation to support their operational day to day business. Compression in the storage or file-systems layer has not been widely adopted for OLTP database because of the concern that it might decrease database performance. OLTP compression in the database layer is available commercially but it has a significant licence cost that reduces the cost saving of compression. In this research, transparent file-system compression with LZ4, LZJB and ZLE algorithm have been tested to improve performance of OLTP application. Using Swing-bench as the benchmark tool and Oracle database 12c, The result indicated that on OLTP workload, LZJB was the most optimal compression algorithm with performance improvement up to 49% and consistent reduction of maximum response time and CPU utilisation overhead, while LZ4 was the compression with the highest compression ratio and ZLE was the compression with the lowest CPU utilisation overhead. In terms of compression ratio, LZ4 can deliver the highest compression ratio which is 5.32, followed by LZJB, 4.92; and ZLE, 1.76. Furthermore, it is found that there is indeed a risk of reduced performance and/or an increase of maximum response time.

scholarly journals Rancang Bangun alat pembuka pintu portal berbasis arduino menggunakan smartphone

2020 ◽  
Vol 1 (1) ◽  
pp. 27-31
Author(s):  
Achmad Haris Afandi ◽  
Putri Anbar Ghalia ◽  
Kistiani Kistiani ◽  
Indri Rahma Sari ◽  
Sri Aswaidar Miza
Keyword(s):  
Response Time ◽  
System Design ◽  
Open Space ◽  
Type A ◽  
Maximum Response ◽  
Maximum Distance ◽  
Automated System ◽  
Servo Motor ◽  
Maximum Response Time ◽  
Green Leds

This study aims to design a prototype Arduino-based portal door controller system device using a smartphone. The making of the tool is done as one of the efforts in advancing technology to provide convenience and comfort through the development of an automated system in the home in the form of automatic portal doors using smartphones. The components used for system design are Arduino REV3 microcontroller module, USB 2.0 type A / B cable (Arduino USB cable), SG90 9g servo motor, red and green LEDs, 220Ω resistor, mini protoboard, connecting cable, jumper cable, and bluetooth module HC06, Powerbank with a capacity of 5600 mAh and a smartphone, while designing software uses Arduino IDE. Based on the results of measurements and testing, the system on the device made is able to open and close the portal door automatically at a maximum distance of 15 meters with a maximum response time of 1 second in open space

Optimal allocation of emergency response services for managing disasters

2014 ◽  
Vol 23 (4) ◽  
pp. 329-342 ◽  
Author(s):  
Evangelos Mitsakis ◽  
Iraklis Stamos ◽  
Jose Maria Salanova Grau ◽  
Georgia Aifadopoulou
Keyword(s):  
Response Time ◽  
Objective Function ◽  
Disaster Management ◽  
Emergency Response ◽  
Optimal Allocation ◽  
Response Times ◽  
Maximum Response ◽  
Content Type ◽  
Maximum Response Time ◽  
Emergency Response Services

Purpose – The purpose of this paper is to present and apply a methodology that optimally assigns emergency response services (ERS) stations in Peloponnesus, Greece that was severely hit by wildfires in 2007, in an effort to describe the actual emergency response in this disaster and identify disaster management possibilities that can arise from the optimal allocation of the existing fire stations. Design/methodology/approach – The methodology concerns the development of an objective function that aims to minimize maximum and average response times of ERS stations and the evaluation of developed scenarios. Simulated annealing is used for the minimization of the objective function, providing near-optimal solutions with low computation times for medium-scale networks. Findings – The findings concern the comparison of average and maximum response times of ERS stations to hearths of fire, based on their actual and optimal allocation. They reveal an overall reduction in the average and maximum response time by 20 and 30 percent, respectively, for the entire region, while there is a reduction of 15 and 35 percent in the average and maximum response time for the locations affected by the 2007 wildfires. Research limitations/implications – The methodology is formulated as a facility location problem with unitary demand and unlimited capacity in the stations, which means that the allocation does not take into account simultaneous events. Originality/value – The paper fulfills an identified need to apply innovative research solutions to actual case studies in order to identify existing gaps and future disaster management possibilities.

scholarly journals Evaluation of the Use of Class B LoRaWAN for the Coordination of Distributed Interface Protection Systems in Smart Grids

2020 ◽  
Vol 9 (1) ◽  
pp. 13 ◽  
Author(s):  
Marco Pasetti ◽  
Emiliano Sisinni ◽  
Paolo Ferrari ◽  
Stefano Rinaldi ◽  
Alessandro Depari ◽  
...  
Keyword(s):  
Response Time ◽  
Communication Networks ◽  
Smart Grids ◽  
Distribution Networks ◽  
Maximum Response ◽  
Area Network ◽  
Wide Area Network ◽  
Protection Systems ◽  
Class B ◽  
Maximum Response Time

The adoption of the distributed generation paradigm is introducing several changes in the design and operation of modern distribution networks. Modern grid codes are becoming more and more complex, and the adoption of smart protection systems is becoming mandatory. However, the adoption of newer and smarter units is only half of the story. Proper communication networks must be provided as well, and the overall costs may become critical. In this work, the adoption of the Long-Range Wide Area Network (LoRaWAN) technology is suggested as a viable approach to implement the coordination of Interface Protection Systems. A proper communication architecture based on the LoRaWAN Class B technology was proposed and evaluated in order to assess its feasibility for the considered application. A scalability analysis was carried out, by computing the number of devices that can be handled by a single LoRaWAN Gateway (GW) and the maximum expected time of response between a triggering event and the arrival of the related coordination command. The results of the study showed that up to 312 devices can be managed by a single GW, by assuring a maximum response time of 22.95 s. A faster maximum response time of 6.2 s is also possible by reducing the number of managed devices to 12.

Drift Mobility Measurements in Porous Silicon

1996 ◽  
Vol 420 ◽  
Author(s):  
L. Tsybeskov ◽  
C. Peng ◽  
P. M. Fauchet ◽  
Q. Gu ◽  
E. A. Schiff
Keyword(s):  
Porous Silicon ◽  
Response Time ◽  
Room Temperature ◽  
Forward Bias ◽  
Drift Mobility ◽  
Maximum Response ◽  
Forward Bias Voltage ◽  
Maximum Response Time ◽  
Temperature Time ◽  
Applied Forward Bias

AbstractModulated electroluminescence (EL) measurements performed on a series of porous silicon (PSi) diodes are presented. The maximum response time of the devices scales with the square of the PSi layer thickness and inversely with the applied forward bias voltage. These scaling results indicate that the maximum response time is a carrier transit time from which a drift mobility μ of 10−4 cm2/Vs is deduced at room temperature. Time-of-flight transport measurements on PSi are in qualitative agreement with this value for μ in addition, they identify μ as the electron mobility and show that transport is dispersive, in contrast to the interpretation of the modulated EL experiments.

Prevalent Factors Involved in Delays Associated with Page Downloads

2007 ◽  
pp. 55-67
Author(s):  
Kevin Curran ◽  
Noel Broderick
Keyword(s):  
Response Time ◽  
Large Percentage ◽  
Maximum Response ◽  
Academic Institutions ◽  
Text And Image ◽  
Maximum Response Time ◽  
Inherent Problem

Over the years the number of Web users has increased dramatically unfortunately leading to the inherent problem of congestion. This can affect each user’s surfing experience. A large percentage of sites use a combination of text and image-heavy design with the use of images contributing heavily to slow-loading sites. Studies have shown that surfers spend a lot of time impatiently waiting for pages to emerge on screen and HCI guidelines indicate 10 seconds as the maximum response time before users lose interest. This chapter presents research into the observed usage of images by academic institutions and the effects on page retrieval times.

Minimising maximum response time

2013 ◽  
Vol 40 (10) ◽  
pp. 2314-2321 ◽  
Author(s):  
Alberto García-Villoria ◽  
Rafael Pastor
Keyword(s):  
Response Time ◽  
Maximum Response ◽  
Maximum Response Time

N and P on-line meters: requirements, maintenance and stability

1996 ◽  
Vol 33 (1) ◽  
pp. 147-157 ◽  
Author(s):  
Henrik A. Thomsen ◽  
Kenneth Kisbye
Keyword(s):  
Sample Preparation ◽  
Response Time ◽  
Ammonium Nitrate ◽  
State Of The Art ◽  
List Price ◽  
User Friendliness ◽  
On Line ◽  
The Cost ◽  
Preparation Design

State-of-the-art on-line meters for determination of ammonium, nitrate and phosphate are presented. The on-line meters employ different measuring principles and are available in many different designs differing with respect to size, calibration and cleaning principle, user-friendliness, response time, reagent and sample consumption. A study of Danish experiences on several plants has been conducted. The list price of an on-line meter is between USD 8000 and USD 35,000. To this should be added the cost of sample preparation, design, installation and running-in. The yearly operating for one meter are in the range of USD 200-2500 and the manpower consumption is in the range of 1-5 hours/month. The accuracy obtained is only slightly smaller than the accuracy on collaborative laboratory analyses, which is sufficient for most control purposes.

Sign in / Sign up

Export Citation Format

Share Document