Featured Post

How to Check Column Nulls and Replace: Pandas

Image
Here is a post that shows how to count Nulls and replace them with the value you want in the Pandas Dataframe. We have explained the process in two steps - Counting and Replacing the Null values. Count null values (column-wise) in Pandas ## count null values column-wise null_counts = df.isnull(). sum() print(null_counts) ``` Output: ``` Column1    1 Column2    1 Column3    5 dtype: int64 ``` In the above code, we first create a sample Pandas DataFrame `df` with some null values. Then, we use the `isnull()` function to create a DataFrame of the same shape as `df`, where each element is a boolean value indicating whether that element is null or not. Finally, we use the `sum()` function to count the number of null values in each column of the resulting DataFrame. The output shows the count of null values column-wise. to count null values column-wise: ``` df.isnull().sum() ``` ##Code snippet to count null values row-wise: ``` df.isnull().sum(axis=1) ``` In the above code, `df` is the Panda

Tutorial: SAP HANA Basics for Beginners

What is SAP HANA?

HANA stands for High-Performance Analytic Appliance. SAP HANA is a combination of hardware and software, and is therefore an appliance.

SAP HANA supports column- and row-level storage. We can store and perform analytics on a huge amount of real-time, non-aggregated transactional data. Hence, HANA acts as both a database and a warehousing tool, which helps in making decisions at the right time.

Challenges in Traditional RDBMS?

There are a few challenges in traditional databases, such as latency, the cost involved, and complexity in accessing databases.

Related: SAP HANA jobs and career options

What is Architecture of traditional RDBMS?

Presentation Layer:

This is the top-most layer and allows users to manipulate data so that they can input it for querying.

This data input from users is passed on to the database layer through the application layer and the results are passed back to the application layer to implement business logics.

The presentation layer can be anything—the web browser, SAP GUI, SAP BEx, SAP Business Objects, and so on. These tools will be installed on individual client machines.

Application Layer:

This layer is also called the business layer. All the business logic will be executed in this layer. It controls the application's functionality by performing detailed processing. This can be installed on one machine or distributed across more than one system.

Database Layer:

This layer receives data from the business layer and performs the required operation from the database. It contains database servers that store the data. Data is stored independently of application layers or business logics.

The database layer remains as an internal interface and is not exposed to the end users. The application layer has to access the data in the database only through this layer.

Most Popular Content

Best SAP HANA interview questions
These Course Contents You Need in Your SAP HANA Training

Comments

Popular posts from this blog

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers

6 Python file Methods Real Usage