Solved

Mysql vs Oracle

Posted on 2016-07-16
10
134 Views
Last Modified: 2016-08-04
Hello Experts,
Our customer needs to distribute a small app to several distant locations....
Now this app will have a database...
1) Which is the best database to distribute many times (like little less than a hundred )
2) Is it ok to consider Oracle and MySQL as the top databases in the world for medium and small apps for distribution ?
3) which database would you suggest for easy remote instalation and implementation as well as maintenace?

regards,
0
Comment
Question by:rguillermo
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 1

Expert Comment

by:klamerus
ID: 41714914
You can't just distribute oracle.  It's a licensed DB.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 41715033
0
 
LVL 1

Expert Comment

by:klamerus
ID: 41715776
Ah thanks.  Didn't realize that existed.

What OS is this for?  That's relevant to the discussion.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715793
Any os oracle supports
0
 
LVL 1

Expert Comment

by:klamerus
ID: 41715847
Yes, the question what was cost effective and if the target is Windows then there's probably a value in considering SQL Server.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41715862
Indeed, as sql server express version also exists.
Like oracle and mysql, the "free" versions come with limitations that need to be clearly studied before choosing
0
 

Author Comment

by:rguillermo
ID: 41715994
Hi thank you for your answers,
I am seeing the main limitations for Oracle XE are

11GB of data and 1 GB Ram.... no hard limit for user connections..
Is there any other important limitation?
Thank you
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 41716052
>>Is there any other important limitation?

CPU.

...
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
...

http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html
0
 
LVL 13

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 41716366
Any os oracle supports
BUT not any architecture ;-) E.g. ARM based systems like Raspberry devices
0
 

Author Closing Comment

by:rguillermo
ID: 41743676
Thanks to all Experts very much !!!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Converting a row into a column 2 43
Performance issue with case statement in oracle 11G 7 45
RDBMS and No sql database 4 38
sql_mode 1 16
Read about achieving the basic levels of HRIS security in the workplace.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

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

18 Experts available now in Live!

Get 1:1 Help Now