Skip to main content
SpringerLink
Log in

A conceptual schema-based temporal meta database schemas generation technique for 3D objects

  • Regular Paper
  • Published:
Knowledge and Information Systems Aims and scope Submit manuscript

Abstract

In this paper, a temporal meta database for three-dimensional (3D) objects whose properties and relationships are supported by valid time is introduced. Based on our proposed temporal object-oriented conceptual schema model, a conceptual schema of the temporal meta database can be generated from a 3D graphical data source and other particular application requirements. Based on our proposed temporal object relational data model with attribute timestamping, logical schemas of the temporal meta database can be systematically and automatically generated from the conceptual schema. From the temporal meta database, non-temporal/temporal metadata about temporal 3D objects are available for temporal information system users. Convenient access using database languages such as SQL can be performed. Queries over 3D objects using a temporal object relational SQL are demonstrated.

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

Access this article

Log in via an institution

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

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. 3D Modeling Software trueSpace (2008) http://www.caligari.com/. Accessed 28 Sep 2008

  2. Allen JF (1983) Maintaining knowledge about temporal intervals. Commun ACM 26: 832–843

    Article  MATH  Google Scholar 

  3. ANSI/ISO/IEC International Standard (IS) (2003) 9075 Database Language SQL:2003, WD 9075-2, SQL/Foundation, September 2003

  4. Arens C, Stoter J, Oosterom PV (2005) Modelling 3D spatial objects in a geo-DBMS using a 3D primitive. Comput Geosci 31: 165–177

    Article  Google Scholar 

  5. Attene M, Robbiano F, Spagnuolo M et al (2007) Semantic annotation of 3D surface meshes based on feature characterization. In: Proceedings of the SAMT, pp 126–139

  6. Autodesk 3ds Max, AutoCAD (2008) http://usa.autodesk.com/. Accessed 28 Sep 2008

  7. Bartels D (1996) ODMG 93-the emerging object database standard. In: Proceedings of the 12th IEEE international conference on data engineering, IEEE, pp 674–676

  8. Bilasco IM, Gensel J, Villanova-Oliver M et al (2006) An MPEG-7 framework enhancing the reuse of 3D models. In: Proceedings of the 11th ACM international conference on 3D Web technology. ACM, pp 65–74

  9. Bilasco IM, Villanova-Oliver M, Gensel J et al (2005) 3DSEAM: a model for annotating 3D scenes using MPEG-7. In: Proceedings of the 7th IEEE internationl symposium on multimedia. IEEE, pp 310–319

  10. Bilasco IM, Villanova-Oliver M, Gensel J et al (2007) Towards geospatial queries in a semantic digital library for 3D data. Trans GIS 11: 337–353

    Article  Google Scholar 

  11. Bimbo AD, Pala P (2006) Content-based retrieval of 3D models. ACM Trans Multimedia Comput Commun Appl 2: 20–43

    Article  Google Scholar 

  12. Bowman DA, North C, Chen J et al (2003) Information-rich virtual environments: theory, tools, and research agenda. In: Proceedings of the ACM symposium on virtual reality software and technology. ACM, pp 81–90

  13. Chan J, Bailey J, Leckie C (2008) Discovering correlated spatio-temporal changes in evolving graphs. Knowl Inf Syst 16:53–96. doi:10.1007/s10115-007-0117-z

    Google Scholar 

  14. Chang S-F, Sikora T, Puri A (2001) Overview of MPEG-7 standard. IEEE Trans Circuits Syst Video Technol 11: 688–695

    Article  Google Scholar 

  15. Clay SR, Wilhelms J (1996) Put: language-based interactive manipulation of objects. IEEE Comput Graphics Appl 16: 31–39

    Article  Google Scholar 

  16. Codd EF (1970) A relational model for large shared data banks. Commun ACM 13: 377–387

    Article  MATH  Google Scholar 

  17. Dietze L, Nonn U, Zipf A (2007) Metadata for 3D city models: analysis of the applicability of the ISO 19115 standard possibilities for further amendments. In: Proceedings of the 10th AGILE International Conference on Geographic Information Science, pp 1–9

  18. Direct3D (2008) http://msdn.microsoft.com/msdnmag/issues/03/07/DirectX90/default.aspx. Accessed 28 Sep 2008

  19. Dublin Core (2008) http://dublincore.org/. Accessed 28 Sep 2008

  20. Emerson EA (1990) Temporal and modal logic. In: van Leeuwen J (ed) Handbook of theoretical computer science, vol. 2. Elsevier, Amsterdam

  21. Escobar-Molano ML, Barrett DA, Carson E et al (2007) A representation for databases of 3D objects. Comput Environ Urban Syst 31: 409–425

    Article  Google Scholar 

  22. Geographic Information Metadata (2003) International standard ISO 19115:2003

  23. Geographic Information Spatial Schema (2003) International Standard ISO 19107:2003

  24. Griffiths T, Fernandes AAA, Paton NW et al (2004) The Tripod spatio-historical data model. Data Knowl Eng 49: 23–65

    Article  Google Scholar 

  25. Gröger G, Reuter M, Plümer L (2004) Representation of a 3-D city model in spatial object-relational databases, International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 34, 1–6. Part B4. In: Proceedings of the XXth ISPRS Congress, Turkey

  26. Guo D, Xiong H, Atluri V et al (2009) Object discovery in high-resolution remote sensing images: a semantic perspective. Knowl Inf Syst 19: 211–233. doi:10.1007/s10115-008-0160-4

    Article  Google Scholar 

  27. Halabala P (2003) Semantic metadata creation. In: Proceedings of the CESCG: 7th central European seminar on computer graphics, pp 15–25

  28. Hetherington RE, Scott JP (2004) Adding a fourth dimension to three dimensional virtual spaces. In: Proceedings of the ninth international conference on 3D Web technology, pp 163–172

  29. Hornsby K, Egenhofer M (2000) Identity-based change: a foundation for spatio-temporal knowledge representation. Int J Geogr Inf Sci 14: 207–224

    Article  Google Scholar 

  30. Huang B, Claramunt C (2002) STOQL: An ODMG-based spatio-temporal object model and query language. In: Proceedings of the 10th international symposium on spatial data handling, pp 1–13

  31. Java3D (2008) http://java.sun.com/products/java-media/3D/. Accessed 28 Sep 2008

  32. Jensen CS et al (1998) The consensus glossary of temporal database concepts. In: Etzion O, Jajodia S, Sripada S (eds) Temporal databases: research and practice. Springer, Berlin, pp 367–405

    Chapter  Google Scholar 

  33. Jurisica I, Mylopoulos J, Yu E (2004) Ontologies for knowledge management: an information systems perspective. Knowl Inf Syst 6: 380–401

    Article  Google Scholar 

  34. Kalogerakis E, Christodoulakis S, Moumoutzis N (2006) Coupling ontologies with graphics content for knowledge driven visualization. In: Proceedings of the IEEE virtual reality conference, IEEE, pp 43–50

  35. Latoschik ME, Schilling M (2003) Incorporating VR databases into AI knowledge representations: a framework for intelligent graphics applications. In: Proceedings of the 6th IASTED international conference on computer graphics and imaging, pp 79–84

  36. Latoschik ME, Fröhlich C (2007) Towards intelligent VR: multi-layered semantic reflection for intelligent virtual environments. In: Proceedings of the graphics and applications (GRAPP 2007), pp 249–259

  37. Martinez JI, Mata CD (2006) A basic semantic common level for virtual environments. Int J Virtual Real 5: 25–32

    Google Scholar 

  38. Mian AS, Bennamoun M, Owens R (2006) Three-dimensional model-based object recognition and segmentation in cluttered scenes. IEEE Trans Pattern Anal Mach Intell 28: 1584–1601

    Article  Google Scholar 

  39. Motelet O, Baloian N, Pino JA (2008) Taking advantage of metadata semantics: the case of learning-object-based lesson graphs. Knowl Inf Syst. doi:10.1007/s10115-008-0181-z

  40. MPEG2008/N9769 (2008) Overview of MPEG-7 Visual Description Tools. http://www.chiariglione.org/mpeg/technologies/mp07-vid(0v)/index.htm. Accessed 28 Sep 2008

  41. Nijssen GM, Halpin TA (1989) Conceptual schema and relational database design: a fact-oriented approach. Prentice-Hall, Englewood Cliffs

    Google Scholar 

  42. OpenGL (2008) http://www.opengl.org/. Accessed 28 Sep 2008

  43. Oracle 10 g (10.1) (2003) Oracle® spatial: user’s guide and reference, B10826-01

  44. Oracle 10 g (2008) http://www.oracle.com/. Accessed 28 Sep 2008

  45. Otto KA (2005) The semantics of multi-user virtual environments. In: Proceedings of the workshop towards semantic virtual environments, pp 1–10

  46. Papapetrou P, Kollios G, Sclaroff S et al (2009) Mining frequent arrangements of temporal intervals. Knowl Inf Syst. doi:10.1007/s10115-009-0196-0

  47. Paquet E, Rioux M (1998) A content-based search engine for VRML databases. In: Proceedings of the IEEE computer society conference on computer vision and pattern recognition, IEEE, pp 541–546

  48. Pigot S (1992) A topological model for a 3D spatial information system. In: Proceedings of the 5th international symposium on spatial data handling, pp 368–392

  49. Pittarello F, De Faveri A (2006) Semantic description of 3D environments: a proposal based on web standards. In: Proceedings of the 11th ACM international conference on 3D web technology, ACM, pp 85–95

  50. Resource Description Framework (RDF) (2008) http://www.w3.org/RDF/. Accessed 28 Sep 2008

  51. Roth MA, Korth HF, Silberschatz A (1988) Extended algebra and calculus for nested relational databases. ACM Trans Database Syst 13: 389–417

    Article  MATH  MathSciNet  Google Scholar 

  52. Schneider M, Weinrich BE (2004) An abstract model of three-dimensional spatial data types. In: Proceedings of the 12th ACM international symposium on advances in geographic information systems, ACM, pp 67–72

  53. Snodgrass RT (1998) Managing temporal data: a five-part series. Technical Report TR-28, Department of Computer Science, University of Arizona

  54. Shumilov S, Siebeck J (2001) Database support for temporal 3D data: extending the GeoToolKit. In: Proceedings of the 7th EC-GI and GIS Workshop, pp 1–14

  55. Stonebraker M, Brown P, Moore D (1999) Object-relational DBMS’s—tracking the next great wave, Morgan Kaufmann, San Francisco

  56. Tangelder JWH, Veltkamp RC (2008) A survey of content based 3D shape retrieval methods. Multimedia Tools Appl 39: 441–471

    Article  Google Scholar 

  57. Toro C, Posada J, Wundrak S et al (2006) Improving virtual reality applications in CAD through semantics. Int J Virtual Real 5: 39–46

    Google Scholar 

  58. Vakaloudis A, Theodoulidis B (1999) The dynamic construction of VRML worlds by the use of a VRML database repository. IEE Seminar Digests 1999 4: 4/1–4/7

    Google Scholar 

  59. Viqueira JR, Lorentzos NA (2007) SQL extension for spatio-temporal data. Very Large Database J 16: 179–200

    Article  Google Scholar 

  60. Virtual Reality Modeling Language (2008) http://www.web3d.org/x3d/specifications/#vrml97. Accessed 28 Sep 2008

  61. Vo TNC, Chittayasothorn S (2008) A temporal object relational SQL language with attribute timestamping in a temporal transparency environment. Data Knowl Eng 67: 331–361

    Article  Google Scholar 

  62. Vongdoiwang W, Batanov DN (2006) An ontology-based procedure for generating object model from text description. Knowl Inf Syst 10: 93–108

    Article  Google Scholar 

  63. Worboys MF (1994) A unified model for spatial and temporal information. Comput J 37: 26–34

    Article  Google Scholar 

  64. X3D (2008) http://www.web3d.org/x3d/. Accessed 28 Sep 2008

  65. Yoo TS (2005) 3D medical informatics: information science in multiple dimensions, chap 12. In: Chen H, Fuller SS, Friedman C, Hersh W (eds) Medical informatics: knowledge management and data mining in biomedicine. Springer, New York, pp 333–358

  66. Zlatanova S (2000) On 3D topological relationships. In: Proceedings of the 11th international workshop on database and expert systems applications, pp 913–919

  67. Zlatanova S (2006) 3D geometries in spatial DBMS. In: Proceedings of the international workshop on 3D geoinformation, pp 1–14

Download references

Author information

Authors and Affiliations

  1. Department of Information Systems, Faculty of Computer Science and Engineering, Ho Chi Minh City University of Technology, Ho Chi Minh City, Vietnam

    Vo Thi Ngoc Chau

  2. Department of Computer Engineering, Faculty of Engineering, King Mongkut’s Institute of Technology Ladkrabang, Bangkok, 10520, Thailand

    Suphamit Chittayasothorn

Authors
  1. Vo Thi Ngoc Chau
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Suphamit Chittayasothorn
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Suphamit Chittayasothorn.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Thi Ngoc Chau, V., Chittayasothorn, S. A conceptual schema-based temporal meta database schemas generation technique for 3D objects. Knowl Inf Syst 24, 113–147 (2010). https://doi.org/10.1007/s10115-009-0235-x

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10115-009-0235-x

Keywords

Search

Navigation