schema help
From: magawake <magawake_at_gmail.com>
Date: Tue, 25 Dec 2007 11:37:47 -0800 (PST)
Message-ID: <ab0571ea-74ce-4772-99b4-a1673df810a5_at_y5g2000hsf.googlegroups.com>
Hello:
I am trying to learn SQL and RDBMS theories. To acheive this, I decided to assign myself a project.
Date: Tue, 25 Dec 2007 11:37:47 -0800 (PST)
Message-ID: <ab0571ea-74ce-4772-99b4-a1673df810a5_at_y5g2000hsf.googlegroups.com>
Hello:
I am trying to learn SQL and RDBMS theories. To acheive this, I decided to assign myself a project.
My project is basically, account for my NFS mounts, and keep track of them. I want to see which filesystems are growing, and which filesystems are staying the same. I will get an inventory daily. I will grab the data and place it into a database, using PERL or AWK.
The filesystems looks like this for example:
On December 24192.168.0.8:/movie 196015808 176581984 9476736 95% /movie 192.168.0.8:/music 196015808 177342240 8716480 96% /music 192.168.0.8:/pictures 196015808 176797024 9261696 96% /pics
On December 25
192.168.0.8:/movie 196015808 176581984 9472736 95% /movie 192.168.0.8:/music 196015808 177342240 8712480 96% /music 192.168.0.8:/pictures 196015808 176797024 9221696 96% /pics
So my intentention is, to show do stats on these filesystems, and see
when it grows and when it stays the same. I will get these stats
daily, and hopefully in a month, I can see what is growing, shrinking,
and staying the same.
Any ideas on the schema? do I really need a RDBMS for this?
TIA