<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic MS SQL server vs. Oracle (in ArcSDE) in Data Management Questions</title>
    <link>https://community.esri.com/t5/data-management-questions/ms-sql-server-vs-oracle-in-arcsde/m-p/496258#M28176</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi everyone,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am going to start using ArcSDE. But as I am totally new, I'd be really grateful to you if you please be kind enough to answer the following questions-&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1. Which one is more user friendly for the beginners (MS SQL server, Oracle, or which one)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2. Technology often changes too rapidly. I should start using which I should be able to use for a long time (1. ESRI should keep supporting the product for at least next ten years. 2. the product should be supported by its mother organization Microsoft and Oracle etc.)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;3. What is the data storage capacity of MS SQL server and Oracle. Which one is better in spatial indexing? why?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;4. What sort of programming capability shall I need? I am planning to start learning Python.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'll be anxiously waiting to hear from you.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks and regards,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Saiful&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 09 Oct 2013 03:26:19 GMT</pubDate>
    <dc:creator>KaziSaiful_Islam</dc:creator>
    <dc:date>2013-10-09T03:26:19Z</dc:date>
    <item>
      <title>MS SQL server vs. Oracle (in ArcSDE)</title>
      <link>https://community.esri.com/t5/data-management-questions/ms-sql-server-vs-oracle-in-arcsde/m-p/496258#M28176</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi everyone,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am going to start using ArcSDE. But as I am totally new, I'd be really grateful to you if you please be kind enough to answer the following questions-&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1. Which one is more user friendly for the beginners (MS SQL server, Oracle, or which one)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2. Technology often changes too rapidly. I should start using which I should be able to use for a long time (1. ESRI should keep supporting the product for at least next ten years. 2. the product should be supported by its mother organization Microsoft and Oracle etc.)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;3. What is the data storage capacity of MS SQL server and Oracle. Which one is better in spatial indexing? why?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;4. What sort of programming capability shall I need? I am planning to start learning Python.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'll be anxiously waiting to hear from you.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks and regards,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Saiful&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Oct 2013 03:26:19 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/ms-sql-server-vs-oracle-in-arcsde/m-p/496258#M28176</guid>
      <dc:creator>KaziSaiful_Islam</dc:creator>
      <dc:date>2013-10-09T03:26:19Z</dc:date>
    </item>
    <item>
      <title>Re: MS SQL server vs. Oracle (in ArcSDE)</title>
      <link>https://community.esri.com/t5/data-management-questions/ms-sql-server-vs-oracle-in-arcsde/m-p/496259#M28177</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I don't see a single part in your multi-part question which is answerable with&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;with a non-subjective response.&lt;/SPAN&gt;&lt;BR /&gt;&lt;OL&gt;&lt;BR /&gt;&lt;LI&gt; I don't see any subjective difference between the five major SQL engines&lt;/LI&gt;&lt;BR /&gt; supported by Esri, and the no-SQL databases seem to be more of the same.&lt;BR /&gt;In the course of a 25 year career as a DBA, RDBMS selection has always been&lt;BR /&gt;a religious issue, not a technical one.&lt;BR /&gt;&lt;LI&gt; Requiring vendors to remain at an identical technology for ten years is an&lt;/LI&gt;&lt;BR /&gt; amazing goal -- I can't think of any component in the software stack that's&lt;BR /&gt; remained supported that long, much less in combination.&lt;BR /&gt;&lt;LI&gt; Modern RDBMS software has the capability to address more data than currently&lt;/LI&gt;&lt;BR /&gt; exists, and each of them has several possible flavors of spatial indexing, each&lt;BR /&gt; of which has both strengths and weaknesses.&lt;BR /&gt;&lt;LI&gt; It's generally accepted that all programmers must master as many languages&lt;/LI&gt;&lt;BR /&gt; as possible across the categories of OS scripting languages, compiled languages,&lt;BR /&gt; OO bytecode languages, SQL dialects, and web scripting frameworks.&amp;nbsp; Python is &lt;BR /&gt; an excellent language but it only resides in one of those categories; you'd need &lt;BR /&gt; to augment it with bash, 'C', PL/SQL, and JavaScript for starters. &lt;BR /&gt;&lt;/OL&gt;&lt;SPAN&gt;- V&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Oct 2013 05:04:57 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/ms-sql-server-vs-oracle-in-arcsde/m-p/496259#M28177</guid>
      <dc:creator>VinceAngelo</dc:creator>
      <dc:date>2013-10-09T05:04:57Z</dc:date>
    </item>
  </channel>
</rss>

