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
Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

What is an Operand? The data on which the operation is to be performed is known as an Operand

What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.