XML (Extensible Markup Language) is a general-purpose specification for creating custom markup languages. It is classified as an extensible language, because it allows the user to define the mark-up elements. XML's purpose is to aid information systems in sharing structured data.
System.XML, System.XML.XPath and System.XML.Schema namespace will be used to manipulate XML node, element, attribute and value in a XML file within .Net application.
Advantages
- It is completely Proprietary database.
- Data will be stored in XML file which is easy to manipulate in ADO.Net
- Image will be stored in file system which will give better access speed.
- Multiple images can be stored in single file and system can read individual image from one file.
- Individual image can be stored in single image folder and can read from that folder.
- Data and Image can be encrypted by any industry standard encryption algorithm like DES, AES, 3 DES.
- System will query the by using XQuery.
- Complete manage code written in .NET 2.0.
- Easy to integrate in .NET application.
1. Database Designing
Database details will be stored in XML file, like image folder or image storing file name, location.
Table definition will be stored in XML schema file having .xsd extension. With standard XML data type and precision, A "Valid" XML document is a "Well Formed" XML document, which also conforms to the rules of a XML file.
veh_data.xsd
<xs:complexType>
<xs:sequence>
<xs:element name="vd_id" type="xs:integer" use="required" />
<xs:element name="vd_loan" type="xs:string" use="required" length="16" />
<xs:element name="vd_loc" type="xs:string" use="required" />
<xs:element name="vd_date" type="xs:date" use="required" />
<xs:element name="vd_img_name" type="xs:string" use="required" />
<xs:element name="vd_img_type" type="xs:string" use="required" />
xs:sequence>
xs:complexType>
xs:element>
schema>
Data will be stored in xml file, data integrity and constraint will be maintain by XML schema file
<include xmlns="veh_data.xsd" />
<veh_data>
<vd_id>Tovevd_id>
<vd_loan>VDPU00000011vd_loan>
<vd_loc>Mumbaivd_loc>
<vd_date>10-Jan-2009vd_date>
<vd_img_name>VDPU00000011.jpgvd_img_name>
<vd_img_type>jpgvd_img_type>
>
<veh_data>
. . .
. . .
>
<veh_data>
. . .
. . .
>
<veh_data>
. . .
. . .
>
<veh_data>
. . .
. . .
>
4.1 Store multiple images in a single imagebase file
4.2 Store images in folder
Query the Data
XDb will use XQuery to query the data from XML file. XQuery is the language for querying XML data. XQuery is a language for finding and extracting elements and attributes from XML documents. XQuery provides the means to extract and manipulate data from XML documents.
XQuery uses XPath expression syntax to address specific parts of an XML document. It supplements this with a SQL-like "FLWOR expression" for performing joins. A FLWOR expression is constructed from the five clauses after which it is named: FOR, LET, WHERE, ORDER BY, RETURN. The language is based on a tree-structured model of the information content of an XML document, containing seven kinds of node: document nodes, elements, attributes, text nodes, comments, processing instructions, and namespaces.
Out of Scope
Following are the out of scope for current version of XDb 1.0, will be work upon on next version.
- Data Compression
- Store image file in different drive for single file concept.
- DB Interface for creating, altering and managing data base.
No comments:
Post a Comment