Database Designer

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 252 Experts worldwide ranked by ideXlab platform

J G Clement - One of the best experts on this subject based on the ideXlab platform.

  • new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    Forensic Science International, 2006
    Co-Authors: J G Clement, Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales, Anita J Hill
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called "DAVID" (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the software was never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In the wake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC's "The Missing" project that seeks to identify the victims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software "DAVID web" and compare its features and performance with alternative packages.

Anita J Hill - One of the best experts on this subject based on the ideXlab platform.

  • new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    Forensic Science International, 2006
    Co-Authors: J G Clement, Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales, Anita J Hill
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called "DAVID" (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the software was never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In the wake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC's "The Missing" project that seeks to identify the victims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software "DAVID web" and compare its features and performance with alternative packages.

Jan L. Harrington - One of the best experts on this subject based on the ideXlab platform.

  • Chapter 9 – Using SQL to Implement a Relational Design
    Relational Database Design, 2009
    Co-Authors: Jan L. Harrington
    Abstract:

    Publisher Summary This chapter introduces the SQL commands that are used to create and maintain the tables, views, indexes, and other structures that make up the Database. As a complete data manipulation language, SQL contains statements that allow inserting, modifying, deleting, and retrieving data. However, to a Database Designer, the portions of SQL that support the creation of Database structural elements are of utmost importance. In current versions of SQL, none of the groupings of Database elements are related to physical storage structures. If working with a centralized mainframe DBMS, one may find multiple catalogs stored in the same Database file. The way in which Database structural elements are named and identified is in some measure dictated by the structure hierarchy—column names must be unique within the table, table names must be unique within the schema, schema names must be unique within their catalog, and catalog names must be unique within their cluster. To a Database Designer, a schema represents the overall logical design of a complete Database. As far as SQL is concerned, however, a schema is nothing more than a container for tables, views, and other structural elements. It is up to the Database Designer to place a meaningful group of elements within each schema.

  • Systems Analysis and Database Requirements
    Relational Database Design, 2009
    Co-Authors: Jan L. Harrington
    Abstract:

    Publisher Summary This chapter presents an account of what happens before data is handed over to the Database Designer. A systems analysis is an important part of the Database design process, and a Database Designer must be familiar with how an analysis is conducted and what it produces. This chapter introduces a classic process for conducting a systems analysis. The classic method for developing an information system is known as the structured design life cycle. It works best in environments where it is possible to specify the requirements before the system is developed because they are fairly well known. The structured design life cycle comprises of many sequential steps. The first step is to conduct a needs assessment. This step determines what the new or modified system should do. Following this, the feasibility of the new or the modified system is tested. Based on the feasibility test, a set of alternative plans for the new or the modified system is generated. At this point, the team involved with designing and developing the system prepares a requirements document, which contains specifications of the requirements of the system, the feasibility analysis, and system development alternatives. Thereafter, the alternatives are evaluated and the best alternative is chosen. Based on the selected alternative, the system is designed and tested. Finally, it is implemented and evaluated for efficiency.

  • Schemas and Tables
    SQL Clearly Explained, 2003
    Co-Authors: Jan L. Harrington
    Abstract:

    As a complete data manipulation language, SQL contains statements that allow the creation, modification, and deletion of structural elements in a Database. This chapter discusses Database's structural elements by reviewing schemas and the permanent base tables that are created within them. The objects in a Database maintained by SQL-92 are arranged in a hierarchy. The smallest units with which a Database works—the columns and rows—appear in the center. These in turn are grouped into tables and views. To a Database Designer, a schema represents the overall, logical design of a complete Database. As far as SQL is concerned a schema is nothing more than a container for tables, views, and other structural elements. It is up to the Database Designer to place a meaningful group of elements within each schema. A domain is an expression of the permitted values for a column in a relation. When a table is defined, each column is assigned a data type that provides a broad domain. The most important structure within a relational Database is the table. Tables contain everything––including business data, and the data dictionary.

  • Using SQL to Implement a Relational Design
    Relational Database Design Clearly Explained, 2002
    Co-Authors: Jan L. Harrington
    Abstract:

    This chapter introduces the SQL commands that are used to create and maintain the tables, views, indexes, and other structures that make up the Database. As a complete data manipulation language, SQL contains statements that allow inserting, modifying, deleting, and retrieving data. However, to a Database Designer, the portions of SQL that support the creation of Database structural elements are of utmost importance. In current versions of SQL, none of the groupings of Database elements are related to physical storage structures. If working with a centralized mainframe DBMS, one may find multiple catalogs stored in the same Database file. The way in which Database structural elements are named and identified is in some measure dictated by the structure hierarchy—column names must be unique within the table, table names must be unique within the schema, schema names must be unique within their catalog, and catalog names must be unique within their cluster. To a Database Designer, a schema represents the overall logical design of a complete Database. As far as SQL is concerned, however, a schema is nothing more than a container for tables, views, and other structural elements. It is up to the Database Designer to place a meaningful group of elements within each schema.

  • 11 – Database Design Case Study #1: Mighty-Mite Motors
    Relational Database Design Clearly Explained, 2002
    Co-Authors: Jan L. Harrington
    Abstract:

    Publisher Summary This chapter provides a case study that exhibits that information systems in older companies have often grown haphazardly, with almost no planning and integration. The result is a hodgepodge of data repositories that cannot provide the information needed for the corporation to function because they are isolated from one another. In such a situation, it is the job of the Database Designer to examine the environment as a whole, and to focus on the integration of data access across the corporation as well as the design of one or more Databases that will meet individual department needs. However, there will almost certainly be a collection of paper forms and reports that the organization uses regularly. Such documents specify the input and output needs of the organization and can greatly simplify a Database Designer's task. The first step in the reengineering project is to establish an Information Systems division. The basic goal for the company was to develop a corporation-wide data administration plan that documents all Databases to be developed for the corporation, to provide an application road map that documents all application programs that will be needed to provide access to corporate Databases, to create a timeline for the installation of corporate Databases and the development of application programs, to specify hardware changes and/or acquisitions that will be necessary to support access to the Databases from within the headquarters building and by salespeople who are traveling.

Aldo Morales - One of the best experts on this subject based on the ideXlab platform.

  • new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    Forensic Science International, 2006
    Co-Authors: J G Clement, Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales, Anita J Hill
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called "DAVID" (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the software was never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In the wake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC's "The Missing" project that seeks to identify the victims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software "DAVID web" and compare its features and performance with alternative packages.

  • short communication new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    2006
    Co-Authors: Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called ‘‘DAVID’’ (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the softwarewas never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In thewake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC’s ‘‘The Missing’’ project that seeks to identify thevictims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software ‘‘DAVID web’’ and compare its features and performance with alternative packages. # 2006 Elsevier Ireland Ltd. All rights reserved.

Vicky Winship - One of the best experts on this subject based on the ideXlab platform.

  • new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    Forensic Science International, 2006
    Co-Authors: J G Clement, Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales, Anita J Hill
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called "DAVID" (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the software was never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In the wake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC's "The Missing" project that seeks to identify the victims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software "DAVID web" and compare its features and performance with alternative packages.

  • short communication new software for computer assisted dental data matching in disaster victim identification and long term missing persons investigations david web
    2006
    Co-Authors: Vicky Winship, Jason David Ceddia, Suhail Alamad, Aldo Morales
    Abstract:

    In 1997 an internally supported but unfunded pilot project at the Victorian Institute of Forensic Medicine (VIFM) Australia led to the development of a computer system which closely mimicked Interpol paperwork for the storage, later retrieval and tentative matching of the many AM and PM dental records that are often needed for rapid Disaster Victim Identification. The program was called ‘‘DAVID’’ (Disaster And Victim IDentification). It combined the skills of the VIFM Information Technology systems manager (VW), an experienced odontologist (JGC) and an expert Database Designer (JC); all current authors on this paper. Students did much of the writing of software to prescription from Monash University. The student group involved won an Australian Information Industry Award in recognition of the contribution the new software could have made to the DVI process. Unfortunately, the potential of the softwarewas never realized because paradoxically the federal nature of Australia frequently thwarts uniformity of systems across the entire country. As a consequence, the final development of DAVID never took place. Given the recent problems encountered post-tsunami by the odontologists who were obliged to use the Plass Data system (Plass Data Software, Holbaek, Denmark) and with the impending risks imposed upon Victoria by the decision to host the Commonwealth Games in Melbourne during March 2006, funding was sought and obtained from the state government to update counter disaster preparedness at the VIFM. Some of these funds have been made available to upgrade and complete the DAVID project. In thewake of discussions between leading expert odontologists from around the world held in Geneva during July 2003 at the invitation of the International Committee of the Red Cross significant alterations to the initial design parameters of DAVID were proposed. This was part of broader discussions directed towards developing instruments which could be used by the ICRC’s ‘‘The Missing’’ project that seeks to identify thevictims of civil unrest and other atrocities. The most significant of these recommendations was that the next version of DAVID should be web-based allowing it to be used anywhere in the world and on any computer platform. The original intention that the software should be made available as freeware was strongly reiterated and endorsed. During 2005 these recommendations have been realized. This paper will describe the design parameters of the new software ‘‘DAVID web’’ and compare its features and performance with alternative packages. # 2006 Elsevier Ireland Ltd. All rights reserved.