Database Administrator

-- ==================================== -- Oracle cold backup -- ==================================== I. Cold backup When the database is closed, all physical system files are copied, which is also called offline backup. Suitable for non-archive

If we use the Select statement to query data from the database, how does the Oracle database work? What can we learn from this? Next, we will combine a simple select statement to look at the operating mechanism of the Oracle database background.

MySQL server has many parameters, but for most beginners, many parameters often make us feel overwhelmed. But which parameters need to be adjusted and which have the greatest impact on server performance? For Myisam storage engine, there are two

Source of this article: http://www.lustlost.com /? P = 101 Mysql supports logical backup and physical backup Based on Backup recovery methods. Logical backup is a backup SQL statement. The backup SQL statement is executed during restoration to

Original article address: Stairway to SQL Server Indexes: Level 1, Introduction to Indexes This article is part of the SQL Server Index advanced series Stairway to SQL Server Indexes. Indexing is the basis of database design and shows developers the

Today, a colleague asked me a question: "After the mysql master uses binlog_ignore_db as a database, all statements executed using mysql-e will not write binlog? " I asked him about the situation. He tried to check his my. in cnf configuration,

I saw some people discussing the difference between pre-read and physical read on the internet today. I personally think that both physical read and pre-read operations require reading data from the disk to the memory, the reading time is different,

Tutorial environment: ORACLE11GR2, CENTOS6.2 32-bit version removes the need to modify the redhat Yum source, ipset to 192.168.233.10, NAT Network), VM8.0 version For installation instructions, refer to the official website documents and some

Deploy two-node cassandra ClusterEnsure that jdk is installed in the system. do not configure JAVA environment variables.Cassandra version: apache-cassandra-1.1.5jdk version: jdk1.6.0 _ 381. cassandra log Path # vim

I.Database Lifecycle The database lifecycle can be roughly divided into several stages based on the software lifecycle and project development. 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/22462324P-0.png "title ="

When using a stored procedure, we usually only need to grant the corresponding permissions to the account that calls the stored procedure. However, in fact, the stored procedure defines whether the user can directly execute the stored procedure, if

Share a function written yesterday. The purpose is to find that the given time is the nth week of the month. DELIMITER $$USE `t_girl`$$DROP FUNCTION IF EXISTS `weekofmonth`$$CREATE DEFINER=`root`@`localhost` FUNCTION `weekofmonth`( f_datetime

Java doesn't really provide any good means of auto-discovery in this regard, so the best way to do it is to simply tell MyBatis where to find the mapping files.So we have the element: What if I want to give mapper to Spring?

I. Databases A database is a collection of data. Whether the database adopts a relational structure or an object-oriented structure, the oracle database stores the data in the data file. Internally, the logical ing of database structure data to

Bkjia.com exclusive Article] This article introduces the indexes and common index types of SQL Server and Oracle. We hope to deepen our understanding of the two database index applications through the comparison method. 1. Index in SQL Server  An

BKJIA exclusive translation] We know that relational databases do not store data in a hierarchical manner, So how should we obtain data in a hierarchical manner? This article will introduce you to the hierarchical query features provided by Oracle,

Oracle databases have three standard backup methods: Export/Import EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup. 1. Export/Import) The Export can be used to

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

I. Composition of installation mediaWe choose INFORMIX-ONLINE and INFORMIX-SQL as the database system development, use and maintenance platform. They store 7 and 4 3.5 inch floppy disks respectively, using the cpio file format.Ii. Installation Steps

There are three main tools used to monitor post-motion of the ONLINE system: System Monitoring Interface SMI), tbstat, and tbcheck. I. System Monitoring Interface SMI) We mainly use SQL commands to operate internal tables/structures in the online