Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Industrial archaeology

  
   Database Forums (Home) -> Ingres RSS
Next:  deny select on linked server  
Author Message
Roy Hann

External


Since: Sep 12, 2006
Posts: 44



(Msg. 1) Posted: Tue Nov 25, 2008 3:27 am
Post subject: Industrial archaeology
Archived from groups: comp>databases>ingres (more info?)
Does anyone (Mikey? John?) remember which release of Ingres introduced
B-trees? It was so long ago that I can persuade myself that it
was almost any release between 3 and 5.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

 >> Stay informed about: Industrial archaeology 
Back to top
Login to vote
Michael Leo

External


Since: Nov 03, 2006
Posts: 19



(Msg. 2) Posted: Tue Nov 25, 2008 12:27 pm
Post subject: Re: [Info-Ingres] Industrial archaeology [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Roy Hann wrote:
> Does anyone (Mikey? John?) remember which release of Ingres introduced
> B-trees? It was so long ago that I can persuade myself that it
> was almost any release between 3 and 5.
>

I used 3 for quite a while, and while I know it had
hash and isam, I can't remember if it had btrees ...

Somewhere buried in my junk is a storage guide written
by RTI engineering from that time. I can't begin to imagine
where it is.

There was an "index" storage type briefly talked about in a white
paper in the 4.x-5.x era.

If I find it, I will let you know.

Mikey

 >> Stay informed about: Industrial archaeology 
Back to top
Login to vote
OldSchool

External


Since: Nov 20, 2007
Posts: 5



(Msg. 3) Posted: Tue Nov 25, 2008 12:27 pm
Post subject: Re: Industrial archaeology [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Nov 25, 1:27 pm, Michael Leo
wrote:
> Roy Hann wrote:
> > Does anyone (Mikey? John?) remember which release of Ingres introduced
> > B-trees?  It was so long ago that I can persuade myself that it
> > was almost any release between 3 and 5.
>
> I used 3 for quite a while, and while I know it had
> hash and isam, I can't remember if it had btrees ...
>
> Somewhere buried in my junk is a storage guide written
> by RTI engineering from that time.  I can't begin to imagine
> where it is.
>
> There was an "index" storage type briefly talked about in a white
> paper in the 4.x-5.x era.
>
> If I find it, I will let you know.
>
> Mikey

well, it was there for sure by 6.2, although it had some teething
issues (b-tree split / rebalance would occassionally go sideways,
leaving 1/2 the db gone and the db inconsistent (ah yes...the good old
days). maybe a search of the trouble tickets (if such records exist)
would provide an indicator.
 >> Stay informed about: Industrial archaeology 
Back to top
Login to vote
Gorby

External


Since: Nov 26, 2008
Posts: 1



(Msg. 4) Posted: Tue Nov 25, 2008 6:25 pm
Post subject: Re: Industrial archaeology [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
OldSchool wrote:
> On Nov 25, 1:27 pm, Michael Leo
> wrote:
>> Roy Hann wrote:
>>> Does anyone (Mikey? John?) remember which release of Ingres introduced
>>> B-trees? It was so long ago that I can persuade myself that it
>>> was almost any release between 3 and 5.
>> I used 3 for quite a while, and while I know it had
>> hash and isam, I can't remember if it had btrees ...
>>
>> Somewhere buried in my junk is a storage guide written
>> by RTI engineering from that time. I can't begin to imagine
>> where it is.
>>
>> There was an "index" storage type briefly talked about in a white
>> paper in the 4.x-5.x era.
>>
>> If I find it, I will let you know.
>>
>> Mikey
>
> well, it was there for sure by 6.2, although it had some teething
> issues (b-tree split / rebalance would occassionally go sideways,
> leaving 1/2 the db gone and the db inconsistent (ah yes...the good old
> days). maybe a search of the trouble tickets (if such records exist)
> would provide an indicator.
Wow! Good Question! Why do you want to know?

I started on Ingres in the 80's on 5.0.something on VAX/VMS. It had
Btree index then.
 >> Stay informed about: Industrial archaeology 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Process hanging on Endselect - We have a process which needs to produce an average figure over the last 16 qualifying weeks. The way it currently works is to select the rows from the two relevant tables ordered by date descending, then in a select loop check if the week qualifies and...

E_DM9063_LK_TABLE_MAXLOCKS - We have a weekly job that takes a COPY.OUT from the "Live" database and then does a COPY.IN to a development database in a separate installation. I've noticed that in one instance, the ERRLOG is getting a number of messages of the general form...

Help fo vnode - I am going to use the ingres replication. For that I have set vnodes using "netutil". I have configured all the things for replication on my local database using repmgr. Now I want to move the Configuration to the Remote Server database. When I...

Help for starting the replication server - I have configured the database for replication using repmgr command I also started the replication server. It is started and its status is active. But there are one error message comming which is related to the authorization of the remote database. Using...

[Info-ingres] vnode puzzle - Hi Dudes, I have a 2.6 installation with several vnodes defined pointing to other installations. All of which test perfectly well using netutil test mode. But when I try to use a simple sql vnode::dbname connection I get the following: sql rat::iidbd...
   Database Forums (Home) -> Ingres All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]