|
Plenary
Lecture
Relational Algebra Applications in Web Programming
Professor Mirela-Catrinel Voicu
Faculty of Economics and Business Administration
West University of Timisoara, Romania
E-mail:
mirela.voicu@feaa.uvt.ro
Abstract: Many websites of e-commerce, e-tourism or
other e-activities propose different communication tools
to consumer. For example, on the website
http://www.booking.com/ the user can perform searches
by: country, city, price range per night, period, star
rating, hotel type, facilities, hotel theme, district,
chains, etc., when it comes to booking hotels rooms. On
the website http://www.sarenza.com/ the user can buy
shoes selecting the following features: type, brand,
size, colour, style, heel, season, material, prix, etc.
In the same way, we can recall very popular websites
such as http://www.amazon.com/,
http://www.treather.com/, http://www.alibaba.com/, etc.
and many other worldwide websites.
In our study we are focused on B2C websites and our goal
is to provide tools with which the consumer can specify
different criteria in order to select products. We
consider the case in which the website data are stored
in a relational database. Generally, the consumer
desired products correspond to records from a query
result. Usually, this result table is obtained selecting
fields from one or many tables, using table
relationships and respecting some criteria. We start
from idea that in databases with a very high number of
records, when the number of tables used in relationships
and the number of criteria are not small, the
traditional way used to explore the relational database,
in certain situations, cannot be easily implemented. In
order to provide a solution to this problem, we propose
an algorithm, using concepts from relational algebra. We
start from a particular database and we propose some
criteria for selection, pointing out some difficulties
using traditional algorithm. Afterwards, we present our
new algorithm and finally we present a generalization
for an abstract case.
Brief Biography of the Speaker:
Mirela-Catrinel Voicu was born in Romania. In 1995, she
graduated from the Faculty of Mathematics and Computer
Sciences, West University of Timisoara. She received the
MSc degree in Applied Mathematics, Informatics in
Economy and Computer Sciences from the West University
of Timisoara. She followed a training course for PhD
thesis at the National Institute for Statistics and
Economic Studies, Paris, France. She received her PhD in
2001 from the University of Timisoara, Romania (with the
"Cum laude" distinction) and from the University of
Paris 13, France (with the "Tres honorable avec
felicitations" distinction). Currently she is a
Professor at the Department of Economic Informatics,
within the Faculty of Economics and Business
Administration, West University of Timisoara, Romania,
where, since 1995, she has held several academic
positions. Her activity includes Programming and
Internet Programming, Informatics in Economy, Databases,
OOP, Data structures. Through the collaboration program
between the Faculty of Economics and Business
Administration and the Faculty of Mathematics and
Informatics of the West University, she has held classes
with international participation, in postgraduate
education, in the section of "Mathematic modelling in
economics and applied sciences" Exchange Rate Evolution
Models subject introduced within the program due to the
original contributions in her PhD. During the
collaboration between the Faculty of Economics and
Business Administration, West University of Timisoara
and CUOA Italy, she has taught a postgraduate class for
the section of "Management of Business and Public
Administration", regarding the Internet. She has 79
papers in conference proceedings or refereed journals
(from these papers, 26 have been presented or published
abroad). She has published 8 books (1 book in France, 1
book in Germany and 6 books in Romania). She is a
reviewer and a member in international program committee
of various WSEAS conferences from abroad, reviewer at
"Journal of Knowledge, Communications and Computing
Technologies", member in the teams of 9 research
projects (one of which is international) and project
manager for one research project. Since 2002, she is a
member of INFOREC (Romanian Association for Economic
Informatics Training Promotion), since 2005, she is a
member of WSEAS (World Scientific and Engineering
Academy and Society) and since 2009, she is a member of
SCT (Society for Computing Technologies).
|
|