August 19, 2012

In-database analytics — analytic glossary draft entry

This is a draft entry for the DBMS2 analytic glossary. Please comment with any ideas you have for its improvement!

Note: Words and phrases in italics will be linked to other entries when the glossary is complete.

“In-database analytics” is a catch-all term for analytic capabilities, beyond standard SQL, running on the same machine as and under the management of an analytic DBMS. These can run in one or both of two modes:

In-database analytics may offer great performance and scalability advantages versus the alternative of extracting data and having it be processed on a separate server. This is particularly likely to be the case in MPP (Massively Parallel Processing) analytic DBMS environments.

Examples of in-database analytics include:

Other common domains for in-database analytics include sessionization, time series analysis, and relationship analytics.

Notable products offering in-database analytics include:

Comments

8 Responses to “In-database analytics — analytic glossary draft entry”

  1. Analytic platform | DBMS 2 : DataBase Management System Services on August 19th, 2012 3:29 am

    [...] our usage, an “analytic platform” is an analytic DBMS with well-integrated in-database analytics, or a data warehouse appliance that includes one. The term is also sometimes used to refer [...]

  2. Rob Klopp on August 20th, 2012 2:58 pm

    I think that “in-database” means in the database instance.

    It might be worth pointing out that in-database analytics are often deployed as SQL extensions, user-defined functions, stored procedures, etc.

    I also wonder if, for a shared-nothing DBMS, in-database analytics implies a parallel implementation (not a single process controlled by the instance that looks like another tier even though it is in the instance)?

  3. Curt Monash on August 20th, 2012 3:50 pm

    Rob,

    I’ve never sure of what “in the same instance” means, so I’m trying to duck that one.

    I’m also not sure what you mean by your second paragraph, truth be told.

    As for your third paragraph — I’m really happy that it’s here in the comment thread should somebody click back to see it! I also might make that point in a blog post some time, which I’d then link from the definition. But I’m guessing I I won’t put it into the glossary entry itself.

  4. shrikanth shankar on August 24th, 2012 1:59 am

    You seem to have left both Oracle and SQL server out. On the ‘in-process’ side, Oracle offers Java and Pl/SQL as options for table functions (and UDF’s and UDAF’s) since the VM runs in process. SQL Server offers C# (and maybe other languages that compile to the CLR ) though I dont know if they support parallel table functions now. Since the code runs against the VM defects dont crash the DB and there are no security concerns. Performance is better than out of process but not (yet) as good as a native function call.

  5. Curt Monash on August 24th, 2012 2:41 am

    Thanks.

    Timely, too. I’m due next week for my first SQL Server briefing in a very long time.

  6. Uninterrupted DBMS operation — an almost-achievable goal | DBMS 2 : DataBase Management System Services on September 2nd, 2012 7:47 pm

    [...] of in-database analytic processes. If you’re going to do in-database analytics, fenced/out-of-process ones are a lot safer than the [...]

  7. When should analytics be in-memory? | DBMS 2 : DataBase Management System Services on September 26th, 2012 10:02 pm

    [...] rules or guidance regarding “analytical problems, situations, or techniques better suited for in-database versus in-memory processing”. There are actually two kinds of distinction to be [...]

  8. Trends in predictive modeling | DBMS 2 : DataBase Management System Services on September 20th, 2013 8:10 am

    [...] talked with Teradata about a bunch of stuff yesterday, including this week’s announcements in in-database predictive modeling. The specific news was about partnerships with Fuzzy Logix and Revolution Analytics. But what I [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.