IDEAS home Printed from https://ideas.repec.org/a/bla/jamest/v49y1998i5p455-470.html
   My bibliography  Save this article

Automated database schema design using mined data dependencies

Author

Listed:
  • S. K. M. Wong
  • C. J. Butz
  • Y. Xiang

Abstract

Data dependencies are used in database schema design to enforce the correctness of a database as well as to reduce redundant data. These dependencies are usually determined from the semantics of the attributes and are then enforced upon the relations. This article describes a bottom‐up procedure for discovering multivalued dependencies (MVDs) in observed data without knowing a priori the relationships among the attributes. The proposed algorithm is an application of the technique we designed for learning conditional independencies in probabilistic reasoning. A prototype system for automated database schema design has been implemented. Experiments were carried out to demonstrate both the effectiveness and efficiency of our method. © 1998 John Wiley & Sons, Inc.

Suggested Citation

  • S. K. M. Wong & C. J. Butz & Y. Xiang, 1998. "Automated database schema design using mined data dependencies," Journal of the American Society for Information Science, Association for Information Science & Technology, vol. 49(5), pages 455-470.
    • Handle: RePEc:bla:jamest:v:49:y:1998:i:5:p:455-470
    DOI: 10.1002/(SICI)1097-4571(19980415)49:53.0.CO;2-M
    as

    Download full text from publisher

    File URL: https://doi.org/10.1002/(SICI)1097-4571(19980415)49:53.0.CO;2-M
    Download Restriction: no
    File URL: https://libkey.io/10.1002/(SICI)1097-4571(19980415)49:53.0.CO;2-M?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:bla:jamest:v:49:y:1998:i:5:p:455-470. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Wiley Content Delivery (email available below). General contact details of provider: http://www.asis.org .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.