Published on Feb 14,2018
1.7K Views
Email Post

Metadata- Concept

Metadata is data about data. Though the second term is used in the preview of types like technical, business and process. It maps the physical data structure to a more logical business model. In the video it has the domain model and the metadata terms.

The domain model has elements like Email, Person & Priority. The metadata terms include items like Subject, Receive Date, Sent Data, Sent From, Sent to, Priority Level and Priority Type. It is the data that describes Business Intelligence like:

  • Mapping
  • Aggregations
  • Transformations
  • Rules

Pentaho Metadata Editor Tool – It’s a tool for designing the metadata model. It maps the physical structure to the business model so that the business user understands it.  This mapping between physical and logical data is stored in centralized repository.

It creates business-specific data dictionary that facilitates better understanding of the model. Here, the business terms is on top of the data terms in order to be understandable.  One can also define what kind of access we can give to the user and what object we want to expose to. We can also localize the language.

We first have to assign to which database we must connect to and the data model has business terms. The sample metadata model contains customers and the order details.

The relationships are defined as one-to-many, many-to-one, many-to-many and so on.

Pentaho Metadata Model

  • Pentaho Metadata Editor (PME) has metadata business model as one major component as shown
  • In the representation, each independent business object has its unique colour. Pentaho domain has business objects as connection, physical table, physical column, business table, business column and category.
  • First relationship ‘INHERITS FROM’ inherits the metadata with ability to override it.
  • Whereas ‘SAME BUSINESS OBJECT’ has two objects actually one and the same.

Got a question for us? Mention them in the comments section and we will get back to you. 

Related Post:

Pentaho for Business Analytics

Pentaho BI Training

About Author
edureka
Published on Feb 14,2018

Share on

Browse Categories

Comments
0 Comments