Vol.8/No.1 (2016) INTERNETWORKING INDONESIA JOURNAL 95
ISSN: 1942-9703 / © 2016 IIJ
Abstract—In this paper, it is conducted an analysis of the
two dashboards that applied metadata, they are "Metadata for
Creating and Displaying Dashboard" and open source Pentaho
dashboard. The analysis is to determine whether the metadata
of the dashboard has met the metadata structure of data
warehouse by comparing each metadata component of both
dashboards to the metadata structure of data warehouse.
Metadata component of each dashboard that meets the
metadata structure of data warehouse will be combined to
produce a new prototype named Meta ++.
Besides Meta ++ as a blueprint of the combined metadata,
there should be a generator for generating metadata based on
inputs provided. Meta ++ will be used to assist the performance
of metadata generator in generating real metadata. A metadata
in the form of XML file will be generated by metadata
generator that based on the information needs input from the
user.
Index Terms—dashboard, generator, metadata, Pentaho.
I. INTRODUCTION
A. Background
REVIOUS research related to the development of
metadata for dashboard has been considered in [1] using
XML as metadata format because XML is flexible and
supports writing of tags according to user requirements and
can be used on a variety of platforms. The reference [1] uses
descriptive metadata that plays an important role in
describing the data. An important reason for creating
descriptive metadata is to facilitate discovery of relevant
information. In addition to resource discovery, metadata can
help to organize electronic resources, to facilitate
interoperability and legacy resource integration, to provide
digital identification, and to support archiving and
preservation [3]. Descriptive metadata is well in displaying
the details of the entire data but missed data structure and
data identification structure [1].
On the other hand, the second related work that will be
analyzed and compared is an open source dashboard that
applied metadata, named Pentaho. Pentaho dashboard
provides an integrated features to do analysis, for this
reason, it is widely used by businesses to produce data; in
addition to that Pentaho is sturdy because it was built for a
Manuscript received July 28, 2015. This paper with title “Metadata of
Dashboard Data Source Based on Study of Pentaho Dashboard Metadata”
was supported by Del Institute of Technology.
Rosni Lumbantoruan, is with Del Institute of Technology, Indonesia.
She is now with the Department of Information System (e-mail:
rosni@del.ac.id).
Agnes Juliana Siregar, Erikson Matondang and Marisa Helen Gultom
were students in Informatics Engineering Department, Del Institute of
Technology, Indonesia.
long time, and strong in terms of visualization and data
unlimited sources and able to accommodate millions of lines
of information [2].
The study is conducted to generate metadata that is
capable of displaying data as a structured together with its
identity that makes the data uniquely identified; this is
consistent with the data warehouse metadata attributes.
Hence, a comparison is done against the data warehouse
metadata to get better metadata results. Each metadata
attribute of both studied dashboards, namely 1) open source
Pentaho dashboards and 2) dashboard results of the study
entitled "Metadata for Creating and Displaying Dashboard"
is analyzed and compared to the metadata structure of data
warehouse. Metadata of the both dashboards that meets the
criteria of data warehouse metadata structures will be
combined to form a metadata prototype called the Meta ++.
To support the creation of metadata that meets the
requirements of users, a metadata generator is developed.
Meta ++ is used as a guideline for metadata generator to
generate an actual metadata in the form of XML.
Furthermore, Meta ++ is applied to the previous developed
application dashboard in [1].
B. Objectives
The aim of this study is to analyze the implementation of
the conformity of open source Pentaho dashboards metadata
and dashboard results of the study "Metadata for Creating
and Displaying Dashboard" to metadata structure of data
warehouse [9]. It is then to compile metadata prototype for
the metadata improvement that will be applied to the
dashboard resulted [1] and later it will be named Meta++.
II. LITERATURE STUDY
A. Metadata
Metadata is often called data about data or information
about information. Metadata is structured information that
describes, explains, locates, or otherwise makes it easier to
retrieve, use, or manage an information resource. Metadata
is a key to ensuring that resources will survive and continue
to be accessible into the future [3]. Based on NISO, there are
three main types of metadata as follow:
a) Descriptive Metadata: describes a resource for purposes
such as discovery and identification. It can include
elements such as title, abstract, author, and keywords.
b) Structural Metadata: indicates how compound objects
are put together, for example, how pages are ordered to
form chapters.
c) Administrative Metadata: provides information to help
manage a resource, such as when and how it was
Metadata of Dashboard Data Source Based on
Study of Pentaho Dashboard Metadata
Rosni Lumbantoruan, Agnes Juliana Siregar, Erikson Matondang and Marisa Helen Gultom
P