The Journal of Supercomputing

, Volume 75, Issue 2, pp 587–606 | Cite as

Expanding ParaSQL for spatio-temporal (big) data

  • Sugam SharmaEmail author
  • Shashi Gadia


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


Query Expansion Parametric Data Model 


  1. 1.
    Anderson JC, Slater N, Lehnardt J (2009) CouchDB: the definitive guide , 1st edn. O’Reilly Media, p 300, ISBN:0-596-15816-5Google Scholar
  2. 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–1394Google Scholar
  3. 3.
    Brown MC (2011) Getting started with CouchDB , 1st edn, O’Reilly Media, p 50, ISBN:1-4493-0755-8Google Scholar
  4. 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–23CrossRefGoogle Scholar
  5. 5.
    Chodorow K, Dirolf M (2010) MongoDB: the definitive guide , 1st edn, O’Reilly Media, p 216, ISBN:978-1-4493-8156-1Google Scholar
  6. 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–225Google Scholar
  7. 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–66Google Scholar
  8. 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 ProposalGoogle Scholar
  9. 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 ScienceGoogle Scholar
  10. 10.
    Lakshman A, Malik P (2011) The Apache Cassandra Project. [Online]
  11. 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:111121CrossRefGoogle Scholar
  12. 12.
    Lomotey RK, Deters R (2015) Terms analytics service for couchDB: a document-based NoSQL. Int J Big Data Intell 2(1):23–36CrossRefGoogle Scholar
  13. 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. 14.
    Mishra V (2014) Titan graph databases with cassandra. In: Beginning apache cassandra development. Apress, Berkeley, CA, USA, pp 123–151Google Scholar
  15. 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].
  16. 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–154Google Scholar
  17. 17.
    Panzarino O (2014) Learning Cypher. Packt Publishing Ltd, BirminghamGoogle Scholar
  18. 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–10Google Scholar
  19. 19.
    Sharma S (2016) Expanded cloud plumes hiding big data ecosystem. Future Gener Comput Syst 59:63–92CrossRefGoogle Scholar
  20. 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–25Google Scholar
  21. 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–157CrossRefGoogle Scholar
  22. 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–221CrossRefGoogle Scholar
  23. 23.
    Stirling RM (2002) Data management in the 21st century emerging technologies and their implication for hydrography. In: FIG XXII International Congress, Washington, DC, USAGoogle Scholar
  24. 24.
    United States Federal Government Federal Information Processing Standard (1994).
  25. 25.
    Vukotic A et al. (2015) Neo4j in action. ManningGoogle Scholar
  26. 26.
    Walsh L, Akhmechet V, Glukhovsky M (2009) Rethinkdb-rethinking database storage. Hexagram 49. Inc, New YorkGoogle Scholar
  27. 27.
    Wicht B (2010) Presentation and use of H2 Database Engine. @Blog(“Baptiste Wicht”). [Online] Accessed 17 Sept 2013

Copyright information

© Springer Science+Business Media New York 2017

Authors and Affiliations

  1. 1.Center for Survey Statistics and MethodologyIowa State UniversityAmesUSA
  2. 2.Department of Computer ScienceIowa State UniversityAmesUSA

Personalised recommendations