I have an Event Business Object (BO) that has basic attributes like Date, EventType, Topic, Status, Organizer, and Attendees (another related BO).
Depending on the EventType, I will have other attributes that are specific to an EventType. Is it better design (flexibility, but more important, performance) to have separate groups of attributes in a single Event BO, or better to store those EventType specific attributes in separate related BOs? If separate related BOs, those would be peers to the Event BO.
For example, a conference event would have separate attributes than a meeting event. Hopefully I have described this well.
Dave
related Business Object design vs separate groups of columns
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: related Business Object design vs separate groups of col
Hard to say. Design-wise groups of objects are better. However, groups of objects incur some performance penalty when you include business object groups in your queries. Whether this penalty will be significant depends on the queries and how they are used in the system. Some poorly performing queries can be replaced with stored procedures, though.
Aware IM Support Team
Re: related Business Object design vs separate groups of col
Thanks. as a database guy, I will look to using AwareIM with stored procedures. I did not see a video on that, but I will look through the doc.
On that note of stored procs, I see that a BASEVERSION is implemented in the tables. I assume that gets overwritten by the app as necessary, and AwareIM is not creating separate "versioned" records, correct? I would not want to worry about versioning when searching for database records in stored procs.
Dave
On that note of stored procs, I see that a BASEVERSION is implemented in the tables. I assume that gets overwritten by the app as necessary, and AwareIM is not creating separate "versioned" records, correct? I would not want to worry about versioning when searching for database records in stored procs.
Dave
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: related Business Object design vs separate groups of col
Code: Select all
I did not see a video on that, but I will look through the doc.
Also EXEC_SPF function.
Code: Select all
On that note of stored procs, I see that a BASEVERSION is implemented in the tables. I assume that gets overwritten by the app as necessary, and AwareIM is not creating separate "versioned" records, correct? I would not want to worry about versioning when searching for database records in stored procs.
Aware IM Support Team