1 / 7

Assignment 4: solutions by C. Zaniolo

Assignment 4: solutions by C. Zaniolo. UCLA, CS240A Fall 2014. Temporal Curiosity Items. Julian: (365*4+1)/4= 365.250000 Gregorian: (400*365+97)/400= 365.242500 Jalaali: (33*365+8)/33= 365.242424 Actual solar year :  365.242198 …

sevilen-osman
Download Presentation

Assignment 4: solutions by C. Zaniolo

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Assignment 4: solutions by C. Zaniolo UCLA, CS240A Fall 2014

  2. Temporal Curiosity Items • Julian: (365*4+1)/4= 365.250000 • Gregorian: (400*365+97)/400= 365.242500 • Jalaali: (33*365+8)/33= 365.242424 • Actual solar year:  365.242198 … • Is "honey moon" a celestial body or a month and what is origin of the expression?

  3. Blue Moon A blue moon is a second full moon in a single calendar month, which happens every two to three years. The rarity of this astronomical event derives from the length of the lunar cycle, 29.53 days,[1] so most months contain only one full moon. The usage of the term blue moon to describe it results from a misinterpretation of the traditional definition of that term in the March 1946 issue of Sky and Telescope.[2] Due to the rarity of a blue moon, the term "blue moon" is used colloquially to mean a rare event, as in the phrase "once in a blue moon".[3]

  4. Exercises 6.3 from the ADS textbook. Erratum: switch the two columns under Drug and Dosage

  5. Exercise 6.1

  6. The Join using CASE % we will now take the temporal join of the two tables: ! echo temporal join select distinct E.SSN, E.LNAME, E.FNAME, E.Salary, D.DNO, case when E.From < D. From then D.From else E.from END as FFrom, case when E.To > D.To then D.To else E.To END as TTo from HistEmp as E, HistDep as D where E.SSn=D.SSN and E.To >D.From and D.To >E.From SSN LNAME FNAME SALARY DNO FFROM TTO ----------- -------------------- -------------------- ----------- ----------- ---------- ---------- 333445555 Wong Franklin 40000 2 12/08/1955 12/08/1956 333445555 Wong Franklin 40000 3 12/08/1956 12/08/1957 333445555 Wong Franklin 40000 4 12/08/1957 12/08/1958 123456789 Smith John 30000 5 01/09/1965 01/09/1966 123456789 Smith John 40000 5 01/09/1966 01/09/1967 123456789 Smith John 40000 4 01/09/1968 01/09/1969 123456789 Smith John 40000 6 01/09/1969 01/09/1970 123456789 Smith John 45000 6 01/09/1979 01/09/1990 999887777 Zelaya Alicia 25000 2 07/19/1998 07/19/1999 999887777 Zelaya Alicia 26000 2 07/19/1999 07/19/2001 10 record(s) selected.

  7. Coalesce in Datalog ehist(Eno, Sal, Title, From, To) coal(Eno,Title, Fr, To) :- ehist(Eno, Title, Fr, To). coal(Eno,T, Fr, To) :- coal(Eno, T, Fr1, To1), ehist(Eno, T, Fr2, To2) Fr1<= To2, Fr2< To1, smaller(Fr1, Fr2, Fr), larger(To1, To2, To). mxps(Eno,T, Fr, To) :- coal(Eno,T, Fr, To), ~ lgr(Eno,T, Fr, To). lgr(Eno,T, Fr, To) :- coal(Eno,T1, Fr1, To1), Fr1<Fr, To1>=To. lgr(Eno,T, Fr, To) :- coal(Eno,T1, Fr1, To1), Fr1<=Fr, To1>To. larger(X, Y, X) :- X>=Y. smaller(X, Y, Y) :- X<=Y.

More Related