An Approach to Fine Tuning Database Performance in Application Software

2021 ◽  
Vol 9 (1) ◽  
pp. 10-13
Author(s):  
LN Chavali ◽  
◽  
Lal Hmingliana ◽  
Brindha Senthil Kumar ◽  
P. Lakshmi Narayana ◽  
...  
Keyword(s):  
Fine Tuning ◽  
Sql Server ◽  
Application Software ◽  
Comparative Performance ◽  
Crucial Step ◽  
Database Performance ◽  
Marginal Gain ◽  
Database Tuning

Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.

Database tuning advisor for microsoft SQL server 2005

2005 ◽  
Author(s):  
Sanjay Agrawal ◽  
Surajit Chaudhuri ◽  
Lubor Kollar ◽  
Arun Marathe ◽  
Vivek Narasayya ◽  
...  
Keyword(s):  
Sql Server ◽  
Sql Server 2005 ◽  
Database Tuning

Database Tuning Advisor for Microsoft SQL Server 2005

2004 ◽  
pp. 1110-1121 ◽  
Author(s):  
Sanjay Agrawal ◽  
Surajit Chaudhuri ◽  
Lubor Kollar ◽  
Arun Marathe ◽  
Vivek Narasayya ◽  
...  
Keyword(s):  
Sql Server ◽  
Sql Server 2005 ◽  
Database Tuning

scholarly journals Concurrency Control in Database Management System

2021 ◽  
Vol 5 (4) ◽  
pp. 76-79
Author(s):  
Thi Ngoc Thanh Nguyen
Keyword(s):  
Concurrency Control ◽  
Management System ◽  
Database Management ◽  
Database Management System ◽  
Sql Server ◽  
Software Systems ◽  
Application Software

Nowadays, most application software systems are aimed at multi-user environments and simultaneous access to the same database. Therefore, concurrency controllers are an integral part of any database management system. The concurrency controller plays an important role in controlling transactions which perform simultaneous access to the database without conflict. This paper presents an overview and illustration how to use concurrency control in database management system of Microsoft SQL Server.

scholarly journals Advanced Photocatalysts Based on Reduced Nanographene Oxide–TiO2 Photonic Crystal Films

Materials ◽  
2019 ◽  
Vol 12 (16) ◽  
pp. 2518 ◽  
Author(s):  
Diamantopoulou ◽  
Sakellis ◽  
Gardelis ◽  
Tsoutsou ◽  
Glenis ◽  
...  
Keyword(s):  
Photocatalytic Activity ◽  
Charge Separation ◽  
Photonic Band Gap ◽  
Thermal Reduction ◽  
Surface Reactivity ◽  
Fine Tuning ◽  
Comparative Performance ◽  
Inverse Opals ◽  
Crystal Films ◽  
Key Factor

Surface functionalization of TiO2 inverse opals by graphene oxide nanocolloids (nanoGO) presents a promising modification for the development of advanced photocatalysts that combine slow photon-assisted light harvesting, surface area, and mass transport of macroporous photonic structures with the enhanced adsorption capability, surface reactivity, and charge separation of GO nanosheets. In this work, post-thermal reduction of nanoGO–TiO2 inverse opals was investigated in order to explore the role of interfacial electron transfer vs. pollutant adsorption and improve their photocatalytic activity. Photonic band gap-engineered TiO2 inverse opals were fabricated by the coassembly technique and were functionalized by GO nanosheets and reduced under He at 200 and 500 °C. Comparative performance evaluation of the nanoGO–TiO2 films on methylene blue photodegradation under UV-VIS and visible light showed that thermal reduction at 200 °C, in synergy with slow photon effects, improved the photocatalytic reaction rate despite the loss of nanoGO and oxygen functional groups, pointing to enhanced charge separation. This was further supported by photoluminescence spectroscopy and salicylic acid UV-VIS photodegradation, where, in the absence of photonic effects, the photocatalytic activity increased, confirming that fine-tuning of interfacial coupling between TiO2 and reduced nanoGO is a key factor for the development of highly efficient photocatalytic films.

Fuzzy Multivariable Control Strategy Applied to a Refrigeration System

