Database Administrator

How to obtain Oracle patch announcement information and download patches Oracle Releases security-related patches four times a year, namely, Critical Patch Updates. How do we know whether the latest CPU is required? Here we will show you how to

MongoDB Data Replication shard I. MongoDB introduction: MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to replace traditional relational databases

Deploying MariaDB Galera Cluster architecture in CentOS 7.4 Mariadb galera Cluster installation:Operating System: CentOS 7.4Number of clusters: 3 nodesHost information: 192.168.153.142 node1 selinux = disabled firewalld disabled192.168.153.143 node2

Create an Oracle Link Server in 64-bit SQL Server Sometimes we want to access data from another SQL Server database or data from other Oracle databases under one SQL Server. to complete these operations, we must first create a database link. The

How to compile and run PL/SQL code snippets from a Case Study PL/SQL is a process-oriented structured programming statement developed by Oracle for database business logic requirements. In the Oracle kernel, there are two important components:

Connect Python to the MySQL database Create Database Connection import MySQLdbConn = MySQLdb. connect (host = "localhost", user = "root", passwd = "sa", db = "mytable ")　Common parameters includeHost: The host Name of the connected database server.

Dynamic Registration of Non-1521 standard ports in Oracle Dynamic Registration of dynamic registry and static registration are important ways to establish a connection between Oracle instances and listeners. From the current trend, the default

MongoDB import, export, backup, recovery, user authorization (4), mongodb ImportV. MongoDB import, export, backup, recovery, and user authorizationI. Data export and Data ImportAs a DBA (Administrator), you often need to import and export data. The

SQL Update multi-table joint Update method, sqlupdate joint Update Sometimes we need to update the data in multiple tables at the same time, then we need to use the following method: (1) sqlite multi-Table update Method Copy codeThe Code is as

PostgreSQL code analysis, query optimization, canonicalize_qual, postgresql Here, we have finished sorting out the part of the regular expression. The reading order is as follows: I. PostgreSQL code analysis, query optimization,

Windows Installation mysql-5.7 compressed version detailed tutorial, windowsmysql-5.7Preface install the mysql database today and go to the mysql official website. For windows, there are two versions of files to download: one is the. msi

Reading: docker container and container cloud (2); reading docker Summarize the learning and building process of dockerI read the 3.1 kernel, which is quite awesome.After reading the plug-ins on the internet, I tried them based on python and

Use exp/imp to migrate data, especially between different versions and between different systems,Of course, we recommend that you use expdp/impdp to import and export data. The following is a brief introduction to the basic operations of exp and imp.

What is data quality? Recently, data analysis is a hot topic. Traditionally, Data Analysis is divided into two types: EDA (Exploratory Data Analysis) and CDA (Confirmatory Data Analysis, validation Data Analysis ). EDA focuses on making data speak

Oracle BASICS (II): user and permission management, and oracle permission management1. Create a user(1) simple creation 1. Permissions: only DBA users have permissions or create user system permissions 2. Syntax: Create user Username identified by

Detailed explanation of Yahoo's MySQL Performance Analyzer, yahoomysql AnalyzerDetailed explanation of Yahoo's MySQL Performance Analyzer Author: chszs, reprinted to be noted. Blog homepage: http://blog.csdn.net/chszs一、introduction Yahoo opened its

MySQL common index, unique index, primary index, foreign key index, composite index, full-text index usage, mysql full-text index1. Common Index The only task of a common INDEX (INDEX defined by the KEY or INDEX keyword) is to speed up data access.

About Oracle Database shutdown and Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three

Incorrect practice: To port the data in the oracle 9i database to a lower version of oracle 8i, first use the exp command to export the command line in oracle 9i ): Exp username/password @ Global SID file = export database file name owner =

Many parameters can be selected during script generation. reasonable configuration of these parameters makes it easy for us to generate scripts as expected. Script generation options, such: Here is the SQL 2005 option, which is slightly different