Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The following table explains few points about the use of row vs column store tablesTo know more about row and column store tables, refer the below link: SAP HANA is optimized for column storage.https://help.sap.com/doc/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/bd2e9b88bb571014b5b7a628fca2a132.html
To check the Compression ratio for a table, you can navigate to Table Definition. Go to Runtime Information.To see Compression Ratio, go to Columns tab. You can see the compression ratio in the Main Size Compression Ratio [%] column.
Yes, it is similar to a new keyword of C++. a new keyword is used to initialize/create an object. See the following example −Employee employee = new Employee();Here new keyword is used to create an object of class Employee.new Employee() invokes the constructor of the class Employee.new keyword can also be used without assigning the object to a reference variable. See the example −String name = new Employee().getName();Here we are creating an object using new keyword and then invoked a method getName() on the object and passed the result to a variable.
In SAP HANA, there are various methods and algorithms that you can use to store data in Column based structure- Dictionary Compressed, Run Length Compressed and many more.In Dictionary Compressed, cells are stored in form of numbers in tables and numeral cells are always performance optimized as compared to characters.In Run length compressed, it saves the multiplier with cell value in numerical format and multiplier shows repetitive value in the table.Compression is calculated using Compression factor. Compression factor refers to the ratio of the uncompressed data size to the compressed data size in SAP HANA.In SAP HANA, Compression is performed ... Read More
Following the the best practices while declaring a variable. These best practices maintains code readability, understandability as project code size increases.Variables names should be short or long enough as per the scope. For example, loop counter variable, i is fine whereas employee as loop variable.Specific words should not be used like equals, compare, data.Use meaningful names which can explain the purpose of the variable. For example cnt Vs counter.Don't use _ to declare a variable name, Use camel casing. For example, employeeName is better than employee_name.Each organization has its own syntax specific standards. Follow those rules to maintain consistency and ... Read More
In SAP HANA Studio, you can use System Monitor to view details of your SAP HANA system at a glance. It tells about Data Disk, Log disk, Trace Disk, Alerts on resource usage with priority.To open System Monitor, select HANA system in System pane and click on the icon as shown below −Once you scroll on the right side, you can see all the information of your HANA system as you mentioned including CPU% and used memory.
SAP HANA studio is an Eclipse-based tool and provides a central development environment and an administration tool for HANA database. These are the features of HANA Studio client −HANA Studio is a client tool, which can be used to access local or remote HANA system. You can use HANA Studio for performing HANA Administration, HANA Information Modeling and Data Provisioning.You can use SAP HANA Studio on Microsoft Windows 32 and 64-bit versions of Windows XP, Windows Vista, Windows 7 platforms.SAP HANA Studio provides perspectives to work on the following HANA features. You can choose Perspective in HANA Studio from the following ... Read More
SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. Following are key features of SAP HANA −SAP HANA is a combination of software and hardware innovation to process a huge amount of real-time data. Based on multi-core architecture in the distributed system environment. Based on column type of data-storage in the database and hence facilitates data compression, and on the fly aggregation.Storing Data in Columnar based table has following benefits −Data CompressionFaster read and write access to tables as compared to conventional Row based storageFlexibility & parallel processingPerform Aggregations and Calculations at ... Read More
In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.Let us understand this with an example, let us say you have 4 specific regions in the report and you want the report to be delivered to individual Regional Manager for their respective region. You can use dynamic recipient option to make it possible.To implement this, you need to create a dynamic recipient report by developing a webi report which contains ... Read More