Skip to main content

DBMS Basics

Data Base Management System:

Data base is nothing but collection of tables.

Table is  collection of rows and columns.

DBMS is the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures.

OR

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

There are four structural types of database management systems:
  • Hierarchical databases.
  • Network databases.
  • Relational databases.
  • Object-oriented databases.
Hierarchical Databases (DBMS)
In the Hierarchical Database Model we have to learn about the databases. It is very fast and simple. In a hierarchical database, records contain information about there groups of parent/child relationships, just like as a tree structure. 
Network databases
A network databases are mainly used on a large digital computers. It more connections can be made between different types of data, network databases are considered more efficiency It contains limitations must be considered when we have to use this kind of database. 
Relational databases
Relational databases work on each table has a key field that uniquely indicates each row, and that these key fields can be used to connect one table of data to another.

Object-oriented databases
The object-oriented database derivation is the integrity of object-oriented programming language systems and consistent systems. The power of the object-oriented databases comes from the cyclical treatment of both consistent data, as found in databases, and transient data, as found in executing programs.

Some databases:

 Hadoop:
It is an open-source framework that allows to store and process big data in a distributed environment across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.


MySQL:

MySQL is the most popular Open Source Relational SQL Database Management System.
MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994.

MongoDB:

MongoDB is an open-source document database and leading NoSQL database. MongoDB is written in C++.

SQLite 

it is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world. 




  1. Thank You So Much................

 

Comments

Post a Comment

Popular posts from this blog

Naming Convention

  Naming Convention : A naming convention is  a convention for naming things: Please find below the table for naming conventions: Naming Convention Format Example Camel Case camelCase 🐪aBcD Kebab Case kebab-case 🍢a-b-c-d Snake Case snake_case 🐍a_b_c_d Pascal Case PascalCase 🧑‍🦳AbCd Flat Case flatcase 📏abcd Upper Flat Case UPPERFLATCASE ABCD Screaming Snake Case SCREAMING_SNAKE_CASE 🐍A_B_C_D Camel Snake Case camel_Snake_Case 🐪🐍ab_Cd Pascal Snake Case Pascal_Snake_Case Ab_Cd Train Case Train-Case 🚃Ab-Cd Cobol Case COBOL-CASE 🍢AB-CD
Post a Comment
Read more
How to run lex yacc programs on win 10 In short: For Lex steps to run: lex lex7.l gcc lex.yy.c a     For YACC steps to run: lex simple_compound.l yacc -d simple_compound.y gcc lex.yy.c y.tab.c a                          A.Lex 1. download flex for windows http://flex-windows-lex-and-yacc.software.informer.com/2.5/ 2. install it locatin:  C:\Flex Windows\ 3.open cmd 4.You need to change location as follows:  cd C:\Flex Windows\EditPlusPortable 5. Steps to run : lex lex7.l gcc lex.yy.c a Output : Word Count : 13 Char Count : 80 Line Count : 7 codes : lex7.l %{ /* *Program to count no of characters, words and lines */ #include<stdio.h> #include<string.h> int c=0,w=0,l=0; %} %% [\t ]+              /* ignore whitespace */ [a-zA-z]+             {w=w+1; c=c+ yyleng;} [\n ]                           {l=l+1;} ['{','}''(',')',.,",;]          {c=c+1;} %% int main() {     yyin= fopen("file1.txt&qu
1 comment
Read more

Add items in shopping cart using ArrayList

 Add items in shopping cart: We are using ArrayList Code: import java.util.*; public class Main {  public static void main (String[]args)   {     ArrayList < String > items = new ArrayList < String > ();     Scanner sc = new Scanner (System.in);       items.add ("folder");       items.add ("flower");       items.add ("Car");       items.add ("Bottle");       items.add ("Mask");       items.add ("Box");       System.out.println ("Shopping card items");       System.out.print (items);       System.out.println ("Enter item which you want:");       String rmv = sc.nextLine ();       items.remove (rmv);       System.out.println ("Shopping card items");       System.out.print (items);   } } Output: Shopping card items                                                                                                              [folder, flower, Car, Bottle, Mask, Box]Enter item which you want: 
Post a Comment
Read more