Software-as-a-service (SaaS) has emerged as a new computing paradigm to provide reliable software on demand. With such an\ninspiring motivation, sensor cloud system can benefit from this infrastructure. Generally, sharing database and schema is the most\ncommonly used data storage model in the cloud. However, the data storage of tenants in the cloud is approaching schema null\nand evolution issues. To address these limitations, this paper proposes multitenant multiple wide tables with vertical scalability by\nanalyzing the features of multitenant data. To solve schema null issue, extended vertical part is used to trim down the amount of\nschema null values. To reduce probability of schema evolution, wide table is divided into multiple clusters that we called multiple\nwide tables. This design reaches the balance between tenant customizing and its performance. Besides, the partition and correctness\nof multiple wide tables with vertical scalability are discussed in detail. The experimental results indicate that the solution of our\nmultiple wide tables with vertical scalability is superior to single wide table, and single wide table with vertical scalability in the\naspects of spatial intensity and read performance.
Loading....