26:
192:
market following the 2008 financial crisis. The perceived problems were a lack of transparency and the absence of a standardised system across asset classes. These made it difficult to make accurate risk assessments of the securities. Enabling better risk assessment would then have the effect of
187:
credit operations. The aim was to allow market participants access to standardized timely information on loans and their performance. Access to this information should allow market actors to make more informed decisions regarding asset backed securities. The
Eurosystem believed that the new data
208:
The result of this development work is
European Data Warehouse GmbH. European DataWarehouse was founded in January 2012 for the purpose of facilitating risk assessment and improving transparency in European asset-backed security (ABS) deals.
229:
European DataWarehouse's responsibilities include ensuring that ABS market data is openly accessible and that all transactions are recorded. A key aim of
European DataWarehouse is to instil trust back into the ABS market. The
188:
requirements would help both investors and third-party assessment providers with their due diligence. It was hoped that the loan level initiative would help instill transparency and, ultimately, confidence back into the
217:
European DataWarehouse Ltd. was designated as a
Securitisation regulation under the FCA in December 2020, which followed the establishment of a UK subsidiary, European DataWarehouse Ltd, as well as a UK office.
568:
131:
It is the first centralised data repository in Europe for collecting, validating and making accessible to download point-by-point, institutionalised and asset class specific loan-level data (LLD) for
765:
221:
European DataWarehouse GmbH was designated as a
Securitisation Repository under ESMA in June 2021, more than three years after the Securitisation Regulation (EU)2017/2402 came into force.
200:
made "Loan Level
Information" one of their extended eligibility criteria for ABS collateral, but without a costly central data warehouse and with free access to market participants.
1374:
678:
475:
1384:
420:
697:
1389:
873:
274:
Management of
European DataWarehouse GmbH is Represented by Dr. Christian Thun (CEO), Gopala Krishnan Sankaran (CTO), and Sascha Schimpfermann (CFO).
101:
751:
554:
403:
for the Best
Industry Infrastructure Initiative in 2012 and was named "Securitization Data Provider of the Year" by GlobalCapital in 2019 and 2022.
537:
179:
The initiative began after support for the idea was recognised at an ECB public consultation. It establishes specific information requirements for
1394:
604:
286:
795:
1379:
1345:
821:
for collecting loan level data (LLD) for Asset-backed securities transactions. It was developed by the market, and endorsed by the
737:
135:(ABS) transactions. European DataWarehouse helps to facilitate risk assessment and improve transparency for European ABS deals.
1251:
496:
445:
1409:
1305:
866:
1399:
1230:
931:
372:
956:
105:
569:"1010data, Inc. and European DataWarehouse GmbH Partner to Increase Transparency of European Asset Backed Securities"
510:
323:
1340:
1256:
951:
916:
1404:
1209:
1109:
113:
583:
1130:
1125:
1083:
859:
701:
400:
653:
1199:
235:
132:
125:
629:
1225:
1022:
1000:
1317:
1184:
926:
255:
231:
180:
169:
165:
157:
117:
1189:
1104:
972:
921:
293:
254:
The main decision-making body. It comprises the shareholder members and governors/observers from the
1140:
1078:
995:
946:
365:
584:"European DataWarehouse: An initiative to improve transparency for European securitisation market"
315:
277:
Management of the UK Subsidiary, European DataWarehouse Ltd., is represented by Markus
Schaber.
1052:
555:"European DataWarehouse: European Loan Level Data: Smart Usage Beyond Asset-Backed Securities"
1235:
941:
266:
Sets the fee structure for EDW customers and consists of eight members of the ABS industry.
121:
39:
421:"ESMA registers European DataWarehouse GmbH and SecRep B.V. as Securitisation Repositories"
234:
is set to make compliance with loan-level data disclosure compulsory before it will accept
1135:
1099:
1038:
990:
826:
352:
197:
882:
818:
189:
173:
193:
encouraging investors and reducing then current levels of reliance on the
Eurosystem.
1368:
1312:
1057:
515:
128:(ABS). It provides an open platform for users to access asset-backed security data.
1324:
1261:
1145:
100:
European DataWarehouse (EDW) is a Securitisation Repository designated by both the
1194:
936:
300:
538:"European DataWarehouse sorgt für Transparenzgewinn von Auto-ABS-Transaktionen"
1300:
1073:
822:
184:
161:
1204:
1047:
982:
385:
307:
58:
25:
1042:
977:
911:
258:
and NCB. It is responsible for strategy and monitoring EDW's operations.
153:
738:"European DataWarehouse Wins "Best Industry Infrastructure Initiative""
682:
497:"La Comisión Europea da un paso más en su apoyo a las Hipotecas Verdes"
479:
64:
446:"FCA has decided to register the first UK securitisation repositories"
766:"GlobalCapital European Securitization Awards: the winners revealed"
1017:
1012:
1007:
851:
752:"GlobalCapital European Securitisation Awards 2019: The Winners""
630:"Bank of England - Market Notice on Information Transparency ABS"
335:
1282:
1166:
893:
855:
829:
and to improve transparency standards for European ABS deals.
698:"Euro ABS Data Warehouse investors offered incentive scheme"
476:"Euro ABS DataWarehouse investors offered incentive scheme"
246:
EDW has three decision-making bodies and 16 shareholders.
164:
credit operations. It was put forward in response to the
845:
723:
679:"REFILE-ECB launches structured transparency programme"
839:
812:
89:
1333:
1293:
1244:
1218:
1177:
1118:
1092:
1066:
1031:
965:
904:
84:
71:
53:
45:
35:
511:"Company Overview of European DataWarehouse GmbH"
102:European Securities and Markets Authority (ESMA)
124:services and full disclosure for investors in
1346:Data warehousing products and their producers
867:
160:(ABSs) information accepted as collateral in
8:
491:
489:
18:
499:(in Spanish). Eficiencia. 22 November 2017.
1290:
1279:
1174:
1163:
901:
890:
874:
860:
852:
172:(ECB) wanted to restore confidence in the
17:
1375:2012 establishments in the European Union
469:
467:
282:
412:
549:
547:
7:
796:"Technical Working Group Membership"
540:. TSI-kompakt.de. 26 September 2013.
287:Banco Bilbao Vizcaya Argentaria S.A.
156:initiative from 2012 to standardize
1385:Institutions of the European Union
1231:MultiDimensional eXpressions (MDX)
557:. RiskTech Forum. 1 November 2016.
196:Following the ECB initiative, the
14:
740:. LCM Partners. 14 December 2012.
582:Kanoni, Eirini; Schaber, Markus.
342:Dutch Securitisation Association
183:(ABSs) accepted as collateral in
1390:Organisations based in Frankfurt
814:European Data DataWarehouse GmbH
24:
754:. GlobalCapital. 14 March 2019.
654:"Eligible Collateral Framework"
1395:Business intelligence software
1252:Business intelligence software
1131:Extract, load, transform (ELT)
1126:Extract, transform, load (ETL)
114:ABS Loan Level Data initiative
1:
1200:Decision support system (DSS)
474:Mayre, Anil (15 March 2012).
360:Moody's Group Cyprus Limited
347:Instituto de Crédito Oficial
238:as collateral for financing.
120:that is engaged in providing
1226:Data Mining Extensions (DMX)
605:"Public Consultation Report"
571:. 1010data.com. 4 June 2014.
987:Ensemble modeling patterns
957:Single version of the truth
110:European DataWarehouse GmbH
106:Financial Conduct Authority
1426:
1341:Comparison of OLAP servers
280:The EDW shareholders are:
1380:Banks established in 1998
1289:
1278:
1210:Data warehouse automation
1173:
1162:
900:
895:Creating a data warehouse
889:
700:. Reuters. Archived from
399:The company received the
150:ABS Loan-Level Initiative
23:
401:Banking Technology Award
380:True Sale International
324:Crédit Foncier de France
1236:XML for Analysis (XMLA)
817:, the European central
330:Creditreform Rating AG
236:asset-backed securities
181:asset-backed securities
158:asset-backed securities
133:asset-backed securities
126:asset-backed securities
1168:Using a data warehouse
1023:Operational data store
204:Data warehouse created
174:securitisations market
30:European DataWarehouse
1185:Business intelligence
366:Sapient Global Market
232:European Central Bank
170:European Central Bank
166:2008 financial crisis
118:European Central Bank
19:EuropeanDataWarehouse
1410:Securities (finance)
1001:Focal point modeling
973:Column-oriented DBMS
922:Dimensional modeling
294:Banco Santander S.A.
1400:Databases in Europe
1306:Information factory
1079:Early-arriving fact
996:Data vault modeling
947:Reverse star schema
772:. 30 September 2022
704:on 22 February 2014
685:. 30 November 2012.
116:established by the
20:
1257:Reporting software
724:"ED Press Release"
425:www.esma.europa.eu
1362:
1361:
1358:
1357:
1354:
1353:
1274:
1273:
1270:
1269:
1158:
1157:
1154:
1153:
1053:Sixth normal form
392:
391:
262:Pricing committee
250:Supervisory board
98:
97:
80:
1417:
1405:Data warehousing
1291:
1280:
1175:
1164:
942:Snowflake schema
902:
891:
876:
869:
862:
853:
846:Official website
840:Official website
825:, to facilitate
809:
807:
805:
800:
782:
781:
779:
777:
762:
756:
755:
748:
742:
741:
734:
728:
727:
720:
714:
713:
711:
709:
693:
687:
686:
675:
669:
668:
666:
664:
650:
644:
643:
641:
639:
634:
626:
620:
619:
617:
615:
609:
601:
595:
594:
588:
579:
573:
572:
565:
559:
558:
551:
542:
541:
534:
528:
527:
525:
523:
507:
501:
500:
493:
484:
483:
471:
462:
461:
459:
457:
452:. 7 January 2022
442:
436:
435:
433:
431:
417:
373:Société Générale
301:BNP Paribas S.A.
283:
225:Responsibilities
122:data warehousing
94:
91:
78:
40:Data warehousing
28:
21:
1425:
1424:
1420:
1419:
1418:
1416:
1415:
1414:
1365:
1364:
1363:
1350:
1329:
1285:
1266:
1240:
1214:
1169:
1150:
1114:
1110:Slowly changing
1100:Dimension table
1088:
1062:
1039:Data dictionary
1027:
991:Anchor modeling
961:
896:
885:
883:Data warehouses
880:
836:
827:risk assessment
803:
801:
798:
794:
791:
786:
785:
775:
773:
764:
763:
759:
750:
749:
745:
736:
735:
731:
722:
721:
717:
707:
705:
695:
694:
690:
677:
676:
672:
662:
660:
658:Bank of England
652:
651:
647:
637:
635:
632:
628:
627:
623:
613:
611:
607:
603:
602:
598:
586:
581:
580:
576:
567:
566:
562:
553:
552:
545:
536:
535:
531:
521:
519:
509:
508:
504:
495:
494:
487:
473:
472:
465:
455:
453:
444:
443:
439:
429:
427:
419:
418:
414:
409:
397:
353:Intesa Sanpaolo
316:Crédit Agricole
244:
227:
215:
206:
198:Bank of England
146:
141:
112:is part of the
88:
77:Christian Thun
74:
67:
61:
31:
12:
11:
5:
1423:
1421:
1413:
1412:
1407:
1402:
1397:
1392:
1387:
1382:
1377:
1367:
1366:
1360:
1359:
1356:
1355:
1352:
1351:
1349:
1348:
1343:
1337:
1335:
1331:
1330:
1328:
1327:
1322:
1321:
1320:
1318:Enterprise bus
1310:
1309:
1308:
1297:
1295:
1287:
1286:
1283:
1276:
1275:
1272:
1271:
1268:
1267:
1265:
1264:
1259:
1254:
1248:
1246:
1242:
1241:
1239:
1238:
1233:
1228:
1222:
1220:
1216:
1215:
1213:
1212:
1207:
1202:
1197:
1192:
1187:
1181:
1179:
1171:
1170:
1167:
1160:
1159:
1156:
1155:
1152:
1151:
1149:
1148:
1143:
1138:
1133:
1128:
1122:
1120:
1116:
1115:
1113:
1112:
1107:
1102:
1096:
1094:
1090:
1089:
1087:
1086:
1081:
1076:
1070:
1068:
1064:
1063:
1061:
1060:
1055:
1050:
1045:
1035:
1033:
1029:
1028:
1026:
1025:
1020:
1015:
1010:
1005:
1004:
1003:
998:
993:
985:
980:
975:
969:
967:
963:
962:
960:
959:
954:
949:
944:
939:
934:
929:
924:
919:
914:
908:
906:
898:
897:
894:
887:
886:
881:
879:
878:
871:
864:
856:
850:
849:
843:
835:
834:External links
832:
831:
830:
819:data warehouse
810:
790:
787:
784:
783:
757:
743:
729:
715:
688:
670:
645:
621:
596:
574:
560:
543:
529:
502:
485:
463:
437:
411:
410:
408:
405:
396:
393:
390:
389:
382:
381:
377:
376:
369:
368:
362:
361:
357:
356:
349:
348:
344:
343:
339:
338:
332:
331:
327:
326:
320:
319:
312:
311:
304:
303:
297:
296:
290:
289:
272:
271:
270:EDW management
264:
263:
252:
251:
243:
240:
226:
223:
214:
211:
205:
202:
190:securitisation
145:
144:ABS initiative
142:
140:
137:
96:
95:
86:
82:
81:
75:
72:
69:
68:
63:
57:
55:
51:
50:
47:
43:
42:
37:
33:
32:
29:
13:
10:
9:
6:
4:
3:
2:
1422:
1411:
1408:
1406:
1403:
1401:
1398:
1396:
1393:
1391:
1388:
1386:
1383:
1381:
1378:
1376:
1373:
1372:
1370:
1347:
1344:
1342:
1339:
1338:
1336:
1332:
1326:
1323:
1319:
1316:
1315:
1314:
1313:Ralph Kimball
1311:
1307:
1304:
1303:
1302:
1299:
1298:
1296:
1292:
1288:
1281:
1277:
1263:
1260:
1258:
1255:
1253:
1250:
1249:
1247:
1243:
1237:
1234:
1232:
1229:
1227:
1224:
1223:
1221:
1217:
1211:
1208:
1206:
1203:
1201:
1198:
1196:
1193:
1191:
1188:
1186:
1183:
1182:
1180:
1176:
1172:
1165:
1161:
1147:
1144:
1142:
1139:
1137:
1134:
1132:
1129:
1127:
1124:
1123:
1121:
1117:
1111:
1108:
1106:
1103:
1101:
1098:
1097:
1095:
1091:
1085:
1082:
1080:
1077:
1075:
1072:
1071:
1069:
1065:
1059:
1058:Surrogate key
1056:
1054:
1051:
1049:
1046:
1044:
1040:
1037:
1036:
1034:
1030:
1024:
1021:
1019:
1016:
1014:
1011:
1009:
1006:
1002:
999:
997:
994:
992:
989:
988:
986:
984:
981:
979:
976:
974:
971:
970:
968:
964:
958:
955:
953:
950:
948:
945:
943:
940:
938:
935:
933:
930:
928:
925:
923:
920:
918:
915:
913:
910:
909:
907:
903:
899:
892:
888:
884:
877:
872:
870:
865:
863:
858:
857:
854:
847:
844:
841:
838:
837:
833:
828:
824:
820:
816:
815:
811:
797:
793:
792:
788:
771:
770:GlobalCapital
767:
761:
758:
753:
747:
744:
739:
733:
730:
725:
719:
716:
703:
699:
696:Mayre, Anil.
692:
689:
684:
680:
674:
671:
659:
655:
649:
646:
631:
625:
622:
606:
600:
597:
592:
585:
578:
575:
570:
564:
561:
556:
550:
548:
544:
539:
533:
530:
518:
517:
516:Bloomberg.com
512:
506:
503:
498:
492:
490:
486:
481:
477:
470:
468:
464:
451:
447:
441:
438:
426:
422:
416:
413:
406:
404:
402:
394:
387:
384:
383:
379:
378:
374:
371:
370:
367:
364:
363:
359:
358:
354:
351:
350:
346:
345:
341:
340:
337:
334:
333:
329:
328:
325:
322:
321:
317:
314:
313:
309:
306:
305:
302:
299:
298:
295:
292:
291:
288:
285:
284:
281:
278:
275:
269:
268:
267:
261:
260:
259:
257:
249:
248:
247:
241:
239:
237:
233:
224:
222:
219:
212:
210:
203:
201:
199:
194:
191:
186:
182:
177:
175:
171:
167:
163:
159:
155:
151:
143:
138:
136:
134:
129:
127:
123:
119:
115:
111:
107:
103:
93:
87:
83:
76:
70:
66:
60:
56:
52:
48:
44:
41:
38:
34:
27:
22:
16:
1325:Dan Linstedt
813:
802:. Retrieved
774:. Retrieved
769:
760:
746:
732:
718:
706:. Retrieved
702:the original
691:
673:
663:17 September
661:. Retrieved
657:
648:
638:17 September
636:. Retrieved
624:
612:. Retrieved
599:
590:
577:
563:
532:
520:. Retrieved
514:
505:
454:. Retrieved
449:
440:
428:. Retrieved
424:
415:
398:
279:
276:
273:
265:
253:
245:
228:
220:
216:
207:
195:
178:
149:
147:
130:
109:
99:
54:Headquarters
49:January 2012
15:
1262:Spreadsheet
1195:Data mining
937:Star schema
522:14 December
1369:Categories
1301:Bill Inmon
1105:Degenerate
1074:Fact table
823:Eurosystem
789:References
185:Eurosystem
162:Eurosystem
73:Key people
1219:Languages
1205:OLAP cube
1190:Dashboard
1141:Transform
1093:Dimension
1048:Data mart
983:Data mesh
952:Aggregate
917:Dimension
591:eurodw.eu
407:Citations
386:UniCredit
308:CaixaBank
213:Evolution
168:, as the
59:Frankfurt
1334:Products
1178:Concepts
1043:Metadata
1032:Elements
978:Data hub
966:Variants
912:Database
905:Concepts
776:28 March
456:28 March
430:28 March
154:Eurozone
104:and the
36:Industry
1284:Related
1136:Extract
1119:Filling
1084:Measure
708:12 July
683:Reuters
480:Reuters
388:S.P.A.
355:S.P.A.
139:History
108:(FCA).
85:Website
65:Germany
46:Founded
1294:People
842:(GmbH)
804:9 July
614:9 July
395:Awards
242:Boards
152:was a
90:eurodw
1245:Tools
1018:ROLAP
1013:MOLAP
1008:HOLAP
848:(Ltd)
799:(PDF)
633:(PDF)
610:. ECB
608:(PDF)
587:(PDF)
375:S.A.
318:S.A.
310:S.A.
1146:Load
1067:Fact
932:OLAP
927:Fact
806:2012
778:2023
710:2012
665:2012
640:2012
616:2012
524:2017
458:2023
432:2023
336:DBRS
148:The
450:FCA
256:ECB
92:.eu
79:CEO
1371::
768:.
681:.
656:.
589:.
546:^
513:.
488:^
478:.
466:^
448:.
423:.
176:.
62:,
1041:/
875:e
868:t
861:v
808:.
780:.
726:.
712:.
667:.
642:.
618:.
593:.
526:.
482:.
460:.
434:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.
