Abstract
Today, most real-world applications are dealing with some form of dimensional data. In recent years, the large, heterogeneous, and multidimensional data have gained significant attention. The complex multidimensional data are being generated at a very rapid pace through various disparate potential resources and sensors, scientific instruments, and internet, especially the social media, are just to name a few. Though, the volume of the data is expanding with a considerable velocity, the data management techniques are not advancing at the same pace, resulting in the scarcity of suitably efficient data processing systems. This unexpected gap of advancement has raised serious concerns in the data community. Presently, in data science, one of the fast-growing needs is to advance the query processing system to efficiently deal with the increasingly complex and sizable data. This research work also aims to address such challenges and attempts to expand the bandwidth of the querying system of the Parametric Data Model. It is an efficient dimensional data model, which comes equipped with its own SQL-like query language, known as Parametric Structured Query Language (ParaSQL).
Similar content being viewed by others
Notes
Readers are advised to read the Sect. 3 for visual representation of the Parametric Data Model.
References
Anderson JC, Slater N, Lehnardt J (2009) CouchDB: the definitive guide , 1st edn. O’Reilly Media, p 300, ISBN:0-596-15816-5
Armbrust M, Xin RS, Lian C, Huai Y, Liu D, Bradley JK, Zaharia M (2015) Spark sql: relational data processing in spark. In Proceedings of the 2015 ACM SIGMOD International Conference on Management of data. ACM, pp 1383–1394
Brown MC (2011) Getting started with CouchDB , 1st edn, O’Reilly Media, p 50, ISBN:1-4493-0755-8
Chen Z, Yang S, Shang Y, Liu Y, Wang F, Wang L, Fu J (2016) Fragment re-allocation strategy based on hypergraph for NoSQL database systems. Int J Grid High Perform Comput (IJGHPC) 8(3):1–23
Chodorow K, Dirolf M (2010) MongoDB: the definitive guide , 1st edn, O’Reilly Media, p 216, ISBN:978-1-4493-8156-1
Gadia SK, Chopra V (1993) A relational model and SQL-like query language for spatial databases. In advanced database systems. Springer, Berlin, pp 213–225
Gadia SK, Nair SS (1993) Temporal databases: a prelude to parametric data. In: Tansel AU et al (eds) Temporal databases: theory, design, and implementation, chap 2. Benjamin/Cummings, Redwood City, CA, pp 28–66
Gadia SK, Gutowski WJ, Al-Kaisi M, Taylor SE, Herzmann D (2004) Database tools promoting extensive, user-friendly access to the iowa environmental mesonet. Baker Proposal
Hahmann, S., Burghardt, D, Weber B (2011) “80% of All information is geospatially referenced”??? towards a research framework: using the semantic web for (In) validating this famous geo assertion. In: Proceedings of the 14th AGILE Conference on Geographic Information Science
Lakshman A, Malik P (2011) The Apache Cassandra Project. [Online] http://cassandra.apache.org/
Liao YT, Zhou J, Lu CH, Chen SC, Hsu CH, Chen W, Chung YC (2016) Data adapter for querying and transformation between SQL and NoSQL database. Future Gener Comput Syst 65:111121
Lomotey RK, Deters R (2015) Terms analytics service for couchDB: a document-based NoSQL. Int J Big Data Intell 2(1):23–36
Michael JF, Donald K, Tim K, Sukriti R, Reynold X (2011) CrowdDB: answering queries with crowdsourcing. In: Proceedings of the 2011 International Conference on Management of Data, Athens, Greece. doi:10.1145/1989323.1989331
Mishra V (2014) Titan graph databases with cassandra. In: Beginning apache cassandra development. Apress, Berkeley, CA, USA, pp 123–151
NCRA (2004). North Central Regional Association of State Agricultural Experiment Station Directors. Expected Outcomes. NC094: Impact of Climate and Soils on Crop Selection and Management [Online]. http://www.lgu.umd.edu/lgu_v2/pages/attachs/474_NC94ExpectedOutcomes.html
Noh SY (2006) Hybrid storage design for NC94 database within the parametric data model framework. In: Proceedings of the International Conference on Computational Science and its Applications, part II, Glasgow, UK, pp 145–154
Panzarino O (2014) Learning Cypher. Packt Publishing Ltd, Birmingham
Rodriguez MA (2015) The gremlin graph traversal machine and language (invited talk). In: Proceedings of the 15th Symposium on Database Programming Languages. ACM, pp 1–10
Sharma S (2016) Expanded cloud plumes hiding big data ecosystem. Future Gener Comput Syst 59:63–92
Sharma S, Shandilya R, Patnaik S, Mahapatra A (2016) Leading NoSQL models for handling big data: a brief review. Int J Bus Inf Syst 22(1):1–25
Sharma S, Tim US, Wong J, Gadia S, Sharma S (2014) A brief review on leading big data models. Data Sci J 13:138–157
Sharma S, Tim US, Gadia S, Wong J, Shandilya R, Peddoju SK (2015) Classification and comparison of noSQL big data models. Int J Big Data Intell 2(3):201–221
Stirling RM (2002) Data management in the 21st century emerging technologies and their implication for hydrography. In: FIG XXII International Congress, Washington, DC, USA
United States Federal Government Federal Information Processing Standard (1994). http://en.wikipedia.org/wiki/FIPS
Vukotic A et al. (2015) Neo4j in action. Manning
Walsh L, Akhmechet V, Glukhovsky M (2009) Rethinkdb-rethinking database storage. Hexagram 49. Inc, New York
Wicht B (2010) Presentation and use of H2 Database Engine. @Blog(“Baptiste Wicht”). [Online] http://www.baptiste-wicht.com/2010/08/presentation-usage-h2-database-engine/. Accessed 17 Sept 2013
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Sharma, S., Gadia, S. Expanding ParaSQL for spatio-temporal (big) data. J Supercomput 75, 587–606 (2019). https://doi.org/10.1007/s11227-016-1955-9
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11227-016-1955-9