# XQuery/Chargement de données

* Introduction
* Installation
Exemples basiques
* HelloWorld
* Chargement de données
* Expression FLWOR
* Séquences
* Analyse syntaxique CSV
* Exemples XPath
* Expressions rationnelles
* Searching multiple collections
* Getting URL Parameters
* Getting POST Data
* Checking for Required Parameters
* Displaying Lists
* Extracting data from XHTML files
* Displaying data in HTML Tables
* Limiting Result Sets
* Filtering Words
* Saving and Updating Data
* Quantified Expressions
* Dates and Time
* Chaining Web Forms
Exemples intermédiaires
* Using XQuery Functions
* Creating XQuery Functions
* Returning the Longest String
* Net Working Days
* Tag Cloud
* String Analysis
* Manipulating URIs
* Parsing Query Strings
* Splitting Files
* Filling Portlets
* Filtering Nodes
* Limiting Child Trees
* Higher Order Functions
* Timing Fibonacci algorithms
* Using Intermediate Documents
* Formatting Numbers
* Uploading Files
* TEI Concordance
* Queries on Tables
* Namespace Constructors
Recherche
* Introduction to XML Search
* Basic Search
* Searching,Paging and Sorting
* Keyword Search
* Employee Search
* Incremental Search of the Chemical Elements
* Lucene Search
* Incremental Searching
* Advanced Search
* Open Search
* Auto-generation of Index Config Files
Interaction
* Adder
* Simple XForms Examples
* Navigating Collections
* Envoyer des e-mails

## Vues personnalisées

* HTML Table View
* Tree View
* Grouping Items
Transformation de documents XML complexes
* Transformation Styles
* Typeswitch Transformations
* Transformation idioms
* Generating Skeleton Typeswitch Transformation Modules
* Web XML Viewer
Rapports paginés
* Installing_the_XSL-FO_module
* Generating PDF from XSL-FO files
* XSL-FO Tables
* Converting HTML tables to XSL-FO tables
* XSL-FO Images

## Publication de contenu

* Publishing Overview
* Publishing to Subversion
Comparaison et fusion de XML
* Compare two XML files
* XML Differences
* Compare with XQuery
* Time Comparison with XQuery
* Synchronizing Remote Collections
* Finding Duplicate Documents

## Requêtes basées sur le temps

* Time Based Queries
* Timing a Query
Documents
* TEI Concordance
* TEI Document Timeline
* DocBook to HTML
* DocBook to PDF
* DocBook to ePub
* DocBook to Microsoft Word
* OpenOffice to HTML
* Office Open XML
XML Schemas
* XML Schema to Instance
* XML Schema to XForms
* XML Schema to SVG
* Caractères spéciaux
Liens avec d'autres langages
* Using intermediate MusicXML documents
* MusicXML to Arduino
* XQuery et Python
* XQuery SQL Module
* XQuery depuis SQL
* List OWL Classes
* Excel et XML
* AJAX Navigating Collections
* AJAX Employee Search
* AJAX Incremental Search of the Chemical Elements
* AJAX DOJO data
* XML vers SQL
* Simple RSS reader
* XHTML et Voice
* XQuery et XSLT
* Basic Authentication
* Digest Authentication
* OAuth
* Wikipedia Page scraping
* Wikipedia Lookup
* Wikipedia Events RSS
* Wiki weapons page
* Wikibook index page
* Wikibook list of code links
* Freebase
* Google Docs
Virtualisation
* Graph Visualization
* Graphing from RDF
* Dataflow diagrams
* Sequence Diagrams
* Example Sequencer
Google
* Google Charts
* Google Chart Sparkline
* Google Chart Bullet Bar
* Histogram of File Sizes
Page Scraping
* Overview of Page Scraping Techniques
* Page scraping and Yahoo Weather
* UK shipping forecast
* BBC Weather Forecast
* Page scraping and Mashup
* Simple RSS reader
* Multiple page scraping and Voting behaviour
* Link gathering
* REST interface definition
* Caching and indexes
Mapping
* Google Geocoding
* String Analysis#Location_Mapping
* Flickr GoogleEarth
* Nationalgrid and Google Maps
* SMS tracker

