CA2615645A1 - A portable database system for independent operation on computing device - Google Patents

A portable database system for independent operation on computing device Download PDF

Info

Publication number
CA2615645A1
CA2615645A1 CA002615645A CA2615645A CA2615645A1 CA 2615645 A1 CA2615645 A1 CA 2615645A1 CA 002615645 A CA002615645 A CA 002615645A CA 2615645 A CA2615645 A CA 2615645A CA 2615645 A1 CA2615645 A1 CA 2615645A1
Authority
CA
Canada
Prior art keywords
database
application
portable
computing device
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
CA002615645A
Other languages
French (fr)
Inventor
Ameet Mehta
Nirav Mehta
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
TELECOMPUTE INTEGRATED SYSTEMS Inc
Original Assignee
Telecompute Integrated Systems Inc.
Ameet Mehta
Nirav Mehta
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Telecompute Integrated Systems Inc., Ameet Mehta, Nirav Mehta filed Critical Telecompute Integrated Systems Inc.
Publication of CA2615645A1 publication Critical patent/CA2615645A1/en
Abandoned legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application

Abstract

The application relates to a method and system for keeping data and applications together and easily transportable across unconnected or unfamiliar computers.
The teachings of this document disclose a hardware and operating system independent portable database system that integrates application data, along with intrinsic characteristics of data, and the functions that control, manage and query data and that can be activated, accessed, and changed in a given computer without using external database management system software that may or may not be present on the said computer. This system and method also provide an application development environment for portable applications to be developed that would generate and be supported by their own respective data, such combinations of portable applications and data being executable transparently and unobtrusively in a given computer that does not have installed in it the said application.

Description

T!Ze application relates to a database svstem and particillariy tv an indepetir#Gnt andportahk~.~ relatiunttl d<ÃtabttsesNIstem. DESCRIPTION O;f+..IJ,ELA1:EI3 ART

Databases tar& widel) dcplo~ed and cc7135istot'data typically relationtalong N" ith tnstrUCti021 Sl'tS 51.ICh as ~torE:dprocE:dtlrl'S, t1'I0.?t?CfS.
S(,K~l. interpreters. k?.'llt'3.1?Orti and are implemented for storage and retrieval of' ciata. A datahase may he trsiii Ii)r fisnctions st-eJi as uplt}ading, dEtwtiottditg, lnst;tllinf!_ transicrring, rt1O\~ t.lpct~iti3?~.
copying andrnanipulating th~daia:Adatabaseis tvptcally stor4cfon devices %,Oth Iiotl- ptartable storage sp,3ce;anc1 is uft4n considered the backbone of ttn oroaniz;uian.

{ t) I)ttiS is b<)th vt'teratcd and storLd in adattabase hy a p.iliicular u}iplic:t.ttior}. Tkte data's chafmacrfsttcs a:re unictuely deterniined bv the application that crLateti it and is ilttefli,,Jhh: <yrcomp<ttible oniy ti) the application ttiat crc.atcdit. Users of a database oflcn need to access the database while on the rtiote or tt ttN

irollt tlte phy'Sical location of' the database. Such aLc.ess is of'ten restFit:tc,i and ilicc.ti 15 Iinzit<itlcans tin ~WctiUntc>f`p rtabi(it% t>fthe. database in a scctlrt and effiiicnt manner. f?~le ttV Of acire,5sirtgttte databascfrttnt aremute iocation isby means ot' a rtc.t~wcarkconne.cti rt. A usc.r typically uses a computing tievice m,tlilabfc to him to connect to the network and thereby access the database. Such an approach also lftces limitations in th<it if* afirst computer has some data in it pcttaining, to a sp:;cificapplication at3d iftl7at ,;ata 20 neec'is to be rctttt, accessed, edrtect vtr-iticcl bv a ttser of another crrrtpt,jtc.r: hw lc.Ãluire;mc;rtts are to hc sati5Ciect, namelyttt4.sec:ttnd corr7lattter has to c<>nttcct toth,: tirst c~.~t7lputc.`r that permits it to becGtntc a Iotnt?te user af thc }ir-st coinpt:tte.r. ~.ild tht; ,c,:i>r7d coÃnputcr lias to have installcd in it or havÃ: acc~~ss Ita the jiarticu(ar ÃÃpplit:ation that can recognize atici read the tiata residint-, ili the first compttter.

'1 his necd for a spccifilc applic.atiotl iithcr ot7 l,L 1 cal t:c~tnputttr or otl tlte loc~Ãl rtetivorf: withcft whi;:h the trser= cannot ti:;e his data, contir?cs t}ii ttsahilitv (}i the ciataha5e. Lxi5tin- a{:tproacJtcs oi' ccz;n}alt:telti ,cparating clata 1Con"
its appiicatior5 iteu ttii ah: itt to tÃ,c data, Wa iiscc i, at a l:scai ct>>~~putLr that ciot:s not i*i:n :Ã sl}eG:k appi(t.4tticfn and t11c pC;!'tiÃleiit data of iditerest to t11L' Ei'ser is located zit 2i re!'tlot:; t;oC2i1?titw1.
tht: user ishacc;cl v~ittt.m e=[Cectf erphzm clttttà ~-~ Atioilit:r ittstaiicc of havinp- oeplitin data is when ttYo tiser lias with hin) dÃ,tta t#~at. 10 'WOUld co47Stitlite Ei11 Upcicitt' to a l.},.it'tit'ttlar d;itab;:lSc'.
10i;at{'Cl iIt ~l 1't'ri1i01('. Cotnl3.~Wt ihat t:tlt'~

not pi<iti idtr access to its ht:>sted application t}t database to the local cotnpttter. and t1tc 1Oc'tE{ cOMPi,tCr dt}cs iic t I10at the rcf;:~ant <tppiiÃ;aÃi<>rt eith4r.

Sinnilarl~~, physica}l~' carrvitjr~ th~.} database t~ti a pcat~tahle device 5cÃc:lt t~tZa< the ~ttÃt~e 1113}~ be ttcceSsccl by a ttscr by rontic.ctingthe portable ice tt) ~Ã
cr:3mpt3tit.g, d~:t tce, ::i,o 15 calls tr?r the availability in that c.c>mpttting tfevic4 ot' relevant ioftwitre that i:ai-i gcrii:rate.

