RBDMS - Relational Database Management Systems

Transcript

1. Diciembre 2021 RBDMS Alejandro Velasco - CPFR
2. Lecturer Mercado Libre First Party 2021 Technical Leader - CPRF Replenishment Mercado Libre Ms.c Computer Science Bs.c Software and Computing Engineering Universidad Nacional de Colombia Passionate on building software applications, researching and playing video games. Sebastian Alejandro Velasco
3. Contents Mercado Libre First Party 2021 #2d2d2dff #ffcd00ff 1. RDBMS 2. JPA 3. Fury Database Service 4. Data Source Specs 5. Connection Pool 6. Integration Testing 7. Database Change Control 8. Fury Migration Service
4. Mercado Libre First Party 2021 RBDMS
5. Relational Database Management System Mercado Libre First Party 2021 #2d2d2dff #ffcd00ff Relationships between data items are expressed by means of tables (values) Relational SQL Natural Normally includes a Structured Query Language API. Provides a natural and straightforward way to represent data in tables. Commitment and Atomicity Handle business rules and policies at a very granular way. Relational model is the best for maintaining data consistency across applications. Data Consistency
6. ACID Mercado Libre First Party 2021 Four crucial properties define relational database transactions: atomicity, consistency, isolation, and durability—typically referred to as ACID. • Atomicity defines all the elements that make up a complete database transaction. • Consistency defines the rules for maintaining data points in a correct state after a transaction. • Isolation keeps the effect of a transaction invisible to others until it is committed, to avoid confusion. • Durability ensures that data changes become permanent once the transaction is committed.
7. CAP Theorem Mercado Libre First Party 2021 “Distributed computing systems can only satisfy two of the following three attributes: (Consistency), (Avalibility) and (Partition Tolerance)”
8. What to look for when selecting a relational database Mercado Libre First Party 2021 #2d2d2dff #ffcd00ff • What are our data accuracy requirements? Will data storage and accuracy rely on business logic? Does our data have stringent requirements for accuracy (for example, financial data and government reports)? • Do we need scalability? What is the scale of the data to be managed, and what is its anticipated growth? Will the database model need to support mirrored database copies (as separate instances) for scalability? If so, can it maintain data consistency across those instances? • How important is concurrency? Will multiple users and applications need simultaneous data access? Does the database software support concurrency while protecting the data? • What are our performance and reliability needs? Do we need a high-performance, high-reliability product? What are the requirements for query-response performance? What are the vendor’s commitments for service level agreements (SLAs) or unplanned downtime?
9. Mercado Libre First Party 2021 JPA
10. JPA - Java Persistence API Mercado Libre First Party 2021 #2d2d2dff #ffcd00ff Store and retrieve Data in a relational database. The API itself, defined in javax.persistence The Jakarta Persistence Query Language (JPQL) Object/relational mapping Purpose https://github.com/spring-guides/gs-accessing-data-jpa
11. ER - Example Mercado Libre First Party 2021
12. Entity Definition Mercado Libre First Party 2021
13. Entity Definition Mercado Libre First Party 2021
14. javax.persistence Mercado Libre First Party 2021 API Reference
15. ORM - OneToOne Mercado Libre First Party 2021 https://docs.oracle.com/javaee/7/api/javax/p ersistence/OneToOne.html
16. ORM - OneToMany Mercado Libre First Party 2021 https://docs.oracle.com/javaee/7/api/jav ax/persistence/OneToMany.html
17. ORM - ManyToOne (Bidirectional) Mercado Libre First Party 2021 https://docs.oracle.com/javaee/7/api/j avax/persistence/ManyToOne.html
18. ORM - ManyToMany Mercado Libre First Party 2021 https://docs.oracle.com/javaee/7/a pi/javax/persistence/ManyToMany .html
19. Repositories Mercado Libre First Party 2021 by implementing one of the Repository interfaces, the Entity will already have some basic CRUD methods (and queries) defined and implemented.
20. Basic Operations in Repositories Mercado Libre First Party 2021
21. Custom Queries in Repositories Mercado Libre First Party 2021
22. Lombok Mercado Libre First Party 2021 Lazy loading? DO NOT use @Data, @EqualsAndHashCode o @ToString. https://plugins.jetbrains.com/plugin/15075-jpa-buddy
23. Mercado Libre First Party 2021 Fury Database Service (PART2)
24. Database Creation Mercado Libre First Party 2021
25. Database Snippets Mercado Libre First Party 2021
26. Mercado Libre First Party 2021 Datasource Specs
27. Dependency Configuration Mercado Libre First Party 2021
28. Datasource properties Mercado Libre First Party 2021
29. Bean Configuration Mercado Libre First Party 2021
30. Mercado Libre First Party 2021 Connection Pool
31. Connection Pool Mercado Libre First Party 2021 Connection pooling is a well-known data access pattern, whose main purpose is to reduce the overhead involved in performing database connections and read/write database operations. In a nutshell, a connection pool is, at the most basic level, a database connection cache implementation, which can be configured to suit specific requirements. • Opening a connection to the database using the database driver • Opening a TCP socket for reading/writing data • Reading / writing data over the socket • Closing the connection • Closing the socket Database connection lifecycle database connections are fairly expensive operations
32. Implementations Mercado Libre First Party 2021
33. HIKARI Mercado Libre First Party 2021 This is a very lightweight (at roughly 130Kb) and lightning-fast JDBC connection pooling framework developed by Brett Wooldridge around 2012. https://github.com/brettwool dridge/HikariCP-benchmark
34. HIKARI Implementation Mercado Libre First Party 2021 Spring boot < 2.x. Its necessary to explicitly define the bean
35. HIKARI - properties Mercado Libre First Party 2021 Spring boot > 2.x. It’s NOT necessary to explicitly define the bean
36. HIKARI - In action Mercado Libre First Party 2021
37. Mercado Libre First Party 2021 Integration testing
38. H2 - In memory database Mercado Libre First Party 2021
39. H2 - Datasource Specs Mercado Libre First Party 2021
40. Mercado Libre First Party 2021 Database Change Control
41. LIQUIBASE - (Sql generation) Mercado Libre First Party 2021
42. Liquibase - XML change Control Mercado Libre First Party 2021 In-app integration (Only for local environments)
43. Liquibase Standalone - Automatic SQL generation Mercado Libre First Party 2021
44. Liquibase Standalone - Automatic SQL generation liquibase.dockerfile mysql.dockerfile docker-compose
45. Liquibase in action - database update. Mercado Libre First Party 2021
46. Liquibase Standalone - Automatic SQL generation Mercado Libre First Party 2021
47. Mercado Libre First Party 2021 Fury Migration Service
48. Database Migrations Mercado Libre First Party 2021
49. Fury - create migration Mercado Libre First Party 2021
50. Fury - create migration Mercado Libre First Party 2021
51. Fury - migration limitations Mercado Libre First Party 2021
52. Mercado Libre First Party 2021 ¡Muchas gracias!