## Timelines

* Creating a Timeline
* Timelines of Resource
* TEI Document Timeline
Web sémantique
* DBpedia with SPARQL - Football teams
* DBpedia with SPARQL and Simile Timeline - Album Chronology
* DBpedia with SPARQL - Stadium locations
* The Emp-Dept case study
** XML to RDF
** SPARQL Tutorial
** SPARQL interface
* Graphing Triples
* SPARQLing Country Calling Codes
* Southampton Pubs
* Alphabet Poster
* Simile Exhibit
* Latent Semantic Indexing
Outils de développent
* Sitemap for Content Management System
* Uptime monitor
* XQuery IDE
* Image Library
* XML Schema to Instance
* Lorum Ipsum text
* XQuery and XML Schema
* Generating XQDocs
* Call Graphs
* System Properties
* Environment Variables
Validation
* Validating a document
* Validation using a Catalog
* Validating a hierarchy
* Validation with Schematron

## Path Analysis

* All Paths
* All Leaf Paths
Securité
* Login and Logout
* URL Driven Authorization
* Digital Signatures
* Changing Permissions on Collections and Resources

## Unit Testing Tools

* XUnit Testing
* XUnit Annotations
Études de cas
* Fizzbuzz
* Project Euler
* Topological Sort
* Slideshow
* Sudoku
* Pachube feed
* World Temperature records
* UWE StudentsOnline
Modules eXistdb
* Installing the XSL-FO module
* Setting HTTP Headers
* Database Utilities
* Get zipped XML file
* Unzipping an Office Open XML docx file
* Installing eXgit
* File Transfer Client
* FTP Client
* Digest Authentication
* UK shipping forecast
* Convert XML to JSON
* Lucene_Search
* Sending E-mail
* Basic Feedback Form
* Using the Math Module
* Using the Memcached Module
* Execute External Process
* Getting URL Parameters
* Getting POST Data
* Checking for Required Parameters
* Manipulating URIs
* Parsing Query Strings
* Adder
* XQuery Batch Jobs
* Sequences Module
* Basic Session Management
* Subversion
* String_Analysis
* Registered Modules
* Registered Functions
* Dynamic Module Loading
* Higher Order Functions
* Timing Fibonacci algorithms
* XMP data
* Basic Authentication
* Validating a document
* Saving_and_Updating_Data
* Splitting_Files
* Generating xqDoc-based XQuery Documentation
* Installing the XSL-FO module
* Generating PDF from XSL-FO files
* XSL-FO Tables
* XSL-FO Images
* XSL-FO SVG
* Using Triggers to Log Events
* Using Triggers to assign identifiers
* Sending E-mail
* Inserting and Updating Attributes
* Updates and Namespaces
* URL Rewriting Basics
* Reindex a Collection
* eXist Replication
* eXist Crib sheet
Annexes
* DataDirect XQuery
* Microsoft SQL Server 2005
* NetKernel
* Oracle Berkeley DB XML
* Stylus Studio
* XQilla
* Gotchas
* Ah-has
* Introduction
* Installation
Exemples basiques
* HelloWorld
* Chargement de données
* Expression FLWOR
* Séquences
* Analyse syntaxique CSV
* Exemples XPath
* Expressions rationnelles
* Searching multiple collections
* Getting URL Parameters
* Getting POST Data
* Checking for Required Parameters
* Displaying Lists
* Extracting data from XHTML files
* Displaying data in HTML Tables
* Limiting Result Sets
* Filtering Words
* Saving and Updating Data
* Quantified Expressions
* Dates and Time
* Chaining Web Forms
Exemples intermédiaires
* Using XQuery Functions
* Creating XQuery Functions
* Returning the Longest String
* Net Working Days
* Tag Cloud
* String Analysis
* Manipulating URIs
* Parsing Query Strings
* Splitting Files
* Filling Portlets
* Filtering Nodes
* Limiting Child Trees
* Higher Order Functions
* Timing Fibonacci algorithms
* Using Intermediate Documents
* Formatting Numbers
* Uploading Files
* TEI Concordance
* Queries on Tables
* Namespace Constructors
Recherche
* Introduction to XML Search
* Basic Search
* Searching,Paging and Sorting
* Keyword Search
* Employee Search
* Incremental Search of the Chemical Elements
* Lucene Search
* Incremental Searching
* Advanced Search
* Open Search
* Auto-generation of Index Config Files
Interaction
* Adder
* Simple XForms Examples
* Navigating Collections
* Envoyer des e-mails

