Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

TPC-D

Question tag: TPC-D 15 Questions

0 Votes 1 Ans

What does TPC-D model?

model TPC-D

0 Votes 1 Ans

What does TPC-D mean by “Decision Support”?

decision support mean TPC-D

0 Votes 1 Ans

Why does TPC-D model an environment with ad hoc queries as opposed to ones which are prewritten?

AD Environment hoc model prewritten queries TPC-D

0 Votes 1 Ans

Why does TPC-D model a system which supports concurrent updates?

concurrent model supports system TPC-D updates

0 Votes 1 Ans

Does TPC-D require referential integrity on primary keys?

integrity keys primary referential require TPC-D

0 Votes 1 Ans

Does TPC-D allow the definition of auxiliary objects such as views or indexes that represent pre-aggregated versions of the underlying table data?

Auxiliary definition indexes objects TPC-D versions

0 Votes 1 Ans

Does TPC-D allow replication of database tables?

database replication tables TPC-D

0 Votes 1 Ans

Does the database require indexes on primary and/or foreign keys? TPC-D as a benchmark does not require indexes (Clause 1.4), but it permits them (Clause 1.5).

benchmark clause database foreign indexes keys primary require TPC-D

0 Votes 1 Ans

Why does TPC-D require update functions?

functions require TPC-D

0 Votes 1 Ans

Are the ACID tests run against the TPC-D schema?

acid run schema tests TPC-D

0 Votes 1 Ans

What isolation level does TPC-D require? TPC-D has three fundamental isolation level requirements as stated in Clause 3.

clause fundamental isolation level require requirements specification TPC-D

0 Votes 1 Ans

Why does TPC-D use a geometric mean for the power test?

arose geometric goals mean metric power Test TPC-D

0 Votes 1 Ans

What are the rules regarding fair published comparisons of TPC-D results? There are two items regarding comparability of TPC-D results, as documented in Clause 5.

comparability comparisons documented fair items published results rules TPC-D

0 Votes 1 Ans

Why does TPC-D require a test sponsor to disclose system pricing in such detail?

disclose pricing require sponsor system Test TPC-D

0 Votes 1 Ans

How is TPC-D similar to or different from TPC-C?

different similar tpc-c TPC-D