This discussion is archived
14 Replies Latest reply: Aug 14, 2012 1:00 AM by 864015 RSS

General questions about nosql

864015 Newbie
Currently Being Moderated
Could anybody please answers these questions about ORACLE nosql -

1- Does nosql supports Geospatial Indexes ?
2- Does nosql supports Full text search ?
3 - Does nosql supports Large Objects (LOB) ?


Thanks

Edited by: 861012 on Aug 10, 2012 7:26 AM

Edited by: 861012 on Aug 10, 2012 10:50 AM
  • 1. Re: General questions about nosql
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    I suggest see:
    Information Center: NoSQL Database [ID 1393750.2]
    Oracle Premier Support - Oracle Database Support News Archive [ID 1284265.1]
    Master Note for Oracle NoSQL Database [ID 1365314.1]

    Regard
    Helios
  • 2. Re: General questions about nosql
    Carlovski Pro
    Currently Being Moderated
    I think you really need to read up on the basics of what NoSQL actually means - most of these questions are nonsensical!
  • 3. Re: General questions about nosql
    864015 Newbie
    Currently Being Moderated
    Hi Carlovski ,

    I go through the doc and i found most of the answers. But still i have some doubts -

    1 - Does oracle nosql supports LOB ? if not then how to save a word doc in nosql database ?
    2- Does oracle nosql supports Full text search ?
    3- Does nosql supports Geospatial Indexes ?

    Thanks,
  • 4. Re: General questions about nosql
    rp0428 Guru
    Currently Being Moderated
    >
    Could anybody please answers these questions about ORACLE nosql -
    >
    Absolutely! And that person is . . . . .YOU!

    The answer to those questions is in the Oracle documentation and tonight, it is available free of charge.

    See Oracle NoSQL Database, 11g Release 2
    http://docs.oracle.com/cd/NOSQL/html/index.html

    What a deal!
  • 5. Re: General questions about nosql
    Aman.... Oracle ACE
    Currently Being Moderated
    861012 wrote:
    Hi Carlovski ,

    I go through the doc and i found most of the answers. But still i have some doubts -

    1 - Does oracle nosql supports LOB ? if not then how to save a word doc in nosql database ?
    2- Does oracle nosql supports Full text search ?
    3- Does nosql supports Geospatial Indexes ?

    Thanks,
    Hmm did you have a look at the Oracle NoSql's technical overview page?
    http://www.oracle.com/technetwork/products/nosqldb/overview/index.html

    Aman....
  • 6. Re: General questions about nosql
    864015 Newbie
    Currently Being Moderated
    Hi Aman,

    Yes , i go through the given link but still i am looking for answers of these 3 questions.

    1 - Does oracle nosql supports LOB ? if not then how to save a word doc in nosql database ?
    2- Does oracle nosql supports Full text search ?
    3- Does nosql supports Geospatial Indexes like mongodb ?

    Thanks

    Edited by: 861012 on Aug 10, 2012 6:45 PM
  • 7. Re: General questions about nosql
    rp0428 Guru
    Currently Being Moderated
    >
    The answer to those questions is in the Oracle documentation and tonight, it is available free of charge.
    >
    You couldn't have look at the docs in the link provided or you would know the answers to those questions
    >
    Oracle NoSQL Database
    provides multi-terabyte distributed key/value pair storage that offers scalable throughput
    and performance.
    >
    Notice the words 'key/value pair storage'. Do you know what a key/value pair is?
  • 8. Re: General questions about nosql
    864015 Newbie
    Currently Being Moderated
    Hey,

    I really looking forward to get the answers of my doubts. If you know then your welcome otherwise please don't write unnecessary things.
    I know what documents are available on net and what key/value pair is .

    Thanks

    Edited by: 861012 on Aug 10, 2012 10:45 AM

    Edited by: 861012 on Aug 10, 2012 10:51 AM

    Edited by: 861012 on Aug 10, 2012 6:45 PM
  • 9. Re: General questions about nosql
    Justin Cave Oracle ACE
    Currently Being Moderated
    861012 wrote:
    I know what documents are available on net and what key/value pair is .
    If you understand how the NoSQL key-value pairs work, then I'm confused by your questions. From the documentation you have been pointed to
    Values

    The value field is stored as a arbitrary byte array. Oracle NoSQL Database makes no internal assumptions about the structure or the data stored > within the byte array. Mapping of the byte arrays to data structures (serialization and deserialization) is left up to the application. Applications > with very simple data requirements may use values containing simple, fixed record structures. Other applications may use values containing
    complex structures, a set of named properties (name-value pairs) or other types of self-describing data formats.

    There are no restrictions on the size or structure of the value field.
    So, NoSQL doesn't care what you are storing. You can store a Word doc, a PDF, a Geospatial index, a string, or anything else you care to store. Of course, as the documentation states, your application will need to know how to generate and interpret those byte arrays.

    As to your question on full text search, it doesn't really make sense. NoSQL stores data in key-value pairs. It doesn't really make sense to do a full-text search on the keys. And your application has to interpret the byte arrays so there is no way for the database to even know that there is text in a value let alone what that text is or how to search it. Searching by something other than a key also defeats the purpose of using the Oracle NoSQL database.

    Justin

    Edited by: Justin Cave on Aug 10, 2012 1:35 AM
  • 10. Re: General questions about nosql
    955110 Newbie
    Currently Being Moderated
    There are different types of nosql databases e.g. key value pairs, document stores, graph DBs etc. Oracle's nosql offering is a key value store which tend to be very fast but have limited capability in querying i.e. you find the key and thus the matching value. It sounds like you want to query based on the value itself so something like a document database (MongoDB, Couch etc) might be what you want. Mongo supports Geo spatial indexes, LOBs but not full text search.
  • 11. Re: General questions about nosql
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!
    >
    It sounds like you want to query
    >
    You may not have realized it but you are responding to Justin ('in response to: Justin Cave') and not to OP (the original poster).

    I can't speak for Justin but I doubt if he wants to query like this at all.

    When you respond take care to use the 'reply' link for the person you are directing your comments to.
  • 12. Re: General questions about nosql
    rp0428 Guru
    Currently Being Moderated
    >
    I know what documents are available on net and what key/value pair is .
    >
    The key is to actually READ the documents. Knowing they are available is the first step but you only gain knowledge by actually reading.
    >
    1- Does oracle nosql supports LOB ? if not then how to save a word doc in nosql database ?
    2- Does oracle nosql supports Full text search ?
    3- Does nosql supports Geospatial Indexes like mongodb ?
    >
    Did you find any reference in those documents for LOB, 'text search' or 'geospatial'?
  • 13. Re: General questions about nosql
    864015 Newbie
    Currently Being Moderated
    Hi Justin,

    Thanks. Its really helpful.
  • 14. Re: General questions about nosql
    864015 Newbie
    Currently Being Moderated
    Hi All,

    All these options are possible in oracle nosql

    Oracle Nosql DB never operates on the value part of a record.
    Values are simply payload, to be stored with keys and reliably
    delivered back to the application on demand.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points