Skip to content
  • Blog
  • Events
  • Help
  • Careers
  • Contact
New Signature
  • About
      • Company

        Cognizant Microsoft Business Group is dedicated to changing the way businesses innovate, transform and run based on a unique cloud operating model. You will now be redirected to our new microsite to learn more.

        View Company

      • Awards

        As a company, we are regularly recognized within the IT industry as well as the communities we serve.

        View All Awards
      • News

        Read the most up-to-date corporate announcements, Microsoft technology updates, innovative business solutions and learn more about how the Cognizant Microsoft Business Group can take your business even farther.

        View News

      • Partners

        New Signature works with a number of outstanding technology companies to deliver the best experiences to our customers.

        View Partners
      • Leadership

        Cognizant Microsoft Business Group’s executive team is comprised of innovative leaders with proven experience and deep industry expertise. You will now be redirected to our new microsite to learn more.

        View Leadership

      • Industries

        Our solutions are tailored to empower organizations across a wide range
        of industries.

        View Industry Experience
    Close
  • Solutions
      • Intelligent Enterprise
        Solutions

        Going Digital
        Unleash cloud capability, deliver change and compete at speed with a Microsoft digital operating model, enabling you to work more efficiently as you transform your IT environment. Learn More

      • Featured Solution

        Secure Cloud
        In a world of constant threat, ensuring that your underlying cloud platform is protected is the first step on your organization’s journey towards a secure, compliant operating environment. Learn More
      • Intelligent Workplace
        Solutions

      • Secure Workplace

        Work Anywhere

        Endpoint Health

        Identity Health

        Teamwork Support



        VIEW WORKPLACE SOLUTIONS
      • Intelligent Cloud
        Solutions

      • App Factory

        Azure Accelerator

        Azure Launchpad

        Azure Launchpad for DevOps

        Application Health

        Platform Health

        VIEW ClOUD SOLUTIONS
    Close
  • Services
      • Begin your journey towards becoming a digital business with GO, our unique end-to-end framework based on the Microsoft Cloud Adoption Framework.

        GO DIGITAL OPERATING MODEL
      • Intelligent Enterprise

      • Consulting

        We go beyond just technology to help your organization understand how digital can help you uniquely differentiate and better serve your employees and customers.

        VIEW ENTERPRISE SERVICES
      • Intelligent Workplace

        • Identity

          Identity is your new first-line-of-defense. It’s vital to your users and clients that your identity platform is properly configured and secured.

          Endpoint

          Whether your devices are on-premises or remote, personal or business-owned, we can ensure they are properly managed and protected.

          Teamwork

          Today’s workforce is collaborating than ever before.  We can empower your current teams with tomorrow’s progressive technologies.

          VIEW WORKPLACE SERVICES
        • Intelligent Cloud

          • Platform

            The cloud is no longer some future-state. It’s the here and now. Adopting a cloud-first platform is one of the best ways to maintain a future-proofed competitive advantage.

            Applications

            We build cloud-native apps and modernize legacy systems with the power of Azure to give your organization a competitive edge.

            Data

            We can help your organization create secure, scalable data platforms to deliver simpler and more sophisticated insights to your business.

            VIEW CLOUD SERVICES
        Close
      • Client Stories
          • Case Studies

            Browse a comprehensive list of companies who have created successful partnerships and experienced transformative solutions with New Signature.

            View All Case Studies

          • Featured Case Study TalkTalk Modern Workplace

            New Signature worked with TalkTalk to define a new Modern Workplace solution based on Microsoft 365, which kept the user firmly at the center of the transformation.
            View Case Study

          • Testimonials

            We love transforming our customers businesses, take a look at what they have to say about New Signature.

            View Testimonials

          • Featured Testimonial Davis Construction

            With New Signature’s help, Davis was able to take a progressive step forward by migrating their private branch exchange (PBX) phone system to a Voice of Internet Protocol (VoIP) system.
            View Testimonial

        Close
      • Explore
          • Guides & Ebooks

            Dive deeper into education with your team by leveraging our expert-developed guides and eBooks.

            View All Guides & Ebooks

          • Infographics

            Rich with statistics and information, our infographics are great tools for quick but insightful learning.

            View All Infographics
          • Podcast: Office Explorers

            Join Kat and Rob monthly as they chat with New Signature experts and explore the world of O365.

            Listen to Podcasts

          • Videos

            Visit our videos stream to access recorded webinars, service information and to learn more about us.

            WATCH ALL VIDEOS
          • Flyers

            Searching for information about our services? Our flyers are a great takeaway for all those details.

            VIEW ALL FLYERS

          • Featured Stream

            Learn more about the tooling and expertise required to unlock productivity and mobilize your teams.

            MODERN WORKPLACE
        Close
        Close
      Blog

      Exploring the NoSQL options on Azure

      New Signature / Blog / Exploring the NoSQL options on Azure
      February 9, 2017| Facundo Gauna
      • Facebook
      • Twitter
      • LinkedIn
      • Print
      Redis Command Line

      For the last couple of years, there’s been a lot of talk around NoSQL. It’s an exciting new world that is unfolding from the good ol’ days of when SQL was the only data persistence in town. Don’t worry, I’ll cover what NoSQL is and how Azure can help you get there.

      What is NoSQL?

      NoSQL is a very big umbrella. It is a name that identifies any type of database that is not relational in the tabular sense.

      Because these databases are schema-less, there’s less overhead on trying to maintain data integrity such us foreign keys, data types, and optional fields. Instead, it’s up to the application developers and data scientists to uphold the data integrity.

      Many people aren’t aware that there many types of NoSQL databases. Instead, it is a much broader classification than the RDBMS counterparts like Oracle, SQL Server, and MySQL. I’ll talk about the main categories:

      1. Key-Value Stores
      2. Column-Family Stores
      3. Document Databases
      4. Graph Databases

      Key-Value Stores – The Dictionaries

      Databases that use the concept of a key to access a unit of data (the value). In the simplest sense, they can be looked at a distributed dictionary. They often times offer great reliability and performance at the sacrifice of consistency or scalability. These databases don’t have to worry about joining data together or relationships or maintaining data integrity when new data is added. Some great uses cases for these databases are:

      1. Distributed cache and user/session data
      2. Write-heavy applications like chats, shopping carts, and logs

      Column-Family Stores – The Big Data Boys

      These are databases that store data in columns instead of rows. In a simplistic sense, they are like a SQL database that don’t allow you to:

      1. Query by anything but the primary key
      2. Create indexes to find data faster
      3. Join data together

      Why so many limitations? Because these databases often cater to the Big Data world. They are built to absorb data at a monstrous rate and provide reasonably fast queries given their size. These databases are often so large that they spawn across multiple machines, so that scaling is just a matter of adding another machine node.

      By disallowing joins and queries on the content of the data, each machine needs only needs to worry about the keys that it’s storing. Therefore, a query against one of these databases is essentially only being directed to the node in which the data point lives. These limitations avoid executing each query on all the nodes in the cluster.

      Document Databases – The Lean and Mean

      These database store data in the form of documents such as JSON, BSON, or XML. They are schemaless and they allow creating indexes on the data. Some scale very easily and others are ACID. Each of these databases brings something different when it comes to features. However, these databases are the first candidates to step-in for a traditional relational database. For the most part, they fill much of the same needs that traditional relational databases. Instead of using SQL to manipulate the data, these databases use APIs and SDKs.

      Typically, these databases should be considered depending on your use case and your development environment. Some of the most common value propositions are:

      1. Open-Source
      2. Faster Performance
      3. Faster Developer Agility (Due to APIs/SDKs and Schema-Less)
      4. Eventually Consistent
      5. Less need for optimization, aka less need for a DBA
      6. Less cost in hosting + licensing fees

      Graph Databases – The Fancy Ones

      Hard to believe but these are more relational than traditional tabular relational databases that use SQL. Instead of storing the relationships with the data, they place an emphasis on the relationships themselves then the data. Social networks and recommendation engines make great use cases for graph databases. These databases shines under situations where too many joins would cause havoc on a SQL database.

      NoSQL on Azure

      Azure has PaaS options for NoSQL. If they don’t have the particular solution you need, there’s tons of PaaS offerings in their marketplace. If all else fails, you can host your own database on an Azure Virtual Machine. I’ll cover some of the options by database type and their alternatives.

      Key-Value Stores

      First Choice: Redis
      Redis is the most popular key-value store out there. It is blazing fast and atomic. It’s easy to use and highly reliable. Brian wrote a great post that you can read here.

      Second Choice: Riak (Marketplace)
      Unlike Redis, your dataset doesn’t have to live in memory. In the Azure marketplace you can have Riak as a service.

      Column-Family Stores

      First Choice: HDInsight
      Microsoft’s answer to Big Data. It’s the Windows-friendly version of HBase and Hadoop. You can use other Azure services like Machine Learning and Data Lake Analytics in conjunction.

      Second Choice: Cassandra (Virtual Machine)
      This is not for the faint of heart, but you can host your own. Cassandra was initially developed by Facebook and it’s an alternative to Hadoop/HBase.

      Document Databases

      First Choice: DocumentDB
      Microsoft has been making great gains with this database. Because it’s a first class citizen on Azure, it works with other great services like Azure Machine Learning, IoT Hub, and others. We will continue to see this database grow in terms of features and connectivity with other Azure offerings.

      Second Choice: RavenDB (marketplace)
      Initially inspired by CouchDB, it’s an opinionated database that is steers developers to write performing applications. In the beginning, it mostly catered to .NET development; however, now it also serves HTTP and Java APIs.

      Graph Databases

      First Choice: Neo4j (marketplace)
      This database is designed to supplement other databases. It embraces Polyglot persistence, which is the concept of using multiple database technologies to store your data. Unfortunately, as of today, Azure does not offer a Graph NoSQL database.

      In summary, there’s many great NoSQL offerings on Azure. In today’s world, SQL is not a one size fits all solution. Applications can benefit from multiple database technologies to store their structured and unstructured data. Data persistence should be viewed holistically and we can help you get there.

      Here at Nebbia, we recognize that different database technologies solve different problems. We carry this belief in our application development to provide the best response times for the type of data being accommodated. Contact us today to find out how NoSQL on Azure can help you and your organization.

      Categories
      Tips and Tricks
      Contact New Signature

      Events

      Thu 28

      Power Platform Series: Drive Organizational Productivity with Power Virtual Agents

      January 28 @ 10:00 am - 10:45 am EST
      Feb 16

      Cognizant’s Experience Lab for Continuous Testing with Azure

      February 16 @ 12:00 pm - 2:00 pm EST

      View More

      New Signature
      New Signature HQ
      901 K Street NW, Suite 450
      Washington, DC 20001
      Phone: 202-452-5923
      New Signature Canada HQ
      7th Floor, 5140 Yonge Street
      Toronto, ON M2N 7J8
      Phone: 416-971-4267
      New Signature UK HQ
      57 Bermondsey Street
      London SE1 3XJ
      Phone: +44 (0) 845-402-1752

      About

      • Company
      • Awards
      • News
      • Leadership
      • Partners
      • Industries

      Solutions

      • Intelligent Enterprise Solutions
      • Intelligent Workplace Solutions
      • Intelligent Cloud Solutions

      Services

      • GO
      • Intelligent Enterprise
      • Intelligent Workplace
      • Intelligent Cloud

      Client Stories

      • Client Stories
      • Testimonials

      Explore

      • Guides & Ebooks
      • Podcasts
      • Flyers
      • Infographics
      • Videos
      Copyright © 2021 New Signature
      • Blog
      • Events
      • Careers
      • Help
      • Anti Slavery
      • Privacy Policy
      • Contact
      • About
        • Company
        • Awards
        • News
        • Leadership
        • Partners
        • Industries
      • Services
        • GO
        • Intelligent Enterprise
        • Intelligent Workplace
        • Intelligent Cloud
      • Client Stories
        • Case Studies
        • Testimonials
      • Technologies
      • Explore
        • Guides & Ebooks
        • Infographics
        • Podcast: Office Explorers
        • Videos
        • Flyers
      • Blog
      • Events
      • Careers
      • Contact
      • Search
      Cookie Settings
      New Signature uses "Required Cookies" to run our website, "Functional Cookies" used by third parties to personalise marketing, including social media features.

      Change your preferences by clicking the “Cookie Settings” link at the bottom of every page. Learn more about cookies in our Cookie Policy and our Privacy Policy. By clicking the “Accept Cookies” button below, you consent to our use of cookies.

      Please note that “Required Cookies” will be set regardless of your consent.
      Cookie SettingsAccept Cookies
      Privacy & Cookies Policy
      Performance

      Performance Cookies provide Content Delivery Network assets that deliver faster site content delivery capabilities.

      Required

      These cookies are required mainly in order to deliver Multilanguage site capabilities.

      Functional

      Functional Cookies allow us to provided advanced media capabilities including videos, surveys and other multimedia capabilities.

      Disabling Functional cookies will block the playing of videos and other multimedia site components.

      Targeting

      Targeting Cookies are used to capture user information in order for New Signature to deliver better user experiences.

      Save & Accept