Database Administrator

What kind of CMS can be used with 10 billion records and fast query? Shenzhen-The Best (554983108) 20:46:23Does MYSQL support file storage? Grandpa Heng Gua-(601069289) 20:46:30 2 million is not a problem Grandpa Heng Gua-(601069289) 20:46:45 More

create table tb(id varchar(3) , pid varchar(3) , name varchar(10))insert into tb values('001' , null, 'Guangdong province')insert into tb values('002' , '001' , 'Guangzhou')insert into tb values('003' , '001' , 'Shenzhen City')insert into tb values('

The installation of the oracle client is very simple. The key lies in the tns configuration. The rpm installation package I used here is that oracle itself is not open source, which is the easiest to install with rpm. First, download the following

In recent years, the multi-core hardware has been gradually applied to data warehouse products. At present, the main public-core hardware includes the multi-core CPU represented by Intel SCC, the multi-core coprocessor represented by Intel Zhiqiang

Http://www.infoq.com/cn/news/2014/01/couchdb-creator-joins-salesforce Recently, the founder of NoSQL database CouchDB announced that it would join Salesforce.com to engage in a very "cool" project related to the vendor's cloud

Mongodb supports backup and recovery in three ways. 1. copy directly. 2, Mongodump-d admin-o F: \ mongodb We put the exported data in the admin directory.Parameter description: (2) Mongorestore-d admin -- dorp F:

With as: A subquery is a part of the independent, sometimes to improve the readability of SQL statements, sometimes to Improve the Performance of SQL statements. If a table in an SQL statement is accessed multiple times with the same access

Symptom:After purge recyclebin, dba_segments still has BIN $ segments.After executing purge recyclebin:SQL> select segment_name, SEGMENT_TYPE from dba_segments where tablespace_name like 'users' and owner = 'zhou186'2;SEGMENT_NAME SEGMENT_TYPE-------

The components involved in Redis are based on the C language. Each C file corresponds to a module and can be considered as a component. Based on the analysis of its source code, we can conclude that the following components and modules and methods

Key data structures and methods 1) struct redisCommand struct redisCommand { char *name; redisCommandProc *proc; int arity; char *sflags; /* Flags as string representation, one char per flag. */ int flags; /* The actual flags,

I am currently working on the mongodb-based spring Project architecture. I have some questions to share with you, so that you can use it later. First look at a simple project architecture: In terms of architecture, the only thing that needs to be

Package util; import java. io. IOException; import java. SQL. connection; import java. SQL. driverManager; import java. SQL. preparedStatement; import java. SQL. resultSet; import java. SQL. SQLException; import java. util. properties; public class

Q: We use asmlib to create ASM disk in Oracle rac 11.2.0.3,And how can I get the logical valume by the datafile names and ASM disks?A:Datafiles were spread internal SS in all the MEMBER disks of a diskgroup. To find out the device name, please check

Among them, "executing other statements will not inspire nested triggers" means that if the statements after the rollback operation continue to be executed, the triggers triggered by subsequent statements will not be executed. For example, the

Video tutorial: http://pan.baidu.com/s/1AaeV8  MongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for WEB applications. MongoDB is a product between

MySQL database CPU soaring Emergency Handling MethodIf the CPU usage of a stable database is so high as 80%, it must be caused by bad SQL statements developed and written. The DBA must first ensure that the database should not run down, therefore,

References: Http://patrick-tang.blogspot.com/2012/06/redis-keepalived-failover-system.html Http://deidara.blog.51cto.com/400447/302402 Http://my.oschina.net/guol/blog/182491 Http://shiguanghui.iteye.com/blog/2001499 Background Currently,

The current status is dg1 as the master database, and the slave database is dg2.First check the status of the Master/Slave database:Dg1 SQL> select name,database_role,OPEN_MODE,SWITCHOVER_STATUS from v$database;DATABASE_ROLE OPEN_MODE SWITCHOVER_

We often traverse the system tables in the data dictionary to write SHELL scripts or dynamically create data. Here I use PLSQL to demonstrate three methods to traverse a table. The table structure is as follows, t_girl=# \d tmp_1;

PostgreSQL does not have binary logs similar to MySQL, but there are REDO logs similar to MySQL, and there is a REDO archiving function not available in MySQL. Of course, REDO archiving has been implemented by MariaDB and Percona-MySQL. Then we can