People Innovation Excellence
 

What is Database? (Part 2)

Pros of NoSQL/NewSQL

  • Very fast (NoSQL) 
  • Not requiring fixed table schemas (NoSQL) 
  • Scales horizontally (NoSQL) 
  • Stronger consistency (NewSQL) 
  • Full transactional support possible (NewSQL)

 Cons of NoSQL/NewSQL

  • Not transactional/ACID (NoSQL) 
  • Can get messy (NoSQL) 
  • Not offering as many development tools as SQL (NewSQL)

Excel: Databases or spreadsheets?

Let’s get back to the relational databases. Based on the assumption relational databases take the form of tables made of columns and rows, is Excel a database? If you want a real entertaining discussion, drop this question to a bunch of programmers. I suggest you run in the other direction, as it may get real ugly! Most of us will agree that even if Excel and its spreadsheets can be extremely useful, they’re not databases. If we look at it objectively, Excel creates spreadsheets. Spreadsheets are in fact tables made of columns and rows. It’s the table format that tends to confuse people into thinking that spreadsheets are relational databases. We already agreed on the fact that databases are used for data management. Spreadsheets don’t go as far and are mostly used for data storage and analysis.

Pros of using Excel

  • Ease of use
  • Short learning curve
  • No programming skills needed
  • Perfect for numerical data
  • Perfect to manage small pools of data
  • Great for data analysis
  • Inexpensive solution

Cons of using Excel

  • Static
  • Only one user at a time can update data
  • Substantial spreadsheets will eventually become tougher to manage and lead to errors in the data
  • One action could break something somewhere without the users realizing it
  • Data stored on your computer (hard drive) versus databases (servers)

Example

Example of Database Software Oracle Database Oracle began its journey in 1979 as the first commercially available relational database management system (RDBMS). Oracle’s name is synonymous with enterprise database systems, unbreakable data delivery and fierce corporate competition from CEO Larry Ellison. Powerful but complex database solutions are the mainstay of this Fortune 500 company. The current release of Oracle’s RDBMS is Oracle 12c. The “c” stands for cloud and is reflective of Oracle’s work in extending its enterprise RDBMS to enable firms to consolidate and manage databases as cloud services when needed via Oracle’s multitenant architecture and in-memory data processing capabilities. Oracle 12c Release 1 will be fully supported by Oracle through the end of July, 2018.

Reference : https://www.kohezion.com/blog/4-examples-database-application/

 

Created by : Christoper Joshua | 1801412215

Lecturer : Marisa Karsen/D4639


Published at : Updated
Written By
Marisa Karsen
Subject Content Coordinator | Information System, Binus University http://sis.binus.ac.id
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close