You've probably heard that column indexing is a great way to optimize query performance by minimizing the number of disk accesses required by the query. MongoDB has a specific application of field indexing called Covered Queries, where all of a query's columns are indexed. Covered Queries are very fast because MongoDB doesn't have to examine any documents apart from the indexed ones. In today's blog, we'll be learning how to use Covered Queries to query data faster.
If you've ever tried to locate a specific column in a large database, I'm sure that you'd agree that it can be a painstaking task. You can glean a lot of information about the DB structure from the information_schema schema. It has a list of all tables and all fields that are in a table. You can then run queries using the information that you have gotten from this table. The specific tables involved are SCHEMATA, TABLES and COLUMNS. There are foreign keys such that you can build up exactly how the tables are created in a schema.
In last week's blog, we explored the pros and cons of document relationship modeling via Embedded and Referenced approaches in MongoDB. We then gained some valuable experience with each by creating both an Embedded and Referenced relationship. Today, we'll learn how to create DBRefs in MongoDB.
As the name implies, Relational Databases (RDBMSes) maintain relationships between the tables to organize the data together in meaningful ways. Document databases such as MongoDB are sometimes called "schema-less" due to the fact that they don't really enforce relationships like RDBMSes do. However, while document databases don't require the same predefined structure as a relational database, that doesn't mean that they don't support it. In fact, MongoDB allows relationships between documents to be modeled via Embedded and Referenced approaches. In today's blog, we'll give each a try using Navicat for MongoDB.
Selecting which database will manage all of your company's data can be a very daunting decision; one that will have long-term ramifications for both your employees, partners and customers. Perhaps you're already contemplating a few specific vendors? Not so fast! Have you taken the time to weigh the pros and cons of NoSQL versus traditional relational databases? If not, you've come to the right place. Let's get started!
- 2020 (1)
- 2019 (1)
- December (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- May (1)
- The Between Operator
- Some SELECT Queries You Must Know
- Diagnose Bottlenecks and/or Deadlocks in MySQL 8 using Navicat Monitor
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (2)
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (3)
- April (1)
- March (1)
- February (1)
- January (1)
- 2018 (1)
- 2017 (1)
-
Support
-
About Us
