Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Kafka Flowchart Useful for Dummies

Architecture for dummies


How Kafka Works


Here're the prime points on Kafka stream-processing. In Mainframe, the data you receive/process in two methods (Batch and online). In Kafka, it receives data and sends it to consumers. Here're the details with Architecture, Logs, and applications that use Kafka.

The streaming data is different (YouTube Live). When the data comes into Queue the data will then be processed. In the batch process, you need to wait till you get the Batch completes. In the case of stream processing, it is on the fly.

1. Architecture



Kafka Architecture

2. Process

  • Kafka is a publish/subscribe system, but it would be more precise to say that Kafka acts as a message broker. A broker is an intermediary that brings together two parties that don’t necessarily know each other for a mutually beneficial exchange or deal.
  • Kafka stores messages in topics and retrieves messages from topics. There’s no direct connection between the producers and the consumers of the messages. Additionally, Kafka doesn’t keep any state regarding the producers or consumers. It acts solely as a message clearinghouse.
  • The underlying technology of a Kafka topic is a log, which is a file that Kafka appends incoming records to. To help manage a load of messages coming into a topic, Kafka uses partitions.
  • The use of partitions is to bring data located on different machines together on the same server. We’ll discuss partitions in detail shortly.

Kafka Logs

  • It writes the incoming messages to logs.
  • It appends to the logs. it will not delete the existing records. 

Zookeeper 

  • ZooKeeper is a centralized service for maintaining configuration information, naming, providing distributed synchronization, and providing group services. 
  • All of these kinds of services are used in some form or another by distributed applications.

3. Stream Data Structure

Stream Data Key Points:

  • Here are the key points to remember: If you need to report on or take action immediately as data arrives, stream processing is a good approach.
  • If you want to Carry detailed analysis- If you need to perform in-depth analysis or are compiling a large repository of data for later analysis, a stream-processing approach may not be a good fit.
How the stream data comes into the Kafka server you can see here.

4. The Kafka Based Applications

Credit card fraud—A credit card owner may not notice a card has been stolen, but by reviewing purchases as they happen against established patterns (location, general spending habits), you may be able to detect a stolen credit card and alert the owner.


Intrusion detectionAnalyzing application log files after a breach has occurred may be helpful to prevent future attacks or to improve security, but the ability to monitor aberrant behavior in real-time is critical.


In a large race, such as the New York City Marathon—Almost all runners will have a chip on their shoe, and when runners pass sensors along the course, you can use that information to track the runners’ positions. By using the sensor data, you can determine the leaders, spot potential cheating, and detect whether a runner is potentially having problems.


The financial industryThe ability to track market prices and direction in real-time is essential for brokers and consumers to make effective decisions about when to sell or buy.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers