WHAT IS DATABASE AND ADVANTAGES OF DATABASE KNOW FULL INFORMATION

DATABASE AND ADVANTAGES OF DATABASE FULL INFORMATION


Friends, Everything Visible On The Internet Is Stored In A Database, So Do You Want To Know What Is A Database - What Is Database And What Is Database Management System, What Are The Benefits Of Database And Why Database Is Important? In Today's Post, We Will Talk About All These Questions And Will Know The Complete Information Of The Database.



WHAT IS DATABASE AND ADVANTAGES OF DATABASE KNOW FULL INFORMATION


Well, You Must Have Heard The Name Of The Data Many Times. Before Knowing About The Database, We Have To Know About The Data. Friends, If I Say In Short Words, Whatever Information You Store In Your Mobile Or Computer In Files, Pictures, Videos Or Other Form Is Called Data. Database Words Are Made Up Of Data. So Let's Know What Is Database?


CONTENTS


- WHAT IS DATABASE - WHAT IS A DATABASE 

- WHAT IS DATABASE MANAGEMENT SYSTEM - WHAT IS DBMS 

- SOME EXAMPLES OF DATABASE MANAGEMENT SYSTEMS

1) MYSQL

2) MS FOX PRO

3) MICROSOFT ACCESS

4) ORACLE

5) SQL SERVER

- TYPES OF DATABASE MANAGEMENT SYSTEMS - TYPES OF DBMS

- MAIN FUNCTIONS OF DATABASE MANAGEMENT SYSTEM -

- WHY DATABASE IS IMPORTANT - WHY DATABASE IS IMPORTANT

- BENEFITS OF DATABASE

- WHERE IS THE DATABASE USED



WHAT IS DATABASE


We Can Store Data In Computer In Various Ways. Such As Document, As Worksheet Or As Program Files And When We Store Data As Row And Column It Is Called Tabular Data. Store One Or More Tables As A File. So It Is Called Database.


And If Explained Well, A Database Is A Group Of Information. Which Is Formed In Such A Way That All The Information Present In It Can Be Changed Easily When The Problem Is The Information Can Be Used Easily And It Can Be Managed Easily.


WHAT IS DBMS


Database Management System Or Dbms Is A Software System. Through Which A User Creates, Define, Maintain And Control The Database. Database Management System Is A Collection Of Programs. Common Database Is Used To Maintain.


Now Let's Understand The Meaning Of Maintain. In This, You Can Do All These Things Like - Inserting Data Into Db, Edit, Delete, Access And Update. You Know What The Database Management System (Dbms) Is.


In Other Words, It Is A Software Package. Through This Software, You Can Create A Database. Just Like You Created A Database Named Student, Now You Have To Add The Details Of The Students To It.


If You Inadvertently Give Incorrect Data, Then You Have To Edit Student Details. A Few Days Later You Came To Know That Someone's Data Is Wrong Then You Also Have To Delete. If You Want To Search His Name And Address From A Student's Roll No, Then He Says Access. Now You Must Understand What Database Management System Does?


SOME EXAMPLES OF DATABASE MANAGEMENT SYSTEMS


1) MYSQL


Mysql Was Started In 1995 By Oracle. It Is An Open-source Relational Database Management System (RDBMS). It Is Based On Structure Query Language (SQL). It Supports Almost All Operating Systems. Mysql Is Very Famous Due To Its High Reliability, Reliability And Cost. It Also Has Lamp Technology Along With Linux, Php And Apache.


2) MS FOX PRO


Ms Fox Pro Is A Database Management System. Which Was Started By Fox Software. But Right Now It Is Under The Protection Of Microsoft. Apart From Being A Database Management System, It Is Also Text Related Oriented Programming Language. Ms Fox Pro Is A Powerful Database Management System As Well As Relational Database Management System (RDBMS). Because It Extensively Supports Multiple Relationships Between Many Dbf Files.


3) MICROSOFT ACCESS


Ms Access Is A Database Management System (Dbms) Operated By Microsoft. Which Combines The Relational Microsoft Jet Database Engine With A Graphical User Interface And Software Development Tool. It Is A Member Of The Microsoft Office Suite Of Applications Included In Commercial And Higher Versions. It Is Used For Both Small And Large Database Development.


4) ORACLE


Oracle Database Is A Relational Database Management System. It Is Maintained By Oracle Corporation. This Is The First Database Designed For Enterprises Grid Computing. It Is The Fourth Generation Of RDBMS. It Is Mostly Used By Big Companies. Who Need To Manage Large Amounts Of Data.


5) SQL SERVER


SQL Server Is An Rdbms Server Developed By Microsoft. Used In Creating Computer Databases For Ms-windows. This Creates The Ms Sql Server Database. Which Can Be Accessed Through Workstation And Internet. It Was Created To Compete With Oracle Database And Mysql. It Is A Full-featured Database.


TYPES OF DBMS


- NETWORK DATABASE


- HIERARCHICAL DATABASE


- RELATIONAL DATABASE


