Le forme di mercato

1
Web-Designer for virtual museums
2
Web-Designer for virtual museums
TUC 1
Introduction

• This e-course is organized through Training Unit
  able to be Capitalized (TUC) which can be
  decomposed into Didactic Unit (U.D.) and Learning
  Object (L.O).
• In order to understand the main logic behind the
  organization of this programme, notice that
• each T.U.C involves several educational goals,
  which sum up to the basic skills of a
  web-designer for virtual museums
• each D.U discusses one single educational goal
  through several topics
• each L.O identifies one single topic. All L.O
  together compose the whole e-course.

3
TUC 1
DU 2 The publication of data on the Internet
DU 3 Software used for modelling 3D images
DU 4 Photography
DU 1 Upload the database

• LO 1.0 Databases and the publication of data on
  the Internet
• LO 1.1 General Information
• LO 1.2 The relational model
• LO 1.3 Management systems of the relational
  databases
• LO 1.4 Configuration of databases
• LO 1.5 Physical implementation of data (a)
• LO 1.6 Physical implementation of data (b)

• LO 2.1HyperText Markup Language
• LO 2.2 Active Server Pages (ASP)
• LO 2.3 ActiveX Data Object (ADO)
• LO 2.4 Structured Query Language (SQL)
• LO 2.5 JavaScript

• LO 3.1 3D Softaware Object Modeller
• LO 3.2 VR WORX 2.5
• LO 3.3 PhotoModeler
• LO 3.4 PixMaker PRO

• LO 4.1 Projecting the camera set
• LO 4.2 Lightening
• LO 4.3
• The camera

4
Upload the database
DU 1

• This lecture unit focuses on the main advantages
  of a dynamic web site, by which user-friendly
  interactive databases are developed. The System
  of Management for interactive databases (RDBMS)
  is crucial in order to create a virtual museum.
  In this scenario, DU1 is specifically aimed at
  web-designers whose expertise is applied for
  museum- communication purposes.
• The objectives of DU1 are
• to plan and realize a System of Managing
  Relational Databases
• to define the structure of the database
  (organizing data in tables and their
  connections)
• to identify the operations that can be executed
  in interactive modality.      

5
Databases and the publication of data on the
Internet
LO 1.0 Abstact
The main advantages of a dynamic web site
compared to a static one are, on the one hand,
the easiness of administration (updating the
information contained) and, on the other hand,
the permission given to users to create selection
interrogations for listing the data searched. The
addition or modification of contents is very
simple because this content is stored in a data
base or in text, graphic or multimedia files, in
such a way that those who are in charge of
contents do not need to possess HTML (Hyper Text
Markup Language), CSS (Cascading Style Sheets),
JavaScript knowledge or other technologies
specific for Web design and often used in
designing presentation pages. In the
development of the European Virtual Museum the
use of a RDBMS (Relational DataBase Management
System) is compulsory, due to the complexity of
data necessary for the complete description of
objects it contains and also due to the need for
the information to be always updated by
specialists of partner museums. The existence of
such RDBMS Databases allows the registration of
all general and special information referring to
objects presently suggested by partners (museums,
research institutes etc.) or completed step by
step.
6
Databases and the publication of data on the
Internet
LO 1.0 Abstract
Moreover, these databases together with the
multimedia files can offer supplementary packages
of special information referring to other
archaeological objects research and
archaeological sites in the area museums or
general or specialized museum collections
historical monuments and / or special cultural
objects useful data and addresses for
transportation, accommodation, and visiting
cultural and tourist objectives virtual shop
(replicas/copies). For the publication on the
internet of the information contained in the
databases, managed by a RDBMS, the main
technologies used are ASP (Active Server Pages)
and ASP.NET (www.aspfree.com www.asp.net), PHP
(Hypertext Preprocessor) www.php.net, JSP (Java
Server Pages) www.java.sun.com/products/jsp/
.All these technologies have server-side
scripting. In such a case the Web server
interprets the file (.asp, .php, .jsp) and sends
an equivalent .htm file to the browser of the
client computer. If the file contains scripts
created with VBScript or JavaScript, the
scripting engine from the server executes the
respective codes. HTTP (Hypertext Transfer
Protocol) is a dependant protocol, in such a way
that any modification made by the user in an
interactive page, as unimportant as it may be,
must be sent to the server which sends back an
updated image of the page. This process is called
circuit through the server.
7
Databases and the publication of data on the
Internet
LO 1.0 Details

• The advantages of using such technologies are
• Dynamically edit, change, or add any content of a
  Web page
• Respond to user queries or data submitted from
  HTML forms
• Access any data or databases and return the
  results to a browser
• Customize a Web page to make it more useful for
  individual users
• Provide security and access control to different
  Web pages
• Tailor your output to different types of
  browsers
• Minimize the network traffic.

