Mimer-SQL-for-Android_-2015-Aug

MimerSQLforAndroidOverviewMimerInformationTechnologyDeveloperoftheMimerSQLproductfamily–EnterpriseSolutions–Industrial/EmbeddedSolutions–MobileSolutionsUsedinmissioncriticalsystemsworldwideWorld-widepresencethroughcustomersandpartnersStrongR&Dteam,allwithindividual15-30yearsexperienceofSQLDBUniqueSQLdatabaseexperiencetargetingmobiledevice;“mobileawarness”HQinUppsala,SwedenDevelopmentstartedinthe1970sMimerSQLinMission-CriticalSystemsControlsflowofpartstotheassemblylinesattheVolvocarplantinGothenburgMissioncriticalInproductionsince25+yearsMimerSQLinLife-CriticalSystemNationalBloodService,England&Wales–Nation-widesystemresponsibleforalldonatedbloodandtissues–Systemcontrols2.5milliondonationsannually–3,500+activeusers–Databaseof1billionrecords+8million/week–“OurexperienceisthatMimerSQLrarelygivesusaproblemandhasaverylowmaintenanceoverhead,sothere’snoneedforanyexpensivedatabaseadministratorstorunthesystem.”IanHenderson,MDatSavantEnterprises,thedeveloperofPULSEStockLevelon09Oct2008MimerSQLpositioningFootprintKbyteMByteGByteMeasurementofRealDatabasesMimerSQLProductFamilyLargeSystemsResourceconstrainedSystemsMimerSQLMobileMimerSQLEnterpriseMimerSQLEmbedded&Real-TimeMimerSQLMicroMimerSQLNanoPhonesbasedonMimerSQLAinoW760iW715C902W910YariC905W995YulongsmartphonewithMimerSQLMobileinsideCoolpadN900isbasedonWinCE,allapplicationsareconnectedtoMimerSQLYulongsmartphonewithMimerSQLMobileinsideCoolpadhasMimerSQLinsidebasedonAndroidJBMimerconcept–ThesinglecontentengineDataDataDataDataDataApplicationsUserinterfaceApplicationservicesOSservicesBaseservicesKernelApplicationCentricApproachDataCentricApproachSharedserverarchitectureinMimerSQL–MimerSQL:Oneserver,onecache–manyapplications–SQLite:Oneinstance,onecacheforeachapplicationSQLiteMimerSQLMemoryusage–InstancesMimerOneProviderMimerTwoProvidersMimerThreeProvidersSQLiteOneProviderSQLiteTwoProvidersSQLiteThreeProvidersBuffersandQueriesBasememoryDatabasecacheEachSQLiteinstanceneedsanothercacheandbufferstorageMimersharesthecacheforallapplications/providersDatastorageinMimerSQLBadperformanceNeedtorebuildindexesSystemunavailableduringreorgHighmaintenancecosts–Downtime–StaffSQLiteMimerSQLAlwaysoptimalperformanceNoneedtorebuildindexesSystemavailable24x7Zeromaintenance–“InstallandForget”PerformanceandReorganizations010203040506070NoofoperationsTimeSQLiteMimerAlldatabaseoperationstakelongerandlongertime,degradationThesamehighperformanceallthetimeRepeatedupdatesofthedatabaseHowtoevaluateaDBMSproduct010203040506070TimeResponsetimeSQLiteMimerRepeatedupdatesofthedatabaseThisisthereal-lifesituationManyevaluationsaremadehere!MulticoresupportMimerSQLmultithreaded–Executesdatabaserequestsinparallelonmultiplecores–NolockingGiveslowerresponsetimesGiveslowerbatteryconsumptionSQLitesinglethreaded–Ifathreadstartsatransaction,allotherthreads(andprocesses)mustwaituntiltransactioncomplete–CannotutilizemultiplecoresMimerSQLSecurity(i)MimerSQLAccessControlsystem–PrivilegesforSelect,Insert,Update,andDelete–Onlyobjectsthatanapplication/contentproviderhasaccesstoarevisible–Possibletocontroldowntoasinglecolumn/rowelementwhatanapplicationcanseeand/ormodify–WithaviewitispossibletodynamicallychangewhatanapplicationcanseeMimerSQLSecurity(ii)Databaseserverrunsinitsownprocess–Dataisprotected–NoviruscanaccessthedatainmemoryDatabasefilesareonlyopenedbythedatabaseserver–Nodirectfileaccessbyapplications/contentproviders–Applications/contentproviderscannotaccessdatabasefilesinthefilesystemMimerSQLSecurity(iii)MimerSQLcanencryptthedatabaseondisk–Eveniftheflashcardisremovedfromthephone,thedatacannotberead–Ifausergainsrootaccesstoaphone,thedatastillcannotberead–EncryptioniscompletelytransparentfordatabaseapplicationsBringYouOwnDevice(BYOD)UseviewmechanismtoprovidedifferentviewsofthesamedatatodifferentusersUsedinthedatadictionaryinMimerSQL–Userscanonlyviewinformationaboutobjectstheyhavecreatedorhavebeengrantedaccessto.Whenaccessrightschangesodoestheinformationreturnedbytheviews.Inasimilarmannerdifferentpartsoftheaddressbook,email,etc.couldbehiddenorshownbyimplementingandusingasimilarmechanismandintegratingwithothersecuritymeasuresHowcanYouDifferentiate?!-CreatingauniqueimproveddeviceMimerSQLforAndroidMakesadifferenceMimerSQLforAndroid,makesadifferenceAfullSQLDatabasepre-integratedwitha“plugandplay”supportforAndroidthatwillimprovetheoverallphoneexperienceDevicedesignSoftwareapplicationsSystemintegrationHardwareconsiderationsUserinterfaceOperatingsystemDataManagementWhyMimerSQLforAndroidMimerSQLgivesacompetitiveedgetothedeviceenhancingtheuserexperienceinpureSQLitereplacementmode.–Significantlybetterperformance.–Stableoperation,nodegradation.–Savesbattery,lesscache,moreefficientCPUandmemoryusage.–Multicoresupportandenterpriseclassconcurrencyoperationgivessignificantlyimproveduserexperience.Optionalopportunitiesforthedevice–Enhancedsecurityandaccesscontrol.–Highperformance”flagship”appsandfunctionalityusingMimerSQLdirectlyShortTimetoMarketwithzeroriskinreplacingSQLite,”plugandplay”–MimerSQLwill