Lec07 - Internal External Data Design.pptx

It is important that they be designed early in the

Info icon This preview shows pages 23–25. Sign up to view the full content.

View Full Document Right Arrow Icon
It is important that they be designed early in the development process (so the application developers can get to work) and that they be fairly immutable once released to the developers (so developers do not need to redo work because of changes in the database design).
Image of page 23

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
External Data Design Interfaces defined by: How implemented and called : Views (stored queries) . This is useful when only joins, filtering, and sorting are required. Stored Procedures . A stored procedure is a program procedure written in the SQL language. It can implement processing logic (such as audit handling, validation, and special record processing actions) and also is able to return multiple datasets at a time to an application. Code Library (API) . Objects and subroutines called in a code library. Web Service . Allows views and stored procedures to be called in the same way functions are called in a program. Names of the objects and procedures / methods , and for each, definition of interface : Arguments (number of arguments, and their datatypes and meaning) Returned data (type, format, and meaning)
Image of page 24
External Data Design Presentation tier . The presentation layer includes both the form design and the form/report-related coding for presenting the data and handling user events. Graphics design (look & feel, layout). Client Event handling logic. Business tier . Business objects - A business object is a component that encapsulates the data and business processing logic for a particular business entity – for instance, a customer order, purchase order, or work order. Data Access Layer (DAL) - The DAL provides a class- oriented mechanism for business objects to retrieve data from / persist data to the data-tier. Data tier . Stored Procedures & Views Tables & relations .
Image of page 25
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern