Database Administrator

MongoDB map reduce, mongoDBmapreduce MongoDB map reduce usage Example: Res = db. runCommand ({Mapreduce: 'liveepguservisits ',Map: function (){Emit ({provice: this. provice}, {"data": [{"mac": this. mac}], visit: this. visitNum, userCount: 0

Install postgresql934 in source code and sql934 in source code0[Root @ pghost ~] # Uname-Linux pghost 2.6.32-431. el6.x86 _ 64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux[Root @ pghost ~] # Cat/etc/issueCentOS release 6.5

Considerations on keys outside of database design and database design There is no uniform standard for the use of foreign keys in the industry. The focus of the debate is data consistency and performance. Supports the use of foreign keysIt is

In SQL Server, the execution result of Exec is assigned to the variable output in the stored procedure. sqlserverexec Background: In this case, the table name and some attributes of the table (the primary key ID is used here) are dynamically passed

Chapter 2 User Authentication, Authorization, and Security (11): fixed the logon ing error in the restored database, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for

Oracle stream Disaster Tolerance configuration, oraclestream Disaster ToleranceConfiguration of Oracle stream Replication Configuration: master database 100.100.100.20 linux system, database instance name db1 version 10.2.0.1 Slave database 100.100.1

IGNOREDELETES, IGNOREUPDATES, ignoredeletes Sometimes, when we do not want to update or delete the data of the target ogg application, we can use the IGNOREDELETES and IGNOREUPDATES parameters. GETDELETES | IGNOREDELETESValid for Extract and

Oracle Performance Analysis 10: Re-indexing-common SQL and oraclesql The previous section describes the causes and methods for re-indexing. This section describes several common SQL statements and stored procedures.Query all invalid global

Basic MySQL operations 1. view all databases mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || wms |+--------------------+ The

MongoDB permission and mongodb permission settings MongoDB does not set permissions by default, which is essentially different from mysql and oracle. When the parameter -- auth is added during startup, the permissions are started. The biggest

GoldenGate performance tuning, goldengatetuning During ogg synchronization, we sometimes encounter very large tables. At this time, we can use multiple replicat processes to split them by the range parameter and apply them to the target database.

Installing Oracle10g encountered ins_ctx.mk problem, oracleinsctx. mk **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them.

A listener cannot be created after Oracle is installed in LINUX. **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please

[MongoDB] The basic operation of Mongodb, Insert \ Query \ Delete \ Update, mongodboperation1, Insert MongoDB is database storing document object, the type of which is called Bson. (like JSON ); Example: // document defination     Now after using

Linux/centos oracle10g control connection IP address, centosoracle10gOracle controls the IP address of the connected database Simply set allowed IP addresses and prohibited IP addresses In 9i and later, modifying sqlnet. ora is actually the best and

Oralce SQL creates the calendar information for a specified period of time, oralcesql The creation start time is 2010 and the end time is 2100. Create table temp_calendar as selectMin (to_char (day, 'yyyymm') month, To_char (min (decode (weekday, 1

How to Create a FUNCTION, log-binmysql Create a function in the master database of the MySQL master-slave replication machine and report the following error: Error Code: 1418. this function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its

Detailed steps for recovering control file faults and detailed steps for file faults If the control file is lost or damaged, the instance is usually aborted. You must perform the following steps: 1. Close the instance (if it is still open ). 2. Copy

Oracle Database Backup Recovery, inspection object settings and related recovery overview, oracle Database Backup Database backup and recovery, inspection needs to pay attention to the object settings: 1. database Name and DBID; -- dbid is in v $

Modify the partial score of a field in SQL. Update AA set aa = replace (aa, '20140901', 'normal') where aa like '% 100' How does one change the partial score of a field in SQL SERVER ?? Update AB set cd = replace (cd, 'standard', 'normal') where