{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,5,25]],"date-time":"2024-05-25T16:40:02Z","timestamp":1716655202755},"reference-count":19,"publisher":"SAGE Publications","issue":"4","license":[{"start":{"date-parts":[[2014,4,1]],"date-time":"2014-04-01T00:00:00Z","timestamp":1396310400000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/journals.sagepub.com\/page\/policies\/text-and-data-mining-license"}],"funder":[{"name":"Doctoral Fund of University of Jinan","award":["XBS1237","J1344","2011GGX10116","2012BAF12B07"],"award-info":[{"award-number":["XBS1237","J1344","2011GGX10116","2012BAF12B07"]}]}],"content-domain":{"domain":["journals.sagepub.com"],"crossmark-restriction":true},"short-container-title":["International Journal of Distributed Sensor Networks"],"published-print":{"date-parts":[[2014,4,1]]},"abstract":"<jats:p>Software-as-a-service (SaaS) has emerged as a new computing paradigm to provide reliable software on demand. With such an inspiring motivation, sensor cloud system can benefit from this infrastructure. Generally, sharing database and schema is the most commonly used data storage model in the cloud. However, the data storage of tenants in the cloud is approaching schema null and evolution issues. To address these limitations, this paper proposes multitenant multiple wide tables with vertical scalability by analyzing the features of multitenant data. To solve schema null issue, extended vertical part is used to trim down the amount of schema null values. To reduce probability of schema evolution, wide table is divided into multiple clusters that we called multiple wide tables. This design reaches the balance between tenant customizing and its performance. Besides, the partition and correctness of multiple wide tables with vertical scalability are discussed in detail. The experimental results indicate that the solution of our multiple wide tables with vertical scalability is superior to single wide table, and single wide table with vertical scalability in the aspects of spatial intensity and read performance.<\/jats:p>","DOI":"10.1155\/2014\/583686","type":"journal-article","created":{"date-parts":[[2014,4,2]],"date-time":"2014-04-02T23:12:55Z","timestamp":1396480375000},"page":"583686","update-policy":"http:\/\/dx.doi.org\/10.1177\/sage-journals-update-policy","source":"Crossref","is-referenced-by-count":9,"title":["Multiple Wide Tables with Vertical Scalability in Multitenant Sensor Cloud Systems"],"prefix":"10.1177","volume":"10","author":[{"given":"Kun","family":"Ma","sequence":"first","affiliation":[{"name":"Shandong Provincial Key Laboratory of Network Based Intelligent Computing, University of Jinan, Jinan 250022, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bo","family":"Yang","sequence":"additional","affiliation":[{"name":"Shandong Provincial Key Laboratory of Network Based Intelligent Computing, University of Jinan, Jinan 250022, China"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"179","published-online":{"date-parts":[[2014,4,2]]},"reference":[{"key":"B1-2014-583686","doi-asserted-by":"publisher","DOI":"10.1145\/1721654.1721672"},{"issue":"1","key":"B2-2014-583686","volume":"72","author":"D C.","year":"2009","journal-title":"Communications in Computer and Information Science"},{"key":"B4-2014-583686","doi-asserted-by":"publisher","DOI":"10.1155\/2013\/917923"},{"key":"B5-2014-583686","first-page":"961","volume-title":"Proceedings of the 14th International Conference on Advanced Communication Technology (ICACT \u203212)","author":"Park K."},{"key":"B6-2014-583686","first-page":"1310","volume-title":"Proceedings of the 14th International Conference on Advanced Communication Technology (ICACT \u203212)","author":"Lee J."},{"key":"B7-2014-583686","doi-asserted-by":"publisher","DOI":"10.1109\/NWeSP.2011.6088144"},{"issue":"2","key":"B8-2014-583686","first-page":"25","volume":"9","author":"Ma K.","year":"2012","journal-title":"Acta Polytechnica Hungarica"},{"key":"B9-2014-583686","first-page":"161","volume-title":"Proceedings of the 1st ACM Symposium on Cloud Computing","author":"Woollen R."},{"key":"B10-2014-583686","first-page":"415","volume-title":"Proceedings of the 19th Annual International Conference on Mobile Computing & Networking","author":"Tirri H."},{"key":"B11-2014-583686","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247571"},{"issue":"9","key":"B12-2014-583686","first-page":"133","volume":"32","author":"Ma K.","year":"2011","journal-title":"Chinese Journal on Communications"},{"key":"B13-2014-583686","doi-asserted-by":"publisher","DOI":"10.1016\/j.proeng.2011.12.682"},{"key":"B14-2014-583686","doi-asserted-by":"publisher","DOI":"10.1155\/2013\/867693"},{"key":"B15-2014-583686","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559941"},{"key":"B16-2014-583686","volume-title":"Fundamentals of Database Systems","author":"Elmasri R.","year":"2010"},{"key":"B17-2014-583686","doi-asserted-by":"publisher","DOI":"10.1145\/1978915.1978919"},{"key":"B18-2014-583686","doi-asserted-by":"publisher","DOI":"10.1007\/s11704-008-0050-7"},{"issue":"2","key":"B19-2014-583686","doi-asserted-by":"crossref","first-page":"88","DOI":"10.1080\/00031305.1994.10476030","volume":"48","author":"Pukelsheim F.","year":"1994","journal-title":"The American Statistician"},{"key":"B20-2014-583686","volume-title":"Pivot Table Data Crunching","author":"Jelen B.","year":"2010"}],"container-title":["International Journal of Distributed Sensor Networks"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/journals.sagepub.com\/doi\/pdf\/10.1155\/2014\/583686","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/journals.sagepub.com\/doi\/full-xml\/10.1155\/2014\/583686","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/journals.sagepub.com\/doi\/pdf\/10.1155\/2014\/583686","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,5,25]],"date-time":"2024-05-25T16:04:11Z","timestamp":1716653051000},"score":1,"resource":{"primary":{"URL":"http:\/\/journals.sagepub.com\/doi\/10.1155\/2014\/583686"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,4,1]]},"references-count":19,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2014,4,1]]}},"alternative-id":["10.1155\/2014\/583686"],"URL":"https:\/\/doi.org\/10.1155\/2014\/583686","relation":{},"ISSN":["1550-1477","1550-1477"],"issn-type":[{"value":"1550-1477","type":"print"},{"value":"1550-1477","type":"electronic"}],"subject":[],"published":{"date-parts":[[2014,4,1]]}}}