Gautam Khanna - PGConf
Open Source, Data & PostgresAn Enterprise ViewGautam KhannaVP & Head - Modernization Practice, Infosys
Late1991OPEN SOURCE HASCOME A LONG WAYAND THEPOSSIBILITIES AREENDLESS2000sThe first ‘big’ open sourceBirth of the Linux KernelThe data explosion and user experience revolutionData, messaging and UI technologies from new tech companieswhere existing solutions could not meet their needs2012 EarlyRise of Microservices, DevOps,ContainersIncreasing speed, scalability ofapplications and rapid testing2000sEmergence of Open Source ConferencesBirth of “Commercial Open Source” todifferentiate from free software2020 Distributed SQL, Distributed servicediscovery, Service mesh, Serverless2018Microservices 2.0, NoSQL, Event driven, Streaming, CloudIncreasing speed, scalability of applications and rapid testing
FOSS is no longer a four letter word for enterprisesEnterprise adoption of Open Source is mainstream95%60%60%Companies say Open Sourceis important to theirenterprise#Clients say #1 challenge isHuge cost incurred to maintainand upgrade monolith systemsbuilt on proprietarytechnologies Companies say OpenSource is being used for ITModernization## Red Hat The State of Enterprise Open Source – 2020 Infosys - Insights from top 200 clients
WE HAVE PLAYED AKEY ROLE INCONVERTING THENON BELIEVERS Before2017 RFP - RedactedAfterSI#LayerRecommendation1Core GRC ent ManagementIBM ELFinal approved solution stack
GSTN STACK –Largest Open Sourcegrounds-updevelopment projectin the countryNeeded to replace30 indirect taxeswith uniform tax lawsacross statesUsed Open Sourcetechnologies with lightweight platform6.4 m tax payersmigration fromexisting tax regimePlatform based architecturewith faceless engineexposing API forconsumption151 BUSD110 kTax collection over18 monthsConcurrent users with 2 seconds responsetime15 m tax payers tofile taxes in the newsystemKey design principles –Platform approach, SEDAand distributed everythingHighlyranked site75 onSimilarWeb.com and140 on alexa.com50% of filing on lastday – 1,2 B invoicesEnd-to-End DevOps pipelinebuilt on Jenkins, Maven,Docker etc.70 mZero RPOpage visits andreturn filingsAnd a 30 minutesRTO to provide arobust DR solution
InsuranceServicesGovernmentLogistics BUT THE ADOPTIONMATURITY fe ScienceADHOCHealthcareOCCASIONALFinancial servicesSTRATEGICCONSISTENT
ANDORGANIZATIONS AREFACING CHALLENGESIN THEIRMODERNIZATIONJOURNEYBest-fit solutionAdoption plex partnerecosystem
INFOSYS IS TAKINGA STRATEGIC VIEWOF OPEN SOURCEAND POSTGRES INPARTICULAR201932,000 63001000 Employees trainedon Open SourceProjects executedon Open SourceContributionsto Open Source
It’s aFan!It’s aWall!WE SEE THECOMPLETE PICTUREIt’s aRope!It’s aSpear!It’s aSnake!It’s aTree!
THAT REQUIRESBOTH BREADTHAND DEPTH OFTECHNOLOGYKNOW-HOW
Adoption is happening across the stackResponsive Web User InterfaceWeb Server & App ServerRed Hat, Ubuntu, SuseJBoss /WSO2/Nginx Apache Modules / Jetty/ Tomcat/Tomee/NodeJSOperating SystemOPEN SOURCEINNOVATION ISVERY STRONGIN THEDATABASELAYERBackbone/AngularJS/, HTML5, CSS3, JQuery, Bootstrap, Mustache, RequireJS Service LayerBusiness Rules EngineBusiness LayerIntegration LayerApache Camel, Spring REST,SwaggerDrools, JRules, JBossRules ManagementJBossBPM,Spring/Akka, WSO2 BPMJBoss/WSO2Integrator, Kafka .Search & AnalyticsBatch ProcessAuthenticationCacheElastic, Apache Solr, Lucene Spring Batch /Pentaho / TalendOpenLDAP, Red HatDSRedis, CouchbaseDatabase LayerContent RepositoryImage ScalingPostgreSQL, MongoDB, Cassandra, Couchbase,MariaDB, MySQLAlfresco, OpenText, ApacheJackrabbitImgScalr
POSTGRES ISPROPELLINGTHE OPENSOURCE RDBMSREVOLUTIONIN G2KENTERPRISESInternationalization,Text manceReliability, Data IntegrityData Types
WE ARE SEEINGTHREE MAJORPATTERNS ING2K ADOPTIONOF POSTGRESUsage PatternsRDBMSMigrationCloudMigrationsMigration from proprietary RDBMSMigration to Cloud usingto PostgreSQL in order to reduce ITPostgreSQL as the target RDBMSNew development leveragingpower of PostgreSQL to speed upGo-To-Marketspend and to simplify IT landscape60%Green-FieldDev30%10%
SOME KEYEXAMPLESAsia-based financial services group Core banking application running on-prem withproprietary databaseNeeded to be made cloud-nativeImplemented oeCloud version of Finacle80%Reduction in database licensingcosts by moving to EDB Postgres
SOME KEYEXAMPLESHigh-speed broadband network provider Cloud migration for geospatial system that supports networkplanningStorage capacity size of data to be initially 4 TB with upperlimit of 100 TB, Number of concurrent users 550.500K AUD30%Annual cost savings bychoosing RDS PostgresIncrease in performance ofsystem
SOME KEYEXAMPLESOilfield services company In-house system for monitoring oil rig performanceDatabase centric application with extensive usage ofPackages; Procedures; Functions; Triggers; AdvancedQueues 400K 3M USDLicense cost savings per year onevery instance of the applicationCost saving annually by enablingeventual movement to Cloud
INFOSYS ISINVESTINGHEAVILY IN TOOLSTHAT HELP CLIENTSOVERCOME SOME OF THEBIGGEST HURDLES INMOVING TO POSTGRESPROPRIETARYRDBMSInfosys DataCruiseInfosys CodeImpactAnalyzerInfosys DataTestingWorkbench
AND OURPARTNERSHELP SOLVESOME OF THEOTHERCHALLENGESWho do I call at 2 AM?Can I avoidthe code conversion heavy lift?What about Enterprisefeatures like monitoring,failover and replication?
OUR PROMISETO OURCLIENTS60-90%30-60%Minimalsaving onlicense costsaving on migrationeffortvendor lock-in
OPEN SOURCEMOVEMENT –A JOURNEY WITHENDLESSOPPORTUNITIES“The trouble with the world is that the stupid arecocksure and the intelligent are full of doubt.Bertrand Russell
THANK YOU 2020 Infosys Limited, Bengaluru, India. All Rights Reserved. Infosys believes the information in this document is accurate as of its publication date; such information is subject to change without notice.Infosys acknowledges the proprietary rights of other companies to the trademarks, product names and such other intellectual property rights mentioned in this document. Except as expressly permitted,neither this documentation nor any part of it may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, printing, photocopying, recording orotherwise, without the prior permission of Infosys Limited and/ or any named intellectual property rights holders under this document.
Elastic, Apache Solr, Lucene Spring Batch / Pentaho / Talend Redis, Couchbase PostgreSQL, MongoDB, Cassandra, Couchbase, MariaDB, MySQL Alfresco, OpenText, Apache Jackrabbit e Service Layer Business Rules Engine Business Layer Integration Layer JBossBPM,Spring /Akka, WSO2 BPM Apache Ca
Stochastic Calculus for Finance Brief Lecture Notes Gautam Iyer Gautam Iyer, 2017. c 2017 by Gautam Iyer. This work is licensed under the Creative Commons Attribution - Non Commercial - Share Alike 4.0 International License. This means you may adapt and or redistribute this document for non
M.L. Khanna DAV Public School, Dwarka, New Delhi Academic Plan 2017-18 pg. 1 M. L. Khanna DAV Public School Sector VI, Dwarka, New Delhi 110075 ACADEMIC PLAN 2017-18 CLASS- IV ENGLISH Learning Objectives: To read aloud and silently at varying speeds. To write a variety of sentence types.
Gautam Agarwal Doctor of Philosophy in Neuroscience University of California, Berkeley Professor Ehud Y. Isacoff, Chair Many biological systems are composed of heterogeneous elements. This work analyzes the heterogeneities found in signaling systems within the Drosophila nervous system, focu
gautam gupta ukg dahlia iii samarth chaudhary mr. jayant choudhary ukg aster position name father’s name class i ansh sharma mr. devendra kr. sharma i b ii ritvi jain mr. vimal anand jain i a iii paridhi gupta mr. vikas gupta i d position name father’s name class i atharv gupta mr. gautam gupta ii a ii anika kulshreshtha dr.
21 2791 F307 Dr. Kamal Singh Rana Dr Ramphal Rana 22 3266 H607 Navneet Kumar Ram Niwas 23 2169 E403 Adesh Kumar Sharma Vijay Kumar Sharma 24 2041 C1103 Ankur Gautam Rajender Prasad Gautam 25 1461 A1002 Bharti Choudhary Rajkumar Choudhary 26 1500 C303 Preeti Yadav Surender Singh 27 1559 D106
Engineering Mathematics – I, Reena Garg, Khanna Book Publishing . AICTE Recommended Books for Undergraduate Degree Courses as per Model Curriculum 2018 AICTE Suggested Books in Engineering & Technology w.e.f. 2018-19 BSC103 – Mathematics – II 1. Advanced Engineering Mathematics, Chandrika Prasad & Reena Garg, Khanna Book Publishing 2. Higher Engineering Mathematics, Ramana B.V., Tata .
VLSI Fundamentals Lec 14: March 12, 2019 Ratioed and Pass Logic Penn ESE 570 Spring 2019 – Khanna . Lecture Outline ! CMOS Worst Case Analysis ! Ratioed Logic Gates ! Pass Transistor Gates Penn ESE 570 Spring 2019 – Khanna 3 . Parasitic Caps for NOR2 (worst case) 4 V x 2C g C dbn1 C dbn2 C d C dbp1 C
Pipe Size ASTM Designation (in) (mm) (D2310) (D2996) 2 - 6 50 - 150 RTRP 11FX RTRP 11FX-5430 8 - 16 200 - 400 RTRP 11FX RTRP 11FX-3210 Fittings 2 to 6-inch Compression-molded fiberglass reinforced epoxy elbows and tees Filament-wound and/or mitered crosses, wyes, laterals and reducers 8 to 16-inch Filament-wound fiberglass reinforced epoxy elbows Filament-wound and/or mitered crosses, wyes .
