DBMS- Whenever i hear this word i don’t feel comfortable within. It seems some complex system. ( It's certainly not one of my strong areas !)
Truth is it's just a software package ( Windows xp is an example of software package ) . The function of DBMS software package is to maintain databases.
So what are databases then?
Database:
It's just collection of data in digital form.
Without databases it's difficult to imagine how the world can function. If railway network has no database ( ie no digital data storage ) then operating one train per day would be some big achievement.
Dbms vs Rdbms:
In DBMS we can store and retrieve data using queries but there is no relation between tables.
However in RDBMS (Relational DBMS) relations can be formed between tables and it's inturn maintained by the system. Because of this reason RDBMS doesn’t accept flat file database ( example for flat file--> one txt file having one record per line). We mostly use RDBMS since most applications require forced relation between tables in the form of foreign keys.
Mysql:
MySql is a RDBMS. It's an open source software package.
My experience:
After discussion about dbms it was time for me to have some hands on experience. I have earlier worked on Oracle’s dbms. Now i tried installing mysql in my system running Ubuntu OS. The installation was easy and smooth.One simple command,
sudo apt-get install mysql-server
installed mysql server in my system.
So now i had the software package,
Opening it was simple.. typing mysql -u user_name -p opened mysql and prompted for your password.(Security !! ). On entering the password which i set during the installation, mysql opened up.
It was my playground then , I created databases , dropped(deleted) them, created , updated , altered , dropped tables inside a database.
So i got a feel about mysql (same feel i got with oracle dbms too).
In coming days i will work on some real time application and data and post about them.
See you in next blog.
Trained @ Sourcebits
No comments:
Post a Comment