Cette bande dessinée didactique a été produite par le Service commun de la Documentation de l'Université de Guyane. Elle s'adresse à un public de doctorants et de chercheurs dans un objectif d'accompagnement à ces nouvelles pratiques scientifiques.
["slug" being an entity attribute]
Spring Data offers an existsBy query method, which we can define in the PostRepository, as follows:
1
2
3
4
5
6
@Repository
public interface PostRepository
extends JpaRepository<Post, Long> {
boolean existsBySlug(String slug);
}
[another] option to emulate existence is using a CASE WHEN EXISTS native SQL query:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
@Repository
public interface PostRepository
extends JpaRepository<Post, Long> {
@Query(value = """
SELECT
CASE WHEN EXISTS (
SELECT 1
FROM post
WHERE slug = :slug
)
THEN 'true'
ELSE 'false'
END
""",
nativeQuery = true
)
boolean existsBySlugWithCase(@Param("slug") String slug);
}
@Repository
public interface PostRepository extends BaseJpaRepository<Post, Long> {
@Query("""
select p
from Post p
where date(p.createdOn) >= :sinceDate
"""
)
@QueryHints(
@QueryHint(name = AvailableHints.HINT_FETCH_SIZE, value = "25")
)
Stream<Post> streamByCreatedOnSince(@Param("sinceDate") LocalDate sinceDate);
}
The FETCH_SIZE JPA query hint is necessary for PostgreSQL and MySQL to instruct the JDBC Driver to prefetch at most 25 records. Otherwise, the PostgreSQL and MySQL JDBC Drivers would prefetch all the query results prior to traversing the underlying ResultSet.
Welcome to the Qualitative Data Sharing (QDS) Toolkit We believe in the benefits of data transparency. We created this toolkit to support qualitative data sharing in an ethical manner.
Abstract. In order to support web applications to understand the content of HTML pages an increasing number of websites have started to annotate structured data within their pages using markup formats such as Microdata, RDFa, Microformats. The annotations are used by Google, Yahoo!, Yandex, Bing and Facebook to enrich search results and to display entity descriptions within their applications. In this paper, we present a series of publicly accessible Microdata, RDFa, Microformats datasets that we have extracted from three large web corpora dating from 2010, 2012 and 2013.
More and more websites have started to embed structured data describing products, people, organizations, places, and events into their HTML pages using markup standards such as Microdata, JSON-LD, RDFa, and Microformats. The Web Data Commons project extracts this data from several billion web pages. So far the project provides 11 different data set releases extracted from the Common Crawls 2010 to 2022. The project provides the extracted data for download and publishes statistics about the deployment of the different formats.
Für viele Forscher und Statistiker gilt Jupyter Notebook als De-facto-Standard, wenn es um schnelles Prototyping und die explorative Datenanalyse geht. Außer auf Notebook wirft der Artikel aber auch einen Blick auf Jupyter Lab, das als nächste Generation von Notebooks in den Startlöchern steht.
C. McElroy, C. Nowlan, J. Drummond, P. Bernath, D. Barton, D. Dufour, C. Midwinter, R. Hall, A. Ogyu, A. Ullberg and 7 other author(s). Applied Optics, 46 (20):
4341-4356(2007)Cited References:
*WORLD MET ORG, 2003, 47 WORLD MET ORG
BERNATH PF, 2005, GEOPHYS RES LETT, V32, ARTN L15S01
BOONE CD, 2005, APPL OPTICS, V44, P7218
BURROWS JP, 1998, J QUANT SPECTROSC RA, V60, P1025
BURROWS JP, 1999, J ATMOS SCI, V56, P151
BURROWS JP, 1999, J QUANT SPECTROSC RA, V61, P509
CARLOTTI M, 1988, APPL OPTICS, V27, P3250
CHAHINE MT, 1970, J ATMOS SCI, V27, P960
DUFOUR DG, 2005, J PHYS CHEM A, V109, P8760, DOI 10.1021/jp052435k
DUFOUR DG, 2006, J PHYS CHEM A, V110, P12414, DOI 10.1021/jp0634306
GILBERT KL, UNPUB J GEOPHYS RES
GREENBLATT GD, 1990, J GEOPHYS RES-ATMOSP, V95, P18577
KAR J, UNPUB J GEOPHYS RES
LUCKE RL, 1999, J GEOPHYS RES-ATMOS, V104, P18785
MCELROY CT, 1995, GEOPHYS RES LETT, V22, P1361
MCELROY CT, 1995, GEOPHYS RES LETT, V22, P1365
NOWLAN CR, 2006, THESIS U TORONTO
ORPHAL J, 2003, J QUANT SPECTROSC RA, V82, P491, DOI
10.1016/S0022-4073(03)00173-0
ROTHMAN LS, 2005, J QUANT SPECTROSC RA, V96, P139, DOI
10.1016/j.jqsrt.2004.10.008
RUSSELL JM, 1993, J GEOPHYS RES-ATMOS, V98, P10777
THOMASON LW, 2003, GEOPHYS RES LETT, V30, ARTN 1631
THUILLIER G, 2004, GEOPH MONOG SERIES, V141, P171, DOI 10.1029/141GM13
WOOD RW, 1935, PHYS REV, V48, P928
McElroy, C. Thomas Nowlan, Caroline R. Drummond, James R. Bernath, Peter F. Barton, David V. Dufour, Denis G. Midwinter, Clive Hall, Robert B. Ogyu, Akira Ullberg, Aaron Wardle, David I. Kar, Jay Zou, Jason Nichitiu, Florian Boone, Chris D. Walker, Kaley A. Rowlands, Neil.
J. Llinas, C. Bowman, G. Rogova, A. Steinberg, and F. White. In P. Svensson and J. Schubert (Eds.), Proceedings of the Seventh International Conference on Information Fusion (FUSION 2004, page 1218--1230. (2004)
A. Sarma, X. Dong, and A. Halevy. SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data, page 861--874. New York, NY, USA, ACM, (2008)