information repositories are essential. they allow data to be shared within or outside an organization, bringing us closer to the reality of the paperless office.
with the toolset shown in table 1, you can build an enterprise-class, scalable web-enabled repository that fully incorporates various forms of media. document files, photographs, video clips and sound files can easily be included in the repository using java and oracle8is lob (large objects) data types.
in this article im going to focus on how you build a repository to store and search documents such as microsoft word, and html and xml files stored in a lob column of a database table. the example used here populates the repository with microsoft word résumés, indexes it using oracle intermedia and reads it using java streams from a servlet (see figure 1).
benefits of java and oracle8i
building repositories using java and oracle8i has several benefits. the documents inherently take advantage of the transaction management and acid (atomicity, concurrency, integrity and durability) properties of the relational database, which means that changes to an internal lob can be committed or rolled back. moreover, associated applications can seamlessly take advantage of database features such as backup and recovery. this makes things easier for the system administrators, who no longer have to perform separate database and... 下一页