book

MongoDB Fundamentals

Name: MongoDB Fundamentals
ISBN: 9781839210648

by Amit Phaltankar, Juned Ahsan, Michael Harrison, Liviu Nedov, Sam Anderson

December 2020

Beginner

748 pages

13h 50m

English

Packt Publishing

Read now

Unlock full access

MongoDB Fundamentals
Preface
About the BookAbout the AuthorsWho This Book Is ForAbout the ChaptersConventionsBefore You BeginInstalling MongoDBEditors and IDEsDownloading and Installing Visual Studio CodeDownloading Node.jsWindowsMacLinuxVerifying the InstallationInstalling the Code BundleGet in TouchPlease Leave a Review
1. Introduction to MongoDB
IntroductionDatabase Management SystemsRelational Database Management SystemsNoSQL Database Management SystemsComparisonIntroduction to MongoDBMongoDB EditionsMigrating Community Edition to Enterprise EditionThe MongoDB Deployment ModelManaging MongoDBSelf-ManagedManaged Service: Database as a ServiceMongoDB AtlasMongoDB Atlas BenefitsCloud ProvidersAvailability ZonesRegionsMongoDB Supported Regions and Availability ZonesAtlas TiersMongoDB Atlas PricingCluster Cost EstimationExercise 1.01: Setting Up a MongoDB Atlas AccountMongoDB Atlas Organizations, Projects, Users, and ClustersOrganizationsExercise 1.02: Setting Up a MongoDB Atlas OrganizationProjectsExercise 1.03: Creating a MongoDB Atlas ProjectMongoDB ClustersExercise 1.04: Setting Up Your First Free MongoDB Cluster on AtlasConnecting to Your MongoDB Atlas ClusterMongoDB ElementsDocumentsDocument StructuresCollectionsUnderstanding MongoDB DatabasesCreating a DatabaseCreating a CollectionCreating a Collection Using Document InsertionCreating DocumentsInserting a Single DocumentInserting Multiple DocumentsFetching Documents from MongoDBFormatting the find Output Using the pretty() MethodActivity 1.01: Setting Up a Movies DatabaseSummary
2. Documents and Data Types
IntroductionIntroduction to JSONJSON SyntaxJSON Data TypesJSON and NumbersJSON and DatesExercise 2.01: Creating Your Own JSON DocumentBSONMongoDB DocumentsDocuments and FlexibilityMongoDB Data TypesStringsNumbersBooleansObjectsExercise 2.02: Creating Nested ObjectsArraysExercise 2.03: Using Array FieldsNullObjectIdDatesTimestampsBinary DataLimits and Restrictions on DocumentsDocument Size LimitNesting Depth LimitField Name RulesExercise 2.04: Loading Data into an Atlas ClusterActivity 2.01: Modeling a Tweet into a JSON DocumentSummary
3. Servers and Clients
IntroductionNetwork AccessNetwork ProtocolsPublic versus Private IP AddressesDomain Name ServerTransmission Control ProtocolThe Wire ProtocolNetwork Access ConfigurationThe IP Access List Temporary AccessNetwork PeeringExercise 3.01: Enabling Network AccessDatabase AccessUser AuthenticationUsername StorageUsername AuthenticationConfiguring Authentication in AtlasTemporary UsersDatabase Privileges and RolesPredefined RolesConfiguring Built-In Roles in AtlasAdvanced PrivilegesExercise 3.02: Configuring Database AccessConfiguring Custom RolesThe Database ClientConnection StringsThe Mongo ShellExercise 3.03: Connecting to the Cloud Database Using the Mongo ShellMongoDB CompassMongoDB DriversExercise 3.04: Connecting to a MongoDB Cloud Database Using the Python DriverServer CommandsPhysical StructureDatabase FilesDatabase MetricsLogical StructureServer CommandsExercise 3.05: Creating a Database View ObjectActivity 3.01: Managing Your Database UsersSummary
4. Querying Documents
IntroductionMongoDB Query StructureBasic MongoDB QueriesFinding DocumentsUsing findOne()Exercise 4.01: Using find() and findOne() Without a ConditionChoosing the Fields for the OutputFinding the Distinct FieldsCounting the Documentscount()countDocuments()estimatedDocumentCount()Conditional OperatorsEquals ($eq)Not Equal To ($ne)Greater Than ($gt) and Greater Than or Equal To ($gte)Less Than ($lt) and Less Than or Equal To ($lte)In ($in) and Not In ($nin)Exercise 4.02: Querying for Movies of an ActorLogical Operators$and operator$or Operator$nor Operator$not OperatorExercise 4.03: Combining Multiple QueriesRegular ExpressionsUsing the caret (^) operatorUsing the dollar ($) operatorCase-Insensitive SearchQuery Arrays and Nested DocumentsFinding an Array by an ElementFinding an Array by an ArraySearching an Array with the $all OperatorProjecting Array ElementsProjecting Matching Elements Using ($)Projecting Matching Elements by their Index Position ($slice)Querying Nested ObjectsQuerying Nested Object FieldsExercise 4.04: Projecting Nested Object FieldsLimiting, Skipping, and Sorting DocumentsLimiting the ResultLimit and Batch SizePositive Limit with Batch SizeNegative Limits and Batch SizeSkipping DocumentsSorting DocumentsActivity 4.01: Finding Movies by Genre and Paginating ResultsSummary
5. Inserting, Updating, and Deleting Documents
IntroductionInserting DocumentsInserting Multiple DocumentsInserting Duplicate KeysInserting without _idDeleting DocumentsDeleting Using deleteOne()Exercise 5.01: Deleting One of Many Matched DocumentsDeleting Multiple Documents Using deleteMany()Deleting Using findOneAndDelete()Exercise 5.02: Deleting a Low-Rated MovieReplacing Documents_id Fields Are ImmutableUpsert Using ReplaceWhy Use Upsert?Replacing Using findOneAndReplace()Replace versus Delete and Re-InsertModify FieldsUpdating a Document with updateOne()Modifying More Than One FieldMultiple Documents Matching a ConditionUpsert with updateOne()Updating a Document with findOneAndUpdate()Returning a New Document in ResponseSorting to Find a DocumentExercise 5.03: Updating the IMDb and Tomatometer RatingUpdating Multiple Documents with updateMany()Update OperatorsSet ($set)Increment ($inc)Multiply ($mul)Rename ($rename)Current Date ($currentDate)Removing Fields ($unset)Setting When Inserted ($setOnInsert)Activity 5.01: Updating Comments for MoviesSummary
6. Updating with Aggregation Pipelines and Arrays
IntroductionUpdating with an Aggregation Pipeline (MongoDB 4.2)Stage 1 ($set)Stage 2 ($set)Stage 3 ($project)Updating Array FieldsExercise 6.01: Adding Elements to ArraysAdding Multiple ElementsSort ArrayAn Array as a SetExercise 6.02: New Category of Classic Movies Removing Array ElementsRemoving the First or Last Element ($pop)Removing All ElementsRemoving Matched ElementsUpdating Array ElementsExercise 6.03: Updating the Director's NameActivity 6.01: Adding an Actor's Name to the CastSummary
7. Data Aggregation
Introductionaggregate Is the New findAggregate SyntaxThe Aggregation PipelinePipeline SyntaxCreating AggregationsExercise 7.01: Performing Simple AggregationsExercise 7.02: Aggregation StructureManipulating DataThe Group StageAccumulator ExpressionsExercise 7.03: Manipulating DataExercise 7.04: Selecting the Title from Each Movie CategoryWorking with Large DatasetsSampling with $sampleJoining Collections with $lookupOutputting Your Results with $out and $mergeExercise 7.05: Listing the Most User-Commented MoviesGetting the Most from Your AggregationsTuning Your PipelinesFilter Early and Filter OftenUse Your IndexesThink about the Desired OutputAggregation OptionsExercise 7.06: Finding Award-Winning Documentary MoviesActivity 7.01: Putting Aggregations into PracticeSummary
8. Coding JavaScript in MongoDB
IntroductionConnecting to the DriverIntroduction to Node.jsGetting the MongoDB Driver for Node.jsThe Database and Collection ObjectsConnection ParametersExercise 8.01: Creating a Connection with the Node.js DriverExecuting Simple QueriesCreating and Executing find QueriesUsing Cursors and Query ResultsExercise 8.02: Building a Node.js Driver QueryCallbacks and Error Handling in Node.jsCallbacks in Node.jsBasic Error Handling in Node.jsExercise 8.03: Error Handling and Callbacks with the Node.js DriverAdvanced QueriesInserting Data with the Node.js DriverUpdating and Deleting Data with the Node.js DriverWriting Reusable FunctionsExercise 8.04: Updating Data with the Node.js DriverReading Input from the Command LineCreating an Interactive LoopExercise 8.05: Handling Inputs in Node.jsActivity 8.01: Creating a Simple Node.js ApplicationSummary

