hzxa21 / peloton Goto Github PK
View Code? Open in Web Editor NEWThis project forked from cmu-db/peloton
The Self-Driving Database Management System
Home Page: http://pelotondb.org
License: Apache License 2.0
This project forked from cmu-db/peloton
The Self-Driving Database Management System
Home Page: http://pelotondb.org
License: Apache License 2.0
Predicate evaluation is done after the projection
Operator
Property
When inserting a tuple with the number of values given smaller than the column count, the database gives an insertion failure and exits.
REFERENCES keyword (and maybe ON DELETE, ON UPDATE) for foreign key does not seem to be supported.
select * from A join B, C
, nested where and nested selectOT - Outer Table
)
EXISTS (SELECT * FROM A1, A2, ... An where [predicates])
[p1, p2, ... pm]
.pi
that has the form Ai.col = OT.col
(without OR), pull it out as the join condition and transform EXISTS into INNER JOIN with DISTINCT in Ai.col
in the right child. If there is not such pi
, keep EXISTS which indicates that it should be done in a nested iteration way.pi
that references the ancestor tables (tables that do not occur in the current level query) and pull them out into the upper level query.OT.col in (SELECT expr FROM A1, A2, ... An where [predicates])
expr
in the right child with join condition OT.col = expr
.[p1, p2, ... pm]
.pi
that references the ancestor tables (tables that do not occur in the current level query) and pull them out into the upper level query.OT.col scalar_op (SELECT expr FROM A1, A2, ... An where [predicates])
OT.col scalar_op expr
. Note that we need to set a flag in the join to indicate that during execution we need to check whether the right child only produce one value for each left tuple.[p1, p2, ... pm]
.pi
that references the ancestor tables (tables that do not occur in the current level query) and pull them out into the upper level query.A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.