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.

RANCANG ULANG APLIKASI PENGARSIPAN SIDOL (SISTEM INFORMASI DOKUMEN LEGAL) PADA PT BUKAKA TEKNIK UTAMA

2018 ◽  
Vol 23 (1) ◽  
pp. 66-79
Author(s):  
Condro Wibawa ◽  
Dessy Tri Anggraeni
Keyword(s):  
Management System ◽  
Database Management ◽  
Database Management System ◽  
Sql Server ◽  
E Mail ◽  
Design Construction

PT Bukaka Teknik Utama adalah perusahaan yang bergerak di bidang engineering, konstruksi, dan manufaktur. Dalam operasional usaha, diperlukan berbagai izin seperti izin usaha dan izin proyek yang merupakan bagian dari Dokumen Legal. Saat ini informasi Dokumen Legal di PT Bukaka Teknik Utama dikelola dalam aplikasi desktop yang bernama SIDOL (Sistem Informasi Dokumen Legal). Aplikasi juga digunakan untuk memonitoring masa berlaku dokumen. Namun begitu, aplikasi ini memiliki beberapa kekurangan, diantaranya adalah hanya dapat diakses oleh komputer yang terpasang aplikasi tersebut, hanya dapat diakses dari jaringan lokal (LAN), dan sistem notifikasi yang hanya dapat dilihat saat pengguna membuka aplikasi. Untuk mengatasi kekurangan tersebut, akan dilakukan perancangan ulang aplikasi sehingga mampu menjawab kekurangan yang ada. Pembuatan aplikasi menggunakan metode prototipe. Metode ini memiliki lima tahapan pengembangan yaitu communication, quick plan, modeling quick design, construction of prototype, and deployment delivery and feedback. Aplikasi dibangun menggunakan bahasa pemrograman HTML untuk tampilan, PHP untuk pengolahan data di sisi server, CSS untuk page styling, Code Igniter sebagai framework, dan Micsosoft SQL Server sebagai Database Management System. Hasil akhir aplikasi adalah menyediakan aplikasi yang dapat diakses semua karyawan yang membutuhlkan informasi Dokumen Legal serta memberikan notifikasi melalui e-mail ketika terdapat dokumen yang masa berlakunya akan segera berakhir.

Determinants of Control System Design in Divisionalized Firms

2004 ◽  
Vol 79 (3) ◽  
pp. 545-570 ◽  
Author(s):  
Margaret A. Abernethy ◽  
Jan Bouwens ◽  
Laurence van Lent
Keyword(s):  
Control System ◽  
System Design ◽  
Performance Measures ◽  
Simultaneous Equation ◽  
Equation Model ◽  
Control System Design ◽  
Information Asymmetries ◽  
Endogenous Variables ◽  
And Performance ◽  
Using Data

We investigate two determinants of two choices in the control system of divisionalized firms, namely decentralization and use of performance measures. The two determinants are those identified in the literature as important to control system design: (1) information asymmetries between corporate and divisional managers and (2) division interdependencies. We treat decentralization and performance measurement choices as endogenous variables and examine the interrelation among these choices using a simultaneous equation model. Using data from 78 divisions, our results indicate that decentralization is positively related to the level of information asymmetries and negatively to intrafirm interdependencies, while the use of performance measures is affected by the level of interdependencies among divisions within the firm, but not by information asymmetries. We find some evidence that decentralization choice and use of performance measures are complementary.

Capacity Planning for Cluster Tools of Wafer Fabrication Plant

2010 ◽  
Vol 450 ◽  
pp. 365-368
Author(s):  
James C. Chen ◽  
Chia Wen Chen ◽  
Kou Huang Chen ◽  
Chien Hsin Lin
Keyword(s):  
Capacity Planning ◽  
Production Costs ◽  
Wafer Fabrication ◽  
Total Production ◽  
Output Rate ◽  
Cluster Tools ◽  
And Performance ◽  
Using Data ◽  
Capital Intensive

Wafer fabrication is a capital intensive industry. A 12-inch wafer fabrication plant needs a typical investment of US$ 3 billion, and the equipment cost constitutes about two-thirds to three-quarters of the total production costs. Therefore, capacity planning is crucial to the investment and performance of wafer fabrication plants. Several formulae are presented to calculate the required number of machines with sequential, parallel, and batch processing characteristics, respectively. An AutoSched AP simulation model using data from real foundry fabrication plants is used in a case study to evaluate the performance of the proposed formulae. Simulation results indicate that the proposed formulae can quickly and accurately calculate the required number of cluster tools leading to the required monthly output rate.

