Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

File Database recommendation

Posted on 2014-07-11
9
Medium Priority
?
362 Views
Last Modified: 2014-07-14
We are looking for a File Database Management system that is easy to use, long-lasting, can store emails, CAD Drawings, PDFS, Word Doc, ect. Hopefully it will not be very, very expensive. Any assistance offered would be greatly appreciated.
0
Comment
Question by:regsamp
  • 5
  • 4
9 Comments
 
LVL 43

Expert Comment

by:pcelba
ID: 40191013
Such weekly defined requirements are fully covered by any database management system or even by Windows NTFS or FAT32 file system because properly organized file system structure is the basement of what you need...

If you need more then you should tell.

Do you need special security access? Do you need encryption? Do you need file versioning? Do you need file locking? Do you need to store some metadata? Do you need to define relations and dependencies among files? Do you need to ensure file integrity and place digital signatures?  Etc. etc.

Just let us konw.
0
 

Author Comment

by:regsamp
ID: 40191027
We do not need special security access and encryption should not be needed but would be needed but would be nice as an option. We do not need file versioning. File integrity is needed and digital signatures is not required. Relations and metadata is not needed.

This is just something new for us as we are use to typical file servers and using a SQL database for Intranet information. What kind of options are out there for combing the two. How would we be able to save an email to a database or scan a pdf to the same database?
0
 
LVL 43

Expert Comment

by:pcelba
ID: 40191495
You have two basic options:
1) Store the whole file in database
2) Store just the filename and a pointer to disk file

You may study SQL Server Blob objects to learn more about the option 2): http://msdn.microsoft.com/en-us/library/bb895234.aspx

The first option is also available as varchar(max) data type on SQL Server and other database engines.

But you should really explain what added value you need or expect from the file stored in a database comparing to shared file folder.
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 

Author Comment

by:regsamp
ID: 40193720
Let me take a look at the information but it is going to be many files. All this can be done in one SQL database?
0
 
LVL 43

Expert Comment

by:pcelba
ID: 40193836
Yes, one SQL database can collect everything. BLOB objects are stored outside the database but you have to access them through the SQL server.
0
 

Author Comment

by:regsamp
ID: 40194283
So the recommendation is SQL to store Word Docs, CAD Drawings, Scanned files and such?
0
 
LVL 43

Expert Comment

by:pcelba
ID: 40194362
No, this is not recommendation. I've just described one MS SQL Server feature (BLOB). Other SQL server engines allow similar functionality. You still did not tell what added value you need comparing to the standard file system.

This just means you may use SQL Server to collect data about your files and also your files. Of course, it will need some programming to implement it.

You may also read something about MS SharePoint Server (http://en.wikipedia.org/wiki/Microsoft_SharePoint) which offers much more than you need now.
0
 

Author Comment

by:regsamp
ID: 40194420
I do not know what value we need. I need a database software package that is good for storing different file types such as Word Docs and CAD drawings.
0
 
LVL 43

Accepted Solution

by:
pcelba earned 2000 total points
ID: 40194475
The database engine does not recognize the file type obviously so all files will be handled as unstructured data (or even as common filestream).

From this point of view you may use any database to store your files. E.g. we are storing several gigabytes of files (PDF, Word, Excel, ...) in FoxPro database.

More important is the speed of your network connection. Each file stored on the SQL server will be moved many times between the server and clients. This will slow the file access speed down and users may start complaining etc. etc.

Files having r/o status and no sensitive info inside can remain in client's local cache but that also needs some programming or setup at least.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question