Hi folks, Below is the epic and stories I worked through with Adrian, we can discuss this a bit more on the call and go over them.
Epic: A subsystem is needed to track the history of the A&AI real-time database at an attribute/entity level for every resource (nodes & edges). The following is what would need to be tracked for the attribute value and entity assertions * source of change (provenance) * timestamp of when the change (add/update/delete) was made in the database * timestamp of when the change (add/update/delete) was made in the network (client can optionally send) The client will need a streamlined way to access this history via URIs and a GUI. For Casablanca only singular entity history queries will be supported showing the state of the entity at a given time. The design needs to be extensible enough to easily support history queries over a range of time, retrieving complicated topology history, traversal mS endpoints (custom query/dsl), and aggregations post Casablanca. Any data populated in A&AI before this feature was implemented, would not have historical information. If the results have a subset of attributes that did not exist in the range of the data requested, A&AI will display the partial history available Data retention limits will be enforced on the historical database to truncate history, this data retention timeframe will be configurable Performance & Response times: TBD Stories: * Create the A&AI history subsystem framework * Develop functionality for the history subsystem to handle storing the historical data within the database layer, recording the database entry time as a meta property on a value/entity update along with the source of the update * Develop functionality for the history subsystem to handle storing the network sequence time as a meta property on a value/entity update (if the network sequence timestamp was passed in), also store the source of the update * Develop functionality for the history subsystem to retrieve the state of an entity at a given database timestamp * Develop functionality for the history subsystem to retrieve the state of an entity at a given network sequence timestamp * Develop functionality for the history subsystem to truncate history data after a configurable range of time * Update the existing A&AI GUI to include functionality to query historical data for an entity at a particular point in time * Ensure the history subsystem is properly updating the logs per ONAP guidelines * Stretch Goal: Develop functionality to archive historical data when truncating data after the configurable timeframe has been reached Thanks, William Reehil Active and Available Inventory D2 PLATFORM & SYSTEMS DEVELOPMENT - Principal Member of Technical Staff AT&T Services Middletown, NJ O: (732) 420-7806 | C: (732) 865-5333 -----Original Appointment----- From: AGGARWAL, MANISHA On Behalf Of ONAP Meetings and Events Sent: Wednesday, March 28, 2018 9:25 AM To: ONAP Meetings and Events; MULLER, ANDREW; NAIK, SOUMYA; FORSYTH, JAMES; MAHARAJH, ROBBY; onap-discuss@lists.onap.org; REEHIL, WILLIAM E Subject: FW: [onap-discuss] Invitation: [aai] Historical Data Tracking @ Weekly from 7am to 8am on Wednesday from Wed Mar 28 to Wed Mar 6, 2019 (PDT) (onap-discuss@lists.onap.org) When: Wednesday, March 28, 2018 10:00 AM-11:00 AM America/New_York. Where: https://zoom.us/j/851671845 Just in case you are not subscribed to the onap-discuss calendar. Manisha -----Original Appointment----- From: ONAP Meetings and Events [mailto:linuxfoundation.org_1rmtb5tpr3uc8f76fmflplo...@group.calendar.google.com] Sent: Thursday, March 22, 2018 8:27 PM To: ONAP Meetings and Events; FORSYTH, JAMES; onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> Subject: [onap-discuss] Invitation: [aai] Historical Data Tracking @ Weekly from 7am to 8am on Wednesday from Wed Mar 28 to Wed Mar 6, 2019 (PDT) (onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org>) When: Occurs every Wednesday effective 3/28/2018 until 3/6/2019 from 10:00 AM to 11:00 AM America/New_York. Where: https://zoom.us/j/851671845 more details ><https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_event-3Faction-3DVIEW-26eid-3DdGdlMWk1N2ZrcWljcDM1MW9ma2swbWpyajAgb25hcC1kaXNjdXNzQGxpc3RzLm9uYXAub3Jn-26tok-3DNzIjbGludXhmb3VuZGF0aW9uLm9yZ18xcm10YjV0cHIzdWM4Zjc2Zm1mbHBsb2k4OEBncm91cC5jYWxlbmRhci5nb29nbGUuY29tYWI3NTM2NDQ5NGUxMDZmYmM0NDM3YWZkMzMzYTFkZDlhMThiMzgzMQ-26ctz-3DAmerica-252FLos-5FAngeles-26hl-3Den-26es-3D0&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=LI3VT7ynSDnszYqJKwuIpYNKNR5ox78MdgS8nIV201c&e=> [aai] Historical Data Tracking When Weekly from 7am to 8am on Wednesday from Wed Mar 28 to Wed Mar 6, 2019 Pacific Time Where https://zoom.us/j/851671845<https://urldefense.proofpoint.com/v2/url?u=https-3A__zoom.us_j_851671845&d=DwQFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=tmbDxl3z5ALqMcH-Ob1SRG5NWaMdDOIF2S8rJ3pyRb4&e=> (map<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_url-3Fq-3Dhttps-253A-252F-252Fzoom.us-252Fj-252F851671845-26sa-3DD-26usd-3D2-26usg-3DAFQjCNEyZUfLXVfGQ-5FaCe-2DzF03gTutBYSA&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=PF68yMxUs9D4shNA-vkT6HaHUueGHJQ0AzplPYZOt-c&e=>) Calendar onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> Who * kp...@linuxfoundation.org<mailto:kp...@linuxfoundation.org> - creator * jf2...@att.com<mailto:jf2...@att.com> * onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> Hi there, ONAP Meeting 10 is inviting you to a scheduled Zoom meeting. Join from PC, Mac, Linux, iOS or Android: https://zoom.us/j/851671845<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_url-3Fq-3Dhttps-253A-252F-252Fzoom.us-252Fj-252F851671845-26sa-3DD-26usd-3D2-26usg-3DAFQjCNEyZUfLXVfGQ-5FaCe-2DzF03gTutBYSA&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=PF68yMxUs9D4shNA-vkT6HaHUueGHJQ0AzplPYZOt-c&e=> Or iPhone one-tap : US: +16699006833,,851671845# or +16465588656,,851671845# Or Telephone: Dial(for higher quality, dial a number based on your current location): US: +1 669 900 6833 or +1 646 558 8656 or +1 877 369 0926 (Toll Free) or +1 855 880 1246 (Toll Free) Meeting ID: 851 671 845 International numbers available: https://zoom.us/zoomconference?m=6DMT8ODjPDZ_tABdAn2HCi0b1KnSta53<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_url-3Fq-3Dhttps-253A-252F-252Fzoom.us-252Fzoomconference-253Fm-253D6DMT8ODjPDZ-5FtABdAn2HCi0b1KnSta53-26sa-3DD-26usd-3D2-26usg-3DAFQjCNEXeg-5Fv6oUs5tFVNPFfprXPfrphxQ&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=JTvJ2s1eIosDw0CJqGcwShct31Tit6IcI9RGmR_qUlc&e=> Going? All events in this series: Yes<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_event-3Faction-3DRESPOND-26eid-3DdGdlMWk1N2ZrcWljcDM1MW9ma2swbWpyajAgb25hcC1kaXNjdXNzQGxpc3RzLm9uYXAub3Jn-26rst-3D1-26tok-3DNzIjbGludXhmb3VuZGF0aW9uLm9yZ18xcm10YjV0cHIzdWM4Zjc2Zm1mbHBsb2k4OEBncm91cC5jYWxlbmRhci5nb29nbGUuY29tYWI3NTM2NDQ5NGUxMDZmYmM0NDM3YWZkMzMzYTFkZDlhMThiMzgzMQ-26ctz-3DAmerica-252FLos-5FAngeles-26hl-3Den-26es-3D0&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=ilMKyhScoMyC22ogfM91ERB6VRTpgvUzx_8IEBZ3C7g&e=> - Maybe<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_event-3Faction-3DRESPOND-26eid-3DdGdlMWk1N2ZrcWljcDM1MW9ma2swbWpyajAgb25hcC1kaXNjdXNzQGxpc3RzLm9uYXAub3Jn-26rst-3D3-26tok-3DNzIjbGludXhmb3VuZGF0aW9uLm9yZ18xcm10YjV0cHIzdWM4Zjc2Zm1mbHBsb2k4OEBncm91cC5jYWxlbmRhci5nb29nbGUuY29tYWI3NTM2NDQ5NGUxMDZmYmM0NDM3YWZkMzMzYTFkZDlhMThiMzgzMQ-26ctz-3DAmerica-252FLos-5FAngeles-26hl-3Den-26es-3D0&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=rTbqJRV7NyZs8-337WGBkBtH9NxLb7oy213kD29pXnI&e=> - No<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_event-3Faction-3DRESPOND-26eid-3DdGdlMWk1N2ZrcWljcDM1MW9ma2swbWpyajAgb25hcC1kaXNjdXNzQGxpc3RzLm9uYXAub3Jn-26rst-3D2-26tok-3DNzIjbGludXhmb3VuZGF0aW9uLm9yZ18xcm10YjV0cHIzdWM4Zjc2Zm1mbHBsb2k4OEBncm91cC5jYWxlbmRhci5nb29nbGUuY29tYWI3NTM2NDQ5NGUxMDZmYmM0NDM3YWZkMzMzYTFkZDlhMThiMzgzMQ-26ctz-3DAmerica-252FLos-5FAngeles-26hl-3Den-26es-3D0&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=Q7vs0_5KG2vHcRiF3yocrbsWFiSmfRP9_QDzGZQhKHI&e=> more options ><https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_event-3Faction-3DVIEW-26eid-3DdGdlMWk1N2ZrcWljcDM1MW9ma2swbWpyajAgb25hcC1kaXNjdXNzQGxpc3RzLm9uYXAub3Jn-26tok-3DNzIjbGludXhmb3VuZGF0aW9uLm9yZ18xcm10YjV0cHIzdWM4Zjc2Zm1mbHBsb2k4OEBncm91cC5jYWxlbmRhci5nb29nbGUuY29tYWI3NTM2NDQ5NGUxMDZmYmM0NDM3YWZkMzMzYTFkZDlhMThiMzgzMQ-26ctz-3DAmerica-252FLos-5FAngeles-26hl-3Den-26es-3D0&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=LI3VT7ynSDnszYqJKwuIpYNKNR5ox78MdgS8nIV201c&e=> Invitation from Google Calendar<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=n7ifUaij4yUs1eq4zCF2i0CbWb41U-Ih4go1gkJDVNA&e=> You are receiving this courtesy email at the account onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> because you are an attendee of this event. To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.google.com_calendar_&d=DwQFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=n7ifUaij4yUs1eq4zCF2i0CbWb41U-Ih4go1gkJDVNA&e=> and control your notification settings for your entire calendar. Forwarding this invitation could allow any recipient to modify your RSVP response. Learn More<https://urldefense.proofpoint.com/v2/url?u=https-3A__support.google.com_calendar_answer_37135-23forwarding&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=6ynYmpUmV9QfEYW1P__UlQ&m=4qZu50ln1PuGngxiD51L3E7hfTjIIIPu6hqkht8bcWg&s=17jqYK_Cx9IEkUwNadAjDR4c7GApW-L-J4ueP5ZUPag&e=>. << File: invite.ics >> << File: ATT00001.txt >>
_______________________________________________ onap-discuss mailing list onap-discuss@lists.onap.org https://lists.onap.org/mailman/listinfo/onap-discuss