SQL Vs NSQL

870 Words2 Pages
bulb-icon

Recommended: Essay about the major types of databases

In the world of database technology, there are two main types of databases: SQL and NoSQL—or, relational databases and non-relational databases. The difference speaks to how they’re built, the type of information they store, and how they store it. Relational databases are structured, like phone books that store phone numbers and addresses.
Non-relational databases are document-oriented and distributed, like file folders that hold everything from a person’s address and phone number to their Facebook likes and online shopping preferences.
First, let’s take a look at one of the main features that separates these two systems: the way they structure data. A relational database—or, an SQL database, named for the language it’s written in, Structured …show more content…

In an SQL database like MySQL, Sybase, Oracle, or IBM DM2, SQL executes queries, retrieves data, and edits data by updating, deleting, or creating new records. SQL is a lightweight, declarative language that does a lot of heavy lifting for the relational database, acting like a database’s version of a server-side script. One particular advantage of SQL is its simple-yet-powerful JOIN clause, which allows developers to retrieve related data stored across multiple tables with a single command.
POPULAR SQL DATABASES AND RDBMS’S
• MySQL—the most popular open-source database, excellent for CMS sites and blogs.
• Oracle—an object-relational DBMS written in the C++ language.
• Sybase—a relational model database server product for businesses primarily used on the Unix OS, which was the first enterprise-level DBMS for Linux.
• MS SQL Server—a Microsoft-developed RDBMS for enterprise-level databases that supports both SQL and NoSQL architectures.
• Microsoft Azure—a cloud computing platform that supports any operating system, and lets you store, compute, and scale data in one …show more content…

Relation databases have a fraught connection with applications written in object-oriented programming languages like Java, PHP, and Python. NoSQL databases are more likely to ide-step this conflict through APIs, which enables developers to eliminate questions without having to understand or learn the repressed architecture of their database system.
COMMON TYPES OF NOSQL DATABASES
1. Key-value model—the least complex NoSQL option, which stores data in a schema-less way that consists of indexed keys and values. Examples: Cassandra, Azure, LevelDB, and Riak.
2. Column store—or, wide-column store, which stores data tables as columns rather than rows. It’s more than just an inverted table—sectioning out columns allows for excellent scalability and high performance. Examples: HBase, BigTable, HyperTable.
3. Document database—taking the key-value concept and adding more complexity, each document in this type of database has its own data, and its own unique key, which is used to retrieve it. Examples: MongoDB, CouchDB.
4. Graph database—have data that’s interconnected and best represented as a graph? This method is capable of lots of complexity. Examples: Polyglot,

Show More
Related

  • Itt Trip Scheduling

    1371 Words  | 3 Pages

    problem and it will be used in this case to build the databases. The databases

    Read More

  • Big Data Essay

    861 Words  | 2 Pages

    ...now use. Majority of the world’s data is unstructured. Big data technology lets us analyze and bring together data of different types. A common theme in the data is that it is diverse. It doesn’t fall into a relational structure. Different browsers send different data; users withhold information, different forms of software versions, or vendors to communicate with you. There will be many errors and inconsistency if the process involves people. Big data is used to take unstructed data and extract ordered meaning. This is for consumption by users or it is structured input into an application.

    Read More

  • Microsoft Rhetorical Analysis Essay

    1803 Words  | 4 Pages

    A cloud can be a white, puffy object that aimlessly floats hundreds, if not thousands of feet in the air. Or a cloud can be gray and gloomy, signaling imminent showers or thunderstorms. However, the identity of a cloud is beginning to change in the modern era. In the modern era, Microsoft is attempting to redefine a cloud as being a service that electronically stores data from a large variety of sources. In particular, Microsoft advertises their new cloud service, Azure, in Fortune magazine, in an attempt to appeal to businesses that require a cloud service to store data, and to meet their consumer’s needs on the web. Though the most peculiar part of the advertisement is the comparison of weather phenomena and Microsoft’s

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.

    Read More

  • Elastic Computer Cloud

    1295 Words  | 3 Pages

    INTRODUCTION: With cloud computing, Amazon has enabled the usage of internet and central remote servers to maintain data and applications and created an environment where connectivity and availability is unobtrusive and prevalent. Amazon offers two options for hosting applications and databases. Amazon EC2 with Elastic Block Storage allows one to run a MySQL database server on Elastic Compute Cloud, an Infrastructure-as-a-Service provider, with Elastic Block Storage (EBS). Meanwhile, another option called Amazon’s Relational Database Services (RDS) is a scalable relational database in the cloud with high availability.

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Transformation of Healthcare through Big Data Analytics

    776 Words  | 2 Pages

    DISTRIBUTED DATABASES: A distributed database system consists of loosely coupled systems that have no common physical components.

    Read More

  • Relational Database Analysis

    946 Words  | 2 Pages

    When discussing the topic of databases most individual’s minds go to a relational database. Where data is stored in tables and they are inter-related to one another by the use of primary and foreign keys. The increased interest on big data has caused some companies to forgo the standard RDBMS in favor of a system that would better suit their needs. This is where NoSQL comes into play. NoSQL – or “Not Only SQL” – uses different data structures to house data. These structures could look similar to a relational database but others look completely different. Depending on the specific structure used, your choice of Database Management Systems will change as well. There are four common data models to use; Key/Value Stores, Document Databases, Table-Style Databases, and Graph Database (Data Access for Highly Scalable Solutions).

    Read More

  • Data Manipulation Language: Data Manipulation Language In Database Management System

    1635 Words  | 4 Pages

    Data Manipulation Language Data Manipulation refers to data retrieval from the database, data insert into database, modify data of the database and delete data from the database. Since these operations can manipulate data in the database, the language is called as Data Manipulation Language. There are two main types off DMLs. They are as follows: 1. A high-level or procedural DML can be used to specify complex database operations concisely. 2. A low-level or procedural DML must be embedded in a general-purpose programming language. This type of DML retrieves individual records or objects from database and processes each separately. Data Manipulation Language in database management system consists of the following commands : SELECT – Data retrieval

    Read More

  • Data Model: Oodbms Vs. Rdbms

    1025 Words  | 3 Pages

    For this coursework two kinds of data models can be used. The object oriented data model, Object Oriented Database Management System(OODBMS), or the relational data model, Relational Database Management System(RDBMS). The differences between these two models and the data model to be used are described in this chapter.

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Brief History Of Databases

    1727 Words  | 4 Pages

    of multiple types of end users. The data is stored in one location so that they

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    The DBMS has a function that can be differentiate from the information retrieval system. The DBMS have the ability to store, update and retrieve the data. This is the main function of the DBMS because the database can be used if there is any record is being stored into the database. The record need to be retrieve first, then it can be change by the database administrator as it will be the record has been updated. The DBMS will protect the structure of the data structure.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about SQL Vs NSQL

Open Document