topic Re: difference between data dictionary and data base in Application Development and Automation Discussions

difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:06:12 GMT

Hi,

Please give me clear view on data dictionary and data base.

Thanks

margani

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:08:58 GMT

Hi Margini,

Please check the forms u can find the lot of answers

Here is a link

http://www.sapdb.info/abap-data-dictionary/

What is a data dictionary?

Data Dictionary is a central source of data in a data management system. Its main function is to support the creation and management of data definitions. It has details about

· what data is contained?

· What are the attributes of the data?

· What is the relationship existing between the various data elements?

Best regards,

raam

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:09:29 GMT

hi,

DATA Dictionary: Where u create objects,tables,views etc

it holds the structure only not the data. these objects reside in repository

Database: holds the data of the objects what we created in data dictionary

refer this link

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea31446011d189700000e8322d00/content.htm

Regards,

priya

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:10:35 GMT

hi there.....

database is a repository of data...... it is a place which holds the entire data together......

while data dictionary defines the basis to distinguish the data....

this can be in the form of tables, views, etc.

hope this is helpful.

regards.

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:11:16 GMT

Hi,

Chk this link:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea31446011d189700000e8322d00/content.htm

http://www.sapdb.org/7.4/htmhelp/97/026b3ae886616ae10000000a114084/content.htm

Regards.

Edited by: Iyswarya Godi on Jun 24, 2008 11:13 AM

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:11:30 GMT

Hi ,

Please go through the below link....

help.sap.com/saphelp_nw04/helpdata/en/cf/21ea31446011d189700000e8322d00/content.htm

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:11:42 GMT

In data dictionary i.e, SE11 Tcode we have create all our data dictionary objects,

like tables, data elements, domains, search helps, matchcodes etc,

but actually database means where the data stores.

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:22:11 GMT

I believe we can think of it as Data Dictionary consisting of meta-data (data that describes/assigns attributes to the real data the business/necessity intends to deal with), while Database consists of the concrete/real data itself.

The Data Dictionary doesn't contain any useful business data itself, just like a pointer doesn't hold any significant value to the program, rather simply a memory address that finally contains the useful data .

Hope it helps.

Avraham

Edited by: Avraham Kahana on Jun 24, 2008 11:22 AM

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:30:28 GMT

hi,

go through this book...

learb abap in 21 days...by sam..

this book gives a clear idea on abap...

its very useful...

reward points if useful *******

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:32:54 GMT

HI,

the database is the repository where the actual data is store where as data dictionary is the data definitions about the that data object for underline database.

Regards

Nilesh

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 09:53:57 GMT

Hi,

By using dictionary we can define the possibles in global.like tables,types...... can use globally.

Where as db to maintain the dictionary data.

Regards

Krishna

Re: difference between data dictionary and data base

Former Member — Tue, 24 Jun 2008 10:06:43 GMT

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated while

a data dictionary is a collection of descriptions of the data objects or items in a data model for the benefit of programmers and others who need to refer to them.

A database contains some data but a data dictionary contains only thye definitions.No data is stored in the dictionary