Database Administrator

Encapsulate PL/SQL code in a smart package The vast majority of PL/SQL-based applications are composed of thousands or even millions of lines of code, which contains detailed and variable user requirements.Commercial logic is initially implemented

MySQL field content is case sensitive Data is migrated from Oracle to MySQL. Since Oracle is case-sensitive in the past, the default configuration is used for MySQL configuration, resulting in some data import failures, and some unique keys report

A preliminary understanding of Oracle B-tree indexes Today, we will study Oracle's B-tree indexes. Through this article, you will know which types of Oracle B-tree indexes are available and how Oracle B-tree indexes are implemented, oracle uses the

InfluxDB server startup process Operating System: CentOS7.3.1611 _ x64 Go language version: 1.8.3 linux/amd64 InfluxDB version: 1.1.0 Source code path: github.com/influxdata/influxdb/#/influxd Program entry (main. go ): Func main (){Rand. Seed (time.

Install and configure MariaDB on RHEL/CentOS MariaDB is an open-source relational database and a MySQL database branch version developed by the community. MariaDB has replaced MySQL as the default database in RHEL/CentOS 7. In this tutorial, we will

Oracle RMAN restores the database to different hosts I. RMAN backup content When RMAN is used for full backup, it contains data files, archive logs, control files, parameter files, and backup logs, as shown below: Arch_20160223_08qukp2t_1_1 arch_2016

How to change the root password of MySQL in CentOS How to change the root password of MySQL in CentOS 1. log on to mysql with an account Mysql-u rootOr # mysql-uroot-p 2. Change the user database Command: mysql> use mysqlMysql> use mysqlReading

Password maintenance in DataGuard Environment The motivation of this article is a friend's question. He asked me if the password file of the slave database can be directly re-built. I said it is best to copy it. If re-built, there may be some

MongoDB insert document The data structure of the document is basically the same as that of JSON. All data stored in the set is in BSON format. BSON is a type of json Binary storage format, referred to as Binary JSON.Insert document MongoDB uses the

MySQL Tutorial: Use tpcc-mysql for stress testing Tpcc-mysql is a product derived from tpcc for mysql Benchmark Testing. For more information, see high-performance MySQL 3. I. Installation Rpm-Uvh

Covering indexes of MySQL SQL optimization and optimizing indexes of mysqlsql Content Overview Using the primary index to improve SQL query efficiency is a frequently used technique, but sometimes the execution plan provided by MySQL is completely

Flask series tutorials (8) -- Flask-Migrate, flaskflask-migrateFlask-Migrate In the actual development environment, database changes often occur. Generally, we do not manually modify the database, but modify the database.ORMThe corresponding model,

An example of creating a table using sqlalchemy in python: pythonsqlalchemy How to Create a table instance using sqlalchemy in python Creating a table through sqlalchemy requires three elements: Engine, base class, and element. from sqlalchemy

Detailed explanation of adding keywords in PostgreSQL syntax, detailed explanation of postgresql Add keywords in PostgreSQL syntax When PostgreSQL's background process Postgres receives the query statement, it first passes it to the query analysis

Mysql checks duplicate indexes and mysql checks indexes. Mysql can re-create an index on the same field, but oracle cannot. Installation requiredPt-query-digest. [Root @ VM-10 ~] #Pt-duplicate-key-checker-h10.10.11.208-uroot-proot-P3316 -- charset =

Sort by salary in descending order. If the salary is the same, sort by employment date. 6 ~ 10 records, required Example: sort by salary in descending order. If the salary is the same, sort by employment date. Get 6 ~ 10 records 1. Obtain the

HBase compact analysis and HBasecompact Analysis HBase is a distributed NoSQL database based on the LSM tree storage model. Compared with the common B + tree, LSM trees can achieve high random write performance while maintaining reliable random read

Redis Command Execution Process, redis command process This problem is simple and simple. The client sends a command request, the server reads the command request, and then the command executor searches for the command implementation, executes the

Oracle Database system is a complex software system. The Oracle architecture refers to the relationship between the components of the Oracle database management system and these components, including the memory structure, background process,

MIS Management SystemIt is also a very practical management system, which can put a lot of things in order to facilitate your search. Next we will take the CD and VCD in your family as an example, we will introduce how to establish a MIS Management