Tuesday, March 10, 2009

SQL layer for the Networking or Telecommunication protocol

As usual. I've just thought about this. I'm not sure if this is a good idea, it may be naive as well. I'm yet to search and confirm if there exists any solution already. I'll confirm with my friends shortly and update this. However anyone who reads this and knows about an existing software feature that provides this capability, please leave a comment.

The SQL being so simple yet powerful can be used for the network management and telecommunication protocols. We've observed that SNMP is being used to manage/notify some SQL-services. This can be just the reverse.

Rather than a command below
doSnmpGet {some switches} {someHost} {someCommunity} {someOID}

The following will be very simple (this can be made better)
SELECT some-oid FROM someSnmpTable WHERE host=someHost AND community=*****;

Rather than bulkget the following can be friendly
SELECT * FROM someSnmpTable WHERE host=someHost;

A similar thing can be tried for TL1 as well. In fact through adapters both can be managed using an SQL convenience layer.

SQL convenience layer for Operating Systems

I've just thought about this. I'm not sure if this is a good idea, it may be naive as well. I'm yet to search and confirm if there exists any solution already. I'll confirm with my friends shortly and update this. However anyone who reads this and knows about an existing software feature that provides this capability, please leave a comment.

There can be a cross-platform SQL convenience layer for querying the file system information.

Won't it be convenient to query like below.
1) SELECT files FROM fileSystem WHERE folderName="someFolder";
2) SELECT files FROM fileSystem WHERE creationTime BETWEEN date1 AND date2;
3) SELECT files FROM fileSystem WHERE owner=me AND type=java;
4) DELETE from fileSystem WHERE type=someType AND name=junk;

These are very few and this can be of great value.

Sunday, March 1, 2009

Undo capability at the Operating System(OS) level

I've just thought about this. I'm not sure if this is a good idea, it may be naive as well. I'm yet to search and confirm if there exists any solution already. I'll confirm with my friends shortly and update this. However anyone who reads this and knows about an existing operating system feature that provides this capability, please leave a comment.

There may have been situations where we felt like "I wish there was an 'undo' to revert a previous action" at the operating system level rather than at the application level.

We already have very good undo capability at the application level to revert to the previous stage of editing/work using Ctrl-Z, "u" and so on.

What if the operating system has the capability to revert to a previous state. Please do not mix this with Mac's TimeMachine or Sun's snapshot and various other *NIX capabilities that provides "files backup or snapshot of the filesystem". You are right, this thought/idea will eventually involve a "persistent mechanism" to hold the "state information" though.

In case
1) I've closed an application window and of course after saving the current work. However I want the application to be open again just with an "Undo" rather than launching it afresh and opening the "recent document or work".

Now, this requires an operating system capability to "record" and "navigate" to the application state. Mozilla Firefox, Google chrome and several such applications have the "save session" and returning to previous session support at the application level.

2) I've resized an application window and rather than resizing back to the older size I just want an "Undo".

3) I've uninstalled/installed an application of course properly answering all question of "un-install wizard" and I want to revert.

Do you think I'm crazy? may be. However what if I've done this while I was half asleep?

These are few trivial situations there may be much more real demanding needs.

Any ideas?