Bi-kipedia SAP HANA SAP HANA is an in-memory database platform for processing high volumes of operational and transactional data in real-time. Dimanche, 22 mars 2015
Bi-kipedia Normalize The state of a database when all repeated values within the database have been removed by creating more tables. Relational OLTP systems are usually highly normalized. Data warehouses typically are not highly normalized.Normalizing data is a process defined by E.F. Codd and boils down to structuring the data into separate and multiple tables to avoid redundancy in the data. Dimanche, 22 mars 2015
Bi-kipedia Denormalize This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment. Dimanche, 22 mars 2015
Bi-kipedia Driver. parameters Drivers are parameters that are used in allocations. A frequently used driver in eg. budgeting is the sales amount. Dimanche, 22 mars 2015
Bi-kipedia Alert Alerts and notifications refer to any automated signals or short messages that may be sent through a SMS, an email or an indicator in a dashboard or report. They are a call to action after a specific event has occurred. They are also used to assign tasks or inform the recipients about certain urgent issues. Alerts can be the result of the outcome of a report or specific queries. Dimanche, 22 mars 2015
Bi-kipedia Data Mapping Data mapping is a process of defining a link between two distinct data models. It is used in software engineering to describe ideal ways to represent and access any form of information. It is used in data warehousing by linking source data models to target data models and additional for describing any transformations between these two models. Dimanche, 22 mars 2015
Bi-kipedia View A view is the way of depicting information in a database. Some options of viewing your data are to arrange your data items in a specific order, re-label, hide or to pre-aggregate certain fields. Dimanche, 22 mars 2015
Bi-kipedia Structured query language (SQL) A structured query language (SQL) is the standard language for a relational database. The Structured Query Language uses a classic English keyword-oriented set of commands to query, describe, manipulate, and manage data. Dimanche, 22 mars 2015
Bi-kipedia Scheduling Scheduling takes into account different tasks, the time, and the resources to be deployed in order to complete these tasks. It is the ability to determine when a particular process will take place in the future, with special consideration on resource availability, activities, and time constraints. Dimanche, 22 mars 2015
Bi-kipedia Role-based security A role-based security is a user-level security feature that allows you to restrict access to a certain feature in the system based on the user role.In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks. Dimanche, 22 mars 2015