In OOP are not tables and rows, objects use polymorphism, inheritance, and it is not uniform. Use objects with RDBMS can be hard.
Mongo DB has no schema to define, no tables and no relationships between collections of objects. Each document can be flat, simple, or complex as we wish. There are no locks of tables, or columns.
Durability vs Consistency
Durability is about whether your data was persisted to durable media before control was returned to you. Eventual consistency in a replica set has to do with whether a document was written to all of the servers, to the primaries and secondaries before control was returned to your application.
· You can ready for inconsistency. Can your application run with? Can it be an issue?
· The application takes control of schema enforcement.
We can backup and restore of Mongo, to import and export information, to monitor the Mongo server, and to share it. You can scale MongoDB horizontally with a replication.
What is BSON ? Store byte arrays on disk..
The BSON specifications can be found on bsonspec.org. Basically, BSON is elementary data types into memory into C data types then to read and to write is fast. BSON specification is data storage serialization format with memory mapped files.
BSON documents has length prefixing. It is fast to find particular a field into store arbitrary object structures and not require to adhere to a particular schema, and this is the key of MongoDB.
Index is important in MongoDb, you must be sure the index is useful and with the correct name of column.
Protects you against tracking through "free", centralized, content delivery.
It prevents a lot of requests from reaching networks like Google Hosted Libraries, and serves local files to keep sites from breaking. Complements regular content blockers.
Prevents Google and Yandex search pages from modifying search result links when you click them.Google and Yandex search pages have the annoying habit of changing the result link when you click it. So if you right-click the link in order to copy it you get some gibberish instead of what you wanted.
This extension disables that behavior – on any Google or Yandex domain, without having to configure anything. Simply install and enjoy! As an added bonus, the search engine can no longer track your clicks.
USE [master] GO CREATE TABLE [dbo].[dbaLogAccess] ( [dbaLogAccessId] [int] IDENTITY (1, 1) NOT NULL , [ConnectionDate] [datetime] NULL , [loginame] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AI NULL , [hostname] [nchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL , [dbname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ) ON [PRIMARY]
Script to add logs, you can run each minute to update the log. This script avoids to repeater, it only saves new connections. We recommend using a job and schedule each minute to run this script.
INSERT INTO master.dbo.dbaLogAccess (ConnectionDate, loginame, hostname, dbname) SELECT DISTINCT tbNew.ConnectionDate, tbNew.loginame, tbNew.hostname, tbNew.dbname FROM (SELECT CONVERT(char(10), GETDATE(), 126) AS ConnectionDate, RTRIM(loginame) AS loginame, hostname, CASE WHEN dbid = 0 THEN '' WHEN dbid <> 0 THEN DB_NAME(dbid) END AS dbname FROM master.dbo.sysprocesses WHERE (hostname <> '')) AS tbNew LEFT OUTER JOIN master.dbo.dbaLogAccess AS tbOld ON tbNew.ConnectionDate = tbOld.ConnectionDate AND tbNew.loginame = tbOld.loginame AND tbNew.hostname = tbOld.hostname AND tbNew.dbname = tbOld.dbname WHERE (tbOld.dbaLogAccessId IS NULL);
This code limit connection by day, we can change by hour or by minute, you just change how many character you use it: