BEGIN:VCALENDAR
VERSION:2.0
PRODID:www.dresden-science-calendar.de
METHOD:PUBLISH
CALSCALE:GREGORIAN
X-MICROSOFT-CALSCALE:GREGORIAN
X-WR-TIMEZONE:Europe/Berlin
BEGIN:VTIMEZONE
TZID:Europe/Berlin
X-LIC-LOCATION:Europe/Berlin
BEGIN:DAYLIGHT
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
DTSTART:19810329T030000
RRULE:FREQ=YEARLY;INTERVAL=1;BYMONTH=3;BYDAY=-1SU
END:DAYLIGHT
BEGIN:STANDARD
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
DTSTART:19961027T030000
RRULE:FREQ=YEARLY;INTERVAL=1;BYMONTH=10;BYDAY=-1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:DSC-12363
DTSTART;TZID=Europe/Berlin:20170120T130000
SEQUENCE:1484899018
TRANSP:OPAQUE
DTEND;TZID=Europe/Berlin:20170120T140000
URL:https://dresden-science-calendar.de/calendar/en/detail/12363
LOCATION:TUD Andreas-Pfitzmann-Bau\, Nöthnitzer Straße 4601069 Dresden
SUMMARY:Theodorou: Automating User-Centered Design of Data-Intensive Proces
 ses
CLASS:PUBLIC
DESCRIPTION:Speaker: M. Sc. Vasileios Theodorou\nInstitute of Speaker: Inst
 itut für Systemarchitektur\, Professur Datenbanken\nTopics:\nInformatik\n
  Location:\n  Name: TUD Andreas-Pfitzmann-Bau (APB 1004 (Ratssaal))\n  Str
 eet: Nöthnitzer Straße 46\n  City: 01069 Dresden\n  Phone: \n  Fax: \nDe
 scription: Business Intelligence (BI) enables organizations to collect and
  analyze internal and external business data to generate knowledge and bus
 iness value\, and provide decision support at the strategic\, tactical\, a
 nd operational levels. The consolidation of data coming from many sources 
 as a result of managerial and operational business processes\, usually ref
 erred to as Extract-Transform-Load (ETL) is itself a statically defined pr
 ocess and knowledge workers have little to no control over the characteris
 tics of the presentable data to which they have access. There are two main
  reasons that dictate the reassessment of this stiff approach in context o
 f modern business environments. The first reason is that the service-orien
 ted nature of todays business combined with the increasing volume of avail
 able data make it impossible for an organization to proactively design eff
 icient data management processes. The second reason is that enterprises ca
 n benefit significantly from analyzing the behavior of their business proc
 esses fostering their optimization. Hence\, we took a first step towards q
 uality-aware ETL process design automation by defining through a systemati
 c literature review a set of ETL process quality characteristics and the r
 elationships between them\, as well as by providing quantitative measures 
 for each characteristic. Subsequently\, we produced a model that represent
 s ETL process quality characteristics and the dependencies among them and 
 we showcased through the application of a Goal Model with quantitative com
 ponents (i.e.\, indicators) how our model can provide the basis for subseq
 uent analysis to reason and make informed ETL design decisions. In additio
 n\, we introduced our holistic view for a quality-aware design of ETL proc
 esses by presenting a framework for user-centered declarative ETL. This in
 cluded the definition of an architecture and methodology for the rapid\, i
 ncremental\, qualitative improvement of ETL process models\, promoting aut
 omation and reducing complexity\, as well as a clear separation of busines
 s users and IT roles where each user is presented with appropriate views a
 nd assigned with fitting tasks. In this direction\, we built a tool-POIESI
 S-which facilitates incremental\, quantitative improvement of ETL process 
 models with users being the key participants through well-defined collabor
 ative interfaces. When it comes to evaluating different quality characteri
 stics of the ETL process design\, we proposed an automated data generation
  framework for evaluating ETL processes (i.e.\, Bijoux). To this end\, we 
 classified the operations based on the part of input data they access for 
 processing\, which facilitated Bijoux during data generation processes bot
 h for identifying the constraints that specific operation semantics imply 
 over input data\, as well as for deciding at which level the data should b
 e generated (e.g.\, single field\, single tuple\, complete dataset). Bijou
 x offers data generation capabilities in a modular and configurable manner
 \, which can be used to evaluate the quality of different parts of an ETL 
 process. Moreover\, we introduced a methodology that can apply to concrete
  contexts\, building a repository of patterns and rules. This generated kn
 owledge base can be used during the design and maintenance phases of ETL p
 rocesses\, automatically exposing understandable conceptual representation
 s of the processes and providing useful insight for design decisions. Coll
 ectively\, these contributions have raised the level of abstraction of ETL
  process components\, revealing their quality characteristics in a granula
 r level and allowing for evaluation and automated (re-)design\, taking und
 er consideration business users quality goals.
DTSTAMP:20260617T120150Z
CREATED:20170110T075119Z
LAST-MODIFIED:20170120T075658Z
END:VEVENT
END:VCALENDAR