Database Administrator

Implementing the median Algorithm in MySQL Purpose: MySQL does not have a specific median algorithm. For those unfamiliar with SQL, median can only be written in Java or other languages. It is not recommended that you use MySQL to complete median

Detailed description of Redis Cluster deployment and Construction I 've been on the road to Oracle for many years. It's also a good feeling to change my feeling and try new knowledge. Redis, an ultra-light memory database, is a very good product

Greenplum distributed Framework Structure1. Basic Architecture Greenplum (GPDB) is a typical Shared-Nothing distributed database system. GPDB has a central control node (Master) to coordinate the entire system and run multiple database instances

Install the Inception service and use Python 3 to audit MySQL Bison is one of the packages that the Inception service depends on. However, some Linux versions have already installed Bison, or the Bison installed through yum, which is usually in

Understanding the Checkpoint Technology in MySQL 1. Background generated by checkpointWhen the database adds, deletes, queries, and modifies data, it is completed in the buffer pool first. To improve the efficiency of transaction operations, the

How to install JSON-supported SQLite 3.9.1 on Ubuntu 15.04 Welcome to read our article on SQLite. SQLite is the most widely used SQL database engine in the world today. It can run without configuration or management. SQLite is a public-domain

Introduction to MongoDB and addition, deletion, modification, and query I. Introduction MongoDB is written in C ++ and is an open source database system based on distributed file storage. MongoDB is designed to provide scalable, high-performance

Create an Oracle database link (DBLINK) You can run the following command to check the Global Database Name: SELECT * FROM GLOBAL_NAME; You can use the following statement to modify the parameter value: Alter system set GLOBAL_NAME = TRUE/FALSE;

Analysis of Oracle 12c PDB In any case, Oracle 12c has been out for so long and has never started learning for various reasons. It seems a little late now. I have always heard that PDB is a brand new architecture model in 12c. In various technical

Student Summary (II) -- what are the single quotes in students and what are the student quotes? Student Summary (II)-What are the single quotes in students? If you see this question, you may think that I am selling it. Let's take a look at this

Four features of database transactions and four features of transactions Four features of the database are atomicity, consistency, separation, and persistence. Next let's take a look at the specific introduction. Atomicity The atomicity of a

Common SQLite database statements and how to use SQLite visualization tool MeasSQLlite on MAC, sqlitemeassqllite I. Introduction In mobile development, small databases are usually used for data management. SQLite is a very small and convenient

Let's talk about the problem. When a 64-bit oracle is installed on a 64-bit operating system, the default encoding is SIMPLIFIED CHINESE_CHINA.ZHS16GBK, but this encoding is not available during actual installation. After installation, the data in

1. Environment Requirement Description: The user has an oracle 10g Database on the Intranet and an oracle 9i database on the Internet. The user publishes information about talent recruitment through the Intranet. All information is stored in one

Mysql master-slave synchronization error solution: This article is fromLinux O & M training for Old BoysSummary of internal teaching plan contentFAQ: Question 1: mysqldump: Got error: 1556: You can't use locks with log tables. When the old boy took

Shortly after I got to work today, QQ Didi kept ringing. After reading the information, I was asked by a netizen to help me with the next SQL statement. The general meaning is to count the number of records in different situations in the

This document describes how to create a SQL Server Analysis Service Project, a data source, and a data source view. 1) Basic BI concepts One BIBusiness intelligence) system can have up to five layers: 1. A data source layer), which consists of

In fact, for non-professional database operators, such as software developers, some of the basic knowledge about database indexing are largely unknown, or do not know why. I think the main cause of this situation is the industry. Many companies have

I. Purpose 1. Port data between different system platforms; 2. Backup and restoration methods of databases; 3. Data movement between users. Ii. Basic syntax and Examples 1. EXP There are three main methods (complete, user, table ). 1) completely Exp

Local service name (Tnsname) The connection between the Oracle client and the server is a connection request sent by the client. The server listener checks the client connection request legally. If the connection request is valid, the connection is