Skip to main content
Log in

Expanding ParaSQL for spatio-temporal (big) data

  • Published:
The Journal of Supercomputing Aims and scope Submit manuscript

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).

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13

Similar content being viewed by others

Notes

  1. Readers are advised to read the Sect. 3 for visual representation of the Parametric Data Model.

References

  1. Anderson JC, Slater N, Lehnardt J (2009) CouchDB: the definitive guide , 1st edn. O’Reilly Media, p 300, ISBN:0-596-15816-5

  2. 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

  3. Brown MC (2011) Getting started with CouchDB , 1st edn, O’Reilly Media, p 50, ISBN:1-4493-0755-8

  4. 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

    Article  Google Scholar 

  5. Chodorow K, Dirolf M (2010) MongoDB: the definitive guide , 1st edn, O’Reilly Media, p 216, ISBN:978-1-4493-8156-1

  6. 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

    Google Scholar 

  7. 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

  8. 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

  9. 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

  10. Lakshman A, Malik P (2011) The Apache Cassandra Project. [Online] http://cassandra.apache.org/

  11. 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

    Article  Google Scholar 

  12. Lomotey RK, Deters R (2015) Terms analytics service for couchDB: a document-based NoSQL. Int J Big Data Intell 2(1):23–36

    Article  Google Scholar 

  13. 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

  14. Mishra V (2014) Titan graph databases with cassandra. In: Beginning apache cassandra development. Apress, Berkeley, CA, USA, pp 123–151

  15. 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

  16. 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

  17. Panzarino O (2014) Learning Cypher. Packt Publishing Ltd, Birmingham

    Google Scholar 

  18. 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

  19. Sharma S (2016) Expanded cloud plumes hiding big data ecosystem. Future Gener Comput Syst 59:63–92

    Article  Google Scholar 

  20. 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

    Google Scholar 

  21. 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

    Article  Google Scholar 

  22. 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

    Article  Google Scholar 

  23. Stirling RM (2002) Data management in the 21st century emerging technologies and their implication for hydrography. In: FIG XXII International Congress, Washington, DC, USA

  24. United States Federal Government Federal Information Processing Standard (1994). http://en.wikipedia.org/wiki/FIPS

  25. Vukotic A et al. (2015) Neo4j in action. Manning

  26. Walsh L, Akhmechet V, Glukhovsky M (2009) Rethinkdb-rethinking database storage. Hexagram 49. Inc, New York

    Google Scholar 

  27. 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

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Sugam Sharma.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

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

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11227-016-1955-9

Keywords

Navigation