TY  - GEN
A1  - Schlosser, Rainer
A1  - Kossmann, Jan
A1  - Boissier, Martin
T1  - Efficient Scalable Multi-Attribute Index Selection Using Recursive Strategies
T2  - 2019 IEEE 35th International Conference on Data Engineering (ICDE)
N2  - An efficient selection of indexes is indispensable for database performance. For large problem instances with hundreds of tables, existing approaches are not suitable: They either exhibit prohibitive runtimes or yield far from optimal index configurations by strongly limiting the set of index candidates or not handling index interaction explicitly. We introduce a novel recursive strategy that does not exclude index candidates in advance and effectively accounts for index interaction. Using large real-world workloads, we demonstrate the applicability of our approach. Further, we evaluate our solution end to end with a commercial database system using a reproducible setup. We show that our solutions are near-optimal for small index selection problems. For larger problems, our strategy outperforms state-of-the-art approaches in both scalability and solution quality.
Y1  - 2019
SN  - 978-1-5386-7474-1
U6  - https://doi.org/10.1109/ICDE.2019.00113
SN  - 1084-4627
SP  - 1238
EP  - 1249
PB  - IEEE
CY  - New York
ER  - 
TY  - JOUR
A1  - Schlosser, Rainer
A1  - Walther, Carsten
A1  - Boissier, Martin
A1  - Uflacker, Matthias
T1  - Automated repricing and ordering strategies in competitive markets
JF  - AI communications : AICOM ; the European journal on artificial intelligence
N2  - Merchants on modern e-commerce platforms face a highly competitive environment. They compete against each other using automated dynamic pricing and ordering strategies. Successfully managing both inventory levels as well as offer prices is a challenging task as (i) demand is uncertain, (ii) competitors strategically interact, and (iii) optimized pricing and ordering decisions are mutually dependent. We show how to derive optimized data-driven pricing and ordering strategies which are based on demand learning techniques and efficient dynamic optimization models. We verify the superior performance of our self-adaptive strategies by comparing them to different rule-based as well as data-driven strategies in duopoly and oligopoly settings. Further, to study and to optimize joint dynamic ordering and pricing strategies on online marketplaces, we built an interactive simulation platform. To be both flexible and scalable, the platform has a microservice-based architecture and allows handling dozens of competing merchants and streams of consumers with configurable characteristics.
KW  - Dynamic pricing
KW  - inventory management
KW  - demand learning
KW  - oligopoly competition
KW  - e-commerce
Y1  - 2019
U6  - https://doi.org/10.3233/AIC-180603
SN  - 0921-7126
SN  - 1875-8452
VL  - 32
IS  - 1
SP  - 15
EP  - 29
PB  - IOS Press
CY  - Amsterdam
ER  -