Solved

Mysql vs Oracle

Posted on 2016-07-16
10
178 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 143

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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 143

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
 
LVL 143

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 77

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

732 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