Database Administrator

Various problems encountered in building a hadoop cluster with your peers are as follows:Preface Some time before the winter vacation, I began to investigate the setup process of Hadoop2.2.0. At that time, I suffered from the absence of machines,

Preface:The earthdistance () function in postgreSQL is used in the project to calculate the distance between two points on the earth. There is too little Chinese information. I found a good English article, hope to help those who will use

Jessonlv-lu guodong Original article, reproduced please indicate the source: http://blog.csdn.net/jessonlv The interview questions I encountered during the interview mainly focused on the joint query of SQL. google made a mistake, but I fixed the

Zookeeper From the author's website data analysis: data-driven website management, optimization and operation: http://item.jd.com/11295690.html The moving average can effectively eliminate the random fluctuations of actual data values, so as to

The bow whispered to the arrow, "Your freedom is mine ". Schema is like an arrow and bows like Python. Choosing Python is the biggest freedom of Schema. Freedom should be an opportunity to make yourself better.(I) MySQLdb SectionTable

I. The rman database can be stored in two locations1. control files of the target database;2. Restore the directory; 2. There are two types of storage records in the control file1. records the history of archived log files and the metadata of rman

This article is sponsored by the men's family and first launched in the dark world. Yesterday, I introduced the permissions after Server-u ftp is integrated with Windows users. Today I will introduce it again. Integration of Server-u ftp with Mysql

The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log

Autocommit = {0 | 1} sets whether MySQL transactions are automatically committed. 1 indicates immediate submission, and 0 indicates explicit submission. Global or session is a dynamic variable that can be used in the configuration file (but not in

Introduction Fact table The foreign key that stores the measurement value and dimension table. Dimension Table Angle and category. Time, region, and status. Old Method Select * from order oinner join district d on o. discode = d. discodeinner

This article will introduce the installation process of Oracle Database 9i in Open Unix 8. If you have experience installing Oracle, you can use the quick installation manual. If you have never installed Oracle databases before, from this article,

1. Create a database DB2_GCB Create database DB2_GCB on g: ALIAS DB2_GCBUsing codeset gbk territory cn collate using system DFT_EXTENT_SZ 32 2. Connect to the database Connect to sample1 user db2admin using 8301206 3. Create an alias Create alias db2

I have always felt that I should learn about another database except Oracle, but I am really not interested in SQL Server. I think MySQL or PostgreSQL is an open source database after all, it is difficult to compete with commercial databases in the

When the server must provide a connection to two or more networks or network subnets, a typical solution is to use a multi-host computer. This computer is usually located in a peripheral network, also known as DMZ, a peripheral security area, or a

Today, we will introduce six useful MySQL SQL statements. Many may use PHP to implement these functions. 1. Calculate the number of years You figured out how old this person is on your birthday.

In the process of using the Sybase database, we often encounter locks in the Sybase Database System. In most cases, users must log on to the system as Super Users to process the process. To ensure the security of the Sybase Database System, the

Robert Thornton has six years of Java language development experience and is currently a consultant for Daugherty Business Solutions. He served in St. louis, Mo ., developers and architects who use Java EE applications on various clients in the

Charts, numbers, and graphs help you quickly understand and analyze large datasets. As the saying goes, "Never heard of anyone", because images can convey important summary and comparison information about data that is difficult to obtain from text

To allow automatic database management, the administrator needs to pre-define predictable management tasks and conditions for sending these tasks. When the specified conditions are met, the database automatically runs the operations specified by the

I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every day for the system to automatically