Code with C | Programming: Projects & Source Codes › Forums › Miscellaneous › Database Confusions
November 23, 2016 at 3:38 pm #11033
As per my information:
Small Organizations use Microsoft Excel for storing their customers data in spreadsheets
Small/Medium Organizations use Microsoft Access for the same purpose
Medium/Large use Oracle Database Solutions
Large/V large are using SAP ERP Solutions
i am a noob on this can someone please explain what are the added advantages of:
Access over Excel
Oracle over Access
And SAP over Oracle?
What are those advantages for which such organizations migrate from a cheap solution like Excel, Access to an expensive solution like Oracle or SAP?
If someone can clear my confusions it will be very useful for me as i have my presentations and the topic is Database so i am confused about above mentioned questions.
November 23, 2016 at 3:38 pm #11034
The information isn’t strictly correct, but the idea is basically right. The simple answer to your question is that the increase in size of the company implies an increase in size of the data requirements. The usual split is:
One- or two-person companies use Excel
The solution is simple and cheap and very low-maintenance. One person with knowledge of Excel can handle everything.
Very small companies use Access
This allows some data to be shared, although it’s not a very scalable solution. Again, it’s simple and it’s usually maintained by someone in the office who has a good grasp of MS Office.
Small-medium companies use Microsoft SQL server
Large companies use Oracle or DB2
This is a “real” database, but it lacks the enormous power of Oracle or DB2. The reality is that there is little to choose between these three in terms of functionality, but the MS solution only runs on Windows and doesn’t scale to the sizes needed by large companies.
Companies with extraordinary requirements for data use NoSQL solutions like Hadoop
This is Google and Facebook, etc.
SAP is not a database, but an enterprise software solution. It usually runs on Oracle or DB2 as its database. I have no idea why this was added to the list – it just doesn’t make sense.
Interestingly, DB2 is often forgotten by people when talking about databases, but it’s the second-biggest seller after Oracle – see Computer Weekly:
You must be logged in to reply to this topic.