Re: [External] : Re: in-memory option - worth it?

I had to laugh at this discussion on product names vs. the use or actual way the tech works as I have this same discussion internally at Microsoft pretty much every week. Every company I've worked for the last 25 years, I have to ponder who in marketing or up higher on the food chain has overruled the creators of the technology to name products they really shouldn't have.

One of my PM battles this week? Someone at Microsoft classified Oracle as an "open source RDBMS". I'll let that settle with y'all for a bit. :)

*Kellyn Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar

On Thu, Apr 15, 2021 at 6:10 PM Andy Rivenes <andy.rivenes_at_oracle.com> wrote:

> I share the same opinion as Mike about the naming, I usually say we should
> have named it the Analytics Database option or the Columnar Database option
> since Database In-Memory targets speeding up analytic query performance and
> not OLTP. People hear in-memory and think it will speed up everything.
>
> Jeff, if you want help or specific questions answered feel free to contact
> me directly.
>
> Yes, I work for Oracle and I am one of the Database In-Memory Product
> Managers.
>
>
> Regards,
>
> Andy Rivenes
>
>
>
> > On Apr 15, 2021, at 5:59 PM, Michael Brown <dba_at_michael-brown.org>
> wrote:
> >
> > In memory is the worst named option that Oracle has put out in my
> opinion. Without knowing what the database is used for, the question of
> should I get it is not really possible to answer.
> >
> > Column Store or Column Store Cache would have been a better name. The
> option will not do much for an OLTP system. OLTP transactions will use the
> same buffer cache they always have, but a table marked for in memory will
> also be maintained organized by columns rather than rows but only in memory
> (hence the name) which means aggregate queries will be vastly improved.
> Read Jonathan’s blog entries that have already been mentioned.
> Blogs.oracle.com also has a blog from the in memory group.
> >
> > --
> > Michael Brown
> >
> >
> >> On Apr 15, 2021, at 12:10 PM, Jeff Chirco <backseatdba_at_gmail.com>
> wrote:
> >>
> >> 
> >> Hey curious if any have the In-Memory option and would it be worth it?
> We are looking to increase our CPU footprint on our server and think about
> maybe trying to squeeze this in if the discount is right. Although this is
> the most expensive option. We are currently a small server, only 4cpu going
> to 8, but we also have a DR server which would stay on a 4cpu server but I
> know it also needs to be licensed.
> >>
> >> What time of systems is it best for? Any good blogs on it?
> >>
> >> Thanks,
> > --
> >
> https://urldefense.com/v3/__http://www.freelists.org/webpage/oracle-l__;!!GqivPVa7Brio!KgPTGtXQoWa3aYLWqGn99bwSZW5Zak6GWTUZBZvF0yF8J0RsFnpKAcRJbVVSozbB1w$
> >
> >
>
>

--
http://www.freelists.org/webpage/oracle-l