scholarly journals Defining an Industry: What is the Size and Scope of the Australian Building and Construction Industry

1970 ◽  
Vol 10 (1-2) ◽  
pp. 119-131 ◽  
Author(s):  
Gerard De Valence
Keyword(s):  
Construction Industry ◽  
Performance Model ◽  
Cluster Approach ◽  
Industry Cluster ◽  
Traditional Structure ◽  
Economic Contribution ◽  
And Performance ◽  
Using Data ◽  
Traditional Industry ◽  
Different Characteristics

This is a reprint from Vol 1, no 1, which has not previously been available in electronic format.The analysis and understanding of the conduct and performance of an industry begins with a study of its structure. However, before analysing an industry's structure it is necessary to define the industry and identify its size, scope and scale to establish its true economic contribution. This paper discusses the size and scope of the Australian building and construction industry, firstly froma traditional industry economics approach by firm size and business characteristics using data fron three construction industry surveys done over 15 years by the ABS. Secondly, data from an industry 'cluster' perspective is shown. The objective of the paper is to compare the differences found in industry size and scope in the structure-conduct-performance approach and the alternative industry cluster approach. Each model reveals different characteristics of the industry. The conclusion finds that the building and construction industry is a case where the traditional structure-conduct-performance model cannot be easily applied. 

scholarly journals Derivation and Performance of Standardized Enhanced Liver Fibrosis (ELF) Test Thresholds for the Detection and Prognosis of Liver Fibrosis

2019 ◽  
Vol 3 (5) ◽  
pp. 815-826 ◽  
Author(s):  
James Day ◽  
Preya Patel ◽  
Julie Parkes ◽  
William Rosenberg
Keyword(s):  
Liver Fibrosis ◽  
Delphi Panel ◽  
Test Results ◽  
Hazard Ratios ◽  
Test Thresholds ◽  
And Performance ◽  
Using Data ◽  
Relationship Of ◽  
The Relationship ◽  
Selection Of

Abstract Introduction Noninvasive tests are increasingly used to assess liver fibrosis and determine prognosis but suggested test thresholds vary. We describe the selection of standardized thresholds for the Enhanced Liver Fibrosis (ELF) test for the detection of liver fibrosis and for prognostication in chronic liver disease. Methods A Delphi method was used to identify thresholds for the ELF test to predict histological liver fibrosis stages, including cirrhosis, using data derived from 921 patients in the EUROGOLF cohort. These thresholds were then used to determine the prognostic performance of ELF in a subset of 457 patients followed for a mean of 5 years. Results The Delphi panel selected sensitivity of 85% for the detection of fibrosis and >95% specificity for cirrhosis. The corresponding thresholds were 7.7, 9.8, and 11.3. Eighty-five percent of patients with mild or worse fibrosis had an ELF score ≥7.7. The sensitivity for cirrhosis of ELF ≥9.8 was 76%. ELF ≥11.3 was 97% specific for cirrhosis. ELF scores show a near-linear relationship with Ishak fibrosis stages. Relative to the <7.7 group, the hazard ratios for a liver-related outcome at 5 years were 21.00 (95% CI, 2.68–164.65) and 71.04 (95% CI, 9.4–536.7) in the 9.8 to <11.3 and ≥11.3 subgroups, respectively. Conclusion The selection of standard thresholds for detection and prognosis of liver fibrosis is described and their performance reported. These thresholds should prove useful in both interpreting and explaining test results and when considering the relationship of ELF score to Ishak stage in the context of monitoring.

scholarly journals Internationalization and Performance of Vietnamese Manufacturing Firms: Does Organizational Slack Matter?

2018 ◽  
Vol 8 (4) ◽  
pp. 64 ◽  
Author(s):  
Hien Thi Ngoc Huynh ◽  
Phuong V. Nguyen ◽  
Khoa T. Tran
Keyword(s):  
Emerging Market ◽  
Developed Countries ◽  
Organizational Slack ◽  
Optimum Level ◽  
International Expansion ◽  
Manufacturing Enterprises ◽  
Long Run ◽  
Third Stage ◽  
And Performance ◽  
Using Data

