Power Based Performance and Capacity Estimation Models for Enterprise Information Systems.

A variety of dependency formalisms have been studied for improving data quality. To treat these dependencies in a uniform framework, we propose a simple language, Quality Improving Dependencies (QIDs). We show that previous dependencies considered for data quality can be naturally expressed as QIDs, and that different enforcement mechanisms of QIDs yield various data repairing strategies.

[1]  Junhu Wang,et al.  Binary equality implication constraints, normal forms and data redundancy , 2007, Inf. Process. Lett..

[2]  Edward A. Komissartschik.  Restructuring and Dependencies in Databases , 1989, MFDBS.

[3]  Lei Chen,et al.  Discovering matching dependencies , 2009, CIKM.

[4]  Richard Hull,et al.  Order Dependency in the Relational Model , 1983, Theor. Comput. Sci..

[5]  Paul Cao,et al.  First TPC-Energy Benchmark: Lessons Learned in Practice , 2010, TPCTC.

[6]  Jianzhong Li,et al.  Towards certain fixes with editing rules and master data , 2010, Proc. VLDB Endow..

[7]  Raghunath Othayoth Nambiar,et al.  A power consumption analysis of decision support systems , 2010, WOSP/SIPEW '10.

[8]  Hannu Toivonen,et al.  TANE: An Efficient Algorithm for Discovering Functional and Approximate Dependencies , 1999, Comput. J..

[9]  Bruce Nordman,et al.  Data Center Power Requirements: Measurements From Silicon Valley , 2003 .

[10]  Wolf-Dietrich Weber,et al.  Power provisioning for a warehouse-sized computer , 2007, ISCA '07.

[11]  Trish Hogan.  Overview of TPC Benchmark E: The Next Generation of OLTP Benchmarks , 2009, TPCTC.

[12]  Meikel Pöss,et al.  New TPC benchmarks for decision support and web commerce , 2000, SGMD.

[13]  Ronald Fagin,et al.  A normal form for relational databases that is based on domains and keys , 1981, TODS.

[14]  Vilém Vychodil,et al.  Data Dependencies in Codd's Relational Model with Similarities , 2008, Handbook of Research on Fuzzy Information Processing in Databases.

[15]  Laks V. S. Lakshmanan,et al.  Data cleaning and query answering with matching dependencies and matching functions , 2011, ICDT '11.

[16]  Bei Yu,et al.  On generating near-optimal tableaux for conditional functional dependencies , 2008, Proc. VLDB Endow..

[17]  Avishek Saha,et al.  Sequential Dependencies , 2009, Proc. VLDB Endow..

[18]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[19]  Wilfred Ng,et al.  Ordered Functional Dependencies in Relational Databases , 1999, Inf. Syst..

[20]  Shuai Ma,et al.  Increasing the Expressivity of Conditional Functional Dependencies without Extra Complexity , 2008, 2008 IEEE 24th International Conference on Data Engineering.

[21]  Shuai Ma,et al.  Improving Data Quality: Consistency and Accuracy , 2007, VLDB.

[22]  Wenfei Fan,et al.  Conditional functional dependencies for capturing data inconsistencies , 2008, TODS.

[23]  Jianzhong Li,et al.  The VLDB Journal manuscript No. (will be inserted by the editor) Dynamic Constraints for Record Matching , 2022 .

[24]  D. Holt,et al.  A Systematic Approach to Automatic Edit and Imputation , 1976 .

[25]  Renée J. Miller,et al.  Discovering data quality rules , 2008, Proc. VLDB Endow..

[26]  Jan Chomicki,et al.  Consistent query answers in inconsistent databases , 1999, PODS '99.

[27]  Raghunath Othayoth Nambiar,et al.  Energy cost, the key challenge of today's data centers: a power consumption analysis of TPC-C results , 2008, Proc. VLDB Endow..

[28]  Arun K. Majumdar,et al.  Fuzzy Functional Dependencies and Lossless Join Decomposition of Fuzzy Relational Database Systems , 1988, ACM Trans. Database Syst..

[29]  Mohammed J. Zaki.  Mining Non-Redundant Association Rules , 2004, Data Min. Knowl. Discov..

[30]  Shuai Ma,et al.  Detecting inconsistencies in distributed data , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[31]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[32]  Adnan Yazici,et al.  An integrity constraint for a fuzzy relational database , 1993, [Proceedings 1993] Second IEEE International Conference on Fuzzy Systems.

[33]  Jef Wijsen,et al.  Determining the Currency of Data , 2011, TODS.

[34]  Michael Luxenburger,et al.  Implications partielles dans un contexte , 1991 .

[35]  Rajeev Rastogi,et al.  A cost-based model and effective heuristic for repairing constraints by value modification , 2005, SIGMOD '05.

[36]  Jianzhong Li,et al.  Reasoning about Record Matching Rules , 2009, Proc. VLDB Endow..

[37]  Kushagra Vaid,et al.  Energy benchmarks: a detailed analysis , 2010, e-Energy.

[38]  Arthur Howard,et al.  The State of Energy and Performance Benchmarking for Enterprise Servers , 2009, TPCTC.

[39]  Adnan Yazici,et al.  A complete axiomatization for fuzzy functional and multivalued dependencies in fuzzy database relations , 2001, Fuzzy Sets Syst..