r~:'aJ. prcseiat. ~xtract; manipulate alici 5tOrtr clftt~~. One r7Cc:cis hc7tl) data at3d <ti,plik:atizin.'~ !o proces4 the cl.tt;I so that th; user c1orives mctisTtm trt3nt thc nroc.c,~ssin4L, ot~~ tlic As applications are \sritj;:rr ior spcci(ic- operating sv,tcms, in lo! L{r:
application ti? he rcxt it tniÃst first be insttilleci, and in th:, Microswf't Wi~trlo~%s cri% irortÃt~r-20 mu5t ht registert:rLl itt the Wittd:txvvs registry. ;l database yuppC>rted applicatic}tt must also he made ctarinectiEsli tc) its tlatahas::. llensz applications and cia;abascs at-e ;t<hject to limitations of haviti~ t,o be ittst-aÃled at 4peci:fic ccirnpatet-a and are Fiot ;:n% isaged a:; "1'!t3g-(1 }~1'a'~.. ac!'(ia' ~:tlrilPf.9tE'rS. I'411'thZrtllQrL' 'cippltcutlt)tl5 c1:":: `i'.lhje{;t ti) irt1c7t.r (1:r, pi'oti:+.'"'s}t, measures and are specificaffv designed not tt> bc (reely installable i'rt.rm or at re:,7otc i:t?niputers. 'f'his has meant that the general desi<~;n approaches Of' ctrrrCtIt .tpP)!ictttions }?erpLttzatc the separatictn oi d<tta frcmi ttpoicatitms and of data kr0m trnkriowt r;:ttz()tc 4ompmers and the dependencC orapplicationy on sfx;cific ~peratin~ s~st~n;s. 5 Ilt:rcfim there are re5trictii7rts on thc f,i~rtuhiiQ t>i a dttiahme and the pNti"t application is directed trz~karcis atidressing tllcSL rctitrictions.

S [;.N1 NI .11iY Fhis sl.rminarv is provided tt., introducrr p0rtahiC
datttbasQ s~stcrrt4 at-ld thc>c ;tistett?s are t'urtht~.r dcsc:rihz.d beto" in the detaileei descrifzlion.
"Fhis st,;nn,tirN is not lnwnded to tdcnltir essenttal feattarcti ()f tile elalmed sUhjcct mmttzr, not' (~, It Ãrztcnd~,'J t`i)r ttse in dctc.rtitinin:; tht; sc.ope of tht ct<tii37td st,hjcct n7attGr.

Fhe: application relates to a tticthtlci ,tnd i~-steni l*or keeping tiat,, and :tpp;i.=tttton, tot7tther and casity transfaot-tablc across urict~nnccteci or untarniliar Cornf7We.t-S, l'lIe tmchirses t:}f' this docunZertt W[cSc a hard"Gtrc anci rMeratkg >y>tt m indcpencicnt portable metliod and 5ysteni that inte~rates tif7plication dttt:i. along ith intriw.ic c1Zars3cteristics of data. and the itrnct47ns t47at contrul. mar7agc and tiuer. drrta ~and that can he activated, accessed, and changed in a xiven com}?um "ithout !rsk{> cxwntttl t:i<;t,th.t54 tnanagct7ient sycro sc>ft"wre tftat rnali>r mqnai be present on tftc said coll;hutc.r. lhi~

tiysttini and inshocl al5<~ providc in applictition iic,,elopineant emironmcnt ior pt.,rtablc ttppiicatiotls to be citivclaped that r%ottld generatc and bc sttPPcrted h~
111Q'ir 0~vtj respective data, 5trch combinations of portable applications and data l,ein transpArently and unobtrusively in a given ccamptttr:r that: does. rio . t have iti,tallcc) in it the said application.

I'he application provides 1'or a portt-tble database svsteni for indepLnc9ent operation t)t1 a computing dcvtcsr' th`rtt tt relational database and at least one application fi-vr j:tccessim>, a.Ãid t6ntrolling . ttic mlatrmtÃ; datahase t>pLrational1v intcL)ratcii ~r ith the rc'aitio~nal riatabasc, the relational database and application capable tif [7cing lnader.i onto a stc~raL)c clex ice; a l<tunch object i'or displaying on the c mputin,,, di:vice the applicatian5 availah1L
can t4ie storage clevicu tan cotincction af tl-ie titarage de% ice to the c:otnputing ;ie'. ic~~ Such that selcsctie~n of' an tzppiicationrr^stilts in the appl;catiori to b.,, loaded nto the random10 ac4css mcinorN tsf the compLttittg device; and an object in-stantiation svstLm lo t nfiin , :ttx3 verilyirrg, digiial li-ak libraries ayail;,at?lc: an: tiiU pirrtahlc databasL s~ytcr7r and instantiating objrct5 required by the ap.plicatiort la access anii control thc r,~iatiui. il database ,vithout interacting, ~vith thc, W.rtlptltin,, devitc to which the portahte sy5tcrn is ccantiectccf, ',SircEt #hat:ttze appticattori i,', capable Of cxCc;Ettintv?
directly froirti the storag)c ~S stc<<icc. `f he appiic;-atii>n mav cpnZ prise of a i1ataprocc ssin~
app4icaticm ~tnti a c:l;tta query ap4~licatit7n.

I'he applicationprovides trir arnethod t>findepctidently operatitig apo>t-t.abte database systcrrr on a computing tlc:vree, thte portathle database sy5terrt comprisin~,~ a ?() relational datalaseatid at lc ast tatie applrcation far ac ccssing atid conttaltrb~ the ri[ational c)at,rbast operationally integraterl ~vith the relational database. the relational clatahasic ancl t:ppli.ca.ttcirt capablo of hein,y loaded orttca a storage devicc; the metlio(l ec~m~tF~rn~;
lattnchtrfg.an objcct it>E- ijispiaying, on the ctiniput'Ãng dc\ iLc tlie apptications m"ailibie ~in titc portable swra.i~c device orz cr:>nncction t>f tit&stora-,,~ tie~ ice to tlie contpLjtin2 dcVicr:;

5clccting art ttpplicattca:rt :16r o peta.l.tn g the rclatioiia1 datah::t5e and lc}adino. thc 5i;icct,d application on to the t-andtrtn..- access nlcniury u.f the cc>ilihc.iting duvic~:; lindino arld vc;ridigital littk libraries trvailable on the p6rtahle database system ;tnd' instantiati112 oh;ects r=eyuired b~thc:, application to access andcontrc>1 the relatic>nal datahase wtllout ~ iratc:rac.tint, \Aitli the computing cievXcc to which ti=te portable s~sten~ is c;onnectcd; suLh that thc applileaticift is cap3ble ofex6ttttn~ci~itcctlv from thc storttgcdcvice.

1'hc; appltcalion also prQvides tor a nzethoa oi' operating apt>rEahlc databasc >>stG>>t on a c:omputin,t cf6vrce: the pcrrtttble database svstem cctmprisin(_1 a r.clati nat dttt~il>;rse, ai le,n ct one application For accessing tind controllinti the relational cit-:tab<ise eperatic,nrtli.

intc-raEt(f with the relational datiabdse, tirYCi a syneltronizati n sv,tGn~
capable oS' connectint) to a remoteiv hosted dafabase, the relittional database. .tpplicatioii and wnrhron'tzation svstcm capaIA+r 6f bcing loaded onto a:storagc dc,vicL; thc:
at least uric application errmpiising trt'.a data proccssitig application and a ciata cluerv application, the rncthud c~rE~prising iarmchin ;an al~jecE f~t>r displakingon Ihc computtngdc~iLc the applii:atiotTs a~ailabi4 on the stczrap ge device crn uoiuicrtion oi' the sicrt'agc di vicc to thc computing de.vice:
sc;le.ctin~ an applic.attq11A
pr.tipetating tlic relational dataha c and loading thr selected application iui to the rartdori-t access memory of Ihe comptttir7L) clr vicc; tindintz Ariri vei'if'}in- digital link lilararics availablc on the portahlc ~iatabtrse s\ stem andinstantiating cibjt;cts rec7t,iiredhv the appCicafi6tt to ac-ctss and control tlac 20 rilttticanal datahase N\ith~~ut interactin~ iGh thc cumptttitt~ ~ic~:~ice to ~~f~iiir tllc p~~i-tahl:..

srstetn is ~t~~ttntcteci: sGtrh that the ttppltcdfiok~ t:~ capah(i i}i`
cxccuEin< ciirctl~ Irctni tl-tc stUtag :1 0 r3c:vice. Ot7Cratll7õ' on data it~al13h1i2 on the rcrnc?tc;
datah'dsc titiino thz .Jat:l prctcessin(I and data ctuery applications ol'the portab(e dat;ihrsc svstcin.

In accordance with anotlier aspect this applicatton relates to a methodof' svnertronliing data bc;tivccti appCtablc databasc sy5tcm and a riniotelN
1iostcd datahzr4e. 11 th,~. port;iirle databasc 5vstctn ccimnpris'tng a rc?ational datahase, at Icnst onc applicarion for G reiatiaiiai database opLrationall) integrated t17c accessing and eontrollinp th relational databzise, and a svnchror}izatinn s} stcr-n capable of' connecting to a remot,;iv hosted databasc, tl7erelatioiatil database and application capable ezi` being loaded onto a5tc>rage dc\ ic4; tl7e nietl3oci comprising opertttivcly coupling the portable ciawbasc 5Nwtcm withac;omptrtiii- devit:e; detcetinos ~~network connection Unthc computino cicVicuh\ :}1G{.0 synchronization syste-rn; connectingthe portable database sv5tcmwth the ree-notelyhc>sted dtitabasc:aii(i synchronizing data between1fte database,o!' the portabic ck~.:ahase svstem and the rcmotelv hosted database.

In accordanc.c with another aspect the application relates to an aliplication developrrtent system cotnprising of a plurality ol~rnodulcs. the modules including ti set i)t objects withpredett:rmined flznctionalities;thc modules capable of cQntiouration to tE~rm database procrsslne applications anddatabase qijc:r\, apptieaeions. in ac:cortiance with spceific usei- re_quirenycnts, such that the database pr- cessin- applicatiorrsand thedata.base query applications are capable otaccessing and controllinf a relational datahase;
2(I

...BRiFl,' DESCRII'TIt);lQF IvilE l.:tN'*WIN 17S ;. . ..

lie <tmonzpwayiÃ};_> dra"ing il(usvates the prc;! rrLCi emhv-dit~ient: oFthe ii~~Qmiisn and to,etht,r NGii1} the 1bMing c{etaileci cfGsirioi<n} sovvs to expiain ti7(i priinkip 1;:5 t,f:i}e in,i:ntic>n. f-i;. I illustrates an excmplari pc>Ã=tahle, i=clational database ,teÃ1} in ~`-1}icf} the iimal?aso ilie tiatabase c}l:te.q appiicador}s and We database pÃ'ocÃ.ysir}E, apnlitaNns aw lT1tl'.gt'ated, p'.?. 2 iliElStraw5 an E`\in!p:irV P(")M1C 1'CieltiWnUl Li.ltahaS<' ti\Mt:M
ti:'t3t1(.'?;=.'J ti? :

eonipLaing dc:niee, Fig. 3 illmate5 an exemplary ~.~oriahle relatinÃ}al database systesn cuÃ}nected' to . . . . , lii the t't.'Ã}1C)te "~ervi'r via a CL1t} pUtlnt device Uttltf_ing the IlitlloI"k hhiiit?Ls of the cot2}piitln`~~
det'i4c.

1)FtSC'h:11''i`It)\ OF 1-1IE PIZEI:ERItEl) EMBt)DIN11=.;`tiTS