8
Practice
LO 1.0
(Forum)
RDBMS advantages Weight Explain
dynamic web-editing
on-line query and data management
data access through browsers
customize websites
on-line protection
compatibility with any browser
minimize website traffic
For a better understanding of this topic,
associate weights to each of the RDBMS
advantages reported below. Use (), () and
() in order to indicate low, medium and high
relevance respectively. Explains the main
rationale behind your choice in the last column.
Finally, discuss your choices with your
colleagues.
9
General Information
LO 1.1 Abstract
The models and techniques of organizing databases
have developed in such a way that they satisfy
the needs of users to have a faster and easier
access to a larger amount of information.
Shortly, the concept of a database can be
defined as being one or more collections of
interdependent organized data, together with the
description of the data and the relation between
them. Relational databases refer to a
collection of data, structured as tables called
relations. The term relational comes from the
fact that each registration in the database
contains information referring to a single
subject. Moreover, the data organized in
categories of information can be manoeuvred by a
single entity, based on values of associated
data.
10
Fundamental objectives of a database
LO 1.1 Details

• 1. Centralization of data in a database solves
  the following problems
• suppressing the redundancy of data
• ensuring the uniqueness of registrations
• centralized control of data
• 2. Interdependence between data and the
  application programmes updating of data from a
  database must not affect programmes of data
  modelling.
• 3. The possibility of connecting data entities,
  which are indispensable for an efficient
  exploitation of the informatics system.
• 4. The integrity of data provides the reliability
  and coherence of the database. Thus we must
  define integrity restrictions like
• belonging to a list of values or interval
• belonging to a certain format
• rules of coherence with other data.

11
Fundamental objectives of a database
LO 1.1 Details

• 5. Security of data the database must be
  protected against any logical or physical
  destruction (updating anomaly). This is done by
  saving, from time to time, some copies of the
  database.
• 6. The confidentiality of data is assured by
  procedures of
• identification of users by name or code
• authentication by password
• authorization of differentiated access by rights
  of creation, consultation, modification or
  erasing for certain segments of data.
• 7.The division of data allows the connection of
  transactions simultaneously solicited on the same
  registration of the database, by blocking waiting
  requests and their ulterior serving

12
COMPASS Database of the British Museum
LO 1.1 Case studies

• COMPASS (Collections Multimedia Public Access
  System) (http//www.thebritishmuseum.ac.uk/compass
  /) is an online database featuring around 5,000
  objects chosen by curators to reflect the
  extraordinary range of the British Museums
  collection. The database has versions for both
  adults and children.
• The website is visited by a large number of
  people. According to their statistics, the number
  of page views to the site are
