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

Data Access PowerPoint PPT Presentation


  • 69 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


Data access

TDD

Data Access

Group 4

LindriIffa

DikaVizar


Data access1

What?

Why?

What testing tools?

TDD

What to test?

Data Access

How?

Who?


Data access2

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


Data access3

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


Data access4

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


Data access5

What Testing tools (1)

Data Access

TDD


Data access6

What Testing tools (2)

Data Access

TDD


Data access7

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


Data access8

  • who

  • Siapa yang melakukan testing?

  • Development: developer aplikasi dan DBA agile.

  • Release: tester

Data Access

TDD


Data access9

  • 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


Data access10

TDD

Data Access

Thank you :)


  • Login