dbTalk Databases Forums  

Oracle for Pick Programmers Book?

comp.databases.pick comp.databases.pick


Discuss Oracle for Pick Programmers Book? in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Dave Goldfinch
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-16-2006 , 07:54 PM






On 16 Oct 2006 11:14:20 -0700, "dawn" <dawnwolthuis (AT) gmail (DOT) com> wrote:

<SNIP>
Quote:
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.

Dave





Reply With Quote
  #12  
Old   
dawn
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-16-2006 , 08:48 PM






Dave Goldfinch wrote:
Quote:
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.
Quote:
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.

Quote:
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



Reply With Quote
  #13  
Old   
Dave Goldfinch
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-16-2006 , 10:58 PM



On 16 Oct 2006 18:48:37 -0700, "dawn" <dawnwolthuis (AT) gmail (DOT) com> wrote:

Quote:
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
I did not mean to say that it isn't easy to switch MV flavours. As I
said, most software houses, in my experience, cater for this.

I do contend that it is as easy to change SQL platforms as it is to
change MV flavours with the proviso that you do not use the more
exotic "features" implemented by some providers.

There were some guidelines for MV standards when the Spectrum
Manufacturers Group was in existence, although they never had the
authority of a published Satandard..

What little of Novell I have seen, makes me very pleased that I have
not seen any more !!

Dave


Reply With Quote
  #14  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-17-2006 , 06:00 PM



"Ed Sheehan" wrote:
Quote:
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


Reply With Quote
  #15  
Old   
Ed Sheehan
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-17-2006 , 10:38 PM



Inline...
"Tony Gravagno" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote

Quote:
"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!
If it turns out to be a smart career move, I'll do it. Of course, I'll need
to determine if I like the environment etc., but in many areas in Pick,
things seem to be drying up. I know some niches are still thriving, but it's
heard for me to see the big Pick picture from my vantage point. Are there
struggling Oracle programmers/dba's?

Quote:
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?
By the time I got there, it was already decided. They're about 25% converted
now. I'm sure they were pitched well by the Oracle team. Their legacy staff
seem to have no interest in staying beyond go-live, even if they could cut
over.

Quote:
- 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.)
Can't be super specific, but in excess of $10 mil.

Quote:
- 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?
From the users point of view, it's shiny and new and has windows 'n mice.
The four basic food groups. Nobody else is too concerned with techy issues.
They are aware of the Oracle reputation, so they feel it'll provide or can
be made to provide whatever buzzword du jour is required down the road.
Quote:
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



Reply With Quote
  #16  
Old   
qbit
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-25-2006 , 04:26 PM



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


Reply With Quote
  #17  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-26-2006 , 05:23 AM



"qbit" <tronic5572 (AT) yahoo (DOT) co.uk> wrote:

Quote:
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
Dan, you've been doing well lately, it's a shame to see you go back to
your old habits.


Reply With Quote
  #18  
Old   
qbit
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-26-2006 , 06:14 PM



Quote:
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.



Reply With Quote
  #19  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-27-2006 , 07:11 AM



"qbit" wrote:
Quote:
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.
No, that was a difference of opinion. Seriously, your comments lately
have been fitting right in. Try not to "go off" like you're sometimes
inclined to do. I think we'll all enjoy the discussions more. Rather
than putting you on my ignore list like I used to, these days I
actually make sure I read whatever you have to say.

Take a look at some of the "attacks" I get involved with in this forum
and elsewhere. It may be hard to believe but some of these people
that I fight with have been my friends for anywhwere up to 24 years
and we get together whenever we can. With few exceptions, this
"thing" we do here isn't personal, it's passion. When people get
heated up about a topic they care about, it's easier to be more
direct. You certainly feel that from time to time. Cut other people
some slack and they'll do the same.

Cheers,
T


Reply With Quote
  #20  
Old   
qbit
 
Posts: n/a

Default Re: Oracle for Pick Programmers Book? - 10-27-2006 , 06:04 PM



i am a man called horse


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.