Multiple repeating attributes with related data

I have a requirement where I should have multiple document types, with each type having about 15-20 custom attributes. Out of these attributes, 5-6 should be multivalued attributes and can have huge data which is related.

For eg.

Type A should have metadata as attr1, attr2..... attr 15

attr5, attr6, attr7, attr8 and attr9 should be multivalued and can have values like

attr5	attr6	attr7	attr8	attr9
ABC	11	H1	41
			56
			58	155 (Total of 41 56 and 58)
		H2	76
			89	165 (Total of 76 and 89)
		H3	23	23
	12	H4	678
			45	723 (Total of 678 and 45)
		H5	34	34
	13	H32	76
			78
			98	252
XYZ	31	H65	22	22
		H54	1	1
	32	H87	22
			21
			2	45
		H66	1
			1	2
			0

So for ABC (which itself is a repeating field), there are 3 values for attr6 and then for each value of attr6 there can be multiple values for attr7 and so on.

I need to maintain these mappings somehow in the database and store the values which will also be used to search for documents and reporting. A user can search for a doc specifying any one value for attr5 and one value for attr6.

Can someone suggest a way to implement this

Thanks,

Udit Sud

Find more posts tagged with

Comments

bacham2

It's doable but I wouldn't recommend it. You will have to write a lot of code to maintain these relationships, and any bug will screw things up. Besides, I don't like how you are storing individual values and totals in the same attribute. How will you able to distinguish between a total and a discrete value? Finally, if the point of this is to do reporting, let me tell that you will have a hard time reporting on such data structures!

I don't know all your business requirements, but I would recommend that you store this information in XML format, and then as the content of your document. For reporting, maybe you should export this data in some data mart, and in a form that is more suited for reporting.

Hicham

documentum1

I think you can create a registered table and store these values. So it will be easy for maintaing the relations between datas

udit.sud

I thought of using registered table but the requirement for advanced search on these attributes does not get fulfilled and we will have to do customizations. The documents in this system are going to be scanned using Captiva and exported to Documentum. All these attributes are data of the documents and need to be maintained in the system for reporting and searching.