EASTIN Central Server - ATIS4all

flashypumpkincenterSoftware and s/w Development

Dec 14, 2013 (3 years and 8 months ago)

143 views




Assistive Technologies and Inclusive
Solutions for All





















D
1
.
6
.
Technical analysis of existing EASTIN portal


Project Acronym

ATIS4all

Grant Agreement Number

CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

Project Title

Assistive Technologies and Inclusive Solutions for All


Deliverable No.

D
1
.
6

Work package No.

WP1

Work package Title

Foundations of ATIS4all

Authors

Carlos de la Cruz

(Technosite)

Status

Final

Dissemination Level

Consortium

(Confidential)

Delivery Date

0
6
/
30
/2011

Number of Pages

41






i

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4

Project 270988

www.atis4all.eu



Version History

Revision

Date

Author

Organisation

Description

1

0
5
/
23
/
2011

Carlos de la Cruz

Technosite

First draft

2

05/24
/
2011

Elena Gómez

Technosite

First revision

3

05/27/2011

Andrea Agnoletto

Fondazione Don
Gnocchi

(ETNA thematic
network)

Second revision

4

06/30/2011

Elena Gómez

Technosite

Final
version








ii

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4

Project 270988

www.atis4all.eu



Table of contents

1

INTRODUCTION

................................
................................
................................
..........

4

2

ARCHITECTURE AND TECHNOLOGICAL ENVIRONMENT

................................
..................

5

2.1

EASTIN Central Server

................................
................................
...........................

5

2.2

Multilanguage support

................................
................................
...........................

5

3

EASTIN CENTRAL SERVER

................................
................................
............................

7

3.1

In
troduction

................................
................................
................................
..........

7

3.2

Page Hierarchy and Sitemap

................................
................................
...................

7

3.3

Search Engine

................................
................................
................................
.......

8

3.3.1

Overvi
ew

................................
................................
................................
.........

8

3.3.2

Search Engine Custom Data Types
................................
................................
...

10

3.3.3

Search Engine Web Services

................................
................................
...........

12

3.3.4

Search Engine Web Services


Batch methods

................................
..................

13

3.3.5

Search Engine Web Services


Live methods

................................
....................

15

3.3.6

Assistive Technology Product Search Section

................................
....................

18

3.3.7

Companies Search Section

................................
................................
..............

26

3.3.8

Associated Information Search Section

................................
.............................

28

3.4

Web forms

................................
................................
................................
..........

29

3.4.1

Submit a product
................................
................................
............................

29

3.4.2

Info request

................................
................................
................................
...

30

3.5

Restricted area

................................
................................
................................
....

31

3.5.1

Accessing the restricted area

................................
................................
...........

31

3.5.2

E
-
mails Section

................................
................................
..............................

32

3.5.3

Attachments Section

................................
................................
.......................

32

3.5.4

Official documents Section

................................
................................
..............

33

4

DATABASE DIAGRAMS

................................
................................
...............................

34

4.1

Overview and Diagram

................................
................................
.........................

34

4.2

Table descriptions

................................
................................
...............................

34

4.2.1

ISO Classification Tables

................................
................................
.................

34

4.2.2

Users Tables

................................
................................
................................
..

35

4.2.3

Email Tables

................................
................................
................................
..

36

4.2.4

Keywords Tables

................................
................................
............................

36





iii

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4

Project 270988

www.atis4all.eu



4.2.5

Labels Tables

................................
................................
................................
.

37

4.2.6

Pr
oduct Submission Tables

................................
................................
..............

38

5

CONCLUSIONS

................................
................................
................................
..........

39

6

REFERENCES

................................
................................
................................
.............

40


List of Figures

Figure 1 Search by ISO code.

................................
................................
............................

19

Figure 2 Search by ISO code results

................................
................................
..................

20

Figure 3 Product’s details page.

................................
................................
.........................

22

Figure 4 Search by keyword

................................
................................
..............................

22

Figure 5 Search by commercial name

................................
................................
.................

23

Figure 6 Search by manufacturer name

................................
................................
..............

23

Figure 7 Search by
insert date

................................
................................
...........................

24

Figure 8 Advanced search

................................
................................
................................
.

25

Figure 9 Companies search section.

................................
................................
...................

27

Figure 10 Company details.

................................
................................
...............................

28

Figure 11 Information request

................................
................................
...........................

31

Figure 12 Restricted area access form.

................................
................................
...............

32

Figure 13 Complete database

................................
................................
............................

34

Figure 14 ISO Classification tables

................................
................................
.....................

35

Figure 15 Users tables

................................
................................
................................
......

36

Figure 16 Email tables.

................................
................................
................................
.....

36

Figure 17 Keywords tables.

................................
................................
...............................

37

Figure 18 Labels tables.

................................
................................
................................
....

37

Figu
re 19 Product Submission tables.

................................
................................
.................

38




4

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



1

INTRODUCTION

The EASTIN Association was founded on December 13, 2006 on the initiative of four
Organisations that

had been previously partners in the EASTIN project (2004
-
2005), a
market validation initiative partially funded by the European Commission through the eTEN
programme.

The four founding members are
Fondazione Don Carlo Gnocchi Onlus

(Italy),
Institut der
d
eutschen Wirtschaft Köln

(Germany), Disabled Living Foundation (United
Kingdom
) and
Danish Centre on Assistive Technology (Denmark). Later other partners
, called National
Contacts,

joined

are

Hacavie (France) and the Flemish Disability Agency (Belgium)
, wh
ich
provide a response
-
to
-
information
-
request service and site content management inside
Eastin, but haven’t got their own databases
. The EASTIN Association also involves one
liaison partner (CEAPAT, Spain) and several Organizations acting as National Con
tacts in
other Countries of the European Union.

The main mission of the EASTIN Association is to maintain, develop and exploit the EASTIN
network, composed of the EASTIN website and all partner’s databases on assistive
technology.

