Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
Change Rate Concepts and their Realization in the MM&S: A Computer Program for Modeling and Simulation of Dynamic Systems Read chapter Read first chapter

2013 | OriginalPaper | Chapter

14. Evaluation of Different Designs to Represent Missing Information in SQL Databases

Authors : Erki Eessaar, Elari Saal

Published in: Innovations and Advances in Computer, Information, Systems Sciences, and Engineering

Publisher: Springer New York

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

It is possible to use different designs to deal with the missing information problem in SQL databases. In this paper, we use a multi-criteria decision support method, which is based on the Analytic Hierarchy Process, to evaluate a set of possible designs for dealing with missing information. One of the designs uses SQL NULL-marks, another design uses tables that are in the sixth normal form, and one of the designs uses special values to represent missing information. We evaluate the designs, which are implemented in a PostgreSQL™ database, in terms of two hypothetical contexts. We create a test database, perform measurements, and use the results to compare the designs. The results of the evaluation provide new insights into the advantages and disadvantages of the different designs.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now
previous chapter 802.11e QoS Performance Evaluation
next chapter Mobile English Learning System: A Conceptual Framework for Malaysian Primary School
Literature
1.
Melton J (2006) IWD 9075-1:200x(E) information technology—database languages—SQL—Part 1: framework (SQL/framework). Feb 2006
2.
Date CJ (2003) An introduction to database systems, 8th edn. Pearson/Addison Wesley, BostonMATH
3.
Date CJ, Darwen H (2007) Databases, types, and the relational model. The Third Manifesto, 3rd edn. Addison-Wesley
4.
Date CJ (2009) SQL and relational theory. How to write accurate SQL code. O’Reilly, Romulus, MI
5.
Date CJ, Darwen H (2010) Database explorations. Essays on the third manifesto and related topics. Trafford Publishing, San Francisco
6.
Rönnbäck L, Regardt O, Bergholtz M, Johannesson P, Wohed P (2010) Anchor Modeling. Agile information modeling in evolving data environments. Data Knowl Eng 69(12), 1229–1253
7.
Karwin B (2010) SQL antipatterns. Avoiding the pitfalls of database programming. The pragmatic bookshelf
8.
9.
Codd EF (1990) The relational model for database management: version 2. Addison-Wesley, Menlo ParkMATH
10.
Liu K-C, Sunderraman R (1990) Indefinite and maybe information in relational databases, ACM Trans Database Syst 15(1), 1–39
11.
Date CJ, Darwen H (2000) Foundation for future database systems. The third manifesto, 2nd edn. Addison-Wesley, Massachusetts
12.
Eessaar E, Soobik M (2012) A decision support method for evaluating database designs. Comput Sci Inf Syst 4:345–365
13.
14.
ISO/IEC 9126-1, Software engineering–product quality–Part 1: quality model, first edn.: 2001-06-15
15.
16.
Gornik D, UML data modeling profile. In: Rational software white paper TP162, 05/2002
17.
Date CJ (2006) The relational database dictionary. A comprehensive glossary of relational terms and concepts, with illustrative examples. O’Reilly, Punta Gorda, FL
18.
Piattini M, Calero C, Sahraoui H, Lounis H (2001) Object-relational database metrics. L’Object 2:488–494
19.
Baroni AL, Calero C, Abreu FB, Piattini M (2006) Object-relational database metrics formalization. In: Sixth international conference on quality software, pp 30–37
20.
Mustajoki J, Hamalainen RP (2000) Web-HIPRE: global decision support by value tree and AHP analysis. INFOR 38(3):208–220
Metadata
Title
Evaluation of Different Designs to Represent Missing Information in SQL Databases
Authors
Erki Eessaar
Elari Saal
Copyright Year
2013
Publisher
Springer New York
Book
Innovations and Advances in Computer, Information, Systems Sciences, and Engineering

Print ISBN: 978-1-4614-3534-1

Electronic ISBN: 978-1-4614-3535-8

Copyright Year: 2013

DOI
https://doi.org/10.1007/978-1-4614-3535-8_14