For the pE,}sc' of prt?motln, ata ~1Ã~clGt'stat}~l~t~C~ of the i?rtztcipIr:'s Oi the aif% t.ntioii.
refi*,~renc~e will now be made to tl-te e.Ãnhodimer7t illustrated in the and ;pu~iiic lan4,uage. W(1 he used tt? deseribL the tiame. It 0li nevcrtt}eless he Ã.ÃÃ}damojd !ft<tt no litnitation t41ti. ,npe oi'tl}e inNentit>n is thcr4by ir}te.ncicif. sLIClI
alter:itii>n'S ar)d lUlrtl?,r t}lt~~Itl~.3tEt)T} in the ?HLltitrilti'.d LIc~ tCt', and sLlC`1} i17r[11c:r <ipr0icatii.3n`i L?t the C`1.:lLipl::5 i?i ttZe imr.ntirknas rllÃistrawd therein being, contem,16ted ~}s v,ould nt>rrlal:~oc~-:cir to me skillt:ci h} thc art tc> "i}ie(} the inveniimt relates, 20 It will be Understoodb~ tho~cskillci in Ie ar'ttliat t1ie fi7~e<~c?ir ~_ gem-rtilc3c;scr-iptic7Ã? and the I'ollcywinti tietaileci tie4cri}?ticmi tre eteinplar) and 4N,?<,n ator, oi 10 mention attci are not iittended to he re5trictib4 t!}e.eof:

