A systematic review of in-memory database over multi-tenancy

The significant cost and time are essential to obtain a comprehensive response, the response time to a query across a peer-to-peer database is one of the most challenging issues. This is particularly exact when dealing with large-scale data processing, where the traditional approach of processing da...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:International journal of electrical and computer engineering (Malacca, Malacca) Ročník 14; číslo 2; s. 1720
Hlavní autoři: Shah, Arpita, Bhatt, Nikita
Médium: Journal Article
Jazyk:angličtina
Vydáno: 01.04.2024
ISSN:2088-8708, 2722-2578
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Abstract The significant cost and time are essential to obtain a comprehensive response, the response time to a query across a peer-to-peer database is one of the most challenging issues. This is particularly exact when dealing with large-scale data processing, where the traditional approach of processing data on a single machine may not be sufficient. The need for a scalable, reliable, and secure data processing system is becoming increasingly important. Managing a single in-memory database instance for multiple tenants is often easier than managing separate databases for each tenant. The research work is focused on scalability with multi-tenancy and more efficiency with a faster querying performance using in-memory database approach. We compare the performance of a row-oriented approach and column-oriented approach on our benchmark human resources (HR) schema using Oracle TimesTen in-memory database. Also, we captured some of the key advantages on optimization dimension(s) are the traditional approach, late-materialization, compression and invisible join on column-store (c-store) and row-base. When compression and late materialization are enabled in a query set; it improves the overall performance of query sets. In particular, the paper aims to elucidate the motivations behind multi-tenant application requirements concerning the database engine and highlight major designs over in-memory database for the tenancy approach on cloud.
AbstractList The significant cost and time are essential to obtain a comprehensive response, the response time to a query across a peer-to-peer database is one of the most challenging issues. This is particularly exact when dealing with large-scale data processing, where the traditional approach of processing data on a single machine may not be sufficient. The need for a scalable, reliable, and secure data processing system is becoming increasingly important. Managing a single in-memory database instance for multiple tenants is often easier than managing separate databases for each tenant. The research work is focused on scalability with multi-tenancy and more efficiency with a faster querying performance using in-memory database approach. We compare the performance of a row-oriented approach and column-oriented approach on our benchmark human resources (HR) schema using Oracle TimesTen in-memory database. Also, we captured some of the key advantages on optimization dimension(s) are the traditional approach, late-materialization, compression and invisible join on column-store (c-store) and row-base. When compression and late materialization are enabled in a query set; it improves the overall performance of query sets. In particular, the paper aims to elucidate the motivations behind multi-tenant application requirements concerning the database engine and highlight major designs over in-memory database for the tenancy approach on cloud.
Author Shah, Arpita
Bhatt, Nikita
Author_xml – sequence: 1
  givenname: Arpita
  orcidid: 0000-0003-1877-0997
  surname: Shah
  fullname: Shah, Arpita
– sequence: 2
  givenname: Nikita
  orcidid: 0000-0002-3243-5901
  surname: Bhatt
  fullname: Bhatt, Nikita
BookMark eNot0MtqwzAQBVBRUmia5h_0A3I1smTJ0E0IfQQC3bRrIcsjUIkfSK6L_75p0s3cWV0u556s-qFHQijwAkDV8Bi_0GMxg4yiGEfQgrPzqW_IWmghmFDarM4_N4YZzc0d2eYcGy6lllxXak2edjQvecLOTdHThHPEHzoEGnvWYTekhbZuco3LSIcZE-2-T1NkE_au98sDuQ3ulHH7nxvy-fL8sX9jx_fXw353ZB6qumZCKumRhwaDAOnK1lQaamy0F62TojUK_Xm0UFCKAGWDruKlCTJw0Eo1bbkh5trr05BzwmDHFDuXFgvcXiDsBcJeIOwVwv5BlL-yEVYx
ContentType Journal Article
DBID AAYXX
CITATION
DOI 10.11591/ijece.v14i2.pp1720-1729
DatabaseName CrossRef
DatabaseTitle CrossRef
DatabaseTitleList CrossRef
DeliveryMethod fulltext_linktorsrc
Discipline Engineering
EISSN 2722-2578
ExternalDocumentID 10_11591_ijece_v14i2_pp1720_1729
GroupedDBID .4S
.DC
8FE
8FG
AAKDD
AAYXX
ABJCF
ABUWG
AFFHD
AFKRA
ALMA_UNASSIGNED_HOLDINGS
ARAPS
ARCSS
BENPR
BGLVJ
BPHCQ
BVBZV
CCPQU
CITATION
EOJEC
HCIFZ
I-F
K6V
K7-
KWQ
L6V
M7S
OBODZ
OK1
P62
PHGZM
PHGZT
PQGLB
PQQKQ
PROAC
PTHSS
TUS
ID FETCH-LOGICAL-c1699-2454ce0fbef214a3d86719eb7c2da42d85ec72925132f13bea6038f4f01755bd3
ISSN 2088-8708
IngestDate Sat Nov 29 02:39:45 EST 2025
IsDoiOpenAccess false
IsOpenAccess true
IsPeerReviewed false
IsScholarly true
Issue 2
Language English
License http://creativecommons.org/licenses/by-sa/4.0
LinkModel OpenURL
MergedId FETCHMERGED-LOGICAL-c1699-2454ce0fbef214a3d86719eb7c2da42d85ec72925132f13bea6038f4f01755bd3
ORCID 0000-0003-1877-0997
0000-0002-3243-5901
OpenAccessLink https://ijece.iaescore.com/index.php/IJECE/article/download/33975/17247
ParticipantIDs crossref_primary_10_11591_ijece_v14i2_pp1720_1729
PublicationCentury 2000
PublicationDate 2024-04-01
PublicationDateYYYYMMDD 2024-04-01
PublicationDate_xml – month: 04
  year: 2024
  text: 2024-04-01
  day: 01
