文件列表:

1.relational-algebra-exericse (0, 2013-03-28)
1.relational-algebra-exericse\q1.ra (93, 2013-03-28)
1.relational-algebra-exericse\q2.ra (144, 2013-03-28)
1.relational-algebra-exericse\q3.ra (143, 2013-03-28)
1.relational-algebra-exericse\q4.ra (237, 2013-03-28)
1.relational-algebra-exericse\q5.ra (136, 2013-03-28)
1.relational-algebra-exericse\q6.ra (405, 2013-03-28)
1.relational-algebra-exericse\q7.ra (564, 2013-03-28)
1.relational-algebra-exericse\q8.ra (476, 2013-03-28)
1.relational-algebra-exericse\q9.ra (477, 2013-03-28)
1.relational-algebra-exericse\sample.db (9216, 2013-03-28)
1.relational-algebra-exericse\sample.properties (26, 2013-03-28)
1.relational-algebra-exericse\sample.ra (4781, 2013-03-28)
2.sql-exercise (0, 2013-03-28)
2.sql-exercise\movie-rating (0, 2013-03-28)
2.sql-exercise\movie-rating\challenging_set.sql (3906, 2013-03-28)
2.sql-exercise\movie-rating\core_set.sql (3367, 2013-03-28)
2.sql-exercise\movie-rating\extra_set.sql (2138, 2013-03-28)
2.sql-exercise\movie-rating\modify_set.sql (1164, 2013-03-28)
2.sql-exercise\movie-rating\movie_rating.db (4096, 2013-03-28)
2.sql-exercise\movie-rating\rating.sql (2142, 2013-03-28)
2.sql-exercise\social-network (0, 2013-03-28)
2.sql-exercise\social-network\challenging_set.sql (2535, 2013-03-28)
2.sql-exercise\social-network\core_set.sql (1788, 2013-03-28)
2.sql-exercise\social-network\extra_set.sql (1341, 2013-03-28)
2.sql-exercise\social-network\modify_set.sql (1012, 2013-03-28)
2.sql-exercise\social-network\social.db (4096, 2013-03-28)
2.sql-exercise\social-network\social.sql (2483, 2013-03-28)
3.xml-exercise (0, 2013-03-28)
3.xml-exercise\countries-xml (0, 2013-03-28)
3.xml-exercise\countries-xml\countries-challenging.xq (8069, 2013-03-28)
3.xml-exercise\countries-xml\countries-core.xq (1553, 2013-03-28)
3.xml-exercise\countries-xml\countries-extra.xq (4884, 2013-03-28)
3.xml-exercise\countries-xml\countries.xml (42438, 2013-03-28)
3.xml-exercise\countries-xslt (0, 2013-03-28)
3.xml-exercise\countries-xslt\challenge-q1.xslt (1207, 2013-03-28)
3.xml-exercise\countries-xslt\challenge-q2.xslt (771, 2013-03-28)
3.xml-exercise\countries-xslt\core-q1.xslt (453, 2013-03-28)
3.xml-exercise\countries-xslt\core-q2.xslt (504, 2013-03-28)
... ...

# DB Class Exercises This includes materials, exercises and solutions used in the [DBclass](https://class2go.stanford.edu/db/Winter2013) offered by Stanford. ## 1.Relational Algebra Exercises This includes exercises for relational algebra. The `utils/bin` folder contains `ra` to run relational algebra easier. It used the [`ra`](http://www.cs.duke.edu/~junyang/ra/) to evaluate relational algebra expressions. ### How to Run - Follow the steps to install `ra`. - Put the executive `ra` to your `$HOME/bin` and **remember to edit the path to find `ra.jar` in your system.** - run `ra` to get the ra REPL to the database environment. - run `ra -i q1.ra` to run particular algebra and see the result. ## 2. SQL Exercises This includes exercises for sql in the classes. The first line in all examples is used by the `dbext` vim plugin to correctly connect to the right database. ### How to Run Option 1, open a sqlite3 console with `sqlite3` and copy and paste the SQL in the console. Option 2, uses the [`dbext`][dbext-link] vim plugin to communicate with the sqlite3 database. Select the sql in visual mode, execute `:DBExecRangeSQL` or press `se`. ## 3. XML Exercises This includes exercises for xml . The `utils/bin` folder contains script to run xquery or xslt easier. The `utils/xquery-helper.vim` contains an util funciton I used to make xquery easier to run inside vim. ## Install Xpath/XSLT Implementations First, install the xpath/xslt implementation on unix system - [saxon](http://www.saxonica.com/). On Mac: brew install saxon Others, follow the instruction on the official site. ### How to Run Xpath/Xquery Use the bin file `utils/bin/xquery` in this repo. It is a simple wrapper around `saxon` to make queries easier to type. **Important**: Each xpath file should only contain one `return` clause, so if you run the xquery manually, you need to **comment out other clauses** to make it run. xquery If you are using `vim` you could use the function I write in vim to run the pieces of code one by one. Just select the code you need to run into a visual block, and press`xe` to run them. More detailed usage: checkout the document on the [official site](http://www.saxonica.com/documentation/using-xsl/commandline.xml) for more details. ### How to Run XSLT Use the bin file `utils/bin/xslt` in this repo. It is a simple wrapper around `saxon` to make queries easier to type. xslt -xsl: For example xslt -xsl:core-q1.xsl courses.xml More detailed usage: checkout the document on the [official site](http://www.saxonica.com/documentation/using-xquery/commandline.xml) for more details. ## 4. Constains and Triggers / 5. Views Same as 3.SQL [dbext-link]: https://github.com/vim-scripts/dbext.vim

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：