Challanging Question----How do i represent a matrix schema.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Challanging Question----How do i represent a matrix schema.

Hybrid View

  1. #1
    manish jain Guest

    Challanging Question----How do i represent a matrix schema.

    Can anybody suggest me that how do i represent a generic matrix schema.

    For now consider it as 2x2 matrix.

    c1 c2
    r1 100 200
    r2 300 400

    Data is 100,200,300,400.

    it will be better if u can suggest upto any level.ie NxN matrix.

    Thanks in Advance
    Manish.





  2. #2
    Rohit Wason Guest

    Re: Challanging Question----How do i represent a matrix schema.


    Hi Manish
    Long time for me to be out of touch from the forum Guys!
    Not much complex man:
    Two ways:
    1)
    <rows>
    <row>
    <col>100</col>
    <col>150</col>
    <col>300</col>
    ..............
    </row>

    <row>
    <col>150</col>
    <col>250</col>
    <col>230</col>
    ..............
    </row>
    .......
    </rows>
    This way has got the simplicity of having data in a free form - as-it-comes
    basis, but drawback of indexing and addressing - you can't access the M[n,m]th
    element.

    2)
    <cells>
    <cell row="1" col="1">120</cell>
    <cell row="1" col="2">220</cell>
    <cell row="1" col="3">300</cell>
    <cell row="2" col="1">250</cell>
    <cell row="2" col="2">520</cell>
    <cell row="2" col="3">100</cell>
    <cell row="3" col="1">105</cell>
    ...
    ...
    ..
    </cells>
    This has the drawback of storage time (somewhat), but a good addressing and
    indexing capabilities.

    You can have n-number of solutions to it, but don't call them challanging

    Rohit


  3. #3
    Eric Guest

    Re: Challanging Question----How do i represent a matrix schema.


    Hey Rohit,

    I am VERY new to XML, so what I'm about to suggest may be way off, but
    I thought I'd throw something out there for consideration.

    Given the solution you've proposed in your point (2), could that be improved
    upon to represent N-dimensional matrices by replacing the "row" and "col"
    attributes of your <cell> element with this:

    <!ATTLIST cell index NMTOKENS> ??

    (I don't have my XML reference at hand...is that syntax correct? I mean an
    attribute to the cell element named "index" that holds one or more NMTOKEN
    items.)

    You could then represent an N-dimensional matrix using cell elements such
    as:

    <matrix name="demo">
    <cell index="3 7 1 1">...</cell>

  4. #4
    Steve Guest

    Re: Challanging Question----How do i represent a matrix schema.


    Rohit:
    Method one works well for me. You could address the
    individual elements using the element Indexes of a node list
    ie:

    set RowIndex = XMLDoc.SelectNodes("//rows[x]")
    Set ColIndex = RowIndex.SelectNodes("//col[y]")

    Then changing the values of x and y to address the
    M(x,y)th element. Not as simple as iterating through
    a recordset, but still allowing you to directly access
    any given component.

    Steve


    "Rohit Wason" <rohitw@futuresoftindia.com> wrote:
    >
    >Hi Manish
    >Long time for me to be out of touch from the forum Guys!
    >Not much complex man:
    >Two ways:
    >1)
    ><rows>
    > <row>
    > <col>100</col>
    > <col>150</col>
    > <col>300</col>
    > ..............
    > </row>
    >
    > <row>
    > <col>150</col>
    > <col>250</col>
    > <col>230</col>
    > ..............
    > </row>
    > .......
    ></rows>
    >This way has got the simplicity of having data in a free form - as-it-comes
    >basis, but drawback of indexing and addressing - you can't access the M[n,m]th
    >element.
    >
    >2)
    ><cells>
    ><cell row="1" col="1">120</cell>
    ><cell row="1" col="2">220</cell>
    ><cell row="1" col="3">300</cell>
    ><cell row="2" col="1">250</cell>
    ><cell row="2" col="2">520</cell>
    ><cell row="2" col="3">100</cell>
    ><cell row="3" col="1">105</cell>
    >...
    >...
    >..
    ></cells>
    >This has the drawback of storage time (somewhat), but a good addressing

    and
    >indexing capabilities.
    >
    >You can have n-number of solutions to it, but don't call them challanging
    >
    >Rohit
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center