In accordance with one aspect ol the invention aJx,rttthk~ fit}tat%asu prC)l'IdtC.I 1(lr lil:g111g the dw;1 and 'clpt_'.lIL:21t1C'!1s tl)`2sll"C'.l' a11C{ C:a l" ti'il?isllll!"lal:)ie ili::' i s L'()tTlilllillif,'_ 'tjt'dct'S 11'Ith ClÃ11L'rt:11t 4011tt<lra atnti I1ard\1mf; sl?Ldt!l'::itllln (w ii?ci11[L'.ctL't't'<:.
1 iil ITl?rtable database SVswt11 ("?ri)vides Ei1r i.:lst aC4.t'Ss to data at alny t r tl"!c tiVSte121'; 1S'ktll(}[1t haVlilg to JnstaH ,'in:' app1li;atl(ln on the ci}r1pUttt1g sytitCTll t11r1}[i4,}i wllli;ii the rLlational ciatttl?me is to he aaesed (w qt2e1'ied upon and thercfOrC Ã10t 1`ati .tcl~
traces or tÃ,er ticnsitivc iÃIfi3rniatittn on the c':?ntputing device Ãhrou`l 1\hich the t iniahlf::
database sy><<m may be ac<.4s;ed. '1'he }wwtz;,bEe ciatafztt,t. 5)Meln is indinet?dem ot' A:

s3Zti:lli Ctl%ii"On371t,'nt i3' i?rC17(tt:C[1.11"L ol t11C'. CC)llll)lltl;l:
dcV?Cl. iTtl 1011t:11 l}l 130Y:.ii}1Q' 10, ckttabasf; s~ster-n ma` he aCc:es(;etl.

l ile portahie dtlt;jl:?ase ,i sten-1 is capable ofbcirli, loaded onu) atly sttjr.24,c ticvii:t:.

