Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data problems on SC

Status
Not open for further replies.
JoeyA

JoeyA

IS-IT--Management
Apr 29, 2003
4
IE
Our organisation is considering implementing SC5 using Oracle 8.1.7 as our DB. I have a concern about the lack of data integrity, even at app level. It seems as though SC is implemented more as a file system instead of a relational type database and over time could result in some serious data inconsistencies and data anomalies normally associated to pre-hierarchical/network database designs.

Questions
- Has anyone experienced data integrity issues relating to SC? For example, contacts belonging to non-existent locations.
- How did you overcome these problems?
- Does SC have any integrity checks and how can they be implemented?
 
Sort by date Sort by votes
no way from sc side , but you can use format control and validations to build some rules for this
 
Upvote 0 Downvote
Thanks dx111ge,

This was my concern because this is a huge task. Please note that I'm not that familiar with the tool and therefore may be asking an obvious question : Is there a way of determining the references (FK) to another table using P4 or it's data dictionary (I assume that there is one). The only mechanism I have is the oracle query (assume I searching for all references to company) :
select table_name, column_name
from cols
where lower(column_name) like '%company%'.

This however will only work if all company references have the word 'company' in them.
 
Upvote 0 Downvote
normally it works , but sometimes , the names are different ( relations between company and another field in another table with the name 'name'). what you need is a erd , but the ERD from peregrine isn't really helpfull, some relations are missing.
 
Upvote 0 Downvote
We are currently consulting at a client who uses SC 5, and at first we also wanted to change the P4 DB over to a RDBMS. However, after doing some investigation, we decided to rather create a shadow RDBMS database. P4 is optimsised for performance, and we use the Shadow database for all our integrity and reporting requirements.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

steever
  • Locked
  • Question
Cubes OLAP and SC
Replies
0
Views
246
steever
steever
steever
  • Locked
  • Question
Reporting issues and Peregrine SC
Replies
2
Views
240
chrishaw
chrishaw
prakashmuthu
  • Locked
  • Question
Problem in SC Mail Notification
Replies
3
Views
273
prakashmuthu
prakashmuthu
jflarente
  • Locked
  • Question
changing controls on a wizard page at "runtime"
Replies
1
Views
312
Jasonic
Jasonic
Luke997
  • Locked
  • Question
SetValue and SC 1
Replies
4
Views
288
Luke997
Luke997

Part and Inventory Search

Sponsor

Back
Top