Solved

DataBase Software

Posted on 2014-11-05
5
118 Views
Last Modified: 2015-05-11
I have one project, for that purpose i want to use database system, which one will good good ( oracle,Sql,MySql...etc), this database will be available to our clients over the internet, so i want to secure this database as well, i am planning to use VPN for this but i am not sure which VPN i should use, i want this database to be in read only mode for the clients,if any one want to access our database for some kind of information they have buy license from us, this is the scenario.....
0
Comment
Question by:Ajeet Kumar
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 40424607
There really is no 'best'.

My advice:
Go with what you know.  For example:  If you are an Oracle DBA (or have them on staff), it makes sense to go with Oracle.

As far as security:
You typically don't have the database directly accessible from the Internet.  You also don't typically let clients have direct database access.

You create applications that allow users to retrieve/manipulate data.  In the Internet/Intranet world this is commonly done through Web Services.

App calls web service.  Web service calls database.
0
 
LVL 21

Assisted Solution

by:robocat
robocat earned 250 total points
ID: 40425750
You can get VPN solutions from any of the major vendors of networking equipment (Cisco, Juniper, ...).

But ... accessing databases over the internet is doing something that databases aren't designed for. Your clients are very likely to experience performance issues. Database connections are designed for low latency/high bandwidth reliable LAN connections, not for high latency internet connections.

Going for webservices, as suggested by slightvw, may be a better solution because these protocols are designed for the internet. Of course your application must allow this.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now