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

Add a column store example

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • WT10.0.0, 4.9.0, 4.4.5
    • Affects Version/s: None
    • Component/s: None
    • None
    • 5
    • Storage - Ra 2021-01-25, Storage - Ra 2021-02-08, Storage - Ra 2021-02-22, Storage - Ra 2021-03-08

       

      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

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

            Assignee:
            sean.watt@mongodb.com Sean Watt
            Reporter:
            sulabh.mahajan@mongodb.com Sulabh Mahajan
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: