Database Administrator

Comparison of PostgreSQL database backup and recovery technologies There are three completely different methods to back up PostgreSQL data: SQL dump File System-level backup Online backup I. SQL dump The pg_dump application tool is used to

Install mirror E 11g on Solaris 10 iSCSI 64 bit I went to a client yesterday to install the 11g database, and made a record of the entire installation process and encountered problems. Because the customer cannot remotely connect to the server using

The partition view joins the horizontal partition data from a group of Members to make the data look like it is from the same table. SQL Server 2000 distinguishes the local partition view from the distributed partition view. In the local partition

Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000 I. Reasons for triggering this error and Related Factors This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by

MonjaDB is a MongoDB GUI client tool that provides intuitive MongoDB data management functions and supports Windows, Mac, and Linux. MonjaDB is an Eclipse plug-in that must be installed first. Main features: Easy to use WYSIWYG edit

Db2 database commands This article summarizes commonly used DB2 operation commands and shares them with you. For friends who use db2, refer. The DB2 database management Client no longer has a control center since v9.7, but uses the Data Studio

[Database Study Notes] (3) ing between SQL data types and Java data types, learning notes Data Types Comparison of Data Types Between SQL database and access Database Text nvarchar (n)Note ntextNumber (long integer) intInteger smallintNumber

CentOS installation mysql *. rpm prompt conflicts with file from package solution, centos. rpm Install MySql 6.5 in CentOS 5.6 Decompress file: tar xvf MySQL-5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar Release the following files: MySQL-embedded-5.

How to update a patch (Rolling Patch) in the Oracle RAC EnvironmentThe Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However, there

Sqlite study notes 7: Open the database using sqlite in C language, sqlite Study Notes The basic content of the database has been mentioned earlier. Next, let's take a look at how to use sqlite in the C language. Interface 1 sqlite3_open(const char

[Introduction to Data Mining]-quality of data quality and quality of Introduction to Data MiningData qualityThe data used by data mining is usually collected or collected for other purposes without explicit purpose. Therefore, data quality cannot be

The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is. The following is a detailed description of the error and the

MySQL Optimization-Delete Insert update and mysql optimization insert update Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46581769 Insert Insert multi-row query results into the table Syntax INSERT INTO

/* Function: batch process data in the database. For example, enter one thousand data records, it is obviously a waste of time to insert a record after each operation, such as creating a connection, and then disconnecting and then creating an insert,

In daily DB2 O & M, we often encounter slow execution of Several SQL statements, but the cpu and memory usage of the database server is not high, similar problems are basically caused by locks, sorting, and other reasons. Next we will analyze how to

How to deal with the rapid growth of oracle archive logs, oracle archive logs Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml. First, query the generation of the following daily

Data Analysis System DIY2/3: Local 64-bit WIN7 + dev c ++ compiler for VMware CentOS7 + MariaDB, diy2win7 Three tasks to be completed in DIY data analysis system. 1. Use VMware to install 64-bit CentOS. The database server can use the built-in

The JDBC driver of Informix is type 4. 1. Environment DescriptionOS: Windows XPInformix: IDS V10.00.TC1JDBC: Informix JDBC Embedded SQLJ V2.20JC22. JDBC ConfigurationAfter Informix JDBC is installed, add the ifxjdbc. jar path to the CLASSPATH

Transaction processing is a key issue for all large database products. database vendors have spent a lot of energy in this aspect, different transaction processing methods may cause huge differences in database performance and functions. Transaction

Import and export data between SQL Server databases (1). Use select into to export data The most widely used SQL Server is to export data using the SELECT INTO statement. The SELECT INTO statement has two functions at the same time: create an empty