Data access
Sponsored Links
This presentation is the property of its rightful owner.
1 / 11

Data Access PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on
  • Presentation posted in: General

TDD. Data Access. Group 4. LindriIffa Dika Vizar. What?. Why?. What testing tools?. TDD. What to test?. Data Access. How?. Who?. what.

Download Presentation

Data Access

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


TDD

Data Access

Group 4

LindriIffa

DikaVizar


What?

Why?

What testing tools?

TDD

What to test?

Data Access

How?

Who?


what

Database testing adalah tindakan memvalidasi isi (content), skema, dan fungsional database. Dari sudut pandang database relasional, meliputi data itu sendiri, struktur tabel, dan hubungan antara tabel, serta stored procedure/fungsi atau kelas database masing-masing.

Data Access

TDD


Why

  • Mengapa perlu melakukan testing RDBMS?

  • Data merupakan aset penting perusahaan.

  • Mission-critical fungsi bisnis diimplementasikan dalam RDBMS.

  • Pendekatan-pendekatan saat ini tidak cukup.

  • Pengujian memberikan feedback yang diperlukan untuk mengidentifikasi cacat.

  • Mendukung pengembangan evolusioner.  

Data Access

TDD


What to test

  • Apa saja yang diuji?

  • Black box testing pada interface

    • O/R mapping

    • Nilai data masukan

    • Nilai data keluaran

  • White box testing dalam database

    • Trigger

    • Stored procedures/function

    • Views

Data Access

TDD


What Testing tools (1)

Data Access

TDD


What Testing tools (2)

Data Access

TDD


how

  • Bagaimana cara testing?

  • Database sandboxes

  • Writing database test

    • Set up the test

    • Run the test

    • Check result

  • Setting up database test

    • Fresh start

    • Data reinitialization

Data Access

TDD


  • who

  • Siapa yang melakukan testing?

  • Development: developer aplikasi dan DBA agile.

  • Release: tester

Data Access

TDD


  • ReferenCE

  • W, Scott.; 2009; Introduction to TDD; Amby Soft; http://www.agiledata.org/essays/tdd.html

  • W, Scott.; 2009; Database Testing: How to Regression Test a Relational Database ; Amby Soft; http://www.agiledata.org/essays/databaseTesting.html

Data Access

TDD


TDD

Data Access

Thank you :)


  • Login