Using the web interface o
f the EASTIN website, users can search information about assistive
technologies on every partner’s local databases. T
his

document

details the

functionality

of
the EASTIN website
,
including

the

way these combined searches are performed
.






5

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



2

ARCHITECTURE AND
TECHNOLOGICAL ENVIRONMENT

The EASTIN network is composed of two different environments:


Partner’s Local Databases
.

Some of the EASTIN partners
its own local
database about assistive technologies. Each local database and webpage is
maintained independently
by its owner, while the EASTIN Central Server uses
web services to access the information stored in them.


EASTIN Central Server
. Users can make join queries about assistive
technologies on the local databases from the EASTIN Central server.

Both
environments are maintained independently. The EASTIN Central Server receives data
from the local databases by making remote calls using web services. The data is received as
SOAP objects (Simple Objects Access Protocol).


2.1

EASTIN Central Server

The EASTIN
Central Server architecture is presented below:


Operating System
. Microsoft Windows Server 2003 Web Edition SP2 in
English.


Web Server
. Microsoft Internet Information Services 6.0.


Programming Language
. VisualBasic.NET.


Web Application Framework
. ASP.NET 1
.1 Web Forms.


Database
. Microsoft SQL Server 2
000
.


2.2

Multilanguage support

Every EASTIN Central Server page is available in the following languages:


EASTIN
founding p
artners and liaison
p
artners
languages:
Danish, Dutch,
English, French, German, Italian and

Spanish
.


EASTIN
National Contact Partners languages
:

o

Bulgarian, Czech, Estonian, Finnish, Greek, Hungarian, Latvian, Lithuanian,
Maltese, Polish, Portuguese, Romanian, Slovak, Slovene and Swedish.

When users access to the EASTIN homepage they are
presented with a list of languages.
Once they choose one of them, a parameter is added to the URL and the webpages are then
presented in that language.

When the user makes a search, the EASTIN Central Server keeps the information received in
the language t
he user has selected if available. Otherwise, the system

shows the English
content.





6

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



Accessibility

The Website is designed so that all the contents are accessible to the largest possible
number of users. The accessibility policy of this Website is based on

the World Wide Web
Consortium (W3C) accessibility recommendations defined within the framework of the Web
Accessibility Initiative (WAI).

All the pages on this Website comply with the following requirements:


W3C XHTML 1.0 Strict


W3C CSS 2


WAI
-
AA WCAG 1.
0







7

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



3

EASTIN CENTRAL SERVER

3.1

Introduction

The public webpage is composed by:


A group of information pages about the project and the association’s partners.


The webpage’s most important section is a group of searching options about
assistive technology
products, companies and associated information.


A web form to submit a product. This sections is intended for manufacturers
who can’t find their product in the EASTIN network and wish to have it included


A web form to send a question to one of the EASTIN p
artners.


3.2

Page Hierarchy and Sitemap

This

section

details

the

pages

that

form

the

web

application
.

In the

navigation

tree root

is

the

home page

of the

application.

This

page

shows

a

list

of
twenty

two

links

that

allow you

to select

the language

in

which to

navigate the

application
.
Also
, there is list of
logos

that

will work

as links

to

each of the

founding and liason
partner’s
websites about assistive technologies
.

From the language selection page onwards, the navigation tree is explained below (the first
page loaded is “0. Searches”):


0. Searches.

o

Assistive Technology Products
. Assistive Technology Products Searcher.

o

Companies
. Companies Searcher.

o

Associated Information
. Associated Information Searcher.


1. What is EASTIN
. Information page.


2. Submit a pro
duct
. Webform to submit a product not presented in the
searches.


3. Info request
. Webform to send a question to one of the EASTIN partners.


4. History.

o

Mission / vision
. Information page.

o

Technology
. Information page.

o

Development
. Information page.


5. The
EASTIN partners. Information page.


6. General info
. Information page.


7. Restricted Area
. Webform to access to the restricted area (user and
password are required).




8

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

E
-
mails
. A list of emails sent to the project distribution list.

o

Attachments
. A list of
files sent to the project distribution list.

o

Official documents
. A list of official documents
(doc, pdf)
used by the
administrators.


8. Disclaimer
. Information page.


9. Accessibility
. Information page.

o

Rehadat
. Link to the German national database
named
Re
hadat
1
.

o

Hjælpemiddelbasen
.

Link to the Danish national database
named
Hjælpemiddelbasen
2
.

o

Dlf data
.

Link to the UK’s national database
named
Dlf Data
3
.

o

Catalogo
.

Link to the Spanish national database
named
Catálogo de Ayudas
Técnicas
4
.

o

Siva
.

Link to the Italian national database

named
Portale Siva
5
.

o

Handicat
.

Link t
o the French national database named
Handicat
6
.

o

Vlibank
.
Link
to the Dutch national database named
Vlibank
7
.

At the top of each page there are a link to the application homepage an
d a list of links to
every EASTIN partner’s local webpage.


3.3

Search Engine

3.3.1

Overview

The Search Engine is the most important section of the web. Its objective is to give users a
way to access the information about assistive technologies stored at the local databases.

There are three types of elements the users can search for:


Assistive Te
chnology Products
. This is the most important search. These are
the
products

that

people

with

disabilities

can

use

to

facilitate

their

activities.
Products are classified by an ISO product
classification defined by the ISO
9999:2007 standard, no matter the

local database. The products are defined by
the following fields:

o

Commercial Name.




1

http://www.rehadat.de/rehadat/

2

http://www.hmi
-
basen.dk/r0x.asp?ldbid=1

3

http://dlfdata2010.dlf.org.uk/

4

http://www.catalogo
-
ceapat.org/

5

http://portale.siva.it/

6

http://www.handicat.com/

7

http://www.vlibank.be/




9

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

Manufacturer.

o

ISO Classification.

o

Last Update.

o

Local Database.

o

Image.

o

Description.

o

Original Document URL.

o

Insert Date


