2017-2018 exchange Sept Oct 2017 Newsletter FINAL | Page 11

Database Management Systems , such as Oracle and SQL Server , consist of software that provides structure for data by organizing it . It also enables users to create , access , search , retrieve and update data . Computer language , such as Structured Query Language , is used to facilitate these actions . The overlay for all of this is the application being utilized by users — for example , a flight reservation application .
Not surprisingly , businesses use databases for different uses : to capture customer account information , transactions , and inventory tracking . There can be technology challenges when applying record retention requirements as some companies do not have the appropriate architecture to systematically identify and delete the applicable data . This becomes more complex when event based retention is involved . Additionally , data that has different retention periods is problematic if the deletion of certain data adversely affects data of another record type .
Unstructured data in the form of files ( e . g ., Word ) is typically contained in folders and subfolders within a directory that can be accessed by multiple users . Disposition is managed through organization of folders and files and the use of naming conventions .
11