IMPROVING THE PERFORMANCE OF DATABASE-CENTRIC APPLICATIONS THROUGH PROGRAM ANALYSIS

Modern software applications are becoming more dependent on database management systems (DBMSs). DBMSs are usually used as black boxes by software developers. For example, Object-Relational Mapping (ORM) is one of the most popular database abstraction approaches that developers use nowadays. Using ORM, objects in Object-Oriented languages are mapped to records in the database, and object manipulations are automatically translated to SQL queries. As a result of such conceptual abstraction, developers do not need deep knowledge of databases; however, all too often this abstraction leads to inefficient and incorrect database access code. Thus, this thesis proposes a series of approaches to improve the performance of database-centric software applications that are implemented using ORM. Our approaches focus on troubleshooting and detecting inefficient (i.e., performance problems) database accesses in the source code, and we rank the detected problems based on their severity. We first conduct an empirical study on the maintenance of ORM code in both open source and industrial applications. We find that ORM performance-related configurations are rarely tuned in practice, and there is a need for tools that can help improve/tune the performance of ORM-based applications. Thus, we propose approaches along two dimensions to help developers improve the performance of ORM-based applications: 1) helping developers write more performant ORM code; and 2) helping developers configure ORM configurations. To provide tooling support to developers, we first propose static analysis approaches to detect performance anti-patterns in the source code. We automatically rank the detected anti-pattern instances according to their performance impacts. Our study finds that by resolving the detected anti-patterns, the application performance can be improved by 34% on average. We then discuss our experience and lessons learned when integrating our anti-pattern detection tool into industrial practice. We hope our experience can help improve the industrial adoption of future research tools. However, as static analysis approaches are prone to false positives and lack runtime information, we also propose dynamic analysis approaches to further help developers improve the performance of their database access code. We propose automated approaches to detect redundant data access anti-patterns in the database access code, and our study finds that resolving such redundant data access anti-patterns can improve application performance by an average of 17%. Finally, we propose an automated approach to tune performance-related ORM configurations using both static and dynamic analysis. Our study shows that our approach can help improve application throughput by 27--138%. Through our case studies on real-world applications, we show that all of our proposed approaches can provide valuable support to developers and help improve application performance significantly.

Regulation and Social Media: Speed Bumps or the Code 2.0

“Governments of the Industrial World, you weary giants of flesh and steel, I come from Cyberspace, the new home of Mind. On behalf of the future, I ask you of the past to leave us alone. You are not welcome among us. You have no sovereignty where we gather (…)” (Barlow 1996). Barlow’s declaration of independence of February 8 1996 was an expression of the libertarian approaches that have run through the Internet since its inception, and is the root of the misapprehension that the internet is somehow unregulated by state sovereignty. But why was it published that day? What happened?

Design of information architecture of the web site of the Faculty of Industrial Engineering and Tourism of the Universidad Central “Marta Abreu” de Las Villas (Cuba)

The information architecture supports information retrieval by users in Web environment. The design should be center in the information user, favoring usability. The Faculty of Industrial Engineering and Tourism of the Universidad Central "Marta Abreu" de Las Villas, lacks a site that enhances the disclosure of information to its members. Are presented as objectives of the study: 1) conduct a user survey to identify information needs of users, 2) establish guidelines for information architecture for the institution focused on users, 3) designing the information architecture for the institution and 4) designed to evaluate the proposal. Are presented as objectives of the study: 1) to realize a user study to identify the information needs of users, 2) establish guidelines for information architecture for the institution focused on users, 3) to design the information architecture for the institution and 4) to evaluate the proposal designed. To obtain results are used methods in the theoretical and empirical levels. Besides, are use techniques that favored the design and evaluation. Is designed the intranet of the Faculty of Industrial Engineering and Tourism. Is evaluated the proposed design for the validation of the results.