9. Performance
IntroductionQuery AnalysisExplaining the QueryViewing Execution StatsIdentifying ProblemsLinear SearchIntroduction to IndexesCreating and Listing IndexesListing Indexes on a CollectionIndex NamesExercise 9.01: Creating an Index Using MongoDB Atlas Query Analysis after IndexesHiding and Dropping IndexesDropping Multiple IndexesHiding an IndexExercise 9.02: Dropping an Index Using Mongo AtlasType of IndexesDefault IndexesSingle-Key IndexesCompound IndexesMultikey IndexesText IndexesIndexes on Nested DocumentsWildcard IndexesProperties of IndexesUnique IndexesExercise 9.03: Creating a Unique IndexTTL IndexesExercise 9.04: Creating a TTL index using Mongo ShellSparse IndexesExercise 9.05: Creating a Sparse Index Using Mongo Shell Partial IndexesExercise 9.06: Creating a Partial Index Using the Mongo Shell Case-Insensitive IndexesExercise 9.07: Creating a Case-Insensitive Index Using the Mongo Shell Other Query Optimization TechniquesFetch Only What You NeedSorting Using IndexesFitting Indexes in the RAMIndex SelectivityProviding HintsOptimal IndexesActivity 9.01: Optimizing a QuerySummary
10. Replication
IntroductionHigh-Availability ClustersCluster NodesShare-NothingCluster NamesReplica SetsPrimary-SecondaryThe OplogReplication ArchitectureCluster MembersThe Election ProcessExercise 10.01: Checking Atlas Cluster MembersClient ConnectionsConnecting to a Replica SetSingle-Server ConnectionsExercise 10.02: Checking the Cluster ReplicationRead PreferenceWrite ConcernDeploying ClustersAtlas DeploymentManual DeploymentExercise 10.03: Building Your Own MongoDB ClusterEnterprise DeploymentCluster OperationsAdding and Removing MembersAdding a MemberRemoving a MemberReconfiguring a ClusterFailoverFailover (Outage)RollbackSwitchover (Stepdown)Exercise 10.04: Performing Database MaintenanceActivity 10.01: Testing a Disaster Recovery Procedure for a MongoDB DatabaseSummary
11. Backup and Restore in MongoDB
IntroductionThe MongoDB UtilitiesExporting MongoDB DataUsing mongoexportmongoexport OptionsExercise 11.01: Exporting MongoDB DataImporting Data into MongoDBUsing mongoimportmongoimport OptionsExercise 11.02: Loading Data into MongoDBBacking up an Entire DatabaseUsing mongodumpmongodump OptionsExercise 11.03: Backing up MongoDBRestoring a MongoDB DatabaseUsing mongorestoreThe mongorestore OptionsExercise 11.04: Restoring MongoDB DataActivity 11.01: Backup and Restore in MongoDBSummary
12. Data Visualization
IntroductionExploring Menus and TabsDashboardsData SourcesExercise 12.01: Working with Data SourcesData Source PermissionsBuilding ChartsFieldsTypes of ChartsBar and Column ChartsExercise 12.02: Creating a Bar Chart to Display MoviesCircular ChartsExercise 12.03: Creating a Pie Chart Graph from the Movies CollectionGeospatial ChartsExercise 12.04: Creating a Geospatial ChartComplex ChartsPreprocessing and Filtering Data Filtering DataAdding Custom FieldsChanging FieldsChannelsAggregation and BinningExercise 12.05: Binning Values for a Bar GraphIntegrationEmbedded ChartsExercise 12.06: Adding Charts to HTML pagesActivity 12.01: Creating a Sales Presentation DashboardSummary
13. MongoDB Case Study
IntroductionFair Bay City Council Fair Bay City BikesProposal HighlightsDockless BikesEase of UseReal-Time TrackingMaintenance and CareTechnical Discussions and DecisionsQuick RolloutCost EffectiveFlexibleDatabase DesignUsersVehiclesRidesRide LogsUse CasesUser Finds Available BikesUser Unlocks a BikeUser Locks the BikeSystem Logs the Geographical Coordinates of RidesSystem Sends Bikes for MaintenanceTechnician Performs Fortnightly MaintenanceGenerating StatsSummary
Appendix
1. Introduction to MongoDBActivity 1.01: Setting Up a Movies Database2. Documents and Data TypesActivity 2.01: Modeling a Tweet into a JSON Document3. Servers and ClientsActivity 3.01: Managing Your Database Users4. Querying DocumentsActivity 4.01: Finding Movies by Genre and Paginating Results5. Inserting, Updating, and Deleting DocumentsActivity 5.01: Updating Comments for Movies6. Updating with Aggregation Pipelines and ArraysActivity 6.01: Adding an Actor's Name to the Cast7. Data AggregationActivity 7.01: Putting Aggregations into Practice8. Coding JavaScript in MongoDBActivity 8.01: Creating a Simple Node.js Application9. PerformanceActivity 9.01: Optimizing a Query10. ReplicationActivity 10.01: Testing a Disaster Recovery Procedure for a MongoDB Database11. Backup and Restore in MongoDBActivity 11.01: Backup and Restore in MongoDB12. Data VisualizationActivity 12.01: Creating a Sales Presentation Dashboard

Content preview from MongoDB Fundamentals

9. Performance

Overview

This chapter introduces you to the concepts of query optimization and performance improvement in MongoDB. You will first explore the internal workings of query execution and identify the factors that can affect query performance, before moving on to database indexes and how indexes can reduce query execution time. You will also learn how to create, list, and delete indexes, and study the various types of indexes and their benefits. In the final sections, you will be introduced to various query optimization techniques that can help you use indexes effectively. By the end of this chapter, you will be able to analyze queries and use indexes and optimization techniques to improve query performance.

Introduction

In the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Practical MongoDB: Architecting, Developing, and Administering MongoDB

Publisher Resources

ISBN: 9781839210648

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

MongoDB Fundamentals

by Amit Phaltankar, Juned Ahsan, Michael Harrison, Liviu Nedov, Sam Anderson

9. Performance

Introduction

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.