Endowing NoSQL DBMS with SQL features through standard Call Level Interfaces

To store, update and retrieve data from database management systems (DBMS), software architects use tools, like call-level interfaces (CLI), which provide standard functionalities to interact with DBMS. However, the emerging of NoSQL paradigm, and particularly new NoSQL DBMS providers, lead to situations where some of the standard functionalities provided by CLI are not supported, very often due to their distance from the relational model or due to design constraints. As such, when a system architect needs to evolve, namely from a relational DBMS to a NoSQL DBMS, he must overcome the difficulties conveyed by the features not provided by NoSQL DBMS. Choosing the wrong NoSQL DBMS risks major issues with components requesting non-supported features. This paper focuses on how to deploy features that are not so commonly supported by NoSQL DBMS (like Stored Procedures, Transactions, Save Points and interactions with local memory structures) by implementing them in standard CLI.

Secure, dynamic and distributed access control stack for database applications

In database applications, access control security layers are mostly developed from tools provided by vendors of database management systems and deployed in the same servers containing the data to be protected. This solution conveys several drawbacks. Among them we emphasize: 1) if policies are complex, their enforcement can lead to performance decay of database servers; 2) when modifications in the established policies implies modifications in the business logic (usually deployed at the client-side), there is no other possibility than modify the business logic in advance and, finally, 3) malicious users can issue CRUD expressions systematically against the DBMS expecting to identify any security gap. In order to overcome these drawbacks, in this paper we propose an access control stack characterized by: most of the mechanisms are deployed at the client-side; whenever security policies evolve, the security mechanisms are automatically updated at runtime and, finally, client-side applications do not handle CRUD expressions directly. We also present an implementation of the proposed stack to prove its feasibility. This paper presents a new approach to enforce access control in database applications, this way expecting to contribute positively to the state of the art in the field.

Secure, dynamic and distributed access control stack for database applications

In database applications, access control security layers are mostly developed from tools provided by vendors of database management systems and deployed in the same servers containing the data to be protected. This solution conveys several drawbacks. Among them we emphasize: (1) if policies are complex, their enforcement can lead to performance decay of database servers; (2) when modifications in the established policies implies modifications in the business logic (usually deployed at the client-side), there is no other possibility than modify the business logic in advance and, finally, 3) malicious users can issue CRUD expressions systematically against the DBMS expecting to identify any security gap. In order to overcome these drawbacks, in this paper we propose an access control stack characterized by: most of the mechanisms are deployed at the client-side; whenever security policies evolve, the security mechanisms are automatically updated at runtime and, finally, client-side applications do not handle CRUD expressions directly. We also present an implementation of the proposed stack to prove its feasibility. This paper presents a new approach to enforce access control in database applications, this way expecting to contribute positively to the state of the art in the field.

Fault tolerance logging-based model for deterministic systems

Fault tolerance allows a system to remain operational to some degree when some of its components fail. One of the most common fault tolerance mechanisms consists on logging the system state periodically, and recovering the system to a consistent state in the event of a failure. This paper describes a general fault tolerance logging-based mechanism, which can be layered over deterministic systems. Our proposal describes how a logging mechanism can recover the underlying system to a consistent state, even if an action or set of actions were interrupted mid-way, due to a server crash. We also propose different methods of storing the logging information, and describe how to deploy a fault tolerant master-slave cluster for information replication. We adapt our model to a previously proposed framework, which provided common relational features, like transactions with atomic, consistent, isolated and durable properties, to NoSQL database management systems.

Ecology and physical condition of red deer in the Iberian Peninsula: implications for management

The red deer (Cervus elaphus) is currently one of the most widespread and abundant wild ungulates in the Iberian Peninsula and is extremely important both ecologically, as a key species for the functioning of the ecosystems, and economically, as a major game species. In Iberia, red deer populations are subjected to different management systems that may affect the physical condition of the individuals, with further consequences for population dynamics. Studies investigating the effects of management practices and environmental conditions on the performance of red deer are still rare regarding Mediterranean ecosystems. Much of the knowledge concerning the ecology of red deer and the impact of management on its physical condition is based on studies conducted in northern and central regions of Europe, where climatological features and management practices differ from those observed in the Mediterranean areas of Iberia. Studies on a biogeographical scale can provide important insights into the relationships between species and a particular environment and contribute to the development of more targeted and appropriate management practices. The optimisation of sampling procedures and the fine-tuning of pre-existing analytical techniques are also fundamental to a more cost-effective monitoring and, therefore, are of enormous value to wildlife managers. In this context, the main aims of this thesis were: 1) to optimise the procedures used to assess the physical condition of red deer; and 2) to identify relevant management and environmental factors affecting the nutritional condition and stress physiology of red deer in the Mediterranean ecosystems of Iberia, as well as any potential interactions between those factors. Two studies with a methodological focus, presented in the first part of the thesis, demonstrated that the physical condition of red deer can be evaluated more simply, using more cost- and time-effective procedures than those traditionally used: i) it was shown that only one kidney and its associated fat is enough to assess nutritional condition in red deer; and ii) the feasibility of using near infrared spectroscopy to predict the concentrations of stress hormone metabolites was demonstrated using faeces of red deer for the first time. Subsequently, two large-scale observational studies, conducted in representative red deer populations found in Mediterranean Iberia, highlighted the importance of considering seasonal environmental variations and variables related to hunting management practices to better understand the nutritional and physiological ecology of red deer. High population densities had adverse effects on the nutritional condition of the deer and were associated with increased stress levels in natural populations without supplementary feeding. Massive hunting events involving the use of hounds were also identified as a potential source of chronic stress in red deer. The research presented in this thesis has clear implications regarding the management and monitoring of red deer populations in Mediterranean environments and is intended to help wildlife managers to implement more effective monitoring programmes and sustainable management practices.