Ligas: 1.https://aprenderly.com/doc/2015859/procesamiento-y-analisis-en-linea-olap 2.http://tmec18.blogspot.com/2016/11/procesamiento-y-analisis-en-linea-olap.html
Datos: Lòpez Lòpez Shaira Itzel Tarea: 26 Mapa Mental
Procesamiento y Análisis En Línea (OLAP).
Type in the name of the book you have read.
Comparaciones
Type the main events of the book, classifying them in: events from the beginning, events from the middle, and events from the end of the book.
Describe the story visually. Add a representative picture for each of them.
MOLAP separada.
base de datos
las agregaciones
en datos más grandes
Type the main events from the end.
Add a representative picture for each of them.
MOLAP
multidimensionales
en cubos de datos
luego son almacenados
pre calculados
Los datos son
Type the main events from the middle.
Add a representative picture for each of them.
ROLAP
por separado.
no son almacenados
datos relacional
directamente desde el Datawarehouse
Los datos son accedidos
Type the main events from the beginning.
Add a representative picture for each of them.
Utilidades de OLAP
diferentes perspectivas.
Take notes while you read the book. Write here your favorite quotes from the book.
Beneficios de OLAP
In contrast to the main idea, the theme is the message, lesson or moral of the book.
Some tips to find out the theme of the book easier:
- Try to find it while you are reading. It may be stated or implied.
- Think about how the characters reacted to obstacles.
- Think about the important decisions that the characters made.
- Think about the characters growing or changing throughout the book.
cantidades de datos.
periodos jerárquicos.
datos agregados.
consultas de usuarios.
elementos de datos.
complejos
flexible para los usuarios
Requerimientos Funcionales de los Sistemas OLAP
Take notes while you read the book. Type here the resources, books, or websites that the author mentioned and you want to check out later.
consulta de datos.
herramientas
segundo servidor
sea altamente escalable
servidor
Operadores para el manejo de cubos de datos
Descenso
Ascenso
Dado
PIVOT
SLICE (Rebanada)
GROUPING SETS
DRILLDOWN
ROLLUP
CUBE
Operadores
HOLAP
multidimensional separada.
se almacenan en una base de datos
resumidos o agregados
base de datos relacional
los registros detallados
sistemas mantienen
ROLAP OLAP
datos multidimensional.
en una estructura
se encuentran almacenados
sistemas los datos
The main idea is what the book is mostly about.
Some tips to find out the main idea of a book easier:
- Read the title.
- Look for the text features.
- Figure out if you are reading a fiction or a non fiction book.
- Think about some examples that support this idea.
A que Se Refiere Los Tipos De Sistemas OLAP
Type the names of the book characters. Start with the main character.
Draw arrows to represent the relationship between them and if it is possible write on them what they represent for each other (if they are relatives, friends, lovers, enemies etc.)
Analítico Híbrido en Línea
Analítico multidimensional en Línea
1
What are the characteristics that best describe the character? Type them here.
(Procesamiento Analítico Relacional en Línea)
Tipos de Sistema OLAP
What is the reason why the author wrote the book?
3.HOLAP
2.MOLAP
1.ROLAP
Concepto OLAP
Who is the author of the book? Type in his/her name.
Tipo de información útil.
Para extraer
Cantidades de datos
Consulta de grandes
Inteligencia de negocios
On-Line Analytical Processing
Procesamiento analítico en línea
