What is horizontal and vertical partitioning?
What will be an ideal response?
With horizontal partitioning, some of the rows of a table are put in one table at one site and other rows of the table are put in one table at another site. There are four major advantages to horizontal partitioning: efficiency, since data are stored close to where they are; local optimization; security: it is easier to control who has access to a set of data at one site; and ease of querying. Vertical partitioning splits a table up by columns, so that some columns are in one table at one location and other columns are in another location.
You might also like to view...
The left side of the accounting equation measures the amount that the business owes to creditors and to the stockholders
Indicate whether the statement is true or false
Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model?
A. Holding and ordering costs are stable and known. B. Demand is constant and known. C. Supply lead time is constant and known. D. Quantity discounts are possible.