Database transaction and connection pool
Database transaction
Introduction to database transactions
1. Transaction: a group of logical operation units that transform data from one state to another.
2. Transaction processing (transaction operation): ensure that all transactions are executed as a work unit. Even if there is a fault, it cannot be modified
Change this way of execution ...
Posted on Thu, 02 Dec 2021 22:08:52 -0500 by jonsimmonds
Table design of Oracle notes
1, Design table
Premise: the design table should first follow the three paradigms as needed
Review 3NF:
1NF – > column is the smallest atom that cannot be subdivided (avoid duplication);2NF – > primary key dependency (unique);3NF – > eliminate the transfer dependency (establish the primary foreign key Associati ...
Posted on Thu, 02 Dec 2021 19:58:22 -0500 by anoesis
Flink CDC Series - Build Streaming ETL on MySQL and Postgres
This tutorial will show you how to quickly build streaming ETL for MySQL and Postgres based on Flink CDC.Flink-CDC project address:https://github.com/ververica/flink-cdc-connectorsThis tutorial's demo is based on a Docker environment and will be done in the Flink SQL CLI, involving only SQL, without a single line of Java/Scala code, or with an ...
Posted on Wed, 01 Dec 2021 23:09:41 -0500 by abhishek
MySQL database log, backup and recovery
catalogue
Log type and function:
1.redo redo log
2.undo rollback log
3.errorlog error log
4.slow query log
5.bin log binary log
6.relay log
7.general log
Log query
Importance of data backup
Classification of database backup
Common backup methods
Actual operation
Physical cold backup and recover ...
Posted on Wed, 01 Dec 2021 15:58:59 -0500 by jamesp
On four thread pools
Transferred from: Micro reading (www.weidianyuedu.com) Micro reading - complete collection of model articles - a website for free learning knowledge
First, let's take a look at the code for obtaining four thread pools:
ExecutorService fixedThreadPool = Executors.newFixedThreadPool(10); ExecutorService cachedThreadPool = Executors.ne ...
Posted on Wed, 01 Dec 2021 11:45:38 -0500 by mattonline
HBase common Shell and Java API operations
1. Common shell
namecommandCreate tablecreate 'table name', 'column cluster name 1', 'column cluster name 2'get dataget 'table name', 'row key', 'column cluster name: column name'Add dataput 'table name', 'row key', 'column cluster name: column name', 'value'View all tableslistView table structuredesc 'table name'Delete columndelete 'table ...
Posted on Wed, 01 Dec 2021 04:31:53 -0500 by modcar
Running away from stores? Not rollback? MySQL creates and manages tables, modifies empty tables, MySQL8 features DDL atomization, complete and detailed collection
1. Basic knowledge
1.1 A procedure for data storage Storing data is the first step in processing data. Data can only be stored correctly for efficient processing and analysis. Otherwise, it can only be a mess, unable to start. So how can we store all kinds of business-related and complex data in an orderly and efficient way? In MySQL, a ...
Posted on Tue, 30 Nov 2021 22:35:36 -0500 by rsnell
Experiment 3: single table query
Experimental purpose
Master the application of simple SQL query statements, including the application of conditions, like, top, order by, compute, etcMaster the application of connection query
Experimental content
1. Basic query
(1) Query all the information of all students in the Student table
use student_info;
select * from Student;
...
Posted on Tue, 30 Nov 2021 21:54:55 -0500 by servo
Additions and deletions of MySQL data processing, new features of MySQL8 computed columns, complete details can be collected
1. Insert Data
1.1 Mode 1: Add by VALUES
Case 1: Insert data in default order for all fields of a table
INSERT INTO Table Name
VALUES (value1,value2,....);
Each field in the table needs to be assigned a value in the value list, and the order of values must be the same as the order in which the fields in the data table are defined. ...
Posted on Tue, 30 Nov 2021 18:49:43 -0500 by essjay_d12
Alignment -- local blast uses detailed 1- database sequence retrieval, download and comparison
This is a note from October 7, 2018. At that time, a batch of amoA genes of soil ammonia oxidizing bacteria (AOA/AOB) were cloned and sequenced, and the sequencing results need to be identified in batch. In order to save time, I taught myself about the local comparison of blast. At that time, I also used the blast-2.7.1 + version. Now download ...
Posted on Tue, 30 Nov 2021 17:37:15 -0500 by sw9