THERE ARE THREE TYPES OF DATABASES -


# 1. NETWORK DATABASE: IN THIS TYPE OF DATABASE, DATA IS REPRESENTED AS A RECORD AND THE RELATIONSHIP BETWEEN THE DATA IS SHOWN AS A LINK.


#2. HIERARCHICAL DATABASE: IN SUCH A DATABASE, DATA IS ORGANIZED WITH NOTE AS THREE STRUCTURE. THE NOTES ARE CONNECTED THROUGH THE LINK.


# 3. RELATIONAL DATABASE: THIS DATABASE IS ALSO KNOWN AS STRUCTURAL DATABASE. IN WHICH DATA IS STORED AS TABLE’S. WHERE COLUMNS ARE STORED IN COLUMNS AND ROWS.


MAIN FUNCTIONS OF DATABASE MANAGEMENT SYSTEM -


MANAGING THE DATABASE - MANAGE THE DATABASE SO THAT IT CAN BE EASILY 


ACCESSED, MANAGED AND UPDATED.


UPDATING DATA - UPDATING THE DATABASE AS REQUIRED.


DATA MODELING - STRUCTURED DEFINITION OF DATA COLLECTION IS KNOWN AS 

DATA MODELING.


PROCESSING QUERY - IT IS A MECHANISM FOR MANIPULATING DATA.


DATA SECURITY - DATABASE SECURITY IS VERY IMPORTANT.


CONCURRENCY CONTROL - THE MECHANISM OF MULTIPLE USERS ACCESSING THE 

DATABASE SIMULTANEOUSLY IS CALLED CONCURRENCY CONTROL.


CRASH RECOVERY - DATA RECOVERY AFTER SYSTEM CRASH.


WHY DATABASE IS IMPORTANT


Database Is Very Important In Internet World. Because Through This, You Can Manage Any Type Of Data Properly And Properly. With This, The Database Provides Many Types Of Facilities To The User.


Database Management System Is A Type Of Application Software. Within Which A Large Amount Of Information Can Be Managed And Organized. Along With This, The Database Has Also Saved Time.


Friends, If We Talk About Who Has Benefited The Most From The Database System, Then It Is Seen That The Biggest Benefit Of This Has Been To Every User Of The Internet Who Keeps Working Hard All The Time To Find The Information. The Biggest Benefit Of The Database Has Been To The Business And Large Organization Companies.


Every Type Of Organization Stores All Kinds Of Information In A Database. For Example, If You Go To A Music Site, Then You Will Get A Database Of All Songs There.


By The Way, If The Database Was Not There And We Would Have Done All This Work With Our Own Hands, Then It Would Have Taken Much More Time Than We Store It In The Database And Would Have Missed Collecting Much Information. Nowadays, In The Era Of Internet, Database Has Become A Huge Management System. Which Everyone Uses.


BENEFITS OF DATABASE


1. ANY INFORMATION CAN BE STORED AND STORED BY THE ARRIVAL OF THE DATABASE.


2. THROUGH THE DATABASE, MORE INFORMATION CAN BE COLLECTED IN LESS SPACE.


3. STORE INFORMATION CAN BE ACCESSED EASILY WITH THE HELP OF DATABASE.

WE ALSO GET THE OPTION TO ADD NEW DATA AND EDIT OLD DATA WITH THE HELP OF DATABASE.


4. DATA CAN BE FILTERED WITH THE HELP OF DATABASE.

WITH THE HELP OF DATABASE, DATA CAN BE DIVIDED INTO DIFFERENT TYPES OF SORT.


5. MANY APPLICATIONS OR USERS CAN ACCESS AT ONCE IN THE SAME DATABASE.

INFORMATION IS PROTECTED WITH THE HELP OF DATABASE.


6. PROGRAMS AND DATA CAN BE KEPT SEPARATELY WITH THE HELP OF DATABASE.

DATA CAN BE BACKED UP WITH THE HELP OF DATABASE.


WHERE IS THE DATABASE USED


By The Way, Database Is An Important Part Of Internet. Now There Can Be Many Examples Of This. Such As The Database We Use, Online Video Streaming, Online Gaming, Share Market, Aadhaar Card, Railway Reservation System,


Flight Reservation System, Banking, Social Media, Online Shopping Website, College And University, We Can Do Library Management System, Hospital Management System, Telecommunication And Everywhere That We Find Available On The Internet.


Whatever Information We Get On The Internet Is Shown To Us Through A Database.


AKASH TIMES

I AM AN ENGINEER BY PROFESSION BUT BLOGGER IS MY OLD DAYS DREAM TO CREATE MY OWN SITE FOR THOSE WHO ARE CURIOUS ABOUT MY BIRTHPLACE THEN I AM COMING FROM (INDIA). THE CURRENT CITY LIVES IN NAVI MUMBAI, INDIA

Post a Comment

IF YOU HAVE ANY PROBLEM PLEASE FELL FREE TO CONTACT US BY - AKASH TIMES

PREVIOUS POST NEXT POST