Requirement analyses and a database model for the project egerfood food safety knowledge center
This presentation is the property of its rightful owner.
Sponsored Links
1 / 24

Requirement Analyses and a Database Model for the Project : EGERFOOD Food Safety Knowledge Center PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

Requirement Analyses and a Database Model for the Project : EGERFOOD Food Safety Knowledge Center. Tibor Radványi Gábor Kusper Eszterházy Károly College. Outline. Motivation Background: Regional Knowledge Centers The EgerFood Project: Food Safety Knowledge Center

Download Presentation

Requirement Analyses and a Database Model for the Project : EGERFOOD Food Safety Knowledge Center

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Requirement analyses and a database model for the project egerfood food safety knowledge center

Requirement Analyses and a Database Model for the Project:EGERFOODFood Safety Knowledge Center

Tibor RadványiGábor KusperEszterházy Károly College


Outline

Outline

  • Motivation

  • Background:

    • Regional Knowledge Centers

    • The EgerFood Project:Food Safety Knowledge Center

    • R+D (Research and Development)

  • Requirements

  • a Database Model


Motivation

Motivation

  • To Build an Information System

    • Which is Working

    • Which is a Real One

  • Use techniques known from teaching

  • Compare practical and theoretical Information System Development

  • It is a big challenge!


Background

Background

  • Regional Knowledge Centers

    • In North-Hungary

      • ’05, Eszterhazy Karoly College: Food Safety

      • ’04, University of Miskolc: Logistics

  • Egerfood:Consumer focused complex food tracking systems, new food safety parameters and tools witha novel info-communication system


The consortium

The Consortium

  • Eszterhazy Karoly College + Research Lab

  • SzinvaNET Kft.

  • 1., Hesi Rt.

  • 2., Egri Bormímes Kft.

  • 3., Detki Keksz Kft.

  • 4., Fish and Food Kft.

  • 5., Quality Champignons Kft.

  • 6., Pásztor-Hús Kft.

  • Merchantmen Chamber of District Heves


The analyzed products

The analyzed products:

  • Egri Bikavér wine,

  • Detki household biscuit,

  • Chilled fresh strudel-sheet,

  • Tóth pungent sausage,

  • Csiperke canned mushroom,

  • Canned fish.


1 task requirement analyses

1. Task: Requirement Analyses

  • We have gathered information about the products and about the procedure of the production

  • First round: Questionnaire

  • Second round: Personal meetings

  • Some questions:

    • Which parameters are measured, How?

    • How are the products identified?


Requirements

Requirements

  • Use existing hardware

  • Easy to adopt

  • Collected data must be transferred encrypted

  • Be able to serve quickly and cost effectively the costumers

  • Be able to query old data to see the trends


A consequent of the requirements

A consequent of the requirements

  • There must be a central data warehouse, which has to:

    • store the data,

    • serve the queries of the displaying modules (Web, WAP, fat clients).


The goal of the it system

The Goal of the IT System

Sending information in a fast, cost effective, and reliable way to the

Costumers

Effected authorities

Food producers


2 task functional specification

2. Task: Functional Specification

  • At the moment we are now at stage

  • Done:

    • Data transmission model

    • The database model of the food tracking database

  • ToDo:

    • Select a cryptography algorithm

    • Develop the protocol of data transmission

    • Develop a product identification code system

    • Specify the GUIs


Data transmission

Data Transmission

Safe & Encrypted

Data redundancy

Cryptography


Transmission model 3 tire storage

Transmission model: 3-Tire Storage

A Food Safety System


Risk of data loss is minimized

Risk of data-loss is minimized

  • How we save data in the 3-Tire Storage:

    • The PCs at the data source save the data immediately after it is inserted.

    • The Buffer Servers save the data before sending it.

    • The Central Data Warehouse saves the data as it receives it.

  • This data redundancy guarantees the data safety!

  • We have a lots of redundant data. Therefore, we have to make an archive time to time at all the 3 levels. Therefore, we need a suitable archive making policy. This is not done yet.


Question about the database

Question about the database

  • What is the best solution?:

  • To create a database model which can store any important data (regarding food safety) of any considered products (or possibly later introduced).

    OR

  • To make a specialized database model for each considered products and take the union of them.

A Food Safety System


The pencil notebook solution

The Pencil & Notebook solution

  • At 6 (out of 6) food producer companies they use pencil and notebook to store measured parameters.

  • They use worksheets.

  • Is this solution good enough? Competitors may use even ERP systems!


The universal solution

The universal solution

  • It seems that the Pencil & Notebook solution is universal.

  • Can be used to store the measured parameters of any

    • Product and

    • Production process.

  • Idea: Use this universal solution, but on a computer.


Data model

Data Model


Companies

Companies

  • Company: basic information about the company, meanly to display for the users.

  • Products: basic product information. A company may have more products.


Attributes

Attributes

  • Attribute: describes a parameter, which is measured during the production.

  • Attribute_Type: the unit of the parameter, this information is needed for data conversion.


Requirement analyses and a database model for the project egerfood food safety knowledge center

Logs

  • Log: data of a work-period.

  • Log_Row: the unit of data insertion.Example: Mary Smith on 15.12.2006 in the 2nd work-period in the 10th tent harvested 3 kg of mushroom.

  • Row_Element: stores the elementary data. Any elementary data should have an attribute.


Example

Example

  • Mary Smith on 15.12.2006 in the 2nd work-period in the 10th tent harvested 3 kg of mushroom.


Conclusion

Conclusion

  • We have created a robust data transformation model which minimize the risk of data-loss.

  • We have created a data model based on the Pencil & Notebook solution.

    • Advantages:

      • Employee can adopt easily to it.

      • Easier application development.

    • Disadvantages:

      • Data conversion cannot be done automatically.


Requirement analyses and a database model for the project egerfood food safety knowledge center

Thank you for your attention!

Tibor Radványi

[email protected]

Gábor Kusper

[email protected]


  • Login