Welcome to the Spring Boot Backend Development Course. One of the topics of this course is ‘Databases’. When developing web applications, databases are essential, and all data must be stored and managed. In this post, we will start with the basic concepts of databases, and then explore various types, database design, integration with Spring Boot, and how to use SQL in detail.<\/p>\n
A database is a system that helps to store and manage information structurally. Users can perform various tasks such as entering, modifying, deleting, and querying data. Databases are generally needed for efficient storage, retrieval, management, and protection of data. Through databases, multiple users can access data simultaneously, ensuring data integrity.<\/p>\n
Databases are necessary for many reasons. These include:<\/p>\n
Databases can primarily be classified as follows:<\/p>\n
Relational databases store data in tabular form. Each table consists of rows and columns, and their relationships are defined by foreign keys. Notable relational database management systems (RDBMS) include MySQL, PostgreSQL, and Oracle.<\/p>\n
Non-relational databases are suitable for storing and managing unstructured data. They can store data in formats such as JSON, XML, documents, and key-value pairs, with a flexible schema. Representative non-relational databases include MongoDB, Cassandra, and Redis.<\/p>\n
Graph databases are optimized for modeling relationships between data. They use nodes and edges to store data and can visually represent complex relationships. Neo4j is a representative example of a graph database.<\/p>\n
Database design is essential for building an efficient database. The database design process includes requirement analysis, conceptual design, logical design, and physical design.<\/p>\n
The first stage of database design is requirement analysis. Here, we identify the information needed by the users and the business requirements.<\/p>\n
In the conceptual design stage, the conceptual structure of the data is defined through an ER diagram. This involves identifying ‘entities’, ‘attributes’, and ‘relationships’.<\/p>\n
In the logical design stage, the conceptual design is transformed into a data model (typically a relational model). At this stage, the schema of the database is determined.<\/p>\n
Finally, in the physical design stage, the logical design is specified according to the actual database system. This process involves optimizations considering performance, including indexing and partitioning.<\/p>\n
Spring Boot provides various features that make it easy to integrate with databases. The process of connecting to a database using Spring Boot includes dependency management, database configuration, defining entity classes, and creating repository interfaces.<\/p>\n
To communicate with a database in Spring Boot, appropriate dependencies must be added. If you are using Maven, the following dependencies should be added to the `pom.xml` file:<\/p>\n
\n\n\n org.springframework.boot<\/groupId>\n spring-boot-starter-data-jpa<\/artifactId>\n<\/dependency>\n\n com.h2database<\/groupId>\n h2<\/artifactId>\n runtime<\/scope>\n<\/dependency>\n<\/code>\n<\/pre>\n4.2 Database Configuration<\/h3>\n
To configure the database in Spring Boot, the `application.properties` file must be modified. Here is an example of H2 database configuration:<\/p>\n
\n\nspring.datasource.url=jdbc:h2:mem:testdb\nspring.datasource.driver-class-name=org.h2.Driver\nspring.datasource.username=sa\nspring.datasource.password=\nspring.h2.console.enabled=true\nspring.jpa.hibernate.ddl-auto=update\n<\/code>\n<\/pre>\n4.3 Defining Entity Classes<\/h3>\n
Entity classes must be defined in Spring Boot that map to database tables. For example, a `User` entity that stores user information could be defined as follows:<\/p>\n
\n\nimport javax.persistence.Entity;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.GenerationType;\nimport javax.persistence.Id;\n\n@Entity\npublic class User {\n\n @Id\n @GeneratedValue(strategy = GenerationType.AUTO)\n private Long id;\n private String name;\n private String email;\n\n \/\/ getters and setters\n}\n<\/code>\n<\/pre>\n4.4 Creating Repository Interfaces<\/h3>\n
Through the Repository interface, you can interact with the database. The `UserRepository` is defined as follows:<\/p>\n
\n\nimport org.springframework.data.jpa.repository.JpaRepository;\n\npublic interface UserRepository extends JpaRepository {\n}\n<\/code>\n<\/pre>\n5. How to Use SQL<\/h2>\n
SQL (Structured Query Language) is the standard language used to interact with databases. With SQL, you can query, insert, modify, and delete data. The basic SQL syntax is as follows:<\/p>\n
5.1 Data Query: SELECT<\/h3>\n\n\nSELECT * FROM users; \n<\/code>\n<\/pre>\n5.2 Data Insertion: INSERT<\/h3>\n\n\nINSERT INTO users (name, email) VALUES ('John Doe', 'john.doe@example.com'); \n<\/code>\n<\/pre>\n5.3 Data Modification: UPDATE<\/h3>\n\n\nUPDATE users SET email = 'john.new@example.com' WHERE id = 1; \n<\/code>\n<\/pre>\n5.4 Data Deletion: DELETE<\/h3>\n\n\nDELETE FROM users WHERE id = 1; \n<\/code>\n<\/pre>\nConclusion<\/h2>\n
In this post, we explored the basic concepts of databases, their types, design methods, and integration with Spring Boot. Since databases play a crucial role in backend development, it is important to have a fundamental understanding and practical use of them. In future courses, we plan to cover a variety of topics related to databases, so please look forward to it.<\/p>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"