aws-samples / aws-database-migration-samples
File Age

File age measurements show the distribution of file ages (days since the first commit) and the recency of file updates (days since the latest commit).

Summary
  • Number of files: 31
  • Daily file updates (only one update per file and date counted): 282
  • First update: 2016-10-21
  • Latest update: 2019-02-11
  • Days between first and latest update: 844 (120 weeks, estimated 600 working days)
  • Active days (at least one file change): 31
  • Data:
File Change History Overall
File Age Distribution Overall
Days since first update
  • There are 31 files with 962 lines of code in files.
    • 31 files that are 366+ days old (962 lines of code)
    • 0 files that are 181-365 days old (0 lines of code)
    • 0 files that are 91-180 days old (0 lines of code)
    • 0 files that are 31-90 days old (0 lines of code)
    • 0 files that are 1-30 days old (0 lines of code)
100% | 0% | 0% | 0% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
Latest Change Distribution Overall
Days since last update
  • There are 31 files with 962 lines of code in files.
    • 31 files have been last changed 366+ days ago (962 lines of code)
    • 0 files have been last changed 181-365 days ago (0 lines of code)
    • 0 files have been last changed 91-180 days ago (0 lines of code)
    • 0 files have been last changed 31-90 days ago (0 lines of code)
    • 0 files have been last changed 1-30 days ago (0 lines of code)
