Skip to main content

A New Approach to Round Tabular Data

  • Conference paper
Book cover Privacy in Statistical Databases (PSD 2006)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4302))

Included in the following conference series:

Abstract

Controlled Rounding is a technique to replace each cell value in a table with a multiple of a base number such that the new table satisfies the same equations as the original table. Statistical agencies prefer a solution where cell values already multiple of the base number remain unchanged, while the others are one of the two closest multiple of the base number (i.e., rounded up or rounded down). This solution is called zero-restricted rounding. Finding such a solution is a very complicated problems, and on some tables it may not exist. This paper presents a mathematical model and an algorithm to find a good-enough near-feasible solution for tables where a zero-restricted rounding is complicated. It also presents computational results showing the behavior of the proposal in practice.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bacharach, M.: Matrix rounding problem. Management Science 9, 732–742 (1966)

    Article  MathSciNet  Google Scholar 

  2. Causey, B.D., Cox, L.H., Ernst, L.R.: Applications of transportation theory to statistical problems. Journal of the American Statistical Association 80, 903–909 (1985)

    Article  MathSciNet  Google Scholar 

  3. Cox, L.H.: Controlled rounding. INFOR 20, 423–432 (1982)

    MATH  Google Scholar 

  4. Cox, L.H.: A constructive procedure for unbiased controlled rounding. Journal of the American Statistical Association 82, 520–524 (1987)

    Article  MATH  Google Scholar 

  5. Cox, L.H., George, J.A.: Controlled rounding for tables with subtotals. Annals of Operations Research, 141–157 (1989)

    Google Scholar 

  6. Dalenius, T.: A simple procedure for controlled rounding. Statistisk Tidskrift 3, 202–208 (1981)

    Google Scholar 

  7. Fagan, J.T., Greenberg, B.V., Hemmig, R.: Controlled rounding of three dimensional tables. Technical report, Bureau of the Census, SRD/RR-88/02 (1988)

    Google Scholar 

  8. Fellegi, I.P.: Controlled random rounding. Survey Methodology, 123–133 (1975)

    Google Scholar 

  9. Moravek, J., Vlach, M.: On necessary conditions for the existence of the solution to the multi-index transportation problem. Operations Research, 542–545 (1967)

    Google Scholar 

  10. Salazar, J.J.: A unified mathematical programming framework for different statistical disclosure limitation methods. Operations Research 53(3), 819–829 (2005)

    Article  MATH  MathSciNet  Google Scholar 

  11. Salazar, J.J.: Controlled rounding and cell perturbation: Statistical disclosure limitation methods for tabular data. Mathematical Programming 105(2–3), 251–274 (2006)

    MATH  MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

González, J.J.S. (2006). A New Approach to Round Tabular Data. In: Domingo-Ferrer, J., Franconi, L. (eds) Privacy in Statistical Databases. PSD 2006. Lecture Notes in Computer Science, vol 4302. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11930242_3

Download citation

  • DOI: https://doi.org/10.1007/11930242_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-49330-3

  • Online ISBN: 978-3-540-49332-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics