Migration from an SQL to a hybrid SQL/NoSQL data model

The paper presents a redesign of a database management system for a retail business company. Initially, based on a traditional data model, it is migrated to a hybrid model which combines both SQL and NoSQL databases. This approach adds flexibility, mobility, and efficiency to the data management sys...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Journal of management analytics Ročník 7; číslo 1; s. 1 - 11
Hlavní autoři: Sokolova, Marina V., Gómez, Francisco J., Borisoglebskaya, Larisa N.
Médium: Journal Article
Jazyk:angličtina
Vydáno: Taylor & Francis 02.01.2020
Témata:
digitalization
NoSQL
ontology
RDF
ISSN:2327-0012, 2327-0039
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 paper presents a redesign of a database management system for a retail business company. Initially, based on a traditional data model, it is migrated to a hybrid model which combines both SQL and NoSQL databases. This approach adds flexibility, mobility, and efficiency to the data management system. The NoSQL database uses an ontology as a data schema, which we describe in this study. The NoSQL database is consulted using the SPARQL query language, and some examples of the queries are detailed in the paper. The architecture of the system and its functionality are discussed.
AbstractList The paper presents a redesign of a database management system for a retail business company. Initially, based on a traditional data model, it is migrated to a hybrid model which combines both SQL and NoSQL databases. This approach adds flexibility, mobility, and efficiency to the data management system. The NoSQL database uses an ontology as a data schema, which we describe in this study. The NoSQL database is consulted using the SPARQL query language, and some examples of the queries are detailed in the paper. The architecture of the system and its functionality are discussed.
Author Borisoglebskaya, Larisa N.
Gómez, Francisco J.
Sokolova, Marina V.
Author_xml – sequence: 1
  givenname: Marina V.
  orcidid: 0000-0003-2268-8953
  surname: Sokolova
  fullname: Sokolova, Marina V.
  email: marina.v.sokolova@gmail.com
  organization: Orel State University
– sequence: 2
  givenname: Francisco J.
  surname: Gómez
  fullname: Gómez, Francisco J.
  organization: Department of Computing Systems, University of Castilla-La Mancha
– sequence: 3
  givenname: Larisa N.
  surname: Borisoglebskaya
  fullname: Borisoglebskaya, Larisa N.
  organization: Orel State University
BookMark eNqFkN1KxDAQhYOs4LruIwh5ge5Okv7ijbLoKlRF1OswTRONtI2kAenb27qrF17ozcyZA2c4fMdk1rlOE3LKYMUghzUXPANgfMWBFSs26hjYAZlPfgQgitmPZvyILPv-DSbJigTyOUlv7YvHYF1HjXctxY4-PpQ0OIr0dai8rad7fecmt8aAtHW1bk7IocGm18v9XpDnq8unzXVU3m9vNhdlpESahSjJGKaq4uPkeSx0wvLCJDEzPEY0Kaq0EioHPnYBBFPFXPOsinUqTJbkWS0W5Gz3V3nX914bqWz4qhs82kYykBMF-U1BThTknsKYTn6l371t0Q__5s53OdsZ51v8cL6pZcChcd547JTtpfj7xScdXnIR
CitedBy_id crossref_primary_10_46481_jnsps_2023_1089
crossref_primary_10_19053_01211129_v32_n65_2023_16519
crossref_primary_10_1155_2021_5567234
crossref_primary_10_1109_ACCESS_2025_3572059
crossref_primary_10_1371_journal_pone_0255562
crossref_primary_10_2298_CSIS241024034B
crossref_primary_10_1109_ACCESS_2021_3112880
crossref_primary_10_1007_s10257_022_00555_6
crossref_primary_10_1142_S0219649220500410
Cites_doi 10.1080/23270012.2014.992985
10.1016/j.jii.2019.07.002
10.1016/j.jii.2017.08.001
10.1080/23270012.2015.1020891
10.3233/SW-130114
10.1142/S2424862217500026
10.1016/j.procs.2015.05.367
10.1080/23270012.2016.1141332
10.1080/17517575.2018.1442934
10.1016/j.datak.2014.07.002
10.1177/1086026615592933
10.1016/j.procs.2016.07.120
10.1080/17517575.2018.1446102
10.1080/23270012.2015.1082449
10.1142/S2424862218500033
10.1016/j.compind.2014.07.009
ContentType Journal Article
Copyright 2019 Antai College of Economics and Management, Shanghai Jiao Tong University 2019
Copyright_xml – notice: 2019 Antai College of Economics and Management, Shanghai Jiao Tong University 2019
DBID AAYXX
CITATION
DOI 10.1080/23270012.2019.1700401
DatabaseName CrossRef
DatabaseTitle CrossRef
DatabaseTitleList
DeliveryMethod fulltext_linktorsrc
Discipline Business
EISSN 2327-0039
EndPage 11
ExternalDocumentID 10_1080_23270012_2019_1700401
1700401
Genre Article
GroupedDBID 0BK
0R~
30N
4.4
AAGDL
AAHIA
AALDU
AAMIU
AAPUL
AAQRR
ABJNI
ABLIJ
ABPAQ
ABXUL
ABXYU
ACGFS
ADCVX
ADGTB
AEISY
AEYOC
AFRVT
AGDLA
AHDZW
AHQJS
AIJEM
AIYEW
AKBVH
AKOOK
AKVCP
ALMA_UNASSIGNED_HOLDINGS
ALQZU
AQTUD
AWYRJ
BLEHA
CCCUG
DEAQA
DGEBU
EBS
EUPTU
GTTXZ
H13
HZ~
IPNFZ
KYCEM
LJTGL
M4Z
O9-
RIG
RNANH
ROSJB
RTWRZ
SOJIQ
TASJS
TBQAZ
TDBHL
TEN
TFT
TFW
TTHFI
TUROJ
ZGOLN
AAYXX
CITATION
ID FETCH-LOGICAL-c367t-571a6cb21a62843e5189f541f24aaf6ac6b3c8029500a0fb42e27b4e63f7587d3
IEDL.DBID TFW
ISICitedReferencesCount 12
ISICitedReferencesURI http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000502773500001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
ISSN 2327-0012
IngestDate Sat Nov 29 04:13:14 EST 2025
Tue Nov 18 22:16:00 EST 2025
Mon Oct 20 23:48:55 EDT 2025
IsPeerReviewed true
IsScholarly true
Issue 1
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c367t-571a6cb21a62843e5189f541f24aaf6ac6b3c8029500a0fb42e27b4e63f7587d3
ORCID 0000-0003-2268-8953
PageCount 11
ParticipantIDs informaworld_taylorfrancis_310_1080_23270012_2019_1700401
crossref_citationtrail_10_1080_23270012_2019_1700401
crossref_primary_10_1080_23270012_2019_1700401
PublicationCentury 2000
PublicationDate 2020-01-02
PublicationDateYYYYMMDD 2020-01-02
PublicationDate_xml – month: 01
  year: 2020
  text: 2020-01-02
  day: 02
