Database (DB), this information is the federation of information, where the related information is collected and kept. Information is kept in the database by being organized (organized).
Organized means to keep the sentence as you read the books On the table , you keep the sentence, in the same way, information and data are kept in the database . To store information, some software is used. The best example is MS-Excel. Here all the data is kept in digital memory devices like Hard disk.
Information is kept in the database in such a way that you can easily access the data Access and Manipulate (change).
Let's understand with an example, "An MS-Excel sheet where you have details of 100 students." Details such as Roll NO, name, address, name of the city, father's name, date of birth. Here we and you can say this Excel Sheet is a database.
DB means whatever information and data is in the Data Base, you can access it whenever you want. Now let's understand what Access means. There is a university, where there are many students, about 5000 of their exams are over.
Now their results are uploaded into the database through computer, it can also be that the university's official is a website . Then it is also uploaded there. Now it has become the database of Students Result.
When the result of exit date comes, this result is published. Then students start putting their Roll no and see the result. This process is called Accessing Database.
There are many such databases such as Google's, Company's, Government's database, where they store their information.
Database management system
It is a software system through which a user creates, defines, maintains and controls the database. DBMS is a collection of programs, which is used to maintain the Database (DB).
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 Database Management System DBMS is . Again let's understand, DBMS 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 the wrong data, then you have to edit the student details. After a few days you came to know that someone's data is wrong, then you will also have to delete it. If you want to search his name and address from a students' Roll no, then he says Access.
Now you must understand what the DBMS does. Take this example, you can also put it in a company, the same thing happens there.
Database examples
By the way, there are a lot of DBMS Software, some of them are
1. Dbase
Of all the DBMSs, Dbase was first created. It was used in microcomputers. This software was the most successful DBMS in its time. All these components remain in DBASE like Database Engine, Query system, a forms engine and a Programming Language is used to run all three. this File remains Extension.
The company named Ashton-Tate publishes Dbase in 1980, this DBMS was used to run the microcomputer's OS. Later it was used by Apple- || And it started happening in IBM PC as well, both used to run on dos os. Dbase was also awarded Best Selling Software of the Year for many years. When Dbase- ||| When released, it started running in UNIX and VMS as well.
2. FoxPro
There is a text-based procedurally oriented programming language here as well as this Database Management System. this one Object Oriented Programming Language. It was first published by Fox Software.
But Microsoft further developed FoxPro to run in MS-DOS, Windows and Unix versions. Currently, its name is Visual FoxPro, but its production was discontinued in 2007 after a few years.
3. IMS
The hierarchical model is followed to store data in the IMS Database . Which is quite different from DB2 and Relational Model. This DBMS is used for information management on demand.
4. Oracle
Oracle RDBMS is also spoken. It is an object-relational database management system. In today's time it is used a lot, the name of this software company is Oracle Corporation. Larry Ellison and his two friends were the CO-Founder of this corporation.
5. MySql
It is an object-relational database management system. It was named after the daughter of its CO-foundered Michael Wideners and SQL means Structured Query Language. This DBMS Software Company is named mySQL AB which was formed in 1995. It is now owned by Oracle Corporation.
6. DB2
This is a product of a database. It is RDBMS means Relational Database Management System . DB2 is used to store, analyze, and retrieve data in the database. db2 is also following Concept of Object Oriented.
Database Operations
There are all the operations given below the database. Understand them in Detail one by one.
1. Insert
If you store some data, then it is called Insert Operation. Just like there is a Student Database, you insert data there Name, Roll, Mark, City.
2. Delete
If you delete a DATA or a record from the database, this operation is called Delete Operation. Some programming languages can also be used to delete.
3. Update
If the information or data is already available and you are making changes in it, then it is called Update. I will still take the same example, if a student's family has shifted to another place, then you have to change the address from the database, this is called update.
4. Search/Access
Searching for the same information or searching for a group of information is called Search or Access Operation. For example, to see a result, to do a balance inquiry, to see if a train ticket is available or not, it is all a search operation.
Database model type
The Data Model tells you how to store, organize and manipulate the data logically in the database and what the logical structure of the database should be like.
I understand you with an example, you were asked to write information about your Familly Details. In this way you can write, you can also write by making a table. You can also write without making a second table, and the third mummy father's name, the names of his children and the names of his children below him.
These three methods were a data model. Similarly, these three models are used in Database Design.
- Hierarchical Model
- Network Model
- Relational Model
1. Hierarchical Model
The Structure of this model looks like Tree Structure. In this model, the Tree Structure is followed to add the records to Apasa. The tree consists of Nodes and Branches.
This means that as the trees are dry, they are also in it. This tree itself represents the logical structure of the database. Below is a structure of this model.
2. Network Model
The Network Model is quite powerful but also complimented. Because all the Nodes / Tables are linked in it. This model can be represented in the Graph Structure. You can see below how the Department, Student, Course and Professor or the variables are linked together.
3. Relational Model
This model is very powerful and simple. Too much Flexible and Natural. The Structure Table of this Data Model would have been the same. The table is called Relation in the language of the database. That is why its name is also Relational Model. It is like a table, so it has Rows and Column.
In the Relational Model, Rows are called Record and Column is called Field says. This model was proposed by E. F Codd while he was in IBM. In this model Unique Field is called Key. And the tables are connected together through these keys. A Student Table has a Roll no, Primary key.
Database of Components
The main three component consists of a
1. Database User
This is the user who accesses and searches the DB from anywhere. Just like you are the same user, do some search in Google, after reading, they read it. But you do not have information about what is inside and how it is stored.
2. DBA
The full form of DBA is Database Administrator , it is called Manager. Which runs the entire system. It understands the user's Needs and manages and updates accordingly.
3. Application Program
This is the DBMS Software Program. It is used to manage the entire DB. If you see above, you will get the information about what DBMS is. Here was some information about components.
Comments
Post a Comment