Columnar NoSQL CUBE: Agregation operator for columnar NoSQL data warehouse

The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment able to find information quickly in a large volume of data. The column-oriented NoSQL (Not Only SQL) database provide for big data the most s...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Conference proceedings - IEEE International Conference on Systems, Man, and Cybernetics S. 3828 - 3833
Hauptverfasser: Dehdouh, Khaled, Bentayeb, Fadila, Boussaid, Omar, Kabachi, Nadia
Format: Tagungsbericht
Sprache:Englisch
Veröffentlicht: IEEE 01.10.2014
Schlagworte:
Accidents
Big data
Data models
Data warehouses
Distributed databases
Roads
ISSN:1062-922X
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Abstract The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment able to find information quickly in a large volume of data. The column-oriented NoSQL (Not Only SQL) database provide for big data the most suitable model to the data warehouse and the structure of multidimensional data in OLAP cube form. However, in the absence of OLAP cube computation operators, we propose in this paper, a new aggregation operator called CN-CUBE (Columnar NoSQL CUBE), which allows data cubes to be computed from data warehouses stored in column-oriented NoSQL database management system. We implemented the CNCUBE operator using the SQL Phoenix interface of HBase DBMS and conducted experiments on a public data warehouse in a distributed environment produced using the Hadoop platform. Thus we have shown that our CN-CUBE operator has OLAP cubes computation times very suitable for NoSQL warehouses.
AbstractList The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment able to find information quickly in a large volume of data. The column-oriented NoSQL (Not Only SQL) database provide for big data the most suitable model to the data warehouse and the structure of multidimensional data in OLAP cube form. However, in the absence of OLAP cube computation operators, we propose in this paper, a new aggregation operator called CN-CUBE (Columnar NoSQL CUBE), which allows data cubes to be computed from data warehouses stored in column-oriented NoSQL database management system. We implemented the CNCUBE operator using the SQL Phoenix interface of HBase DBMS and conducted experiments on a public data warehouse in a distributed environment produced using the Hadoop platform. Thus we have shown that our CN-CUBE operator has OLAP cubes computation times very suitable for NoSQL warehouses.
Author Boussaid, Omar
Kabachi, Nadia
Dehdouh, Khaled
Bentayeb, Fadila
Author_xml – sequence: 1
  givenname: Khaled
  surname: Dehdouh
  fullname: Dehdouh, Khaled
  email: Khaled.Dehdouh@univ-lyon2.fr
  organization: ERIC Lab., Univ. of Lyon 2, Bron, France
– sequence: 2
  givenname: Fadila
  surname: Bentayeb
  fullname: Bentayeb, Fadila
  email: Fadila.Bentayeb@univ-lyon2.fr
  organization: ERIC Lab., Univ. of Lyon 2, Bron, France
– sequence: 3
  givenname: Omar
  surname: Boussaid
  fullname: Boussaid, Omar
  email: Omar.Boussaid@univ-lyon2.fr
  organization: ERIC Lab., Univ. of Lyon 2, Bron, France
– sequence: 4
  givenname: Nadia
  surname: Kabachi
  fullname: Kabachi, Nadia
  email: Nadia.Kabachi@univ-lyon2.fr
  organization: ERIC Lab., Univ. of Lyon 2, Bron, France
BookMark eNpVj09Lw0AUxFeoYFt7F7zsF0h8-3aT3eethtY_REVqwVvZJJsaabNlkyJ-ewP24mGYOfwYZiZs1PrWMXYlIBYC6Gb1nMUIQsUpaZWgPmMz0kYoTSSNAj1iYwEpRoT4ccEmXfcFgKCEGbOnzO-O-9YG_uJXbznP1neLWz7fBre1feNb7g8u2N4HXg8q_8OV7S3_tsF9-mPnLtl5bXedm518ytbLxXv2EOWv94_ZPI8aoZM-KnRdgTUJFlSIErWCEo0jIyqQae3Q6lIWZEklpCqhayxKLaUiqIYwzJZTdv3X2zjnNofQ7G342Zyuy19K8U2L
ContentType Conference Proceeding
DBID 6IE
6IH
CBEJK
RIE
RIO
DOI 10.1109/SMC.2014.6974527
DatabaseName IEEE Electronic Library (IEL) Conference Proceedings
IEEE Proceedings Order Plan (POP) 1998-present by volume
IEEE Xplore All Conference Proceedings
IEEE Electronic Library (IEL)
IEEE Proceedings Order Plans (POP) 1998-present
DatabaseTitleList
Database_xml – sequence: 1
  dbid: RIE
  name: IEEE Electronic Library (IEL)
  url: https://ieeexplore.ieee.org/
  sourceTypes: Publisher