Companies
. These are the companies that create and
supply the assistive
technologies products. The information about the companies are defined by the
following fields:

o

Name.

o

Address.

o

Country.

o

Phone.

o

Fax.

o

Website.

o

E
-
Mail.

o

Original Document URL.


Associated Information
. Documents concerning assistive
technologies
products, but not the products themselves. The fields defining these documents
are:

o

Type: There are five types:



Fact Sheets.



FAQs.



Case Studies.



Ideas.



Links.

o

Title in English.

o

Original Title.

o

Original Document URL.

o

Classification.

o

Descriptio
n.

o

Last Update.

o

Local Database.

Both assistive technology products and associated information documents are grouped
following the ISO product classification defined by the ISO 9999:2007
(ISO, 2007)

standard.



10

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



User searches can be
made browsing the ISO categories tree or by making direct searches
on the “Commercial name”, “Manufacturer’s name” or “Insert date” fields.

The main information about products, companies and associated information is not stored in
the EASTIN Central Server

database but in each partner’s local database. Anyway, some
data is stored locally by the EASTIN Central Server:


ISO Class description
. The code number, name and description of each ISO
class are stored locally to show it in the result pages. To obtain ne
w or updated
information about ISO classes, the system executes periodically the
“GetIsoClassInformation” method, described below.


Number of products of each ISO Class
. When the user is browsing the ISO
Class tree, each ISO Class shows the total number of
products associated to the
class. To calculate this number, a combined search in all local databases must
be performed, but these searches can increase the load time of each page and
overload the system. The solution is to execute periodically the
“GetIsoC
lassAidsNumber” method described below for each ISO Code, and store
the result in the EASTIN Central Server database.


Keywords and associated ISO Codes
. One of the searches uses predefined
keywords associated with one or more ISO Codes. The association bet
ween ISO
Codes and keywords is made by the “GetKeyWordList” method described below.
This procedure is ran periodically to update the information stored in the
EASTIN Central Server database.


3.3.2

Search Engine Custom Data Types

In order to receive the data fro
m the EASTIN partners’ databases, the EASTIN Portal Web
uses web services which return basic SOAP, such as String, Int and DateTime, but also
custom defined types. A complete description of EASTIN custom defined types follows
below:


IsoClass
. Used to store

the description of one ISO code.

o

String
Name
. The name of the ISO class.

o

String
Extended_Description
. The ISO class description.


KeyWordHash
. Used to store the association between a keyword and one or
more ISO codes.

o

String
KeyWordHash_Id
. The ID of the k
eyword in EASTIN partner’s local
database.

o

String
KeyWord
. The keyword.

o

String[]
IsoCode_Array
. The array of all ISO classification codes associated
to the keyword (for example [“12.22”, “09.03.03”]).




11

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




SmallAid
. Used to store resumed information about an
assistive technology
element.

o

String
Aid_Id
. The ID of the assistive device in EASTIN partner’s local
database.

o

String[]
IsoCode_Array
. The array of all ISO classification codes to whom
the assistive device belongs (for example [“12.22”, “09.03.03”]).

o

Stri
ng
Commercial_Name
. The commercial name of the assistive device.

o

String
Manufacturer
. The manufacturer of the assistive device.

o

DateTime
First_Entry_Date
. The date on which the assistive device was
inserted into EASTIN partner’s local database.

o

DateTime
La
st_Update_Date
. The date of the last update of the assistive
device in EASTIN partner’s local database.

o

String
Miniature_Picture_Url
. The URL of the small format picture of the
assistive device (used when displaying list of assistive devices in EASTIN
Port
al). The URL must be accessible on the Web by the end user’s browser.


Aid
. Used to store additional information about an assistive technology element.

o

String
Native_Record_Url
. The URL of the Web page on the original
EASTIN Partner’s web site in which the

assistive device is presented. The URL
must be accessible on the Web by the end user’s browser.

o

Boolean
Is_Public
. True if the information about this assistive device is
public, otherwise false.

o

String
Free_Text_Description
. The description of the
assistive device.

o

String
Aid_Big_Image
. The URL of the big format picture of the assistive
device (used when displaying the detail view of the assistive device in EASTIN
Portal). The URL must be accessible on the Web by the end user’s browser.


SmallCompany
. Used to store resumed information about a company.

o

String
Company_Id
. The ID of the company in EASTIN partner’s local
database.

o

String
Name
. The name of the company.

o

DateTime
Last_Update_Date
. The date of the last update of the company
in EASTIN partner’
s local database.

o

String
Country
. The company’s country in ISO 3166
-
1
-
alpha
-
2 code (for
example “IT”, “US”, etc.).


Company
. Used to store additional information about a company.

o

String
Native_Record_Url
. The URL of the Web page on the original
EASTIN Partn
er’s web site in which the company is presented. The URL must
be accessible on the Web by the end user’s browser.

o

Boolean
Is_Public
. True if the information about this company
is

public,
otherwise false.

o

String
Address
. The address of the company.




12

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

String
Phone
. The phone of the company.

o

String
Fax
. The fax of the company.

o

String
Email
. The email address of the company.

o

String
Web_Site_Url
. The Web site URL of the company. The URL should be
accessible on the Web by the end user’s browser.


SmallAssociatedInf
oDoc
. Used to store resumed information about an
Associated Information element.

o

String
Associated_Info_Doc_Id
. The ID of the associated information
document in EASTIN partner’s local database.

o

DateTime
Last_Update_Date
. The date of the last update of the
associated
information document in Eastin partner’s local database.

o

String
Native_Title
. The original title in the native language of the
associated information document.

o

String
English_Title
. The English translation of the original title of the
associated

information document.

o

String
Native_Doc_Language
. The ISO 639
-
1 code of the native language
of the associated information document (for example: "en", "it", "de").


AssociatedInfoDoc
. Used to store additional information about an Associated
Information ele
ment.

o

