4 ms·

Can you briefly describe some of that tooling?

pjmlp 11y ago
The ones I care about: - The capabilities of PL/SQL and TransactSQL, FOSS databases don't have as feature rich programming language for stored procedures. - Ability to mix relation, object oriented and unstructured data modeling - The SQL features and extensions - Distributed transactions across multiple databases across clusters - The SQL Developer IDE or integration with Visual Studio, without relying on third parties
- Retric 11y ago
  My General experence is stored procedures and even transactions scale really poorly. I have seen several ex-oracle projects and it really only seems to work well for hospitals and other organizations that don't grow. Or banks which have relativly few transactions per day. Ed: Or the old Cognos Big Data (No Users). Any thoughts?
  - pjmlp 11y ago
    I have been involved in some telecommunications and health care projects in a couple of Fortune 500, using Informix, Oracle and SQL Server backends, which had more GB on their databases than most big data projects I see being tossed around in big data startups. Of course it is a personal experience and I cannot generalize, but on those projects we had all the scale we needed. All the issues we had, the DBAs could sort them out after checking the query optimizers and fine tune the model and respective indexes.
  - pjc50 11y ago
    > transactions scale really poorly Please be more specific about 'scaling' numbers! > Or banks which have relativly few transactions per day. http://www.telegraph.co.uk/finance/newsbysector/banksandfinance/11672021/Mobile-banking-has-eclipsed-branches-and-even-the-rest-of-the-internet.html http://www.telegraph.co.uk/finance/newsbysector/banksandfina... "Banking apps were used 10.5m times a day across the country in March, eclipsing the 9.6m daily log-ins to internet banking services"
  - sokoloff 11y ago
    I've always felt that 99% of the people worried about database scaling didn't actually have a DB scaling problem. I've seen billion dollar double-digit growth rate e-commerce companies run their transactional systems on a single commodity DB server (technically 2 in a failover configuration). Successful social media companies have legitimate scaling concerns. Most every e-commerce company under $5BB/year does not. At least 10x (and probably 100x) as many architects believe they have a scaling problem as actually do, IMO.
patrickg_zill 11y ago
Oracle runs on so many platforms, that essentially once you fire up a command line interface or otherwise give administration commands to it, it is its own OS. After installation (provided you don't run out of disk space), you can set it up and maintain it without (hardly) ever having to run an OS command. As a result, just about everything, including statistics to be gathered, users, etc. is just another table you can query via SQL or set using Oracle commands.

pjmlp 11y ago

The ones I care about: - The capabilities of PL/SQL and TransactSQL, FOSS databases don't have as feature rich programming language for stored procedures. - Ability to mix relation, object oriented and unstructured data modeling - The SQL features and extensions - Distributed transactions across multiple databases across clusters - The SQL Developer IDE or integration with Visual Studio, without relying on third parties

Retric 11y ago
My General experence is stored procedures and even transactions scale really poorly. I have seen several ex-oracle projects and it really only seems to work well for hospitals and other organizations that don't grow. Or banks which have relativly few transactions per day. Ed: Or the old Cognos Big Data (No Users). Any thoughts?
- pjmlp 11y ago
  I have been involved in some telecommunications and health care projects in a couple of Fortune 500, using Informix, Oracle and SQL Server backends, which had more GB on their databases than most big data projects I see being tossed around in big data startups. Of course it is a personal experience and I cannot generalize, but on those projects we had all the scale we needed. All the issues we had, the DBAs could sort them out after checking the query optimizers and fine tune the model and respective indexes.
- pjc50 11y ago
  > transactions scale really poorly Please be more specific about 'scaling' numbers! > Or banks which have relativly few transactions per day. http://www.telegraph.co.uk/finance/newsbysector/banksandfinance/11672021/Mobile-banking-has-eclipsed-branches-and-even-the-rest-of-the-internet.html http://www.telegraph.co.uk/finance/newsbysector/banksandfina... "Banking apps were used 10.5m times a day across the country in March, eclipsing the 9.6m daily log-ins to internet banking services"
- sokoloff 11y ago
  I've always felt that 99% of the people worried about database scaling didn't actually have a DB scaling problem. I've seen billion dollar double-digit growth rate e-commerce companies run their transactional systems on a single commodity DB server (technically 2 in a failover configuration). Successful social media companies have legitimate scaling concerns. Most every e-commerce company under $5BB/year does not. At least 10x (and probably 100x) as many architects believe they have a scaling problem as actually do, IMO.

patrickg_zill 11y ago

Oracle runs on so many platforms, that essentially once you fire up a command line interface or otherwise give administration commands to it, it is its own OS. After installation (provided you don't run out of disk space), you can set it up and maintain it without (hardly) ever having to run an OS command. As a result, just about everything, including statistics to be gathered, users, etc. is just another table you can query via SQL or set using Oracle commands.