Residence Time Distribution (Rtd) Associated with Statistical Weighted Moments to Fit Mathematical Models Using In Industrial Systems Diagnosis

This work presents a computational, called MOMENTS, code developed to be used in process control to determine a characteristic transfer function to industrial units when radiotracer techniques were been applied to study the unit´s performance. The methodology is based on the measuring the residence time distribution function (RTD) and calculate the first and second temporal moments of the tracer data obtained by two scintillators detectors NaI positioned to register a complete tracer movement inside the unit. Non linear regression technique has been used to fit various mathematical models and a statistical test was used to select the best result to the transfer function. Using the code MOMENTS, twelve different models can be used to fit a curve and calculate technical parameters to the unit.

Parallelisation of ESAUNA within EUROPORT-1: A structured/unstructured aeronautical CFD flow code

General-purpose parallel processing for solving day-to-day industrial problems has been slow to develop, partly because of the lack of suitable hardware from well-established, mainstream computer manufacturers and suitably parallelized application software. The parallelization of a CFD-(computational fluid dynamics) flow solution code is known as ESAUNA. This code is part of SAUNA, a large CFD suite aimed at computing the flow around very complex aircraft configurations including complete aircraft. A novel feature of the SAUNA suite is that it is designed to use either block-structured hexahedral grids, unstructured tetrahedral grids, or a hybrid combination of both grid types. ESAUNA is designed to solve the Euler equations or the Navier-Stokes equations, the latter in conjunction with various turbulence models. Two fundamental parallelization concepts are used—namely, grid partitioning and encapsulation of communications. Grid partitioning is applied to both block-structured grid modules and unstructured grid modules. ESAUNA can also be coupled with other simulation codes for multidisciplinary computations such as flow simulations around an aircraft coupled with flutter prediction for transient flight simulations.

Twenty years of the Foundation of the School of Library, Documentation and Information of the National University Intellectual Property in Costa Rica - The information technology environment

This year the School of Library, Documentation and Information is twenty years from its beginning as Unit Library.

Implicaciones tributarias en la determinación del impuesto a la renta como resultado de la revaluación de propiedad, planta y equipo en el sector industrial, en el cantón Cuenca a partir de la implementación de las NIIF en el Ecuador

En el Ecuador, a partir del año 2010, por resolución de la Superintendencia de Compañías, las compañías que se encuentran reguladas por este organismo, deben aplicar de manera obligatoria las Normas Internacionales de Información Financiera (NIIF), cuyo objetivo fundamental es que los Estados Financieros reflejen la realidad de la compañía y puedan ser comparables a nivel mundial, permitiendo una mayor competitividad y mejor toma de decisiones. La exención de la NIIF 1 permite optar en la fecha de transición a las NIIF por la medición de una partida de propiedad, planta y equipo por su Valor Razonable, y utilizar este valor como Costo Atribuido lo que implica contablemente un incremento en el valor tanto del activo como del patrimonio así como el reconocimiento de impuestos diferidos. Las NIIF no están diseñadas para realizar reportes impositivos por lo que la revaluación en los elementos de propiedad, planta y equipo generó implicaciones tributarias en la determinación del Impuesto a la Renta sobre todo en el sector industrial porque las compañías que pertenecen a este sector tienen en sus activos un valor significativo en propiedad, planta y equipo. El presente trabajo de investigación se lo realizó a través de un estudio de caso a una de las compañías objeto de estudio así como también a través de la aplicación de encuestas a las compañías que pertenecen al sector industrial del Cantón Cuenca y del análisis de la información que consta en la página de la Superintendencia de Compañías de dichas compañías.

Migration-related detention: A focus on the Italian context

