Forgot your password?
typodupeerror

Comment: Re:Let the hate fly! (Score 1) 140

by FlyingGuy (#47950925) Attached to: Oracle CEO Larry Ellison Steps Down

I do not know either. Backwards compatibility perhaps? I do know that if you have written code and have used bit mapping ( INT AND 0xA23F4D ) and things like that you will more then likely run into to trouble ( in theory it should not matter since the number of bits is not shrinking ) when your INT goes from 32 bits to 64 bits and the same thing goes if you using any ROT commands so who knows.

Comment: Re:Let the hate fly! (Score 1) 140

by FlyingGuy (#47947871) Attached to: Oracle CEO Larry Ellison Steps Down

I am quite sure that this is true in a lot of spaces and I am quite sure the opposite is true in a lot of spaces.

That brings up another point though. Tuning a database... This is seeming to be a lost art. Over time I have witnessed what I think is an alarming trend of otherwise mostly competent developers wanting the database to just be a magic box. So much code has been written to hide the database, to turn it into objects that match oop models. Pick any of them, springDB, Hibernate et all. No one wants to recognize the database as being an integral part of a well thought out and balanced system. They simply want to throw a framework in front of it an attempt to ( poorly IMHO ) make it non existent when IMHO is the best place to implement the vast majority of business rules, but that is another discussion.

But back to your main point. As I said, if Oracle just sucked as a database it would not have the market share that it does and if DB2 ( a mighty fine DB in its own right ) was that much faster and better then it would have a much larger market share then it does. Each DB has it's own set of strengths and weaknesses and each one has its sweet spot.

Comment: Re:Let the hate fly! (Score 1) 140

by FlyingGuy (#47942899) Attached to: Oracle CEO Larry Ellison Steps Down

I can't disagree with that statement, but for the other 10% there really is no substitute for Oracle. Like I said in my original post PG may eclipse Oracle and that will be OK. In the mean time use what works for the situation as there are many choices, many that are good, many that are not so good and we as software professionals get paid to advise the right course for the write set of tasks. One thing we are all guilty of though is retreating to our comfort zones and like it or not we weight all of those decisions with out own particular set of likes and dislikes.

Comment: Re:Let the hate fly! (Score 5, Interesting) 140

by FlyingGuy (#47942637) Attached to: Oracle CEO Larry Ellison Steps Down

Happy to share, and I have posted a link as well.

So every SQL database, Oracle included, has to have some way of keeping transaction order, which is to say which transaction got there 1st, 2nd, 3rd etc. This is part of ACID and it cannot be ignored. Oracle and others solved the problem by using a synthetic number. Oracle's "number" type is not a recognized IEEE standard like an INT or a FLOAT, DOUBLE etc. It i stored using a proprietary scheme in the DB that Oracle guarantees to be correct when it is accessed and it is completely portable. The last estimate I saw ( I rarely look ) was that pushing Oracle to its absolute limits was that it would take ~ 141 years to wrap around. Personally I am not going to be alive then and I doubt Oracle will be either.

In postGres they use a 32 bit unsigned int to keep tract of this. Now 2^32 is 4,294,967,296 transactions, which is a very large number indeed, but when you get into extremely hi volume transaction environments this can get used up pretty fast, like in a few days fast! Since the number is unsigned and postGres is written in C ( although I don't think it matters ) when you hit INT MAX it wraps back to 1!!! and that is a disaster. In older versions it just kept going and corrupting your data and there was really no way out of it, you were just hosed. In the latest version, the database will only go so far and it will force itself down before it wraps around AND will refuse to come up until the vacuum process is complete. On VERY large tables this can take days!

Now the guys who write PG are no dummies. They recognized this and came up with a process called VACUUM, it does many things and it will reset the TXID and keep you safe. In most every application this is fine. In Extreme transaction environments where you build up billions of rows very quickly you have to set the VACUUM process to it's most aggressive level to keep up with inbound transactions and it just kills performance and your TX rate falls into the basement.

This link explains it better than I can. PostGres Wrap Around Problem

Comment: Re:Let the hate fly! (Score 1) 140

by FlyingGuy (#47942143) Attached to: Oracle CEO Larry Ellison Steps Down

Hey, so I am going let the invective roll right on by...

Is Oracle a huge turd throwing ape? That is not an unfair analogy and in some ways I agree with you.

I have been in the database business for a very long time and I have watched them come and go. Some self destructing and others just fading into obscurity but the one thing that I have observed over the years is that the database is pretty much at the heart of anything non trivial. There are only TWO RDBMS's that have stood the test of time and that is Oracle and DB2.

That is a good because something that important cannot be flavor of the month like so many programming languages and frameworks are these days.

In a perfect world we would have infinite choice and they all would work as good as the other and software patents would not exist. Sadly, Elvis isn't making records anymore and there is no Santa Clause.

Comment: Let the hate fly! (Score 4, Interesting) 140

by FlyingGuy (#47941343) Attached to: Oracle CEO Larry Ellison Steps Down

But here is the problem...

You cannot deny that he built a huge empire on something as banal as a database. Arguably the best RDBMS pretty much ever and where is the competition?

I use Oracle extensively. I am a DBA and of all the alternatives out there ( and I have tried most of them ) the only thing that comes even close is DB2 with postGres running a close third and depending on your POV, catching up fairly quickly. Perhaps postGres will eclipse Oracle one day, but not unless they get some serious money behind the project and that probably won't happen because no one wants to pump the millions of dollars it would take into a project that cannot even fix the TXID problem, and make no mistake about it, it is a problem. Also if someone dumps that kind of money into a project they expect some kind of ROI. There might be a few white knights that have that kind of money but they are few and far between and most can find more worthy causes to spend that kind of money on. Don't get me wrong, postGres is a fine DB but it has some faults that make it not so attractive.

Larry understands how to stitch technology together around a DB better than most anyone else I have seen. Arguably Microsoft gets it, but they are stuck running in the windows universe which despite a lot of progress is still broken. You cannot run MS-SQL Server across hundreds of Intel machines and expect it to hold together, but they ave built and end to end ecosystem and MS-SQL Server is tightly integrated, but you can't drop it on a Z-Series mainframe under either IBM's native OS or Linux. PostGres has the same problem but they are moving to fix that, but I am not sure they really understand the problem. Of the other DB's out there ( Mongo, Hadoop, et all. ) that you can do that with, they don't support things like ACID which, like it or not, is pretty much a requirement in way to many situations.

The facts speak for themselves. If Oracle really sucked as a Database it would not be in the vast number spaces that it occupies. You can cap on Larry Ellison all you want, question his lineage, say he is an ego maniacal asshole, but you have to give the man his due. He built a company that does have the answer to almost all the spaces where a DB matters and he built a business that relentlessly pursues those spaces to the betterment of their stock holders and 98% of the people and organizations that use their products.

Comment: Re:Why Java? PASCAL is THE learning language (Score 1) 511

by FlyingGuy (#47745209) Attached to: If Java Wasn't Cool 10 Years Ago, What About Now?

There may be object-oriented versions of Pascal now, but that's not the original language any more than C++ is C.

Wow have you been living under a rock? Delphi first released by the now defunct Borland and now released by Embarcadero Technologies is probably the best RAD language on the market, bar none.

On top of that it now generates native code for Windows, OSX, IOS, and Android. They even had a Linux version for a while called KyLix.

It is OOP Pascal and it is the fastest compiler on the market and generates native binaries for all the platforms. The resulting binaries are amazingly fast and are generally on par with C,C++ AND Java. You can write them as GUI apps or console apps, take your pick. The runtime is royalty free and their ultimate version comes with drivers for just about every SQL database on the planet.

Comment: VERY old news (Score 1) 275

by FlyingGuy (#47635127) Attached to: Long-Wave Radar Can Take the Stealth From Stealth Technology

This has been a known Achilles heel for stealth technology since it first came out.

Take a cheap Furuno surface search radar play around with the main frequency and the pulse repetition frequency, and not by a lot, and all of the sudden things that never painted before suddenly appear.

This is one of the main principles of mine detection sonar. You can make fairly large changes in the output frequency to really tune the thing once you know the relative size and shape of the target you are searching for. Torpedo's do the same thing. The search on a relatively low frequency then when the algorithm thinks it has something it switches to frequencies typically 10 to 20 times higher for high resolution aiming. The exact same principles could be applied. AWACS could search and much lower frequencies then vector fighters in with the ability to not change the frequencies a lot, but lower them down to just above the thresholds for the very small antennas. Close enough and no matter how the target is shaped you will get a return.

Comment: Re:A rose by any other name (Score 1) 218

by FlyingGuy (#47592473) Attached to: The Great Taxi Upheaval

You sir are a completely uninformed and obviously blind to history moron.

Banks playing fast and loose with depositor's money caused the financial crisis, just like it caused in 1929.

In response the government passed both Securities Act of 1933 and the Glass-Steagall Act the prohibited commercial banks ( those banks that hold customer deposits ) to prevent such insanity as using customer funds to gamble on highly speculative and extremely risky business investments.

You would have think we would have learned from the Savings and Loan crisis, yes that bit of lunacy that cost the tax payers billions of dollars when we decided to deregulate savings and loan institutions.

Then just a few years ago Glass-Steagall was basically gutted and the party was on! Banks put their customers money into all sorts of hairball shit like derivatives and other such insanity. Combine that with making loans to people to buy houses they had no business making loans to and here we go again. Free Market they cried from the rooftops! Adam Smiths invisible hand they cried from the rooftops of their palaces! Just let the market be free and we will all prosper they told us.

And what happened? Pure greed took over from regulation and it damn near bankrupted the country, a very few people got mega rich, a bunch more got filthy rich and a number more made a killing. The result of which forced us to sell billions of securities to the likes of China and anyone else we could beg. The national debt is really beyond belief.

A free market is good but unfortunately the market does not take into account the dishonesty of man. In China they take you out and shoot you for shit like the CEO's of those huge banks did and all the little minions that were in on it. What did those people get? Huge bonuses, golden parachutes and the rest of us got stuck holding the bag.

So you pull your head out of your ass, walk out of the echo chamber and really learn what is happening around you.

Comment: Re:Sales flow chart. (Score 2) 97

by FlyingGuy (#47554921) Attached to: Oracle Offers Custom Intel Chips and Unanticipated Costs

PostGres compares ok on a lot of workloads, but when the rubber really hits the road that is when it starts to fall apart.

They must fix the TXID ID problem. It will now at least shut down when it is getting close to rolling over, but the vacuum process will just kill your performance in very high transaction workloads. Not that Oracle would not have the same problem if they were using a 32 bit number for the value, but with the size of the ID Oracle uses this won't happen for ~ 140 years.

Immovability... PostGres gets some great performance but it does so at the cost of the data files being so close to the metal that you can't move them to another host that is not exactly the same as it is moving from. If that is not true you have to do an SQLDUMP of the data. That is a fairly fatal flaw in my opinion.

So yes you can use PG in place of Oracle, to a point, but after that point it just does not perform as required.

I migrated a PG DB to Oracle 11g EE and it runs quite smoothly. The application would quickly overwhelm PG without some serious changes to the PG code.

Don't steal; thou'lt never thus compete successfully in business. Cheat. -- Ambrose Bierce

Working...