48 documents found, page 1 of 5
Task clustering on ETL systems – A pattern-oriented approach
Oliveira, Bruno; Belo, O.Usually, data warehousing populating processes are data-oriented workflows composed by dozens of granular tasks that are responsible for the integration of data coming from different data sources. Specific subset of these tasks can be grouped on a collection together with their relationships in order to form higher- level constructs. Increasing task granularity allows for the generalization of processes, simpli...
Defining energy consumption plans for data querying processes
Gonçalves, R.; Saraiva, João Alexandre; Belo, O.During the last few years, we have been witnessing a significant increase in research about the development and production of hardware and software components with low levels of energy consumption. Today, energy consumption is one of the most critical issues in the area of information technologies and communication. One of the fractions in which this concern is most evident is in the management of database syst...
Conceptual-physical bridging – From BPMN models to physical implementations on ...
Oliveira, Bruno; Santos, Vasco; Gomes, Cláudia; Marques, Ricardo; Belo, O.Developing and implementing data-oriented workflows for data migration processes are complex tasks involving several problems related to the integration of data coming from different schemas. Usually, they involve very specific requirements - every process is almost unique. Having a way to abstract their representation will help us to better understand and validate them with business users, which is a crucial s...
7to77, A new database querying experience
Martins, João; Belo, O.Nowadays, the vulgarization of information and communication technologies has reached to a level that the majority of people spend a lot of time using software to do regular tasks, ranging from games and ordinary time and weather utilities to some more sophisticated ones, like retail or banking applications. This new way of life is supported by the Internet or by specific applications that changed the image peo...
Using a domain-specific language to enrich ETL schemas
Belo, O.; Gomes, Cláudia; Oliveira, Bruno; Marques, Ricardo; Santos, VascoToday it is easy to find a lot of tools to define data migration schemas among different types of information systems. Data migration processes use to be implemented on a very diverse range of applications, ranging from conventional operational systems to data warehousing platforms. The implementation of a data migration process often involves a serious planning, considering the development of conceptual migrat...
Using relational algebra on the specification of real world ETL processes
Santos, Vasco; Belo, O.Modeling Extract-Transform-Load (ETL) processes of a Data Warehousing System has always been a challenge. The heterogeneity of the sources, the quality of the data obtained and the conciliation process are some of the issues that must be addressed in the design phase of this critical component. Commercial ETL tools often provide proprietary diagrammatic components and modeling languages that are not standard, t...
A domain-specific language for ETL patterns specification in Data Warehousing S...
Oliveira, Bruno; Belo, O.During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirem...
Integrating usage analysis on cube view selection – An alternative method
Rocha, Daniel; Belo, O.One of the best ways to make an effective selection of data cube views is based on monitoring multidimensional queries during a relevant number of OLAP sessions. This allows to understand how and when a data cube is explored, collecting and analysing the views that decision agents use to consult. This is very important, because it deals directly with the optimisation of resources, namely the ones related to sto...
Categorização do consumo de energia em sistemas de povoamento de Data Warehouses
Guimarães, Miguel; Saraiva, João Alexandre; Belo, O.Os recursos computacionais exigidos durante o processamento de grandes volumes de dados durante um processo de povoamento de um data warehouse faz com que a necessidade da procura de novas implementações tenha também em atenção a eficiência energética dos diversos componentes processuais que integram um qualquer sistema de povoamento. A lacuna de técnicas ou metodologias para categorizar e avaliar o consumo de ...
An artificial tutor for teaching portuguese using the method of João de Deus
Belo, O.; Silva, DiogoOver the past few years we have been witnessing to an unprecedented integration of software applications in various domains. From simple applications in retail systems to highly sophisticated products installed on personal devices, we recognize the usefulness of these products in the daily lives of people, giving them support into their most mundane activities or providing simple means of entertainment and fun ...