Henrietta Dombrovskaya

Director of Data Analytics at BrokerX

About

``` Henrietta Dombrovskaya is a database researcher and developer with over 35 years of academic and industrial experience. She holds a Ph.D. in Computer Science from the University of Saint Petersburg, Russia. At present she is

• A Senior Cloud Consultant at Enterprise DB
• Local Organizer of the Chicago PostgreSQL User Group
• Active community member, a frequent speaker at the PostgreSQL Conferences
• A researcher focused on developing efficient interactions between applications and databases; publications include Proceedings of EDBT 2014 Athens, ICDE 2016 in Helsinki, and SOFSEM 2020 Limassol
• A winner of the “Technologist of the Year” 2019 award of the Illinois Technology Association
• An author of PostgreSQL Query Optimization book ```

Henrietta Dombrovskaya has presented the following presentations

Functions: Use and Misuse at 2021 Postgres Conference Webinars

presented by Henrietta Dombrovskaya

video
Functions are among the most underused and misused of PostgreSQL objects. Since all modern programming languages include user-defined functions, people often assume that database functions are cut from the same cloth and if you know how to write functions and when to write functions in an application programming language, you can apply this knowledge to PostgreSQL. This could not be further fro...
more
Tue 26 2021 Dev
Long Queries and the Art of Full Scan at 2021 Postgres Conference Webinars

presented by Henrietta Dombrovskaya

video
Some queries just can’t run in a fraction of a second, no matter how well written. This does not mean they can’t be optimized. Many practitioners hold that since analytical reports do not have strict response time requirements, it is not important how fast or slow they run. In extreme cases, report developers make no effort to make sure that reports are complete in a reasonable time, giving the...
more
Wed 22 2021 Ops
How to build local communities: a meetup perspective at Postgres Webinar Series

presented by Henrietta Dombrovskaya

video
Today, Chicago PUG is the third-largest in the Western Hemisphere, but it was not the case three years ago. It is easy to announce a new User Group, but how to keep it running and growing? Nobody expected new pandemic and the effect it will take on our lives. The Open Source communities, including Postgres community, which live and breath live discussions, were hit heavily. How did we manage? W...
more
Wed 28 2020 Case Study
NORM - Bridging the Gap Between Applications and Databases at Postgres Webinar Series

presented by Henrietta Dombrovskaya

video
Life without ORM - is it possible and how we can get there? In this talk, Hettie will present the approach developed and implemented at Braviant Holdings. NORM (No-ORM) allows building performant and scalable applications and is praised by developers for its ease of use.
Wed 6 2020 Dev
Life without ORM: is it possible and how we can get there at Postgres Conference 2020

presented by Henrietta Dombrovskaya, Alvaro Hernandez, Alexander Ioffe, dharshan rangegowda, Boris Novikov, and Jeremy Smith
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
more
Development
How to build local communities: a meetup perspective at Postgres Conference 2020

presented by Henrietta Dombrovskaya
Today, Chicago PUG is the third-largest in the Western Hemisphere, but it was not the case three years ago. It is easy to announce a new User Group, but how to keep it running and growing? Nobody expected new pandemic and the effect it will take on our lives. The Open Source communities, including Postgres community, which live and breath live discussions, were hit heavily. How did we manage? ...
more
Professional Development, Life and Leadership
The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks at Postgres Conference 2020
Think like a database
presented by Henrietta Dombrovskaya and Boris Novikov
Abstract: Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely possible to become an optimization wizard, and we are going to prove it in the course of this training. We will provide the participants with the opportunity to look at the process of query writing “as a database engine”, a...
more
Development
Connecting Galaxies at Postgres Conference
Information Exchange Techniques for Java/PostgreSQL Applications
presented by Alyssa Ritchie and Henrietta Dombrovskaya
Everything shall pass except Object-Relational Impedance Mismatch. Despite many years of research and development in this area, applications and databases still struggle with communication issues. An incompatibility of data models between object-oriented application code and a database engine causes multiple performance problems and triggers over-complicated application design.
In this talk,...
more
Wed 20 2019 Development
Using FDW Like Never Before at Postgres Conference
Remote Functions Calls Are Possible
presented by Henrietta Dombrovskaya
At Braviant Holdings we consider foreign data wrappers to be the best thing even introduced in PostgreSQL. We use them virtually everywhere, both for our apps which interact with OLTP databases and for the ETL for our Data Warehouse.
One of the best things about using the FDW is that they allow you to map objects of various types. You can map tables, views, other foreign tables, you can use...
more
Wed 20 2019 Development