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