I just watched a presentation from Mar 11, 2012, where Paul Graham / YCombinator is giving away seven billion dollar startup ideas:
- A New Search Engine
- Replace Email
- Replace Universities
- Internet Drama
- The Next Steve Jobs
- Bring Back Moore’s Law
- Ongoing Diagnosis
Idea 6 on the list, is basically about the need to invent the sufficiently smart compiler, capable of understanding how to automatically break down a problem (expressed in code) into pieces which can be executed in parallell, in order to utilize GPUs and/or a lot of CPU cores.
Building such a compiler is probably extremely difficult, if at all possible, perhaps mainly due to the complexity possible to express in C, C++, Python, Java or any normal imperative language.
Imagine instead the same problem but for a declarative language like SQL. Would it be equally difficult? Core member Bruce Momjian of the PostgreSQL team have already expressed his ideas on how to tackle the problem.
When thinking about it, the query planner is a bit like a compiler, kind of. It takes the SQL and figures out a smart way to execute it, breaking it down into a lot of sub-tasks, of which some could with benefit be executed in parallel.
So let’s hope the great pg-hackers will pull this off, so we don’t have to pay some future start-up compiler-billionaire license fees to get automatic parallelism.
Joel on SQL 
Well the really exciting thing to do would be to integrate it with LLVM so the query planner could actually compile an optimized native code blob to perform the query if it deems it worthwhile.
A more declarative language like SQL should be able to be more easily optimized/parallelized than typical imperative languages. I also like that LLVM idea in the first comment. That being said, we could also gain a lot more speed yet by improving the query language. Misfeatures in SQL like 3-valued logic / nulls and duplicate rows also weigh heavily on an optimizer as there are a lot of logically reasonable query restructuring that it can’t do because under 3VL or dups it could change the answer, even though most of the time that isn’t in a way the user cares about.
Automatic high-degree parallelism requires a higher level of programming. There’s just no way that a compiler can optimize just any code to automatically work across many cores. We can only get so far with out-of-order execution, speculative execution etc — which is and has already been done by CPUs for years — but is really just wasted CPU cycles in the absence of something better to do.
We need to start thinking strongly about the higher-level abstractions that let us “parallelize” work. Relational databases and SQL have these higher-level abstractions, but we could do a lot more research in this area.
You will have real big problems if you are tinryg to build with those things and not know what they are. Try looking through wikipedia for the definitions of each of those. A summary i can give you goes like this:SQL is the language used to query (retrieve or insert) data into the database. So the database stores all your data. SQL is a standard language that is used to manipulate data on all databases. Samples of databases are MySQL, Oracle, MS-SQL, Sybase, PostgreSQLPHP is a server-side language (meaning it executes on the server and is not dependent on the client which can be any browser) meant to display data to the user. PHP is needed to connect to the database and use SQL to retrieve the data, and then PHP displays the data to the user. The user will be reading the data from a web browser. The best example is Email or even yahoo answers. Your Questions and my answers are held in a database. But to take it out you need to ask for the right thing from the database. For this you need SQL. And to display it to the user that is what PHP is for. Good Luck.
we prefer to honor lots of other world-wide-web web sites on the inteenrt, even though they aren?t linked to us, by linking to them. Below are some webpages worth checking out
Their services are valuable to you simply because
they take the guess work out of the training and nutrition your body
needs to be healthy for life. Now you already know what can affect this fat
loss, but maybe yourself not sure whether you can do
this or not. That is why you only need to follow the
above guidelines 90% of the time, which allows for 4-5 cheat meals per week.
My brother recommended I might like this website. He was entirely right.
This post actually made my day. You cann’t imagine simply how much time I had spent
for this information! Thanks!
LLVM? Who needs that? SQL is by far more powerful than CISC optimization 😛 Go for GPU: https://wiki.postgresql.org/wiki/PGStrom
I pay a visit day-to-day a few sites and sites to read posts, but this website offers
feature based articles.
Building such a compiler is probably extremely difficult, if at all possible, perhaps mainly due to the complexity possible to express in C, C++, Python, Java or any normal imperative language.
Imagine instead the same problem but for a declarative language like SQL. Would it be equally difficult? Core member Bruce Momjian of the PostgreSQL team have already expressed his ideas on how to tackle the seo singapore.
I see that comment spam is getting more sophisticated, even copying parts of the main blog post into the result in order to appear like a normal comment at first, but the one earlier today is anything but.
Building such a compiler is probably extremely difficult, if at all possible, perhaps mainly due to the complexity possible to express in C, C++, Python, Java or any normal imperative language.Senator Lee Rhiannon tweeted her congratulations. In contrastaccounting software singapore
Idea 6 on the list, is basically about the need to invent the sufficiently smart compiler, capable of understanding how to automatically break down a problem (expressed in code) into pieces which can be executed in parallell, in order to utilize GPUs and/or a lot of CPU cores.An alternative criterion depends on the validity of the purpose of the protest. However HCG drops
Imagine instead the same problem but for a declarative language like SQL.“Harm” can be difficult to characterise. The “harm“ that was caused by Oldfield’s actions was to ruin the day for young men who had trained hard for an iconic race portland optometrist
There may also be a review if the discharge was dishonorable.
Home ownership comes with serious financial responsibilities and
for most, this will be a commitment for as many as thirty years.
The next phase of these calculations are slightly more
complicated but will provide you with general information.
Building such a compiler is probably extremely difficult, if at all possible, perhaps mainly due to the complexity possible to express in C, C++, Python, Java or any normal imperative language. more information here
Imagine instead the same problem but for a declarative language like SQL.It was politically embarrassing for Israelforskolin for weight loss
Imagine instead the same problem but for a declarative language like SQL.Neverthelessspartagen XT
Wow! In the end I got a web site from where I be able to truly take useful
facts concerning my study and knowledge.
Building such a compiler is probably extremely difficult, if at all possible, perhaps mainly due to the complexity possible to express in C, C++, Python, Java or any normal imperative language. Hay Day Hack Tool APK – Diamonds
When thinking about it, the query planner is a bit like a compiler, kind of. It takes the SQL and figures out a smart way to execute it, breaking it down into a lot of sub-tasks, of which some could with benefit be executed in parallel. joint supplement
this is the homepage for free resources of msp game for 2016.
Barbecue beef brisket is the national dish of the Republic of Texas. Here’s the Back Pork Ribs Recipe for how to cook it the way the BBQ champions abd BBQ restaurants cook it. Learn how to grill Brisket steak in best weather now!
Imagine instead the same problem but for a declarative language like SQL. Would it be equally difficult? Core member Bruce Momjian of the PostgreSQL team have already expressed his ideas on how to tackle the problem. jack