database OKD

Text-file rows have eight fields, separated by one backslash {database, OKD}.

records: fields and order

Fields are heading/contents, event start date, event end date, person or entity name, occupation or title, location, creations, and header/details.

records: history or non-history

Database entries are either History or non-History records. Non-History entries have only heading/contents and header/details. History entries have heading/contents and header/details, plus event start date, event end date, person or entity name, occupation or title, location, and creations.

records: non-history

Non-History entries are about concepts. Heading field places idea in knowledge hierarchy. Header names idea. The details define idea, give examples, and relate idea to other ideas. If detail sentence begins with "However" or "Perhaps", sentence comments or speculates.

records: history

History entries describe who, what, where, when, why, and how about event or person. Who is in person or entity name, field 4, and in occupation or title, field 5. What is in creations, field 7. Where is in location, field 6. When event happened, or when person flourished, is in start date and end date, fields 2 and 3. Dates person lived are in details, field 8. Details state Why and How and more about Who, What, Where, and When. Heading/contents indicates history category, such as mathematics or inventions.

fields: heading

All entries have heading-and-contents field 1, which has main, secondary, and higher levels, separated by greater-than signs. Headings organize all information into hierarchy.

Main headings are Database Description 0, Consciousness 1, Arts 2, Mathematical Sciences 3, Biological Sciences 4, Physical Sciences 5, Social Sciences 6, and Practical Affairs 7.

Secondary heading for Database Description is Outline Of Knowledge (OUTL).

Secondary heading for Consciousness is Consciousness (CONS).

Secondary headings for Arts are Art (ART ), Dance (DANC), Literature (LITE), Movie (MOVI), Music (MUSI), Photography (PHOT), Radio (RADI), and Television (TELE).

Secondary headings for Mathematical Sciences are Algebra (ALGE), Arithmetic (ARIT), Calculus (CALC), Computer Science (COMP), Game Theory (GAME), Geometry (GEOM), Group Theory (GROU), Information Theory (INFO), Logic (LOGI), Mathematics (MATH), Number Theory (NUMB), Set Theory (SETT), Statistics (STAT), and Topology (TOPO).

Secondary headings for Biological Sciences are Biology (BIOL), Botany (BOTA), Ecology (ECOL), Medicine (MEDI), Nutrition (NUTR), and Zoology (ZOOL).

Secondary headings for Physical Sciences are Astronomy (ASTR), Chemistry (CHEM), Earth Science (EART), and Physics (PHYS).

Secondary headings for Social Sciences are Economics (ECON), Education (EDUC), Geography (GEOG), History (HIST), Law (LAW ), Linguistics (LING), Philosophy (PHIL), Political Science (POLI), Psychology (PSYC), Religion (RELI), and Sociology (SOCI).

Secondary headings for Practical Affairs are Food (FOOD), Game (GAME), Health (HEAL), Housing (HOUS), Legal Affairs (LEGA), Machine (MACH), Military Affairs (MILI), Financial Affairs (FINA), Personal Affairs (PERS), and Transportation (TRAN).

To replace abbreviations with full fields, use Microsoft Excel Visual Basic procedure replace1and4lettabbrwithfield1 in allprocedures.xls. To replace full fields with abbreviations, use procedure replacefieldwith4letterabbr1.

Tertiary headings name subject branches. Later headings group topics.

fields: beginning date

History entries have event date, field 2. Date number has format year.moda, such as 1000.1231 or 999.0501, so sorting dates sorts by number. Years after BCE (AD) have no sign. BCE (BC) years are negative, for example, 999 BCE = -999. Negative years never have month or day. Beginning date can be year-range first year. (People's birth and death dates are in Details field, field 8.)

fields: ending date

History entries have ending date, field 3, which has same format as beginning date. Ending date is year-range last year.

fields: person

History entries name people, groups, or events, in field 4. Forward slash separates different names. Name variants use " or ". Names have first name first. Last names first are in brackets.

fields: occupation

History entries give occupation or title, in field 5. Forward slash separates occupations.

fields: location

History entries list regions, cities, countries, continents, Earth, or Universe, in field 6. Forward slash separates locations.

fields: works

History entries list books, artworks, music, and inventions, in field 7. Semicolons separate works. Brackets after title contain date and background information. Titles do not have quotation marks or underlining.

fields: details

Entries provide details, comments, definitions, descriptions, explanations, formulas, examples, or reasons, in field 8. First part is Details header, which indicates entry subject. Web-site entry file name is Details header plus ".html". Line headers are unique. After header is blank, hyphen, and blank.

Parentheses are for mathematical expressions, discoverer names, and for translating foreign-language words into English. Brackets are for dates and references. Quotations are for direct quotes and for designating words. Curly brackets are for index entries. After right curly brackets, pipes | indicate that index entry is in glossary. Index entries are only in Details field.

fields: record number

Field is not in use. Entries have number, in field 9, to indicate optimum entry reading and browsing order. Generate record numbers and add to records using procedure generatenumberforrecord1 or addlinenumbertobeginning1.

fields: reference

Field is not in use. Entries list entry-information author, title, publisher, location, date, and page numbers, or Web site URI, in field 10. Field-10 references are "none" = none, "text" = college textbook or dictionary or encyclopedia, "ScAm" = Scientific American, "dict" = collegiate dictionary, "ency" = printed or online encyclopedia, "FDOH" = Farsi dictionary or handbook, "JDOH" = Japanese dictionary or handbook, or "VDOH" = Vietnamese dictionary or handbook. Extract reference citations from Detail field using procedure generatereferencecitations1 and compare to references in Consciousness Bibliography.txt.

fields: entry date

Field is not in use. Entries have number in format year.moda, such as 2005.1231, to track data entry, revision, or deletion, in field 11.

fields: significance

Field is not in use. Entry last field indicates significance or importance, in field 12. Asterisk indicates significant information. Period indicates secondary information.

database field modification

You can modify addfieldsafterheading1 to add more fields or change fields.

Related Topics in Table of Contents

Database>Outline Of Knowledge>Database

Whole Section in One File

0-Outline Of Knowledge-Database

Drawings

Drawings

Contents and Indexes of Topics, Names, and Works

Outline of Knowledge Database Home Page

Contents

Glossary

Topic Index

Name Index

Works Index

Searching

Search Form

Database Information, Disclaimer, Privacy Statement, and Rights

Description of Outline of Knowledge Database

Notation

Disclaimer

Copyright Not Claimed

Privacy Statement

References and Bibliography

Consciousness Bibliography

Technical Information

Date Modified: 2022.0224