in particular 13(?rt:.~blt' 4tt)rage di:.\li;t` such as KSB L{t'lvcS.
1'IrC\tli"sr dcti1t:f's. disc i.lt'iti;'S
, , and other S#1Ti?li;i1' titf)rt3,_'e tnle~illS. 1'i?r tllc lwt'r7t)SeS t)1 c\plaiflii?g the il1Crlt'~ Cif' tt1'~
lnlclntfot1, it 511.?11 he ;imi.lF1wd that tlic (?oriabll: database sy`.itl;tll is Et)odCd c)il to C+i"1i- ~i41=

~Stora.'-e tiL~vii.:e, a t 5}3 c.1rive. fi?r porti<tbilit, Of tt?C ditMb,tse.
1 0t1eM. t;IC PcO.sS
database ststtn-t is capable of being operatetl frvni any uorl: station and may lae port-;/ci or Ãnoved to any other uri:matiori as thc: I?oriable dwaboo systerti is not hard"arc botÃnrf, f,`a I illt,IStrae.s ari exet~nplar~ portable database syston 100 W hich a rebtiwmi (.~`tlt:.il"?i1hC`, 1{}2. a i.j:.?Cilbi3Sc' qtll:!'\ &pp11i:ilti0lZ 1()4 and database pr(lCi:islll...' li;<ltiotiti 106 can be it7teWr<3wci and irnl.}let~iettt4d :1,, ont. I'Ele i.{atL31_}atir~. i02 o; ['i.,::Ition:fi and si.Ãr ports all q pes oi` quet=`~ laliguagt,,, ~,tlch as St"`}( .VMi, and r?tl}ur,; tor ,:tcttr:t!c Li;id C'.:'rC1r free I'l'trit'.tal l}1 dWm ;% qt1Cr, is sClt?t211Hid 't?\ an t?pe.mti)I` tft u di.ilay)ilst.'. '1'oct:`>>'.i?L?
applilrat}()11 li<?6 "'h1Ch it1St7"t1CB the t1:3ta1',;;lzt' t1Elcry application 104 and illt titis?~i i'~1 ciata is retric~ed franr, the database. '1'he database query application 104 provides tor Ini Jh speed search opet-ations to bc perf't7rn7ed over the rcfati<>nal ciatzi.
'J":ie database processint~ applications 1()6 oÃ`thc portrtblc databasc sy s.cn ; are scii atane}in4w and indcpc;ndent app!ications ancl c1o not rcquire art~
corrc4poneiing t~?cs to l,c installed Ovcr thc COMjIttting rlevici; to tihich the pr>r't:rbEc 5"tcttt is .`orirtc::c;#. Or eaaillplc. in a\'licrosvl: tkindovt's wnvironr-ncrtt. thc portable dat:zlzayt t,i>c5 rrot NqUirc any updating ai thc WindotNs registry and the database proccssin,,-, atlplication is capable ofexccutin~õ dire-ctl\#roni the portable database sy swni. The portabfe database syster7t al,a con7priscy ol' a launch c7t}cct and ari uhicct I(i irrstantiation svstem. 1'he launch c>b.ject ctisplavs on the cotoputing dvÃcc the dmahaic processing applications I()6 available on the storage device on canncction r7f thc:. ,tora gc device to the coniptttint,~ cie% ice such that scfcctkn o( a databaie prt~cessin- L:p.,pFication rest.rits in the particular applicatit>n to he ltmut,:d on to tlw r;:tnciitni access r,:cmor~ ol' tltc ci>rYlpt,tinj,), device, The object in,tantiatiori spenn iinds and wcrifics digital lirif: libraric, available on the portable database s}item and instantiate~ cihjc:~:ts rccltrirec3 h~ tliC
database prc>ccssing application to access and cc7ntrol the reIaticinal database ~, itijocrt interacting, NOth t}lc conIputin(-,cfiti ice to xhich the p(>rtable s)stern isconnectLd: suclr that the applicatian is capable of' txGcutirig direitly Pt>rn the storage de~, iQe. The ohjcct instantiation srstenl provides and enables the database ylrcry applieatit7rzs requircci hrthcdatabmc prcxessin app;ic:atic)ns to accct;, and control the databasc;.

I lte Jatahasc processing apphcation I(i(, ma} aiso pro\ idc iot= ttser <:uthetjticati<7n an(i authorization. Ehis nZa~be iniplernented b)rt:qtririnw~ auscr authcntier<Ytir>n ~;

reqtaii`etnetii i~ tlic launc.l~ ah.}c;ct l~efrsrtx a datal~a~i ~t=~x:cssin~
a~s~iicatitst~ i5 yelGt:te.~ f~xt rxs on data staeh as ti~date: read.
optrrati0n .AFt~r ait~ot!i~tt~ a i~ser may request actici clLlLts:, sGut~~lt. t`tt;;, 'i'he NSctit Of stÃC1I actions is cfi:ipla\ed ove:r a dssp:liy terminai oi' the cc>rrlptjting d0tee to wlii.ch the portablesystern is connected.

`I'lic databaaL c{ticrs applicatiojt i~~rnploti in-; objects as snade availabie by the o!)juc.t tttstc3ntliit{t)n system may search ct't)s:'s ltinctl(}i1'rllly and t11e cl'FcCl.i~t' rcstill l?1a~ he t;otnputcd {rom a ntzntEscr oi`d Ãtabases o!'the pcirtablc ciata~ase- s~5tem ;

,l hc= prw,isic)sa ol' a launch. c>t~ject, ~wtjl7jeca instar,titÃtrn y~st~:in t1n.' ht2 corresncrnding I)i.l 's, in the portable database sti>tcin ailiows a fu1k it,tnctioinal dat<tht-se:

proci;sst:n~:dpplicaticm to be ruri from the stot-a-i device on 1~vlticlt the portable tlat.tbase stotti is lo<i&d. T'he IaLinch object does not t-cauirt: to he installed ontt) the cotnp~itine-devccefor cipe:ration and the object instantiation sys(em ctiablt~s the database processing application to bc t-Ein without rNuiring tiny f'unctiotittl cap<tbilitic:s of the up~~t-ating stititit~~
t3f the conaputing, device. .'1c:cardin`>l\. no traiis ul' the pc)rtahlc database -,y:,tLm are it.t't ot} the computing devicL throttgh which the portable databtise systc:iii is ueccsacd.

l~i~t 2 iilustrates the portable database systLtn 100 as i 4tdcc3 OntO a st0rage ticvice sirtt:h as a l: Sfi, crltipled to a standalone c.omPtrting device 1 l 6 ha'~
init a C.'E't 1 118 and a RAM 1?(). When tlte portabli dtt.tabijs4 sVstc:rn i,;;Ouplcci 10 >ticfI ~t ct`'rnp.,tittg dc\ ict, the launc;-h ubjc:ct 1 12 is trtstantiated an(i i:s c#isplared tat} the can-tpi.itina ciLvic:e: ! lijs i.amch M object does tisat ne~,~c# Co be itmalleci wn tv tltc ccttnpt.iting devic-e.
'I'llc latztich oh.ieci ciispla~ s a Iisl. c7('dat~base prooi~ssittg applications ttr;ailab1c on the Storagc device. .~ ~i-sc:.r is then requir.cd tb seleia tttic: such application aiid tlye sLlec:.ted application is ioaded ontt) lhc randlJlll 'ciCec`i:'s til't~Tlol't c)f`thP, t;tJmlltlirJJw cit',vicE: 1hG
data prt3ti:SSinL, arpht'.iatIt)Ii yt}

se(ectcci and 1o;3;.tcd then requiE:s a data t3twry appllcatiiln i:)r a c.:stilrlg allLi c<}ntrtdli,lg the database akt3il<thlÃ: on the pcmrtahlt datah,:Ise s)stcm. Th< <3hjet:.t irl,iantitltkHrt s,stcm FInds and in;;tantia.tes ohjcm rcqtlirt~=d bti the cl:lia c{tlav application and tllcrt`hy c:-Iahlil~;
the data proco5sing and data qElery appiications, Whout mquirin<.; :<n;
5tlpl?t>M or t.;tiiii.ini~

any itnctionalities ortht: opLlating yv'mt:m oi thc ct}nlputing devict u) %:hitl7 sl=1e ilortablc da1Ãibasesymein is connc:cted. 1 11:' CC)n1Pilt{ng, device is t}nil rCCIl.I1rC;d for accessing tlit: portzibie database Str:in and ii:lr Ãfispl:lying Oc rewlis of the tlueHcs lirai by t(~e opcrattr. Ai!
t.ht.= rLQrL c:

iEJnllltlrl[Slltl ti and the tj it 1pitiC,E i5111 Gi2t)a billllGs are prc;tiC:r:t \,l?t113ti th~' pt.?!' %:hie 1(7 dat:tbasL stistcm itscl#' alid the s~stem ,loc5 not mike E~se of nti cornl:ui,{i; tlt6<C
Ont:tAn41l ities.

The tlattt prtlecssing al>plicati(ins present ~~ iiflin trtt~ ~~LWtrlbli:
dGe_ab:iyL si sti:n1 are fuli~ lunctionai relatislnal databast applications ancl pro\ icie for ci'I`ecti~t=' dat :}tt?I ~I!)tI
re.trlval and Ãtla} support other iir{taha5e i'unctions such as updatc.
dCICte. s:;<arch, r110Gii1',\

etc. (le applications inay ako emph; an interprete.I' otQj~2ct li;r inlc:rpletlnc~ tf:1Z rE:tri~~tEi froni the i{atabasÃ: in ttte e4i:-nt the data in the dataYlase: is str}red in an onuyMcd 11o.I;IIE:r.
]"it} 3 EtlUstratl'S the ~.~orLable database 1yco11 ct1!1nLt'ttd to a rc'illt)tc su\'a 114Jttlllb a tlataha5c: 128 via a coniptttirt t t3eviÃ:tr 1 i6 hti utiliring the neattvl:
<tbil3i:Ls t4i thv t.ompÃ1tinM; di~,ico I hc portable tiataba4e system as luad::ci on to a 5tc.1r11gC LICViC.: c>r;
connection with acompÃitinfõ device 5carches lÃlr a wwc}r!: Corincctioli so as to :}c LtiÃ: tt}
connect \~ith a rclnilte server asts}cinied "ith the pe:rtahle database slstcr?i. 'I'he rwot:_ f)t)r.el~3~ E~;l::fi? I t`
si'rEer hlols tllt' database <3ni< the data that is ;its() avala:1E}4e on the Cyst{:i71_ S f `I`hc database itastin 7 scrver cloes not rectuirc riii}- end user specific apI-riication ti~?
be installed un it irt urder for the portable database syStein to acccys it as all data procesyins~ and corresponding control is exurt:ise~.j by the pcsrtablt~
database s~ stOM
(oacicd on a stora~,c; c~evitrc. '1'hG cc,~iI~tttir~tg d4vic~~: to ~l hich the pi,rttthl4 s%:~tari~

coupled to is m4rcl}, tisecf as a pipeline tii cotinec,t and at;ccs:s data on t11,t: rz2tn()t;: ;cr\ cr I'oi-i-nission and authentication for accessing the i-eniote databasc tn,to be inct:rporatoci ~~ ithin the portable database svstern or a user mav be requircd to !-se authenticalcd at th+.:
St:rV(;l'.

lities oi'ths rernotc t'li4 portable database system does nOt tttilir.,c any of lttnctio}na -"t`rver Lttid on ccfrinectino ith the renzutt! st rver atitornaticallk s}
nchrtanizcs data ith tlic clataba5e present on the t-etriate server, "I"}ic portable database system rna~ be t~roN'idi:d with a svnc#ironir,ation svstem 124 that rtia} be cUntigtired to autcamatically l<tunchorr t;1c detection of a rretwvrkcc3nnectionl26 a,nd tnav svnchrotiizedzttapre,cntott the ren7otc:
4crver ,Vith data sttaredwithin thcpeir-tabirr database s~sterti.i'he s}nchronizatic;n s~ stc>m I5 aflolws the data base to be moditted, edited.
updated and queried kti'ith respect to thc c#atabasc hosted on the remote scrvEr, ~'h~etrHnsn~issic~i7 of diia fr~tit the pot-table device;i<+~th~~ i-crrtote database and t. ice r er.sa may, be Oone in aiecure. encrypteti format: `I he datat~ase. at tht reiti te ,54t-ver sidc can he citit?ri4ti lior the:,t'oqtfircd data bv makinp use ofi the tiatal34tye query applicatiun 2t~ prt5ertt at the 1?ctrtable C1atabase system, .i:hc dat~ exU=at`tiat3 and maniptEl<3ticm mayhe r~trf6rmed at the ser,,cr sidey by eXecuting the applicaticins anci f1snctions t t the s,imt iit thc, pz7rtabEc dtitabatic, sy5tem.