• 2002 8,227,638
• 2003 12,866,087
• 2004 18,153,123
• The COMPASS website was paid for by a generous
  donation by the Annenberg Foundation (
  http//www.whannenberg.org/ ) which enabled the
  Museum to restore and re-vamp the Reading Room at
  the British Museum. The COMPASS project was part
  of this. The Childrens COMPASS site was funded
  by the Ford Motor Company Fund.

13
LO 1.1 Case studies
COMPASS Database of the British Museum

• The adult section is very well organized and
  there are several searching facilities depending
  on the area of interest of the visitor. Moreover,
  there are many useful links and also background
  information on almost every item. There are
  online tours on a variety of subjects and there
  is also information about current exhibitions.
  The online tours cover a wide range of topics,
  starting from New Tours and The British Museum to
  collections referring to Africa, Americas,
  Europe, Greece, Rome, Egypt and so on. Apart for
  the fact that each object featured is illustrated
  with high quality scalable images for detailed
  study, there is also plenty of information about
  the objects, as well as references and links to
  related objects. The database was designed for
  the general visitor and thus the information has
  been written accordingly. Therefore, technical
  terms are explained in glossary links and if one
  is interested in learning more about an item,
  most of the articles give references to books
  written or recommended by the Museums curators.
• Childrens COMPASS was launched in February 2002
  and uses a search engine designed for children.
  Apart from the childrens tours and the articles
  written for 7-11 year old pupils, there are also
  classroom activities and quizzes, as well as an
  Ask the Expert facility. The online tours are
  specially written to cover topics from the UK
  National Curriculum, including Literacy,
  Numeracy, Science and Art as well as History.
  There are also examples of childrens work,
  online animations, games and puzzles, web links
  and reading lists. In addition to the online
  tours, there is also a Search engine that allows
  children to look for information from the
  following areas Africa, the Americas,
  Anglo-Saxon England, Asia, Ancient Egypt, Europe,
  Ancient Greece and Roman Britain.

14
LO 1.1 Case studies
COMPASS Database of the British Museum

• Childrens COMPASS was planned so that children
  with disabilities could use it as well. The
  worksheets have a set of teaching suggestions for
  how they may be adapted, both for children with
  learning difficulties, as well as for those who
  need extension activities. For those with reading
  difficulties, there is software available for
  reading the text on childrens COMPASS aloud.
  Childrens COMPASS has been designed from the
  outset with visually impaired users in mind
  (ttp//www.thebritishmuseum.ac.uk/compass/ixbin/hi
  xclient.exe?_IXDB_compasssearch-formgraphical/e
  du/main.htmlsubmit-buttonsearch). Thus a
  text-only version of most screens enables
  screen-readers to browse, while text size and
  colour can be easily changed using the browser
  tools.
• The site has been designed and evaluated by the
  New Media Unit at the British Museum, in
  consultation with local primary schools and with
  the advice and assistance of the Museum Education
  Department.
• According to Tim Jacques from the New Media Unit,
  the following worked on COMPASS website
• Head of New Media project manager
• Content Manager responsible for the content on
  the site
• Imaging Manager responsible for the images on
  the site
• Creative Editor responsible for all the text
• Design Manager responsible for the design of
  the site
• Access Officer responsible for all access
  issues for the site
• Education Editor responsible for the editorial
  content on the Childrens COMPASS site
• Imaging Assistant helping the Imaging Manager
  and also HTML coding for some pages
• Support Officer administration for COMPASS
  Project
• I.S. Support IT support for the project, though
  not full time on COMPASS alone

15
LO 1.1 Case studies
COMPASS Database of the British Museum

• In addition, there were also Editorial Assistants
  to help with editing the text, and curators and
  freelancers who wrote the object text. Also,
  there were a number of interns who worked for
  fixed periods of time, usually to compliment
  their studies.
• The technology for the site and delivering it to
  the web was provided by a company called System
  Simulation Ltd. Their Index (www.ssl.co.uk)
  software provided the database. System Simulation
  Ltd. offers a comprehensive package of support
  arrangements tailored to user requirements.
  Training is provided for application builders,
  database administrators and end-users. Tools for
  importing data from a wide range of third party
  files and databases to Index applications are
  also available.
• Information management systems frequently require
  support for a range of specialist functions as
  well as the basic storage and retrieval
  facilities. The application tools provided with
  Index are designed so that appropriately
  tailored systems are very easy to make, use and
  maintain. The facilities provided by this
  software include
• Interfaces to newswire systems
• Storage management for large text and image
  archives
• Interfaces to Point of Sale equipment
• Interfaces to EDI systems
• Interfaces to scanning and OCR software
• Script-based multimedia authoring
• Loan management
• Exhibition design
• Index has been successfully integrated with
  RDBMS and other more specialised applications.

16
COMPASS Database of the British Museum
LO 1.1 Case studies

• System Simulation Ltd. has implemented the
  British Museums new Merlin collections
  management system based on MUSIMS. Data have been
  imported from the previous system and the data
  structures and procedures have been upgraded in
  line with modern and international museum
  standards. The Terminology Client includes
  thesauri developed by the British Museum and
  other international standards. The Unicode
  facility enables the museum to catalogue and
  search using historical and non-European scripts.
  Merlin provides data and resources for the
  COMPASS public access system through an
  integrated Index Content Management System, also
  supplied by System Simulation Ltd.
• System Simulation Ltd. worked closely with the
  COMPASS team and supplied the software
  architecture for the COMPASS project. Thus, the
  Content Development System was used for the
  creation and management of all content including
  selected data imports from Merlin (the Museums
  collection management system) and the Publishing
  Pipelines delivering content to all versions of
  COMPASS on the web and to the specially designed
  touch-screen consoles in the Reading Room.
  COMPASS offers a variety of interfaces for
  exploring the Museums collections in new ways,
  therefore enabling visitors to get a better
  understanding of objects and their contexts.
  Childrens COMPASS find specially designed
  features for children, as well as parents,
  teachers and schools. The programs presented
  there are aimed at the specific needs of both
  teachers and children, and the subject areas of
  the UK National Curriculum.
• There is also a high-access text-only version
  provided for visually impaired visitors. For the
  outstanding efforts to ensure that the website is
  accessible to visually impaired people, The
  British Museum COMPASS won the Visionary Design
  Award 2002 from the National Library for the
  Blind.

17
The relational model
LO 1.2 Abstract
The relational model was defined and published
for the first time in 1970 by Dr. Edgar F. Codd,
a researcher at the IBM laboratories from San
Jose (California), who published his works
referring to the relational model for databases.
This relational model has the advantage that it
allows the designer of the database to study the
properties of the managing system of the database
without being forced to implement it. The
theoretical fundament of this kind of a database
is represented by the mathematical theory of
relations. One of the main characteristics of
the relational model is its simplicity and
strictness from a theoretical point of view, a
fact that placed it before other models, being
adopted within the last decade by the majority of
researchers and programmers in the field. The
data and relations are explicitly represented,
using a logical structure called relation. On the
other hand, the relational model was
mathematically defined, providing a modern means
of studying the logical properties of a database
system. Unlike the relational model, other
models, previously used, the hierarchy model and
the network model did not have such a powerful
theoretical background. Another essential
difference between the relational model and the
other two models is that while the former is
oriented towards a multitude, the other two are
file oriented this results from the fact that if
for the hierarchy model and the network model the
programmer must design procedural programmes,
which should access the database registration by
registration using physical connections for
registrations while for the relational model,
just one instruction in an non-procedural
language (like SQL Structured Query Language),
usually determines the modelling of more
registrations
18
The relational model
LO 1.2 Abstract
Another particular property for the relational
model is that only the logical properties of the
database can be addressed and not the physical
ones, because it is not oriented towards the
calculation system. As a result, the model does
not include the rules, structures and operations
referring to the physical implementation of the
database system. However, one of the objectives
of the relational model was to introduce a clear
distinction between the physical and logical
aspects of a database, an objective called by E.
F. Codd the independence of data. At the
beginning of the theoretical foundation of the
relational model, there were serious fears
regarding the efficiency of applying the
relational model for large databases. The
extraordinary technological development in the
field of electronics and informatics within the
past few years is obvious in the rise of the
modelling power of computers and has led to the
elimination of these fears through the large use
of the relational database systems including on
personal computers.
19
The components of the relational model
LO 1.2 Details
The components of the relational model are

• The relational structure of data. Within
  relational databases, the data is organised as
  tables, called relations. Associations between
  relations are explicitly represented through
  connection attributes.
• The operators of the relational model. They
  define the operations that can be done on
  relations, with the purpose of realising the data
  modelling functions (visualisation, insertion,
  modification, erasing).
• Integrity restrictions of the relational model.
  Also called integrity rules they define the
  demands that must be satisfied by the data within
  the database in order to be considered as correct
  and coherent compared to the real world that they
  reflect.

20
Management systems of the relational databases
LO 1.3 Abstract

• In order to reach the objectives for which it was
  created, a database must have an associated
  system of data management, which is the software
  of the database.
• Through the system of data management the
  following activities can be accomplished
• defining the structure of the database
  (organizing data in tables and their connection)
• introducing and modifying data
• fast access to data through different types of
  interrogations
• presentation of data as reports (listed on the
  screen or printed) in which the data resulted
  from interrogations are summarized
• security of data
• A database management system (DBMS) is a
  mechanism whose fundamental principle lies,
  generally speaking, in the so-called abstracting
  of data stored on the support. There are three
  abstracting levels corresponding to the three
  models of data physical, conceptual and logical.
  (Figure 1)
• The physical model (or internal) regards the data
  as they are stored on the
• support and represents the zero level of
  abstracting
• The conceptual model regards the data through its
  real significance
• The logical model (or internal) regards the data
  through the eyes of the final user. For a
  database there may be more logical models,
  depending on the different possible categories of
  final users.

21
Planning databases
LO 1.3 Details

• Projecting database applications implies, from
  this point of view, two extremely important
  initial steps logical projection and physical
  implementation of the data model. The data model
  forms the basis of the entire application system
  which will exploit the database. The logical
  projection refers to the establishment of the
  conceptual model of the database, which is
  independent compared to the particular DBMS that
  will be used. The result of this first step is a
  document that will contain the detailed
  definition of the data structures which will be
  implemented. The physical implementation consists
  of the transposition of the conceptual model
  produced in the previous step, on the specific
  DBMS.
• The main RDBMS that are the basis of dynamic and
  interactive Web pages
• Oracle (www.oracle.com)
• Microsoft SQL Server (www.microsoft.com/sql/)
• Microsoft Access (www.office.microsoft.com/en-us/d
  efault.aspx)
• MySQL (www.mysql.com)

22
Practice
LO 1.3
Figure 1 Abstracting levels of a RDBMS
23
Configuration of databases
LO 1.4 Abstract

• According to these objectives, the construction
  of a database implies the following steps
• analysis of the system (domain) for which the
  database is projected
• projecting the structure of the database
• introducing the data in the database
• exploitation and maintenance of the database.
• The first step in the configuration of the
  database is the setting out of the objects that
  must be included and their properties. A single
  object together with its properties forms an
  entity of data. Each entity of data must be
  unique in order to be differentiated from the
  others. The properties of the objects included in
  entities of data are called attributes. The
  identification of objects (data sources) together
  with their properties is called data modelling.

24
Configuration of databases
LO 1.4 Abstract

• The purpose of the data model is to create a
  logical representation of the data structure,
  used for the creation of the database. The models
  using objects and tables (which will be created
  afterwards on the grounds of these objects) are
  called conceptual data models.
• For the configuration of databases we identify
  two conceptual data methods or models
• the bottom-up method for the creation of an
  application database. According to this method
  the configuration of the database begins with the
  image of data listed on the screen or with a
  printed report. It is used for the creation of a
  simple database, which uses a single type of data
  object
• the top-down method, in which the configuration
  begins with the identification of objects (data
  sources) for the creation of subject databases
  (databases formed by tables dedicated to a single
  class of subjects).
• A better solution is the configuration of
  databases with the help of groups of objects
  which are connected by subject. This means the
  use of the top-down method (model).

25
Objectives
LO 1.4 Details

• The main objectives that must be fulfilled after
  the configuration process of a database are
• fulfilling the needs of the user for getting
  updated information in time and economically
• the elimination and minimization of repetition
  (redundancy) of data from the database
• providing fast access to certain information
  elements from the database, necessary for
  different categories of users
• the possibility of extending the database
  according to the users needs
• the security of data which consists of stopping
  the access of unauthorised persons to the
  database
• the easiness in the creation of applications for
  the introduction, editing, listing and
  rediscovering of information.

26
Physical implementation of data (a)
LO 1.5 Abstract

• The Implementation of data consists of the
  transposition of data entities in tables made up
  of columns (fields) and rows (registrations). The
  attributes of entities together with the
  connection attributes (which will be added) will
  be the columns (fields) of the tables. The values
  associated to these fields represent the rows
  (registrations) from tables.
• The implementation of relations between entities
  can be made through four possibilities
• one-to-one the value of the key field from a
  single registration from the new table must
  correspond to a unique value of the associated
  field from the existing table (the tables have a
  one-to-one correspondence of rows one row in a
  table cannot have more than one corresponding row
  in the other table)
• one-to-many the field main key from the first
  table must be unique, but the values from the key
  field of the second table may be associated with
  more entries (one-to-more relations ties a single
  row in a table to more rows from another table by
  means of a relation between the primary key of
  the main table and the corresponding key of the
  associated table)

27
Physical implementation of data (a)
LO 1.5 Abstract

• many-to-one the new table may have more values
  in the key field which may correspond to a unique
  value of the associated field from the existing
  table (it is the opposite of the one-to-many
  relation
• many-to-many they have no restrictions, there
  are no unique relations between the key fields
  from the existing table or the new table both
  key fields contain duplicate values. These types
  of relations cannot be expressed as simple
  relations between two participating entities. In
  order to create a many-to-many relation we must
  create an intermediary table which should have
  many-to-one relations with two main tables.
• Observation we must remember the fact that
  many-to-one and one-to-many relations are one and
  the same thing, depending on the table to which
  we refer.

28
Physical implementation of data (b)
LO 1.6 Abstract

• The normalization is a standard procedure by
  means of which the attributes of data are grouped
  in tables, and tables are grouped in databases.
  The purposes of the normalization are the
  following
• the elimination of doubles in the tables
• the permission of carrying out future
  modifications in the structure of tables
• minimizing the impact of structural modifications
  of the database in the applications of users who
  use the data.

29
Physical implementation of data (b)
LO 1.6 Abstract

• The normalization is carried out in five steps
  (forms of normalization)
• the first normal form indicates that the tables
  must be plane and must not contain repetitions of
  groups
• in the second normal form the data from the
  columns without key are completely depending on
  the main key
• for the third normal form, all the columns
  without a key in a table must respect the rules
  of the first and the second normal form
• for the fourth normal form, independent data
  entities must not be stored within the same table
  when between these entities there are
  many-to-many relations (it eliminates the
  redundancy due to mn relations).
• for the fifth normal form, the exact
  reconstruction of the original table from those
  tables from which it had been separated, must be
  possible it seldom appears in practice.

30
The publication of data on the Internet
DU 2

• For the creation of the Web site of the European
  Virtual Museum, we used Microsoft Active Server
  Pages technology. Further on we are going to
  introduce the main elements which are part of
  this technology
• This lecture unit explains deeply what is meant
  by (a) HTML, (b) ASP and (c) how entering the
  database thought the web. Main features of SQL
  (structure Query language) and Java programming
  are discussed.
• The objectives of DU2 are
• to identify the operations that can be executed
  in interactive modality
• to know how to use the main software for
  realizing the web pages.

31
LO 2.1 Abstract
HyperText Markup Language
One of the first fundamental elements of the WWW
(World Wide Web) is HTML (HyperText Markup
Language), a standard which describes the primary
format in which the documents are being
distributed and seen on the WEB. Many of its
features, as the independence of the platform,
the structuring of formatting and the hypertext
connections, make it a very good format for
documents published on the Internet.   The
official HTML standard is given by World Wide Web
Consortium (W3C) which is affiliated to Internet
Engineering Task Force (IETF). W3C stated a few
versions of the HTML specification, like HTML
2.0, HTML 3.0, HTML 3.2, HTML 4.0, HTML 4.01 and,
most recently XHTML (Extensible HyperText Markup
Language). At the same time the authors of
browsers (navigators) like Netscape (Netscape
Navigators) and Microsoft (Internet Explorer),
have often developed their own HTML extensions
excluding the standard process and incorporated
them in their own browsers.  
32
LO 2.1 Abstract
HyperText Markup Language

• Presently, HTML 4.0 is widely utilized and the
  HTML specifications have already been published.
  HTML language offers WEB designers the following
  possibilities
• to publish the documents with headers, texts,
  tables, lists, photographs etc.
• to find information on-line by means of
  hyperlinks accessed by a simple mouse click
• to project forms for the achievement of
  transactions with distant servers, for searching
  for information or for commerce specific
  activities
• to include table calculation sheet, video clips,
  sounds and other applications directly in
  documents.

33
LO 2.1 Details
The origins of HTLM
HTML was initially developed by Tim Berners-Lee
at CERN (Centre Européen de Recherche Nucléaire)
in 1989. HTML is a language based on SGML
(Standard Generalized Markup Language) which is
an international standard (ISO 8879) approved
in 1986. HTML was initially seen as a possibility
for physicians using different computers to
change information between them by means of the
Internet. Thus a few conditions were necessary
independence of the platform, hypertext
possibilities and structuring of documents. The
independence of the platform means that a
document can be listed in a similar way (or
almost identical) by different computers, vital
for a numerous and various audience. Hypertext is
translated by the fact that any word, phrase,
image or element of the document seen by the user
(client) can refer to another document or even to
paragraphs within the same document, which makes
the navigation between components of the same
document or between multiple documents easier.
The strict structuring of documents allows their
conversion from one format into another as well
as the interrogation of a database containing
these documents.
34
LO 2.2 Abstract
Active Server Pages (ASP)
Active Server Pages (ASP) is a powerful
instrument developed by Microsoft. An ASP file
may contain text, HTML tags (markers) and
scripts. The scripts in an ASP file will be
executed by the server through IIS (Internet
Information Server) which is part of Windows
2000, Windows NT 4.0 (Option Pack) or PWS
(Personal Web Server) in Windows 95-98. An ASP
script, executed by the server, is always limited
by lt gt and may contain expressions,
instructions, procedures, or operators accepted
by the language use (for example JavaScript). ASP
pages use ADO objects (ActiveX Data Objects) to
achieve the connection of data after which,
through the Structured Query Language (SQL),
different types of queries on the databases can
be carried out.
35
LO 2.3 Abstract
ActiveX Data Object (ADO)

• ADO is used to access a database through a WEB
  page. It was created by Microsoft and it is
  automatically installed at the same time with
  Microsoft IIS (Internet Information Server)
  package. By means of the ADO component the
  following operations in an ASP file may be
  fulfilled
• The creation of an ADO connection with the
  database
• Opening the connection with the database
• The creation of an ADO recordset
• Opening a recordset
• Drawing out the necessary data from a recordset
• Closing a recordset
• Closing the connection with the database.

36
LO 2.4 Abstract
Structured Query Language (SQL)

• SQL is an ANSI (American National Standards
  Institute) standard language used for the
  querying of MS Access, MS SQL Server, DB2,
  Informix, Oracle, Sybase databases etc.
• With the help of SQL we can make selection or
  action queries (adding, deleting and modifying
  registrations) upon databases. It consists of
• SQL Queries for querying the database
• SQL Data Manipulation Language (DML) which
  allows the introduction, deletion and updating of
  data (registrations) by using the instructions
• INSERT INTO introducing new data in a table of
  the database
• DELETE deleting registrations
• UPDATE updating (modifying) registrations.

37
LO 2.4 Abstract
Structured Query Language (SQL)

• SQL Data Definition Language (DDL) allows the
  creation, modification and deletion of tables in
  the database, as well as the creation and
  deletion of an index (search key). For this
  purpose the following instructions are being
  used
• CREATE TABLE
• ALTER TABLE
• DROP TABLE
• CREATE INDEX
• DROP INDEX

38
LO 2.4 Case studies
The State Hermitage Museum
The Hermitage Museum Project, as a partnership
between IBM Corporate Community Relations () and
the State Hermitage Museum in St. Petersburg,
began in 1997. The website () presents
significant historical information on the
Hermitage Museum, its extensive collections,
offerings, events, membership and special
exhibitions. The Hermitage Museum website enables
the world to see the Hermitage collections from
anywhere in the world using IBM Digital Library
technology, based on IBM RS/6000 computers and
IBM Digital Library software from the IBM Santa
Teresa, California Lab. The special application
software was created in IBM's e-business Solution
Centre in Naples, Italy and the site design and
user interface of the website were developed by
IBM's e-business Services in Atlanta,
Georgia http//www.haifa.il.ibm.com/projects/soft
ware/hermitage/index.html. At the core of the
project is IBM's Image Creation Studio based on
IBM Research's Pro/3000 Scanner with PC's and
special image processing software, which produce
high quality, high resolution digital images from
originals or transparencies of works of art from
the Hermitage collections. The images feature
IBM's patented digital invisible watermark
technology to protect Hermitage image usage
rights. For this project, 2000 images have been
scanned and retouched by the Hermitage Museum
staff.
39
LO 2.4 Case studies
The State Hermitage Museum
The Hermitage Museum website provides a
searchable database of high resolution images
from 12 distinctive categories of works
(painting, prints and drawings sculpture
machinery and mechanisms arms and armour
furniture and carriages ceramics and porcelain
applied arts jewellery textiles numismatics
and glyptics costume archaeological artefacts),
HotMedia images of selected rooms and items,
Query By Image Content Search (QBIC Search) and
the "Zoom View" Java-based technology developed
expressly for this project. It allows the user to
zoom in on a particular part of an illustration
for detailed analysis and to study descriptive
material (http//www.hermitagemuseum.org/html_En/i
ndex.html). Query By Image Content search
technology allows users locate works using visual
tools, by selecting colours from a palette or by
sketching shapes on a canvas. With advanced
search visitors can find a particular item by
selecting a specific category of artworks, the
type of item, the style, trend or tendency,
country of origin, theme, genre, the personage
represented and the data range. In the section
Zoom View Gallery users can scrutinize the
slightest details of an artwork using an
innovative technology. High-resolution images are
provided by IBM's specialized Image Creation
Studio using patented IBM technology developed at
Watson Research labs to digitize art objects and
protect images. The network used to host the
website includes multiple farms of IBM RS/6000
and support millions of hits each day.
40
LO 2.5 Abstract
JavaScript

• JavaScript is a programming language for WEB
  pages. It is used in many sites for improving
  their design, for the validation of some forms
  etc. It has been developed by Netscape and it is
  the most popular script language for the
  Internet. It is recognized by all popular
  browsers (navigators) from version 3.0 and more.
  The main characteristics and uses of the
  JavaScript language
• it has been created for developing the
  interactivity of WEB pages
• it is a line of command language
• it is written directly in HTML document
• it does not need a preliminary compiler
• anyone can use JavaScript without a licence
• it is tolerated by all important navigators, like
  Internet Explorer or Netscape.
• The complete description of the Active Server
  Pages technology, and not only, can be found at
  www.asp.net.

41
Practice
LO 2.5

• The language offers WEB designers the following
  possibilities
• to publish the documents with headers, texts,
  tables, lists, photographs etc.
• to find information on-line by means of
  hyperlinks accessed by a simple mouse click
• to project forms for the achievement of
  transactions with distant servers, for searching
  for information or for commerce specific
  activities
• to include table calculation sheet, video clips,
  sounds and other applications directly in
  documents.
• True or False?
• 2. With the help of SQL we cant make selection
  or action queries (adding, deleting and modifying
  registrations) upon databases.
• True or False?
• 3. JavaScript is a powerful 3D software product
  that calculates measurements and constructs 3D
  models from your photographs simply and easily.
• True or False?

42
DU 3
Software used for modelling 3D images

• Images and graphics are a fundamental source of
  communication. 2D and especially 3D graphics are
  quickly becoming an integral part of dynamic,
  interactive web sites.
• Following is a description of some 3D graphics
  software currently available.
• The objectives of DU 3 consist in
• to know how to use the main software for
  realizing the images in 3D
• to know how to converse profitable with the
  professional figures of the expert of the
  contents and with the project leader.

43
LO 3.1 Abstract
Software 3D Object Modeller
3DSOM from Creative Dimension Software Ltd. is a
fast, cost-effective software tool for generating
photo-realistic 3D models from images of real
objects, based on technology originally developed
by Canon. With the 3DSOM Viewer Java applet,
interactive plug in-free 3D content can easily be
created for compelling e-commerce sites,
eye-catching internet advertising, online museum
exhibitions, and more. A fully customised 3D
modelling service is also available delivering
high quality multimedia content for CD marketing
campaigns, exhibitions, education, digital
product brochures and streaming over the
internet http//www.3dsom.com/features/process.h
tml ttp//www.3dsom.com/proexamples/index.html.
44
LO 3.1 Details
Specifications

• a) Input Images
• Mat printing function to create calibration mats
  on an ordinary black and white printer.
• Accepts up to 256 input images per project from
  digital cameras or scanners as JPEG, BMP or PNG
  files.
• Fully automatic, robust camera calibration to
  identify arbitrary camera location and
  orientation.
• Automatic background separation (masking) tool
  with compensation for shadows on the backdrop.
• Manual mask editing tools at multiple image
  zooms.
• Mask save and load via PNG for editing in an
  external editor (Adobe Photoshop, JASC Paint Shop
  Pro and others).
• b) Wire frame Generation
• Fast and accurate, patented geometry calculation
  algorithm based on silhouettes without any
  voxelisation errors.