PublicationDecade 2020
PublicationTitle Journal of management analytics
PublicationYear 2020
Publisher Taylor & Francis
Publisher_xml – name: Taylor & Francis
References Gomez A. (CIT0019) 2015; 2015
CIT0010
CIT0020
CIT0031
CIT0001
CIT0034
CIT0011
CIT0022
CIT0033
Kudo T. (CIT0024) 2017; 9
Rani P. M. T. (CIT0030) 2016; 9
Bouet M. (CIT0007) 2016; 3
CIT0013
CIT0035
CIT0027
CIT0004
CIT0006
CIT0017
Ganiee N. (CIT0018) 2015
CIT0028
CIT0009
References_xml – ident: CIT0004
  doi: 10.1080/23270012.2014.992985
– volume: 9
  start-page: 97
  issue: 3
  year: 2017
  ident: CIT0024
  publication-title: International Journal of Informatics Society
– ident: CIT0001
  doi: 10.1016/j.jii.2019.07.002
– ident: CIT0010
  doi: 10.1016/j.jii.2017.08.001
– ident: CIT0013
  doi: 10.1080/23270012.2015.1020891
– ident: CIT0027
  doi: 10.3233/SW-130114
– ident: CIT0017
  doi: 10.1142/S2424862217500026
– volume: 2015
  start-page: 162
  year: 2015
  ident: CIT0019
  publication-title: Cloud Computing
– ident: CIT0031
  doi: 10.1016/j.procs.2015.05.367
– ident: CIT0009
  doi: 10.1080/23270012.2016.1141332
– volume: 9
  start-page: 1
  issue: 42
  year: 2016
  ident: CIT0030
  publication-title: Indian Journal of Science and Technology
– ident: CIT0035
  doi: 10.1080/17517575.2018.1442934
– volume: 3
  start-page: 1
  issue: 1
  year: 2016
  ident: CIT0007
  publication-title: Open Journal of Information Systems (OJIS)
– ident: CIT0022
  doi: 10.1016/j.datak.2014.07.002
– ident: CIT0034
  doi: 10.1177/1086026615592933
– ident: CIT0020
  doi: 10.1016/j.procs.2016.07.120
– ident: CIT0006
  doi: 10.1080/17517575.2018.1446102
– ident: CIT0011
  doi: 10.1080/23270012.2015.1082449
– ident: CIT0028
  doi: 10.1142/S2424862218500033
– ident: CIT0033
  doi: 10.1016/j.compind.2014.07.009
– year: 2015
  ident: CIT0018
  publication-title: International Journal of Allied Practice, Research and Review
