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

❤️ Liver explosion for 3 days! 20000 word graphic SQL zero basic entry, not afraid you can't learn, just afraid you don't collect! ❤️

📚 preface SQL language has a history of more than 40 years. Since it was applied, it has been almost everywhere. Every payment record we consume, every user information we collect and every message we send will be stored in the database or its related products, and the language to manipulate the database is SQL! SQL is almost a necessar ...

Posted on Sat, 20 Nov 2021 06:42:25 -0500 by phpBever

MySQL8.0 setup_actors execution time statistics

The resource usage statistics of each sql statement in the database is often the most troublesome part and the most effective way to locate the problem. In addition, the resource usage can help the DBA to confirm whether the business concurrency increases, whether the hardware resources meet the existing requirements, and whether the parameters ...

Posted on Wed, 10 Nov 2021 20:32:21 -0500 by evanesq

MySQL learning - connection query

join query What connection query? In the actual development, in most cases, the data is not queried from a single table. Generally, multiple tables are queried jointly to get the final result. In actual development, a business usually corresponds to multiple tables. For example, students and classes have to save at least two tables. Of cour ...

Posted on Mon, 08 Nov 2021 00:39:19 -0500 by jengle52

Theory and test of oracle materialized view

Theory and test of oracle materialized view 1. Materialized view (1) Basic concepts of oracle materialized view Materialized views first need to create materialized view logs, oracle Create a materialized view log table based on the materialized view log created by the user. The name of the materialized view log table is mlog$_Followed by t ...

Posted on Thu, 21 Oct 2021 00:28:17 -0400 by theflea912

⭐ openGauss database source code analysis series articles -- object permission management ⭐

❤️ Hello, I'm Gauss squirrel club. Welcome to study~ ❤️ ‍ Described in the previous article "9.3 role management" In this chapter, we introduce the wonderful contents related to "9.4 object permission management" in Chapter 9 security management source code analysis. 9.4 object permission management Permission manag ...

Posted on Sun, 17 Oct 2021 22:16:47 -0400 by Warz