• Handles objects with holes and those composed of
  multiple separate parts generating one or more
  closed triangle meshes.
• Interactive mesh decimation to reduce polygon
  count to required level.
• Optional clip plane to remove any remaining stand
  geometry.
• Editable synthetic silhouettes allow geometry to
  be refined from angles where images were not
  originally taken.

45
LO 3.1 Details
Specifications

• c) Texture Generation
• Fully automatic texture tiling function to create
  a single texture map around the whole object.
• User chosen texture map resolution up to 2048
  pixels square.
• Patented texture blending algorithms to reduce
  registration errors and produce crisp textures.
• Tone correction option to compensate for exposure
  differences between images.
• Manual alignment option for including underneath
  shots to texture all faces of the object.
• Powerful, easy-to-use, seamless texture editing
  using your usual external image editor by
  painting on any view of the object.
• d) Save and Export
• Export final model to 3DSOM Viewer for immediate
  inclusion on web pages without need for browser
  plugins. We can also remove our branding on a
  per-model basis.
• 3DSOM Viewer can display a background image
  behind the model as well as adding lighting,
  shadows and hotspots in a small redistributable
  Java applet.
• Export to Shockwave for use in Macromedia
  Director 8.5 for creating interactive web
  content, and also as ready-to-use web page for
  use with popular Shockwave Player plugin.