PublicationDecade 2020
PublicationTitle International journal of electrical and computer engineering (Malacca, Malacca)
PublicationYear 2024
SSID ssib044740765
ssj0000866295
Score 2.2847795
SecondaryResourceType review_article
Snippet The significant cost and time are essential to obtain a comprehensive response, the response time to a query across a peer-to-peer database is one of the most...
SourceID crossref
SourceType Index Database
StartPage 1720
Title A systematic review of in-memory database over multi-tenancy
Volume 14
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVHPJ
  databaseName: ROAD: Directory of Open Access Scholarly Resources (selected full-text only)
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssib044740765
  issn: 2088-8708
  databaseCode: M~E
  dateStart: 20110101
  isFulltext: true
  titleUrlDefault: https://road.issn.org
  providerName: ISSN International Centre
– providerCode: PRVPQU
  databaseName: Advanced Technologies & Aerospace Database
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000866295
  issn: 2088-8708
  databaseCode: P5Z
  dateStart: 20110901
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/hightechjournals
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Computer Science Database
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000866295
  issn: 2088-8708
  databaseCode: K7-
  dateStart: 20110901
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/compscijour
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: East & South Asia Database (ProQuest)
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000866295
  issn: 2088-8708
  databaseCode: BVBZV
  dateStart: 20110901
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/eastsouthasia
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Engineering Database
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000866295
  issn: 2088-8708
  databaseCode: M7S
  dateStart: 20110901
  isFulltext: true
  titleUrlDefault: http://search.proquest.com
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Central
  customDbUrl:
  eissn: 2722-2578
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0000866295
  issn: 2088-8708
  databaseCode: BENPR
  dateStart: 20110901
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1NT9wwELWWj0N7QKW0agutfOhtZZo4ThxLXFYViAOskICKW2THtligYbWlW7jwF_jLHdtJNluKoJW4WJG1O0r0np7H4_EMQp9torVgWUos05KwLOJEgRQTJlQC_BCK-5Ys3_b4cJifnIiDXu-uuQszveBVlV9fi_GzQg1zALa7OvsPcLdGYQKeAXQYAXYYnwT84F515l-hLgT57rJqb_ouKdQtXn2XvRkyCgl4zk5mu67qfKywU2EidM5pqwyUdV-IvpmVNnR-6768kABcuBBUP7ZRh8NT6eM5g4nrWtLGBE5lOKsajs6b6ToiQbuJLF64KCgXqGwUdNWEOQ6bXicPc8rLOgyjHRkFryr6u76nwgn86MyUZnMasxHdHI_drwkMYramNef4fyx1bQKi3_qArcJbKrylIlgqnKUFtER5KpxM7t9uNwLFGIf9b30s7Jf6PMuo7-zTfnOTLQbGvzzwmh0XqOPLHL1CK_UmBA8CeVZRz1Sv0ctOaco1tDXAMxrhQCN8aXFLI9zQCDsa4TkavUHHO9tHX3dJ3WmDlHEm3BFbykoTWWUsjZlMtKt6KIziJdWSUZ2npoQXB184oTZOlJFZlOSWWdDzNFU6eYsWq8vKvEOY6RScHskjmSlWKqN0RDVnJjc8Fzay71HcfHwxDgVVisfQ-PAf_1lHL2bc3ECLV5Of5iNaLqdXox-TTx7W3zHdclM
linkProvider ISSN International Centre
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=A+systematic+review+of+in-memory+database+over+multi-tenancy&rft.jtitle=International+journal+of+electrical+and+computer+engineering+%28Malacca%2C+Malacca%29&rft.au=Shah%2C+Arpita&rft.au=Bhatt%2C+Nikita&rft.date=2024-04-01&rft.issn=2088-8708&rft.eissn=2722-2578&rft.volume=14&rft.issue=2&rft.spage=1720&rft_id=info:doi/10.11591%2Fijece.v14i2.pp1720-1729&rft.externalDBID=n%2Fa&rft.externalDocID=10_11591_ijece_v14i2_pp1720_1729
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2088-8708&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2088-8708&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2088-8708&client=summon