) CREATE INDEX idx_book_id ON person_book USING btree (book_id); Then, the data was imported into the table. The following command works when database actually runs on the machine the data file is located on (or something like this... Sure as hell the processing engine couldn't get to the file when database with the table was located on a ttu server and the data.txt file on my PC). COPY person_book(person_id, book_id) FROM 'C:data.txt' DELIMITERS ',' CSV HEADER; Task 1: In order to determine the number of people who have purchased both book X and book Y a function has been written in PLPGSQL. The SELECT sentence in the given function operates the following way 1) it selects all IDs of people who have purchased book Y 2) it performs inner join of IDs selected in the first step with selection of IDs of people who have purchased book X 3) it counts the number of distinct IDs in the resulting set, thusly solving the problem
Tulemus suunatakse faili koik.inimesed, kus on kolm tulpa eraldatud sobiva arvu tühikutega nimi | vanus | elukoht ------+-------+--------- Mart | 16 | Narva Priit | 17 | Tallinn Laa | 12 | Kuressaare Leida | 18 | Elva Maie | 45 | Pulva Vdino | 39 | Haapsalu Soovides näha taas väljundit terminalil, andke korraldus 'o' zoo=> o Soovides koopeerida andmebaasi sisu ning määrata andmevälja eraldaja, andke käsk zoo=> COPY inimesed TO stdout USING DELIMITERS ','; Kasutajale ei ole ette nähtud teha failioperatsioone ning seega peab anmed faili suuname läbi väljundi (stdout) kasutades käsku 'o'. Postgresi koormuse testimine Toimub käsuga # pgbench -i -s 100 test või # pgbench -c 16 -t 1000 test MS Access Microsoft Access on Microsofti poolt loodud ja Microsoft Office'i kontoritarkvara paketti kuuluv andmebaaside tarkvara. Microsoft Access 2010 märksõna on lihtsus: kasutusvalmis mallid kiirendavad tööd
Has 2 address fields (source & destination) for multiaccess · Disable or select authentication stage (PAP, CHAP, EAP) stuffing (for bit-oriented protocols). >Bit oriented synchronous transmission: preferred scheme · transparent to either Lacks framing delimiters and CRC · Line quality monitoring during normal operation (the > Byte stuffing (STX, ETX, DLE) Transmit side: insert DLE before control characters 1. transmit printable characters or binary data · 3 general schemes that vary on how SOF, EOF · Byte oriented (bit orientation is rarely useful, and MAC ability to verify whether the line has a good enough quality start of frame send DLE STX 2
annaabi.ee 
