Database Administrator

Install and configure PostgreSQL 9.4.3 in CentOS 6.5 I. IntroductionPostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system.

MongoDB Study Notes (1)-install MongoDB on WindowsOverview This document describes how to install MongoDB in Windows. Official website of MongoDB: http://www.mongodb.org/. the latest version is 2.6.7. Note: MongoDB does not support Windows XP since

An error solution for ORA-600 [13011] Sunoperating 5.10Oracle 10.2.0.2.0A ORA-600 error occurs in a database in the development environment. Error message in alert. log:Thu Nov 13 15:11:43 2014Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc:

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

Configure Oracle Gateway 12 to connect to SQL Server 2014 In recent work, we need to connect to SQL Server 2014 based on Oracle. We can configure Gateway to implement this function. This Gateway is actually implemented through dblink. That is, the

Rman backup method-Incremental backup and rman backup method incremental Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.

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

Common MongoDB commands and examples (3). Common mongodb commands Common commands and advanced commands I. Details of advanced applications for addition, deletion, modification, and query: Add: * ** if c1 is not inserted at the time of insertion,

MongoDB: Data Model introduction, mongodb Data Model Data in MongoDB has a flexible mode. Unlike SQL databases, you must determine the mode of a table before inserting data. The MongoDB set does not force the structure of the document. This

[Translated from mos] in unix/linux, how does one delete a shard by using a File descriptor (File Descriptors) to retrieve the deleted File (Data File or redo log )?Use File Descriptors in unix/linux to retrieve deleted files (Data Files or redo

In Linux, how does one change the database script file from the sh format to the SQL format, In the process of software development, it often involves changing the database script file from sh format to SQL format in Linux. This document uses an

Install the latest MySQL server in 64-bit Windows 7 Install the latest MySQL server in 64-bit Windows 7 Recently, I have been studying MySQL Databases and often modify configuration files. As a result, MySQL databases cannot be used and I have to

Comparison table of operations between MongoDB and MySQL and comparison table of mongodb Comparison tables and differences between MongoDB and MySQL MySQL and MongoDB are both open-source common databases, but MySQL is a traditional relational

After several days, I have completed HADR. Next, let's share it with you. System Environment: OS: SUSE 11sp1-64bit DB: db29.7.0.5   DB2server1: 192.168.5.151 db2inst1 DB2server2: 192.168.5.152 db2inst2 Steps: Operations on DB2server1: Db2inst1 @

SQL Server Performance Tuning methodology and common tools, SQL Server Tuning In earlier articles, we mentioned the DETECT methodology in Performance Tuning. Here we will briefly review the DETECT methodology. Discover the problem: found the

Mysql configuration file my. cnf configuration and configuration parameters, mysqlmy. cnf Mysql configuration file my. cnf Mysql is installed without the my. cnf file. 1. You can copy the mysql sample configuration file, such as the my-medium.cnf

Client Character Set, oracle client Character SetThis part is supported by oracle globalization. For more information, see the documentation.First, let's talk about the database character set. When we use dbca to create a database, we will let you

SQLite tutorial (14): C language programming example code (2), sqlite programming example 3. Efficient batch data insertion: Before giving the operation steps, let's briefly describe the concept of batch insert to help you read the subsequent sample

I. Scenarios In SQL Server 2005, there is a table TestDatetime, where the data type of the Dates field is datetime. If you see a table record, what do you first think? Figure 1: Data List) When you see this data, do you think this design is a waste

Test Data Management: creative solutions and Data Management Solutions Mario Matthee is a tester, Consultant, certified Master Scrum and very unqualified mountain motorcycle drivers (learning ). He is keen to introduce young IT experts