<commit_before><!doctype html>
<html>
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <title>SCAPE slides</title>

    <link rel="stylesheet" href="css/reveal.css">
    <link rel="stylesheet" href="css/theme/customtheme.css">

    <!-- Theme used for syntax highlighting of code -->
    <link rel="stylesheet" href="lib/css/zenburn.css">

    <!-- Printing and PDF exports -->
    <script>
      var link = document.createElement( 'link' );
      link.rel = 'stylesheet';
      link.type = 'text/css';
      link.href = window.location.search.match( /print-pdf/gi ) ? 'css/print/pdf.css' : 'css/print/paper.css';
      document.getElementsByTagName( 'head' )[0].appendChild( link );
    </script>
  </head>
  <body>
    <div class="reveal">
      <div class="slides">
        <section data-background-image="img/bg/3.png" data-background-size="contain">
          <h2 id="title"> Cohort Query </h2> <h2 id="title"> Processing </h2>
          <p> Part I: Traditional Cohort Analysis </p>
        </section>
        <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <textarea data-template>
            ## Outline

            - Motivation
            - Cohort analysis
            - SQL-based approaches
            - COHANA: COHort ANAlytics engine
            - Performance analysis
          </textarea>
        </section>
        <section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - User activities
                - High volume
                - High availability
                  - online shopping
                  - mobile applications
                  - health care
                  - ...
            </textarea>
          </section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - Two factors affecting user behavior
                - Aging
                - Social changes
                  - New versions of application
                  - Modification in website layout
            </textarea>
          </section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - Cohort analysis:
                - Access the impact of aging on human behavior in a changing society
                - Perfect for analyzing user behavior
            </textarea>
          </section>
        </section>
        <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <textarea data-template>
            ## Background
              - Birth of users
                - Born upon performing the first birth event
              - Cohort definition
                - A group of users who share common characteristics during the birth
              <aside class="notes" data-markdown>
                ## Birth of Users: 
                - A user is considered born when performing a certain event for the first time.

                ## Cohort definition:
                - A group of users/human who share some common characteristics when they were born.
                - Compute the aggregation for each (cohort, age) group.
              </aside>    
              - Steps
                - Group users into cohorts
                - Determine the age for each activity of each user
                - Compute the aggregation for each (cohort, age) group.
          </textarea>
        </section>
        <section data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <p data-markdown> ## An example </p>
          <div class="left-panel">
            <p data-markdown>
              - Retention analysis<commit_msg>fix bug<commit_after><!doctype html>
<html>
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <title>SCAPE slides</title>

    <link rel="stylesheet" href="css/reveal.css">
    <link rel="stylesheet" href="css/theme/customtheme.css">

    <!-- Theme used for syntax highlighting of code -->
    <link rel="stylesheet" href="lib/css/zenburn.css">

    <!-- Printing and PDF exports -->
    <script>
      var link = document.createElement( 'link' );
      link.rel = 'stylesheet';
      link.type = 'text/css';
      link.href = window.location.search.match( /print-pdf/gi ) ? 'css/print/pdf.css' : 'css/print/paper.css';
      document.getElementsByTagName( 'head' )[0].appendChild( link );
    </script>
  </head>
  <body>
    <div class="reveal">
      <div class="slides">
        <section data-background-image="img/bg/3.png" data-background-size="contain">
          <h2 id="title"> Cohort Query </h2> <h2 id="title"> Processing </h2>
          <p> Part I: Traditional Cohort Analysis </p>
        </section>
        <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <textarea data-template>
            ## Outline

            - Motivation
            - Cohort analysis
            - SQL-based approaches
            - COHANA: COHort ANAlytics engine
            - Performance analysis
          </textarea>
        </section>
        <section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - User activities
                - High volume
                - High availability
                  - online shopping
                  - mobile applications
                  - health care
                  - ...
            </textarea>
          </section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - Two factors affecting user behavior
                - Aging
                - Social changes
                  - New versions of application
                  - Modification in website layout
            </textarea>
          </section>
          <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
            <textarea data-template>
              ## Motivation

              - Cohort analysis:
                - Access the impact of aging on human behavior in a changing society
                - Perfect for analyzing user behavior
            </textarea>
          </section>
        </section>
        <section  data-markdown data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <textarea data-template>
            ## Background
              - Birth of users
                - Born upon performing the first birth event
              - Cohort definition
                - A group of users who share common characteristics during the birth
              - Steps
                - Group users into cohorts
                - Determine the age for each activity of each user
                - Compute the aggregation for each (cohort, age) group.
          </textarea>
        </section>
        <section data-background-image="img/bg/4.png" data-background-size="contain" style="text-align: left;">
          <p data-markdown> ## An example </p>
          <div class="left-panel">
            <p data-markdown>
              - Retention analysis
{'fraction_non_alphanumeric': 0.11496122091568677, 'fraction_numerical': 0.004253189892419315, 'mean_word_length': 1.7455357142857142, 'pattern_counts': {'":': 0, '<': 111, '<?xml version=': 0, '>': 111, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4277010', 'n_tokens_mistral': 2187, 'n_tokens_neox': 2022, 'n_words': 554}