Skip to main content

Key terms in Database and Introduction to database


General Terms:

DataBase:

A container in which we can store data in an organized manner.

SQL:

SQL is a language which we use to talk to Database.

DBMS:

A software which can understand SQL or Database language and can manage database.

Server:

A physical device where data is stored. Although it is not the only task of the server, but it is one of its tasks among running actual website code, accept http requests etc.

Analogy:

So, database is just collection of files in an organized manner i.e the data organized in any format (tables, key values etc) is named as database. It is similar to the concept, if we organize our data in some format which we decide to follow, then we would call it our database. At the end of the day, it is just data that is being stored on some storage device and in an organized manner. That's what happens in case of server, data is stored in an organized manner in specialized storage device of the server.

Schemas:

a category or logical container, it is like a virtual format which we follow. We can use it to group up related objects.

Tables: 

Collection of rows and columns i.e. fields and records.

Field/Attribute:

One column is a field or attribute.

Record:

One row is a record. 

Primary Key:

A single attribute or collection of attributes which are unique is called primary key. Primary key can have more than one attribute.

Types of SQL Commands:

DDL(Data Definition Language):

This involves:

  • CREATE (create tables with fields)
  • ALTER (to change something that already exists, i.e change the attribute names or types or anything related to that)
  • DROP (Delete a column i guess)
DML(Data Manipulation Language):
  • INSERT (put data into the created table)
  • UPDATE (update or alter the added data in the table)
  • DELETE ()

DQL(Data Query Language):

SELECT (we can ask questions. Selecting data and using it according to our requirement)


.

💾 Database

A database is simply an organized collection of related data that can be easily accessed, managed, and updated.
Think of it as a container or repository where data is stored — like tables in MySQL or files in a folder.

📘 Example:
Imagine you have a university database that stores:

  • Student records (name, roll no, address)

  • Courses offered

  • Marks and attendance

All this data together — stored in structured tables — is the database.

⚙️ Database System

A database system is a complete environment that includes:

  • The database (the data)

  • The DBMS (Database Management System) software that manages the data

  • And sometimes, users, applications, and hardware interacting with it

It’s the whole setup that allows you to create, manage, update, query, and secure your data efficiently.

📘 Example:
If your university uses MySQL to manage student data:

  • The MySQL DBMS software

  • The database files storing the student, course, and marks data

  • The hardware (server) running MySQL

  • The students, teachers, and admin apps using it

→ all together make the database system.




Labels:

Comments

Post a Comment

Popular posts from this blog

Java Servlets

  According to me its just a translator, who manages the HTTP requests and handle them to the appropriate function of the API. So then, API turns out to be a term or set of those functions which are kept public. Now let us see in little bit of detail what servlets are: For that we need to see few terms: Static Web Pages: Static web pages are the pages, which are already built, and whose content and design always remain the same.  For Example: About us page of some website. Contact info page of some website Dynamic Web Pages: Dynamic pages are not already defined. They are dependent on search queries. For Example: If we search top 5 books, and click on search button, result would be different. If we search top 5 countries and enter search, result would be different.  So, the search result for every search is different. Working: Now if we have to search static page let's say the first page of any website (which is same for every use in every country) then the process is sim...
Post a Comment
Read more

What is an API? A Simple Explanation for Programming Beginners

API What is an interface? Interface is a control system, through which we can use something. For Example: The interface of car includes: Steering Wheel Brakes Gear Acceleration pedal Mirrors Interface is concerned with the fact that how to use something, rather than how it works. The Easiest Analogy for an API : The Restaurant Imagine you're at a  restaurant . You are the user. You want food (data or a service). You can't just walk into the kitchen and start cooking. That would be  chaotic  and unsafe! Instead, you interact with the  waiter . You look at a  menu  (the  API  documentation) and give your order to the waiter. The waiter takes your request to the kitchen. The kitchen prepares your food. The waiter then brings the response (your delicious meal) back to you. The  waiter  is the contract, the messenger, the interface in our case the  API . They provide a secure and simple way for you to get what you need from the kitchen ...
Post a Comment
Read more

Why do I need to create Java Classes? Why don't just use database for searching?

The Bridge Between Data and Display A Conceptual Guide to Java, Databases, and the "Why" behind the Code. 1. The Core Problem When building a web application, you have data sitting in a Database (SQL Server) and a user waiting at a Browser . The challenge is moving that data efficiently and safely. Beginners often ask: "Why do I need to create Java Classes ( Student.java ) and copy data into Lists? Why can't I just print the database results directly to the screen?" To answer this, we must understand how the database actually talks to Java. 2. The Anatomy of a Connection The ResultSet is NOT Data — It is a "Live Wire" A common misconception is that when you run a query, the data is instantly sent to your Java program. It is not. The ResultSet is a Cursor (Pointer) . It points to a row on the database hard drive. The Connection is a Pipe . The Streaming Analogy: Think of a ResultSet like a Phone Call . When you say rs.next() , you are asking the da...
Post a Comment
Read more