Programmer Think

Transaction processing in Spring question answering 1. What is a transaction speak mysql When a transaction is proposed, a transaction refers to a group sql A collection of statements with multiple entries in the collection sql sentence It may be insert, update, select, delete or a combination. We hope these multiple sql statements can suc ...

In September, datawhale teamed up to learn task05 advanced SQL operations 1, Window function 1. Concept, basic usage Window function (OLAP function) Online AnalyticalProcessingReal time analysis and processing of database Window function allows us to selectively summarize, calculate and sort some data Conventional SELECT statemen ...

preface Teach you how to use sharding JDBC to realize the database sub database and sub table. 1, Concept Sub database and sub table Database and table splitting is a reasonable splitting of databases and tables when the amount of data is large to a certain extent. Take MySQL as an example: it is recommended that the maximum amount ...

brief introduction What is Mybatis? MyBatis is an excellent persistence layer framework.It supports custom SQL, stored procedures, and advanced mapping.MyBatis eliminates almost all JDBC code and the work of setting parameters and obtaining result sets.MyBatis can configure and map primitive types, interfaces and Java POJO s (Plain Old Java O ...

Introduction to Codis codis cluster Codis is a distributed Redis solution. For upper tier applications, there is no obvious difference between connecting to the Codis Proxy and connecting to the native Redis Server (unsupported command list). Upper tier applications can be used like stand-alone Redis. The lower tier of Codis will handle r ...

Article catalog 1 Overview2 example description 2.1 flashback query2.2 flashback version query2.3 flashback transaction query2.4 flashback table2.5 flashback deletion 3 expansion 1 Overview In order to recover Oracle database from misoperation quickly, Oracle has introduced flashback technology.This blog mainly shares the flashbac ...

  catalogue 1, Singleton mode 2: Factory mode 3, Abstract factory pattern 4, Summary 5, Reference website 1, Singleton mode 1. Usage scenario of singleton mode in real life: Background processing services for printers Log object for the application Connection pool for database Counters for web sites Configuration object fo ...

Singleton mode What is singleton mode Definition of Singleton pattern: a pattern in which a class has only one instance and the class can create the instance itself. For example, only one task manager can be opened in Windows, which can avoid the waste of memory resources caused by opening multiple task manager Windows, or errors such ...

1 View The difference between a view and a table: "Is the actual data saved?""Views are not tables. Views are virtual tables. Views depend on tables." 1.1 Create View CREATE VIEW <View Name>(<Column Name 1>,<Column Name 2>,...) AS <SELECT Sentence> -- Create views based on multiple tables wit ...

High performance server, network theoretical knowledge and operating system High performance server Improve server performance 1. I/O model Blocking IO (not appropriate) Program blocking and read / write function when there is no data to read, the program blocks until the data is read successfully Blocking process: the time period whe ...