×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data problems on SC

Data problems on SC

Data problems on SC

(OP)
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?

RE: Data problems on SC

no way from sc side , but you can use format control and validations to build some rules for this

RE: Data problems on SC

(OP)
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.

RE: Data problems on SC

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.  

RE: Data problems on SC

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close