Re: Is IBM actually doing something with IDS?

Serge Rielau wrote:
Obnoxio The Clown wrote:
DA Morgan said:
Obnoxio The Clown wrote:

Horse***. When I asked you to explain this feature when you were
crowing
about it years ago, you used an order entry example. If that's not OLTP,
I
don't know what is.
You aren't accusing Serge of painting the target after the arrow was
shot are you? <g>

That's one way of putting it. :o)

Using much less controversial language though and without dragging me into his fantasies. What's with that fixation on horses behinds? ;-)

I indeed used order entry examples and I keep using them.
Just because the primary target of the language OLTP doesn't mean it's useless in OLTP. In fact the cause to implement was TPC-C.
It's just fluffy language wise, but SQL isn't exactly known to be easy on the keyboard to begin with. ;-)

Since we have Daniel on board now - oh joy - maybe he can tell us how one moves (not just copies) data from one table to another in his world.

Well first we start by asking the customer the following questions.

1. What version of what product to what version of what product?
2. What volume of data? Are we talking single transactions or GB?
3. What is the windows? One second or one day?
4. How close to real-time? Milliseconds? 24 hours?
5. With or without transformation?
6. With or without audit trail and compliance requirements?
7. For what purpose?
8. One time only or as a regularly scheduled job?

There is a huge difference between copying to a DR site real time and
copy to a reporting database on a separate server and copying within a
single stand-alone database-instance.

The best practice answer depends on many factors and technologies that
come to mind. In an Oracle environment, they would range from
transportable tablespaces to Streams to Change Data Capture to Data
Guard to external tables to datapump export-import to database links to
spooling it out as a text file.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.