Bi-kipedia SQL Query A query is a question to a database, translated in a SQL-language which results in a particular data set being returned. Jeudi, 7 août 2014
Bi-kipedia Snowflake schemas Two "dimensional modeling” techniques are generally used for modeling the data structures within a data warehouse context. These are the "star schema” and "snowflake schema” techniques. Both find their roots within the Kimball dimensional modeling techniques. Properties of the snowflake schemas : Jeudi, 7 août 2014
Bi-kipedia Microsoft SQL Server Data Quality Services - DQS SQL Server Data Quality Services (DQS), new since SQL Server 2012, is a knowledge-driven data quality product. Jeudi, 7 août 2014
Bi-kipedia Microsoft SQL Server Database Services The SQL Server Database Engine is the core service for storing, processing and securing data within Microsoft SQL Server.The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within the enterprise.The Database Engine also provides rich support for sustaining high availability. Jeudi, 7 août 2014
Bi-kipedia Microsoft SQL Server Database Engine Tuning Advisor The Microsoft SQL Server Database Engine Tuning Advisor helps you to optimize database configuration by identifying an optimal set of indexes, indexed views and partitions without requiring an expert understanding of the database structure. It advises you by analyzing a certain workload by using trace files, trace tables or T-SQL scripts as input.The Database Engine Tuning Advisor will then give you certain recommendations to add, remove or modify certain settings in your Microsoft SQL Server database. Jeudi, 7 août 2014
Bi-kipedia Microsoft Columnstore Indexes A "columnstore” index within Microsoft SQL Server 2012 stores each column in a separate set of disk pages, rather than storing multiple rows per page which is the way data is stored traditionally.Benefits of this are: Jeudi, 7 août 2014
Bi-kipedia SAP BW InfoObject This is the lowest level of metadata existing in the SAP Business Warehouse.There are two main types of InfoObjects: characteristics – representing dimensions for analysis - and key figures – representing the numeric data to be analyzed. The metadata definition consists of technical properties (Data Type, length, conversion routine, …) and descriptive properties (text and attribute Master Data, hierarchies, navigation properties, …). Jeudi, 7 août 2014
Bi-kipedia SAP BW InfoProvider There are different objects available in SAP BW for reporting, which can all be described as InfoProviders because they are holding and providing information to the end user of SAP Business Intelligence. Examples of InfoProviders are: Jeudi, 7 août 2014
Bi-kipedia SAP BW Multiprovider The MultiProvider does not represent physical tables, but is defined as a view on other InfoProviders like InfoCubes, DataStore Objects, InfoObjects, … It is also represented as a dimensional model, and the InfoObjects inside this model are mapped to the physical InfoProviders. It is a best practice to always build your queries on a MultiProvider, for reasons of extensibility and re-usability. Jeudi, 7 août 2014
Bi-kipedia SAP BW InfoCube The BW InfoCube is the star-scheme modelled InfoProvider optimized for multidimensional analysis. It is based on an ‘extended’ star scheme that models the Master Data outside the dimension tables. The InfoCube allows 16 dimensions (containing multiple InfoObjects) and multiple key figures. Jeudi, 7 août 2014