CHALALO

Diabético Tipo 1,Creador de la Escala de Notas, Geek,Arquitecto de Software,Mg Ing. Informática, Profe de Postgrado, mi canal

[Aurimas Griciūnas @Aurimas_Gr]

What is the 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝘆 𝗼𝗿𝗱𝗲𝗿 𝗼𝗳 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻?

There are many steps involved in optimising your SQL Queries. It is helpful to understand the order of SQL Query Execution as we might have constructed a different picture mentally.

The actual order is as follows:

𝟭. 𝗙𝗥𝗢𝗠 𝗮𝗻𝗱 𝗝𝗢𝗜𝗡: determine the base data of interest.

𝟮. 𝗪𝗛𝗘𝗥𝗘: filter base data of interest to retain only the data that meets the where clause.

𝟯. 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬: group the filtered data by a specific column or multiple columns. Groups are used to calculate aggregates for selected columns.

𝟰. 𝗛𝗔𝗩𝗜𝗡𝗚: filter data again by defining constraints on the columns that we grouped by.

𝟱. 𝗦𝗘𝗟𝗘𝗖𝗧: select a subset of columns from the filtered grouped result. This is also where 𝗪𝗜𝗡𝗗𝗢𝗪 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗮𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗶𝗼𝗻𝘀 happen.

𝟲. 𝗢𝗥𝗗𝗘𝗥 𝗕𝗬: order the result by one or multiple columns.

𝟳. 𝗟𝗜𝗠𝗜𝗧: only retain the top n rows from the ordered result.

Below is a nice way to visualize it.

What are your thoughts? Let me know in the comment section 👇

--------

Follow me to upskill in #MLOps, #MachineLearning, #DataEngineering, #DataScience and overall #Data space.

Also hit 🔔to stay notified about new content.
𝗗𝗼𝗻’𝘁 𝗳𝗼𝗿𝗴𝗲𝘁 𝘁𝗼 𝗹𝗶𝗸𝗲 💙, 𝘀𝗵𝗮𝗿𝗲 𝗮𝗻𝗱 𝗰𝗼𝗺𝗺𝗲𝗻𝘁!

Join a growing community of Data Professionals by subscribing to my 𝗡𝗲𝘄𝘀𝗹𝗲𝘁𝘁𝗲𝗿.

[Milan Jovanović @mjovanovictech]

Amazon's Prime Video team migrated one system from Microservices to a Monolith.

And reduced cloud costs by 90%.

Here are the most important takeaways:

[Dr Milan Milanović @milan_milanovic]

𝗪𝗵𝘆 𝗔𝗺𝗮𝘇𝗼𝗻 𝗔𝗯𝗮𝗻𝗱𝗼𝗻𝗲𝗱 𝗠𝗶𝗰𝗿𝗼𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀 𝗔𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁𝘂𝗿𝗲 𝗶𝗻 𝗙𝗮𝘃𝗼𝗿 𝗢𝗳 𝗠𝗼𝗻𝗼𝗹𝗶𝘁𝗵?

In the latest post (check in the comments), a team that works on Prime Video explained their approach to ensuring that customers receive high-quality content. They use a tool to monitor every stream viewed by customers and use it to identify quality issues.

The tool was intended to run on a small scale, so they noticed that 𝗼𝗻𝗯𝗼𝗮𝗿𝗱𝗶𝗻𝗴 𝗺𝗼𝗿𝗲 𝘀𝘁𝗿𝗲𝗮𝗺𝘀 𝘁𝗼 𝘁𝗵𝗲 𝘀𝗲𝗿𝘃𝗶𝗰𝗲 𝘄𝗮𝘀 𝘃𝗲𝗿𝘆 𝗲𝘅𝗽𝗲𝗻𝘀𝗶𝘃𝗲. So, they decided to revise the architecture.