100% | 0% | 0% | 0% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
File Change History per File Extension
sql, tab, rb, md, vw, txt, sh, js, ddl, pls, json
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
rb100% | 0% | 0% | 0% | 0%
vw100% | 0% | 0% | 0% | 0%
ddl100% | 0% | 0% | 0% | 0%
pls100% | 0% | 0% | 0% | 0%
js100% | 0% | 0% | 0% | 0%
Latest Change Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
rb100% | 0% | 0% | 0% | 0%
vw100% | 0% | 0% | 0% | 0%
ddl100% | 0% | 0% | 0% | 0%
pls100% | 0% | 0% | 0% | 0%
js100% | 0% | 0% | 0% | 0%
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
mongodb/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
oracle/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
mongodb/sampledb/v1/scripts100% | 0% | 0% | 0% | 0%
mysql/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
sqlserver/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
mongodb/sampledb/v1/user100% | 0% | 0% | 0% | 0%
primary (latest change distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
mongodb/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
oracle/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
mongodb/sampledb/v1/scripts100% | 0% | 0% | 0% | 0%
mysql/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
sqlserver/sampledb/v1/schema100% | 0% | 0% | 0% | 0%
mongodb/sampledb/v1/user100% | 0% | 0% | 0% | 0%
Oldest Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
pls
generate_tickets.pls
in oracle/sampledb/v1/schema
 32 1 1790 1928 2
vw
ticket_info.vw
in oracle/sampledb/v1/schema
 21 - 1790 1928 2
vw
sporting_event_info.vw
in oracle/sampledb/v1/schema
 13 - 1790 1928 2
vw
ticket_info.vw
in sqlserver/sampledb/v1/schema
 19 - 1914 1914 1
vw
sporting_event_info.vw
in sqlserver/sampledb/v1/schema
 13 - 1914 1914 1
vw
getNewId.vw
in sqlserver/sampledb/v1/schema
 2 - 1914 1914 1
vw
sporting_event_ticket_info.vw
in mysql/sampledb/v1/schema
 33 - 1790 1859 2
vw
sporting_event_info.vw
in mysql/sampledb/v1/schema
 27 - 1790 1859 2
load_sports_teams.rb
in mongodb/sampledb/v1/schema
 143 - 1790 1801 3
generate_sporting_events.rb
in mongodb/sampledb/v1/schema
 108 - 1790 1801 3
load_sport_location.rb
in mongodb/sampledb/v1/schema
 100 1 1790 1801 3
generate_tickets.rb
in mongodb/sampledb/v1/schema
 58 - 1790 1801 3
load_nfl_data.rb
in mongodb/sampledb/v1/schema
 36 - 1790 1801 4
load_nfl_stadium_data.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 4
load_sport.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 3
load_mlb_data.rb
in mongodb/sampledb/v1/schema
 32 - 1790 1801 4
load_person.rb
in mongodb/sampledb/v1/schema
 29 - 1790 1801 3
load_name_data.rb
in mongodb/sampledb/v1/schema
 26 - 1790 1801 4
list_sport_locations.rb
in mongodb/sampledb/v1/scripts
 14 - 1790 1801 2
list_sports.rb
in mongodb/sampledb/v1/scripts
 11 - 1790 1801 2
Files Not Recently Changed (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
vw
getNewId.vw
in sqlserver/sampledb/v1/schema
 2 - 1914 1914 1
vw
sporting_event_info.vw
in sqlserver/sampledb/v1/schema
 13 - 1914 1914 1
vw
ticket_info.vw
in sqlserver/sampledb/v1/schema
 19 - 1914 1914 1
create_dms_user.js
in mongodb/sampledb/v1/user
 6 - 1798 1798 1
list_sporting_events.rb
in mongodb/sampledb/v1/scripts
 7 - 1790 1801 2
list_teams.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_mlb_teams.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_name_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_sport_locations_with_seats.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_teams.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_stadium_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_mlb_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_sports.rb
in mongodb/sampledb/v1/scripts
 11 - 1790 1801 2
vw
sporting_event_info.vw
in oracle/sampledb/v1/schema
 13 - 1790 1928 2
list_sport_locations.rb
in mongodb/sampledb/v1/scripts
 14 - 1790 1801 2
vw
ticket_info.vw
in oracle/sampledb/v1/schema
 21 - 1790 1928 2
load_name_data.rb
in mongodb/sampledb/v1/schema
 26 - 1790 1801 4
vw
sporting_event_info.vw
in mysql/sampledb/v1/schema
 27 - 1790 1859 2
load_person.rb
in mongodb/sampledb/v1/schema
 29 - 1790 1801 3
Most Recently Created Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
ddl
dms_sample_dw.ddl
in oracle/sampledb/v1/schema
 90 - 1707 1707 1
create_dms_user.js
in mongodb/sampledb/v1/user
 6 - 1798 1798 1
load_sports_teams.rb
in mongodb/sampledb/v1/schema
 143 - 1790 1801 3
generate_sporting_events.rb
in mongodb/sampledb/v1/schema
 108 - 1790 1801 3
load_sport_location.rb
in mongodb/sampledb/v1/schema
 100 1 1790 1801 3
generate_tickets.rb
in mongodb/sampledb/v1/schema
 58 - 1790 1801 3
load_nfl_data.rb
in mongodb/sampledb/v1/schema
 36 - 1790 1801 4
load_nfl_stadium_data.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 4
load_sport.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 3
load_mlb_data.rb
in mongodb/sampledb/v1/schema
 32 - 1790 1801 4
load_person.rb
in mongodb/sampledb/v1/schema
 29 - 1790 1801 3
load_name_data.rb
in mongodb/sampledb/v1/schema
 26 - 1790 1801 4
list_sport_locations.rb
in mongodb/sampledb/v1/scripts
 14 - 1790 1801 2
list_sports.rb
in mongodb/sampledb/v1/scripts
 11 - 1790 1801 2
list_mlb_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_stadium_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_teams.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_sport_locations_with_seats.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_name_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
Most Recently Changed Files (Top 20)
File# lines# unitslast modified
(days ago)		created
(days ago)		# changes
ddl
dms_sample_dw.ddl
in oracle/sampledb/v1/schema
 90 - 1707 1707 1
load_sports_teams.rb
in mongodb/sampledb/v1/schema
 143 - 1790 1801 3
generate_sporting_events.rb
in mongodb/sampledb/v1/schema
 108 - 1790 1801 3
load_sport_location.rb
in mongodb/sampledb/v1/schema
 100 1 1790 1801 3
generate_tickets.rb
in mongodb/sampledb/v1/schema
 58 - 1790 1801 3
load_nfl_data.rb
in mongodb/sampledb/v1/schema
 36 - 1790 1801 4
load_nfl_stadium_data.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 4
load_sport.rb
in mongodb/sampledb/v1/schema
 35 - 1790 1801 3
vw
sporting_event_ticket_info.vw
in mysql/sampledb/v1/schema
 33 - 1790 1859 2
load_mlb_data.rb
in mongodb/sampledb/v1/schema
 32 - 1790 1801 4
pls
generate_tickets.pls
in oracle/sampledb/v1/schema
 32 1 1790 1928 2
load_person.rb
in mongodb/sampledb/v1/schema
 29 - 1790 1801 3
vw
sporting_event_info.vw
in mysql/sampledb/v1/schema
 27 - 1790 1859 2
load_name_data.rb
in mongodb/sampledb/v1/schema
 26 - 1790 1801 4
vw
ticket_info.vw
in oracle/sampledb/v1/schema
 21 - 1790 1928 2
list_sport_locations.rb
in mongodb/sampledb/v1/scripts
 14 - 1790 1801 2
vw
sporting_event_info.vw
in oracle/sampledb/v1/schema
 13 - 1790 1928 2
list_sports.rb
in mongodb/sampledb/v1/scripts
 11 - 1790 1801 2
list_mlb_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2
list_nfl_stadium_data.rb
in mongodb/sampledb/v1/scripts
 9 - 1790 1801 2