DBMS Tools

 There are many different DBMS system are available in market, each has it's own feature and limitations. Some of the most common DBMS software are:-  Oracle database, MySQL, Microsoft SQL server, Mongo DB, IBM DB2, PostgreSQL, Cassandra, Couchbase etc...
Today we will be discussing about Oracle database. It is most commonly used for learning purpose among students and professionals.

Oracle 10g:- It was released in 2003 by Oracle corporation.

Features: 

  1. Grid Computing: Oracle 10g introduced the concept of grid computing, which allows multiple computers to work together to solve complex problems. This is like when you and your friends work together on a big project, each doing a different part of the work, to get it done faster and better.

  2. Real Application Clusters (RAC): Oracle 10g allows multiple instances of the Oracle database to run on a cluster of servers, providing scalability, availability, and performance benefits. This is like having many people working together on a game, each taking on a different role to make it more fun and successful.

  3. Flashback Technology: Oracle 10g introduced Flashback technology, which allows users to quickly and easily recover data from a specific point in time, without the need for traditional recovery techniques. This is like being able to rewind a video game to a specific point where you made a mistake, and then try again to get it right.

  4. Automatic Storage Management: Oracle 10g introduced Automatic Storage Management (ASM), which simplifies and streamlines the management of storage for Oracle databases. This is like having a big closet where you can easily find all your clothes and toys, instead of having them scattered around your room.

  5. Security and Auditing: Oracle 10g includes a range of security and auditing features, such as fine-grained access control, encrypted tablespaces, and audit trail management, to help ensure the confidentiality, integrity, and availability of data. This is like having a secret diary or a special toy that you want to keep safe from your little brother or sister, and you have a special lock or hiding place to keep it safe.

    SQL Vs NoSQL

    To Access Database we have SQL(Structured query Language) and NoSQL(Not Only SQL). 

    SQL is a traditional type of database management system that uses a table-based format for storing and managing data. It's designed for managing structured data, which is data that can be easily organized into a table format.Example- Oracle 10g, MySQL..

            NoSQL, on the other hand, is a newer type of database management system that can handle unstructured or semi-structured data, which doesn't fit into the table format of SQL. NoSQL is often used for big data applications and real-time web applications, where performance and scalability are critical.Example:- Cassandra, MongoDB..

    Overall, the choice between SQL and NoSQL depends on the specific needs of the application and the type of data being stored and managed.

     

     

     

Comments

Post a Comment