How Query Optimizer Works in RDBMS

In a previous post, we discussed how the various relational operators are implemented in relational database systems. If you have read that post, you probably still remember that there are a few alternative implementations for every operator. Thus, how should RDBMS determine which algorithm (or implementation) to use? Obviously, to optimize the performance for any query, RDBMS has to select the correct the algorithm based on the query. It would not be desirable to always use the same algori...

   DATABASE,DATABASE DESIGN,DATABASE OPTIMIZATION     2019-04-20 07:26:32

  iPhone App Development: What’s New For Developers In iOS 11

A curiosity ends with the introduction of iOS 11 on 5th of June 2017. It is the next-generation version of iOS. This update takes the best and most advanced operating system and turns it up to 11. But with iOS 11 was released to the public on 19 September 2017 and since then, there have been two distinct updates to iOS 11.02 which fixed the earpiece noise during phone calls; and the major iOS 11.1. iOS 10 was an operating system update that largely ignored the iPad, but Apple made up for it in ...

   APPLE,IOS11     2017-11-02 11:15:22

  Twitter service down incidents summary

This Thursday, Twitter encountered a global service down incident. This is the second service down incident since last month. Later Twitter updated its website and stated that users might not be able to access Twitter temporarily.Twitter admitted the service down incident and explained that this time's service down was caused by problems of their both data centers.Ok, now lets summarize the service down incidents encountered by Twitter in past few years.in May 2008, Twitter's new engineer team w...

   Twitter,Service down,History     2012-07-28 12:36:39

  Selling Yourself: Why? and How!

I know many good developers who are under the impression that they either don’t have to sell themselves, or selling themselves is wrong, but is that really true?First let me clarify by defining what I mean by “selling yourself”. I don’t mean “selling out”, I mean marketing yourself, what you’re doing and what your skills are. Especially to your organization.I don’t need to sell myself, my code speaks for itself.Really? Do you think your pristin...

   Sell,Developer,Skill,Show,Resume,CV     2011-08-10 03:19:34

  Is programmer really profession for youth only?

- dedicated to the new programmers just into the workplace.

One young Chinese friend asked me: is programmer meant only for less experienced youth? Should I consider transition once if I work on it until 30 years old?

   Programmer,Youth,Product,Project,Career,Analysis     2012-03-18 07:06:44

  Jack Ma speaks within the company's intranet post PDD earnings report

On November 28th, PinDuoDuo(PDD) released its financial report for the third quarter of 2023, ending on September 30th. The revenue for the third quarter was 688.4 billion RMB, showing a year-on-year growth of 93.9%. The net profit, according to the U.S. General Accounting Standards, reached 15.54 billion RMB, with a net profit margin of 22.6%. PDD attributed its overall positive performance to the accelerated recovery of the consumer market and the vigorous implementation of its "high-qual...

   PDD,JACK MA,ALIBABA     2023-11-29 06:02:09

  New Unreal Engine 5 and Nvidia Technology in Black Myth: Wukong

In this article, we explore the cutting-edge Unreal Engine 5 and Nvidia GPU technologies used in the highly anticipated AAA game Black Myth: Wukong this year to enhance its game graphical quality. Our insights are based on an interview article of the technical lead of Game Science Interactive Technology, Geekerwan's experimental analysis, and Nvidia's official Black Myth: Wukong showcase featuring the RTX 40xx series. As a software engineer, my perspective may differ from that of a game develop...

       2024-08-24 09:32:55

  4 Technologies That Impact You (Without Your Knowledge)

Our world to day is so driven by technology that it’s easy to stay on top of the major changes and developments. We know when there’s a major new innovation in personal electronics; we know that the 5G network is rolling out this year; we track the progress of smart cars, learning thermostats, and interactive home speakers. We even tend to care about how major tech companies around the world are performing! However, as “plugged in” as we all seem to be to the world of tec...

   AI,DATA ANALYTICS,IOT     2020-04-16 06:35:54

  Parallel Javascript

Lately the ideas for a parallel, shared memory JavaScript have begun to take shape. I’ve been discussing with various JavaScript luminaries and it seems like a design is starting to emerge. This post serves as a documentation of the basic ideas; I’m sure the details will change as we go along. User Model The model is that a JavaScript worker (the “parent”) may spawn a number of child tasks (the “children”). The parent is suspended while the children exe...

   Parallel JavaScript,API,Spawn,Parent,Task     2012-01-11 12:02:00

  Read 10 new books from O'Reilly for free

Recently O'Reilly provided free access to some books. Some of them are even in early release status. Here we recommend 10 of them. 1、Mastering Perl 2、Git Pocket Guide 3、Vagrant: Up and Running 4、High Performance Browser Networking 5、802.11ac: A Survival Guide 6、Test-Driven Development with Python 7、Interactive Data Visualization for the Web 8、HTML5 Canvas 9、Programming JavaScript Applications 10、Agile Data Source : http://linu...

   O'Reilly,Free book,Early release     2013-07-03 07:56:20