| commit | 611d8ae874ffdbd3e972625495f6d83387c6569b | [log] [tgz] |
|---|---|---|
| author | Ian Maxon <ian@maxons.email> | Thu Jan 26 12:34:10 2023 -0800 |
| committer | Michael Blow <mblow@apache.org> | Sun Jan 29 20:26:14 2023 +0000 |
| tree | 7fa946d9f2c78138f62f2e039a81c2eeaccd4405 | |
| parent | f88ee76e089bc9f04edf8b2e0e7be63bfe80b0ca [diff] |
[ASTERIXDB-3046][COMP] Support cost based query optimization. - user model changes: yes - storage format changes: no - interface changes: yes added: ICost, ICostMethods modified: IAccessMethod Details: Cost based query optimization enables the optimizer to compute the optimal plan for a query. - Add new rule EnumerateJoinsRule to run the CBO logic. - Add new rule AnnotateOperatorCostCardinalityRule to annotate operators with cardinalities and costs. - Add 3 compiler properties to control CBO: compiler.cbo, compiler.forcejoinorder, compiler.queryplanshape - Add 3 hints: hashjoin, selectivity, productivity. - Add new operator annotations: INPUT_CARDINALITY, OUTPUT_CARDINALITY, TOTAL_COST, OP_COST LEFT_EXCHANGE_COST, RIGHT_EXCHANGE_COST - Make tests run in CBO test mode. Backport changes: - Compensate for not having batch lookup change in this branch Change-Id: I848adf6a8fdcfea360655ab649de2fb75a73c814 Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17143 Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu> Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com> Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17329 Reviewed-by: Michael Blow <mblow@apache.org> Tested-by: Michael Blow <mblow@apache.org>
AsterixDB is a BDMS (Big Data Management System) with a rich feature set that sets it apart from other Big Data platforms. Its feature set makes it well-suited to modern needs such as web data warehousing and social data storage and analysis. AsterixDB has:
Data model
A semistructured NoSQL style data model (ADM) resulting from extending JSON with object database ideas
Query languages
An expressive and declarative query language (SQL++ that supports a broad range of queries and analysis over semistructured data
Scalability
A parallel runtime query execution engine, Apache Hyracks, that has been scale-tested on up to 1000+ cores and 500+ disks
Native storage
Partitioned LSM-based data storage and indexing to support efficient ingestion and management of semistructured data
External storage
Support for query access to externally stored data (e.g., data in HDFS) as well as to data stored natively by AsterixDB
Data types
A rich set of primitive data types, including spatial and temporal data in addition to integer, floating point, and textual data
Indexing
Secondary indexing options that include B+ trees, R trees, and inverted keyword (exact and fuzzy) index types
Transactions
Basic transactional (concurrency and recovery) capabilities akin to those of a NoSQL store
Learn more about AsterixDB at its website.
To build AsterixDB from source, you should have a platform with the following:
Instructions for building the master:
Checkout AsterixDB master:
$git clone https://github.com/apache/asterixdb.git
Build AsterixDB master:
$cd asterixdb $mvn clean package -DskipTests
Here are steps to get AsterixDB running on your local machine:
Start a single-machine AsterixDB instance:
$cd asterixdb/asterix-server/target/asterix-server-*-binary-assembly/apache-asterixdb-*-SNAPSHOT $./opt/local/bin/start-sample-cluster.sh
Good to go and run queries in your browser at:
http://localhost:19006
Read more documentation to learn the data model, query language, and how to create a cluster instance.
To generate the documentation, run asterix-doc with the generate.rr profile in maven, e.g mvn -Pgenerate.rr ... Be sure to run mvn package beforehand or run mvn site in asterix-lang-sqlpp to generate some resources that are used in the documentation that are generated directly from the grammar.