Type design, architectural question

Hi,

One of our clients wants to import folders into their repository.

While creating object types I realized that some attributes they gave me are really belong to folders, (Lets say "Date received", etc.) and some of them are for documents inside these folders (Lets say "Importance", etc.)

First I think to inherit a folder object type from dm_folder, and a document object type from dm_document.

But customer wants to search documents including the attributes from the folders.

For example date received between these days and importance=high

I think repeating "Date received" on all of the documents is waste of DB space (Because there may be millions documents in one folder) but I can't figure out how to design a system to achive the goal.

I have a look at the concept of "aspect" but I think it is not the one that I'm looking for.

Other solution I think of is the customization of webtop.

Any recommendations for me?

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

lastnitescurry

If using 6.5+ this read up on Light weight types. they could be what you want

All comments

lastnitescurry

If using 6.5+ this read up on Light weight types. they could be what you want

aflowers001

A sub select perhaps might assist.

something like (and this is untested pseudo stuff)

select * from mydocumenttype where x='1' and y='other' and any i_folder_id in (select r_object_id from dm_folder_subtype where datereceived < datvalue)

this will limit to only documents in any matching folder, but it will include linked folders which might not be what you want and might not be how you design the solution.

lightweight objects might help but I believe you'd have to invest in HVS as far as i'm aware.

bdipso

Hi,

Thank you for your answer. It seems Light weight sysobjects are the answer to my question by definition.

I'm going to try to implement this solution.

Thank you again.

bdipso

Hi;

I was thinking of to customize the webtop as you explained, but I don't prefer to do that. Lots of code changes that may result lots of errors

Right now I don't know if attributes of Lightweight objects are visible on the webtop advanced search screen or not. I'll try HVS and suggest this product to customer if it is successfull. After that they can choose :

1) If they want to pay for it

2) Repeating info on the database

3) A customization which may perform badly

Thank you,