hindu.hashnode.devOracle PL/SQL Materialized ViewsMaterialized View A materialized view whose contents are periodically refreshed based on a query, either against a local or remote table. fig 1 represents materialized view logic flow CREATE MATERIALIZED VIEW view-name BUILD [IMMEDIATE | DEFERRED] R...Sep 8, 2025·3 min read
hindu.hashnode.devConcurrency in easy way - part 2Previous, blog ( Concurrency in easy way - part 1 ), analog the balls as the threads. First, let know about the process. A process generally has a complete, private set of basic run-time resources; in particular, each process has its own memory space...Aug 16, 2025·2 min read
hindu.hashnode.devLogic Behind SQL queries - part 1Hello, Solving SQL queries is somewhat difficult but it can be solved ease with by knowing some logical tricks and understanding the basics. First, let us know about the control flow of the SQL statements. Generally, the SQL statement is in the form ...Aug 10, 2025·2 min read
hindu.hashnode.devConcurrency in easy way - part 1In the above picture, the joker performing the art by balancing the all balls one by one, and in the following way, if he hold ball for a sec, then immediately he will throw the ball up and caught another ball. Joker continuously holding the differen...Aug 6, 2025·1 min read
hindu.hashnode.devThe 2025 EY Open Science AI and Data Challenge: Cooling Urban Heat Islands ExperienceThis challenge is focused on a phenomenon known as the urban heat island effect, a situation that occurs due to the high density of buildings and lack of green space and water bodies in urban areas. Temperature variations between rural and urban envi...Apr 11, 2025·3 min read