• Export to VRML for interchange with many 3D
  packages and also for viewing with VRML-enabled
  browsers.
• Export to 3DS object for loading into 3D Studio
  Max and other 3D editing/animation packages.
• All project information saved in one project file
  
• Original images are not altered (can be read
  only) and left outside file to minimise project
  file size.

46
LO 3.1 Details
Specifications

• e) System Requirements
• 3DSOM runs under Windows XP (Home or
  Professional Editions) or Windows 2000.
  Although it is possible to run under a Windows
  emulator on a Macintosh, this is not
  recommended as intensive processing is
  required.
• Recommended specs for a PC
• CPU x86 compatible, PC/AT compliant
• Pentium 3 or 4 is preferable
• 32-bit graphics card with OpenGL support
• Monitor resolution 1024x768 minimum (small system
  fonts)
• Physical RAM 128MB minimum, 256MB recommended
• Mouse and Keyboard

47
LO 3.2 Abstract
VR WORX 2.5
QuickTime Virtual Reality is an extension of the
QuickTime technology developed by Apple Computer,
Inc. that allows viewers to interactively explore
and examine photo realistic, three-dimensional,
virtual world. Unlike many other virtual reality
systems, QuickTime VR does not require the viewer
to wear goggles, a helmet or gloves. Instead, the
viewer navigates in a virtual world using
conventional computer input devices (such as the
mouse, trackball, track pad or keyboard) to
change the displayed image via the QuickTime VR
movie controller. QuickTime VR is quickly
becoming one of the most important assets you can
have, bringing a new level of interactivity and
motion to web design and multimedia productions.
The user can create interactive QuickTime VR
movies quickly, simply and professionally, with
any kind of camera film, digital, video or
created on the computer using a three-dimensional
(3D) graphics package.
48
LO 3.2 Abstract
VR WORX 2.5
A QuickTime VR movie contains all the date for a
QuickTime VR virtual world. The movie contains a
single scene, which is an aggression of one or
more nodes. A node is a location in a virtual
world which an object or panorama can be viewed.
For panoramic nodes, the node's position is the
centre point from which the panorama is viewed.
Any number of nodes, objects, panoramas, linear
movies or stills, can comprise a QuickTime VR
Scene. The VR Worx is the award-winning suite
of VR authoring tools for QuickTime. The latest
version, The VR Worx 2.5 is taking advantage of
todays revolutionary operating systems.
Engineered for Mac OS X and Windows XP, with a
new streamlined and simplified user interface,
The VR Worx 2.5 delivers powerful technology
along with fresh advancements to its famous
feature/function set. The VR Worx 2.5 creates
cylindrical panoramic movies, object movies and
multi-node scenes (a.k.a. virtual tours), all in
the QuickTime format. Version 2.5 has the ability
to create an object movie, which has a panoramic
movie as a moving background. And v2.5 has the
capacity for transitions within a multi-node
scene, like standard wipes, dissolves, explodes,
and others, as well as actual linear video as a
transition. The VR Worx 2.5 can construct
multinode environments with cylindrical
panoramas, cubic VRs, multi-row objects, absolute
objects, objects with sound, still images and
linear QuickTime movies (http//www.vrtoolbox.com/
gallery.html).
49
LO 3.2 Details
VR WORX 2.5

• New Features Functions Include
• Streamlined and simplified User Interface for
  Macintosh Windows
• Live Scrolling, Live Window Resizing and Dialog
  Sheets
• Application-wide Image Drag Drop, including
  Document Proxy Icons
• Integrated On-line Help
• Intelligent Auto-configuration of Panoramas
  Objects
• Choice of Cylindrical or Linear input acquisition
  mode for Panoramas
• Integrated Bridge to external image editors, like
  Photoshop
• Zoom capability for images in Stitch Blend
  panels
• Drag Nudge capability for positioning images in
  Stitch panel
• User defined presets for quick composition of
  QuickTime movies
• Specify alternate target sizes with estimated
  download times
• Optimize media order for fast-start downloading
• Auto-generate low res preview track from movie or
  external image file
• Embed HTML tags and generate HTML "Starter Page"
  containing movie
• Recompose existing Object, Panorama and Linear
  QuickTime movies
• AppleScript Windows Visual Basic Scripting
  enabled throughout
• Improved handling of large images for Composition
  and Import/Export

50
LO 3.2 Details
VR WORX 2.5

• Chroma-Key Background Mask
• Frame Based Animation
• Centering, Cropping, and De-Wobbling Effects
• Integrated On-line Help
• Application-wide Image Drag Drop
• Auto-configuration of Panoramas Objects
• Cylindrical or Linear input acquisition for
  Panoramas
