Defining and implementing domains with multiple types using mesodata modelling techniques

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Defining and implementing domains with multiple types using mesodata modelling techniques

Full text

Pdf (187 KB)

Source

Conferences in Research and Practice in Information Technology Series; Vol. 166 archive
Proceedings of the 3rd Asia-Pacific conference on Conceptual modelling - Volume 53 table of contents

Hobart, Australia

Pages: 85 - 93

Year of Publication: 2006

ISBN ~ ISSN:1445-1336 , 1-920-68235-X

Authors

Sally Rice	School of Informatics and Engineering, Flinders University of South Australia, Adelaide, South Australia and School of Computer and Information Science, University of South Australia, Mawson Lakes, South Australia
John F. Roddick	School of Informatics and Engineering, Flinders University of South Australia, Adelaide, South Australia
Denise de Vries	School of Informatics and Engineering, Flinders University of South Australia, Adelaide, South Australia

Publisher

Australian Computer Society, Inc. Darlinghurst, Australia, Australia

Bibliometrics

Downloads (6 Weeks): 5, Downloads (12 Months): 23, Citation Count: 0

Additional Information:

abstract references index terms collaborative colleagues

Tools and Actions:	Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

ABSTRACT

The integration of data from different sources often leads to the adoption of schemata that entail a loss of information in respect of one or more of the data sets being combined. The coercion of data to conform to the type of the unified attribute is one of the major reasons for this information loss. We argue that for maximal information retention it would be useful to be able to define attributes over domains capable of accommodating multiple types, that is, domains that potentially allow an attribute to take its values from more than one base type.Mesodata is a concept that provides an intermediate conceptual layer between the definition of a relational structure and that of attribute definition to aid the specification of complex domain structures within the database. Mesodata modelling techniques involve the use of data types and operations for common data structures defined in the mesodata layer to facilitate accurate modelling of complex data domains, so that any commonality between similar domains used for different purposes can be exploited.This paper shows how the mesodata concept can be extended to facilitate the creation of domains defined over multiple base types, and also allow the same set of base values to be used for domains with different semantics. Using an example domain containing values representing three different types of incomplete knowledge about the data item (coarse granularity, vague terms, or intervals) we show how operations and data structures for types already existing within the mesodata can simplify the task of developing a new intelligent domain.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	Tamas Abraham , John F. Roddick, Survey of Spatio-Temporal Databases, Geoinformatica, v.3 n.1, p.61-99, March 1999 [doi>10.1023/A:1009800916313]
	2	James F. Allen, Maintaining knowledge about temporal intervals, Communications of the ACM, v.26 n.11, p.832-843, Nov. 1983 [doi>10.1145/182.358434]
	3	Thomas M. Connolly , Carolyn E. Begg , Anne D. Strachan, Database systems: a practical approach to design, implementation and management, Addison Wesley Longman Publishing Co., Inc., Redwood City, CA, 1996
	4	de Vries, D., Rice, S. & Roddick, J. F. (2004), In support of mesodata in database management systems, in 'DEXA 2004', Springer, Zaragoza, Spain.
	5	de Vries, D. & Roddick, J. F. (2004), Facilitating database attribute domain evolution using meso-data, in F. Grandi, ed., 'Third International Workshop on Evolution and Change in Data Management (ECDM2004)', Lecture Notes in Computer Science, Springer, Shanghai.
	6	Debabrata Dey , Sumit Sarkar, A probabilistic relational model and algebra, ACM Transactions on Database Systems (TODS), v.21 n.3, p.339-369, Sept. 1996 [doi>10.1145/232753.232796]
	7	Egenhofer, M. J. & Franzosa, R. D. (1991), 'Point-set topological spatial relations', International Journal for Geographical Information Systems 5(2), 161-174.
	8	Lorentz, D. & Gregoire, J. (2003), Oracle Database SQL Reference 10g Release 1 (10.1), Oracle Corporation.
	9	Jim Melton , Alan Simon, SQL:1999: understanding relational language components, Morgan Kaufmann Publishers Inc., San Francisco, CA, 2001
	10	MySQL (2003), 'SQL open source software'.
	11	Sally Rice , John F. Roddick, Lattice-Structured Domains, Imperfect Data and Inductive Queries, Proceedings of the 11th International Conference on Database and Expert Systems Applications, p.664-674, September 04-08, 2000
	12	Roddick, J. (1994), A Model for Temporal Inductive Inference and Schema Evolution in Relational Database Systems, Doctor of philosophy, La Trobe University.
	13	Schneider, M. (1997), Spatial Data Types for Database Systems, Vol. 1288 of Lecture Notes in Computer Science, Springer.
	14	Richard Thomas Snodgrass, The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Norwell, MA, 1995
	15	Swan, V. G. (1984), The pottery kilns of Roman Britain, Royal Commission for Historical Monuments.
	16	Vilain, M. B. (1982), A system for reasoning about time, in 'National Conference on Artificial Intelligence', Pittsburg, PA, pp. 197-201.
	17	Zeng, J. (1999), Research and practical experiences in the use of multiple data sources for enterprise-level planning and decision making: A literature review, Technical report, Center for Technology in Government, University at Albany / SUNY.