Speaker: Simi Oluwatomi.
Applications interact with various databases, but the database layer is often a second-class citizen during development. This leads to issues like memory utilization, data loss, and anomalies. This talk focuses on key relational database design principles for robust and efficient systems.
In the world of software systems, most applications inevitably interact with databases. From Google spreadsheets to Microsoft Access, relational, non-relational, and even graph databases, databases are crucial to any software system. However, despite the significance of this component, the database layer often takes a back seat to application code during the development process.
Complication This oversight leads to many issues at the database level, including but not limited to excessive memory consumption, write failures, data loss and data anomalies. These complications undermine the overall performance of any software system.
How can we improve the reliability of software systems at the crucial database layer, ensuring seamless operation and data integrity? In this session, I will draw from my experience to provide invaluable insights into improving the dependability of software systems through effective database design. Developers can sidestep the previously mentioned complications by embracing fundamental principles like normalization, key design, indexing, effective connection management, and transactions. Armed with this knowledge, participants will be empowered to build applications and systems that are not only more efficient and reliable but also easier to maintain over time.
5 сен 2024