![]() | |
![]() |
| | Thread Tools | Display Modes |
#11
| |||
| |||
|
|
If SQL is dead (or gasping), what then of Oracle? First of all, there is a huge, huge installed base for Oracle. Additionally, they have improved performance so much that I would be surprised if it beat out Pick shops these days if you optimize h/w and config for each. Also, they, like other DBMS vendors have added a ton of proprietary features (so unless a site is very careful not to use such features, it would not be easy to migrate from Oracle to SQL Server or DB2), so when you are using Oracle, you are not just using SQL-92, you are using all of the enhancements that Oracle has added, a few of which might align with newer standards. One other point on this is that Oracle bought Sleepycat, a tag-value database, not at all SQL-based. /SNIP |
#12
| |||
| |||
|
|
On 16 Oct 2006 11:14:20 -0700, "dawn" <dawnwolthuis (AT) gmail (DOT) com> wrote: SNIP If SQL is dead (or gasping), what then of Oracle? First of all, there is a huge, huge installed base for Oracle. Additionally, they have improved performance so much that I would be surprised if it beat out Pick shops these days if you optimize h/w and config for each. Also, they, like other DBMS vendors have added a ton of proprietary features (so unless a site is very careful not to use such features, it would not be easy to migrate from Oracle to SQL Server or DB2), so when you are using Oracle, you are not just using SQL-92, you are using all of the enhancements that Oracle has added, a few of which might align with newer standards. One other point on this is that Oracle bought Sleepycat, a tag-value database, not at all SQL-based. /SNIP Surely this would be no more difficult than moving from , say, D3 to JBase, or UnidData to D3 - choose the flavour of the day... |
|
It always amuses me when I hear how "non-standard" each SQL implementation is, compared to good ole Pick - what a joke ! |
|
Almost ever MV software house I have worked for over the last 25 years, has carefully written code in a limited sub-set of the MV Basic syntax that is reasonably common to most implementations. They have then used a pre-processor to generate code for each implementation they require. The previous company that I worked for, developed Browser based systems that could be switched from Access to SQL Server to Oracle. Basically they employed the same technique as all those MV people ie steer away from the really esoteric quirks of each implementation and write a few routines that iron out the remaining differences. IMHO, SQL will be around long after the current generation of CDP'ers have retired. |
#13
| |||
| |||
|
|
Dave Goldfinch wrote: On 16 Oct 2006 11:14:20 -0700, "dawn" <dawnwolthuis (AT) gmail (DOT) com> wrote: SNIP If SQL is dead (or gasping), what then of Oracle? First of all, there is a huge, huge installed base for Oracle. Additionally, they have improved performance so much that I would be surprised if it beat out Pick shops these days if you optimize h/w and config for each. Also, they, like other DBMS vendors have added a ton of proprietary features (so unless a site is very careful not to use such features, it would not be easy to migrate from Oracle to SQL Server or DB2), so when you are using Oracle, you are not just using SQL-92, you are using all of the enhancements that Oracle has added, a few of which might align with newer standards. One other point on this is that Oracle bought Sleepycat, a tag-value database, not at all SQL-based. /SNIP Surely this would be no more difficult than moving from , say, D3 to JBase, or UnidData to D3 - choose the flavour of the day... Maybe not -- didn't mean to suggest it, but many do suggest or think that SQL is more standardized. It always amuses me when I hear how "non-standard" each SQL implementation is, compared to good ole Pick - what a joke ! Because SQL is prescriptive with its schema, rather than descriptive (as with MV dicts), there is more specified to the actual DBMS. However, I would never suggest it is easy to move from one MV flavor to another. Almost ever MV software house I have worked for over the last 25 years, has carefully written code in a limited sub-set of the MV Basic syntax that is reasonably common to most implementations. They have then used a pre-processor to generate code for each implementation they require. The previous company that I worked for, developed Browser based systems that could be switched from Access to SQL Server to Oracle. Basically they employed the same technique as all those MV people ie steer away from the really esoteric quirks of each implementation and write a few routines that iron out the remaining differences. IMHO, SQL will be around long after the current generation of CDP'ers have retired. Yes, as will MV. Removal of old technologies is far, far harder than introducing new ones. So, I think your points were 1. that SQL will be around for a long, long time. Agreed. 2. It isn't easy to switch from one MV flavor to another. Agreed. But I will suggest that it is amazingly reasonable to switch from some flavors of MV to other flavors given that there have been zero industry standards announced in MV. The move from Prime Information on Primos to UniData on AIX that we did after others had gone before us on the same VAR solution, was a lot easier than a Novell version upgrade done around the same time, for example. Cheers! --dawn |
#14
| |||
| |||
|
|
I'm on a contract job where they're converting from Universe to Oracle. There may be an opportunity to ramp up in Oracle, and I've long since flipped my priority from staying with Pick at all costs to providing for my family. It would be nice to see Pick thrive, but from my perspective, for all but a few niches, Pick is doomed. Time to don the ol' water wings and jump. |
#15
| |||||
| |||||
|
|
"Ed Sheehan" wrote: I'm on a contract job where they're converting from Universe to Oracle. There may be an opportunity to ramp up in Oracle, and I've long since flipped my priority from staying with Pick at all costs to providing for my family. It would be nice to see Pick thrive, but from my perspective, for all but a few niches, Pick is doomed. Time to don the ol' water wings and jump. Ed, if they're paying you enough for a good long period of time, then do the jump, and good luck! |
|
People have a tendency to want to toss MV because they have no idea of what it is. In your case: - Is the end-user aware that Universe is one of two MV DBMS products sold by IBM under the DB2 banner? |
|
- What is it costing to convert the software from MV to Oracle? Is this company aware that ONware can run MV code directly against an Oracle back-end? They can then create new SQL queries to run against the existing data and get the best of both worlds. (jBASE may be capable as well but not as readily as ONware I suspect.) |
|
- What do they hope to gain from moving to Oracle? Has anyone asked IBM to compare or profile the app and DBMS with whatever it is that Oracle is offering? |
|
Can someone provide some realistic numbers here which compare the number of combined U2 licenses being sold these days with the number of DB2 licenses? I'd guess the numbers are close and this is good marketing fodder that people should use if it can be verified. T |
#16
| |||
| |||
|
#17
| |||
| |||
|
|
david, you didn't appear to understand my point i understand you are a PICK developer i understand you have no soul PICK is merely a collection of concepts if you were a software engineer you would understand that |
#18
| |||
| |||
|
|
Dan, you've been doing well lately, it's a shame to see you go back to your old habits. |
#19
| |||
| |||
|
|
Dan, you've been doing well lately, it's a shame to see you go back to your old habits. i am trying but that was a direct attack. |
#20
| |||
| |||
|
![]() |
| Thread Tools | |
| Display Modes | |
| |