i~.

Ile, clat<tbttse prcoc.ssing applicati ma antf tlie iiatabasc quert appli::ations mi.
Ãrtaclc available in the -ortx) c71'prctlef1ittd inOdulcs or aplalic.stion devcjoipmLnt I.it,. :\ :i,cr may tltc.n build an application as per hk specific rcqttireinent~, tisina ÃIi:.: ~ivaiial>lc Me>dules in the cleveloptnent kii, nvithout having to create Rom scrittc.h the urppliiatiorr5 reqtaii-ed lor accc4sing anci controiiing tlle ttser"s ci<iwhue. :1i1 objicts ant{ liirwtictatliti4s rc.qtiirQ:d b~ tiie databttsi processin;: and cjitcr4 applications nzati bL
macle fvaiiabie b~, tl.;>
object sitstantitition system pi'ovWed by the p(wt<;ble ciatabaw, sy,tem. :1 d:.,v``opcr :n:l~
,tlsi> atittit>ÃaEiy insert Specilic cabjcc.is or funetionttliLies into the ohject holfsntiatif}Ã~
systern in accordance with specitic reqttire)tILnts. In cllec.t the pc>rtabie database st,teni 1() mov he Ãnade available as an ea.sily configurable set of modules ca.~ttf~(c c~3' f rttii<<i ~
cittt<thrtse processing applisititms and dttlahttse qttcrn applit.ttticftts as lwr ti:ter rc.quirenients ivitltout recltairingany4ubstat3tial reworking or having to creat<< tbc ncce5s<trtapplicatiorts from scratch.

In at.-cEfrdaiicc with an a5pcct UftYtE invcntictn such cctn (igtÃrabli niot.itiles t~ iatb" 15 ntade availttble on a portable storage tncdiitm such as a l-Sf3 clrivQ -1ccordingl~ th;, pc3rtxhle database svstcm may t?4 tiiacle available az tpreloadett 5torage dcvicw c.,ipai.~lir of cC71nnglit`atltJrl in at'cUi'darlcir with LfSE`.i' Sl?L'C1ÃiC
I'L'Cltl4rC11lti~tS. 'l'he priceciing, description describes the essential e.leÃi-lents ol'the in4cntit>n. It zt iil howevcr be apparcnt to oite of ordiÃiÃ~c~,skilt in tht;art that rr3an~ci~.~nt~es and ?f)modificati tis can be tnade thereto xtiithotit rieptwting I'rotti the spirit and scOPc t?f the invention as St;tfflrth heY`E'In. i.5

Claims (14)

1. A portable database system for independent operation on a computing device comprising:
a relational database and at least one application for accessing and controlling the relational database operationally integrated with the relational database, the relational database and application capable of being loaded onto a storage device;
a launch object for displaying on the computing device the applications available on the storage device on connection of the storage device to the computing device such that selection of an application results in the application to be loaded on to the random access memory of the computing device; and an object instantiation system for finding and verifying digital link libraries available on the portable database system and instantiating objects required by the application to access and control the relational database without interacting with the computing device to which the portable system is connected;
such that the application is capable of executing directly from the storage device.
2. A portable database system as claimed in claim 1 wherein the at least one application comprises of a data processing application and a data query application.
3. A portable database system as claimed in claim 1 wherein the launch object comprises of an authorization object for authenticating a user of the portable database system.
4. A portable database system as claimed in claim 1 wherein the launch object is capable of executing directly from the storage device.
5. A portable database system as claimed in claim 1 comprising a synchronization system capable of connecting to a remotely hosted database for synchronization of data between the portable database system and the remotely hosted database.
6. A portable database system as claimed in claim 5 wherein the synchronization system comprises of authentication means for authentication of the portable database system at the remote database.
7. A portable database system as claimed in claim 5 wherein the synchronization system is capable of updating, retrieving or modifying the remotely hosted database.
8. A portable database system as claimed in claim 2 wherein data stored in the relational database is encrypted.
9. A portable database system as claimed in claim 7 comprising an interpreter capable of interpreting data retrieved from the relational database.
10. A method of independently operating a portable database system on a computing device, the portable database system comprising a relational database and at least one application for accessing and controlling the relational database operationally integrated with the relational database, the relational database and application capable of being loaded onto a storage device; the method comprising launching an object for displaying on the computing device the applications available on the portable storage device on connection of the storage device to the computing device;
selecting an application for operating the relational database and loading the selected application on to the random access memory of the computing device;
finding and verifying digital link libraries available on the portable database system and instantiating objects required by the application to access and control the relational database without interacting with the computing device to which the portable system is connected; such that the application is capable of executing directly from the storage device.
11. A method of operating a portable database system on a computing device, the portable database system comprising a relational database, at lease one application for accessing and controlling the relational database operationally integrated with the relational database, and a synchronization system capable of connecting to a remotely hosted database, the relational database, application and synchronization system capable of being loaded onto a storage device; the at least one application comprising of a data processing application and a data query application, the method comprising launching an object for displaying on the computing device the applications available on the storage device on connection of the storage device to the computing device;
selecting an application for operating the relational database and loading the selected application on to the random access memory of the computing device;
finding and verifying digital link libraries available on the portable database system and instantiating objects required by the application to access and control the relational database without interacting with the computing device to which the portable system is connected; such that the application is capable of executing directly from the storage device, operating on data available on the remote database using the data processing and data query applications of the portable database system.
12. A method of synchronizing data between a portable database system and a remotely hosted database, the portable database system comprising a relational database, at lease one application for accessing and controlling the relational database operationally integrated with the relational database, and a synchronization system capable of connecting to a remotely hosted database, the relational database and application capable of being loaded onto a storage device;
the method comprising operatively coupling the portable database system with a computing device;
detecting a network connection on the computing device by the synchronization system;
connecting the portable database system with the remotely hosted database; and synchronizing data between the database of the portable database system and the remotely hosted database.
13. An application development system comprising a plurality of modules, the modules including a set of objects and predetermined functionalities, the modules capable of configuration to form database processing applications and database query applications in accordance with specific user requirements, such that the database processing applications and the database query applications are capable of accessing and controlling a relational database.
14. An application development system as claimed in claim 13 loaded on to a portable storage device.
CA002615645A 2007-08-17 2007-11-13 A portable database system for independent operation on computing device Abandoned CA2615645A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
IN1749/DEL/2007 2007-08-17
IN1749DE2007 2007-08-17

Publications (1)

Publication Number Publication Date
CA2615645A1 true CA2615645A1 (en) 2009-02-17

Family

ID=40374859

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002615645A Abandoned CA2615645A1 (en) 2007-08-17 2007-11-13 A portable database system for independent operation on computing device

Country Status (2)

Country Link
CA (1) CA2615645A1 (en)
WO (1) WO2009024849A2 (en)

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6341288B1 (en) * 1998-07-29 2002-01-22 Sybase, Inc. Database system with methodology for accessing a database from portable devices
US7747872B2 (en) * 2004-03-25 2010-06-29 Franklin Electronic Publishers, Inc. Secure portable electronic reference device
US7661146B2 (en) * 2005-07-01 2010-02-09 Privamed, Inc. Method and system for providing a secure multi-user portable database
EP1952244A2 (en) * 2005-11-09 2008-08-06 Electronic Plastics, LLC Device providing a secure work environment and utilizing a virtual interface
US20080161951A1 (en) * 2007-01-03 2008-07-03 Morris Jeffrey M Portable memory device with dynamically loaded audio content

Also Published As

Publication number Publication date
WO2009024849A3 (en) 2011-04-21
WO2009024849A2 (en) 2009-02-26

Similar Documents

Publication Publication Date Title
US9426272B2 (en) Method and system for a digital diary system
Lomet et al. Unbundling transaction services in the cloud
AU2014384636B2 (en) Systems and methods for ephemeral eventing
EP2038778A2 (en) Global asset management
US20130117307A1 (en) Snapshot isolation support for distributed query processing in a shared disk database cluster
US8924952B1 (en) Updating software utilizing multiple partitions
US20180321711A1 (en) Portable electronic device
US8417712B2 (en) Image querying with relevance-relative scaling
US20230004545A1 (en) Including Transactional Commit Timestamps In The Primary Keys Of Relational Databases
JP5722962B2 (en) Optimize storage performance
US20150177938A1 (en) Providing access to a cloud based content management system on a mobile device
US10922354B2 (en) Reduction of unverified entity identities in a media library
US20150161249A1 (en) Finding personal meaning in unstructured user data
JP2007525758A5 (en)
EP3699759B1 (en) Electronic device and method for managing database
GB2522754A (en) Recording context for conducting searches
US9078288B2 (en) Independent information network
US7739232B2 (en) Programming system for occasionally-connected mobile business applications
CA2615645A1 (en) A portable database system for independent operation on computing device
US20220207003A1 (en) Live data migration system
US20080086483A1 (en) File service system in personal area network
CN103339978B (en) For providing the technology of criminal&#39;s imaging of improvement
CN104731827B (en) The generation method and device of fast distributed file system files metadata
CN116089432A (en) Method and system for implementing sub-table replication and computer readable storage medium
CN115098537B (en) Transaction execution method and device, computing equipment and storage medium

Legal Events

Date Code Title Description
EEER Examination request
FZDE Dead

Effective date: 20141113