Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-7072

Add a column store example

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: WT10.0.0, 4.9.0, 4.4.5
    • Component/s: None
    • Labels:
      None

      Description

       

      Adding an example that uses column store with weather data and defining a schema to support desired operations (see attachments).

      1. Define attributes in a weather data record - includes day, hour, temperature, humidity, pressure, wind, feels-like temperature, and location (includes latitude, longitude, country).
      2. Populate data records with randomised data.
      3. Write example operations:
        • Op 1: Find average data given a location
        • Op 2: Find max/min temperature data given a time range
        • Op 3: Update temperature from Celsius to Fahrenheit
        • Op 4: Calculate chance of rain given humidity and pressure
        • Op 5: Remove the data for a given country

        Attachments

        1. IMG_20210114_124012.jpg
          426 kB
          Monica Ng
        2. IMG_20210114_124351.jpg
          214 kB
          Monica Ng

          Issue Links

            Activity

              People

              Assignee:
              sean.watt Sean Watt (Inactive)
              Reporter:
              sulabh.mahajan Sulabh Mahajan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: