BR Forum • [BR_forum] KLN

Page 1 of 1

[BR_forum] KLN

Posted: Fri Sep 05, 2008 8:46 am

by gothnerd at gmail.com

on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.

Is that accurate? It just seems on the small side.

-john

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Looks like you need LuisGomez.net solar generation services!

http://www.luisgomez.net/solar

Luis

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!

Percy

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane

Percy,

Are you out of danger? Or are you in the path of the hurricane?

-- Susan

Susan Smith wrote:
Charlie,

Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.

-- Susan

Post generated using Mail2Forum (http://www.mail2forum.com)

[BR_forum] KLN

Posted: Fri Sep 05, 2008 9:15 am

by GomezL at collectionso...

This is indeed true.

Do keep in mind that an index record looks something like this

MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).

These index records are stored on “Leaves” on the “B-Tree”.

The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.

Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN

on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.

Is that accurate? It just seems on the small side.

-john

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!

http://www.luisgomez.net/solar

Luis

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!

Percy

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane

Percy,

Are you out of danger? Or are you in the path of the hurricane?

-- Susan

Susan Smith wrote:
Charlie,

Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.

-- Susan

Post generated using Mail2Forum (http://www.mail2forum.com)

[BR_forum] KLN

Posted: Fri Sep 05, 2008 9:33 am

by tech at sys-corp.com

John,

I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.

--Richard Forrester

John Bowman wrote:

on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.

Is that accurate? It just seems on the small side.

-john

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Looks like you need LuisGomez.net solar generation services!

http://www.luisgomez.net/solar

Luis

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!

Percy

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane

Percy,

Are you out of danger? Or are you in the path of the hurricane?

-- Susan

Susan Smith wrote:
Charlie,

Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.

-- Susan

_______________________________________________
BR_forum mailing list
BR_forum@maillist.ads.net (BR_forum@maillist.ads.net)
http://maillist.ads.net/mailman/listinfo/br_forum

Post generated using Mail2Forum (http://www.mail2forum.com)

[BR_forum] KLN

Posted: Fri Sep 05, 2008 9:35 am

by gothnerd at gmail.com

okay, thanks guys!

-john

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of SysCorp Tech Support
Sent: Friday, September 05, 2008 11:32 AM
To: Business Rules Forum
Subject: Re: [BR_forum] KLN

John,

I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.

--Richard Forrester

John Bowman wrote:

on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.

Is that accurate? It just seems on the small side.

-john

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Looks like you need LuisGomez.net solar generation services!

http://www.luisgomez.net/solar

Luis

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!

Percy

From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane

Percy,

Are you out of danger? Or are you in the path of the hurricane?

-- Susan

Susan Smith wrote:
Charlie,

Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.

-- Susan

_______________________________________________
BR_forum mailing list
BR_forum@maillist.ads.net (BR_forum@maillist.ads.net)
http://maillist.ads.net/mailman/listinfo/br_forum

Post generated using Mail2Forum (http://www.mail2forum.com)

[BR_forum] KLN

Posted: Fri Sep 05, 2008 9:45 am

by GomezL at collectionso...

You might be interested in the Sort Command:

Technical Considerations
1.) The following field lengths are required for the D, S & L format specs: D is 8; S is 4; & L is 9.
2.) The total sort key length may not exceed 32,767 bytes.
3.) Up to ten fields may be specified with the MASK specification.
4.) MASK must always be the last specification in a sort group.
5.) The existence of MASK flags the end of the current sort group. Business Rules will automatically treat any specifications that follow as part of the next sort group.

Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Friday, September 05, 2008 11:13 AM
To: Business Rules Forum
Subject: RE: [BR_forum] KLN

This is indeed true.

Do keep in mind that an index record looks something like this

MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).

These index records are stored on “Leaves” on the “B-Tree”.

The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.

Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN

on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.

Is that accurate? It just seems on the small side.

-john

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!

http://www.luisgomez.net/solar

Luis

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane

Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!

Percy

From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane

Percy,

Are you out of danger? Or are you in the path of the hurricane?

-- Susan

Susan Smith wrote:
Charlie,

Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.

-- Susan

Post generated using Mail2Forum (http://www.mail2forum.com)