String
Native_Document_Url
. The URL of the associated information
document in the original Eastin Partner’s web site. The URL must be
accessible on the Web by the end user’s browser.

o

Boolean
Is_Public
. True if the information about this associated in
formation
document are public, otherwise false.

o

String[]
Classification_Code_List
. The array of all ISO classification codes
associated to the associated information document (for example [“12.22”,
“09.03.03”]).

o

String
Abstract
. The abstract of the associa
ted information document.

o

String
Picture_Url
. The URL of the picture related to the associated
information document (used when displaying the detail view of the associated
information document in EASTIN Portal). The URL must be accessible on the
Web by t
he end user’s browser.


3.3.3

Search Engine Web Services

To communicate the EASTIN Central Server and the partner’s local databases, a group of
methods had been defined. There are two groups of Web methods:


Batch methods
. They are invoked by automatic processes which run in
EASTIN central server and are used to update some almost
-
static information
inside the EASTIN Portal (for example the ISO tree, the keyword lists, etc.).



13

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



These methods are called with different frequen
cies (from once a day to once a
month), depending on how often the retrieved information content is supposed
to change inside the EASTIN partner’s local system. For example the method
which returns the description of ISO classes used to update the ISO tree

in
EASTIN Portal is called once a month, because the ISO classification is supposed
to be almost constant. Instead the method which returns the number of
assistive devices for a given ISO class is invoked once a day because new
assistive devices could be
often added inside the EASTIN partner’s local system
or perhaps their description could have been modified.


Live methods
. They are invoked directly by the end users through the EASTIN
Portal Web pages and they return the results of searches inside EASTIN
p
artners’ databases about assistive devices, manufacturers and associated
information.


3.3.4

Search Engine Web Services


Batch methods

There are three batch methods:


GetIsoClassAidsNumber.


GetIsoClassInformation.


GetKeyWordList.

The descriptions of the methods

are presented below:


Int
GetIsoClassAidsNumber

(String isoCode)

o

Input parameters:



String
isoCode
. A string representing a single ISO class (for example
“12.22”).

o

Returns
. Int representing the number of assistive devices contained in the
ISO class passed
in the input parameter. Returns zero if no assistive device
belongs to the ISO class.

o

Frequency
. Once a day; calls to the Web method can start at any moment
between 00.00 AM and 00.59 AM. The time at which the last call is executed
is not defined.

o

Descript
ion
. This is a batch method which returns the number of assistive
devices belonging to the ISO class whose ISO code is passed as a string
parameter to the method. If no assistive device belonging to the ISO class is
found the method returns zero (and not t
he null object). The method is
designed to work in batch mode. Once a day the ISO classification tree which
is stored in EASTIN Portal is visited by the batch process and for each node,
which represents an ISO class, the method is called, passing the ISO c
ode of
that node as parameter (so the number of calls to the Web method is equal to
the number of nodes of EASTIN ISO classification tree). The method retrieves



14

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



the number of assistive devices belonging to that ISO class and this
information is updated in
the EASTIN ISO tree. The returned values must be
self
-
consistent with the ISO tree structure: for example the number of
assistive devices returned by GetIsoClassAidsNumber (“12.22”) must be equal
to the sum of the number of assistive devices returned invok
ing
GetIsoClassAidsNumber on all subclasses of “12.22”.


IsoClass
GetIsoClassInformation
(String isoCode)

o

Input parameters:



String
isoCode
: a string representing a single ISO class (for example
“12.22”).

o

Returns
. IsoClass object containing the description of

the ISO class passed in
the input parameter. If no description is found returns the null object.

o

Frequency
. Once a month; calls to the Web method can start on the first
day of every month at any moment between 03.00 AM and 03.59 AM. The
time at which the
last call is executed is not defined.

o

Description
. This is a batch method which returns a single object belonging
to the class IsoClass, which represents an element of ISO classification. The
method searches into the local database for information about th
e ISO class
whose ISO code is passed as string parameter to the method. For example if
the method is passed with the value "12.22" it will search for information
about 12.22 ISO class. The information retrieved by the method and stored in
the IsoClass obje
ct are:



The name of the ISO class



Its extended description (if available).



If no information for the ISO class is found the method returns the null
object.

o

The method is designed to work in batch mode. Once a month the ISO
classification tree which is
stored in EASTIN Portal is visited by the batch
process and for each node, which represents an ISO class, the method is
called, passing the ISO code of that node as parameter (so the number of
calls to the Web method is equal to the number of nodes of EAST
IN ISO
classification tree). The method retrieves the information about that ISO class
and then updates the EASTIN Portal ISO tree.


KeyWordHash[]
GetKeyWordList
()

o

Input parameters:



None

o

Returns
. KeyWordHash[]: an array of KeyWordHash objects containing
inf
ormation about keywords. If no keyword is found returns a not null
KeyWordHash[] array with zero elements.




15

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

Frequency
. Once a month; the unique call to the Web method can start on
the second day of every month at any moment between 03.00 AM and 03.59
AM.

o

D
escription
. This is a batch method which returns an array of objects
belonging to the class KeyWordHash. The method searches into the EASTIN
partners’ local databases for the collection of keywords


ISO classes which
will be used in the keyword research o
f EASTIN Portal. This method requires
no parameter. Each KeyWordHash object contains:



A keyword.



An array of ISO codes which are related to this keyword.



If no keyword information is found the method returns a not null array
with zero elements.

o

The meth
od is designed to work in batch mode. Once a month the method is
called and the returned information
is

updated in the EASTIN Portal keyword
lists.


3.3.5

Search Engine Web Services


Live methods

There are six live methods:


FindAidsList


FindAid


FindCompanyLis
t


FindCompany


FindAssociatedInfoDocList


FindAssociatedInfoDoc

The descriptions of the methods are presented below:


SmallAid[]
FindAidsList

(String[] isoCodeArray, String commercialName, String
manufacturer, DateTime firstEntryDate, DateTime todayDate)

