Thursday, July 30, 2009

What We Can Do

Subtitle: The Hope and Change the rest of us desire.

The purpose of this site is to document the events of the day. Few read it and fewer still take what is written here to heart. Mostly, it is cynical. It is the view of the world as one might view a train wreck before it happens, reporting on the screeching wheels and metal before the train hits the wall.

For just a moment I'm going to step out of the role as cynic and reporter of our demise and propose a few ideas that could turn this impending tragedy around, avoiding the train wreck. It isn't inevitable, but it is likely, given the direction we're heading. That direction needs to change.

The United States Constitution is an amazing document, both for its forward-thinking and its clarity. The few aberrations, including slavery and limited suffrage, were corrected by the sweat and blood of patriots, others were corrected peacefully. What we have left is a miracle -- a kind of road-map to preserving our treasured liberties.  It is only as useful as it is used and respected.

In some cases (the minutia I'll leave to another day) we screwed things up. For all the good intentions and lofty goals, prohibition was a bad idea, and it was later reversed. The Sixteenth Amendment was enacted to give Congress the ability to collect taxes on income (not wages), for the purposes of paying war debt. The balance of power between the States and the Federal government was severely harmed by the passage of the Seventeenth Amendment, changing the election of Senators from state selection by the respective state legislature, to popular vote. It, too, was invented with the goal of correcting a perceived wrong, but it created far more trouble than it benefited us.

I fully expect that those Amendments will be eventually overturned, viewed through the lens of history as mistakes as great and obvious as prohibition proved to be. In some cases the Constitution is fine as it is today, but it has been interpreted to mean something other than it was intended to mean.  The Fourteenth Amendment, for example, was enacted to gaurantee that the Bill of Rights, the respect of individual rights, and the status of U.S. citizen were uniform throughout the states, not that all other laws between the states had to be uniform.

Whether those Amendments will be overturned (or the interpretations of others limited to their original intent) will happen in my lifetime or later is the question. The larger question is if we'll exist long enough to reverse them.

Those are important, but trivial compared to what remains intact, based on the Founders exquisite understanding of the purpose of government and how government can be prevented from becoming the tyrannical state.

The Founders made it quite clear that the Federal government had limited powers -- that it derived its powers from The People -- and that all the powers not specifically granted to the Federal government remained with The People (individually) or collectively, by the States. On the whole, the Constitution doesn't limit what the people or the Several States may do; on the contrary, the Constitution limits and articulates what the Federal government may do.  In all cases, however, the Founders made it quite clear that we retained the rights we temporarily delegated to the Federal government.  At any time we could rescind their authority, or grant it additional powers, but only through Constitutional Amendment (not, as far too many believe, by doing whatever they damn well please).

There was fear that the Federal government would attempt to trump State powers, but more concern that larger states would attempt to trample the smaller ones. There were "checks and balances" as well, dividing the Federal government into three branches: Legislature, Executive, and Justice.

Each branch had their specific role and authority. The legislature was empowered to make laws and to lay taxes for the express purpose of carrying out those laws and their duties, but what laws they could create was strictly limited to those articulated. The Executive, beyond its primary directive of foreign affairs and domestic security, was empowered to make sure that the laws enacted by Congress were carried out. Justice was the arbiter between the states, and was the last hope when justice could not be found elsewhere.

All of the above was carefully worded in the various Articles. Article I addresses the Congress. Article II describes the Executive role. Article III describes the role of the judiciary. The remaining Articles (IV through VIII) address specific matters, such as how the Constitution may be altered, how new states may be admitted into the union, etc.

After the initial draft was presented to the people for their review, individually and by their respective state governments, a great debate ensued. (Actually, many debates ensued.) The most important one were the debates between the "Federalists" and the "Anti-Federalists." These are known as The Federalist Papers and The Anti-Federalist Papers. There can be no doubt of the Founders original intent when understood through those debates.

In Federalist 37, Madison framed the argument by describing the difficulties, goals, and the outcome of the Constitutional Convention:
The genius of republican liberty seems to demand on one side, not only that all power should be derived from the people, but that those intrusted with it should be kept in dependence on the people, by a short duration of their appointments; and that even during this short period the trust should be placed not in a few, but a number of hands. Stability, on the contrary, requires that the hands in which power is lodged should continue for a length of time the same. A frequent change of men will result from a frequent return of elections; and a frequent change of measures from a frequent change of men: whilst energy in government requires not only a certain duration of power, but the execution of it by a single hand.

Heretofore I have described the authority granted by the people to the Federal government. More importantly, however, is the balance of power between the Federal government and the States. Madison also describes the difficulties of this in Federalist 37:
To the difficulties already mentioned may be added the interfering pretensions of the larger and smaller States. We cannot err in supposing that the former would contend for a participation in the government, fully proportioned to their superior wealth and importance; and that the latter would not be less tenacious of the equality at present enjoyed by them. We may well suppose that neither side would entirely yield to the other, and consequently that the struggle could be terminated only by compromise. It is extremely probable, also, that after the ratio of representation had been adjusted, this very compromise must have produced a fresh struggle between the same parties, to give such a turn to the organization of the government, and to the distribution of its powers, as would increase the importance of the branches, in forming which they had respectively obtained the greatest share of influence. There are features in the Constitution which warrant each of these suppositions; and as far as either of them is well founded, it shows that the convention must have been compelled to sacrifice theoretical propriety to the force of extraneous considerations.

In Federalist 44, Madison addresses some of the ant-Federalist criticisms. In the passage below, he addresses the powers granted to Congress and the concerns that Congress would, at some future date, enlarge or expand on their limited powers (as they have done today):
If it be asked what is to be the consequence, in case the Congress shall misconstrue this part of the Constitution, and exercise powers not warranted by its true meaning, I answer, the same as if they should misconstrue or enlarge any other power vested in them; as if the general power had been reduced to particulars, and any one of these were to be violated; the same, in short, as if the State legislatures should violate the irrespective constitutional authorities. In the first instance, the success of the usurpation will depend on the executive and judiciary departments, which are to expound and give effect to the legislative acts; and in the last resort a remedy must be obtained from the people who can, by the election of more faithful representatives, annul the acts of the usurpers.

In Federalist 45, Madison details the concerns of too much state power, but what was concerning them at the time was an attempt by a powerful state to invade/control another state, not the Federal government encroaching on all the states. For this reason, state powers were not specifically articulated, but some state sovereignty was limited. Reading it today, however, is almost laughable. The checks and balances against encroachment of state authority has happened so pervasively and extensively, that remarks about how the numbers of people employed at the state level providing a buttress against the "few" at the Federal level, makes it absolutely clear that we have allowed all power-balancing strategies to be entirely eliminated. Madison was certain that the people would raise the alarm, and go to the guns, to address encroaching Federal powers long before they got to the point where we are today.

In Federalist 46, Madison addresses the concerns that the usurpation of state autonomy (or individual autonomy) would get so bad as to destroy the spirit and the literal powers of the States:
The only refuge left for those who prophesy the downfall of the State governments is the visionary supposition that the federal government may previously accumulate a military force for the projects of ambition. The reasonings contained in these papers must have been employed to little purpose indeed, if it could be necessary now to disprove the reality of this danger. That the people and the States should, for a sufficient period of time, elect an uninterupted succession of men ready to betray both; that the traitors should, throughout this period, uniformly and systematically pursue some fixed plan for the extension of the military establishment; that the governments and the people of the States should silently and patiently behold the gathering storm, and continue to supply the materials, until it should be prepared to burst on their own heads, must appear to every one more like the incoherent dreams of a delirious jealousy, or the misjudged exaggerations of a counterfeit zeal, than like the sober apprehensions of genuine patriotism.

Madison scoffed at the concerns, believing that the people would never stand for it, but all those fears have become our reality. We allowed all the worst-case scenarios to occur and that was something that Madison could never have fathomed.

So what do we do and what powers remain?

Before I address the best option, I'd like to address a concern: In many states the Second Amendment is in full force. For many of us, however, we wish to use that as a last resort, and attempt to restore the powers of the people and the respective States without resorting to war (or even some sort of agreed-upon, peaceful secession). The war option is far from being the only option, and surely the least desirable, when other options are still open to us.

There are a variety of suggestions to address the encroachment of Federal powers. Some have gone so far as to suggest we need to restate the limitions again, perhaps in new words, to make the point that the Constitution limits what the Federal government may do. This is the equivalent of applying bolds, asterisks, and underlines to what is already written. While I would not be opposed to these options, as I would support any and all peaceful attempts to address the problem, I do not think it is our best option.

The Constitution, in Amendments Ninth and Tenth, already state that the powers not specifically listed as granted to the Federal government remain with the states and/or the people. Saying it again is not going to change the status quo.  The Federal government is already ignoring what was written, so writing something else to be ignored is a futile gesture. We're past words. It is time for action.

The option that is open to us is state disobedience, but I use disobedience to better explain the idea rather than the word as a value judgement. It is the state-collective equivalent of civil disobedience. In truth, it is the Federal government that has been disobedient, by exercising powers they have not been granted. The only effective way to put meat into the limitations imposed on the Federal government is for the states to ignore actions, measures, and laws that are extra-constitutional. Only those actions, measures, initiatives, and laws that are specifically articulated in the Constitution as belonging to the Federal government will be respected by the several States, and by The People.

To this end, some state legislatures are passing "State Sovereignty" measures to restate their authority and limit Federal authority. These involve restatements of the Ninth and Tenth Amendments, which are:
Amendment IX
The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.

Amendment X
The powers not delegated to the United States by the Constitution, nor prohibited by it to the States, are reserved to the States respectively, or to the people.

While we shouldn't ignore Congressional elections, it is more important now to pay attention to state elections, including the legislatures and the governor. It is time for governors (with agreement by the state legislatures) to refuse to abide by unconstitutional Federal encroachment. This includes:

  • Refusing all TARP funds/invasions of Federal officers in local businesses.

  • Refusing all Stimulus funding.

  • Refusing all education funding and federal legislation regarding education (and all other unconstitutional government departments).

  • Exercise the option to call out the National Guards to protect our borders if our Federal government continues to refuse to exercise their primary directive.


It is time for states to refuse to comply and also refuse the bribe money that comes with it, while protecting state citizens from unconstitutional taxes and penalties.

It is the responsibility of our state legislatures and our governors to exercise the authority we have granted to them. It is time we work locally to elect representatives who will restore the balance of power between the Federal and State governments and reject all invasions and encroachments of Federal authorities.

The following is the kind of speech that every governor of every state should deliver on the day he or she is sworn into office:
The People of this state have graciously elected me as their Governor, and I understand fully the responsibilities and authorities they have entrusted to me, as well as the limitations of that power within our state, and those entrusted to the Federal government. There are strict lines of delineation, between the counties and cities within our state; the powers granted to the local mayors and city/town councils; the unique relationships we have with neighboring states, and the authority we recognize as belonging to the Federal government.

The authority we have granted to the Federal government is strictly limited to those items articulated in the U.S. Constitution. The Federal government has the responsibility and authority to declare war, to provide for the common defense, to coin money, to regulate the seas, oceans and post roads, and to protect the products and arts by providing copyright and patent laws, and the judiciary may intervene on matters between us and other states. The Federal government has no other powers or authority. As part of my oath today I swore to uphold and protect not only our State Constitution, but the Federal Constitution. I take that oath seriously. Beginning today, I will issue an order which returns all funds received from the Federal government that goes beyond their authority. I reject all laws enacted by Congress that goes beyond their specifically limited authority. I will refuse, with force if necessary, the invasion of Federal officers, in whatever department or uniform, to exercise authority not specifically granted to them.

For too long states have remained passive, gradually morphing from free and sovereign states to lowly beggars, looking to the Federal government for hand-outs and to do the job that governors were intended to perform. That transition into a lowly beggar class ends now.

  • If the Federal government does not perform its duty with respect to protecting our borders, I will call out our National Guard to do so.

  • If the Federal government attempts to send agents to interfere with our peaceful commerce within our state, I will stop them at the border, with force, if necessary.

  • If the Federal government attempts to arrest or in any way interfere with our citizens' refusal to pay taxes on anything other than their incomes (not wages) or taxes imposed equally among the states, but only for the percentage of Federal government budget that is Constitutional, I will issue orders to stop them. Our state officers, police, and National Guard will be called upon to intervene to protect our citizens from arrest or property seizure, if necessary.

  • I will call upon neighboring and friendly states to assist us if necessary, and I will respond to calls for assistance from other states, if they should need our assitance.


It is time, finally, for the State governors to exercise the powers they have been granted, to protect thier citizens in their respective states from invasions of their liberty by the extra-Constutional acts of the Federal government, and for the Several States to refuse to abide by unjust and unconstitutional laws.

Today, the liberty and values established by the Founders will be restored in this state, and I hope many others.

That is what is necessary. That is the change of direction I introduced in my opening paragraphs to alter the course of the train to prevent the wreck. Although patience is required, anything else or short of that is a guarantee that our republican government will cease to exist.

Chances it will happen? Zero. But Americans love the underdog and this post is supposed to be my non-cynical view of the future. Despite the fact that I clearly and carefully stated that "going to the guns" was not an option, I suppose that my suggestions would classify me as a terrorist to some.  Oh, well.  So much for being optimistic.

Some of Us

In an interview with AG Eric Holder by Pierre Thomas, Jason Ryan, and Theresa Cook (ABC News, Attorney General Eric Holder Speaks Exclusively to ABC News, July 29, 2009), Holder is quoted:
"The American people would be surprised by the depth of the threat, but also reassured to see the assets that have been deployed around the world," Holder said, adding that the United States interacts closely with its foreign partners.

Some Americans may be surprised at the amount of threats posed by terrorist groups, but not all of us.  Some people chose to respond to the 9/11 attacks by burying their head in the sand, believing it was an isolated incident -- like some sort of fluke of nature.  They also viewed the lack of additional attacks as meaning that there weren't any attempts.

Nothing could be further from reality.

The reality is that there are groups within the larger banner of al Qaeda and outside of its central planning approach who want nothing more than to carry out another 9/11 attack (or something much, much worse).
"Guantanamo is a place that has served as a recruiting tool for those who want to do us harm," he said.

Holder declined to say how many detainees could face trial in the United States, but said U.S. attorney offices around the country have been reviewing the cases for possible prosecution in those districts.

The Democrats continue to treat terrorism as a criminal action rather than as an act of war.  "Facing trial" is for criminal actions. Detaining unlawful combatants is not a criminal justice action. Holding these people (or deciding to put them before a firing squad) is a military matter.

Suggesting that Guantanamo serves as a recruitment vehicle for terrorists is both a strawman and a distraction. Everything we do, from being prosperous to checking passports on inbound passengers could be viewed as a "recruiting tool." Easter egg rolls on the White House lawn could be seen as a recruiting tool as it demonstrates an association with Christianity. The point being, that everything we do as a people, including everything we do to combat terrorism can be used by propagandists to encourage the weak minded to become radicalized.
"The possibility exists that there could be people who are held in a preventative way under the laws of war," he said. "If that happens, we'd only do so by creating a system that had due process.

"I think that by closing Guantanamo, by prosecuting people, be it in Article III courts, or in military commissions, we will make the American people safer than they are now," Holder continued.

In the above, Holder is talking out of both sides of his mouth. If the military commissions are successful at prosecuting illegal combatants, the result will be the firing squad.  How, exactly, would that event appease terrorists?  Appeasing the terrorists would require that the men in detention are found not to be illegal combatants and released. That would prove that our military are bumbling idiots for picking up the wrong people (a characterization much favored by many on the Left) or they're dangerous terrorists who will be released on some sort of technicality. Neither scenario is good for our side.

The fate of an unlawful combatant is death.  There is no other outcome. They aren't given life sentences, as one might receive for murder, or put in some sort of work/release program. Illegal combatants are shot or hanged. Delaying that outcome with detention, as long as the detainees are useful to us, is the best way to protect us.

We're at war, even if the Left continues to try to treat this as a criminal problem, doing anything necessary to avoid a military entanglement. Criminals don't fly suicide missions with the purpose of terrorizing their enemies into submission. Military enemies do that, and it appears that terrorism is working on those on the Left. Submission is their middle name.

None of this is surprising to some of us. The Left has been spewing the criminal justice angle of this matter since the beginning.  The Left knows they can't win elections because of their track record on handling military matters. Republicans are perceived (rightly) as being the best people to have in charge in war time, so the Left worked really hard to distract the public from acknowledging that there is a war on! The media presented the battles as a lost cause and a political battle, not a literal one. They've campaigned that the Bush response was overreach... and now they're trying to tell us that terrorists really are something serious, and something to worry about... and how hard they work everyday to keep us safe.
He noted, however, that the Bush administration "left us an infrastructure that I think is very good," and that national security officials are constantly striving to put the country in a safer position.

Some of us know that, too.

The Bush Administration kept us safe, but they didn't find it necessary to whine about it or constantly toot their own horn for performing their primary directive, doing their job.  Perhaps that was Bush's failing -- he gave the American people too much credit -- perhaps the American people do need to be constantly reminded that there is a war going on, and there really are people out to get us.
Americans are asking: How will we fight and win this war? We will direct every resource at our command -- every means of diplomacy, every tool of intelligence, every instrument of law enforcement, every financial influence, and every necessary weapon of war -- to the disruption and to the defeat of the global terror network.

This war will not be like the war against Iraq a decade ago, with a decisive liberation of territory and a swift conclusion. It will not look like the air war above Kosovo two years ago, where no ground troops were used and not a single American was lost in combat.

Our response involves far more than instant retaliation and isolated strikes. Americans should not expect one battle, but a lengthy campaign, unlike any other we have ever seen. It may include dramatic strikes, visible on TV, and covert operations, secret even in success.

- George W. Bush, Address to the Nation, Washington, DC, September 20, 2001



Some people are surprised that terrorism continues to be a threat. Some aren't. Some people forget what was said and promised. Some of us remember.

We will not waiver, we will not tire, we will not falter, and we will not fail.

H/t Drudge.

Wednesday, July 29, 2009

What Matters

Michael Barone (Washington Examiner, Obama has aura but doesn't know how to legislate, July 29, 2009) states the obvious:
In other words, he's [Obama] never done much work putting legislation together -- especially legislation that channels vast flows of money and affects the workings of parts of the economy that deeply affect people's lives. This lack of experience is starting to show. On the major legislation considered this year -- the stimulus, cap and trade, health care -- the Obama White House has done little or nothing to set down markers, to provide guidance, to establish boundaries and no-go areas.

None of this should come as a surprise to anyone. The country elected a neophyte to POTUS (which is why the Republicans shouldn't try to do the same--people will be crying for a Eisenhower/Reagan type Grandpa come 2016, and avoiding game-show-host-charisma style candidates--the party that puts Grandpa out there will win).  If this POTUS has taught us anything, it is that there is no room for learning on the job. Experience matters, in all things, even if it is the illusion of experience.

Petreus / Perry 2016.


Other contenders include (sorry to say that there are no other Governors besides Rick Perry with sufficient experience and wisdom):

Over

From Byron York (Washington Examiner, Obama, playing defense on the stimulus, July 29, 2009):
The speech seems a pretty clear indication that Republicans (and the polls) have put Obama on the defensive.

The polls have him running scared, as it should be.  Americans may have been temporarily fooled by his moderate campaign speak, but nakedness of this Emperor and his true tyrannical stripes are beginning to show.

'We' have Obama on the run and this is only the beginning of his demise. The honeymoon is officially over. The divorce proceedings are going to be ugly.

On Their Watch

Social Security and Medicare are underfunded by $40 trillion.  Saying that they are underfunded is a bit of a bait and switch, as these programs have never been funded. FICA deductions go into the General Fund, with all the other taxes collected by the Feds.

When Bush was campaigning for his second term he focused on Social Security reform, but Congress (now an obvious, not statistical Democrat majority) would have no part of it.  Aggravating blue collar workers and the AARP is political suicide, so Congress did nothing to reform Social Security.

Whether that was cowardice or strategic (to further weaken the economy to bolster a win in 2008) doesn't matter.  The reality is that the Boomers are gradually shifting from the contributing to the receiving line of the FICA deduction, and their mass will shift the FICA budget line from positive to negative as early as 2012.  No more will Democrats have the FICA excess to play around with, which is why they're advocating "health care reform" and infusing it with methods to ration existing entitlement programs, while shoring up the gravy train for other programs.

In the socialized medicine Bills there are plans to begin rationing Medicare (as health care "reform" has little or nothing to do with Medicare).  Someone is going to have to do it eventually.  I'm just glad that the Democrats will have to own it, but I'm certain that they'll figure out a way to blame the Republicans for it.

In in decade it won't matter and AARP and Social Security recipients will be thrown under a bus.  They have to be, as there won't be enough money to pay even a fraction of their total federal entitlement payments.  And rightly, as it is their fault: their generation did nothing to guarantee that the money would be there when they got to retirement age. It won't matter if it was ignorance or malice.  Reality is immune to cause.  It just is.  And "empty" is what the coffers will be.

Friday, July 24, 2009

Soylent Green is People!

Reading through the Twitter posts from Peter Fleckstein, posted by Savage (Little Green Footballs, Inside the Health Care Bill, aka HR3200, July 22, 2009), that's the thought that kept popping into my head:
PG 425: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 4-12 Government mandates Advance Care Planning Consult. Think Senior Citizens end of life

Pg 425: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 17-19 Government will instruct and consult regarding living wills, durable powers of attorney. Mandatory!

PG 425: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 22-25, 426 Lines 1-3 Government provides approved list of end of life resources, guiding you in death!

PG 427: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 15-24 Government mandates program for orders for end of life. The Government has a say in how your life ends!

Pg 429: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 1-9 An “advance care planning consultant” will be used frequently as patients health deteriorates.

PG 429: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 10-12 “advance care consultation” may include an ORDER 4 end of life plans. AN ORDER from GOV

Pg 429: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 13-25 – The Government will specify which Doctors can write an end of life order.

PG 430: SEC. 1233. ADVANCE CARE PLANNING CONSULTATION Lines 11-15 The Government will decide what level of treatment you will have at end of life.

(For people who don't understand the reference, Soylent Green was a film based on a dystopic novel [Make Room! Make Room! by Harry Harrison] where government mandated that people submit themselves to be killed on their 65th birthday. Set in a future where pollution prevented crop growth, there were food shortages. It was determined that the government-issued green wafers given to the people as nourishment was made from the bodies of the elderly.)

There is a point, however, where arguing the details is counterproductive. The bottom line is that government, especially the Federal government, has no authority to "reform" health care. It should be rejected on principle, regardless of the details.

H/t comment by katablog.com (James Pethokoukis, Reuters Blogs, Why Obama might have just killed Obamacare, July 23, 2009)

Thursday, July 23, 2009

Title Not Found

With regard to the Amazon/1984 stories: The ignorance of how databases work and what data-syncing is continues. This article and comments at Network World illustrate the ignorance.

Background: Kindle users were able to buy an ebook that was distributed without copyright authorization. As soon as Amazon was made aware of the problem, they removed the title (Orwell's 1984, to make the story interesting) from their catalog.

That's the back-story. What happened next should be a surprise only to people who don't understand how these things work, and I'm not referring to how ebooks are created or sold (or anything having to do with copyrights or license agreements).

A database is a collection of tables. Tables are a collection of records. Records are a collection of fields. Fields are made up of bits/characters.

(A record may be synonymous with a "transaction" but it isn't always.)

I'll start with a single table.

A database like Amazon's contains customers. Customers have certain characteristics, such as names, shipping and billing addresses, join dates, last purchase date, phone numbers, etc. Some of those characteristics will be stored in a "customer" table, some will be stored in subordinate tables, but they're only subordinate because we think of them that way. They're just tables. The relationships the tables have to each other (if any) is because of our understanding of how the data relates, not because computers/databases have any inherent understanding of these relationships.

The Amazon database also contains a "products" table. Those products make up their catalog. Products have characteristics of their own, such as supplier, unit of sale, weight, description, name, etc.

The "supplier" of an item will also be a record in a "supplier" table. That table will have the contact information for the supplier, their main contact address, as well as any other data elements Amazon might wish to maintain at that level.

Amazon will also have a price file (or a "price table") because all retailers do. They'll also have some sort of inventory tracking table (either maintained locally for the items they stock in their own warehouse or combined with a hook into the supplier's inventory system, if inventory is maintained by the supplier). In an operation like Amazon, inventory is all over the place, so a combination of methods is used.

Customer and supplier records are reasonably static. That doesn't mean that they don't ever change. They do change, because suppliers and new customers are always added, in addition to keeping them updated when suppliers and customers move. Transaction tables are constantly changing... that's why they're called "transactions."

When you log on to Amazon you sign in with your email address, but because email addresses can change, that isn't your customer number. (Some database designers are stupid enough to use an email address as a customer record number, but as I said, they're stupid.) It is a given that every customer has a customer record number and every supplier has a supplier record number. Each product in the Amazon catalog has a product number, too, which can be a single item, or a combination of items sold as part of a bundle. (Think of a computer that may be sold in a bundle that includes a laptop computer, a power cord, and instruction manuals--each having unique part numbers, but when combined create a unique product number.)

Let's say that my customer record number is C001. I'll keep it simple and we'll assume that I only have one billing and one shipping address (we know that Amazon customers can store dozens of each, but we'll ignore that).

I initiate an order for product P001.

A transaction table exists to create a relationship record of that order. That record says that customer C001 bought P001. Nothing in the transaction table knows what a P001 is, nor does the transaction table know that C001 is me. It is just linking the two together with other information to keep the transaction unique (such as assigning it a transaction number, the date the purchase was made, the date the transaction was created, etc.).

On the front end, Amazon displays a report of this transaction to me and sends it in the form of an order confirmation in email. That order confirmation will include the name of item I purchased because reports can be programmed to "look up" data from other tables and other databases. Since we have a product number (P001), we have the descriptive information for that item from the products table. Since we have a hook from products to suppliers, the report can also display details about the supplier, such as:

On 7/23/2009 you purchased Qty: 1, Item #: P001-Databases for Morons from "Technical Publishers."

If I purchased more than one item, it would list the additional items purchased.

The above might give the appearance that the transaction order contains the descriptive information, but it doesn't. It only contains record numbers and dates. A table that contains redundant data, such as a transaction table that contains anything but the record number of a product or customer is referred to as "denormalized." That redundancy is bad, not only because it uses more space in the database than it needs to, but because it can quickly create "out of balance" or "out of sync" situations (depending on the transaction type). When a customer changes their name, for example, their customer record is updated, and only that record. If the order table copied the customer name to the table when an order was created, it won't get notified/changed when the name change occurs (without redundant/unnecessary programming). So this stuff is kept simple, i.e., normalized.

On the backend, a bunch of things happen when a customer clicks "submit" on their order. Something equivalent to a packing slip or pull order is created for the items in Amazon's warehouse. For items not in Amazon's warehouse, the equivalent of a pull order is sent to the drop shipper/supplier. Once the item(s) are pulled from inventory, a transaction is created to reduce inventory for the quantity of items purchased. A shipper order number is created (with a vendor such as UPS or Fedex) once the package is boxed. Debits are processed against my credit card. At each stage of the order fulfillment process a status change is noted in the transaction record that triggers an update in an email sent to me:
1. Order acknowledgement
2. Order processing
3. Order filled/shipping order assigned

If there are any glitches, such as a delay in processing, a discovery that an out of stock conditions exists, etc., an exception will be generated.

When a system is first designed the developers try to trap as many exceptions as they can. When programming changes are required later, it usually has nothing to do with bugs in programming code, as those are caught and corrected early. It is generally because there are new exceptions (where human beings get involved in the process and make mistakes). It is also because there are new types of product offerings that didn't exist when the system was initially created.

Reprogramming is always more problematic than initial programming. This is because there are hundreds (sometimes thousands) of hooks into different tables, databases, and systems that need to be adjusted when changes are made in one place that have to be cascaded to other parts of the process. The programmer responsible for making the changes doesn't know what all those hooks are, and exceptions/mistakes occur when the system encounters a condition that wasn't adjusted.

One of the processes that retailers have to account for is removals from catalog. There are dozens of reasons why a retailer may wish to "de-list" a product. It could have been a limited run, special pricing, a supplier goes out of business, the supplier wasn't reliable, a new supplier had the item available at a better profit margin, etc. A one-size-fits-all method of handling this won't work, because there isn't a one-size-fits-all reason. That makes things even more complicated for a programmer, but that's why they make the big $$$.

If a supplier is determined to be unreliable, the supplier won't be used and that includes delisting all the products they sold. If an item is no longer made, the supplier is still used for other items, just not that item.

The point being that (regardless of why or how it is done) retailers are constantly changing their catalog offerings.

You can't delete records. Well, you can, technically, but you don't because that creates a "title not found" condition. If, for example, a supplier record is deleted from the supplier table, when I look through my order history at Amazon, the spot that was originally filled in with "Technical Publishers" will be blank (or filled in with the error message "title not found"). If a customer record is deleted, when Amazon attempts to reconcile their credits from the credit card companies, they won't be able to tie back to a specific customer. Because of this, records are not deleted. They're "closed." This can be as simple a step as changing a status flag from "O" ("Open") to "C" ("Closed").

If I asked Amazon to delete my account, they wouldn't actually delete it. They'd "close" it, because deleting it would create havoc throughout their system (as well as create havoc from an accounting standpoint, because all the history associated with my account would be lost, and that's a no-no from a bookkeeping/accounting standpoint).

Now some folks might get upset that their data isn't deleted, but that's just tough. Before computers came into the picture to track these things, companies kept ledgers of all this stuff. No one would have suggested that a company go through 15 years of ledgers and take scissors to their books of record. The fact that people don't make the logical leap from ledger to computer record is their stupid fault, not the fault of the retailer. Not only would a company not want to delete your record, in many cases (where book of record requirements exist) it could be unlawful to do so.

So Amazon got into the ebook business. Their systems were initially designed for the sale of tangible items. There was certainly a lot of reprogramming required to offer this new service. One of the main changes is that Amazon had to create a storage account, where all the items a customer has purchased can be stored. And this is where this (obviously) gets confusing for some people.

They didn't literally create a storage box for each customer, as we might buy a new physical hard-drive to store additional data. A literal storage device would mean that Amazon would store the same item over and over again, hundreds of times, in each customer's unique storage box. That would be redundant and unnecessary, and the physical storage requirements would be mind-boggling. What they created was a virtual (meaning, "not real") storage box, similar to an order transaction record. Amazon has one pointer to a copy of each electronic media they sell, each with a unique part number.  When customer A001 buys one, they create a transaction which is equivalent to an e-book storage table so it shows up in my storage box list. It is a virtual library of "my" stuff. The physical copy is stored in one location. The list of books in my storage box is an index (akin to a "link") to the file name and location of the item.

What I do not know for certain, but I would guess, is that Amazon doesn't have all the e-book files on their own servers. I would guess that they point to files on servers Amazon doesn't maintain themselves, as they have distributors who stock items for them (and I have some inside knowledge to validate my suspicion that they do this). What the record of each item would include would be the file name and the server location where it was stored. Whether the item was stored on Amazon's servers or on a supplier's server would be invisible to a customer, as customers are also unaware that their storage box is virtual, not literal.

A customer's Kindle is linked to their virtual storage box. When a customer buys a new item, a transaction is created that displays the item in the virtual storage box that, in turn, allows the item to be downloaded to the Kindle device. The customer can choose which items they want to have on their Kindle, up to the maximum storage of the device itself. This allows a customer to buy more items than the Kindle device can literally store, and can control which items are physically stored at any given time.

When a Kindle customer has their device radio on, the system will sync the list of items in their virtual storage with the list of items currently on the device. This is similar to doing a manual, physical inventory check every now and again.

To put this in perspective, let's say that you went to the library. You go to the card catalog. You find the book you want in the catalog and the Dewey Decimal system locator. You go to that section of the library but the book isn't there.

If you immediately assert that Ninjas broke into the library, knowing that you wanted to read that book, and took that book to a fire pit and burned it so you couldn't read it, might others think your conspiracy theory a bit daft (and you a bit scary), given that it could simply be that someone else had already checked the booked out of the library? The librarian could have put the book in the wrong place. The card for the book could have had the wrong identifier number typed on it. The library may have delisted the book, but forgot to take the card index out of the card file. Where human beings are involved mistakes will be made, most often, innocently. Yes, it could be that Ninjas did all that, but until we have evidence of that, Occam's Razor requires we go with the simplest and most common explanation first.

What happens when Amazon delists an e-book item because the supplier is found to have been in violation of copyright law, with respect to some or all of the titles they sell? Did Amazon Ninjas break into your house and purposely destroy an ebook or is some other, more reasonable explanation plausible?

Was the supplier record deleted or closed? Was the product number deleted, or closed, and what happens to the titles listed in the virtual storage on Amazon when that happens? Was the file deleted from Amazon's servers? Was the link to the supplier's server deleted from the e-book's record?

Regardless of the dozens of innocent technical glitches that could have caused this, the title was no longer available on Amazon's catalog; therefore, the item was no longer available in the Kindle virtual storage box. When a customer synced their device to their virtual storage, the item was no longer there. Amazon didn't, despite the protests of idiots everywhere, send Ninjas out to reach into each customer's Kindle and run some sort of delete/destroy routine. The item itself, or the link to the item or the item's server no longer existed, so it was no longer in the index of the Kindle device.

Amazon will have to reprogram their system so this doesn't happen again. They said that, and apologized for the glitch. They refunded the money for the items purchased.

Folks who think that Amazon virtually broke into their Kindle to delete files have no clue how databases work, what virtual storage boxes are, or what syncing means.

Amazon discovered what happens when you de-list an item, in a way that worked for tangible items, in a process that had not been programmed to handle it, and they're fixing it. Maybe Oswald did it, but until we have evidence of that, let's assume a programming glitch because those happen thousands and thousands of times every day: no conspiracy or grand-theft illusions required.

Please, if you do not understand the above, shut up. You're embarrassing yourself.