A Semantic Data Model: Meaning Making from Data Structures in the SQL Server
Downloads
Information systems designs are increasingly concerned with entity relationships and technical programmatic approaches to solutions architecture as opposed to semantic based, business focused information architecture that places business definitions at the centre of the information system design and implementation. The disconnect between information technology and business is perpetuated by an overly prescriptive information technology technical design method that fails to incorporate qualitative and normative aspects of business, where information is structured and delivered according to business. The paper will discuss various decision support and semantic approaches to information design and delivery and argue that the traditional modes of solution delivery do not include meaning making of the data elements which are essential to business information reporting and analytics. The meaning making aspect identified is linked to data dictionary or business data glossary that allows for the discovery of semantic meaning from the SQL Server. Using Christian Fürber's methodology on semantic programming, the analytics team developed a semantic model that enabled detailed definition of fields and the discovery of information using semantic search functionality embedded in the SQL Server. The project provided semantic data framework that provided business with the capability for semantic reconciliation and data sets that were further integrated with Tableau visualization and SQL auto processes.
R. Batra, "A History of SQL and Relational Databases," in SQL Primer: An Accelerated Introduction to Basic SQL.: Apress, 2018, pp. 183-187.
Terry Halpin and Tony Morgan, Information Modeling and Relational Databases. Burlington: Elsevier, 2008.
E. F. Codd, "A relational model of data for large shared data banks," Communications of the ACM, vol. 13, no. 6, pp. 377-387 , 1970. https://doi.org/10.1145/362384.362685.
Peter Pin-Shan Chen, "The entity-relationship model”toward a unified view of data," ACM Transactions on Database Systems, vol. 1, no. 1, pp. 9-36, 1975. https://doi.org/10.1145/320434.320440.
Frank Manola and Umeshwar Dayal, "PDM: an object-oriented data model," in OODS '86 Proceedings on the 1986 international workshop on Object-oriented database systems, California, USA, 1986, pp. 18-25.
E. F. Codd, The Relational Model for Database Management: Version 2. Redwood: Addison-Wesley, 1990.
Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation and Management, 11th ed. Stamford: Cengage Learning, 2014.
John W. Satzinger, Robert B. Jackson, and Stephen D. Burd, Systems Analysis and Design in a Changing World. Boston: Course Technology, 2009.
Joan Peckham and Fred Maryanski, "Semantic data models," ACM Computing Surveys, vol. 20, no. 3, pp. 153-189, 1988. https://doi.org/10.1145/62061.62062.
von Halle B, "Data: asset or liability," Database Programming and Design, vol. 4, no. 7, pp. 13-15, 1991.
von Halle B and L. Goldberg, The Decision Model: A Business Logic Framework. Florida: Auerbach Publications, 2010.
AleÅ¡ PopoviÄ, Ray Hackney, Pedro Simíµes Coelho, and Jurij JakliÄa, "Towards business intelligence systems success: Effects of maturity and culture on analytical decision making," Decision Support Systems, vol. 54, no. 1, pp. 729-739, 2012. https://doi.org/10.1016/j.dss.2012.08.017.
M.Krysiński et al., "Semantic Data Sharing and Presentation in Integrated Knowledge System," in Intelligent Tools for Building a Scientific Information Platform. New York: Springer, 2013, pp. 67-83.
Stefan W. Knoll, Jordan Janeiro, Stephan G. Lukosch, and Gwendolyn L. Kolfschoten, "A Semantic Model for Adaptive Collaboration Support Systems," in Semantic Models for Adaptive Interactive Systems. New York: Springer, 2013, pp. 59-81.
Richard Y. Wang and Diane M. Strong, "Beyond Accuracy: What Data Quality Means to Data Consumers," Journal of Management Information Systems, vol. 12, no. 4, pp. 5-33, 1996. https://doi.org/10.1080/07421222.1996.11518099.
Daniel L. Moody and Graeme G. Shanks, "Improving the quality of data models: empirical validation of a quality management framework," Journal Information Systems, vol. 28, no. 6, pp. 619-650, 2003.
S. Bjeletich, "SQL Server 2007: Best Practices for Semantic Data Modelling for Performance and Scalability," 2008. [Online]. http://codesmartinc.com/codesmartinc/wp-content/uploads/2012/08/semantic_db_modeling.docx
C. Adams, "Lessons for Information System Development," in Business Information Technology Management: Alternative and Adaptive Futures. London: Macmillan, 2000, pp. 25-39.
C.Fürber, Data Quality Management with Semantic Technologies. Wiesbaden: Springer, 2016.
Rudra Pratap Deb Nath, Katja Hose, Torben Bach Pedersen, and Oscar Romero, "SETL: A programmable semantic extract-transform-load framework for semantic data warehouses," Information Systems, vol. 68, pp. 17-43, 2017. https://doi.org/10.1016/j.is.2017.01.005.
R. Bergmann and Y. Gil, "Similarity assessment and efficient retrieval of semantic workflows," Information Systems, vol. 40, pp. 115-127, 2014. https://doi.org/10.1016/j.is.2012.07.005.
Authors who publish with this journal agree to the following terms:
All accepted papers will be published under a Creative Commons Attribution 4.0 International (CC BY 4.0) License. Authors retain copyright and grant the journal right of first publication. CC-BY Licenced means lets others to Share (copy and redistribute the material in any medium or format) and Adapt (remix, transform, and build upon the material for any purpose, even commercially).
