{"id":91148,"date":"2020-08-09T01:42:48","date_gmt":"2020-08-08T23:42:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti"},"modified":"2020-08-09T01:42:48","modified_gmt":"2020-08-08T23:42:48","slug":"moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","title":{"rendered":"Minu soovid tuleviku andmebaasidele ning Rosreestrile seoses tehingute tegemisega","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"Minu
\nKliendi vahel on andmebaasiga suhtlemine.
\nSaidilt http:\/\/corchaosis.ru<\/a><\/noindex>, pildi autor Jonathan Tiong.<\/p>\n

Peale selle, et ma olen programmeerija (peamiselt Delphi + erinevad andmebaasid, viimase ajal ORACLE ja natuke PHP), on mul hobi \u2014 korterite ostmine ja m\u00fc\u00fcmine. Ostsin korteri ehitusetapis usaldusv\u00e4\u00e4rselt arendajalt hea hinnaga (n\u00e4iteks hetkel on selline arendaja Samolot, korterid m. Nekrasovka l\u00e4hedal m\u00fc\u00fcakse), ootan maja valmimist (tihti hiljem kaks aastat, odavate pakkumiste puhul juhtub see), teen seal remonti ja m\u00fc\u00fcn selle siis 95-100% turuhinnast.<\/p>\n

Nii et, ma (nagu k\u00f5ik teised) sain hakkama probleemiga, et Rosreestrilt puudus tehingute tegemise v\u00f5imalus.<\/p>\n

Rosreestri tehingute puudulikkuse probleem<\/b><\/p>\n

Programmeeringus on \u00abTehing\u00bb, kinnisvaras aga \u00abTehing alternatiiviga\u00bb (ja samuti, kui osa sellest, \u00abPankadeeninduse leping\u00bb), ja seal on k\u00f5ik pisut keerulisem. R\u00e4\u00e4gin l\u00e4hemalt.<\/p>\n

Vasia tuli vaatama korterit, mida m\u00fc\u00fcb Petja. Ja Vasile meeldis k\u00f5ik v\u00e4ga, sealhulgas hind, kuid tal ei ole raha. Nii algab meie lugu.<\/a><\/noindex><\/p>\n

Vasily omab oma kinnisvara, mis sisaldab m\u00f5ningaid tema jaoks mitte eriti v\u00e4\u00e4rtuslikke asju \u2014 naabermajades elas Lomonossov, lagi on seitse ja pool meetrit k\u00f5rge, l\u00e4heduses asub puu- ja k\u00f6\u00f6giviljabaas ning S\u00f5numite turg, Aeroexpressile on jala minna ning korteri all on \u00fcks meeter k\u00f5rge keldri osa, \u00fclal on p\u00f6\u00f6ning, mis on mugav astronoomiliste vaatluste jaoks. Vasily m\u00f5istab, et need omadused t\u00f5stavad tema korteri hinda, kuid mitte tema enda jaoks. Ta otsustab osta Petja korteri ja m\u00fc\u00fca oma korteri. Kuid m\u00fc\u00fca just selleks, et osta Petja korter, mitte lihtsalt. Kinnisvaramaaklerite keeles nimetatakse seda \u2014 'Alternatiiv on valitud.'<\/p>\n

N\u00fc\u00fcd vaatame seda olukorda Petja vaatenurgast. Asi on selles, et Petja ei soovi samuti hoida raha, mis kaotab v\u00e4\u00e4rtust, ta m\u00fc\u00fcb oma korteri, et osta endale korter Elfi linnas Valinor, kuid millise t\u00e4pselt \u2014 seda ta veel vaadanud ei ole. Kinnisvaramaaklerite keeles nimetatakse seda \u2014 'Tehing alternatiiviga.'<\/p>\n

Kaks Keskmise Maa haldjat, Maglor ja Maedros, omavad Valinori linnas sobivat (Petja kriteeriumite j\u00e4rgi) kinnisvara, millest nad kiiresti loobuvad, kuna nad valmistuvad teenima Melkorit. Kinnisvaramaailmas nimetatakse seda 'Vaba m\u00fc\u00fck'.<\/p>\n

Nii et Vasja leiab kliendi Sero\u017ea. N\u00fc\u00fcd leiab Petja Valinori linnas kaks tema soovidele vastavat varianti. Suundume tehingu vormistamise juurde. Oletame lihtsuse huvides, et keegi tehingu osalistest ei kasuta h\u00fcpoteeki ega oma koormatud alaealisi kaasomanikke. Seega peavad n\u00fc\u00fcd toimuma j\u00e4rgmised sammud:
\n1. Sero\u017ea annab Petjale raha.
\n2. Vasja annab oma korteri Sero\u017eale.
\n3. Petja annab oma korteri Vasile.
\n4. Kas Maglor v\u00f5i Maedros annavad oma korteri Valinoris Petjale ja saavad Sero\u017ealt raha.
\n5. Malkor ja Maedros l\u00e4hevad Mordori, et teenida Melkorit.<\/p>\n

Ideaalne oleks edastada j\u00e4rgmine skript kinnistusregisteri t\u00e4itmiseks:<\/p>\n

START TRANSACTION
\nVasja korter anda Sero\u017eale.
\nPetja korter anda Vasile.
\nbegin
\nMalkoori korter anda Petjale
\nSero\u017ea raha anda Malkorile
\nIF_ERROR:
\nMaedrose korter anda Petjale
\nSero\u017ea raha anda Maedrosule
\nl\u00f5pp
\nCOMMIT TRANSACTION\n<\/p><\/blockquote>\n

\nSee on lihtsustatud tehingu skript alternatiiviga, mis eeldab, et k\u00f5igil korteritel on \u00fcks t\u00e4iskasvanud (ja teov\u00f5imeline) omanik, et nende v\u00e4\u00e4rtused on v\u00f5rdsed ja et maaklerite tasud (kui need on olemas) makstakse eraldi tehingu etappidest.<\/p>\n

Kuid Rosreestr ei toeta tehingu j\u00e4rjepidevust. K\u00f5iki toiminguid tehakse j\u00e4rjestikku ja iseseisvalt, \u00fcksteise j\u00e4rel, ilma et kogu tehingu puhul oleks v\u00f5imalik tagasiteenust, kui m\u00f5ni neist ei \u00f5nnestunud. Maksimum, mida on v\u00f5imalik saavutada \u2014 arvestades, et Rosreestr ja MFC ei tegele sularaha \u00fclekandmisega \u2014 on raha paigutamine pangarakku, kus on juurdep\u00e4\u00e4su tingimused Vasja, Petja, Sergei (kui mingit tehingut ei registreerita), ja teiste osaliste jaoks, kui nad esitavad Rosreestrisse registreeritud lepingud. Ja muide, pangad ei kontrolli lepingute autentsust iseseisvalt, st nad usaldavad tehingus osalejate dokumentide t\u00f5elisust.<\/p>\n

Lisaks tehingu t\u00e4itmisriski k\u00f5rval on ka probleem selles, et kui teised osalised saavad sisse kolida oma uude elukohta, oodates t\u00e4ielikku vormistamist (tere, teenuste puuduj\u00e4\u00e4kide k\u00fcsimus!), siis Maglor ja Maedhros ei l\u00e4he kohe Melkori teenistusse ning t\u00f5en\u00e4oliselt ei saa Maglor sihvrille k\u00e4tte, tal lihtsalt ei j\u00e4tku aega. Kinnisvaratehingud vormistatakse j\u00e4rjekindlalt ja iga tehingu vormistamine kestab v\u00e4hemalt 9 t\u00f6\u00f6p\u00e4eva.<\/p>\n

Lisaks sellele ei toeta Rosregister ehitamisel DDU alusel elukohta koormatut, kuigi v\u00f5iks, see on elementaarne tegevus seoses lihtsa futuuriga.<\/p>\n

N\u00fc\u00fcd liigume puuduste ja minu soovide juurde seoses andmebaasihalduss\u00fcsteemiga.<\/b><\/p>\n

1) Esiteks on versioonihalduss\u00fcsteemi puudumine. Kui Delphi poolelt arendan oma liivakastis, ei saa minu tehtud muudatused teistele arendajatele k\u00e4tte enne, kui nad on commiteeritud, kuid andmebaasis on olukord teine. Isegi kui mul on t\u00e4ielik (kui mitte arvestada viidatud \u00fclesande raames vajalikku) juurdep\u00e4\u00e4s tootmisandmebaasile, mis juhtuda v\u00f5ib, ei saa ma seal arendada. Kui ma hakkan testima, on k\u00f5ik l\u00e4bi. Mis ajast on see kiviaeg??? Looge arendajatele liivakast.<\/p>\n

