Knowledge (XXG)

Data engineering

Source 📝

478:
follows this strategy. It is often difficult to implement these plans because of the lack of transparency at the tactical and operational degrees of organizations. This kind of planning requires feedback to allow for early correction of problems that are due to miscommunication and misinterpretation of the business plan.
896:
Abadi, Martin; Barham, Paul; Chen, Jianmin; Chen, Zhifeng; Davis, Andy; Dean, Jeffrey; Devin, Matthieu; Ghemawat, Sanjay; Irving, Geoffrey; Isard, Michael; Kudlur, Manjunath; Levenberg, Josh; Monga, Rajat; Moore, Sherry; Murray, Derek G.; Steiner, Benoit; Tucker, Paul; Vasudevan, Vijay; Warden, Pete;
100:
based upon an understanding of the operational processing needs of organizations for the 1980s. In particular, these techniques were meant to help bridge the gap between strategic business planning and information systems. A key early contributor (often called the "father" of information engineering
477:
Business objectives that executives set for what's to come are characterized in key business plans, with their more noteworthy definition in tactical business plans and implementation in operational business plans. Most businesses today recognize the fundamental need to grow a business plan that
109:
report on it with James Martin. Over the next few years, Finkelstein continued work in a more business-driven direction, which was intended to address a rapidly changing business environment; Martin continued work in a more data processing-driven direction. From 1983 to 1987, Charles M. Richter,
269:
Data is stored in a variety of ways, one of the key deciding factors is in how the data will be used. Data engineers optimize data storage and processing systems to reduce costs. They use data compression, partitioning, and archiving.
536:. They are focused on the production readiness of data and things like formats, resilience, scaling, and security. Data engineers usually hail from a software engineering background and are proficient in programming languages like 1506:
Clive Finkelstein (2011) "Enterprise Architecture for Integration: Rapid Delivery Methods and Technologies". Second Edition is in PDF at www.ies.aust.com and as an ebook on the Apple iPad and ebook on the Amazon
117:(IT) teams in most companies. Other teams then used data for their work (e.g. reporting), and there was usually little overlap in data skillset between these parts of the business. 110:
guided by Clive Finkelstein, played a significant role in revamping IEM as well as helping to design the IEM software product (user data), which helped automate IEM.
1503:
Clive Finkelstein (2006) "Enterprise Architecture for Integration: Rapid Delivery Methods and Technologies". First Edition, Artech House, Norwood MA in hardcover.
229:
High-performance computing is critical for the processing and analysis of data. One particularly widespread approach to computing for data engineering is
1099: 1524: 1553: 1122: 1533: 307: 532:
pipelines to manage the flow of data through the organization. This makes it possible to take huge amounts of data and translate it into
452:
The number and variety of different data processes and storage locations can become overwhelming for users. This inspired the usage of a
789: 1471:
Ian Macdonald (1988). "Automating the Information engineering methodology with the Information Engineering Facility". In:
541: 279: 1558: 545: 329: 486:
The design of data systems involves several components such as architecting data platforms, and designing data stores.
549: 537: 974: 553: 453: 1044: 816: 237:(dataflow graph); nodes are the operations, and edges represent the flow of data. Popular implementations include 360:
is a centralized repository for storing, processing, and securing large volumes of data. A data lake can contain
340:
on a much larger scale than databases can allow, and indeed data often flow from databases into data warehouses.
720: 1563: 529: 925: 314:
databases — which attempt to allow horizontal scaling while retaining ACID guarantees — have become popular.
847: 337: 306:
more easily than relational databases by giving up the ACID transaction guarantees, as well as reducing the
28: 1510:
Reis, Joe; Housley, Matt (2022) "Fundamentals of Data Engineering". O'Reilly Media, Inc. ISBN 9781098108304
1461:
Clive Finkelstein (1992). "Information Engineering: Strategic Systems Development". Sydney: Addison-Wesley.
250: 1204: 603: 461: 161: 114: 93: 1482: 1381: 533: 345: 258: 65: 460:) to allow the data tasks to be specified, created, and monitored. The tasks are often specified as a 106: 1521: 975:"Lecture Notes | Database Systems | Electrical Engineering and Computer Science | MIT OpenCourseWare" 608: 369: 254: 230: 169: 1408: 1070: 872: 365: 287: 173: 1282: 658: 17: 1361: 1025: 426: 380:. A data lake can be created on premises or in a cloud-based environment using the services from 303: 105:, who wrote several articles about it between 1976 and 1980, and also co-authored an influential 757: 749: 1486: 1373: 1369: 373: 102: 753: 745: 1353: 1322: 1017: 613: 586: 385: 344:, data engineers, and data scientists can access data warehouses using tools such as SQL or 341: 145: 57: 1528: 1456:
An Introduction to Information Engineering: From Strategic Planning to Information Systems
1394: 952: 381: 361: 205: 197: 181: 97: 85: 69: 505: 495: 457: 432: 333: 323: 234: 193: 177: 49: 1547: 1365: 1008: 418: 405: 242: 185: 1434: 1029: 924:
McSherry, Frank; Murray, Derek; Isaacs, Rebecca; Isard, Michael (January 5, 2013).
785: 632: 565: 238: 53: 1451:
John Hares (1992). "Information Engineering for the Advanced Practitioner", Wiley.
1146: 695: 574: 552:. They will be more familiar with databases, architecture, cloud computing, and 422: 412: 377: 189: 92:
for data analysis and processing. These techniques were intended to be used by
903:
12th USENIX Symposium on Operating Systems Design and Implementation (OSDI 16)
582: 578: 573:
are more focused on the analysis of the data, they will be more familiar with
501: 421:
splits data into regularly sized chunks; this often matches up with (virtual)
246: 149: 124:, the massive increase in data volumes, velocity, and variety led to the term 208:. Data started to be handled and used by many parts of the business, such as 34:
Software engineering approach to designing and developing information systems
1476: 1123:"Google Spanner's Most Surprising Revelation: NoSQL is Out and NewSQL is In" 930: 508:
to describe the data and relationships between different parts of the data.
389: 357: 283: 213: 153: 1349: 1357: 1174: 898: 598: 526: 436: 201: 129: 125: 121: 89: 61: 1348:
Tamir, Mike; Miller, Steven; Gagliardi, Alessandro (December 11, 2015).
113:
In the early 2000s, the data and data tooling was generally held by the
1493:. Technical Report (2 volumes), Savant Institute, Carnforth, Lancs, UK. 1323:"What is Data Modelling? Overview, Basic Concepts, and Types in Detail" 1021: 1000: 157: 393: 311: 141: 133: 41: 1539:
Enterprise Engineering and Rapid Delivery of Enterprise Architecture
404:
If the data is less structured, then often they are just stored as
299: 298:
for their queries. However, with the growth of data in the 2010s,
294:
transaction correctness guarantees; most relational databases use
209: 1473:
Computerized Assistance during the Information Systems Life Cycle
128:
to describe the data itself, and data-driven tech companies like
1175:"What is a Data Warehouse? | Key Concepts | Amazon Web Services" 633:"What is Data Engineering? | A Quick Glance of Data Engineering" 440: 291: 204:
management. This change in approach was particularly focused on
45: 1100:"NewSQL: An Alternative to NoSQL and Old SQL for New OLTP Apps" 1045:"How Will The Database Incumbents Respond To NoSQL And NewSQL?" 1257: 721:"Information Engineering - an overview | ScienceDirect Topics" 295: 1229: 773:
Christopher Allen, Simon Chatwin, Catherine Creary (2003).
1538: 336:
are a main choice. They enable data analysis, mining, and
332:
is required (but not online transaction processing), then
775:
Introduction to Relational Databases and SQL Programming.
1230:"Cloud Object Storage – Amazon S3 – Amazon Web Services" 817:"The History of the Data Engineering and the Megatrends" 899:"TensorFlow: A system for large-scale machine learning" 696:"What is Data Engineering and Why Is It So Important?" 60:. Making the data usable usually involves substantial 1464:
Ian Macdonald (1986). "Information engineering". in:
140:. Due to the new scale of the data, major firms like 897:Wicke, Martin; Yu, Yuan; Zheng, Xiaoqiang (2016). 1205:"File storage, block storage, or object storage?" 48:. This data is usually used to enable subsequent 1001:"Will NoSQL Databases Live Up to Their Promise?" 415:represent data hierarchically in nested folders. 233:, in which the computation is represented as a 1309:What are The Phases of Information Engineering 848:"The Remarkable Utility of Dataflow Computing" 794:Information Modeling and Relational Databases. 439:; often each file is assigned a key such as a 302:databases have also become popular since they 164:and storage techniques. They started creating 1435:"What is Data Science and Why it's Important" 8: 525:is a type of software engineer who creates 278:If the data is structured and some form of 1252: 1250: 1199: 1197: 1195: 261:for much more efficient data processing. 120:In the early 2010s, with the rise of the 1468:. T.W. Olle et al. (ed.). North-Holland. 1466:Information Systems Design Methodologies 841: 839: 837: 1169: 1167: 1141: 1139: 1069:Pavlo, Andrew; Aslett, Matthew (2016). 810: 808: 806: 804: 802: 689: 687: 685: 683: 681: 679: 624: 249:. More recent implementations, such as 1390: 1379: 1098:Stonebraker, Michael (June 16, 2011). 286:are generally used. Originally mostly 160:started to move away from traditional 44:to enable the collection and usage of 1050:. 451 Group (published April 4, 2011) 7: 846:Schwarzkopf, Malte (March 7, 2020). 308:object-relational impedance mismatch 762:Computerworld, In depths, appendix. 500:This is the process of producing a 172:focused on data, and in particular 82:information engineering methodology 1409:"Data Engineer vs. Data Scientist" 1283:"Introduction to Data Engineering" 694:Black, Nathan (January 15, 2020). 659:"Introduction to Data Engineering" 25: 18:Information technology engineering 1500:. (3 volumes), Prentice-Hall Inc. 1121:Hoff, Todd (September 24, 2012). 1102:. Communications of the ACM Blog 1071:"What's Really New with NewSQL?" 955:. Timely Dataflow. July 30, 2022 101:methodology) was the Australian 80:Around the 1970s/1980s the term 328:If the data is structured and 84:(IEM) was created to describe 1: 1534:Rapid Application Development 408:. There are several options: 280:online transaction processing 1554:Software development process 1479:et al. (ed.). North-Holland. 462:directed acyclic graph (DAG) 330:online analytical processing 1437:. Edureka. January 5, 2017. 1147:"What is a Data Warehouse?" 760:" by Clive Finkelstein. In 744:"Information engineering," 1580: 1454:Clive Finkelstein (1989). 563: 554:Agile software development 493: 454:workflow management system 321: 40:refers to the building of 26: 1458:. Sydney: Addison-Wesley. 136:started using the phrase 1234:Amazon Web Services, Inc 1179:Amazon Web Services, Inc 1043:Aslett, Matthew (2011). 27:Not to be confused with 1498:Information engineering 1491:Information engineering 953:"Differential Dataflow" 926:"Differential dataflow" 764:May 25 – June 15, 1981. 338:artificial intelligence 290:were used, with strong 94:database administrators 56:, which often involves 29:Information Engineering 1527:July 20, 2019, at the 1522:The Complex Method IEM 1389:Cite journal requires 999:Leavitt, Neal (2010). 604:Information technology 115:information technology 1496:James Martin (1989). 725:www.sciencedirect.com 346:business intelligence 259:incremental computing 1358:10.2139/ssrn.2762013 1307:Finkelstein, Clive. 609:Software engineering 370:semi-structured data 366:relational databases 288:relational databases 257:Dataflow, have used 231:dataflow programming 170:software engineering 1559:Information systems 1350:"The Data Engineer" 435:manages data using 304:horizontally scaled 216:, and not just IT. 1415:. February 7, 2019 1022:10.1109/MC.2010.58 905:. pp. 265–283 427:solid state drives 282:is required, then 1487:Clive Finkelstein 1352:. Rochester, NY. 639:. January 5, 2020 473:Business planning 374:unstructured data 342:Business analysts 310:. More recently, 103:Clive Finkelstein 16:(Redirected from 1571: 1439: 1438: 1431: 1425: 1424: 1422: 1420: 1413:Springboard Blog 1405: 1399: 1398: 1392: 1387: 1385: 1377: 1345: 1339: 1338: 1336: 1334: 1319: 1313: 1312: 1304: 1298: 1297: 1295: 1293: 1279: 1273: 1272: 1270: 1268: 1254: 1245: 1244: 1242: 1240: 1226: 1220: 1219: 1217: 1215: 1201: 1190: 1189: 1187: 1185: 1171: 1162: 1161: 1159: 1157: 1143: 1134: 1133: 1131: 1129: 1118: 1112: 1111: 1109: 1107: 1095: 1089: 1088: 1086: 1084: 1075: 1066: 1060: 1059: 1057: 1055: 1049: 1040: 1034: 1033: 1005: 996: 990: 989: 987: 985: 971: 965: 964: 962: 960: 949: 943: 942: 940: 938: 921: 915: 914: 912: 910: 893: 887: 886: 884: 882: 877: 869: 863: 862: 860: 858: 843: 832: 831: 829: 827: 812: 797: 783: 777: 771: 765: 742: 736: 735: 733: 731: 717: 711: 710: 708: 706: 691: 674: 673: 671: 669: 655: 649: 648: 646: 644: 629: 614:Computer science 587:machine learning 384:vendors such as 166:data engineering 107:Savant Institute 98:systems analysts 58:machine learning 38:Data engineering 21: 1579: 1578: 1574: 1573: 1572: 1570: 1569: 1568: 1564:Data management 1544: 1543: 1529:Wayback Machine 1518: 1513: 1447: 1445:Further reading 1442: 1433: 1432: 1428: 1418: 1416: 1407: 1406: 1402: 1388: 1378: 1347: 1346: 1342: 1332: 1330: 1329:. June 15, 2021 1327:Simplilearn.com 1321: 1320: 1316: 1306: 1305: 1301: 1291: 1289: 1281: 1280: 1276: 1266: 1264: 1256: 1255: 1248: 1238: 1236: 1228: 1227: 1223: 1213: 1211: 1203: 1202: 1193: 1183: 1181: 1173: 1172: 1165: 1155: 1153: 1145: 1144: 1137: 1127: 1125: 1120: 1119: 1115: 1105: 1103: 1097: 1096: 1092: 1082: 1080: 1073: 1068: 1067: 1063: 1053: 1051: 1047: 1042: 1041: 1037: 1003: 998: 997: 993: 983: 981: 973: 972: 968: 958: 956: 951: 950: 946: 936: 934: 923: 922: 918: 908: 906: 895: 894: 890: 880: 878: 875: 871: 870: 866: 856: 854: 845: 844: 835: 825: 823: 814: 813: 800: 784: 780: 772: 768: 743: 739: 729: 727: 719: 718: 714: 704: 702: 693: 692: 677: 667: 665: 657: 656: 652: 642: 640: 631: 630: 626: 622: 595: 571:Data scientists 568: 562: 519: 514: 498: 492: 484: 475: 470: 450: 402: 362:structured data 354: 334:data warehouses 326: 320: 318:Data warehouses 276: 267: 227: 222: 206:cloud computing 182:data protection 88:and the use of 86:database design 78: 70:data processing 35: 32: 23: 22: 15: 12: 11: 5: 1577: 1575: 1567: 1566: 1561: 1556: 1546: 1545: 1542: 1541: 1536: 1531: 1517: 1516:External links 1514: 1512: 1511: 1508: 1504: 1501: 1494: 1480: 1469: 1462: 1459: 1452: 1448: 1446: 1443: 1441: 1440: 1426: 1400: 1391:|journal= 1340: 1314: 1299: 1274: 1262:Apache Airflow 1246: 1221: 1209:www.redhat.com 1191: 1163: 1135: 1113: 1090: 1061: 1035: 991: 966: 944: 916: 888: 864: 833: 798: 778: 766: 737: 712: 675: 650: 623: 621: 618: 617: 616: 611: 606: 601: 594: 591: 564:Main article: 561: 560:Data scientist 558: 518: 515: 513: 510: 506:abstract model 496:Data modelling 494:Main article: 491: 488: 483: 482:Systems design 480: 474: 471: 469: 466: 449: 446: 445: 444: 433:Object storage 430: 416: 401: 398: 353: 350: 324:Data warehouse 322:Main article: 319: 316: 275: 272: 266: 263: 235:directed graph 226: 223: 221: 218: 174:infrastructure 96:(DBAs) and by 77: 74: 33: 24: 14: 13: 10: 9: 6: 4: 3: 2: 1576: 1565: 1562: 1560: 1557: 1555: 1552: 1551: 1549: 1540: 1537: 1535: 1532: 1530: 1526: 1523: 1520: 1519: 1515: 1509: 1505: 1502: 1499: 1495: 1492: 1488: 1484: 1481: 1478: 1474: 1470: 1467: 1463: 1460: 1457: 1453: 1450: 1449: 1444: 1436: 1430: 1427: 1414: 1410: 1404: 1401: 1396: 1383: 1375: 1371: 1367: 1363: 1359: 1355: 1351: 1344: 1341: 1328: 1324: 1318: 1315: 1310: 1303: 1300: 1288: 1284: 1278: 1275: 1263: 1259: 1253: 1251: 1247: 1235: 1231: 1225: 1222: 1210: 1206: 1200: 1198: 1196: 1192: 1180: 1176: 1170: 1168: 1164: 1152: 1148: 1142: 1140: 1136: 1124: 1117: 1114: 1101: 1094: 1091: 1079: 1078:SIGMOD Record 1072: 1065: 1062: 1046: 1039: 1036: 1031: 1027: 1023: 1019: 1015: 1011: 1010: 1009:IEEE Computer 1002: 995: 992: 980: 976: 970: 967: 954: 948: 945: 933: 932: 927: 920: 917: 904: 900: 892: 889: 874: 868: 865: 853: 849: 842: 840: 838: 834: 822: 818: 815:Dodds, Eric. 811: 809: 807: 805: 803: 799: 795: 791: 787: 782: 779: 776: 770: 767: 763: 759: 755: 751: 747: 741: 738: 726: 722: 716: 713: 701: 697: 690: 688: 686: 684: 682: 680: 676: 664: 660: 654: 651: 638: 634: 628: 625: 619: 615: 612: 610: 607: 605: 602: 600: 597: 596: 592: 590: 588: 584: 580: 576: 572: 567: 559: 557: 555: 551: 547: 543: 539: 535: 531: 528: 524: 523:data engineer 517:Data engineer 516: 511: 509: 507: 503: 497: 490:Data modeling 489: 487: 481: 479: 472: 467: 465: 463: 459: 455: 447: 442: 438: 434: 431: 428: 424: 420: 419:Block storage 417: 414: 411: 410: 409: 407: 399: 397: 395: 391: 387: 383: 379: 375: 371: 367: 363: 359: 351: 349: 347: 343: 339: 335: 331: 325: 317: 315: 313: 309: 305: 301: 297: 293: 289: 285: 281: 273: 271: 264: 262: 260: 256: 252: 248: 244: 243:deep learning 240: 236: 232: 224: 219: 217: 215: 211: 207: 203: 199: 195: 191: 187: 186:cybersecurity 183: 179: 175: 171: 167: 163: 159: 155: 151: 147: 143: 139: 138:data engineer 135: 131: 127: 123: 118: 116: 111: 108: 104: 99: 95: 91: 87: 83: 75: 73: 71: 68:, as well as 67: 63: 59: 55: 51: 47: 43: 39: 30: 19: 1497: 1490: 1483:James Martin 1472: 1465: 1455: 1429: 1417:. Retrieved 1412: 1403: 1382:cite journal 1343: 1331:. Retrieved 1326: 1317: 1308: 1302: 1290:. Retrieved 1286: 1277: 1265:. Retrieved 1261: 1237:. Retrieved 1233: 1224: 1212:. Retrieved 1208: 1182:. Retrieved 1178: 1154:. Retrieved 1150: 1128:February 22, 1126:. Retrieved 1116: 1106:February 22, 1104:. Retrieved 1093: 1083:February 22, 1081:. Retrieved 1077: 1064: 1054:February 22, 1052:. Retrieved 1038: 1016:(2): 12–14. 1013: 1007: 994: 982:. Retrieved 978: 969: 957:. Retrieved 947: 935:. Retrieved 929: 919: 907:. Retrieved 902: 891: 879:. Retrieved 873:"sparkpaper" 867: 855:. Retrieved 851: 824:. Retrieved 820: 793: 786:Terry Halpin 781: 774: 769: 761: 740: 728:. Retrieved 724: 715: 703:. Retrieved 699: 666:. Retrieved 662: 653: 641:. Retrieved 636: 627: 570: 569: 566:Data science 522: 520: 499: 485: 476: 451: 413:File systems 403: 382:public cloud 355: 327: 277: 268: 251:Differential 239:Apache Spark 228: 168:, a type of 165: 144:, Facebook, 137: 119: 112: 81: 79: 54:data science 37: 36: 1489:. (1981). 1151:www.ibm.com 979:ocw.mit.edu 821:Rudderstack 790:Tony Morgan 575:mathematics 423:hard drives 378:binary data 178:warehousing 1548:Categories 852:ACM SIGOPS 730:August 23, 620:References 583:statistics 579:algorithms 502:data model 448:Management 352:Data lakes 348:software. 247:TensorFlow 241:, and the 198:processing 1477:T.W. Olle 1419:March 14, 1366:113342650 931:Microsoft 468:Lifecycle 390:Microsoft 358:data lake 284:databases 274:Databases 245:specific 214:marketing 194:modelling 154:Microsoft 1525:Archived 1333:July 31, 1292:July 31, 1287:Coursera 1267:July 31, 1239:July 31, 1214:July 31, 1184:July 31, 1156:July 31, 1030:26876882 984:July 31, 959:July 31, 937:July 31, 909:July 31, 881:July 31, 857:July 31, 826:July 31, 792:(2010). 705:July 31, 700:QuantHub 668:July 31, 643:July 31, 599:Big data 593:See also 534:insights 527:big data 437:metadata 202:metadata 130:Facebook 126:big data 122:internet 90:software 50:analysis 1507:Kindle. 1374:2762013 458:Airflow 265:Storage 225:Compute 158:Netflix 76:History 66:storage 62:compute 42:systems 1372:  1364:  1258:"Home" 1028:  796:p. 343 758:Part 6 754:part 5 750:part 4 746:part 3 663:Dremio 637:EDUCBA 585:, and 548:, and 542:Python 456:(e.g. 394:Google 386:Amazon 376:, and 312:NewSQL 255:Timely 200:, and 190:mining 156:, and 146:Amazon 142:Google 134:Airbnb 1362:S2CID 1074:(PDF) 1048:(PDF) 1026:S2CID 1004:(PDF) 876:(PDF) 546:Scala 512:Roles 504:, an 406:files 400:Files 392:, or 364:from 300:NoSQL 220:Tools 210:sales 150:Apple 1485:and 1421:2021 1395:help 1370:SSRN 1335:2022 1294:2022 1269:2022 1241:2022 1216:2022 1186:2022 1158:2022 1130:2020 1108:2020 1085:2020 1056:2020 986:2022 961:2022 939:2022 911:2022 883:2022 859:2022 828:2022 732:2022 707:2022 670:2022 645:2022 550:Rust 538:Java 441:UUID 292:ACID 212:and 132:and 64:and 52:and 46:data 1354:doi 1018:doi 530:ETL 425:or 296:SQL 162:ETL 1550:: 1475:. 1411:. 1386:: 1384:}} 1380:{{ 1368:. 1360:. 1325:. 1285:. 1260:. 1249:^ 1232:. 1207:. 1194:^ 1177:. 1166:^ 1149:. 1138:^ 1076:. 1024:. 1014:43 1012:. 1006:. 977:. 928:. 901:. 850:. 836:^ 819:. 801:^ 788:, 756:, 752:, 748:, 723:. 698:. 678:^ 661:. 635:. 589:. 581:, 577:, 556:. 544:, 540:, 521:A 464:. 396:. 388:, 372:, 368:, 356:A 196:, 192:, 188:, 184:, 180:, 176:, 152:, 148:, 72:. 1423:. 1397:) 1393:( 1376:. 1356:: 1337:. 1311:. 1296:. 1271:. 1243:. 1218:. 1188:. 1160:. 1132:. 1110:. 1087:. 1058:. 1032:. 1020:: 988:. 963:. 941:. 913:. 885:. 861:. 830:. 734:. 709:. 672:. 647:. 443:. 429:. 253:/ 31:. 20:)

Index

Information technology engineering
Information Engineering
systems
data
analysis
data science
machine learning
compute
storage
data processing
database design
software
database administrators
systems analysts
Clive Finkelstein
Savant Institute
information technology
internet
big data
Facebook
Airbnb
Google
Amazon
Apple
Microsoft
Netflix
ETL
software engineering
infrastructure
warehousing

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.