Multi-purpose adaptable business tier components based on Call Level Interfaces

Call Level Interfaces (CLI) play a key role in business tiers of relational and on some NoSQL database applications whenever a fine tune control between application tiers and the host databases is a key requirement. Unfortunately, in spite of this significant advantage, CLI are low level API, this way not addressing high level architectural requirements. Among the examples we emphasize two situations: a) the need to decouple or not to decouple the development process of business tiers from the development process of application tiers and b) the need to automatically adapt business tiers to new business and/or security needs at runtime. To tackle these CLI drawbacks, and simultaneously keep their advantages, this paper proposes an architecture relying on CLI from which multi-purpose business tiers components are built, herein referred to as Adaptable Business Tier Components (ABTC). Beyond the reference architecture, this paper presents a proof of concept based on Java and Java Database Connectivity (an example of CLI).

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.

ABTC: multi-purpose adaptable business tier components based on Call Level Interfaces

Call Level Interfaces (CLI) are low level API that play a key role in database applications whenever a fine tune control between application tiers and the host databases is a key requirement. Unfortunately, in spite of this significant advantage, CLI were not designed to address organizational requirements and contextual runtime requirements. Among the examples we emphasize the need to decouple or not to decouple the development process of business tiers from the development process of application tiers and also the need to automatically adapt to new business and/or security needs at runtime. To tackle these CLI drawbacks, and simultaneously keep their advantages, this paper proposes an architecture relying on CLI from which multi-purpose business tiers components are built, herein referred to as Adaptable Business Tier Components (ABTC). This paper presents the reference architecture for those components and a proof of concept based on Java and Java Database Connectivity (an example of CLI).

Definição dos padrões químicos e geológicos naturais do Paul de Arzila e da sua envolvente

A Reserva Natural do Paul de Arzila (Decreto Lei nº 219/88 de 27 de Junho) está integrada na Rede Europeia de Reservas Biogen ticas do Concelho da Europa desde 1990. A Reserva Natural do Paul de Arzila goza de um estatuto privilegiado pelo que o planeamento da área em questão está sujeito aos ditames do Concelho da Europa que garante o equilírio biológico e, consequentemente, a conservação da diversidade genética da Reserva. Impõe-se assim a necessidade de se proceder à definição dos padrões químicos e geológicos naturais não só da área da Reserva Natural do Paul de Arzila, mas também da sua envolvente. Inicialmente procedeu-se, a uma caracterização da área do Paul de Arzila referente à fisiografia, relevo, geologia, tectónica, unidades pedológicas e capacidade de uso do solo, recursos naturais, focos de poluição e seus impactos e caracterização sócio - económica. A caracterização geoquímica do Paul de Arzila foi estabelecida com base nos resultados das análises químicas efectuadas em amostras de solos, sedimentos de corrente e águas. Trata-se de um projecto que, a longo prazo, permitirá alargar a problemática da conservação ambiental e da diversidade gené tica das Reserva existentes ao nível do público local e nacional com a implementação de projectos de preservação e sensibilização ambiental.