Database Administrator

The Database Administrator is responsible for establishing a configuration management database and maintaining the internal integrity or possible inter-database integrity of each database. Main activities include: Create a configuration

I. jobs of the database administrator Generally, as a DBA, do the following 12 tasks Installation and configuration Capacity Planning Application Architecture Design Manage database objects Bucket Management Security Management Backup and

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to

When importing data from IMP in Oracle, hybriddb for MySQL prompts that the character set is inconsistent. The imp import and exp export functions of Oracle are often used in the production environment for data migration. The character set is

Installing PostgreSQL using RPM packages in Linux Postgresql and MySQL are currently popular and active open source relational database systems. Compared with high-end Oracle commercial products, Postgresql and MyQL have much room for improvement in

Mybatis simple CRUD Based on XML file configuration, mybatiscrud All the ORM framework learning curves come with a CRUD, which is cool. Now let's get a CRUD. All the configurations are based on the previous one. Let's talk about the code. insert

Mysql batch Add a new column stored procedure in the table, mysql new Generally, for websites with a large access volume, the request log table is created independently on a daily basis. The business needs to add a new column for each table. After a

Big Data graph database: Data sharding and Data graph database This is excerpted from Chapter 14 "Big Data day: Architecture and algorithms". The books are listed in In a distributed computing environment, the first problem facing massive data to

To put it a little bit, pl/SQL developer needs to install the local Oracle client to connect to remote oracle before using the client configuration. Due to the bloated client, oracle now provides green and small solutions. The following is a

Mount a USB flash drive to CentOS and a USB flash drive to CentOS USB flash drive insertion prompt: [Sdb] No Caching mode page present[Sdb] Assuming drive cache: write through Use fdisk-l to check the USB flash disk (in fact, this is useless, just

Atitit. java parses the implementation of the SQL parser interpreter, atitit. javasql Atitit. java parses the implementation of the SQL parser Interpreter 1. parsing the essence of SQL: Implementing a 4gl dsl programming language compiler 1 2.

Character encoding system of MySQL (I)-data storage coding and mysql Data Storage MySQL has been installed many times, and every time it will be entangled in the character encoding configuration of the database, so I decided to thoroughly clarify it

Introduction to the long raw blob clob type in Oracle, blobclob Note: RAW: unprocessed type, which can store binary data or byte charactersLONG: variable-length string data. The maximum length is 2 GB. LONG has the VARCHAR2 column feature. It can

I. Backup and Recovery Overview1. Backup and Recovery Overview1.1 What is Backup and Recovery?Generally, backup and recovery references various policies and procedures to protect your database from data loss, and recreate the database after any data

Prerequisites: (1) The zabbix server has been successfully installed and run. (2) The zabbix client has been successfully created and runs. 1. Download and install msmtp Software WgetHttp://sourceforge.net/projects/msmtp/files/msmtp/1.4.32/msmtp-1.

Yahoo open-source MySQL Performance Analysis Tool (MySQL Performance Analyzer ), Address: https://github.com/yahoo/mysql_perf_analyzerMySQL Performance Analyzer is an open source project for MySQL performance monitoring and analysis. This repository

SQLite tutorial (1): SQLite database introduction, sqlite Database I. Introduction: SQLite is currently the most popular open-source embedded database. compared with many other embedded storage engines (NoSQL), such as BerkeleyDB and MemBASE, SQLite

PostgreSQL tutorial (6): Functions and operators (2), postgresql Operators 6. Pattern Matching: PostgreSQL provides three methods for implementing pattern matching: SQL LIKE operator, closer SIMILAR TO operator, and POSIX-style regular expression.1.

MongoDB Practice Notes for beginners-install, create databases, save and query data, and learn mongodb MongoDB is a scalable and High-Performance Distributed Document storage database written in C. It is designed to provide scalable and

Download, install, and use MongoDB. 1. Download and install 64-bit: mongodb-win32-x86_64-enterprise-windows-64-2.6.4-signed.msi Http://downloads.mongodb.com/win32/mongodb-win32-x86_64-enterprise-windows-64-2.6.4-signed.msi? _ Ga = 1.242525191.6074727