Describing the World: Data Model Patterns

1. Library of Congress David C. Hay Washington, DCMarch 24, 2009 Essential Strategies, Inc. 13 Hilshire Grove Lane, Houston, TX 77055(2 (713) 464-8316 . dch@essentialstrategies.comz www.essentialstrategies.com Describing the World:Data Model Patterns Part Two: Metadata

2. Metadata models are descriptions that can apply to the entire enterprise model or any part of it. Part Two: Metadata and Specializations • Abstraction Level 1: Metadata • Information Resources • Accounting

3. Part Two: Metadata and Specializations • Abstraction Level 1: Metadata • Information Resources • Accounting

4. INFORMATION RESOURCE DEFINITION: “Data Model Patterns…” (ISBN: 0-932633-29-3), “U.S. Constitution”, “Dch@essen... to rkh5donkey@yahoo.com” etc. INFORMATION RESOURCE INSTANCE: “Data Model Patterns…” (copy 235), “U.S. Constitution”, (Original in national Achives) “Dch@essen... to rkh5donkey@yahoo.com” “(copy to rkh…)” “(copy to dch…) etc. MEDIUM: “Book”, “Legal document”, “E-mail”, etc. 1. Information Resources . . .

5. Functional Requirements for Bibliographic Records . . .

6. Definitions . . . • Item - a physical object that has paper pages and a binding and can sometimes be used to prop open a door or hold up a table leg. • Manifestation – a “publication” as when we go to a bookstore to purchase a book. We may know its ISBN but the particular copy does not matter as long as it’s in good condition and not missing pages. • Expression - a particular text in a specific language. • Work - the conceptual content that underlies all of the linguistic versions, the storybeing told in the book, the ideas in a person’s head for the book.

7. In the Hay version . . . • Work is represented by Information Resource Definition. • Item is represented by Information Resource Instance. • Manifestationis (sort of) encompassed in Information Resource Definition. • Expressionis not adequately handled at all.

8. You know the difference between a terrorist and a data modeler, of course . . .

9. INFORMATION RESOURCE RELATIONSHIP: …STRUCTURE: “Data Model Patterns…” || “Chapter 3: The Enterprise” …REFERENCE: “Data Model Patterns…” || “1. R.G. Ross, The Business rule Book” etc. 2. Information Resource Relationships . . .

10. CONCEPT: “A willingness to lend money (by a bank)” “A structure and associated elements for removing crude oil from the ground (by an oil company).” etc. EXPRESSION: “Facility” “Data Model” “Site” etc. 3. Business Terms . . .

11. Example of BUSINESS TERM . . . • Facility – “A willingness to lend money.” • Facility – “A structure and associated elements for removing crude oil from the ground.” • Site – “A structure and associated elements for removing crude oil from the ground.” • etc.

12. NOTE: Anything else in the model can be a MODELED CONCEPT,represented by one or more BUSINESS TERMS. 4. Data Model as Concepts . . .

13. The fundamental problem . . .

14. The fundamental problem . . . • Items (Information Resource Definitions) are physical resources, like any other Physical Asset, to be inventoried and managed like any other. • Works (Information Resource Instances) may in fact be related to any other entity class in the model. • The many-to-many relationships hide a much more complex world than it appears.

15. INFORMATION RE- SOURCE CONTENT is the text that constitutes the resource An INFORMATION RE-SOURCE DESCRIPTION of a DOCUMENT is the metadata (such as “title”, “ISBN”, etc.) that describe the information resource. An INFORMATION RE- SOURCE TOPIC ASSIG- NMENT is a “tag” that categorizes the INFOR-MATION RESOURCE CONTENT. NOTE: An INFORMATION RESOURCE may be “about” any other ENTITY, ATTRIBUTE, or RELATIONSHIP in the enterprise data model. 5. Descriptions and Topics . . .

16. DISTRIBUTION: “Dch@essen... to rkh5donkey@ yahoo.com copy to rkh” “Dch@essen... to rkh5donkey@yahoo.com” copy to dch” etc. 6. Distributions . . .

17. About people . . .

18. What about . . . ? • “is edited by” • “is illustrated by” • “is sold by” • Etc.

19. 7. Information Resource Roles . . .

20. 8. Disposition Rules . . .

21. 9. Actual Dispositions . . .

22. Part Two: Metadata and Specializations • Abstraction Level 1: Metadata • Documents • Accounting

23. I know . . . • Everybody (ok, nearly everyone) hates accounting. • It is truly mysterious. • And the source of great shenanigans. • I always thought so. • Until I discovered something . . .

24. So, let’s learn how to keep the books… The two interesting things about bookkeeping . . . • It is the only word in the English language that contains three sets of double letters next to each other. • It is itself a modeling language. It describes the organization in a formal way. • Luca Pacioli, a monk and collaborator of Leonardo da Vinci, first codified the system in a mathematics textbook of 1494. • Assignment: Invent a way to “model” the assets of the church. • Oh, and we don’t recognize the existence of negative numbers.

25. Business Rule: The total value of all Asset Account BALANCES must equal • the total value of all Liability Account BALANCES plus • - the total value of all Equity Account BALANCES. About Accounts • An account is a name for a collection of financial quantities • Asset Account – the amount of money or items of value held by the organization. • Liability Account – of the amount of Assets, that amount which was loaned by someone outside the organization. • Equity Account – of the amount of Assets, that amount which is owned by the organization.

26. In the Federal Government, an ACCOUNT is called a “Fiscal Strip”, an ACCOUNT TYPE is a “Budget Order Class”, and a COST CENTER is called a “Budget Line Item”. 1. Accounts . . .

27. Business Rule: An ACCOUNT may only be part of a singleACCOUNT STRUCTURE in a particular ROLL-UP SCHEME. 2. Account Structures and Categories . . .

28. Some Accounting Business Rules . . . • To maintain the equivalence cited above, every transaction must: • Add to an ASSET ACCOUNT andsubtract from an ASSET ACCOUNT, or • Add to an ASSET ACCOUNT andadd to a LIABILITY ACCOUNT or an EQUITY ACCOUNT, or • Subtract from an ASSET ACCOUNT andsubtract from an EQUITY ACCOUNT.

29. credit credit plus plus debit debit plus debit credit plus minus minus debit minus minus credit debit credit credit plus plus plus debit credit minus minus debit minus Some Accounting Business Rules (cont.) . . . • To do this, it must consist of: • A DEBIT, which either • adds to an ASSET ACCOUNT, <or> • subtracts from a LIABILITY ACCOUNT, <or> • subtracts from an EQUITY ACCOUNT, <and> • A CREDIT, which either • subtracts from an ASSET ACCOUNT, <or> • adds to a LIABILITY ACCOUNT, <or> • adds to an EQUITY ACCOUNT. • Each new BALANCE, then, is created by adding or subtracting from the previous balance according to these rules. Liabil-ity Asset Equity

30. 3. Accounting Transactions . . .

31. For example . . . Accounting Transaction Account Credited AccountDebited TransactionValue Credit AccountBalance DebitAccountBalance CashSale Revenue(Equity)+ Cash(Asset)+ 430 6060 1024 Invoice Revenue(Equity)+ Accounts Receivable(Asset)+ 500 6560 1500 Payment Receipt Accounts Receivable (Asset)- Cash(Asset)+ 500 1000 1524

32. 4. Accounting Rule Entries . . .

33. For Example . . . Accounting transaction type Debit rule account +/- Credit rule account +/- Invoice Accounts Receivable (Asset) + Revenue (Equity + Payment Received Cash on hand (Asset) + Accounts Receivable (Asset) _ Purchase Inventory (Asset) + Accounts Payable (Liability) + Payment Made Accounts Payable (Liability) _ Cash on Hand (Asset) -

34. 5. Accounting Cost Center Links . . .

35. More Accounting Cost Center Links . . . ??

36. 6. Transaction Product Cost Links . . .

37. Questions?