SSID ssj0001219508
Score 2.1735144
Snippet The paper presents a redesign of a database management system for a retail business company. Initially, based on a traditional data model, it is migrated to a...
SourceID crossref
informaworld
SourceType Enrichment Source
Index Database
Publisher
StartPage 1
SubjectTerms digitalization
NoSQL
ontology
RDF
Title Migration from an SQL to a hybrid SQL/NoSQL data model
URI https://www.tandfonline.com/doi/abs/10.1080/23270012.2019.1700401
Volume 7
WOSCitedRecordID wos000502773500001&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
journalDatabaseRights – providerCode: PRVAWR
  databaseName: Taylor & Francis Journals Complete
  customDbUrl:
  eissn: 2327-0039
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0001219508
  issn: 2327-0012
  databaseCode: TFW
  dateStart: 20140102
  isFulltext: true
  titleUrlDefault: https://www.tandfonline.com
  providerName: Taylor & Francis
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV1LS8QwEA6yiHjxLa4vcvDa3U3SJO1RxMWDLoor7q0kaaIL0spuFfz3ZtJWdg_qQS-FBqaUySQzk8x8H0JnSmgn8sRE3Ai4ZjQuSoglkdQ-PJeOcybyQDYhR6NkMklvm2rCeVNWCTm0q4Eiwl4Ni1vpeVsR1_dBANyWQhsVSXsAMBeHDi7v-mFpjoePC6csgeY0MMxRGcFA28bz3YeWHNQSfOmC4xlu_sMvb6GNJurE57WZbKMVW-ygtbbofReJm-lTbQoY-k2wKvD93TWuSqzw8wc0dcF7f1TCKBSV4sCgs4cehpfji6uoYVSIDBOyirgkShhN_dO7JWY5SVLHY-JorJQTygjNTDKgXmcDNXA6ppZKHVvBnM8rZM72UacoC3uAsNMm4QkzWuR-s41JmltufazlE0pNiBNdFLdqzEwDNw6sFy8ZaVBJW51koJOs0UkX9b7EXmu8jd8E0sU5yqpw0OFqVpKM_Sh7-AfZI7ROIfWG0xh6jDrV7M2eoFXzXk3ns9NghZ-tFNI0
linkProvider Taylor & Francis
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV3NS8MwFA8yRb34Lc7PHLx2W9ImaY8ijolbQZy4W0nSRAfSyayC_715_ZDuoB70UmjglfL6mveR934_hM4lV5anofaY5nDMqK0XEkM8oVx4LixjPk8LsgkRx-FkEjVnYaCtEnJoWwJFFHs1_NxQjK5b4rouCoDjUpijIlEHEOYCGOFaZs7XAn7-uP_QqLMURKcFxxwVHizUgzzfPWnBRS0AmDZcT3_zP156C21UgSe-KC1lGy2ZbAet1n3vu4iPpo-lNWAYOcEyw3e3Q5zPsMRPHzDXBffdeAar0FeKCxKdPXTfvxpfDryKVMHTPhe5xwSRXCvqrs4z-YaRMLIsIJYGUlouNVe-DnvUKa0ne1YF1FChAsN961ILkfr7qJXNMnOAsFU6ZKGvFU_dfhuQKDXMuHDL5ZSKEMvbKKj1mOgKcRyIL54TUgGT1jpJQCdJpZM26nyJvZSQG78JRM2PlORFrcOWxCSJ_6Ps4R9kz9DaYDwaJsPr-OYIrVPIxKE4Q49RK5-_mRO0ot_z6ev8tDDJTy1T1l4
linkToPdf http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV3NS8MwFA-iMrz4Lc7PHLx2W5omaY-iFsVZJk7crSRpogPZxlYF_3vz-iHbQT3opdDAK-X1Ne8j7_1-CJ1JrizPQu0xzeGYUVsvJIZ4QrnwXFjGKM8KsgmRJOFgEPWqbsJZ1VYJObQtgSKKvRp-7klm6464tgsC4LQUxqhI1AKAuQAmuFZc6MzByPvx01yZpeA5LSjmfOHBQj3H892TFjzUAn7pnOeJN_7hnTfRehV24vPSTrbQkhlto0bd9b6D-N3wubQFDAMnWI7ww30X52Ms8csHTHXBfTsZwyp0leKCQmcXPcZX_Ytrr6JU8DTlIveYIJJr5bur80vUMBJGlgXE-oGUlkvNFdVhx3c668iOVYFvfKECw6l1iYXI6B5aHo1HZh9hq3TIQqoVz9xuG5AoM8y4YMtllIoQy5soqNWY6gpvHGgvXlNSwZLWOklBJ2mlkyZqfYlNSsCN3wSi-W-U5kWlw5a0JCn9UfbgD7KnqNG7jNPuTXJ7iNZ8SMOhMuMfoeV8-maO0ap-z4ez6UlhkJ-wrdUQ
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=Migration+from+an+SQL+to+a+hybrid+SQL%2FNoSQL+data+model&rft.jtitle=Journal+of+management+analytics&rft.au=Sokolova%2C+Marina+V.&rft.au=G%C3%B3mez%2C+Francisco+J.&rft.au=Borisoglebskaya%2C+Larisa+N.&rft.date=2020-01-02&rft.issn=2327-0012&rft.eissn=2327-0039&rft.volume=7&rft.issue=1&rft.spage=1&rft.epage=11&rft_id=info:doi/10.1080%2F23270012.2019.1700401&rft.externalDBID=n%2Fa&rft.externalDocID=10_1080_23270012_2019_1700401
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2327-0012&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2327-0012&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2327-0012&client=summon