Database Administrator

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

Detailed description of InnoDB Transaction log (redo log and undo log) To avoid performance problems caused by I/O bottlenecks during data writing to the maximum extent, MySQL adopts a cache mechanism: When the query modifies the data in the

The temporary tablespace and undo tablespace used to import data from Oracle impdp are full. For Oracle data migration, we may use the expdp/impdp method. Sometimes large tables and lob fields may consume large temporary and undo tablespaces.

Comment lookup in infobright Data Warehouse The infobright Data Warehouse can compress and store a large amount of data in High-strength compression. The process of constant query is to decompress the data, of course, the detailed introduction has

Cross-platform database migration using Oracle Data Guard The customer was originally a single-host Oracle 11.2.0.3.0 Database for Windows Database system. The customer's requirement is to migrate the single-host Oracle Database to the three-node

PostgreSQL export data dictionary documentation You need to sort out the data dictionary documents of the current database on the project. The project is not standardized. Such documents should be supplemented later. Each field in these tables is

DB2 tablespace redirection recovery database practice DB2's backup recovery is a bit pitfall. When the path settings of the source and target systems are different, manual redirection recovery is required. This article is a summary process after my

Oracle GoldenGate introduction and installation configuration tutorial Introduction to Oracle GoldenGate GoldenGate is a log-Based Structured Data replication software. GoldenGate can capture, transform, and deliver a large amount of transaction

A set of Mybaits result sets, a solution for nested List in Javabean, and a solution for mybaitsjavabean In such a scenario, as a writer, I have written many articles. If I abstract myself into an object, so how can I get my articles written by

Implementation of multiple parameters in PrepareStatement SQL statement in, The following is the process of exploring the SQL statement with PrepareStatement pre-compiling where condition as in today. Only the fourth method is implemented in the

Why does database middleware not support join? Does middleware support join? Some netizens have doubts that database middleware only supports four types of SQL in the article "Let you design database middleware: Partition key common Query IN

Lesson 4 MongoDB Data Query (1): mongodb Data Query1. Course outlineThis course mainly describes MongoDB Data Query related content, including the introduction and use of the find function, query operator introduction and use, embedded document

Error code: 1728 Cannot load from mysql. proc. The table is probably uploaded upted, 1728mysql. procError code: 1728 Cannot load from mysql. proc. The table is probably uploaded uptedHttp://bugs.mysql.com/bug.php? Id = 50183The reason is that mysql.

Note and execute shell commands for Mysql queries. mysql executes shell commands. Mysql query notes 1. when querying mysql, you must add the database prefix before the table. Otherwise, the database is the current database by default (when

Use excel for data mining (4) ---- highlight abnormal values and excel Data Mining Use excel for data mining (4) ---- highlight Abnormal Values After configuring the environment, you can use excel for data mining. For environment configuration

Install and configure an openstack Virtual Machine. When you need to modify the ip address, you can modify the ip address in the database. Since many tables are created when the openstack environment is configured, the local ip address is configured.

Official MongoDB documentation translation series: Official mongodb documentationIntroduction This document provides a method for writing data into multiple documents using two-phase commit to process multi-document updates or "Multi-document

Introduction to basic statements of elasticsearch the aggregation function is powerful for analyzing data. Elasticsearch has powerful aggregation functions to analyze data, which is more powerful than MySQL. It can be categorized into sports based

Temporary tablespace cleaning in Oracle and Oracle tablespace cleaning Author: iamlaosong Oracle temporary tablespace is mainly used to query and store some buffer data. Temporary tablespace consumption is mainly caused by sorting the intermediate

Data cleansing Note: correct English date conversion reports "invalid month", note English Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have