2016 ◽  
Vol 12 (2) ◽  
Author(s):  
Saulo Fernando dos Santos Vidal ◽  
Jones Erni Schmitz ◽  
Ivan Carlos Franco ◽  
Ana Maria Frattini Fileti ◽  
Flavio Vasconcelos Da Silva
Keyword(s):  
Energy Consumption ◽  
Fuzzy Controller ◽  
Fine Tuning ◽  
Refrigeration System ◽  
Process Variables ◽  
Pump Frequency ◽  
Comparative Performance ◽  
Control Effort ◽  
Squared Error ◽  
And Control

Abstract The refrigeration process involves complex systems exhibiting nonlinearities and coupled behavior, so this paper aims to evaluate the comparative performance of a multivariable fuzzy logic-based control system and a classic multi loop PID. The process variables were the temperature of the secondary fluid (propylene glycol) outlet and the evaporating temperature. The manipulated variables were the compressor frequency speed and the pump frequency speed. Aspen Plus and Aspen Dynamics simulators were used to simulate the experimental prototype. The model was previously validated and linked with MATLAB software, where the controllers were implemented. Tuning of the fuzzy controller was performed through the membership functions and gains adjustments. The tuning of the multi loop PID controller was performed using the Ziegler-Nichols method and then a fine tuning was carried out. In order to fairly compare energy consumption and control effort, the tune of PID-based strategy was finished when similar values of Integral of Squared Error were achieved. Thus, very similar behavior for the process variables in both controllers. On the other hand, a great improvement in the control effort and energy saving was observed when the multivariable fuzzy controller was used in comparison to classic PID. The energy consumption was reduced by 25 % and the control effort by 96 % when the proposed strategy was used.

Using Data Masking for Balancing Security and Performance in Data Warehousing

2013 ◽  
pp. 384-409
Author(s):  
Ricardo Jorge Santos ◽  
Jorge Bernardino ◽  
Marco Vieira
Keyword(s):  
Database Management System ◽  
Sql Server ◽  
Storage Space ◽  
Simple Arithmetic ◽  
Database Performance ◽  
Data Querying ◽  
Implementation Costs ◽  
Data Masking ◽  
And Performance ◽  
Using Data

Data Warehouses (DWs) are the core of sensitive business information, which makes them an appealing target. Encryption solutions are accepted as the best way to ensure strong security in data confidentiality while keeping high database performance. However, this work shows that they introduce massive storage space and performance overheads to a magnitude that makes them unfeasible for DWs. This work proposes a data masking technique for protecting sensitive business data in DWs which balances security strength with database performance, using a Formula based on the mathematical modular operator and simple arithmetic operations. The proposed solution provides apparent randomness in the generation and distribution of the masked values, while introducing small storage space and query execution time overheads. It also enables a false data injection method for misleading attackers and increasing the overall security strength. It can be easily implemented in any DataBase Management System (DBMS) and transparently used, without changes to application source code. Experimental evaluations using a real-world DW and TPC-H decision support benchmark implemented in leading DBMS Oracle 11g and Microsoft SQL Server 2008 demonstrate its overall effectiveness. Results show the substantial savings of its implementation costs when compared with state of the art encryption solutions provided by those DBMS and that it outperforms those solutions in both data querying and insertion of new data.

Comparison between Normalized Databases Implemented with Different Database Systems

2013 ◽  
Vol 774-776 ◽  
pp. 1827-1832 ◽  
Author(s):  
Omar Kassem Khalil ◽  
Aissa Boudjella ◽  
Brahim Belhouari Samir
Keyword(s):  
Normal Form ◽  
Data Storage ◽  
Normal Forms ◽  
Database Systems ◽  
Database System ◽  
Sql Server ◽  
Database Performance ◽  
And Storage ◽  
Normalization Process ◽  
Different Levels

This paper compares different levels of database normalization process in terms of anomalies removal and storage reduction. Several databases have been normalized up to Third Normal Form (1NF, 2NF and 3NF) in order to investigate the influence of the normalization on the database performance. They are implemented separately with different database systems such as MS Access, SQL Server and Oracle. The percentage of storage reduction and data anomalies are investigated for every normal form and database system. The results show that the data storage is significantly reduced over unnormalized database, approximately between 20 to 30% for 1NF flattening tables and 1NF decomposing table, and between (15% - 22%) and (9% - 22%) for 2NF and 3NF, respectively. The removal of the majority of anomalies is observed in the first normal form while fewer anomalies are removed in the next higher normal forms. For the same database implemented, the comparison between three different database systems shows approximately the same results with slight differences. These differences may be due to the nature, the size of the constraints and metadata on each database system.

Sign in / Sign up

Export Citation Format

Share Document