Abstract
Government agencies and other organizations often have a huge quantity of data in need of digitization. In some cases, the data are represented on paper as tables with multilevel headers. Storing this data into relational tables probably necessitates a complex redesign of the data, through renaming of columns and/or normalization of the tables. To save this step, an XML data model can be used easily and naturally, but typical non-technical users still prefer to visualize data in the form of tables. We show in this paper how to transform and display XML data as HTML tables with multilevel headers, to preserve the original easy-to-read format while having a well defined schema, and describe how it can be used in concrete applications, focusing on a military logistics database.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Cafarella, M.J., Halevy, A., Khoussainova, N.: Data integration for the relational web. Proc. VLDB Endow. 2, 1090–1101 (2009), ISSN: 2150-8097
Oracle Corporation. Oracle Berkeley DB XML, http://www.oracl.com/us/products/database/berkeley-db/index-066571.html
Crestan, E., Pantel, P.: Web-scale knowledge extraction from semi-structured tables. In: Proceedings of the 19th International Conference on World Wide Web, WWW 2010, Raleigh, North Carolina, USA, pp. 1081–1082 (2010), ISBN: 978-1-60558-799-8
Python Software Foundation. Python Programming Language, http://www.python.org
Gatterbauer, W., et al.: Towards domain-independent information extraction from web tables. In: Proceedings of the 16th International Conference on World Wide Web, WWW 2007, Ban , Alberta, Canada, pp. 71–80 (2007), ISBN: 978-1-59593-654-7
Jagadish, H.V., et al.: Making database systems usable. In: Proceedings of the 2007 ACM SIGMOD International Conference on Management of Data, SIGMOD 2007, Beijing, China, pp. 13–24 (2007), ISBN: 978-1-59593-686-8
Lim, S.-J., Ng, Y.-K.: An automated approach for retrieving hierarchical data from html tables. In: CIKM 1999: Proceedings of the Eighth International Conference on Information and knowledge Management, Kansas City, Missouri, United States, pp. 466–474 (1999), ISBN: 1-58113-146-1
Nokia. Nokia N800 Internet Tablet, http://www.nokia-asia.com/find-products/products/nokia-n800-internet-tablet
Tajima, K., Ohnishi, K.: Browsing large html tables on small screens. In: UIST 2008: Proceedings of the 21st annual ACM symposium on User Interface software and Technology, pp. 259–268. ACM, New York (2008), ISBN: 978-1-59593-975-3
CherryPy Team. CherryPy Python Package, http://www.cherrypy.org
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Rinfret, D., Chênevert, C., Drolet, F. (2011). OSD-DB: A Military Logistics Mobile Database. In: Du, X., Fan, W., Wang, J., Peng, Z., Sharaf, M.A. (eds) Web Technologies and Applications. APWeb 2011. Lecture Notes in Computer Science, vol 6612. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-20291-9_50
Download citation
DOI: https://doi.org/10.1007/978-3-642-20291-9_50
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-20290-2
Online ISBN: 978-3-642-20291-9
eBook Packages: Computer ScienceComputer Science (R0)