## Vues personnalisées

* HTML Table View
* Tree View
* Grouping Items
Transformation de documents XML complexes
* Transformation Styles
* Typeswitch Transformations
* Transformation idioms
* Generating Skeleton Typeswitch Transformation Modules
* Web XML Viewer
Rapports paginés
* Installing_the_XSL-FO_module
* Generating PDF from XSL-FO files
* XSL-FO Tables
* Converting HTML tables to XSL-FO tables
* XSL-FO Images

## Publication de contenu

* Publishing Overview
* Publishing to Subversion
Comparaison et fusion de XML
* Compare two XML files
* XML Differences
* Compare with XQuery
* Time Comparison with XQuery
* Synchronizing Remote Collections
* Finding Duplicate Documents

## Requêtes basées sur le temps

* Time Based Queries
* Timing a Query
Documents
* TEI Concordance
* TEI Document Timeline
* DocBook to HTML
* DocBook to PDF
* DocBook to ePub
* DocBook to Microsoft Word
* OpenOffice to HTML
* Office Open XML
XML Schemas
* XML Schema to Instance
* XML Schema to XForms
* XML Schema to SVG
* Caractères spéciaux
Liens avec d'autres langages
* Using intermediate MusicXML documents
* MusicXML to Arduino
* XQuery et Python
* XQuery SQL Module
* XQuery depuis SQL
* List OWL Classes
* Excel et XML
* AJAX Navigating Collections
* AJAX Employee Search
* AJAX Incremental Search of the Chemical Elements
* AJAX DOJO data
* XML vers SQL
* Simple RSS reader
* XHTML et Voice
* XQuery et XSLT
* Basic Authentication
* Digest Authentication
* OAuth
* Wikipedia Page scraping
* Wikipedia Lookup
* Wikipedia Events RSS
* Wiki weapons page
* Wikibook index page
* Wikibook list of code links
* Freebase
* Google Docs
Virtualisation
* Graph Visualization
* Graphing from RDF
* Dataflow diagrams
* Sequence Diagrams
* Example Sequencer
Google
* Google Charts
* Google Chart Sparkline
* Google Chart Bullet Bar
* Histogram of File Sizes
Page Scraping
* Overview of Page Scraping Techniques
* Page scraping and Yahoo Weather
* UK shipping forecast
* BBC Weather Forecast
* Page scraping and Mashup
* Simple RSS reader
* Multiple page scraping and Voting behaviour
* Link gathering
* REST interface definition
* Caching and indexes
Mapping
* Google Geocoding
* String Analysis#Location_Mapping
* Flickr GoogleEarth
* Nationalgrid and Google Maps
* SMS tracker

## Timelines

* Creating a Timeline
* Timelines of Resource
* TEI Document Timeline
Web sémantique
* DBpedia with SPARQL - Football teams
* DBpedia with SPARQL and Simile Timeline - Album Chronology
* DBpedia with SPARQL - Stadium locations
* The Emp-Dept case study
** XML to RDF
** SPARQL Tutorial
** SPARQL interface
* Graphing Triples
* SPARQLing Country Calling Codes
* Southampton Pubs
* Alphabet Poster
* Simile Exhibit
* Latent Semantic Indexing
Outils de développent
* Sitemap for Content Management System
* Uptime monitor
* XQuery IDE
* Image Library
* XML Schema to Instance
* Lorum Ipsum text
* XQuery and XML Schema
* Generating XQDocs
* Call Graphs
* System Properties
* Environment Variables
Validation
* Validating a document
* Validation using a Catalog
* Validating a hierarchy
* Validation with Schematron