o

Input parameters:



String[]
isoCodeArray
: an array of strings representing ISO classes
(for example [“12.22”, “09.03.03”])



String
commercialName
: the whole or a part of the commercial
name of the searched assistive devices



String
manufacturer
: the whole or

a part of the manufacturer name
of the searched assistive devices



DateTime
firstEntryDate
: the lower bound for the insert date of the
searched assistive device



DateTime
todayDate
: the current date




16

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

Returns
. SmallAid[]: array of SmallAid objects containing
each a light set of
information about an assistive device. If no assistive device is found returns a
not null SmallAid[] array with zero elements.

o

Description
. This method returns an array of objects belonging to the class
SmallAid. The method implements f
our different kinds of searches:



If isoCodeArray is not void the method searches for all assistive
devices belonging to the ISO classes passed, using an SQL OR
statement. For example if [“12.22”, “09.03.03”] is the isoCodeArray all
assistive devices belon
ging to 12.22 ISO class or to 09.03.03 class are
returned.



If commercialName is not void the method searches a matching
between the words contained in commercialName string and the data
in EASTIN partner’s local database using an SQL LIKE clause. Since
int
o the commercialName parameter there could be one or more
words the method should parse the words contained in these
parameters and organize the search in its own database using the SQL
criteria which grant the most exhaustive results.



If manufacturer is

not void the method searches a matching between
the words contained in manufacturer string and the data in EASTIN
partner’s local database using SQL LIKE statement. Since
manufacturer could contain one or more words the same consideration
as in 2 are vali
d.



If firstEntryDate and todayDate are not void all assistive devices whose
first entry date is included within the interval (firstEntryDate,
todayDate) are returned. These two parameters must be both not void
or both void.

o

The
previous results

a
re merged

together with an AND logic: only results
satisfying all conditions are returned. If one or more of the four group of
parameters are void they are ignored in the search procedure. If no assistive
device is found the method returns a not null SmallAid[] arr
ay with zero
elements.


Aid
FindAid
(String aidId, String nationality)

o

Input parameters:



String
aidId
: the ID identifying a single assistive device inside the
EASTIN partner’s systems.



String
nationality
: the nationality of the end user who has invoked
the
method formatted according ISO 639
-
1 code for languages (for
example: "en", "it", "de").

o

Returns
. Aid: an object containing detailed information about a single
assistive device. If no assistive device is found than returns the null object.

o

Description
. Thi
s method returns an object belonging to the class Aid. The
method searches into EASTIN partner’s local databases for the assistive



17

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



device which has the Aid_Id code matching with the method parameter
"aidId". The parameter "nationality" is used to decide if

the description of the
found assistive device has to be returned in the EASTIN partner local
language (in case the end user nationality is the same as EASTIN partner
nationality) or translated in English (if the two nationalities are different). The
forma
t of this parameter has to follow ISO 639
-
1 code for languages: "en",
"it", "de", etc. If no assistive device is found the method returns the null
object.


SmallCompany[]
FindCompanyList

(String companyName)

o

Input parameters:



String
companyName
: the whole o
r a part of the name of the
searched company

o

Returns
. SmallCompany[]: an array of SmallCompany objects containing
each a light set of informations about a Company. If no company is found
returns a not null SmallCompany[] array with zero elements.

o

Description
. This method returns an array of objects belonging to the class
SmallCompany. The method searches into EASTIN partner’s local database for
all companies whose name matches with companyName parameter using an
SQL LIKE statement. If no company is

found returns a not null
SmallCompany[] array with zero elements.


Company
FindCompany

(String companyId)

o

Input parameters:



String
companyId
: the ID identifying a single company inside EASTIN
partner’s local systems

o

Returns
. Company: an object containing d
etailed information about a single
company. If no company is found than returns the null object.

o

Description
. This method returns an object belonging to the class Company.
The method searches into EASTIN partner’s local database for the company
which has
the Company_Id code matching with the method parameter
companyId. If no company is found the method returns the null object.


SmallAssociatedInfoDoc[]
FindAssociatedInfoDocList

(String[] isoCodeArray,
String infoType)

o

Input parameters:



String[]
isoCodeArray
: an array of strings representing ISO classes
(for example [“12.22”, “09.03.03”])



String
infoType
: a string representing the type of additional
information searched. It must assume one of the following values:
“faq”, “fact sheet”, “case study”, “idea” and

“link”.

o

Returns
. SmallAssociatedInfoDoc[]: an array of SmallAssociatedInfoDoc
objects containing each a light set of information about an associated



18

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



information document. If no associated information document is found returns
a not null SmallAssociatedInf
oDoc [] array with zero elements.

o

Description
. This method returns an array of objects belonging to the class
SmallAssociatedInfoDoc. The method searches into EASTIN partner’s local
database for all associated information documents of type specified by
inf
oType parameter which are related to one of the ISO classes specified by
the parameter isoCodeArray. If no associated information document is found
the method returns a not null SmallAssociatedInfoDoc [] array with zero
elements.


AssociatedInfoDoc
FindAsso
ciatedInfoDoc
(String associatedInfoDocId,
String nationality, String infoType)

o

Input parameters:



String
associatedInfoDocId
: the ID identifying a single associated
information inside EASTIN partner’s system



String
nationality
: the nationality of the end u
ser who has invoked
the method formatted according ISO 639
-
1 code for languages (for
example: "en", "it", "de")



String
infoType
: a string representing the type of associated
information searched. It must assume one of the following values:
“faq”, “fact she
et”, “case study”, “idea” and “link”.

o

Returns
. AssociatedInfoDoc: an object containing detailed information about
a single associated information document. If no associated information
document is found than returns the null object.

o

