Refine
Has Fulltext
- no (3984) (remove)
Year of publication
Document Type
- Doctoral Thesis (3984) (remove)
Keywords
- Deutschland (8)
- photosynthesis (5)
- Arabidopsis thaliana (4)
- Klimawandel (4)
- metabolomics (4)
- migration (4)
- Bundeswehr (3)
- Kunstgeschichte (3)
- Migration (3)
- Photosynthese (3)
Institute
- Institut für Biochemie und Biologie (659)
- Institut für Chemie (375)
- Institut für Physik und Astronomie (375)
- Wirtschaftswissenschaften (310)
- Öffentliches Recht (241)
- Bürgerliches Recht (217)
- Historisches Institut (198)
- Institut für Geowissenschaften (179)
- Institut für Ernährungswissenschaft (178)
- Institut für Informatik und Computational Science (121)
Aktives kommunales Debt Management : Wege zu mehr Effizienz bei der kommunalen Fremdfinanzierung
(2008)
The introduction of columnar in-memory databases, along with hardware evolution, has made the execution of transactional and analytical enterprise application workloads on a single system both feasible and viable. Yet, we argue that executing analytical aggregate queries directly on the transactional data can decrease the overall system performance. Despite the aggregation capabilities of columnar in-memory databases, the direct access to records of a materialized aggregate is always more efficient than aggregating on the fly. The traditional approach to materialized aggregates, however, introduces significant overhead in terms of materialized view selection, maintenance, and exploitation. When this overhead is handled by the application, it increases the application complexity, and can slow down the transactional throughput of inserts, updates, and deletes.
In this thesis, we motivate, propose, and evaluate the aggregate cache, a materialized aggregate engine in the main-delta architecture of a columnar in-memory database that provides efficient means to handle costly aggregate queries of enterprise applications. For our design, we leverage the specifics of the main-delta architecture that separates a table into a main and delta partition. The central concept is to only cache the partial aggregate query result as defined on the main partition of a table, because the main partition is relatively stable as records are only inserted into the delta partition. We contribute by proposing incremental aggregate maintenance and query compensation techniques for mixed workloads of enterprise applications. In addition, we introduce aggregate profit metrics that increase the likelihood of persisting the most profitable aggregates in the aggregate cache.
Query compensation and maintenance of materialized aggregates based on joins of multiple tables is expensive due to the partitioned tables in the main-delta architecture. Our analysis of enterprise applications has revealed several data schema and workload patterns. This includes the observation that transactional data is persisted in header and item tables, whereas in many cases, the insertion of related header and item records is executed in a single database transaction. We contribute by proposing an approach to transport these application object semantics to the database system and optimize the query processing using the aggregate cache by applying partition pruning and predicate pushdown techniques.
For the experimental evaluation, we propose the FICO benchmark that is based on data from a productive ERP system with extracted mixed workloads. Our evaluation reveals that the aggregate cache can accelerate the execution of aggregate queries up to a factor of 60 whereas the speedup highly depends on the number of aggregated records in the main and delta partitions. In mixed workloads, the proposed aggregate maintenance and query compensation techniques perform up to an order of magnitude better than traditional materialized aggregate maintenance approaches. The introduced aggregate profit metrics outperform existing costbased metrics by up to 20%. Lastly, the join pruning and predicate pushdown techniques can accelerate query execution in the aggregate cache in the presence of multiple partitioned tables by up to an order of magnitude.
Afropolitan Encounters
(2022)
Afropolitan Encounters: Literature and Activism in London and Berlin explores what Afropolitanism does. Mobile people of African descent use this term to address their own lived realities creatively, which often includes countering stereotypical notions of being African. Afropolitan practices are enormously heterogeneous and malleable, which constitutes its strengths and, at the same time, creates tensions.
This book traces the theoretical beginnings of Afropolitanism and moves on to explore Afropolitan practices in London and Berlin. Afropolitanism can take different forms, such as that of an identity, a political and ethical stance, a dead–end road, networks, a collective self–care practice or a strategic label. In spite of the harsh criticism, Afropolitanism is attractive for people to deal with the meanings of Africa and Africanness, questions of belonging, equal rights and opportunities.
While not a unitary project, the vast variety of Afropolitan practices provide approaches to contemporary political problems in Europe and beyond. In this book, Afropolitan practices are read against the specific context of German and British colonial histories and structures of racism, the histories of Black Europeans, and contemporary right–wing resurgence in Germany and England, respectively.
Simultaneously speculative and inspired by everyday experiences, this volume develops an aesthetics of metabolism that offers a new perspective on the human-environment relation, one that is processual, relational, and not dependent on conscious thought. In art installations, design prototypes, and researchcreation projects that utilize air, light, or temperature to impact subjective experience the author finds aesthetic milieus that shift our awareness to the role of different sense modalities in aesthetic experience. Metabolic and atmospheric processes allow for an aesthetics besides and beyond the usually dominant visual sense.
The Turkish language in diaspora is in process of change due to different language constellations of immigrants and the dominance of majority languages. This led to a great interest in various research areas, particularly in linguistics. Against this background, this study focuses on developmental change in the use of adverbial clause-combining constructions in Turkish-German bilingual students’ oral and written text production. It illustrates the use of non-finite constructions and some unique alternative strategies to express adverbial relations with authentic examples in Turkish and German. The findings contribute to a better understanding of how bilingual competencies vary in expressing adverbial relations depending on language contact and extra-linguistic factors.
The aim of this work is the study of silica Arrayed Waveguide Gratings (AWGs) in the context of applications in astronomy. The specific focus lies on the investigation of the feasibility and technology limits of customized silica AWG devices for high resolution near-infrared spectroscopy. In a series of theoretical and experimental studies, AWG devices of varying geometry, foot-print and spectral resolution are constructed, simulated using a combination of a numerical beam propagation method and Fraunhofer diffraction and fabricated devices are characterized with respect to transmission efficiency, spectral resolution and polarization sensitivity. The impact of effective index non-uniformities on the performance of high-resolution AWG devices is studied numerically. Characterization results of fabricated devices are used to extrapolate the technology limits of the silica platform. The important issues of waveguide birefringence and defocus aberration are discussed theoretically and addressed experimentally by selection of an appropriate aberration-minimizing anastigmatic AWG layout structure. The drawbacks of the anastigmatic AWG geometry are discussed theoretically. From the results of the experimental studies, it is concluded that fabrication-related phase errors and waveguide birefringence are the primary limiting factors for the growth of AWG spectral resolution. It is shown that, without post-processing, the spectral resolving power is phase-error-limited to R < 40, 000 and, in the case of unpolarized light, birefringence-limited to R < 30, 000 in the AWG devices presented in this work. Necessary measures, such as special waveguide geometries and post-fabrication phase error correction are proposed for future designs. The elimination of defocus aberration using an anastigmatic AWG geometry is successfully demonstrated in experiment. Finally, a novel, non-planar dispersive in-fibre waveguide structure is proposed, discussed and studied theoretically.