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.

About lynnlangit

redheaded girl geek (SoCalDevGal), linguist, BigData & Cloud expert, SQL Server Business Intelligence author, co-founder of "Teaching Kids Programming"
This entry was posted in Big Data, Cloud, noSQL. Bookmark the permalink.

One Response to Using Variety to get schema info for MongoDB

  1. Tee Dubs says:

    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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s