Component development and construction for database design

0
95

Authors: Bernhard Thalheim

Tags: 2004, conceptual modeling

Principles for database modeling were developed and intensively investigated in the late 1970s and early 1980s. They are based on concepts such as supertypes and subtypes, restructuring through normalization, type construction by constructors, generic models, and associations with pre-specified semantic meaning, e.g., classified relationship types. Use of these principles can result in large and complex database schemas that are difficult for developers to understand, integrate, and extend. We observe that often such schemas consist of identifiable sub-schemas that are loosely coupled. We use this observation to develop a design theory aimed at component-based construction of schemata. Building blocks used for schema construction are termed kernel components. Kernel components are composed to form more complex components by the application of the component constructors. Our approach allows a developer to derive an understandable schema topography for very large and complex databases.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X05X0132X/1-s2.0-S0169023X04001570/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMr%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJGMEQCIElDZe27e64MWK%2Bdr%2FOX%2B2qvwf5Mojcf9NtzoizGkO8sAiB5BefGU8tCdAAy78SPIfmkbZ3EAQWDIc3T4jgzYf%2BfRiq9Awjz%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDA1OTAwMzU0Njg2NSIMbCq%2BYWVrS6S7%2Bd9SKpEDCy3lkgbcb8vjdcmBhH2RCp1LoehSEeoMfj8363IxI8o00WQiM%2FiKO8RfBr3j8bbzenPo2hIfuFyUI0Z4ApbykK5hRJ%2FljV1HSJ5ilFI%2FCvB44vjIRB6iNiDwXB3%2BlaFgVav0HOPTQk5GtkpEI3M6GoFiEQVl8FI%2FBNRHxnIspUzbZkMi%2FJMlgIqRuB6OHhGyQ2S5zQYCrZjvzorp0igNhyirt5zdagpDcaq6kmZrnAkBPKK8bzNU1guay7hd%2ByADZsPR7CDpJ0aeFLtLOAIjG5mPMhN9SNOoa8nlzmkVNmURkWlTgtxvvcpKxWdGZzWQC9vsob%2F3uqjDrZFLC5qQXpW1KwDTVxiFtADXW5tA7ssBIhX45gpAeOlx0JYUjPsxhZbJ%2BsuvBl0siOAxxzCkFjlawcUIdql5EaJV2Kp2fwx%2FqbY0VWhKzR4tPLw9Pt1KeHyTx8HsnFVO2a4rN93C%2Fti2PZTYBXkQN1asBgg7nVTQQkZzaLizeyTAZYyXJwn1LlPnelUauhXTIs0v1CxrDI4wgdry%2BwU67AGVl1ztOu%2Fj9QKIt87mVAq5eeLlyT3w1HB23sZ189lTHV6zOQ3b%2FY%2FRKctHZ7lcxQJAJWBVKR5n%2BJspNOOLIb4fR04pwp09WnjCIyG2wiz0BkubuBs%2F6diRN4JJsjRtumSok1XW5w6iks52HRAkYWon1C6e%2FmXcyTrMOV8UtNTTtOWhrhgzIm1kLvXf3VsVu3kqhC2GNoCe%2BUSLnzp5OYZgFsy4Ed3F3%2BNTeHQ6qvE2KtXGlLgX5OrMse079Gx1FAHTX29Swui7PtAQIgIO%2BcY6S8G%2BQz7aOHVzuueiVwXO4AK2fWsBIhCezJ9bMg%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T185302Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTY2MVOOJQS%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=901405f3b5568df770c992c3ee9968cbcb01857edaa55f6288212287b07a5aa1&hash=fc85e04ba153aa8ae8ce8f73d0b8207baf055b9fe64d142a57c7d922bf615f8f&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=S0169023X04001570&tid=spdf-e664bb10-03b4-495c-ac8c-2fb1f400803e&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client