Analysis of EEC Regulation 2092/91 in relation to other national and international organic standards

This Deliverable 3.2 report presents an analysis of differences between EEC Regulation 2092/91 and other organic standards and their implementation, using a specially developed database (www.organicrules.org). It further reports on database development. The work was carried out as part of the “EEC 2092/91 (Organic) Revision” STREP project (No. SSPE-CT- 2004-502397) within the EU 6th Framework Programme. The main objective was to identify differences in organic standards in relation to Regulation (EEC) 2092/91 and to analyse selected national governmental and private organic standards with the aim of identifying specific areas in the (EEC) 2092/91 where revision in terms of harmonisation, regionalisation or simplification may be possible

Algebraic optimization of recursive queries

Over the past few years, much attention has been paid to deductive databases. They offer a logic-based interface, and allow formulation of complex recursive queries. However, they do not offer appropriate update facilities, and do not support existing applications. To overcome these problems an SQL-like interface is required besides a logic-based interface.\ud \ud In the PRISMA project we have developed a tightly-coupled distributed database, on a multiprocessor machine, with two user interfaces: SQL and PRISMAlog. Query optimization is localized in one component: the relational query optimizer. Therefore, we have defined an eXtended Relational Algebra that allows recursive query formulation and can also be used for expressing executable schedules, and we have developed algebraic optimization strategies for recursive queries. In this paper we describe an optimization strategy that rewrites regular (in the context of formal grammars) mutually recursive queries into standard Relational Algebra and transitive closure operations. We also describe how to push selections into the resulting transitive closure operations.\ud \ud The reason we focus on algebraic optimization is that, in our opinion, the new generation of advanced database systems will be built starting from existing state-of-the-art relational technology, instead of building a completely new class of systems

A Survey on IT-Techniques for a Dynamic Emergency Management in Large Infrastructures

This deliverable is a survey on the IT techniques that are relevant to the three use cases of the project EMILI. It describes the state-of-the-art in four complementary IT areas: Data cleansing, supervisory control and data acquisition, wireless sensor networks and complex event processing. Even though the deliverable’s authors have tried to avoid a too technical language and have tried to explain every concept referred to, the deliverable might seem rather technical to readers so far little familiar with the techniques it describes

CERTCOST News

The EU research project, CERTCOST, has issued the first digital CERTCOST newsletter. Despite the fact that organic certification and its costs might be a somewhat dry subject from a consumer’s point of view, we intend to present the results in a eatable manner. The International Center for Research in Organic Food Systems, ICROFS, is responsible for dissemination of the CERTCOST project

Final project report: EEC 2092/91 (ORGANIC) Revision

This report summarises the findings of the project that have been presented in a number of separate reports and publications. In the Chapters 2 to 5 the approach, results and conclusions of the project are summarised, following the structure of the different work packages. Chapter 2 summarises the work on ethical values of organic agriculture. Chapter 3 looks at the differences in the implementation of Regulation (EEC) 2092/91 across Europe and compares the European Regulation with international standards. Chapters 4 and 5 summarise the findings that relate to reducing the dependency on non-organic inputs in the case of feed and seed. The final Chapter 6 consolidates the recommendations of the whole project arising from the various different work packages in one place. Recommendations are aimed in particular at the second stage of the ongoing revision process of the European Regulation, the transfer of the detailed rules from the Annexes of the Regulation (EEC) 2092/91 that is expected to start after the completion of the project. Further recommendations for standard setting bodies, regulators and research recommendations are also presented. The overall objective of the project was to provide recommendations for the revision and further development of the Regulation (EEC) 2092/91 and other standards for organic agriculture, broken down into a number of specific objectives that resulted in 12 seperate reports. The basic ethical values and value differences of organic agriculture in Europe was identified through stakeholder consultation (D 2.1) and through literature as part of developing a procedure for balancing and integrating the basic values in developments of EU regulation (D 2.3). Organic standards from national and private organisations in Europe were compared with the EU regulation with help of database (www.organicrules.org) and differences were analysed to give recommendations on further harmonisation of the EU regulation (D 3.2). The knowledge on how to achieve 100 % organic rations in diets for livestock was expanded through a meta-analysis of literature and an overview of the current situation to characterise the availability of protein sources for 100% organic diets for pigs and poultry was produced (D 4.1 part 1 and 2). Criteria for use of organic inputs, evaluation criteria for Annex II C: Feed materials and Annex II D: Dietary supplements of Regulation (EEC) 2092/91 were developed (D. 4.2). A guide for operators was developed (D 4.3). The knowledge on how to reduce the use of non-organic seed and vegetative propagation materials was improved through reports on seed borne diseases in organic seed and propagation material (D 5.1), on the importance of quality characterising in organic seed and propagation material (D 5.2) and analysis of national derogation regimes (D 5.3). The project produced 12 reports, 7 scientific publications in peer-reviewed journals, and a project web-page at www.organic-revision.org where all reports and further documents are available. It organised 3 workshops with stakeholders and had ongoing communication with the Unit on Organic Farming in DG Agriculture responsible for the Organic Regulation. Members of the team produced in total more than 250 dissemination items

Využití asociačních pravidel při analýze alarmových trendů

This article deals with acquired alarm logs analyses, the alarm logs from control systems, and explains the reasons for its collecting and implication of the analyses. Several existing platform solutions can be used to analyze the alarms from the historical trends, and solutions, which offer the filtering of events based on time units to obtain the data about the maximum and average number of logs. This paper contributes to this area by developing a graphical interface for a system that makes it possible to use the analysis by association rules and brings the possibility of detecting frequent and repeating patterns in acquired alarm data files.Tento článek se zabývá sběrem a analýzami alarmových logů, alarmových hlášení z řídicích systémů, a vysvětluje důvody pro jejich sběr a důsledky analýz. Několik stávajících řešení na softwarových platformách může být k analýze alarmů použito z ukládaných historických trendů a řešení, která nabízejí filtrování událostí na základě časových období a údajů o maximálním a průměrném počtu logů. Tento příspěvek přispívá k této oblasti vytvořením grafického rozhraní pro systém, který umožňuje použití analýzy pomocí asociačních pravidel a přináší možnost detekce častých a opakujících se vzorů v získaných datových souborech s alarmy

Reactive Rules for Emergency Management

The goal of the following survey on Event-Condition-Action (ECA) Rules is to come to a common understanding and intuition on this topic within EMILI. Thus it does not give an academic overview on Event-Condition-Action Rules which would be valuable for computer scientists only. Instead the survey tries to introduce Event-Condition-Action Rules and their use for emergency management based on real-life examples from the use-cases identified in Deliverable 3.1. In this way we hope to address both, computer scientists and security experts, by showing how the Event-Condition-Action Rule technology can help to solve security issues in emergency management. The survey incorporates information from other work packages, particularly from Deliverable D3.1 and its Annexes, D4.1, D2.1 and D6.2 wherever possible