Description
. This metho
d returns an object belonging to the class
AssociatedInfoDoc. The method searches into local database for the
associated information which has the Associated_Info_Doc_Id code matching
with the parameter associatedInfoDocId. The parameter nationality is use
d to
decide if the content of the found associated information has to be returned in
the EASTIN partner local language (in case the end user nationality is the
same as EASTIN partner nationality) or translated in English (if the two
nationalities are diffe
rent). The format of this parameter has to follow ISO
639
-
1 code for languages: "en", "it", "de", etc. If no assistive device is found
the method returns the null object.


3.3.6

Assistive Technology Product Search Section

The users can access to the assistive te
chnology product searcher section by clicking in the
“0. Searches” link at the left menu present in every page, and then selecting the “Assistive
Technology Products” link. The section has six different options:


Guided search by ISO product classification
codes.


Keyword search.




19

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Search by commercial name.


Search by manufacturer’s name.


Search by insert date.


Advanced search.

The description of each sea
rching option is detailed below.


3.3.6.1

Search Option number 1
-

Guided search by ISO product classification codes.

This option presents a table with three columns
, as shown
Figure
1
:


ISO Code
. The ISO number associated to the category (one to three numbers
in the format “xx”, “xx.yy” or “xx.yy.zz”).


Classification
. The name of the ISO Code category, and the associated
de
scription. This information is updated once a month by invoking the
GetIsoClassInformation

procedure for each ISO Code number and storing
the result at the database.


Number of products
. The number of assistive technology products associated
with the ISO Co
de category. This number is updated once a day by executing
the
GetIsoClassAidsNumber

procedure for each ISO Code number and
storing the result at the database.



Figure
1

Search by ISO code.


Each time

the

users click on

the

des
cription

of

an ISO class, the page is reloaded, showing
the

ISO classes associated

with

the previous one,

in

the form of a
table the same

columns

described above
. By clicking in a “third level” ISO class a list of all
the

products

associated
with

that

category

is loaded in a page of search results.




20

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



At any time

during

this

navigation

users
can click

on

the box

in the

last

column

showing

the

total

number

of

products belonging to

the category.

When users do that

the system
loads a

page

of

search
results

de
picted in
Figure
2
.


Figure
2

Search by ISO code results


The page of search results shows the

following
information:


Products found
. The
total products found in the search.


ISO Code
: The ISO Code and description of the products showed.


Local databases list
. A list of all local databases about assistive technologies
(“Rehadat”, “Hjælpemiddelbasen”, “Dlf data”, “Catalogo”, “Siva”, “Handicat”
and
“Vlibank”). There is a checkbox next to each database that the users can check
or uncheck. If the search is refreshed (by clicking the “Refresh” button), the
products belonging to the unchecked databases won’t be included in the results
page.


Sort by (
field)
. A drop
-
down list whose elements are a group of product
description fields: “Commercial name”, “Manufacturer”, “Insert date”, “Last
update” (selected by default) y “Database”. If the search is refreshed (by
clicking the “Refresh” button), the produc
ts will be ordered according to the
selected field.




21

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Sort by (order)
. A drop
-
down list with the options “Ascendant” and
“Descendant” If the search is refreshed (by clicking the “Refresh” button), the
products will be ordered according to the selected field
and the selected order.


Refresh button
. When users click the “Refresh” button, the page is reloaded
and the selected filters (local databases unchecked, sorting field and sorting
order) are applied.


Products table
. Each row of the table represents one of

the products found in
the search. By clicking in any box a page with the product’s details is loaded.
Each row shows the following information:

o

Small Image. A small image associated to the product.

o

ISO Code and description. The ISO Code and description
associated to the
product.

o

Commercial name. The product’s commercial name.

o

Manufacturer. The product’s manufacturer’s name.

o

Insert date. The date the product was inserted at its local database.

o

Last update. The date of the last update of the product’s info
rmation at its
local database.


Pagination Links
. Each page shows ten products and the rest are shown in
other pages. At the top and the bottom of the products table there are a series
of links to additional result pages.
Each

link

is

a

number that

indicate
s

the

particular page

to load
.
When

there are
more than

then result
pages
,
"
Previous
pages
"
and

"Next

pages
" are shown
that load

a

new

set of

pagination
links
.

When users click on a row in the product table, a new page with the product’s details is
loaded
, see
Figure
3
.




22

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
3

Product’s details page.


The elements of the page are:


ISO Code and description
. The ISO Code and description
associated to the
product.


Commercial name
. The product’s commercial name.


Manufacturer
. The product’s manufacturer’s name.


Large Image
. A larger image associated to the product.


Last update
. The date of the last update of the product’s information at its
local database.


Description
. The full description of the product.


Original document
. The URL of the product’s webpage at its local database
webpage.


3.3.6.2

Search Option number 2


Keyword search

This option presents a page with a drop
-
down list
, as depicted
Figure
4
.


Figure
4

Search by keyword





23

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



The elements of the list are updated once a month by executing the
GetKeyWordList

procedure.

When the
user selects one of the options and clicks the “Search” button, the systems makes
a search in the local databases and brings the data of the products belonging to the ISO
classes associated with the selected keyword.

A page with a table of products is load
ed. The table is similar to the one described at the
“Search Option number 1
-

Guided search by ISO product classification codes” section.
When the user clicks on a row, a page with the product’s details is loaded.


3.3.6.3

Search Option number 3


Search by comm
ercial name.

This option presents a text box
, see
Figure
5
.


Figure
5

Search by commercial name


When the user introduces a string in the textbox and clicks the “Search” button, the system
makes a search in the local databas
es and returns the data of the products whose
commercial name contains the introduced string.

A page with a table of products is loaded. The table is similar to the one described at the
“Search Option number 1
-

Guided search by ISO product classification

codes” section.
When the user clicks on a row, a page with the product’s details is loaded.


3.3.6.4

Search Option number 4
-

Search by manufacturer

name.

This option presents a text box
, see
Figure
6
.


Figure
6

Search by manufacturer name





24

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



When the user introduces a string in the textbox and clicks the “Search” button, the system
makes a search in the local databases and returns the data of the produ
cts whose
manufacturer’s name contains the introduced string.

