This is a small application that should access ISO image file (or a harddisk) and write following details into RDBMS (MySQL table):
1. Separate the files by type of file (Word Doc, Excel, Powerpoint, pdf, .txt, Outlook pst, Image files, Audio, Video)
2. Access these files and write following details into RDBMS;
File-ID (application generated unique id)
Extension (.xls etc etc)
# of times file is modified
Content (Text Field) - For all files that have text and numbers. This is most important. This should have all the content from the file dumped into this column
Image (For Image files) - Any text in this image file can go into text column
Audio - At this stage optional
Video - At this stage optional
I am quite open in terms of technology choices, as long as quality, scalability and extendability are not compromised.
However this application should should be browser based and should enable me to fire qeries from the browser to the database table.