Difference between internal tables and extra datasets, Database Management System

What is the difference between internal tables and extract datasets?

  • The lines of an internal table always have the similar structure. By using extract datasets, you can handle groups of data with dissimilar structure and get statistical figures from the grouped data.
  • You have to describe the structure of the internal table at the starting. You need not describe the structure of the extract dataset.
  • In contrast to internal tables, the system partly compresses precise datasets when storing them. This decreases the storage space required.
  • Internal tables need special work area for interface while extract datasets do not require a special work area for interface.

 

Posted Date: 5/11/2013 3:59:01 AM | Location : United States







Related Discussions:- Difference between internal tables and extra datasets, Assignment Help, Ask Question on Difference between internal tables and extra datasets, Get Answer, Expert's Help, Difference between internal tables and extra datasets Discussions

Write discussion on Difference between internal tables and extra datasets
Your posts are moderated
Related Questions
What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.

What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

how to calculate frequency count of algorithm