Database Administrator

Deferred Segment Creation of Oracle 11g This article mainly introduces the Deferred Segment Creation feature introduced in Oracle 11g, as well as the issues that need attention when we use this feature. 1) Deferred Segment Creation In Oracle,

Install Oracle 11.2.0.4 x64 in Oracle Linux 6.5 1. Prepare the Oracle11g installation environment Use Oracle Linux 6.5 x64 for installation. The installation process is the same as RedHat. During installation, select the desktop, Development Kit,

How to extract Chinese character strings from Oracle In actual work, we often need to use the function of removing special characters, especially the data inserted into the database. To ensure the data quality, we often need to clean the data, that

Oracle 11g solutions for exporting empty and small tables Oracle 11g has a new feature. When the table has no data, no segment is allocated to save space. Solution: 1) insert a row and then roll back to generate a segment. This method inserts data

Importance of indexes in MySQL connection queries In MySQL, connection queries are often used to read data from multiple tables. Connection query uses the fields in the two tables that match the connection relationship to establish the association

Install MariaDB on the Ubuntu 14.04 (Trusty) Server The MariaDB database management system is a branch of MySQL. MariaDB strives to become an ideal choice for professional, robust, scalable, and reliable SQL database services. To achieve this goal,

MySQL Log System There are five log types in MySQL. Different log types have different log information. Here, the log types are as follows: Error Log: 1. Records Information during server startup and Shutdown 2. Records Errors generated during

Step 4 of automated MySQL deployment Step 4 of automated MySQL deployment Preparations First, you need to build ftpserver Yum install vsftpd Service vsftpd start In this way, the ftp service is up. It is simple to use, so no configuration file is

HBase System Architecture HBase is an Apache Hadoop database that provides random and real-time read/write access to large data. HBase aims to store and process large data. HBase is an open-source, distributed, multi-version, column-oriented storage

Hibernate ing mechanism Hibernate ing mechanism Object Relation Mapping (ORM) is a technology designed to solve the mismatch between objects and relational databases. In short, ORM uses metadata that describes the ing between objects, automatically

Summary of MySQL remote connection For a long time, I have never had the habit of summing up the problems encountered in the project. I feel that from today on, regardless of the problems encountered, note that it is necessary to summarize the

Summary of database principles, Summary of database principles Database technology is a technology that mainly studies how to scientifically organize and store data, efficiently obtain and process data, and meet different information needs of users,

Importance of indexes in mysql connection queries In mysql, connection queries are often used to read data from multiple tables. Connection query uses the fields in the two tables that match the connection relationship to establish the association

Mysql yum installation, mysqlyum Reference: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-5-6-from-official-yum-repositories Today, I sorted out the testing machine at the company and tried to install mysql with yum. I

Some query statements in Oracle and their execution sequence.Query condition:1) LIKE: fuzzy query. Two Wildcards are required. %: represents 0 to multiple characters; _: identifies a single character.2) IN (list): used to retrieve data that matches

Use Xtrabackup to back up the mysql database, xtrabackupmysql Use Xtrabackup to back up databases Xtrabackup is an open source backup tool developed by percona, which is different from ibbackup. Ibbackup is a paid backup tool. In terms of its backup

Troubleshooting of EXPDP stuck in AIX environment and expdp stuck in aix Environment Problem: A recent user is preparing to build a test environment. Because the official database of this user is an AIX midrange computer and the test environment is

Use of the SQL midstream mark and the SQL markDeclare @ id intDeclare @ addTime datetimeDeclare cursor1 cursor for -- defines the cursor cursor1Select id, addtime from MR_Examine -- use the cursor object (enter select text as needed)Open cursor1 --

Go to Oracle server connection and switch to oracle Server1. Two Connection Methods for the Oracle server Oracle database connections can be divided into two categories based on whether the client and server are running on the same machine. One is

[MongoDB] MapReduce programming model of MongoDB database, mongodbmapreduce When I first read the Mongodb getting started manual, I saw mapreduce. It was so difficult that I ignored it directly. Now, when I see this part of knowledge again, I am