189 lines
No EOL
6.8 KiB
BibTeX
189 lines
No EOL
6.8 KiB
BibTeX
% Bibtex Gen: https://www.literatur-generator.de/info/bibtex
|
||
|
||
% File: 3035918.3064053.pdf
|
||
@inproceedings{10.1145/3035918.3064053,
|
||
author = {Walenz, Brett and Roy, Sudeepa and Yang, Jun},
|
||
title = {Optimizing Iceberg Queries with Complex Joins},
|
||
year = {2017},
|
||
isbn = {9781450341974},
|
||
publisher = {Association for Computing Machinery},
|
||
address = {New York, NY, USA},
|
||
url = {https://doi.org/10.1145/3035918.3064053},
|
||
doi = {10.1145/3035918.3064053},
|
||
abstract = {Iceberg queries, commonly used for decision support, find groups whose aggregate values are above or below a threshold. In practice, iceberg queries are often posed over complex joins that are expensive to evaluate. This paper proposes a framework for combining a number of techniques---a-priori, memoization, and pruning---to optimize iceberg queries with complex joins. A-priori pushes partial GROUP BY and HAVING condition before a join to reduce its input size. Memoization caches and reuses join computation results. Pruning uses cached results to infer that certain tuples cannot contribute to the final query result, and short-circuits join computation. We formally derive conditions for correctly applying these techniques. Our practical rewrite algorithm produces highly efficient SQL that can exploit combinations of optimization opportunities in ways previously not possible. We evaluate our PostgreSQL-based implementation experimentally and show that it outperforms both baseline PostgreSQL and a commercial database system.},
|
||
booktitle = {Proceedings of the 2017 ACM International Conference on Management of Data},
|
||
pages = {1243–1258},
|
||
numpages = {16},
|
||
keywords = {postgresql, iceberg, query optimization, databases, iceberg queries},
|
||
location = {Chicago, Illinois, USA},
|
||
series = {SIGMOD '17}
|
||
},
|
||
|
||
% Website
|
||
@online{EffwFrankWedekind,
|
||
author = {AK Prof. Dr. Ariane Martin},
|
||
title = {Frank Wedekind | FB 05 - AK Prof. Dr. Ariane Martin},
|
||
year = 2023,
|
||
comment = {http://web.archive.org/web/20230405061538/https://www.martin.germanistik.uni-mainz.de/forschung/frank-wedekind/},
|
||
url = {https://www.martin.germanistik.uni-mainz.de/forschung/frank-wedekind/},
|
||
urldate = {2023-09-24}
|
||
},
|
||
|
||
@online{IbmOpenJPACaching2023,
|
||
year = 2023,
|
||
url = {https://www.ibm.com/docs/de/was/8.5.5?topic=applications-configuring-openjpa-caching-improve-performance},
|
||
urldate = {2023-09-24}
|
||
},
|
||
|
||
@online{PostgresPro:Chap20.4:2023,
|
||
year = 2023,
|
||
comment={http://web.archive.org/web/20230530113045/https://postgrespro.com/docs/postgresql/14/runtime-config-resource},
|
||
url = {https://postgrespro.com/docs/postgresql/14/runtime-config-resource},
|
||
urldate = {2023-12-27}
|
||
},
|
||
|
||
@online{PostgresF27:2023,
|
||
year = 2023,
|
||
url = {https://www.postgresql.org/docs/8.4/pgstatstatements.html},
|
||
urldate = {2023-12-27}
|
||
},
|
||
|
||
%@online{PostgresC20.4:2024,
|
||
year = 2024,
|
||
url = {https://www.postgresql.org/docs/current/runtime-config-resource.html},
|
||
urldate = {2024-03-27}
|
||
},
|
||
|
||
@online{ConfigTo12:online,
|
||
author = {},
|
||
title = {Config - Too small work\_mem · pganalyze},
|
||
url = {https://pganalyze.com/docs/checks/settings/work_mem},
|
||
month = {},
|
||
year = {},
|
||
urldate = {2024-09-12}
|
||
},
|
||
|
||
@online{PostgreS39:online,
|
||
author = {},
|
||
title = {PostgreSQL: Documentation: 16: 54.27. pg\_stats},
|
||
url = {https://www.postgresql.org/docs/current/view-pg-stats.html},
|
||
month = {},
|
||
year = {},
|
||
urldate = {2024-09-14}
|
||
},
|
||
|
||
@online{PostgreS12:online,
|
||
author = {},
|
||
title = {PostgreSQL: Documentation: 16: CREATE STATISTICS},
|
||
url = {https://www.postgresql.org/docs/16/sql-createstatistics.html},
|
||
month = {},
|
||
year = {},
|
||
urldate = {2024-09-14}
|
||
},
|
||
|
||
@online{AspNetCore:2024:MVC,
|
||
year = 2024,
|
||
url = {https://learn.microsoft.com/de-de/aspnet/core/fundamentals/middleware/?view=aspnetcore-8.0},
|
||
urldate = {2024-04-02}
|
||
},
|
||
|
||
@online{AspNetCore:2024:Middleware,
|
||
year = 2024,
|
||
url = {https://learn.microsoft.com/de-de/aspnet/core/fundamentals/middleware/?view=aspnetcore-8.0},
|
||
urldate = {2024-04-02}
|
||
},
|
||
|
||
@online{Golang:2024,
|
||
year = 2024,
|
||
url = {https://de.wikipedia.org/wiki/Go_(Programmiersprache)},
|
||
urldate = {2024-04-04}
|
||
},
|
||
|
||
% File: 978-1-4842-3546-1.pdf
|
||
@BOOK{Sharan2018,
|
||
AUTHOR = {Sharan, Kishori},
|
||
YEAR = {2018},
|
||
TITLE = {Java APIs, Extensions and Libraries - With JavaFX, JDBC, jmod, jlink, Networking, and the Process API},
|
||
EDITION = {},
|
||
ISBN = {978-1-484-23546-1},
|
||
PUBLISHER = {Apress},
|
||
ADDRESS = {New York},
|
||
},
|
||
|
||
% File: 978-1-4842-6885-8.pdf
|
||
@BOOK{Winand2012,
|
||
AUTHOR = {Winand, Markus},
|
||
YEAR = {2012},
|
||
TITLE = {SQL Performance Explained - alles, was Entwickler über SQL-Performance wissen müssen ; [für alle gängigen SQL-Datenbanken]},
|
||
EDITION = {},
|
||
ISBN = {978-3-950-30781-8},
|
||
PUBLISHER = {M. Winand},
|
||
ADDRESS = {},
|
||
},
|
||
|
||
% File: 978-1-4842-8992-1.pdf
|
||
@BOOK{Royal2022,
|
||
AUTHOR = {Royal, Peter},
|
||
YEAR = {2022},
|
||
TITLE = {Building Modern Business Applications ; Reactive Cloud Architecture for Java, Spring, and PostgreSQL},
|
||
EDITION = {},
|
||
ISBN = {978-1-4842-8991-4},
|
||
PUBLISHER = {Apress Berkeley, CA},
|
||
ADDRESS = {New York},
|
||
},
|
||
|
||
% File: fröhlich-2022-postgresql.pdf / Ehemalinger Link: doi:10.3139/9783446473157
|
||
@book{Fröhlich2022,
|
||
author = {Fröhlich, Lutz},
|
||
title = {PostgreSQL},
|
||
publisher = {Carl Hanser Verlag GmbH \& Co. KG},
|
||
year = {2022},
|
||
doi = {10.3139/9783446473157},
|
||
address = {München},
|
||
edition = {},
|
||
URL = {https://www.hanser-elibrary.com/doi/abs/10.3139/9783446473157},
|
||
eprint = {https://www.hanser-elibrary.com/doi/pdf/10.3139/9783446473157}
|
||
},
|
||
|
||
% Buch PostgreSQL - Administration (Hagen Leihe)
|
||
@book{Eisentraut2013,
|
||
AUTHOR = {Eisentraut, Peter AND Helmle, Bernd},
|
||
YEAR = {2013},
|
||
TITLE = {PostgreSQL-Administration - },
|
||
EDITION = {},
|
||
ISBN = {978-3-868-99362-2},
|
||
PUBLISHER = {O'Reilly Germany},
|
||
ADDRESS = {Köln},
|
||
},
|
||
|
||
% File: müller-wehr-2012-java-persistence-api-2.pdf / Ehemaliger Link: doi:10.3139/9783446431294
|
||
@book{MüllerWehr2012,
|
||
author = {Müller, Bernd and Wehr, Harald},
|
||
title = {Java Persistence API 2},
|
||
publisher = {Carl Hanser Verlag GmbH \& Co. KG},
|
||
year = {2012},
|
||
doi = {10.3139/9783446431294},
|
||
address = {München},
|
||
edition = {},
|
||
URL = {https://www.hanser-elibrary.com/doi/abs/10.3139/9783446431294},
|
||
eprint = {https://www.hanser-elibrary.com/doi/pdf/10.3139/9783446431294}
|
||
},
|
||
|
||
@book{Dombrovskaya2021,
|
||
author = {Dombrovskaya, Henrietta AND Novikov, Boris AND Bailliekova, Anna},
|
||
year = {2021},
|
||
doi = {10.1007/978-1-4842-6885-8},
|
||
title = {PostgreSQL Query Optimization - The Ultimate Guide to Building Efficient Queries},
|
||
isbn = {978-1-4842-6885-8},
|
||
publisher = {Apress},
|
||
address = {Berkeley, CA},
|
||
url = {https://link.springer.com/book/10.1007/978-1-4842-6885-8},
|
||
eprint = {https://link.springer.com/book/10.1007/978-1-4842-6885-8}
|
||
},
|
||
|
||
% noch offen:
|
||
% - OpenJPA: https://openjpa.apache.org/documentation.html
|
||
% - IBN OpenJPA Cache: https://www.ibm.com/docs/de/was/8.5.5?topic=applications-configuring-openjpa-caching-improve-performance
|
||
|
||
|
||
% File: postgresql-15-A4.pdf |