A page with a table of products is loaded. The table is similar to the one described at the
“Search Option number 1
-

Guided search by ISO product classification codes” section.
When the user c
licks on a row, a page with the product’s details is loaded.


3.3.6.5

Search Option number 5
-

Search by insert date.

This option presents a page with a drop
-
down list
, depicted in
Figure
7
.


Figure
7

Search by insert date


The elements of the list are “Yesterday”, “Last week”, “Last month”, “Last 3 months” and
“Last Year”.

When the user selects one of the options and clicks the “Search” button, the
system makes a
search in the local databases and returns the data of the products whose “
Insert Date
” date
belongs to the period selected.

A page with a table of products is loaded. The table is similar to the one described at the
“Search Option number 1
-

Guided search by ISO product classification codes” section.
When the user clicks on a row, a page with the product’s details is loaded.


3.3.6.6

Search Option number 6
-

Advanced search
.

The EASTIN engine allows to search in all 7 national databases, by means of

the ISO
classification of assistive technology products or, alternatively, a list of keywords. It is also
possible to specify: the product commercial name (or part of it); the manufacturer name (or
part of it); the entry date in the products database. The

search starts when clicking on the
"Search" button.




25

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
8

Advanced search


The
Figure
8

depicts the elementos of this page, which are t
he following:


An ISO Codes category tree. When users click on an element, the subclasses are
deployed and the clicked element is selected (marked by two asterisks on the
tree).
The

search

will be
filtered

to

show only

items

in the

selected category
.


Search

by keywords. By checking this element, the search will be filtered
according with the content of the following text boxes:




26

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

Commercial name. A string to filter by commercial name.

o

Manufacturer’s name. A string to filter by manufacturer’s name.

o

Recent produ
cts. A drop
-
down list with the elements “Yesterday”, “Last
week”, “Last month”, “Last 3 months” and “Last Year”. The search will be
filtered according to the “Last updated” field of the product.


“Search” button.

When the user clicks the “Search button”, t
he system makes a search in the local databases
and returns the data of the products according with the selected filters.

A page with a table of products is loaded. The table is similar to the one described at the
“Search Option number 1
-

Guided search b
y ISO product classification codes” section.
When the user clicks on a row, a page with the product’s details is loaded.


3.3.7

Companies Search Section

The users can access to the companies search section by clicking in the “0. Searches” link at
the left menu p
resent in every page, and then selecting the “Companies” link. The loaded
page presents a text box.


When the user introduces a string in the textbox and clicks the “Search” button, the system
makes a search in the local databases and returns the data of
the companies whose name
contains the introduced string. A page with a list of companies is loaded.




27

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
9

Companies search section.


In
Figure
9
, t
he search results page shows the following information:


Companies found
. The total number of companies found in the search


Company name
. The string used in the search.


Local databases list
. A list of all de local databases about assistive
technologies (“Rehadat”, “Hjælpemiddelbasen”, “Dlf data”, “Catalogo”, “Siva”,
“Handicat” and “Vlibank”). There is a checkbox next to each database that the
users can check or uncheck. If the search is refr
eshed (by clicking the “Refresh”
button), the products belonging to the unchecked databases won’t be included
in the results page.


Refresh button
. When users click the “Refresh” button, the page is reloaded
and the selected filters (local databases checked
/unchecked) are applied.


Company List
. Each row of the table represents one of the companies found in
the search. By clicking in any box a page with the company’s details is loaded.
Each row shows this information:

o

Company name.

o

Company country.


Paginati
on Links
. Each page shows ten products and the rest are shown in
other pages. At the top and the bottom of the products table there are a series
of links to additional result pages.
Each

link

is

a

number that

indicates

the

particular page

to load
.
When

the
re are
more than

then result
pages
,
"
Previous
pages
"
and

"Next

pages
" are shown
that load

a

new

set of

pagination
links
.




28

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



When users click on a row, a page with the details of the company is loaded
, see
Figure
10
.


Figure
10

Company details.


The information of the details page is:


Original document
. The URL of the company’s webpage at its local database.


Name
. The company’s name.


Address
. The
company’s address.


Country
. The company’s country.


Phone
. The company’s phone.


Fax
. The company’s fax.


Website
. The company’s website URL.


E
-
mail
. The company’s email.


3.3.8

Associated Information Search Section

The users can access to the associated information search section by clicking in the “0.
Searches” link at the left menu present in every page, and then selecting the “Associated
Information” link.

Searches
can be performed

on

five

types of

items
:


Fact sh
eets.


FAQs.


Case Studies.


Ideas.


Links.

There are three types of searches associated to each type of elements. When the users
select one type of elements, these three types of searches are presented:




29

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Guided search by ISO product classification codes
.
A
list

of

ISO

Codes

such as the

guided search

of

the

section

of

assistive

technologies
.
Each

time

the

user clicks on

the

description

of

a

category, the page

is reloaded

with all the
subcategories

associated

with

the previous category. When the users click on

the


third

level

subcategories

the page is reloaded showing all the associated
information elements associated with the ISO Code selected.
At any time

during

this

navigation

users can click

on

the box

in the

last

column

to obtain a list of
associated
information elements belonging to the

ISO

code.


Keyword

Search
. A drop
-
down list as the one presented at the Assistive
Technologies search is presented. When the user selects an option, a list of all
the elements associated with the search is loaded.


Searc
h on all documents
. Returns a list of all the elements of the type
selected.

The result of the searches is always a page with a list of elements. Each item shows the
following information:


Name
. The Associated Information element’s name.


Last update
. The A
ssociated Information element’s last update.

When users click on an element of the list, a page with the details of the element is loaded:


Type
. The element’s type (“Fact Sheets”, “FAQs”, “Case Studies”, “Ideas” or
“Links”).


Title in English
. The English v
ersion of the element’s name


Original Title
. The element’s name in its original language.


