Big Data, Cloud, noSQL

Using Variety to get schema info for MongoDB

I tried out a utility on GitHub called Variety for MongoDB.  As the creator (@JamesCropcho) says of Variety:

“This lightweight tool helps you get a sense of your application’s schema, as well as any outliers to that schema. Particularly useful when you inherit a codebase with data dump and want to quickly learn how the data’s structured. Also useful for finding rare keys.”

I used this tool on my imported ‘NotAdvWorks’ database to take a look at the structure of the Person.Person collection.  I also used the MongoVue tool to verify the output from Variety, which was stored as a new database called ‘varietyResults’

As I am working on my first couple of production projects with MongoDB, I am really working to get my head around just what ‘schema-less database’ really means for the applications I design. I am also offering a one-day class on May 22, in Anaheim, CA (‘NoSQL for SQL Server Pros‘) to share what I am learning as I work with NoSQL in the real world with my ‘relational’ audience.

I recorded a short YouTube video of working with Variety – enjoy.

One thought on “Using Variety to get schema info for MongoDB

  1. Thank you so much for sharing your exploration with us. It has been a great guide to understanding non-relational, non-star data environments. I am finding this a hard concept to absorb, and your posts have definitely helped me. Kind regards, Tricia Wilcox Almas

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s