ABSTRACT

Computerized data minimization and storage using xml enable sql server is Database information system used by the institution to record and supervises all the student records undergoing their Youth Service experience. It is a powerful tool in the career department of the Institution. XML is here as the internet standard for information exchange among e-businesses and applications. With its dramatic adoption and its ability to model structured, unstructured and semi-structured data, XML has the potential of becoming the data model for internet data. In the recent years, Oracle has evolve its DBMS to support complex, structured, and unstructured data. Oracle has now extended that technology to enable the storage and querying XML data by evolving its DBMS to an XML enabled DBMS – Oracles has now extended that technology to enable the storage and querying of XML data by evolving its DBMS to an XML enabled DBMS – Oracle.In this, paper we will present Oracles’ XML – enabling database technology. In particular, we will discuss how XML data can be stored, managed, and queried in the Oracle8i database.

TABLE OF CONTENTS

Title page

Certification

Approval

Dedication

Acknowledgement

Abstract

Table of contents

CHAPTER ONE

1.0      Introduction

1.1      Statement of Problem

1.2      Purpose of study

1.3      Aims and objectives

1.4      Scope/Delimitations

1.5      Limitations/ Constraints

1.6      Definition of Terms

CHAPTER TWO

2.0      Literature review

CHAPTER THREE

3.0      Methods of fact finding and detailed discussions of the subject matter

3.1      Methodologies for fact-finding

3.2      Discussions

CHAPTER FOUR

4.0      Futures, impactions and challenges of the subject matter for the society.

4.1      Futures

4.2      Implications

4.3      Challenges

CHAPTER FIVE

5.0      Summary, Recommendation and conclusion

5.1      Summary

5.2      Recommendation

5.3      Conclusion

References

CHAPTER ONE

1.0     INTRODUCTION

Increasingly, developers don’t have a choice between relational and XML data. Each has its strengths and each has its place. Reports and business intelligence applications work primarily with relational data, but vendors and customers need data in XML. And both kinds of data are increasingly integrated: change requests refer to customer email; trouble-tickets reference white papers. SQL Server 2005 can help you manage all these different kinds of data under a single platform. Even without any built-in support for XML, a database system typically offers more robust management functionality than a file system. Features such as security, backup, and mirroring make the database a good home for documents.

But XML isn’t completely new to the Microsoft database world: SQL Server 2000 shipped with some XML functionality, and SQLXML continues to improve client-side functionality. But most of the XML support in that version has to do with mapping between relational and markup data. The OPENXML keyword is used to shred documents into a tabular format for storage. And the FOR XML clause can be used to publish relational data as XML on demand.

It’s a nice piece of indirection: Developer don’t (necessarily) have to learn database libraries and DBAs don’t have to worry (too much) about the intricacies of XML. But the indirection is only one-way: SQL Server 2000 offers very little in the way of native XML support. You can store your document in string, but you can’t index it, or shred it on the fly – not without a lot custom development Maintaining a data storage environment that is both dependable and cost-effective has become a major challenges for law firms and corporations of all sizes.

For over three years, Inventus has been providing data storage and numerous other data center services within a very successful outsourced model. Both law firms and corporations have taken advantage of the robust infrastructure Inventus has assembled over the years to either enhance, or even replace their own in-house offering. In addition to data storage, other services include: back-up, de-duplication, business continuity, and disaster recovery. These services can be provided in conjunction with a best practices e-discovery strategy, or simply to alleviate the burden of one of the many IT challenges every faces today.

1.1     STATEMENT OF PROBLEM

Owing to:

i)            The difficulties people face in keeping individual information/data

ii)          Inadequate supervision of youth service individuals

iii)        Difficulties people encountered when searching for given youth service information.

iv)         Problem individual encountered in knowing their deployment area.

v)           Time wasted in searching for individual information on packed files.

vi)         Time wasted in sorting youth service files.

1.2     PURPOSE OF STUDY

The sole purpose of this study is to put to an end the difficulties encountered in storing data and