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
Software failures :  In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr

Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r