Inspired by a community psychology ecological perspective, this chapter addresses migration-related detention as part of that set of practices implemented by the EU and the Schengen Area to ensure internal security by strengthening external borders control. In particular, it focuses on the Italian context. Starting from a historical overview of the Italian legal and policy framework on migration, a critical analysis of the rationale for migrant detention and deportation is developed, highlighting the business interests at stake. In this regard, the concept of immigration industrial complex is utilized, emphasizing its similarities with the military and prison industrial complexes. Finally, the case of an Italian migration-related detention center is illustrated. We argue for the use of ecological multilevel analysis to grasp the complexity of these sites of confinement, and shed light on the forces and interests that revolve around them. Alternatives are advocated based on freedom and justice for all.

Improving the Performance of Database-Centric Applications Through Program Analysis

Thesis (Ph.D, Computing) -- Queen's University, 2016-09-30 09:55:51.506

Code pattern analysis of object-oriented programming languages

Code patterns, including programming patterns and design patterns, are good references for programming language feature improvement and software re-engineering. However, to our knowledge, no existing research has attempted to detect code patterns based on code clone detection technology. In this study, we build upon the previous work and propose to detect and analyze code patterns from a collection of open source projects using NiPAT technology. Because design patterns are most closely associated with object-oriented languages, we choose Java and Python projects to conduct our study. The tool we use for detecting patterns is NiPAT, a pattern detecting tool originally developed for the TXL programming language based on the NiCad clone detector. We extend NiPAT for the Java and Python programming languages. Then, we try to identify all the patterns from the pattern report and classify them into several different categories. In the end of the study, we analyze all the patterns and compare the differences between Java and Python patterns.

Management Perspectives on Industrial Heritage: an Exploratory Research

The current research project focuses on the analysis of the critical issues of industrial heritage management in Italy and the preservation of organizational history within the reuse projects of former industrial sites. The organizational and managerial perspective is crucial on two levels. Firstly, it is important in the analysis of the original significance of the site, and in particular its organizational history, and its conservation within the new regeneration strategy. Secondly, it is crucial at the phase of management of reuse projects and its feasibility and sustainability analysis. Based on the analysis of the literature, a unique classification of the reuse strategies that can be implemented in order to regenerate former industrial sites has been formulated. The exploratory research thus adapts a multiple case study design. Eight Italian case studies have been chosen, one for each type of regeneration strategy. Each case study is explored as a stand-alone entity through the analysis of the local differences and idiosyncrasies of the specific context, the factors that stood behind the choice of the reuse strategy and the way the reuse project evolved through the years. Then, the current management of each reuse project is analysed. The narration and musealization of the organizational history is investigated through the spatial dimension, the level of content and the level of expression. Secondly, the case studies are compared through a cross-case analysis from three different perspectives: issues on the phase of preparation and implementation of the reuse projects, critical issues behind the current management of new projects and issues on the ways of preservation and narration of organizational history within the new project. The research shows that all regeneration strategies are affected by the conflict between preservation and change, by the issue of materiality and selectivity.

'Aedes sacrae' e 'edifici destinati all'esercizio pubblico del culto cattolico': la condizione giuridica delle chiese in Italia tra diritto canonico e ordinamento statale

