What are the types of internal tables in SAP ABAP

Three types of internal tables are in SAP ABAP.

Standard Internal Tables: These tables have a linear index and can be accessed using the index or the key. The response time is in linear relationship with number of table entries. These tables are useful when user wants to address individual table entries using the index.

Sorted Internal Tables: These tables also have an index and the key. But the response time is in logarithmic relationship with number of table entries, since it users binary search algorithm instead of linear search. These tables are useful when user wants the table to be sorted while additional entries have to be added.

Hashed Internal Tables: These tables have no index, but have the key. The response time is constant irrespective of number of table entries, since it uses a Hash algorithm. These tables are useful when user wants to access the entries with key only.

Comments

SAP HANA In Memory Strategy

SAP HANA has many processes running on the SUSE Linux Server. SUSE Linux server manages the reservation of memory to all process. When SAP HANA starts up, Linux OS reserves memory for the program code, program stack, and static data. OS can dynamically reserve additional data memory upon request from the SAP HANA Server. SAP HANA create a memory pool for managing and tracking the consumption of memory. The memory pool is used to store all the in-memory data and system tables, thread stack, temporary computations and all other data structure required for managing the database. When more memory is required for table growth or temporary computations, the SAP HANA memory manager obtains this from the pool. For an overview, check out the Memory Overview feature of the SAP HANA studio. To access it, right-click on a System ->Configuration and Monitoring -> Open Memory Overview in the context menu, as follows:

SAP HANA Architecture

Data is compressed by different compression techniques (e.g. dictionary encoding, run length encoding, sparse encoding, cluster encoding, indirect encoding) in SAP HANA Column store. When main memory limit is reached in SAP HANA, the whole database objects (table, view,etc.) that are not used will be unloaded from the main memory and saved into the disk. These objects names are defined by application semantic and reloaded into main memory from the disk when required again. Under normal circumstances SAP HANA database manages unloading and loading of data automatically. However, the user can load and unload data from individual table manually by selecting a table in SAP HANA studio in respective Schema- by right-clicking and selecting the option "Unload/Load". SAP HANA Server consists of : Index Server Preprocessor Server Name Server Statistics Server XS Engine SAP HANA Index Server: SAP HANA Database Main server are index server. Detail of each server i...

SAP HANA Advantages

Below are advantages of SAP HANA - By In-Memory Technology user can explore and analyze all transaction and analytic data in real time from virtually any data source. Data can be aggregated from many sources. Real-time replication services can be used to access and replicate data from SAP ERP. SQL and MDX interface from third party support. It provides information modeling and design environment.

KalviTN

Search This Blog