Oracle view, index, constraint, transaction, database paradigm

๐Ÿ… Programmer Xiao Wang's blog: Programmer Xiao Wang's blog ๐Ÿ… Welcome to like ๐Ÿ‘ Collection โญ Leaving a message. ๐Ÿ“ ๐Ÿ… If you have an editor's error and contact the author, if you have a good article, welcome to share it with me, I will extract the essence and discard the dross. ๐Ÿ… Learning route of java self-study: Learning route of ...

Posted by BigX on Thu, 10 Mar 2022 17:13:11 +0100

MySQL has too much replication delay due to insufficient IO capacity

background Received alarm, content: MySQL_ The master-slave replication delay is too high (example: XXXX), current value: 1032.00, threshold: 1000 - 100000000, occurrence time: 12 / 30 / 2021 02:27:16. Analysis process Generally, in case of replication delay, let's first look at the replication status and active session of the slave library. ...

Posted by swasheck on Wed, 09 Mar 2022 02:35:03 +0100

Qt connect and use SQL Sever database

Record the whole process of connecting to SQL Server database in detail environment System: Windows 10 professionalQt version: Qt 5.14.2 [compilation kit MinGW 32]SQL Sever: SQL Sever 2019Programming language: C++ 1, Configuring ODBC data sources 1, Add a new user in SQL Sever Manger 1. Open the MSS Management Studio provided below ...

Posted by drawmack on Tue, 08 Mar 2022 03:11:55 +0100

HIVE installation and SQL tutorial

Install brew The following script is used for domestic brew installation: /bin/zsh -c "$(curl -fsSL https://gitee.com/cunkai/HomebrewCN/raw/master/Homebrew.sh)" Install hive brew install hive Hide execute sql statement hive can directly convert sql statements into mapreduce code (the link below is very good) https://geek-docs.com/hive/ ...

Posted by Teen0724 on Mon, 07 Mar 2022 23:39:51 +0100

Mysql learning notes

SQL statement DQL (data query language): query statements. All select statements are DQL; DML (data operation language): insert delete update to add, delete and modify the data in the table; DDL (data definition language): create drop alter, adding, deleting and modifying the table structure; TCL (transaction control language): commit the tran ...

Posted by gmccague on Mon, 07 Mar 2022 19:37:05 +0100

Database must know and know

1. Database and SQL 1-1 introduction to database Our common mysql, SQL Server, DB2, Oracle Database and Postgresql all belong to relational database management system (RDBMS) The tables stored in the database are all sheets, which can be compared to excel data sheets. They are basically the same, just like that. 1-2 introduction to SQL The ...

Posted by Hylian on Mon, 07 Mar 2022 14:00:22 +0100

Deep learning linear algebra, probability and information theory

(3) Probability and information theory) 2, Linear algebra Purpose: it is mainly to reduce the dimension of data and restore or build the target with the least data 2.1 eigenvalue decomposition Only symmetric positive definite matrix can be decomposed into eigenvalues. Eigenvalue decomposition: A = P * B * PT, where B is the diagonal mat ...

Posted by GeertDD on Sun, 06 Mar 2022 17:43:45 +0100

Mysql learning notes

first day 1. What is a database? What is a database management system? What is sql? What is the relationship between them? Database: The English word DataBase is called DB for short. A combination of files that store data in a format. As the name suggests: a warehouse for storing data is actually a pile of files. These files store data in a spe ...

Posted by andrewmay67 on Sun, 06 Mar 2022 12:07:50 +0100

Custom SQL collection metadata using graphite

Grabit yes Salmon data kinship analyzer It collects SQL scripts from various data sources and then uploads them to salmon for data kinship analysis. The analysis results can be viewed in salmon. At the same time, the data kinship results will be extracted into the local directory. At present, grab supports two modes of operation: graphical int ...

Posted by shiva on Sun, 06 Mar 2022 10:37:04 +0100

MySQL notes: Chapter 08_ Aggregate function

Note: this content is compiled from the MySQL video of Shangshan Silicon Valley Station B >>MySQL video of Shangsi valley station B The previous chapter talked about SQL single line functions. In fact, there is another kind of SQL function, which is called aggregation (or aggregation, grouping) function. It is a function that summari ...

Posted by rcarr on Sat, 05 Mar 2022 15:50:16 +0100