2) Teiseks on puudus eelnevalt seadistatud standardiseeritud tabelitest, mis kirjeldavad reaalsust. Igas firmas, kus olen t\u00f6\u00f6tanud, on oma formaadi tabel, mis kirjeldab nimede (nii vene kui (v\u00e4hemalt) ingliskeeles, vene keeles eri k\u00e4\u00e4ndes) kaheteistk\u00fcmne kuu nimetusi!<\/p>\n

3) Kolmandaks \u2014 ja siin kasutan Oracle'i terminoloogiat \u2014 puudub v\u00f5imalus kutsuda \u00fcles lihtne Insert v\u00f5i Update skript, mis kasutab Returning funktsiooni, nii nagu me kutsume Selecti. V\u00f5ib-olla ei ole probleem Oracle'is, vaid Delphi + Oracle liidese probleem.<\/p>\n

4) Neljas \u2014 vajadus m\u00e4\u00e4rata oma loodud protseduuridele ja funktsioonidele volitused seal, kus ma ei soovi seda teha. Ma ei soovi m\u00e4\u00e4rata ja seej\u00e4rel muuta kasutajate volitusi protseduuri ja funktsiooni jaoks. Miks ei v\u00f5iks s\u00fcsteem, kui ma ei ole selges\u00f5naliselt kirjutanud Grant'e, iseseisvalt vaadata kaasatud objekte ja vastavalt nendele \u00f5igustele anda v\u00f5i mitte anda teatud kasutajatele \u00f5igust funktsiooni kutsuda? Olen valmis selle jaoks funktsioonide ja protseduuride kirjutamisel \u00fcht m\u00e4rks\u00f5na kirjutama. Veel parem, las kasutaja alustab k\u00e4ivitamist ja kui algoritmi haru toob ta n\u00f5udmise juurde, milleks tal ei ole \u00f5igusi, siis viskab s\u00fcsteem vea.
\n
Allikas: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041a\u043b\u0438\u0435\u043d\u0442 \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0443\u0435\u0442 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u0421 \u0441\u0430\u0439\u0442\u0430 http:\/\/corchaosis.ru, \u0430\u0432\u0442\u043e\u0440 \u043a\u0430\u0440\u0442\u0438\u043d\u044b Jonathan Tiong. \u041f\u043e\u043c\u0438\u043c\u043e \u0442\u043e\u0433\u043e, \u0447\u0442\u043e \u044f \u044f\u0432\u043b\u044f\u044e\u0441\u044c \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u043c (\u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e, \u044d\u0442\u043e Delphi + \u0432\u0441\u044f\u043a\u0438\u0435 \u0440\u0430\u0437\u043d\u044b\u0435 \u0421\u0423\u0411\u0414, \u0432 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u041e\u0420\u0410\u041a\u041b, + \u043d\u0435\u043c\u043d\u043e\u0433\u043e PHP), \u0443 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0445\u043e\u0431\u0431\u0438 \u2014 \u044d\u0442\u043e \u043a\u0443\u043f\u043b\u044f \u0438 \u043f\u0440\u043e\u0434\u0430\u0436\u0430 \u043a\u0432\u0430\u0440\u0442\u0438\u0440. \u042f \u043f\u043e\u043a\u0443\u043f\u0430\u044e \u043a\u0432\u0430\u0440\u0442\u0438\u0440\u0443 \u043d\u0430 \u044d\u0442\u0430\u043f\u0435 \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u0430 \u043e\u0442 \u0431\u043e\u043b\u0435\u0435 \u043c\u0435\u043d\u0435\u0435 \u043d\u0430\u0434\u0451\u0436\u043d\u043e\u0433\u043e \u0437\u0430\u0441\u0442\u0440\u043e\u0439\u0449\u0438\u043a\u0430 \u043f\u043e \u0432\u043a\u0443\u0441\u043d\u043e\u0439 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":91149,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-91148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Minu soovid tulevasele andmebaasihalduss\u00fcsteemile ning ka Rosreestrile seoses tehingu\u00f5igustega | ProHoster","description":"Klient suhtleb andmebaasiga. Veebilehelt http:\/\/corchaosis.ru, kunstniku Jonathan Tiong maal. Peale selle, et ma olen programmeerija (peamiselt Delphi + erinevad andmebaasihalduss\u00fcsteemid, viimasel ajal ORACLE + natuke PHP), on mul hobi \u2014 korterite ostmine ja m\u00fc\u00fcmine. Ostsin korteri ehitusprotsessi k\u00e4igus usaldusv\u00e4\u00e4rselt arendajalt hea hinnaga.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u041c\u043e\u0438 \u043f\u043e\u0436\u0435\u043b\u0430\u043d\u0438\u044f \u043a \u0421\u0423\u0411\u0414 \u0431\u0443\u0434\u0443\u0449\u0435\u0433\u043e, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043a \u0420\u043e\u0441\u0440\u0435\u0435\u0441\u0442\u0440\u0443 \u0432 \u0447\u0430\u0441\u0442\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u043e\u043d\u043d\u043e\u0441\u0442\u0438 | ProHoster","og:description":"\u041a\u043b\u0438\u0435\u043d\u0442 \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0443\u0435\u0442 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u0421 \u0441\u0430\u0439\u0442\u0430 http:\/\/corchaosis.ru, \u0430\u0432\u0442\u043e\u0440 \u043a\u0430\u0440\u0442\u0438\u043d\u044b Jonathan Tiong. \u041f\u043e\u043c\u0438\u043c\u043e \u0442\u043e\u0433\u043e, \u0447\u0442\u043e \u044f \u044f\u0432\u043b\u044f\u044e\u0441\u044c \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u043c (\u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e, \u044d\u0442\u043e Delphi + \u0432\u0441\u044f\u043a\u0438\u0435 \u0440\u0430\u0437\u043d\u044b\u0435 \u0421\u0423\u0411\u0414, \u0432 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u041e\u0420\u0410\u041a\u041b, + \u043d\u0435\u043c\u043d\u043e\u0433\u043e PHP), \u0443 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0445\u043e\u0431\u0431\u0438 \u2014 \u044d\u0442\u043e \u043a\u0443\u043f\u043b\u044f \u0438 \u043f\u0440\u043e\u0434\u0430\u0436\u0430 \u043a\u0432\u0430\u0440\u0442\u0438\u0440. \u042f \u043f\u043e\u043a\u0443\u043f\u0430\u044e \u043a\u0432\u0430\u0440\u0442\u0438\u0440\u0443 \u043d\u0430 \u044d\u0442\u0430\u043f\u0435 \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u0430 \u043e\u0442 \u0431\u043e\u043b\u0435\u0435 \u043c\u0435\u043d\u0435\u0435 \u043d\u0430\u0434\u0451\u0436\u043d\u043e\u0433\u043e \u0437\u0430\u0441\u0442\u0440\u043e\u0439\u0449\u0438\u043a\u0430 \u043f\u043e \u0432\u043a\u0443\u0441\u043d\u043e\u0439","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","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-08-08T23:42:48+00:00","article:modified_time":"2020-08-08T23:42:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"91148","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 12:33:24","updated":"2022-09-30 22:07:47"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/91148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=91148"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/91148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/91149"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=91148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=91148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=91148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}