Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most SQL database tuning will…
Why you may need it? I am a developer, and I work daily in Integrated Development Environments (IDE), such as Intellij IDEA or Eclipse. These IDEs are desktop applications. Since the advent of Google Documents, I have seen more and…
Find below sample for loop to generate a document with array, sub-document, nested-document use mydb db.studentscol.drop() for(var i = 1; i <= 1000 ; i++){var r= Math.random().toString(36).substring(7); db.studentscol.insert( { _id:i, name:r, address: { address_id:i, state:r,country:”India”,street:{name:r,colony:{ name:r,pin:r}}}, hobbies: [{h1:r},{h2:r},{h3:r},{h4:r}] });} //…
Roles & Responsibilities 01) Defragmentation 02) Schema Design – working with Application/Development team 03) Query fine tuning 04) Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fails, disk usage .. etc 05) Backup and restores (…
MongoDB itself has provided some basic looping mechanism through which you can achieve iteration functionality. let’s discuss one by one. FOR LOOP:- For loop is a basic loop available in mongodb and its syntax is just same as we have…
VDRs are gaining popularity among businessmen all over the planet. Investment bankers, lawyers and top managers of corporations need the functional and safe place to keep their documents and to finish plenty of deals. Thus, today, VDR providers provide the…
using System; using MongoDB.Bson; using MongoDB.Driver; using MongoDB.Driver.Builders; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 { class Program { protected static IMongoClient _client; protected static IMongoDatabase _database; public static void Main(string[] args) { var credential = MongoCredential.CreateGssapiCredential(“user@DBVERSITY.COM”);…
The following table clearly explains what each Oplog field denotes. Field Name Alias Details Operations Values ts TimeSpace Holds the “Time of the operation” & “incremental id”. For all bulk (insert/remove/update) operations “Time of the operation” remains same and…
As of MemSQL 5.0, MemSQL includes an authentication plugin that enables a MemSQL Server to use PAM (Pluggable Authentication Modules) to authenticate users. PAM enables a system to use a standard interface to access various kinds of authentication…
Visualizing Data Makes It Easier To Read When dealing with data analysis, most companies rely on MS Excel or Google Sheets. While those are powerful tools, it’s difficult to notice trends, much less make any sense out of large rows…