Data/hora: 22/06/2024 00:44:31

Biblioteca(s): 	Embrapa Agricultura Digital.	
Data corrente: 	18/03/1998	
Data da última atualização: 	25/11/2013	
Autoria: 	MELO, R. N.	
Título: 	Tutorial on data warehouse technology.	
Ano de publicação: 	1997	
Fonte/Imprenta: 	In: SIMPÓSIO BRASILEIRO DE BANCO DE DADOS, 12., 1997, Fortaleza. Anais... Fortaleza: UFC, 1997.	
Páginas: 	p. 8.	
Idioma: 	Inglês	
Notas: 	SBBD'97. Editado por Vânia Maria Ponte Vidal.	
Conteúdo: 	This tutorial provides an overview of the technologies used in building an infrastructure to support a data warehouse and OLAP (On Line Analytical Processing) applications. Participants will clearly understand the architecture of a data warehouse, and the fact that a number of components and processes contribute to the overall product. The tutorial will ensure users understand how OLAP differs from OLTP (On Line Transaction Processing) and the fundamental difference between relational systems and multidimensional systems. We will examine topics including: Data vs information; Operational vs analytical needs; The definitions of OLTP and OLAP; Analytical problems to be handled through multidimensional analysis; Analytical problems to be handled through relational systems (ROLAP); An overview of data warehouse architecture; OLTP database overview; Data from external sources; Extraction and propagation requirements; Transformation and cleansing requirements; Metadata and what it means; Star-join schema for fact tables, measurements, facts, fact records, dimensions, attributes and time; Showflake schema; Data refining; Aggregation and propagation; Data Marts; OLAP tools and presentation tools. In summary, uponcompletion, students should understand the different types of database techniques that support data warehouses and their applications. They should also understand different techniques and tools for extracting data from operational systems to the data warehouse and for building applications on top of the data warehouse.	
Palavras-Chave: 	Banco de dados.	
Thesaurus Nal: 	Databases.	
Categoria do assunto: 	--	
Registro original: 	Embrapa Agricultura Digital (CNPTIA)	
Exemplares: 	CNPTIA - (6744-1) - ADD - PL - PP - 005.74 - SIM - 1997.00018 - DIS