Original document
. The URL of the element at the local partner’s webpage.


Classification
.

The ISO Code and associated description of the element.


Description
. The el
ement’s description.


3.4

Web

forms

3.4.1

Submit a product

This section is intended for manufacturers who can’t find their product in the EASTIN
network and wish to have it included. There is a form with the following elements:


Commercial name
.


Type of assistive
device
. The ISO Code as defined by the ISO 9999:2007
standard.


Concise description in English
.


Concise description in native language
.


Manufacturer Data

o

Company Name.




30

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



o

Website address
.

o

Geographical location
. A drop
-
down list of countries.


Data Submitted by
.

o

Surname and first name.

o

E
-
mail.


Supplier Information
. A form for
the
country

of
each
EASTIN founding and
liaison partner or national contact partner

(Belgium, Cyprus, Germany, Denmark,
Spain, Finland, France, United Kingdom, Italy, Lithuania, Latvia, Slov
enia and
Slovakia) is presented. Each country has an associated checkbox that indicates
whether to provide information about the supplier of that particular country. The
information associated with each country’s supplier is:

o

Company name.

o

Website address.

o

E
-
mail.

For each selected supplier a mail is sent to the specific e
-
mail address.
The mail (sent in
copy to the respective Eastin partner, too) invites the Supplier to contact the respective
Eastin partner and to ask him to take in consideration the inser
tion of the product in his
national database.

3.4.2

Info request

Using this form

in
Figure
11
, users can send requests to the EASTIN partners.




31

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
11

Information request


The web form fields are:


Name
. User’s name.


E
-
mail
. User’s email.


Country
. A drop
-
down list to select the user’s country.


Message
.


Addressee
. A group of radio buttons to select the partners. The question
can
be sent only to one partner.

When users click on the “Send” button, the message is sent to the selected partner’s email
address.


3.5

Restricted area

3.5.1

Accessing the restricted area

Users can access the private are by clicking on the “Restricted area” link a
t the left menu of
the webpages. A page with a web form is loaded
, see
Figure
12
:




32

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
12

Restricted area access form.


The web form
shows the following fields:


User.


Password.

To access the private are, users must have a valid username and password.


3.5.2

E
-
mails Section

Once validated, users can access the e
-
mails section. In this page, they can access the
emails sent to the EASTIN partne
r’s distribution list.

Emails sent to the distribution list are presented in a single webpage, in the form of a table
with these fields:


Subject
. The email’s subject.


Sender
. The name and email address of the email’s sender.


Date
. The email’s date.


Attach
ed list
. If the email has attached files, they appear in this section, as
links to the files.


Text
. The email’s main text is not shown in this table, but there is a link to open
a new tab in the navigator with the text.

From this section, users can’t send
new messages to the distribution list, as it only works as
a repository.


3.5.3

Attachments Section

Once validated, users can access the e
-
mails section. In this page, they can access the files
attached to the emails sent to the EAS
TIN partner’s distribution
list.

The files sent to the distribution list are presented in a single webpage, in the form of a table
with these fields:


File
. The file name and its size.




33

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Sender
. The sender’s name and email address.


Date
. The date the file was sent to the distribution l
ist.


Open attachment
. A link to the file.


Move to e
-
mail
. A link to the “E
-
mails” section in the restricted area. The link
takes the user to the message where the file was included.

From this section, users can’t send new files to the distribution list, as

it only works as a
repository.


3.5.4

Official documents Section

Once validated, users can access the “Official documents” section. In this page, they can
download the official files stored in the local EASTIN Central Server database.

The documents are present
ed in a single webpage, in the form of a table with these fields:


File name
. The document’s name, which act as a link to the file.


Date
. The document’s creation date.


Size
. The document’s size.







34

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



4

DATABASE DIAGRAMS

4.1

Overview and Diagram

EASTIN

Central

Server

has

a

database

that

serves

as

support to

various

sections of the

application
.
The content

of

some

of these

tables

is

updated

on

a regular basis

through

various

batch

processes
, depicted in
Figure
13
.


Figure
13

Complete database



4.2

Table descriptions

4.2.1

ISO Classification Tables

These tables store the information concerning the ISO Code categories stored locally
, see
Figure
14
.




35

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
14

ISO Classification tables


4.2.2

Users Tables

This tables store information about the webpage’s users
, see
Figure
15
.




36

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
15

Users tables

4.2.3

Email Tables

This tables store the information about the emails sent to the distribution list. The content

of
the emails and the file attachments are stored in these tables
, see
Figure
16
.


Figure
16

Email tables.


4.2.4

Keywords Tables

These tables sto
re the information about keywords and their associated ISO Codes
, see
Figure
17
.




37

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu




Figure
17

Keywords tables.


4.2.5

Labels Tables

These tables are
used to store the labels used to implement the multi
-
language of the web

pages

in
Figure
18
.


Figure
18

Labels tables.





38

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



4.2.6

Product Submission
Tables

These tables store the information about the products submitted by users using the “Submit
a product” web

form

in
Figure
19
.


Figure
19

Product Submission tables.







39

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



5

CONCLUSIONS

In the present document, the analysis of the existing EASTIN portal is described, which is
used to search assistive technologies across Europe.

This portal is composed of
two different environments
: p
artner’s
national d
atabases

and
the
EASTIN Central Server
, which is used to
access the information stored in them.

Both
environments are maintained independently. The EASTIN Central Server receives data from
the local databases by making r
emote calls using web serv
ices.

Taking as base the EASTIN portal, the new EASTIN 2.0 will be developed by ATIS4all and
ETNA thematic networks.






40

European Thematic Network on Assistive Technologies and Inclusive Solutions for All

European Commission, CIP
-
ICT
-
PSP
-
2010
-
4 Project 270988

www.atis4all.eu



6

REFERENCES

ISO. (2007).
ISO 9999:2007
-

Assistive products for persons with disability
--

Classification
and termi
nology.

International Organization for Standarization.