Database Administrator

Subtotal for Oracle 1. Sequence 1.1 What is Sequence? Sequence is an object provided by Oracle for generating auto-increment primary keys. This is similar to the identity of SQL server. From a mathematical point of view, it is an arithmetic

Truncate usage in Oracle Syntax: truncate table; You can use the truncate Statement (DDL language) to delete all records in a table. The truncate statement is usually much faster to delete data than to delete data. This is because no rollback

Mongodb3.0 Performance Test Report III. mongodb3.0 performance test Mongodb3.0 Performance Test Report 1 Mongodb3.0 Performance Test Report 2 Test environment: Servers: 6 X86 pcservers Cpu: single 8-core Memory: 64 GB Disk: raid 10 Operating System:

JAVA transaction attribute ACID; java transaction attribute acidATOMICITY ):A transaction must be completely completed or canceled without ambiguity. When an error occurs in any operation, the effect of all operations that constitute the transaction

Connection Pool technology and technology Concept The connection pool is a buffer pool technology for creating and managing a connection. After the connection pool is ready, it will be used by any thread that needs them. The technology that

High concurrency: Memcached practice lesson 10th-part of the code for "Memcached Get data" Section 2: memcached practiceHigh concurrency: Memcached practice lesson 1-"Memcached Get data" part of Code 2 I. Logic of reading and writing the Memcached

MySQL Study Notes (1), mysql Study NotesPreface Note content is based on the database course of the lab building. If you are interested, you can click it to learn it. It should be a note, so the content may be simple and incomplete. Because note

SQL and SQL tutorialsAn inner join is a join in which the values in the columns being joined are compared using a comparison operator. In the ISO standard, inner joins can be specified in either the FROM or WHERE clause. this is the only type of

An error occurred while converting from nvarchar to numeric. nvarcharnumeric When writing an SQL statement, you need to compare the nvarchar column of the (dictionary) table with the numeric column of Table B; The dictionary data stored in the

SQL and SQL tutorialsInner joins return rows only when there is at least one row from both tables that matches the join condition. inner joins eliminate the rows that do not match with a row from the other table. outer joins, however, return all

Find problem in eXtremeDB, problemtremedb Class table1 { Char f1; Char f2; Uint4 f3; Uint4 f4; Double f5; Uint4 f6; Uniquetree Idx1; Tree Idx2; };   Steps: Step 1: find (Idx1 = (a, B), find the records; Step 2: put (f6, c ); Step 3: find (Idx1 =

Sharp SQL2014: handling deadlocks, sql2014  In two or more tasks, if each task locks the resources that other tasks attempt to lock, this will cause permanent blocking of these tasks and lead to deadlocks. For example: Transaction A obtains the

Data replication between tables We can use insert between two tables to implement simple replication (the two tables have the same structure). The example is as follows: SQL> create table T (2 tid number (4 ), 3 tname varchar2 (10) default 'abc ', 4

Install and use memcache. 1 memcache depends on libevent brew install libevent 2 download memcache ＃wget http://www.memcached.org/files/memcached-1.4.22.tar.gz Then install configure; make install 3. Start: 'Sudo./memcached-p 11211-m 64-u shenyb-d

Use SQL server with the doscommand and SQL server with the doscommandIn general, we can use SQL server under the DOS command and use the DOS command to use SQL server as follows:1. Connect to the database server:The osql command can be used to input

Install the phpredis module extension in ubuntu. 1. The premise is to install redis first, and then install phpredis... 2.download the phpredis-master.tar.gz installation package first... The details are as follows: 1.tar zxvf

Sub-structure and sub-structure of the tree 1. Question Enter Two Binary Trees A and B to determine whether B is A sub-structure. The binary tree structure is as follows: Struct BinaryTreeNode { Int m_nValue; BinaryTreeNode * m_pLeft; BinaryTreeNOde

Use Django to clean up data in the database.Description of the data cleaning problem in the database: in my system, due to history and various reasons, the data recorded in the table in the database is problematic, there are repeated and incomplete

Transport Tablespace Set (3), createtablespace View the source Character Set and endian:SQL> select userenv ('language') from dual;USERENV ('language ') SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> SELECT d. PLATFORM_NAME, ENDIAN_FORMAT2 FROM V

Data migration-compact and move -- The current requirement is that the following result sets become compact: COL1 COL2 COL3------------------------------ 123456789101112 COL1 COL2 COL3------------------------------1 7 112 8 123 94 1056 Drop table