The initial architecture consisted of 𝘀𝗲𝗿𝘃𝗲𝗿𝗹𝗲𝘀𝘀 𝗰𝗼𝗺𝗽𝗼𝗻𝗲𝗻𝘁𝘀 𝗼𝗿𝗰𝗵𝗲𝘀𝘁𝗿𝗮𝘁𝗲𝗱 𝗯𝘆 𝗔𝗪𝗦 𝗦𝘁𝗲𝗽 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀. What they did here is to move expensive operations between components into a single process to keep the data more trans within process memory.

Building initial solutions with serverless components was a good choice because it enabled it to be done quickly and scale each component, yet such a way of using some components 𝗰𝗮𝘂𝘀𝗲𝗱 𝗶𝘀𝘀𝘂𝗲𝘀 𝗮𝘁 𝟱% 𝗼𝗳 𝘁𝗵𝗲 𝗲𝘅𝗽𝗲𝗰𝘁𝗲𝗱 𝗹𝗼𝗮𝗱.

After the analysis, they concluded that the distributed approach didn't bring many benefits, so they packed all the components into a single process. 𝗠𝗼𝘃𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝘀𝗲𝗿𝘃𝗶𝗰𝗲 𝘁𝗼 𝗮 𝗺𝗼𝗻𝗼𝗹𝗶𝘁𝗵 𝗿𝗲𝗱𝘂𝗰𝗲𝗱 𝘁𝗵𝗲𝗶𝗿 𝗶𝗻𝗳𝗿𝗮𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲 𝗰𝗼𝘀𝘁 𝗯𝘆 𝗼𝘃𝗲𝗿 𝟵𝟬% 𝗮𝗻𝗱 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲𝗱 𝘀𝗰𝗮𝗹𝗶𝗻𝗴 𝗰𝗮𝗽𝗮𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀.

Image credits: Amazon.

_______
If you like my posts, please follow me, @milan_milanovic, and hit the 🔔 on my profile to get a notification for all my new posts.

Grow with me 🚀!

#technology #softwareengineering #cloudcomputing #techworldwithmilan #softwarearchitecture

[SpaceX @SpaceX]

Onboard view from Falcon 9’s flight to space and back during smallsat rideshare mission

[Pasion Basket @PasionBasketNBA]

Hoy se cumplen 31 años de este icónico momento: Michael Jordan se dirigía a un joven rookie llamado Mutombo y le decía: "Hey, esta es para ti" Y anotaba un tiro libre con los ojos cerrados. Así de fácil 🐐

[Marcos Caballero @SecMcaballero]

Piensa antes de compartir tus fotos en RRSS

[CHALALO @chalalo]

@clatto esa guea es un dinosaurio

[Pedro Huichalaf Roa 📱+ 🖥️+🌐 @huichalaf]

Un kiosquero argentino organizó una millonaria estafa hackeando tarjetas de crédito con un algoritmo escrito en papel
https://t.co/szFjZBgRFf

Sin usar tecnología (sólo con lapiz y papel) y sin hackear sistemas informáticos, logró engañar a empresas.

Para sorprenderse.

[CHALALO @chalalo]

@desastronomo @lesliona No la he visto, anotada!

[CHALALO @chalalo]

hay mentiras y esta guea.... y tener el caraderajismo de publicarla, chuta....

[🅶🅰🅱🆁🅸🅴🅻.🅿.🆂_ @GABRIELPADILLA7]

La gente que quería que Will Smith ganara un #Oscar en estos momentos:

[CHALALO @chalalo]

@radixcl Siempre

[CHALALO @chalalo]

Que buena aplicación para docentes y profesores https://t.co/7IgYkOTrUK please RT :)

[CHALALO @chalalo]

#ContigoCHV igual un RT no estaría mal de esta gran app que sirve mucho a docentes y alumnos :) https://t.co/fNt1v9rVrM

[CHALALO @chalalo]

@anbernardi fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake fake

[CHALALO @chalalo]

@anbernardi añlskdjkaslkjdlaskjdasd

[CHALALO @chalalo]

@anbernardi fake