News for hackers. Stuff that matters.
Re:Oracle’s Cloud Licensing Change by brad0 on Sunday January 29, 2017 @04:13AM (#13513235)
Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?
Re:Oracle’s Cloud Licensing Change by rosser on Sunday January 29, 2017 @04:16AM (#13513247)
The thing you need to understand about Oracle is that it's never — well, never in my experience, and I've worked as a DBA (mostly postgres, but I have had my hands on some Oracle) for a decade now — chosen by the technologists. It's chosen by management. Usually non-technical management. Often dangerously so.

But Oracle support basically doesn't answer the phone unless you're regularly cutting them six-figure checks, so you kinda need that level of management to be making the decision whether or not to use the platform.

Re:Oracle’s Cloud Licensing Change by raverbashing on Sunday January 29, 2017 @04:40AM (#13513348)
Engineers need to learn how to stand their ground
Re:Oracle’s Cloud Licensing Change by NeutronBoy on Sunday January 29, 2017 @05:08AM (#13513439)
In an Enterprise, you almost never buy 'a database'. There's a solution/application that you buy, that will have a supported DB backed (usually Oracle or MSSQL). That solution is mostly picked on business capabilities and functionality. The technical component is only one aspect of the requirements, which cover business capabilities/features, technical fit within existing environment, data migration/compatibility, vendor support, vendor credentials, the amount of training required, the amount of business change needed, etc.

These projects often cost $10m+, once you factor in the technical implementation and integration, business process changes, training for business staff, training for IT staff, transition costs, etc.

So if you want to argue that the business should get the solution that fits their requirements the second best, because the 'best' one has an Oracle backend, you had better come up with a shit-hot reason that can't be solved with 'hire a couple of Oracle engineers'.

Re:Oracle’s Cloud Licensing Change by arethuza on Sunday January 29, 2017 @05:27AM (#13513495)
"That solution is mostly picked on business capabilities and functionality."

Exactly - cost of support/hosting/licensing the relevant database is a factor but, in my experience, it is a pretty small part of a large ERP or CRM implementation.

Re:Oracle’s Cloud Licensing Change by threeseed on Sunday January 29, 2017 @04:52AM (#13513382)
That's cute. And it might even work in a startup. But likely not.

But in the enterprise world nobody really cares what engineers think. You have Enterprise Architects, Technical Architects, Solution Architects etc. who get paid exorbitant amounts of money, are political animals and can masterfully straddle the line between business and technology. Most of them are ex-engineers so they aren't entirely useless and since they have their own language they will make you look stupid. Can't articulate the transition from a tactical to strategic solution and explain what business capabilities it aligns to ? Well good luck getting that past the central Enterprise Architects who will need to sign off on your choice before it heads to Procurement/Legal.

Architects along with IT managers and CIOs are the people whom the famous Oracle Sales machine targets with golf games, overseas trips and fancy dinners. It's never engineers. I spent a few years at Oracle. They are a multi billion dollar company for a reason.

Re:Oracle’s Cloud Licensing Change by bb101 on Sunday January 29, 2017 @05:06AM (#13513430)
I can confirm this. Oracle goes out of their way to make senior and upper-mid management feel like rockstars. All expenses paid meetings in attractive overseas destinations, start to finish hand holding on multi-million dollar engagements, regular contact and personal attention. Management swoon and sign the cheques. And why wouldn't they? After all, it's only the company's money, not theirs personally.
Re:Oracle’s Cloud Licensing Change by raverbashing on Sunday January 29, 2017 @05:36AM (#13513524)
It will be fun if Oracle is investigated relating this practices
Re:Oracle’s Cloud Licensing Change by Helmet on Sunday January 29, 2017 @02:59PM (#13516235)
Why? This is basically how the business world operates. There is nothing wrong with a private business wining and dining a potential client to swoon and sell them something.
Re:Oracle’s Cloud Licensing Change by edblarney on Sunday January 29, 2017 @03:45PM (#13516522)
"here is nothing wrong with a private business wining and dining a potential client to swoon and sell them something."

Yes it's called 'kickbacks' and it can be illegal or considered corruption.

If you were a CEO would you want your team buying a product because they were given $5000 tickets to the superbowl?

Re:Oracle’s Cloud Licensing Change by aNoob7000 on Sunday January 29, 2017 @07:07PM (#13517661)
You will be investigating likes of Microsoft, IBM, and even Amazon.

As an example, I can't stop the CIO and board at my company from talking about the cloud because of all the consultants and sales guys talking to the C suite. You want to see something really oversold right now look no further than the cloud.

Re:Oracle’s Cloud Licensing Change by edblarney on Sunday January 29, 2017 @07:45PM (#13517815)
'Wining and dining' is very common, but it's not necessarily considered 'corruption' because a meal is well, just a meal, after all. The occasional tickets etc. are just a 'gift' not ostensibly supposed to interfere with the purchasing decision.

Of course they do on some level.

But it's a fine line.

It's crazy how many CEO's will let purchasing decision makers be taken on these things and junkets, I would just not allow it.

But also don't doubt the ability of people to just drink koolaid. There are tons of non-thinkers out there who just 'buy' the story presented to them.

Also - I don't think 'the cloud' is oversold. It's definitely the future, and it's going to be the 'new normal' and it's here to stay.

The notion that anyone would 'host their own' stuff just doesn't make sense anymore - unless there are specific reasons for it. 'The cloud' is now the 'default choice' for most things, unless you have a need not to use it.

Re:Oracle’s Cloud Licensing Change by aNoob7000 on Monday January 30, 2017 @12:00AM (#13518813)
I never said the "wining and dining" was illegal or corrupt. I just think it is a easy way to get decision makers to push the people under them to look at technologies that may or may not apply.

In the case of the cloud, I agree that there's a future for it. But I think in the future people are going to look around and notice that it cost a lot of money to run everything in the cloud and on-premise is going to start looking good again.

Re:Oracle’s Cloud Licensing Change by raverbashing on Sunday January 29, 2017 @05:05AM (#13513425)
Yes, those issues are important, and I was aware of them

For a start, that's why I don't work (at least directly) for the enterprise world.

But I've seen companies adopt open source solutions and modernize. I've also seen companies use those "legacy" technologies. They're the ones that usually go bankrupt, unless technology is a minor part of their business.

And yes, as much as "corporate architecture" is 90% BS and politics, if you can at least explain why solution A is better than solution B in a way it's understood, then you did your part.

And the question remains, who will pick up the phone when an open source DB fails to perform as it should. Does Red Hat provide support in that area?

Re:Oracle’s Cloud Licensing Change by threeseed on Sunday January 29, 2017 @05:50AM (#13513554)
Support is the biggest issue with open source. It's why companies like RedHat, DataStax, Hortonworks, Databricks, MongoDB have all done so well. They basically took over their open source projects and provided official vendor support in the Oracle "style".

They all offer certifications, training and conferences around the world for you to spend company money on.

Re:Oracle’s Cloud Licensing Change by arethuza on Sunday January 29, 2017 @05:30AM (#13513510)
"explain what business capabilities it aligns to"

Well, that is rather the point of buying a large complex business application - it has to align with business processes!!

Re:Oracle’s Cloud Licensing Change by technion on Sunday January 29, 2017 @05:46AM (#13513542)
Let me read you a specification I got for a project a while back:

Build and implement an Intranet system based on Oracle

That was the start, and finish of the spec we got. Question about what sort of information the intranet stores? Here's your answer:

As long as it uses Oracle

Standing your ground where Oracle is involved usually just means quitting. Not every engineer has that luxury.

Re:Oracle’s Cloud Licensing Change by PhantomGremlin on Monday January 30, 2017 @05:36AM (#13519967)
If that were the extent of the "specification" I got, and I couldn't get any additional information, then ...

Yes, I'd quit. Period. End of discussion. I couldn't work at a company that operated that way.

Re:Oracle’s Cloud Licensing Change by rwallace on Sunday January 29, 2017 @06:50AM (#13513713)
Well yes, engineers do need to learn how to stand their ground - over things like pay and working conditions. But no amount of standing your ground will let you overrule the CTO on a corporate strategic decision, no matter how mistaken. As the saying goes, "God grant me the serenity to accept the things I cannot change, courage to change the things I can, and wisdom to know the difference."
Re:Oracle’s Cloud Licensing Change by pallopiipaeri on Sunday January 29, 2017 @04:22AM (#13513270)
MySQL and Postgres have multi-master replication. They do NOT have distributed transactions (with the distributed locking system etc). For some customers it is important. Others have delusions that they need it.

Oracle has other products as well. I am generally aware of couple used widely.

Their ESB is one of the heavy players, and some sausage stands always need the most advanced ones. The funny thing is that with Oracle's ESB you end up developing the missing glue features using Java, and the ESB product's framework. The environment is extremely non-productive.

Oracle's JavaEE application server is kind of nice, if you wanted WebSphere with training wheels. While feature wise it does have similar set, the maintainability and management features are just plain inferior, and most options are bolted down, and not available unless you go to lower levels...

Oh, they offer ERP suite(s) as well. Those are for people that are prone to joining religious cults. They are not technology, and software products really. They are something sold to general and logistic managers with a story that you can actually force your company to use their "best practices" sets for everything, and abandon all software architecture in favor of warm and nice spaghetti. :)

Re:Oracle’s Cloud Licensing Change by rosser on Sunday January 29, 2017 @04:23AM (#13513277)
Postgres has two-phase commit, which can be used at the application level to implement distributed transactions.

It does not have multi-master replication natively, though there are companion projects that enable it.

Re:Oracle’s Cloud Licensing Change by pallopiipaeri on Sunday January 29, 2017 @04:38AM (#13513336)
Unfortunately those are blocker level issues for most enterprisey IT managements.

Adding extra implementation to application, to do the database's work against the usual division of labor, no thanks. And bringing some shady 3rd party support package on top of the database is a second really big no.

For businesses only what you get out of the box counts. Otherwise you can always state that "the platform has C++ compiler, stfu and code". That doesn't really work. The companies are into buying complete products for a reason: they don't want to implement unnecessarily things they really should just get out of the box.

TBH I love postgres, but before they offer proper multi-master transactions out of the box most companies just still go for Oracle. That's similar as to why people buy Photoshop. GIMP fell some 10 years after in usability and features when they did not prioritize implementing the dynamic layer effect system. Instead of that they chose to masturbate with GEGL or something like that for 10 years, without providing the actual end user requested features. The situation still stands there, before they implement what Photoshop 4 or so did they got no chance of being valid alternative...

Re:Oracle’s Cloud Licensing Change by CaliforniaKarl on Sunday January 29, 2017 @05:10AM (#13513447)
Vouching parent comment. The last time I looked at Postgres, I was really happy to see that BDR was now doable without a patched Postgres. But, I believe transactions affecting multiple tables didn't fully work yet.

Postgres is my preference over MySQL/MariaDB, but I wouldn't have pushed for it back when I worked in traditional corporate IT: Stability, and having a third-party to blame, really wins there!

Re:Oracle’s Cloud Licensing Change by keypusher on Sunday January 29, 2017 @04:36AM (#13513328)
PG 9.6 brought bidirectional replication in and supported via mainline extension (no patches).

http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/

Re:Oracle’s Cloud Licensing Change by rosser on Sunday January 29, 2017 @04:42AM (#13513352)
Okay, sorry, you're right. In my head "multi-master" is N > 2, for some reason. Probably because of Bucardo.

Also, we're only on 9.5, so I haven't gotten to play with BDR yet, though I do have a meeting next week to start talking about how we might use logical decoding.

Re:Oracle’s Cloud Licensing Change by pgaddict on Sunday January 29, 2017 @07:12AM (#13513784)
I may be missing something, but I don't see any mention of 2 nodes in that blog post. In fact, BDR is designed to be run with many more nodes. That being said, it's an asynchronous multi-master, suitable for geo-distributed architectures. Everyone has their own concept of what multi-master is, sadly.

The other thing is that "PG 9.6 brought ..." might suggest this is built into PostgreSQL 9.6. That's not quite the case - we're working on moving it into core, but that takes time. For now it's an extension (plug-in). PG 10 will however include pglogical, which is another step in that direction.

Re:Oracle’s Cloud Licensing Change by toyg on Sunday January 29, 2017 @04:30AM (#13513304)
> Oracle's JavaEE application server is kind of nice

You mean Weblogic, right? Because OAS has been dead for a while now. Afaik, Weblogic and Websphere are practically the same, hard to say one is "just plain inferior" to the other.

Re:Oracle’s Cloud Licensing Change by tilt_error on Sunday January 29, 2017 @05:01AM (#13513413)
...except when it comes to support for talking with Tuxedo. I guess my shop may be one of the largest Tuxedo users in the world, so it makes WLS kind of mandatory :(
Re:Oracle’s Cloud Licensing Change by di4na on Monday January 30, 2017 @09:56AM (#13521631)
Just saying : if Oracle has proper distributed transactions, then it is lying. Welcome to CAP. Or it has times when it will shit the bed and wait. For reaaaaally long time.
Re:Oracle’s Cloud Licensing Change by tlogan on Sunday January 29, 2017 @04:32AM (#13513312)
Here are some reasons (things I used in past):

- ASM

- DataGuard

- FlashBack Query

- RAC

- PL/SQL (the worst language ever but very useful for building packages inside database)

- Window Functions

- Transparent Data Encryption

- online reorg

- RMAN and online backup

Oracle as a company is terrible. But Oracle RDBMS is a mean machine. Do not underestimate it.

Re:Oracle’s Cloud Licensing Change by yxhuvud on Sunday January 29, 2017 @06:12AM (#13513630)
Postgres has at the very least window functions. What do you mean by online reorg? Schema changes in a transaction that doesn't block? Yeah, postgres has that too.
Re:Oracle’s Cloud Licensing Change by tannhaeuser on Sunday January 29, 2017 @11:01AM (#13514694)
> PL/SQL (the worst language ever but very useful for building packages inside database)

I've heard that "in the database" sentence many times but never got it. PL/SQL is just another programming language VM that happens to have SQL types as native types, and syntax for SQL cursors.

Other than for triggers and possibly indexed deterministic functions (both of which are inessential/questionable), you don't want your code "in the database" due to it lacking basic capabilities such as unit testing.

Re:Oracle’s Cloud Licensing Change by cneumuel on Sunday January 29, 2017 @03:19PM (#13516344)
There are several unit testing frameworks for PL/SQL. Code in the database encapsulates business logic, it gives you unified access from all clients. It can also be orders of magnitude faster. The presentation linked here

https://thehelsinkideclaration.blogspot.co.at/2016/09/noplsq...

proves that with flame graphs for a simple workload done from the app server vs. implemented in PL/SQL.

Re:Oracle’s Cloud Licensing Change by tannhaeuser on Sunday January 29, 2017 @04:31PM (#13516816)
The performance argument I can accept (I've done PL/SQL coding and administered Oracle clusters years ago). But when it comes down to it, PL/SQL can possibly only benefit from lower inter-process or JDBC driver overhead vs. Java, say. I've seen PL/SQL becoming a CPU bottleneck in large real-time migration projects.

To encapsulate business logic using PL/SQL, however, is crazy IMHO. Rather than coding your business logic in a mainstream language (with incomparably better staffing and tooling), you now have it in a proprietary niche language with awkward or even non-existent debugging.

Also, the relational model is (or should be) the unified access at this level IMHO, rather than some ad-hoc data access layer.

Re:Oracle’s Cloud Licensing Change by pjmlp on Sunday January 29, 2017 @07:03AM (#13513756)
> PL/SQL (the worst language ever but very useful for building packages inside database)

Actually it is way better than the open source alternatives, but maybe my likeness for Ada makes my opinion biased

Re:Oracle’s Cloud Licensing Change by Illniyar on Sunday January 29, 2017 @04:25AM (#13513284)
The Oracle database is a beast, both in terms of performance, performance tuning and features.

It probably out performs MySQL and Postgres in most areas - and if you don't do horizontal scaling, then Oracle is probably your best bet if you want to get the most out of a server.

I don't think there are any advantages of going to vertical scaling over horizontal scaling these days.

Re:Oracle’s Cloud Licensing Change by Joeri on Sunday January 29, 2017 @05:06AM (#13513432)
Relational databases don't scale horizontally all that far because of the challenges in replicating writes. Either you do delayed replication and have inconsistent slaves, or you do sharding and have a complicated app layer.

The trick to scaling a sql db is to either shard it and treat it like nosql with worse tooling, or go vertical as far as you can before you go horizontal. Luckily, there aren't many workloads that require horizontal scaling. Stackoverflow can run on a single beefy db server.

Re:Oracle’s Cloud Licensing Change by user5994461 on Sunday January 29, 2017 @10:23AM (#13514463)
They can scale by normalizing and dropping transactions. Then that's really close to a NoSQL db, so might as well use a No SQL db.
Re:Oracle’s Cloud Licensing Change by codingbeer on Sunday January 29, 2017 @04:21AM (#13513263)
Vendor locked. Many companies have huge applications bound tightly to the Oracle database. Often the business logic is just stored procedures. That makes it incredibly difficult to migrate and developers will have a hard time convincing management that the cost of migration would be worth it.
Re:Oracle’s Cloud Licensing Change by arethuza on Sunday January 29, 2017 @05:39AM (#13513531)
Main reason that I have seen for Oracle is that businesses buy applications and then install the database they need to run that application. How many ERP/CRM/HR/financials applications are there that compete with Oracle applications that run on MySQL or Postgres?
Re:Oracle’s Cloud Licensing Change by jimnotgym on Sunday January 29, 2017 @07:28AM (#13513826)
This is correct. If a major ERP/CRM player used Postgres it would be different. I guess a lot of that is down to the slow development cycle of those products.

It wont be SAP though, they seem to be all about HANNA these days

Re:Oracle’s Cloud Licensing Change by chx on Sunday January 29, 2017 @04:56AM (#13513396)
It's not support, it's blame. When the fertilizer hits the circular air moving device someone needs to be the scapegoat. And believe me, the CIO is not going to be the one. There isn't an entity to point to if you run MySQL or PostgreSQL.
Re:Oracle’s Cloud Licensing Change by oblio on Sunday January 29, 2017 @05:20AM (#13513476)
Both MySQL and PostgreSQL have commercial entities backing them. Funnily enough, MySQL's is also Oracle.
Re:Oracle’s Cloud Licensing Change by toyg on Sunday January 29, 2017 @04:24AM (#13513279)
Qualify "people". For many classes of enterprise applications (BI etc), mysql and postgres are not even a choice, it's all about oracle/sql server/db2.

Pg and mysql dominate developer-centric operations, but business-first environments are a very different game. There, it's all about long sales cycles and long feature-lists that only big vendors can afford.

Re:Oracle’s Cloud Licensing Change by hasch on Sunday January 29, 2017 @04:21AM (#13513259)
I bet you can get plenty of support for MySQL or Postgres
Re:Oracle’s Cloud Licensing Change by threeseed on Sunday January 29, 2017 @04:56AM (#13513394)
MySQL support you can get from Oracle. PostgreSQL support is very limited.

There is no vendor so you're relying on third parties many of whom are mom and pop shops. And if you're a global, multi-national well good luck finding someone who you can cut a deal with for global support. Not to mention that the support is hardly likely to be top tier.

Re:Oracle’s Cloud Licensing Change by rosser on Sunday January 29, 2017 @05:03AM (#13513421)
You say this garbage every time this comes up. "Mom and pop shops". Yes, those exist, but they're the minority.

You're generally either dealing with EnterpriseDB, or you're dealing with a company that is run by people who are significant contributors to the project — literally, on the core committee — or have people who have created meaningful parts of the PostgreSQL ecosystem.

You need to drop this FUD.

I will never again use or support an Oracle product after they literally, specifically cost a former employer $.75mm, on Cyber Monday by giving us factually false information.

Re:Oracle’s Cloud Licensing Change by mjw1007 on Sunday January 29, 2017 @05:37AM (#13513528)
In discussions like this, I often hear people say companies choose Oracle because they'd have "someone to sue" if things go wrong.

Did your employer attempt to recover the money from Oracle? If not, did they even consider doing so?

Re:Oracle’s Cloud Licensing Change by justinjlynn on Sunday January 29, 2017 @03:26PM (#13516391)
If they actually did consider it, legal would probably make them unconsider it. That is, after laughing in such a way as to give the C*O the impression someone has just walked on their grave.
Re:Oracle’s Cloud Licensing Change by threeseed on Sunday January 29, 2017 @05:59AM (#13513592)
I say this "garbage" because in my opinion it's true.

EnterpriseDB has according to LinkedIn between 200-500 people mostly located in AMR and EMEA based on experience with their APAC division. They simply are NOT a top tier support company on par with Oracle, Teradata, SAP etc. I am based in APAC and so my opinion is going to be far different than other parts of the globe.

And the difference with DataStax, MongoDB etc is that those companies are basically the open source projects. They control the steering committees, copyrights, branding etc. And so there there's a lot more confidence in being able to reach someone who actually wrote that part of the code. PostgreSQL has always been far more decentralised.

Re:Oracle’s Cloud Licensing Change by x0x0 on Sunday January 29, 2017 @02:07PM (#13515938)
EnterpriseDB has multiple pg core devs on staff and has been offering excellent pg support for over a decade. A former employer used them and they lived up to their reputation -- very good, not cheap (but cheap compared to Oracle.) I can't imagine they have any trouble selling the usual 30m or 60m SLA contracts into APAC, but maybe I'm wrong. For companies in EMEA or North America they're an excellent choice.
Re:Oracle’s Cloud Licensing Change by rj0049 on Monday January 30, 2017 @12:00AM (#13518811)
There's a leading DB vendor (at least according to Gartner) which will give you enterprise support if you run MySQL or PostgreSQL.

AWS.

While multi-master replication is still not there (it's still just a synchronous standby and read slaves) all of the heavy lifting is done for you.

Re:Oracle’s Cloud Licensing Change by adolfojp on Sunday January 29, 2017 @10:46AM (#13514585)
You don't choose Oracle databases. You choose Oracle products and services that use Oracle databases. If you visit their website and hover over the products and solutions tabs you'll see a ton of boring mission critical applications that most startups will never touch.
Re:Oracle’s Cloud Licensing Change by dagw on Sunday January 29, 2017 @05:33AM (#13513522)
Oracle is much better at handling huge amounts of data. Oracle also has support for all kinds of really niche features that are really important to some people.