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. In our study we
have worked with databases from Access and we have made the algorithm
implementation in
Delphi,
but the implementation can also be made in other programming environments and
we can also use other relational databases.
Brief Biography of the
Speaker:
Mirela-Catrinel Voicu was born in Romania, in 1972. 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 “Très honorable avec
félicitations“ distinction). Currently she is Professor of the Department of
Economic Informatics, within the Faculty of Economic Sciences, 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 Economic Sciences 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 Modeling in economics and applied sciences” – Exchange Rate
Evolution Models – subject introduced within the program due to the original
contributions in she’s PhD. During the collaboration between the Faculty of
Economic Sciences, West University of Timisoara and CUOA – Italy, she has
taught in postgraduate university, “The Management of Business and Public
Administration”, the subject, Internet. She has 60 papers in conference
proceedings or refereed journals (from these papers, 12
have been
presented or published abroad). She has published 7 books (1 book in
France and 6 books in Romania). She is a reviewer and a member in
international program committee of 6 WSEAS conferences from abroad, 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) and since
2005 is a member of WSEAS (World Scientific And Engineering Academy And
Society).