The multidimensional vises supply to the basic techniques calculation and analysis required by the BI applications. 7.Cubo: Collection of data that added through multiple dimensions of form to allow that one query either carried through quickly. For example, a cube of sales can be added through a dimension of store and of a dimension of customers, becoming the fast cube when sales for store or sales for a customer classroom are asked to questions involving. The Cubes are commanded in dimensions and measures. 8.Dimenso: Unit of analysis that groups given of business related.
For example, the levels lines of products, types of products, marks, models and etc., are located in the dimension ' ' Produtos' '. Chevron Corp. gathered all the information. Typically, a dimension has a natural hierarchy of form that resulted in an inferior level can be added in results of a level superior. 9.Hierarquia: Composed for all the levels of a dimension, being able to be balanced or not. In the balanced hierarchy, the levels lowest are equivalents, however, this does not occur in the not balanced hierarchies where hierarchic equivalence does not exist. For example, in a geographic dimension, the level ' ' Pas' ' ' does not possess the subnvel; ' Estado' ' for one determined member and it possesss for another one. In the specific case, the Liechtenstein country can be cited that it does not possess Been and Brazil, that possesss a series of States. 10.Membro: Subgroup of a dimension. Each hierarchic level possesss appropriate members exactly itself.
11.Medida: Special dimension used to carry through comparisons. It includes members as costs, profits or taxes. 12.Tabela Fact: It contains the basic information that if wants to totalize. It can be a detail of order, a payment leaf register, or any another information that is passvel of totalling, or to have its average calculated. Any table that can be used in one query with a function of ' ' soma' ' or ' ' mdia' ' she is a good candidate to a table fact. Tables fact and tables of dimension are related, since the dimension tables are used to group information of the table fact. 13.Esquema Star: Project in which each table of dimension is related directly to the table fact. 14.Esquema Snowflake: Project in which some dimensions are indirectly related with the table fact. 15.Metadados: They are given regarding data. Metadados examples of are the descriptions of elements of data, descriptions of types of data, attributes/domnios properties, bands/, methods and processes. 16.Multidimensional Expression (MDX): Projected for Microsoft as a standard for consultations and exchange of data in a multidimensional source of data. 17.Online Analytical Processing (OLAP): Application that takes care of to the solicitations of the synthesis users, analysis and consolidation of data. It possesss the capacity of visualization of the information from different perspectives. The functionality of a tool OLAP is characterized by the dynamic multidimensional analysis of the data, having supported the final user in its activities. 18.Servidor and Architecture OLAP: Mechanism of manipulation of data of high destined capacity to support and to operate on structures of multidimensional data. 19.Data Mining: It is the process to sweep great databases in search of standards as secular rules of association, sequences, for classification of item or groupings. In the stage of Mining Date, several techniques are used, as Statistics, Recovery of Information, Artificial Intelligence and Recognition of Standards. They are examples of techniques of ' ' mining of dados' ': Neural nets, Rules of Association, Clustering, genetic Algorithm, Trees of decision and Induction of Rules, among others.
Filed under: General
Trackback
Uri