• Bridge to external image editors, like Photoshop
  
• Improved handling of large images for Movie
  Composition and Import/Export, exceeding 16,000
  pixels wide for source images and 30,000 pixels
  wide for imported or rendered panoramas
• Transparent View mode for precise stitching
• Over 250 Hot Spots per node
• Recompose existing Objects, Panos and Linear
  QuickTime movies
• Embed HTML tags generate HTML Starter Page
  containing your movie
• AppleScript Visual Basic Scripting for Windows
  enabled throughout
• Multinode Transitions, including linear video
  transitions
• Scene Module accepts Panoramas, Cubic VRs,
  Objects, Still Images and Linear Movies as Nodes
• Edit and Preview Multi-Node Scenes without
  rendering finished movie

51
LO 3.2 Details
VR WORX 2.5

• System Requirements for PC
• Pentium Class PC (or compatible
• Windows ME, 2000, XP (or higher)DirectX
  8QuickTime 6 or later 128 MB RAM
• b) System Requirements for Macintosh
• Power PC (or compatible)
• Mac OS X 10.2 (or higher)
• QuickTime 6 or later
• 128 MB RAM

52
LO 3.3 Abstract
PhotoModeler

• PhotoModeler is a powerful 3D software product
  that calculates measurements and constructs 3D
  models from your photographs simply and easily
  (http//www.photomodeler.com/app03.html).
• PhotoModeler is used by professionals around the
  world to
• Create "as-built" drawings and measurements for
  process and plant engineers
• Measure accident and crime scenes for forensic
  analysts
• Create "as-found" and "as-built" drawings for