scalability. To
reduce this overhead, we focus on user-centric applications where (1) the data fragment attached to each user
defines the basic access unit, (2) transactions m... o achieve optimal performance, we propose
to move user data to a single node where the transaction can b... ecommendation methods aim to predict, for a given user, the rating or preference she would give to an “i
scalability. To
reduce this overhead, we focus on user-centric applications where (1) the data fragment attached to each user
defines the basic access unit, (2) transactions m... o achieve optimal performance, we propose
to move user data to a single node where the transaction can b... ecommendation methods aim to predict, for a given user, the rating or preference she would give to an “i
rmat A20
select table_name, blocks, num_rows from user_tables;
</code>
Afficher le coût d'une lecture s... _01/server.102/b14237/statviews_1069.htm#i1578369|user_indexes]]
<code sql>
set autotrace off
sele... dex_name, blevel, distinct_keys, leaf_blocks from user_indexes;
</code>
Description d'une table : cardi... 1/server.102/b14237/statviews_2105.htm#REFRN20286|user_tables]]
<code sql>
set autotrace off
sel
ns la barre). J'ai créé une base par défaut jdbc (user: jdbc, password: jdbc) qui est inclus dans le fic... wif>
Il existe déjà une base par défaut H2/jdbc (user: jdbc, password: jdbc).
Pour charger les données,... ar org.h2.tools.RunScript -url jdbc:h2:./H2/jdbc -user jdbc -password jdbc -script creations.sql
java -c... ar org.h2.tools.RunScript -url jdbc:h2:./H2/jdbc -user jdbc -password jdbc -script insertions.sql
</code
ns la barre). J'ai créé une base par défaut jdbc (user: jdbc, password: jdbc) qui est inclus dans le fic... wif>
Il existe déjà une base par défaut H2/jdbc (user: jdbc, password: jdbc).
Pour charger les données,... ar org.h2.tools.RunScript -url jdbc:h2:./H2/jdbc -user jdbc -password jdbc -script creations.sql
java -c... ar org.h2.tools.RunScript -url jdbc:h2:./H2/jdbc -user jdbc -password jdbc -script insertions.sql
</code
_01/server.102/b14237/statviews_1069.htm#i1578369|user_indexes]]
<code sql>
select index_name as no... b_valeurs, leaf_blocks as pages_de_Rowids
from user_indexes;
</code>
Description d'une table : cardi... 1/server.102/b14237/statviews_2105.htm#REFRN20286|user_tables]]
<code sql>
column nom format A20
... rows as cardinalite, blocks as nb_pages
from user_tables;
select table_name as nom, num_ro
_01/server.102/b14237/statviews_1069.htm#i1578369|user_indexes]]
<code sql>
select index_name as no... b_valeurs, leaf_blocks as pages_de_Rowids
from user_indexes;
</code>
Description d'une table : cardi... 1/server.102/b14237/statviews_2105.htm#REFRN20286|user_tables]]
<code sql>
column nom format A20
... rows as cardinalite, blocks as nb_pages
from user_tables;
select table_name as nom, num_ro
* Que représentent les vues du dictionnaire user_tables, user_objects et user_source ? Expliquer brièvement ce que représente chaque attribut. Voir la documentation:... 2/server.102/b14237/statviews_4471.htm#REFRN26286|user_tables]] (cf. [[http://www-ari.ufr-info-p6.jussie
dans un terminal la commande suivante ''sqlplus <user>/<user>@ora11''
où <user> est la lettre **E** en **majuscule**, suivie de votre **login numérique à 7 chiffre... cas, (**ET UNIQUEMENT APRES AVOIR TESTÉ sqlplus <user>/<user>@ora11 comme indiqué ci-dessus!!**) demand
rmating the dataset
val triples0 = sc.textFile(s"/user/olivier/${folderName}/${fileName}_encoded_unique"... ntTimeMillis();
val quads_I_SPO = sc.textFile(s"/user/olivier/${folderName}/${fileName}").coalesce(part... les (see Datasets excerpts)
*/
val inputData = s"/user/olivier/${folderName}/${fileName}_encoded_unique_... .currentTimeMillis();
val quads = sc.textFile(s"/user/olivier/${folderName}/${fileName}").map(x=>x.spli
val jointureParDiffusion = RATINGSRDD.map{ case( user, N) => (user, N, UsersDiffusion.value(user)) }
jointureParDiffusion.count
</code>
Vérifier dans le navigateur que l... 18Diffusion.value.get(numU) match {
case Some(user) => Seq((numU,note,user))
case None => Seq()
rmating the dataset
val triples0 = sc.textFile(s"/user/olivier/${folderName}/${fileName}_encoded_unique"... ntTimeMillis();
val quads_I_SPO = sc.textFile(s"/user/olivier/${folderName}/${fileName}").coalesce(part... les (see Datasets excerpts)
*/
val inputData = s"/user/olivier/${folderName}/${fileName}_encoded_unique_... .currentTimeMillis();
val quads = sc.textFile(s"/user/olivier/${folderName}/${fileName}").map(x=>x.spli
ste des paramètres) |
|'''Qui suis-je ?''' |show user \\ ou \\ select username from v$session where si... e compilation ? |show err \\ ou \\ select * from user_errors; |
|Comment afficher le nom de tous les ob... u \\ select object_name, object_type, status from user_objects order by object_name; |
|Comment afficher... e_source('nom_fonction')); \\ ou \\ select * from user_source where name = 'nom_fonction' order by type,