Skip to main content

An Efficient Patent Storing Mechanism Based on SQLite on Hadoop Platform

  • Conference paper
  • First Online:
Web-Age Information Management (WAIM 2014)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 8597))

Included in the following conference series:

Abstract

This paper describes a patent storage and analysis system based on Hadoop and SQLite. This system is proposed to solve data loading overhead in Map Phase of patent analysis applications. System proposed in this paper utilizes SQLite data structure as HDFS block container to enhance patent documents storage and query performance. In addition, a hierarchical index-based patent data processing approach has been implemented in this system to support patent analysis applications. This paper presents a data storing mechanism which enhances query jobs by at least 2x faster than original Hadoop. And our mechanism decreases 90 % data loading overhead in map phase.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. CNET News Internet & Media Twitter hits 400 million tweets per day, mostly. http://news.cnet.com/8301-1023_3-57448388-93/twitter-hits-400-million-tweets-per-day-mostly-mobile/

  2. Facebook is collecting your data - 500 terabytes a day. http://gigaom.com/2012/08/22/facebook-is-collecting-your-data-500-terabytes-a-day/

  3. Huang, L., Yuan, Y., Zhao, Z.: A study on the application of data mining in the patent information analysis for company. In: Second International Workshop on Education Technology and Computer Science (ETCS), Wuhan, vol. 1 (2010)

    Google Scholar 

  4. Karki, M.M.S.: Patent citation analysis: a policy analysis tool. World Patent Inf. 19(4), 269–272 (1997)

    Article  MathSciNet  Google Scholar 

  5. Dean, J., Ghemawat, S.: MapReduce: simplified data processing on large clusters. Commun. ACM 51(1), 107–113 (2008)

    Article  Google Scholar 

  6. Buck, J.B., Watkins, N., LeFevre, J., Ioannidou, K., Maltzahn, C., Polyzotis, N., Brandt, S.: SciHadoop: array-based query processing in hadoop. In: Proceedings of 2011 International Conference for High Performance Computing, Networking, Storage and Analysis, Seattle, p. 66 (2011)

    Google Scholar 

  7. Tseng, Y.-H., Lin, C.-J., Parker, D.S.: Text mining techniques for patent analysis. Inf. Proc. Manage. 43(5), 1216–1247 (2007)

    Article  Google Scholar 

  8. Yang, H.-C., Dasdan, A., Hsiao, R.-L., Parker, D. S.: Map-reduce-merge: simplified relational data processing on large clusters. In: ACM SIGMOD International Conference on Management of Data, Beijing, pp. 1029−1040 (2007)

    Google Scholar 

  9. Herodotou, H., Babu, S.: Profiling, what-if analysis, and cost-based optimization of MapReduce programs. In: Very Large Database Endowment, vol. 4, pp. 1111−1122 (2011)

    Google Scholar 

  10. Lin, M., Zhang, L., Wierman, A., Tan, J.: Joint optimization of overlapping phases in MapReduce. Perform. Eval. 70(10), 720–735 (2013)

    Article  Google Scholar 

  11. Java Database Connector for SQLite. https://bitbucket.org/xerial/sqlite-jdbc

  12. USPTO Bulk Downloads: Patent Grant Full Text. http://www.google.com/googlebooks/uspto-patents-grants-text.html

  13. The SQLite Database File Format. https://www.sqlite.org/fileformat.html

Download references

Acknowledgement

This work (Grants No. C0141582) was supported by Business for Cooperative R&D between Industry, Academy, and Research Institute funded Korea Small and Medium Business Administration in 2014.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Dugki Min .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Rui, X., Kim, B., Min, D. (2014). An Efficient Patent Storing Mechanism Based on SQLite on Hadoop Platform. In: Chen, Y., et al. Web-Age Information Management. WAIM 2014. Lecture Notes in Computer Science(), vol 8597. Springer, Cham. https://doi.org/10.1007/978-3-319-11538-2_35

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-11538-2_35

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-11537-5

  • Online ISBN: 978-3-319-11538-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics