{"id":77180,"date":"2020-04-08T13:42:32","date_gmt":"2020-04-08T11:42:32","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya"},"modified":"2020-04-08T13:42:32","modified_gmt":"2020-04-08T11:42:32","slug":"testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","title":{"rendered":"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Salut tuturor, numele meu este Alexander \u0219i sunt inginer \u00een calitatea datelor, ocup\u00e2ndu-m\u0103 cu verificarea calit\u0103\u021bii datelor. \u00cen acest articol voi vorbi despre cum am ajuns aici \u0219i de ce, \u00een 2020, aceast\u0103 direc\u021bie de testare s-a dovedit a fi pe val. <\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/0691d5a78bcbc8f4f102eafbbef20c0a.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Tendin\u021ba global\u0103 <\/h2>\n<p>\nLumea de ast\u0103zi tr\u0103ie\u0219te o nou\u0103 revolu\u021bie tehnologic\u0103, unul dintre aspectele c\u0103reia este utilizarea de c\u0103tre diverse companii a datelor acumulate pentru a-\u0219i impulsiona v\u00e2nz\u0103rile, profiturile \u0219i imaginea public\u0103. Se pare c\u0103 dispunerea de date de calitate \u0219i de min\u021bi capabile s\u0103 transforme aceste date \u00een bani (prin procesare corect\u0103, vizualizare, construirea de modele de \u00eenv\u0103\u021bare automat\u0103 etc.) a devenit cheia succesului pentru multe dintre acestea. Dac\u0103 acum 15-20 de ani, lucrul intens cu acumularea \u0219i monetizarea datelor era apanajul \u00een principal al companiilor mari, ast\u0103zi aceasta este o preocupare comun\u0103 pentru aproape to\u021bi cei care g\u00e2ndesc ra\u021bional. <\/p>\n<p>\u00cen acest context, acum c\u00e2\u021biva ani, toate portalurile dedicate c\u0103ut\u0103rii de locuri de munc\u0103 din \u00eentreaga lume au fost inundate cu anun\u021buri pentru Data Scientists, deoarece toat\u0103 lumea era convins\u0103 c\u0103, angaj\u00e2nd un astfel de specialist, se poate construi un supermodel de \u00eenv\u0103\u021bare automat\u0103, prezic\u00e2nd viitorul \u0219i realiz\u00e2nd un 'salt cuantic' pentru companie. Cu timpul, oamenii au \u00een\u021beles c\u0103 aceast\u0103 abordare func\u021bioneaz\u0103 foarte rar, deoarece nu toate datele care ajung \u00een m\u00e2inile acestor speciali\u0219ti sunt adecvate pentru antrenarea modelelor. <\/p>\n<p>\u0218i au \u00eenceput cererile din partea Data Scientists: \u201eS\u0103 cump\u0103r\u0103m mai multe date de la ace\u0219tia \u0219i aceia...\u201d, \u201eNe lipsesc datele...\u201d, \u201eAvem nevoie de pu\u021bin mai multe date, iar acestea trebuie s\u0103 fie de calitate...\u201d. Pe baza acestor cereri, s-au construit numeroase interac\u021biuni \u00eentre companiile care de\u021bin diverse seturi de date. Fire\u0219te, aceasta a necesitat o organizare tehnic\u0103 a procesului \u2014 conectare la sursa de date, extragerea acestora, verificarea c\u0103 au fost \u00eenc\u0103rcate complet etc. Num\u0103rul acestor procese a crescut, iar \u00een prezent avem o cerere uria\u0219\u0103 pentru alt tip de speciali\u0219ti \u2014 inginerii de Data Quality \u2014 cei care monitorizau fluxul de date \u00een sistem (data pipelines), calitatea datelor la intrare \u0219i ie\u0219ire, \u0219i tr\u0103geau concluzii despre suficien\u021ba, integritatea \u0219i alte caracteristici ale acestora. <\/p>\n<p>Trendul inginerilor de Data Quality a venit la noi din SUA, unde, \u00een plina er\u0103 a capitalismului, nimeni nu este dispus s\u0103 piard\u0103 b\u0103t\u0103lia pentru date. Mai jos am inclus capturi de ecran de pe dou\u0103 dintre cele mai populare site-uri de c\u0103utare a locurilor de munc\u0103 din SUA: <noindex><a rel=\"nofollow\" href=\"https:\/\/www.monster.com\">www.monster.com<\/a><\/noindex> \u0219i <noindex><a rel=\"nofollow\" href=\"https:\/\/www.dice.com\">www.dice.com<\/a><\/noindex> \u2014 pe care sunt afi\u0219ate datele la 17 martie 2020 despre num\u0103rul locurilor de munc\u0103 publicate, ob\u021binute folosind cuvintele cheie: Data Quality \u0219i Data Scientist. <\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.monster.com\">www.monster.com<\/a><\/noindex><\/p>\n<p>Data Scientists \u2013 21416 locuri de munc\u0103<br \/>\nData Quality \u2013 41104 locuri de munc\u0103<\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/8578f2d1e600791e166ed6e8a7068015.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/3ff69acc3c7e0d649eae0808b1b535be.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.dice.com\">www.dice.com<\/a><\/noindex> <\/p>\n<p>Data Scientists \u2013 404 locuri de munc\u0103<br \/>\nData Quality \u2013 2020 locuri de munc\u0103<\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/b35a9b423ba4bef8736659580e3c281e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/2c29b83bbe2361089de5a0ab65017300.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>\nEste evident c\u0103 aceste profesii nu concurent \u00eentre ele. Capturile de ecran le-am folosit doar pentru a ilustra situa\u021bia actual\u0103 pe pia\u021ba muncii \u00een ceea ce prive\u0219te cererea pentru inginerii de Data Quality, care sunt acum solicita\u021bi mult mai mult dec\u00e2t Data Scientists. <\/p>\n<p>\u00cen iunie 2019, EPAM, r\u0103spunz\u00e2nd nevoilor pie\u021bei IT moderne, a \u00eenfiin\u021bat Data Quality ca o practic\u0103 separat\u0103. Inginerii de Data Quality, \u00een cadrul activit\u0103\u021bii lor zilnice, gestioneaz\u0103 datele, verific\u0103 comportamentul acestora \u00een condi\u021bii \u0219i sisteme noi, monitorizeaz\u0103 relevan\u021ba, suficien\u021ba \u0219i actualitatea datelor. \u00cen acela\u0219i timp, \u00een practic\u0103, inginerii de Data Quality dedic\u0103 \u00eentr-adev\u0103r pu\u021bin timp test\u0103rii func\u021bionale clasice, <u>DAR<\/u> asta depinde foarte mult de proiect (exemplul \u00eel voi oferi mai departe). <\/p>\n<p>Responsabilit\u0103\u021bile inginerului de Data Quality nu se limiteaz\u0103 doar la verific\u0103ri manuale\/automate de rutin\u0103 pentru \u201enulls, count \u0219i sums\u201d \u00een tabelele DB, ci necesit\u0103 o \u00een\u021belegere profund\u0103 a nevoilor de afaceri ale clientului \u0219i, \u00een consecin\u021b\u0103, capacitatea de a transforma datele disponibile \u00een informa\u021bii de afaceri utile. <\/p>\n<h2>Teoria Data Quality<\/h2>\n<p>\n<img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/d920a7a0435d6f3a1eb84fc16221c742.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Pentru a \u00een\u021belege pe deplin rolul unui astfel de inginer, haide\u021bi s\u0103 analiz\u0103m ce reprezint\u0103 Data Quality \u00een teorie. <\/p>\n<p><b>Data Quality<\/b> \u2014 este unul dintre pa\u0219ii din Data Management (o lume \u00eentreag\u0103, pe care o vom l\u0103sa pentru studiu individual) \u0219i r\u0103spunde de analiza datelor dup\u0103 urm\u0103toarele criterii: <\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/8f5e75bad69e3cb589cc0e1104ad946f.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nCred c\u0103 nu are sens s\u0103 explic fiecare dintre punctele (teoretic denumite \u201edimensiuni de date\u201d), ele sunt descrise destul de bine \u00een imagine. Totu\u0219i, procesul de testare nu implic\u0103 copierea strict\u0103 a acestor atribute \u00een cazurile de testare \u0219i verificarea lor. \u00cen Calitatea Datelor, ca \u0219i \u00een orice alt tip de testare, trebuie s\u0103 ne baz\u0103m mai \u00eent\u00e2i pe cerin\u021bele de calitate a datelor, convenite cu participan\u021bii la proiect, care iau decizii de afaceri. <\/p>\n<p><\/p>\n<blockquote><p>\u00cen func\u021bie de proiect, un inginer de Calitate a Datelor poate \u00eendeplini diferite func\u021bii: de la un simplu testator automatizat cu o evaluare superficial\u0103 a calit\u0103\u021bii datelor, p\u00e2n\u0103 la o persoan\u0103 care realizeaz\u0103 profilarea lor detaliat\u0103 pe baza caracteristicilor men\u021bionate mai sus. <\/p><\/blockquote>\n<p>O descriere foarte detaliat\u0103 a proceselor de Management al Datelor, Calitate a Datelor \u0219i domenii conexe este excelent prezentat\u0103 \u00een cartea intitulat\u0103 <i>\u201eDAMA-DMBOK: Data Management Body of Knowledge: 2nd Edition\u201d<\/i>. Recomand cu c\u0103ldur\u0103 aceast\u0103 carte ca o introducere \u00een acest domeniu (linkul c\u0103tre ea \u00eel ve\u021bi g\u0103si la sf\u00e2r\u0219itul articolului).<\/p>\n<h2>Povestea mea<\/h2>\n<p>\n\u00cen industria IT, am parcurs un drum de la Junior tester \u00een companii de produse p\u00e2n\u0103 la Lead Data Quality Engineer \u00een compania EPAM. Dup\u0103 aproximativ doi ani de munc\u0103 ca tester, eram ferm convins c\u0103 am realizat absolut toate tipurile de testare: regresiv\u0103, func\u021bional\u0103, de stres, de stabilitate, de securitate, UI etc. \u2014 \u0219i am experimentat o mul\u021bime de instrumente de testare, lucr\u00e2nd totodat\u0103 \u00een trei limbaje de programare: Java, Scala, Python. <\/p>\n<p><\/p>\n<blockquote><p>Privind \u00eenapoi, \u00een\u021beleg de ce setul meu de abilit\u0103\u021bi profesionale a fost at\u00e2t de divers \u2014 am participat la proiecte legate de manipularea datelor, mari \u0219i mici. Acest lucru m-a adus \u00eentr-o lume plin\u0103 de instrumente \u0219i oportunit\u0103\u021bi de cre\u0219tere.<\/p><\/blockquote>\n<p>Pentru a aprecia diversitatea instrumentelor \u0219i posibilit\u0103\u021bile de a ob\u021bine noi cuno\u0219tin\u021be \u0219i abilit\u0103\u021bi, este suficient s\u0103 ne uit\u0103m la imaginea de mai jos, care prezint\u0103 cele mai populare dintre ele \u00een domeniul \u201eDate \u0219i AI\u201d.<\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/e3278694195bf59b44055e1eaafd62b1.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nAstfel de ilustra\u021bii sunt realizate anual de c\u0103tre unul dintre cunoscu\u021bii investitori de capital de risc, Matt Turck, venit din domeniul dezvolt\u0103rii de software. Iat\u0103 <noindex><a rel=\"nofollow\" href=\"https:\/\/mattturck.com\">linkul<\/a><\/noindex> blogul s\u0103u \u0219i <noindex><a rel=\"nofollow\" href=\"https:\/\/firstmarkcap.com\/team\/matt-turck\">firma de capital de risc<\/a><\/noindex>, unde lucreaz\u0103 ca partener. <\/p>\n<p>Am crescut profesional extrem de rapid atunci c\u00e2nd am fost singurul tester al proiectului, sau cel pu\u021bin \u00een primele etape ale acestuia. \u00centr-un astfel de moment, trebuie s\u0103 r\u0103spunzi de \u00eentregul proces de testare, iar op\u021biunea de a te retrage nu exist\u0103, trebuie s\u0103 mergi \u00eenainte. La \u00eenceput, acest lucru era \u00eenfrico\u0219\u0103tor, dar acum \u00eemi sunt evidente toate avantajele acestei experien\u021be: <\/p>\n<ul>\n<li>\u00cencepi s\u0103 comunici cu \u00eentreaga echip\u0103 cum nu ai f\u0103cut-o niciodat\u0103, deoarece nu exist\u0103 un intermediar pentru comunicare: nici manager de teste, nici colegi testeri. <\/li>\n<li>Imersiunea \u00een proiect devine incredibil de profund\u0103, iar tu de\u021bii informa\u021bii despre toate componentele at\u00e2t \u00een general, c\u00e2t \u0219i \u00een detaliu. <\/li>\n<li>Dezvoltatorii nu te privesc ca pe \u00abtipul din testare care face ceva neclar\u00bb, ci mai degrab\u0103 ca pe un egal, care aduce o valoare incredibil\u0103 echipei prin testele sale automate \u0219i previziunea apari\u021biei bug-urilor \u00een anumite p\u0103r\u021bi ale produsului. <\/li>\n<li>Ca rezultat \u2014 e\u0219ti mai eficient, mai calificat, mai c\u0103utat. <\/li>\n<\/ul>\n<p>\nPe m\u0103sur\u0103 ce proiectul se dezvolta, \u00een 100% din cazuri deveneam mentor pentru noii testeri care se al\u0103turau, \u00eei \u00eenv\u0103\u021bam \u0219i le ofeream cuno\u0219tin\u021bele pe care le acumulasem. Totu\u0219i, \u00een func\u021bie de proiect, nu primeam \u00eentotdeauna resurse de \u00eenalt\u0103 calitate pentru automatizarea test\u0103rii \u0219i era necesar fie s\u0103 \u00eei \u00eenv\u0103\u021b automatizarea (pentru cei interesa\u021bi), fie s\u0103 creez instrumente pentru utilizarea acestora \u00een activit\u0103\u021bile lor zilnice (instrumente de generare a datelor \u0219i \u00eenc\u0103rcarea acestora \u00een sistem, instrument pentru testare de stres\/testare a stabilit\u0103\u021bii \u201epe rapid\u201d etc.). <\/p>\n<h3>Exemplu de proiect concret<\/h3>\n<p>\nDin p\u0103cate, din cauza obliga\u021biilor de confiden\u021bialitate, nu pot oferi detalii despre proiectele la care am lucrat, totu\u0219i voi da exemple de sarcini tipice pentru un Data Quality Engineer \u00eentr-unul din proiecte. <\/p>\n<p>Scopul proiectului era s\u0103 implement\u0103m o platform\u0103 pentru preg\u0103tirea datelor folosite \u00een antrenarea modelelor de \u00eenv\u0103\u021bare automat\u0103. Clientul era o mare companie farmaceutic\u0103 din SUA. Tehnic, acesta era un cluster <noindex><a rel=\"nofollow\" href=\"https:\/\/kubernetes.io\">Kubernetes<\/a><\/noindex>, ridicat pe <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/ec2\">AWS EC2<\/a><\/noindex> instan\u021be, cu mai multe microservicii \u0219i bazat pe proiectul Open Source al companiei EPAM \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/legion-platform\/legion\">Legion<\/a><\/noindex>, adaptat nevoilor specifice ale clientului (\u00een prezent, proiectul a fost transformat \u00een <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/odahu\/odahu-flow\">odahu<\/a><\/noindex>). Procesele ETL au fost organizate cu ajutorul <noindex><a rel=\"nofollow\" href=\"https:\/\/airflow.apache.org\">Apache Airflow<\/a><\/noindex> \u0219i au mutat datele din <noindex><a rel=\"nofollow\" href=\"https:\/\/www.salesforce.com\">SalesForce<\/a><\/noindex> sistemul clientului \u00een <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/s3\/?nc1=h_ls\">AWS S3<\/a><\/noindex> Buckets. Apoi, pe platform\u0103 a fost depus un container Docker al modelului de \u00eenv\u0103\u021bare automat\u0103, care a fost antrenat pe date recente \u0219i prin intermediul interfe\u021bei API REST a furnizat predic\u021bii relevante pentru afacere \u0219i care rezolv\u0103 sarcini concrete. <\/p>\n<p><b>Vizual, totul ar\u0103ta cam a\u0219a: <\/b><\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/c2de3c1919f3f9ff29147fce09eb14c4.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nTestarea func\u021bional\u0103 a acestui proiect a fost abundent\u0103, av\u00e2nd \u00een vedere viteza de dezvoltare a func\u021bionalit\u0103\u021bilor \u0219i necesitatea de a men\u021bine rapiditatea ciclului de lansare (sprinturi de dou\u0103 s\u0103pt\u0103m\u00e2ni), a fost esen\u021bial s\u0103 ne g\u00e2ndim din timp la automatizarea test\u0103rii celor mai critici noduri ale sistemului. O mare parte din platform\u0103, bazat\u0103 pe Kubernetes, era acoperit\u0103 de teste automate, implementate pe <noindex><a rel=\"nofollow\" href=\"https:\/\/robotframework.org\/\">Robot Framework<\/a><\/noindex> + Python, dar era necesar s\u0103 le men\u021binem \u0219i s\u0103 le extindem. \u00cen plus, pentru confortul clientului, a fost creat un GUI pentru gestionarea modelelor de \u00eenv\u0103\u021bare automat\u0103, desf\u0103\u0219urate pe cluster, precum \u0219i posibilitatea de a specifica de unde \u0219i unde trebuie mutate datele pentru antrenarea modelelor. Aceast\u0103 extensie ampl\u0103 a dus la extinderea verific\u0103rilor func\u021bionale automatizate, care au fost realizate \u00een mare parte prin apeluri API REST \u0219i un num\u0103r mic de teste UI end-to-end. Aproximativ la mijlocul acestui proces, s-a al\u0103turat un tester manual care s-a descurcat excelent cu testarea de acceptare a versiunilor produsului \u0219i cu comunicarea cu clientul \u00een leg\u0103tur\u0103 cu acceptarea noului release. \u00cen plus, datorit\u0103 apari\u021biei noului specialist, am reu\u0219it s\u0103 document\u0103m munca noastr\u0103 \u0219i s\u0103 ad\u0103ug\u0103m c\u00e2teva verific\u0103ri manuale foarte importante, care au fost greu de automatizat imediat. <\/p>\n<p>\u0218i, \u00een sf\u00e2r\u0219it, dup\u0103 ce am ob\u021binut stabilitate de la platform\u0103 \u0219i un GUI construit pe aceasta, am \u00eenceput s\u0103 construim pipelines ETL folosind Apache Airflow DAG-uri. Verificarea automatizat\u0103 a calit\u0103\u021bii datelor a fost realizat\u0103 prin scrierea unor DAG-uri Airflow speciale care verificau datele \u00een func\u021bie de rezultatele procesului ETL. \u00cen cadrul acestui proiect am avut noroc, iar clientul ne-a oferit acces la seturi de date anonimizate, pe care am efectuat testele. Am verificat datele, linie cu linie, pentru conformitatea cu tipurile, existen\u021ba datelor corupte, num\u0103rul total de \u00eenregistr\u0103ri \u00eenainte \u0219i dup\u0103, compararea transform\u0103rilor efectuate de procesul ETL \u00een ceea ce prive\u0219te agregarea, schimbarea denumirilor coloanelor \u0219i altele. \u00cen plus, aceste verific\u0103ri au fost amplificate pe diferite surse de date, de exemplu, pe l\u00e2ng\u0103 Salesforce \u0219i pe MySQL. <\/p>\n<p>Verific\u0103rile calit\u0103\u021bii finale a datelor au fost efectuate deja la nivelul S3, unde acestea erau stocate \u0219i erau \u00een stare ready-to-use pentru antrenarea modelelor de \u00eenv\u0103\u021bare automat\u0103. Pentru a ob\u021bine datele din fi\u0219ierul CSV final, aflat pe S3 Bucket, \u0219i pentru validarea acestora, a fost scris un cod folosind <noindex><a rel=\"nofollow\" href=\"https:\/\/aws.amazon.com\/ru\/sdk-for-python\">clientul boto3<\/a><\/noindex>. <\/p>\n<p>De asemenea, din partea clientului a fost o cerin\u021b\u0103 de a stoca o parte din date \u00eentr-un S3 Bucket \u0219i o alt\u0103 parte \u00een altul. Pentru aceasta, a fost necesar s\u0103 scriem verific\u0103ri suplimentare care s\u0103 controleze validitatea unei astfel de sort\u0103ri. <\/p>\n<h3>Experien\u021ba generalizat\u0103 din alte proiecte<\/h3>\n<p>\nExemplul celei mai generalizate liste de activit\u0103\u021bi ale unui inginer de calitate a datelor: <\/p>\n<ul>\n<li>Preg\u0103tirea datelor de test (valide\/nevalide, mari\/mici) printr-un instrument automatizat. <\/li>\n<li>\u00cenc\u0103rcarea setului de date preg\u0103tit \u00een sursa ini\u021bial\u0103 \u0219i verificarea preg\u0103tirii acestuia pentru utilizare. <\/li>\n<li>Lansarea proceselor ETL pentru procesarea setului de date din depozitul ini\u021bial \u00een cel final sau intermediar, folosind un anumit set de configura\u021bii (\u00een cazul \u00een care este posibil s\u0103 stabili\u021bi parametrii configurabili pentru sarcina ETL). <\/li>\n<li>Verificarea datelor procesate de procesul ETL pentru calitatea \u0219i conformitatea lor cu cerin\u021bele de business. <\/li>\n<\/ul>\n<p>\nAccentuarea verific\u0103rilor ar trebui s\u0103 nu se concentreze doar pe faptul c\u0103 fluxul de date \u00een sistem a func\u021bionat \u00een general \u0219i a ajuns la final (ceea ce face parte din testarea func\u021bional\u0103), ci, mai ales, pe verificarea \u0219i validarea datelor pentru a se asigura c\u0103 acestea corespund cerin\u021belor a\u0219teptate, identific\u00e2nd anomalii \u0219i altele. <\/p>\n<h3>Instrumente<\/h3>\n<p>\nUna dintre tehnicile de control al datelor poate fi organizarea de verific\u0103ri \u00een lan\u021b la fiecare etap\u0103 a proces\u0103rii datelor, a\u0219a cum se nume\u0219te \u00een literatur\u0103 \u201edata chain\u201d \u2014 controlul datelor de la surs\u0103 p\u00e2n\u0103 la punctul final de utilizare. Astfel de verific\u0103ri sunt, de obicei, implementate prin scrierea de interog\u0103ri SQL de verificare. Este evident c\u0103 aceste interog\u0103ri trebuie s\u0103 fie c\u00e2t mai u\u0219oare \u0219i s\u0103 verifice buc\u0103\u021bi separate de calitate a datelor (metadatele tabelelor, linii goale, NULL-uri, erori de sintax\u0103 \u2014 alte atribute cerute de verificare). <\/p>\n<p>\u00cen cazul test\u0103rii de regresie, unde se folosesc seturi de date gata preg\u0103tite (nemodificabile sau modificate nesemnificativ), \u00een codul testelor automate pot fi stocate deja \u0219abloane pentru verificarea datelor \u00een conformitate cu calitatea (descrieri ale metadatelor a\u0219teptate ale tabelelor; obiecte de selec\u021bie ale liniilor care pot fi selectate aleatoriu \u00een timpul testului \u0219i altele). <\/p>\n<p>De asemenea, \u00een timpul test\u0103rii este necesar s\u0103 se scrie procese ETL de testare, folosind cadre precum Apache Airflow, <noindex><a rel=\"nofollow\" href=\"https:\/\/spark.apache.org\/\">Apache Spark<\/a><\/noindex> sau complet instrumente black-box de tip cloud, cum ar fi <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/dataprep\">GCP Dataprep<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/dataflow\">GCP Dataflow<\/a><\/noindex> \u0219i altele. Aceast\u0103 circumstan\u021b\u0103 oblig\u0103 inginerul de teste s\u0103 se familiarizeze cu principiile de func\u021bionare ale instrumentelor men\u021bionate mai sus \u0219i s\u0103 efectueze testarea func\u021bional\u0103 mai eficient (de exemplu, a proceselor ETL existente \u00een proiect), precum \u0219i s\u0103 le foloseasc\u0103 pentru verificarea datelor. \u00cen special, pentru Apache Airflow exist\u0103 deja operatori gata preg\u0103ti\u021bi pentru a lucra cu baze de date analitice populare, cum ar fi <noindex><a rel=\"nofollow\" href=\"https:\/\/cloud.google.com\/bigquery\">GCP BigQuery<\/a><\/noindex>. Cel mai simplu exemplu al utiliz\u0103rii sale a fost deja prezentat <noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@yuu.ishikawa\/apache-airflow-as-a-data-quality-checker-416ca7f5a3ad\">aici<\/a><\/noindex>, a\u0219a c\u0103 nu voi repeta. <\/p>\n<p>Pe l\u00e2ng\u0103 solu\u021biile gata preg\u0103tite, nimeni nu v\u0103 interzice s\u0103 implementa\u021bi propriile tehnici \u0219i instrumente. Acest lucru nu va aduce doar beneficii proiectului, ci \u0219i inginerului de calitate a datelor, care astfel \u00ee\u0219i va \u00eembun\u0103t\u0103\u021bi orizontul tehnic \u0219i abilit\u0103\u021bile de programare. <\/p>\n<h3>Cum func\u021bioneaz\u0103 acest lucru \u00eentr-un proiect real<\/h3>\n<p>\nO ilustrare bun\u0103 a ultimelor paragrafe despre \u201edata chain\u201d, ETL \u0219i verific\u0103rile omniprezente este urm\u0103torul proces din unul dintre proiectele reale: <\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/4a4cd3043b584bb3fbce4b9c3021e9f6.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nAici, \u00een \u00abfunnel\u00bb-ul de intrare al sistemului nostru ajung diferite date (bine\u00een\u021beles, preg\u0103tite de noi): valide, invalide, mixte etc., apoi acestea sunt filtrate \u0219i ajung \u00eentr-un depozit intermediar, dup\u0103 care urmeaz\u0103 o nou\u0103 serie de transform\u0103ri \u0219i se vor plasa \u00een depozitul final, din care, la r\u00e2ndul s\u0103u, se va realiza analiza, construirea vitrinelor de date \u0219i c\u0103utarea insight-urilor de business. \u00centr-un astfel de sistem, f\u0103r\u0103 a verifica func\u021bionalitatea proceselor ETL, ne concentr\u0103m pe calitatea datelor \u00eenainte \u0219i dup\u0103 transform\u0103ri, precum \u0219i pe ie\u0219irea \u00een analiz\u0103. <\/p>\n<p>Rezum\u00e2nd cele spuse anterior, indiferent de locurile \u00een care am lucrat, am fost implicat \u00een proiecte de Data care au avut urm\u0103toarele tr\u0103s\u0103turi: <\/p>\n<ul>\n<li>Numai prin automatizare se pot verifica anumite cazuri \u0219i atinge un ciclu de lansare acceptabil pentru afaceri. <\/li>\n<li>Testerul \u00eentr-un astfel de proiect este unul dintre cei mai respecta\u021bi membri ai echipei, deoarece aduce o valoare enorm\u0103 fiec\u0103rui participant (accelerarea test\u0103rii, date bune pentru Data Scientist, identificarea defectelor \u00een etapele timpurii). <\/li>\n<li>Nu conteaz\u0103 dac\u0103 lucrezi pe propria ta echip\u0103 sau \u00een cloud - toate resursele sunt abstractizate \u00eentr-un cluster de tip Hortonworks, Cloudera, Mesos, Kubernetes etc. <\/li>\n<li>Proiectele sunt construite pe un model de microservicii, predomin\u00e2nd calculul distribuit \u0219i paralel. <\/li>\n<\/ul>\n<p>\nVoi sublinia c\u0103, implic\u00e2ndu-m\u0103 \u00een testarea calit\u0103\u021bii datelor, specialistul \u00een testare \u00ee\u0219i mut\u0103 accentul profesional pe codul produsului \u0219i instrumentele utilizate. <\/p>\n<h3>Tr\u0103s\u0103turile distinctive ale test\u0103rii calit\u0103\u021bii datelor<\/h3>\n<p>\n\u00cen plus, pentru mine, am identificat urm\u0103toarele (imediat men\u021bionez FOARTE generalizate \u0219i exclusiv subiective) tr\u0103s\u0103turi distinctive ale test\u0103rii \u00een proiectele de Data (Big Data) \u0219i alte domenii: <\/p>\n<p><img decoding=\"async\" alt=\"Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea\" src=\"\/wp-content\/uploads\/2020\/04\/8df52fbae2998e70755bf84e254db83e.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<h2>Linkuri utile<\/h2>\n<p><\/p>\n<ol>\n<li>Teorie: <noindex><a rel=\"nofollow\" href=\"https:\/\/www.amazon.com\/DAMA-DMBOK-Data-Management-Body-Knowledge\/dp\/1634622340\">DAMA-DMBOK: Data Management Body of Knowledge: edi\u021bia a 2-a<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/training.ru\/#!\/Home?lang=ru\">Centrul de formare<\/a><\/noindex>&nbsp;EPAM&nbsp;<\/li>\n<li>Materiale recomandate pentru un inginer Data Quality \u00eencep\u0103tor:\n<ol>\n<li>Curs gratuit pe Stepik:&nbsp;<noindex><a rel=\"nofollow\" href=\"https:\/\/stepik.org\/course\/551\/syllabus\">Introducere \u00een bazele de date<\/a><\/noindex>.&nbsp;<\/li>\n<li>Curs pe LinkedIn Learning:&nbsp;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.linkedin.com\/learning\/data-science-foundations-data-engineering\/welcome\">Fundamentele Data Science: Inginerie de date<\/a><\/noindex>.<\/li>\n<li>Articole:\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.stickyminds.com\/article\/business-intelligence-and-data-quality\">Inteligen\u021ba de afaceri \u0219i calitatea datelor<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.datagaps.com\/concepts\/etl-testing\">Testarea ETL<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/panoply.io\/analytics-stack-guide\/data-profiling-best-practices\">Ce este Profilarea Datelor? Proces, cele mai bune practici \u0219i instrumente<\/a><\/noindex>;&nbsp;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.guru99.com\/software-testing-test-data.html\">Generarea Datelor de Test: Ce este, Cum se face, Exemplu, Instrumente;&nbsp;<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.testbytes.net\/blog\/5-test-data-generation-techniques-to-know\">5 tehnici de generare a datelor de test pe care trebuie s\u0103 le cuno\u0219ti.<\/a><\/noindex>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<li>Video:\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=HWaBdqmTqEA\">Conceptualizarea calit\u0103\u021bii datelor | Tutorial despre calitatea datelor | Tutorial despre depozitarea datelor<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=avDqzhuHFkw\">Profilarea datelor utiliz\u00e2nd SSIS<\/a><\/noindex>;<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=r7SF5WldITk\">Profilarea Datelor \u0219i Procesarea Pipeline-ului cu Spark.<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><\/p>\n<h2>Concluzie<\/h2>\n<p>\n<b>Data Quality<\/b> \u2014 este un domeniu foarte t\u00e2n\u0103r \u0219i promi\u021b\u0103tor, a c\u0103rui apartenen\u021b\u0103 \u00eenseamn\u0103 a fi parte dintr-un start-up. Intra\u021bi \u00een domeniul Calit\u0103\u021bii Datelor \u0219i v\u0103 ve\u021bi scufunda \u00eentr-o multitudine de tehnologii moderne foarte c\u0103utate, dar cel mai important \u2014 \u00eenaintea dumneavoastr\u0103 se vor deschide oportunit\u0103\u021bi enorme pentru generarea \u0219i implementarea propriilor idei. Ve\u021bi putea aplica o abordare de \u00eembun\u0103t\u0103\u021bire continu\u0103 nu doar \u00een proiect, ci \u0219i pentru propria dezvoltare ca specialist.<br \/>\n<br \/>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/epam_systems\/blog\/495478\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u0440\u0435\u0447\u044c \u043f\u043e\u0439\u0434\u0451\u0442 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u044f \u043a \u044d\u0442\u043e\u043c\u0443 \u043f\u0440\u0438\u0448\u0451\u043b \u0438 \u043f\u043e\u0447\u0435\u043c\u0443 \u0432 2020 \u0433\u043e\u0434\u0443 \u044d\u0442\u043e \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u043d\u0430 \u0433\u0440\u0435\u0431\u043d\u0435 \u0432\u043e\u043b\u043d\u044b. \u041c\u0438\u0440\u043e\u0432\u043e\u0439 \u0442\u0440\u0435\u043d\u0434 \u0421\u0435\u0433\u043e\u0434\u043d\u044f\u0448\u043d\u0438\u0439 \u043c\u0438\u0440 \u043f\u0435\u0440\u0435\u0436\u0438\u0432\u0430\u0435\u0442 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u0443\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0440\u0435\u0432\u043e\u043b\u044e\u0446\u0438\u044e, \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u0430\u0441\u043f\u0435\u043a\u0442\u043e\u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":77181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-77180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445: \u0442\u0440\u0435\u043d\u0434\u044b, \u0442\u0435\u043e\u0440\u0438\u044f, \u043c\u043e\u044f \u0438\u0441\u0442\u043e\u0440\u0438\u044f | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-04-08T11:42:32+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-08T11:42:32+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Tester de date mari \u0219i mici: tendin\u021be, teorie, povestea mea | ProHoster","description":"Bun\u0103 ziua, numele meu este Alexandru, \u0219i sunt inginer de Calitate a Datelor, responsabil cu verificarea calit\u0103\u021bii datelor.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445: \u0442\u0440\u0435\u043d\u0434\u044b, \u0442\u0435\u043e\u0440\u0438\u044f, \u043c\u043e\u044f \u0438\u0441\u0442\u043e\u0440\u0438\u044f | ProHoster","og:description":"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440, \u0438 \u044f Data Quality \u0438\u043d\u0436\u0435\u043d\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u043f\u0440\u0435\u0434\u043c\u0435\u0442 \u0438\u0445 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0430.","og:url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/testirovshhik-bolshih-i-malenkih-dannyh-trendy-teoriya-moya-istoriya","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-04-08T11:42:32+00:00","article:modified_time":"2020-04-08T11:42:32+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"77180","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 17:22:32","updated":"2022-10-03 00:36:00","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/77180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=77180"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/77180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/77181"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=77180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=77180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=77180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}