DeliveryMethod fulltext_linktorsrc
Discipline Engineering
Sciences (General)
EISBN 9781479938407
1479938408
EndPage 3833
ExternalDocumentID 6974527
Genre orig-research
GroupedDBID 29F
6IE
6IF
6IH
6IK
6IL
6IM
6IN
AAJGR
AAWTH
ABLEC
ADZIZ
ALMA_UNASSIGNED_HOLDINGS
BEFXN
BFFAM
BGNUA
BKEBE
BPEOZ
CBEJK
CHZPO
IEGSK
IJVOP
IPLJI
M43
OCL
RIE
RIL
RIO
RNS
ID FETCH-LOGICAL-i175t-b7fd0a852b9b1c2740c28e981d036fe2a7c3b9a94594d17f2bc733490dbc70203
IEDL.DBID RIE
ISICitedReferencesCount 13
ISICitedReferencesURI http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000370963703161&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
ISSN 1062-922X
IngestDate Wed Aug 27 04:48:10 EDT 2025
IsPeerReviewed false
IsScholarly true
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-i175t-b7fd0a852b9b1c2740c28e981d036fe2a7c3b9a94594d17f2bc733490dbc70203
PageCount 6
ParticipantIDs ieee_primary_6974527
PublicationCentury 2000
PublicationDate 2014-Oct.
PublicationDateYYYYMMDD 2014-10-01
PublicationDate_xml – month: 10
  year: 2014
  text: 2014-Oct.
PublicationDecade 2010
PublicationTitle Conference proceedings - IEEE International Conference on Systems, Man, and Cybernetics
PublicationTitleAbbrev SMC
PublicationYear 2014
Publisher IEEE
Publisher_xml – name: IEEE
SSID ssj0020418
Score 1.9819305
Snippet The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment...
SourceID ieee
SourceType Publisher
StartPage 3828
SubjectTerms Accidents
Big data
Data models
Data warehouses
Distributed databases
Roads
Title Columnar NoSQL CUBE: Agregation operator for columnar NoSQL data warehouse
URI https://ieeexplore.ieee.org/document/6974527
WOSCitedRecordID wos000370963703161&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV3NS8MwFH9sw4NedB_iNzl4ULBbmrRN403LhoiOyRzsNpI01V3a0W3675u0dTrw4i2EBMJ7JO_38t7vPYDLRLqJ9ELqxJ6ylBwhHOFj4fAQy5j6XPlcFM0m2HAYTqd8VIObDRdGa10kn-muHRax_DhTa_tV1gsM-PUJq0OdsaDkam2cK-y5Je0tIA4nZPodksS8N36ObA6X1632bzVSKezIYP9_JziAzg8hD402pqYJNZ22YO9XLcEWNKtbukRXVSnp6zY8RvbxSUWOhtn45QlFk_v-LbozPvZboRGULXQRZ0cGuyK1vdgmj6JPkev3bL3UHZgM-q_Rg1N1T3DmBhKsHMmSGIvQJ5JLVxnnEysSam7wqTFaiSaCKSq54J7PvdhlCZGKUepxHJuBjU8eQiPNUn0ECEtCJdUhl0rYemaCBoJrLzZwUWAi5DG0rahmi7JAxqyS0snf06ewa7VRZsSdQWOVr_U57KiP1XyZXxRa_QJfSaD9
linkProvider IEEE
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV1LTwIxEJ4gmqgX5WF824MHTVwobZfdelMCQQWCARJupO12lcsu4aF_33Z3RUm8eGuapmlm0s43nflmAK5DWQsl86kTMGUpOUI4wsXC4T6WAXW5crlImk14vZ4_HvN-Du7WXBitdZJ8pit2mMTyg1it7FdZtW7Ar0u8Ldh2GSM4ZWut3SvMainxrU4cTsj4OyiJeXXQbdgsLlbJdthopZJYktbB_85wCOUfSh7qr41NAXI6KsL-r2qCRShk93SBbrJi0rcleG7Y5ycSc9SLB68d1Bg9Nu_Rg_Gy3xKdoHimk0g7MugVqc3FNn0UfYq5fo9XC12GUas5bLSdrH-CMzWgYOlILwyw8F0iuawp435iRXzNDUI1ZivURHiKSi44czkLal5IpPIoZRwHZmAjlEeQj-JIHwPCklBJtc-lEraimaB1wTULDGAUmAh5AiUrqsksLZExyaR0-vf0Fey2h93OpPPUezmDPauZND_uHPLL-UpfwI76WE4X88tEw1_xh6RE
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%3Abook&rft.genre=proceeding&rft.title=Conference+proceedings+-+IEEE+International+Conference+on+Systems%2C+Man%2C+and+Cybernetics&rft.atitle=Columnar+NoSQL+CUBE%3A+Agregation+operator+for+columnar+NoSQL+data+warehouse&rft.au=Dehdouh%2C+Khaled&rft.au=Bentayeb%2C+Fadila&rft.au=Boussaid%2C+Omar&rft.au=Kabachi%2C+Nadia&rft.date=2014-10-01&rft.pub=IEEE&rft.issn=1062-922X&rft.spage=3828&rft.epage=3833&rft_id=info:doi/10.1109%2FSMC.2014.6974527&rft.externalDocID=6974527
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1062-922X&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1062-922X&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1062-922X&client=summon