Già ad uno sguardo esterno la normativa chiamata a disciplinare la condizione giuridica delle chiese cattoliche nel nostro Paese appare caratterizzata da un elevato grado di complessità: impressione che trova conferma sia con riferimento al diritto canonico, nella cui prospettiva le disposizioni appositamente dedicate ai 'loca sacra' dal Codex Iuris Canonici richiedono di essere affiancate dalle indicazioni provenienti – ai rispettivi, differenti livelli – tanto dalla Conferenza Episcopale Italiana quanto dai dicasteri della Curia romana; sia nell'ottica dell'ordinamento italiano, che agli 'edifici destinati all’esercizio pubblico del culto cattolico' riserva un'attenzione specifica, emergente nella legislazione unilaterale così come in quella pattizia. A fronte di una simile eterogeneità, sono d’altra parte note le problematiche che il tempo presente pone innanzi alle esigenze di una corretta amministrazione del patrimonio ecclesiastico – spesso pure dotato di un inestimabile valore storico-artistico –, le quali si riversano sulla preservazione stessa di tali immobili. Prendendo le mosse da questi presupposti, la trattazione si propone di effettuare una lettura sistematica delle diverse fasi in cui si articola il 'ciclo vitale' di un'ipotetica chiesa cattolica, così da ricostruire organicamente e criticamente quel quadro complessivo che permetta di formulare le soluzioni più appropriate per rispondere a questioni risalenti e sfide inedite. È quindi con questo intento che, una volta definito esattamente il concetto di chiesa-edificio, vengono ripercorsi i momenti in cui si sviluppa, anche giuridicamente, la sua esistenza: dalla pianificazione al finanziamento delle nuove costruzioni, con una speciale attenzione all'apporto che può essere offerto da parte della CEI; dagli utilizzi ammessi nel diritto canonico alle tutele garantite da parte statale; dalle misure di salvaguardia ai criteri per la loro adeguata gestione, comprendenti tanto i profili relativi alla conservazione quanto quelli riguardanti la valorizzazione; dalle implicazioni di un'eventuale riduzione a uso profano fino ai requisiti dettati per la nuova destinazione dell'immobile.

Sustainability and environmental impact of the Italian ceramic tile industry

The increasing consumption rates among citizens and the uncontrolled exploitation of natural resources have made environmental pollution and management of waste the main problems facing humanity in its upcoming future. Together with generation of energy and transport, industrial production certainly plays a key role in the genesis of these problems. It is for this reason that the concepts of environmental, social and economic sustainability have emerged over the years as the cornerstones for future development. In light of this, the most forward-looking industries have begun to study their impact on environment and society in order to improve their performances and, at the same time, to anticipate the increasingly rigorous environmental regulations. In this work, various performance indicators related to the Italian ceramic tile sector will be presented and discussed. In particular, the emission factor of characteristic pollutants will be reported on a period of up to fifteen years while data regarding waste management, concentration of pollutants and emission legal limits for the last decade will be here disclosed as a result of a vast analysis on recorded data. The collected information describes the present level of performance of the ceramic tile manufacturing industries in Italy and shows how recycling is now a consolidated reality and how some pollutants, such as particulate matter, fluorine and lead are actually disappearing from production processes and how others, such as volatile organic compounds, are increasing instead. Moreover, the adoption of alternative raw materials for the production of ceramic tiles is discussed and the implementation of the recycling of various waste is addressed at experimental or industrial scale. Finally, the development of a new ceramic engobe with high content of waste glass (20%) is presented as an experimental example of reutilization of resources in the ceramic tile industry.

Modeling and Model Predictive Control of an Industrial Hydraulic System

This thesis aims to illustrate the construction of a mathematical model of a hydraulic system, oriented to the design of a model predictive control (MPC) algorithm. The modeling procedure starts with the basic formulation of a piston-servovalve system. The latter is a complex non linear system with some unknown and not measurable effects that constitute a challenging problem for the modeling procedure. The first level of approximation for system parameters is obtained basing on datasheet informations, provided workbench tests and other data from the company. Then, to validate and refine the model, open-loop simulations have been made for data matching with the characteristics obtained from real acquisitions. The final developed set of ODEs captures all the main peculiarities of the system despite some characteristics due to highly varying and unknown hydraulic effects, like the unmodeled resistive elements of the pipes. After an accurate analysis, since the model presents many internal complexities, a simplified version is presented. The latter is used to linearize and discretize correctly the non linear model. Basing on that, a MPC algorithm for reference tracking with linear constraints is implemented. The results obtained show the potential of MPC in this kind of industrial applications, thus a high quality tracking performances while satisfying state and input constraints. The increased robustness and flexibility are evident with respect to the standard control techniques, such as PID controllers, adopted for these systems. The simulations for model validation and the controlled system have been carried out in a Python code environment.