This paper aims to investigate the three-stage theory of international expansion in the long run from the perspective of firm behavior. Although this topic has been mostly explored using data from developed countries, this paper aims to fill the research gap in an emerging market by using an extensive unbalanced panel data of 12,704 unlisted Vietnam manufacturing enterprises from the General Statistics Office during 2007 to 2012. The findings illustrated a significant S-shaped relationship between internationalization and performance. Notably, the results depict significantly moderating effects of both high-discretion slacks and low-discretion slacks on the internationalization–performance relationship across three stages of global expansion as an enterprise enhances this relationship in the first and third stage although this worsens it in the middle stage. The empirical results suggest that firms should determine the optimum level of internationalization and slacks in addition to balancing their costs with their real gains.

scholarly journals KAJIAN TATA LAYOUT DAN FASILITAS KERJA DOSEN TELKOM UNIVERSITY KASUS STUDI : RUANG KERJA DOSEN FIK TELKOM UNIVERSITY

2018 ◽  
Vol 3 (2) ◽  
pp. 77
Author(s):  
Doddy Friestya Asharsinyo
Keyword(s):  
Activity Patterns ◽  
Creative Industries ◽  
Creative Industry ◽  
Storage Space ◽  
Study Program ◽  
Work Activities ◽  
Working Space ◽  
And Performance ◽  
Scientific Fields

The quality and performance of lecturers apart from the quality of their education, are also obtained from the surrounding academic environment, which is related to the workspace environment in conducting Tridarma activities. The lecturer workspace is Tridarma's activities take place, it is also a space for lecturers to actualize themselves through their fields of expertise, science and works. The layout of the lecturers' workplaces related to scientific fields at the Faculty of Creative Industries differs from one another, due to the results of work activities, research carried out, and the resulting paperwork varies from dimension / size in the field of expertise / science. The standard of work space for lecturers in general is the same for all fields of science. This research method is carried out with a qualitative approach, starting by observing empirical facts about the working space of the lecturers in the Faculty of Creative Industries, and then explaining the existing conditions and analyzing in accordance with applicable standards. The results & findings of this study conclude that the activity patterns and layout in the Tel-U lecturer workspace at the Faculty of Creative Industry are associated with the field of knowledge of each study program have the same cubical pattern and facilities, with a centralized orientation circulation in the middle of the room, there is no no special work storage space.

scholarly journals Demand Side Simulaton: Architecture And Performance

2021 ◽  
Author(s):  
Jahanzeb Yousaf
Keyword(s):  
Distribution Systems ◽  
Database Management System ◽  
Demand Side ◽  
Simulation Engine ◽  
Agent Simulation ◽  
Utility Companies ◽  
Simulation Paradigm ◽  
Improved Performance ◽  
Complex Solutions ◽  
And Performance

In this thesis, we describe a simulator of residential power consumption, as the first step towards a comprehensive demand-side simulator in the context of smart grid. The si mulator uses a commercialRelational Database Management System (RDBMS) as its simulation engine, and is thus capable of supporting much larger simulated systems than other existing simulators which are mostly based on a multi-agent simulation paradigm. The RDBMS-based design also leads to much improved performance while requiring less resources than comparable MAS-based system. Moreover, simulator records all the events which exceed a certain threshold and in response controls demand and assures the stability of the system, based on the future and past events. furthermore, simulator can help utility companies to obtain initial data that can lead to the development of more complex solutions to monitor and control energy consumption, and thus identify target operating points for the generation and distribution systems, with the ultimate goal of balancing the demand and supply, and of improving energy efficiency at the utility level.

scholarly journals The relationship between inter-organizational trust and performance

2012 ◽  
Vol 60 (4) ◽  
pp. 89-98 ◽  
Author(s):  
Roman Fiala ◽  
Martin Prokop ◽  
Iva Živělová
Keyword(s):  
Structural Equation ◽  
Organizational Trust ◽  
Negative Relationship ◽  
Fit Indices ◽  
Supplier Performance ◽  
Significant Negative Relationship ◽  
Model Fit Indices ◽  
And Performance ◽  
Using Data ◽  
The Relationship

The article deals with an investigation of the relationship between inter-organizational trust and performance. Using data obtained in a questionnaire survey in 373 organizations with more than 20 employees with their seat in the Czech Republic, we found the relationship between inter-organizational trust and supplier performance, mediated by the level of conflict. Also, the statistically significant negative relationship between inter-organizational trust and costs of negotiation and the statistically significant positive relationship between supplier performance and perceived performance were confirmed. The hypothesis on the statistically significant relationship between inter-organizational trust and negotiating costs was not confirmed. The structural equation modelling technique was used in the calculations. The calculated model fit indices (CFI, NFI, NNFI) with values over 0.9 demonstrate a very good quality of the model.

Sign in / Sign up

Export Citation Format

Share Document