Algorithms used to obtain aggregated value sets from relational databases

Professor Mirela-Catrinel Voicu
Faculty of Economic Sciences,
West University of Timişoara,
ROMANIA
E-mail: mirela.voicu@fse.uvt.ro
Web Site: http://www.fse.uvt.ro
Abstract: For n fields used for grouping we can obtain
2n
aggregation
types. When n is not small,
2n
is a considerable value. With a new model for
the specification of aggregation types, we present ways in which we can obtain
any subsets of aggregation types, starting from n fields used for grouping.
The algorithms concern cases in which:
- The specification of aggregation types is made after we insert the data in
the tables.
- The specification of aggregation types is made before we insert the data in
the tables. In order to obtain the results really fast, we also use
hypercubes.
- The case of one table (the fields used for grouping and for aggregation are
from the same table) where we use one hypercube and we can specify the
aggregation types in any moment (after or before the data insertion in the
table) - model which can be used for questionnaires.
These algorithms can be used in many economic analyses, in order to obtain
complex reports. We will also present an example which concerns the sales in a
supermarket chain.
Brief Biography of the
Speaker:
Mirela-Catrinel Voicu is born in Romania, 1972 and graduated in 1995 of
Faculty of Mathematics and Computer Sciences, West University of Timisoara.
She received the MSc degrees in Applied Mathematics, Informatics in Economy
and Computer Sciences from the West University of Timisoara. She stayed for
training course for PhD thesis at National Institute for Statistics and
Economic Studies, Paris, France. She received her PhD in 2001 from the
University of Timisoara, Romania (with the distinction “Cum laude”) and from
the University of Paris 13, France (with the distinction “Très honorable avec
félicitations“). Currently she is Associate Professor in the Department of
Economic Informatics, Faculty of Economic Sciences, West University of
Timisoara, Romania, where since 1995 she has been holding academic positions.
She has teaching activity in Programming and Internet Programming, Informatics
in Economy, Databases, OOP, Data structures, Exchange rate evolutions
models-course. She has 59 papers in conference proceedings or refereed
journals (from these papers, 11 are presented or published abroad). She has
published 7 books (1 book in France and 6 books in Romania). She is reviewer
and member in international program committee of 5 WSEAS conferences from
abroad, member in the teams of 9 research projects (nationals and
international) and project manager for one research project. Since 2002, she
is member INFOREC (Romanian Association for Economic Informatics Training
Promotion) and since 2005 is member WSEAS (World Scientific And Engineering
Academy And Society).