## Path Analysis

* All Paths
* All Leaf Paths
Securité
* Login and Logout
* URL Driven Authorization
* Digital Signatures
* Changing Permissions on Collections and Resources

## Unit Testing Tools

* XUnit Testing
* XUnit Annotations
Études de cas
* Fizzbuzz
* Project Euler
* Topological Sort
* Slideshow
* Sudoku
* Pachube feed
* World Temperature records
* UWE StudentsOnline
Modules eXistdb
* Installing the XSL-FO module
* Setting HTTP Headers
* Database Utilities
* Get zipped XML file
* Unzipping an Office Open XML docx file
* Installing eXgit
* File Transfer Client
* FTP Client
* Digest Authentication
* UK shipping forecast
* Convert XML to JSON
* Lucene_Search
* Sending E-mail
* Basic Feedback Form
* Using the Math Module
* Using the Memcached Module
* Execute External Process
* Getting URL Parameters
* Getting POST Data
* Checking for Required Parameters
* Manipulating URIs
* Parsing Query Strings
* Adder
* XQuery Batch Jobs
* Sequences Module
* Basic Session Management
* Subversion
* String_Analysis
* Registered Modules
* Registered Functions
* Dynamic Module Loading
* Higher Order Functions
* Timing Fibonacci algorithms
* XMP data
* Basic Authentication
* Validating a document
* Saving_and_Updating_Data
* Splitting_Files
* Generating xqDoc-based XQuery Documentation
* Installing the XSL-FO module
* Generating PDF from XSL-FO files
* XSL-FO Tables
* XSL-FO Images
* XSL-FO SVG
* Using Triggers to Log Events
* Using Triggers to assign identifiers
* Sending E-mail
* Inserting and Updating Attributes
* Updates and Namespaces
* URL Rewriting Basics
* Reindex a Collection
* eXist Replication
* eXist Crib sheet
Annexes
* DataDirect XQuery
* Microsoft SQL Server 2005
* NetKernel
* Oracle Berkeley DB XML
* Stylus Studio
* XQilla
* Gotchas
* Ah-has
[ Modifier le sommaire ]

## Méthodes

Il existe plusieurs méthodes de chargement d'un fichier XML dans une base de données (désérialisation). Leur utilisation dépend du nombre de fichiers à charger, et des règles de chargement.

### Via l'interface HTTP

* Idéal pour un chargement de fichier rapide.

### Via un outil d'IDE comme oXygen

* Faire un clic droit sur une collection et sélectionner "Import file" ou "Import Folders".

### Via le client WebDAV client

* Idéal pour les chargements en masse.
* Permet aussi de déplacer, copier et renommer les collections et fichiers.
* Certains IDE comme oXygen ont aussi un client WebDAV.
Accéder via http://localhost:8080/exist/webdav/db
Liste de clients WebDAV :
* Builtin MAC WebDAV client
* Transmit for the MAC
* Windows WebDAV client
Documentation WebDAV eXist : http://www.exist-db.org/exist/apps/doc/webdav.xml

### Via le client Java

* Le client offre un outil d'ajout de fichiers et de restauration de sauvegarde.

### Par un programme XQuery

* Client HTTP GET pour récupérer ou supprimer un fichier XML et le stocker dans la base.
* Client (S)FTP.

### Via un script Apache Ant

Nombre de bases de données XML possède un jeu de scripts Apache Ant pour faire :
* Chargement de masse.
* Création de collections.
* Définition de permissions.
* Exécution d'une XQuery.
* Backup.
* Restauration.
Ils permettent généralement de filtrer les fichiers à charger.
Un échantillon de chargeur Ant figure sur http://en.wikibooks.org/wiki/Apache_Ant/Store_XML_data
Certains scripts XQuery chargés dans la base des collections peuvent nécessiter des étapes post-installations pour les rendre exécutables par certains utilisateurs.

## Références

* (en) « Documentation eXist sur les uploads »