Reg Data and DDIC

[Former Member]

Hi Frnz,

what is data integrity?

DDIC preserves DATA INTEGRITY AND DATA SECURITY how?

regards

[Former Member]

Hi Frnz,

what is data integrity?

DDIC preserves DATA INTEGRITY AND DATA SECURITY how?

regards

[Former Member]

Hi Frnd,

Wot is google?

[Former Member]

hi,

I did not understand whats given in GOOGLE

[Former Member]

>

> hi,
> 
> I did not understand whats given in GOOGLE

Then you just need to keep reading about data integrity until you understand it - this is a feature that applies to databases regardless of vendor, operating system, size, etc... I'm sure there is a lot of information about it if you search in Google.

If you don't understand it then look for another explanation. If you still don't understand, don't worry about it, move onto something else you are trying to learn and come back to it later. It's an aspect of database operation/management that is fundamental and will make a lot of sense as your knowledge increases.

[Former Member]

hi Gareth,

Why dont you exaplain? SDN is meant for helping right

Any way thnks for ur idea

regards

[Former Member]

>

> hi Gareth,
> 
> Why dont you exaplain? SDN is meant for helping right
> 
> Any way thnks for ur idea
> 
> regards

Because you will learn more if you search and discover yourself instead of getting the answers handed to you. I am helping you but as with so many people on here you want everything given to you - try to discover and learn for yourself and you will have a much better understanding. It would be pointless for me to write what data integrity is here when it is already freely available all over the web.

To get you going, read this http://en.wikipedia.org/wiki/Data_integrity which hopefully will help. Data Integrity isn't just a simple thing as someone has said - it is a fundamental aspect of database design and operation.

[Former Member]

Hi,

Is data security in DDICpreserved with lock objects and autorizations?

How foreign key relationships help in data integrity or data security

regards

Edited by: abap learner on Jul 1, 2008 10:39 AM

[Former Member]

Hi Learner,

Foreign key maintains the data integrity and to avoid redundency by validating the data.

The data security is provided by setting the authorizations.

Regards,

Jagadish.

[Former Member]

Check out the below related threadds

[Former Member]

Hi,

Please check this link

http://www.sapdb.org/7.4/htmhelp/ac/be98cea56511d2a97100a0c9449261/content.htm

http://searchsap.techtarget.com/general/0,295582,sid21_gci1111566,00.html

Integrity rules: the database system provides a wide range of declarative integrity rules, thus reducing the programming requirements for applications. Integrity rules that refer to a table can also be specified (see constraint name).

Key: a key comprising one or more columns can be defined for each table. The database system ensures that each key is unique. A key can also consist of columns of different data types (see key definition).

UNIQUE definition: the uniqueness of the values in other columns and column combinations can also be ensured by using other mechanisms (see UNIQUE definition for "alternate keys").

NOT NULL: by specifying NOT NULL, you can ensure that the NULL value is not accepted in individual columns.

DEFAULT definition: you can define default values for each column (see DEFAULT specification).

Referential integrity conditions: by specifying referential integrity conditions, you can declare deletion and existence dependencies between the rows in two tables (see name of a referential constraint).

Database procedures and triggers: complex integrity rules that require access to further tables can be formulated with database procedures or triggers.

Best regards,

raam

[Former Member]

Dude,

http://help.sap.com/saphelp_nw04s/helpdata/en/3a/14c43bb7137503e10000000a11402f/frameset.htm

Amit.

[Former Member]

Guys I already searched in the NET and did not get a clear idea,

could any one explain with an example

regards

[Former Member]

Hi,

data integrity means nothing but a relation between two things......what ever data we are going to fetch based on the conditions...that relevant data is known as data integrity.

ex:-

if matnr is a material used in different tables for different prespective.

that material having different quanitys .

by using that same matnr we can also fetch uom and plant details..

Regards,

venkat n