--- title: Dynamic Schema in NoSQL description: Dynamic Schema in NoSQL --- [![e-Zest logo\_An accion lab company\_Colour](https://blog.e-zest.com/hubfs/images/Logos%20with%20Tagline/Corporate/SVG/e-Zest%20logo_An%20accion%20lab%20company_Colour.svg "e-Zest logo_An accion lab company_Colour")](https://www.e-zest.com/) - [WORK](https://www.e-zest.com/our-work) - [SERVICES](https://www.e-zest.com/our-services) - [Product Engineering](https://www.e-zest.com/digital-product-engineering-services) - [Enterprise Data Services](https://www.e-zest.com/enterprise-data-services) - [Digital Commerce](https://www.e-zest.com/digital-commerce-services) - [Digital Operations](https://www.e-zest.com/digital-operations) - [Digital Consulting](https://www.e-zest.com/digital-transformation-consulting-services) - [Digital Experience Design](https://www.e-zest.com/digital-experience-design) - [INSIGHTS](https://blog.e-zest.com/) - [CAREERS](https://www.e-zest.com/careers) - [ENTERPRISE DATA SERVICES](https://www.e-zest.com/enterprise-data-services) - [GENERATIVE AI](https://www.e-zest.com/generative-ai) - [Healthcare](https://healthcare.e-zest.com) - [Contact Us](https://www.e-zest.com/contact-us) - ![Elevating Product Engineering with AI and ML](https://blog.e-zest.com/hubfs/Elevating%20Product%20Engineering%20with%20AI%20and%20ML.jpg) [BLOGS](https://blog.e-zest.com) #### Elevating Product Engineering with AI and ML As technology evolves and customer choices broaden, there is an increasing ... [Read more](https://blog.e-zest.com/elevating-product-engineering-with-ai-and-ml) - ![e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024](https://blog.e-zest.com/hubfs/e-Zest%20%E2%80%93%20An%20Accion%20Labs%20Company%20-%20Gets%20Recognition%20as%20a%20Contender%20in%20the%20ISG%20Provider%20LensTM%20Study%20on%20Digital%20Engineering%20Services%202024.jpg) [NEWS](https://blog.e-zest.com/news) #### e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024 We are delighted to announce that e-Zest – An Accion Labs Company has been ... [Read more](https://blog.e-zest.com/news/e-zest-an-accion-labs-company-gets-recognition-as-a-contender-in-the-isg-provider-lens-study-on-digital-engineering-services-2024) - ![e-Zest Solutions supports Digital Pune Mission](https://blog.e-zest.com/hubfs/blog-files/Digital%20Literacy%20Bus%20e-Zest.png) [CSR](https://blog.e-zest.com/csr) #### e-Zest Solutions supports Digital Pune Mission **Pune, India:** e-Zest Solutions, a leading digital technology innovation ... [Read more](https://blog.e-zest.com/csr/e-zest-solutions-supports-digital-pune-mission) - [Work](https://www.e-zest.com/our-work) - [Services](https://www.e-zest.com/our-services) - [Insights](https://blog.e-zest.com) - [Careers](https://www.e-zest.com/careers) - [Enterprise Data](https://www.e-zest.com/enterprise-data-services) - [Generative AI](https://www.e-zest.com/generative-ai) - [Innovations](https://www.e-zest.com/innovations) - [Healthcare](https://healthcare.e-zest.com) - [About](https://www.e-zest.com/about-us) - [Contact](https://www.e-zest.com/contact-us) - [Blog](https://blog.e-zest.com/) - [News](https://blog.e-zest.com/news) - [CSR](https://blog.e-zest.com/csr) - [![Linkedin Icon](https://blog.e-zest.com/hubfs/icons/linkedin_icon_white.svg)](https://www.linkedin.com/company/e-zest-solutions/) - [![Twitter Icon](https://blog.e-zest.com/hubfs/twitter-logo-silhouette%20(5).svg)](https://twitter.com/ezest) - [![Facebook Icon](https://blog.e-zest.com/hubfs/facebook-app-logo%20(4).svg)](https://www.facebook.com/61259256638) - [![Instagram Icon](https://blog.e-zest.com/hubfs/instagram-logo%20(4).svg)](https://www.instagram.com/ezestsolutions/) - [![Youtube Icon](https://blog.e-zest.com/hubfs/icons/youtube_icon_white.svg)](https://www.youtube.com/user/ezestcorporate) [![Go to top icon](https://blog.e-zest.com/hubfs/AA%20Assets/top%20button.svg)](https://blog.e-zest.com/dynamic-schema-in-nosql/#top) Hit enter to search or ESC to close Insights e-Zest members share technology ideas to foster digital transformation. - [Blog](https://blog.e-zest.com) - [News](https://blog.e-zest.com/news) - [Podcasts](https://www.e-zest.com/podcasts) - [Healthcare](https://blog.e-zest.com/healthcare) - [CSR](https://blog.e-zest.com/csr) - [Whitepaper](https://blog.e-zest.com/whitepaper) - [Playbook](https://blog.e-zest.com/playbook) - [Media Kit](https://www.e-zest.com/media-kit) # Dynamic Schema in NoSQL [Anuradha Bankar](https://blog.e-zest.com/author/anuradha-bankar) Jan 14, 2014 [business intelligence](https://blog.e-zest.com/topic/business-intelligence-2) - - - - I always used to wonder why we need NoSQL database in first place like most of the developers who have worked on SQL. As I started exploring it, the thing that struck me most is NoSQL's "Dynamic Schema". In Relational databases, you need to define schemas before you can add data. Structure and data types are fixed in advance. For example, you define a customer table with first name, last name and phone number. Now if you want to store customer address and his/her favorites then you'll have to add new columns to the table. Each time you add a new feature in your application, the schema of your database changes. If the database is large, this is a very slow process and involves significant downtime. NoSQL databases are built to store data without a predefined schema. This makes it easy to make significant application changes in real-time. So in NoSQL database, dissimilar data of customer and product can be stored together, if necessary. There's also no way, using a relational database, to effectively address unstructured or unknown data. NoSQL databases have provided a solution for dealing with modern scaling and data format challenges. NoSQL is not a replacement for SQL databases, but it is a valid alternative for a lot of situations where standard SQL is not the best approach to store your data. Selecting the right database for your application is important. Following should be your parameters to decide one database type over another: - Manage structured or unstructured data - To scale or perform beyond the capabilities of your existing system - Affordable alternatives or expensive proprietary software - Need for speed and agility of development - - - ### Similar Blog [![The New Age of Data-led Digital Transformation](https://blog.e-zest.com/hubfs/dd%20blog.jpg) The New Age of Data-led Digital Transformation Digital Transformation in organizations has placed data where it deserves to be – at the center of the Digital Enterprise. The ... By Devendra Deshmukh Mar 10, 2020](https://blog.e-zest.com/the-new-age-of-data-led-digital-transformation) [![Insightful Tips CIOs must not Ignore](https://blog.e-zest.com/hubfs/Blog%20Graphics%20(Insightful%20tips%20CIOs%20must%20not%20ignore%20in%202017).jpg) Insightful Tips CIOs must not Ignore CIOs of enterprises are under tremendous pressure to innovate and evolve according to the ever changing business dynamics. CIOs ... By Nidhi Thakkar Jan 27, 2017](https://blog.e-zest.com/insightful-tips-cios-must-not-ignore-in-2017) [![Qlik Sense - GenX of Qlikview](https://blog.e-zest.com/hubfs/blog-files/qlik.jpg) Qlik Sense - GenX of Qlikview We all are familiar with QlikView, the leading data visualization tool. Qlik community has recently introduced Qlik Sense 2.1 as ... By Nilam Mahajan Nov 26, 2015](https://blog.e-zest.com/qlik-sense-genx-of-qlikview) [![Technology in the News- Week 37, 2015](https://blog.e-zest.com/hs-fs/file-3419272476-jpg/blog-files/tech-digest-week-37.jpg) Technology in the News- Week 37, 2015 **Microsoft acquires cyber security startup Adallom** By Corporate Sep 11, 2015](https://blog.e-zest.com/technology-in-the-news-week-37-2015/) [![Tech stories handpicked for you -Week 34, 2015](https://blog.e-zest.com/hs-fs/file-3419271906-jpg/blog-files/tech-digest-week-33.jpg) Tech stories handpicked for you -Week 34, 2015 By Corporate Aug 22, 2015](https://blog.e-zest.com/tech-stories-handpicked-for-you-week-34-2015/) [![Using AngularJS with Pentaho Dashboard](https://blog.e-zest.com/hubfs/img-1.jpg) Using AngularJS with Pentaho Dashboard Pre Requisite: Knowledge of AngularJS is needed. By Anuradha Bankar Oct 04, 2016](https://blog.e-zest.com/using-angularjs-with-pentaho-dashboard) [![Hichert chart in MicroStrategy](https://blog.e-zest.com/hubfs/img-1-10.png) Hichert chart in MicroStrategy **What is HICHERT®SUCCESS?**Prof Dr. Rolf Hichert wanted to make business communication most successful. He initiated the SUCCESS ... By Anuradha Bankar Jun 02, 2016](https://blog.e-zest.com/hichert-chart-in-microstrategy) [![Connecting to Magento API with Pentaho ETL (Spoon)](https://blog.e-zest.com/hubfs/workflow-1.jpg) Connecting to Magento API with Pentaho ETL (Spoon) Magentois a popular open-sourcee-commerce platform which is highly customizable and has all the features to build a shopping ... By Anuradha Bankar May 26, 2016](https://blog.e-zest.com/connecting-to-magento-api-with-pentaho-etl-spoon) [![Elasticsearch vs Graph Database](https://blog.e-zest.com/hs-fs/file-3419272691-jpg/blog-files/elastic-search-vs-graph-database.jpg) Elasticsearch vs Graph Database Recently, I worked on a project which involved building a genealogy portal to gather information about individuals and their ... By Anuradha Bankar Sep 24, 2015](https://blog.e-zest.com/elasticsearch-vs-graph-database/) [Sharding and Replication in MongoDB Sharding and Replication have become important tool in today’s application database design. We have couple of ongoing projects ... By Anuradha Bankar Jan 23, 2014](https://blog.e-zest.com/sharding-and-replication-in-mongodb/) ## Helping Organizations Thrive in the Digital Age [Contact Us](https://www.e-zest.com/contact-us) - [About](https://www.e-zest.com/about-us) - [Services](https://www.e-zest.com/our-services) - [Work](https://www.e-zest.com/our-work) - [Insights](https://blog.e-zest.com/) - [Healthcare](https://healthcare.e-zest.com/) - [Accion Labs](https://www.accionlabs.com/) - - - - - - Dallas - Detroit - Hannover - Vienna - London - Pune © 2025 e-Zest Solutions - [Privacy Policy](https://www.e-zest.com/privacypolicy) - [Cookie Policy](https://www.e-zest.com/cookie-policy) Contact us Contact us e-Zest is a leading digital innovation partner for enterprises and technology companies that utilizes emerging technologies for creating engaging customers experiences. Being a customer-focused and technology-driven company, it always helps clients in crafting holistic business value for their software development efforts. It offers software development and consulting services for cloud computing, enterprise mobility, big data and analytics, user experience and digital commerce.