Database Management Toolkit for Efficient Collections and Documents Handling

1. Xindice command

2. collections • List collections: xindice lc –c /db/… • Add collections: xindiceadmin ac –c /db/... –n collection_name • Delete collection: xindiceadmin dc –c /db/collection_name

3. exercise • Create collections: /db/data/products/flowers, /db/data/products/clothes, /db/data/products/electronics. • Create collections: /db/data/customers/vip, /db/data/customers/regular, /db/data/customers/potential.

4. documents • List documents: xindice ld –c /db/… • Add documet: xindice ad –c /db/.. –f file –n key • Retrieve document: xindice rd –c /db/.. –n key or xindice rd –c /db/.. –n key –f filename • Delete document: xindice dd –c /db.. –n key

5. documents • Add all files on a directory: xindice ad –c /db/…. -f directory • Add all files on a directory with an extension of “.xml”: xindice ad –c /db/… -f directory –e xml

6. Import & export • Import a directory structure: xindiceadmin import -c /db/… -f directory (-e extension) • Export a collection to a directory: xindice export –c /db/… -f directory