Bo universe (semantic layer) Design

Knowledge Structure 1. SQL Statement 2. Rdmbs System Knowledge 3. Familiar with database data types and logical structures Task : Design Create Maintenance Universe Distribution Universe Metadata Layer Create Universe ---- Business Object The metadata layer is built on Universe. Class and Object Mode Universe What is Universe Is the data structure of the database ( Business-oriented ing of tables, columns, and connections. What is a class? Class is Universe Logical grouping of objects. Usually The class name reflects the business concept and reflects the type and type of objects. What is an object? The object is Universe The most specific embodiment. The data or data School in the database mapped to the object. What are the types of objects? Dimension Details and Measurements Dimension objects are parameters used for analysis. The detailed object provides a description for the dimension object. A measurement object is a numerical value that measures a dimension object. Summary: Data or data dispatching in an object ing Database For multi-dimensional analysis, objects are limited to one of the following three types: Dimensions, details, and measurements. Class is the aggregation of Objects Based on business types. Universe It is an aggregation of images for a specific application or user group class.