Database Administrator

Introduction to Oracle RAC clusters, processes, and logs In a single-host environment, Oracle runs on the OS Kernel. OS Kernel manages hardware devices and provides hardware access interfaces. Oracle does not directly operate the hardware, but has

MySQL Character Set settings Recently, in the MySQL database used by the project team, garbled data is inserted. We have summarized this issue. Let's start from the basic point, to the deep-seated causes and solutions of errors. Basic Concepts •

Compile the Proc program in Linux, and compile the Proc program in Linux. A simple Proc program needs to be written in linux. There is very little information, and a brief summary will be made after completion.References. 1. download the following

An example is provided to briefly introduce arrays in PostgreSQL and postgresql. PostgreSQL has many out-of-the-box data types, from standard digital data types, to geometric types, and even network data types. Although many people ignore these data

Linear table of DS, ds linear table Linear table definition A linear table is the most common and simple data structure. A linear table is a finite sequence of n data elements. The specific meaning of each data element varies under different

Common Database interview questions and database questions1. Foreign key candidates for primary key superkeys Primary key: A combination of data columns or attributes that are unique and fully identified for the stored data objects in the database

Hive simple instructions for use, hive simple instructions for use I usage: Hive: Start hive The command must end with a semicolon and tell hive to execute the command immediately, case insensitive. Show tables; View tables Desc tablename;

Database optimization tutorial (I) preface & definition of slow query, and introduction of database optimization tutorial Preface   Recently, I helped the company optimize the database. Based on what I learned, I used the learning knowledge step by

Paradigm analysis, paradigm 1. the paradigm theory is a Codd method used for data modeling. Practice has proved that it is suitable for micro-analysis of a single link. It is better to use the later ER Method for macro analysis. In fact, the

Linux C language database, linuxc language database MySQL is an open-source free database widely used in Linux, and is the first choice for storing data in Linux applications. To install MySQL in Ubuntu, run the following command at a terminal

Xtrabackup automatic backup script and xtrabackup script # Backup. sh #! /Bin/sh # on xtrabackup 2.2.8 # When you execute it for the first time, it will check whether there is a full backup. Otherwise, create a full database backup first. # When you

Run the rpm package to teach you how to install MySQL (MySQL-server-5.6.23 for CentOS6.5 _ 64bit), centos6.5mysql Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44753455 1. Check whether MySQL is installed on the

Simplifies complex set operations of report data sources and computation of reports Set operations are often used in computing report data sources. SQL supports set operations so that most simple set operations can be completed easily. However, when

Data segmentation-Atlas introduction and segmentation atlas Introduction Atlas is a MySQL-based Data Middle Layer project developed and maintained by the infrastructure team of Qihoo 360 Web platform department. Based on MySQL-Proxy 0.8.2 officially

My MYSQL Study Notes (1), MYSQL Study Notes ( This is my personal notes for learning MYSQL through online articles. I hope this will help you.1. DEFUALT keywords CREATE TABLE emp(id INT DEFAULT 12) 2. Set the auto-increment column

Install Goldengate On Oracle Rac 11.2.0.4, goldengate11.2.0.4 Installation environment: source:OS：redhat 6.3DB:11.2.0.4 racOGG:11.2.1.0.1target:OS:redhat 6.3DB:11.2.0.4OGG:11.2.1.0.1 A single data transfer configuration from rac to a single machine.

SQL removes duplicate records, SQL removes duplicates There are two Repeated Records. One is a completely repeated record, that is, records with all fields being repeated, and the other is records with duplicate key fields, such as duplicate Name

IMU technology and redo private strand Technology in Oracle, imustrand Oracle030 IMU technology and redo private strand Technology in oracle030Oracle 3. Explain the Oracle IMU Mechanism Select * from v $ sysstat where name like '%

[Translated from mos] Why does the INITIAL parameter be ignored when a table is created in a tablespace locally managed using the uniform size ?, Mosuniform Translation: Why Does a Table Created in a Locally Managed Tablespace With Uniform Extents

Linux mysql regular backup and compression, linuxmysql1. Check whether the mysql BACKUP command works. Create a backup directory under the var directory and a mysql directory under the backup Directory to store mysql backup files Cd to