14 Replies Latest reply: Aug 14, 2012 3:00 AM by 864015 RSS

    General questions about nosql

    864015
      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
          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
            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
              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
                >
                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....
                  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
                    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
                      >
                      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
                        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
                          JustinCave
                          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
                            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
                              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
                                >
                                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
                                  Hi Justin,

                                  Thanks. Its really helpful.
                                  • 14. Re: General questions about nosql
                                    864015
                                    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.