WordEngineering

Ken Adeniji

A thesis submitted for the degree of Doctor of Philosophy in the Faculty of Science.

Abstract

Thesis Statement: This dissertation introduces AlphabetSequence ( 2 Corinthians 10:9-18 ). The AlphabetSequenceIndex is the result of a pure function to sum alphabet places AlphabetSequence.cs . The AlphabetSequenceIndexScriptureReference are the offsets from the beginning and the ending of the Scripture. The AlphabetSequenceIndexScriptureReference consists of four parts; there are two references each to particular chapters and verses. The first mention is the forward verse, which the author calculates by determining the AlphabetSequenceIndex verse in the Bible. The second mention is the forward chapter, and this the author calculates as before, but by substituting the verse with the chapter. Both the backward chapter and backward verse are the corresponding, anticlockwise places.

The importance of this work?

Where does the Bible list? Creation days, genealogies, allies, plagues, tribes, journey, commandments, reigns, kingdoms, disciples, fruit of the Holy Spirit, churches.

Acknowledgments

Chuck Missler of Koinonia House (KHouse) is worthy of note, faith (Hebrews 11).

The author is indebted to Ury Schecow, his Master's degree supervisor, at the University of Technology, Sydney (UTS), 15 Broadway Ultimo (NSW), 2007, Australia. The author is grateful to Tom Osborne, his Artificial Intelligence instructor; and Brian Henderson-Sellers, his Object-Oriented Technology instructor; both also at UTS. The author makes mention of his colleagues at UTS; Decler Mendez, Cesar Orcando, Ricardo Lamas and Peter Milne. The author stretches his open hand to Robyn A. Lindley, his Doctorate degree supervisor at the University of Wollongong (UOW), NSW 2522, Australia.

Theory

www.JesusInTheLamb.com
Part Example Commentary
Sub-domain www A sub-domain defaults to www.
Domain JesusInTheLamb
Country code top-level domain (ccTLD) .com An abbreviation for commercial. A default domain extension.
Directory and filename The default, for example, is index.html
Fragment
It is not an e-mail address, since it does not include an at sign, @.
It defaults to port 80.
It defaults to the homepage.

The issuing of this domain name may be related to commencing writing the book titled Ocean Senior on . There has not been a follow-up on future artifacts. But when one reads the Bible, the book of Revelation, which starts with the letters to the 7 churches in Asia Minor, does not instigate future alteration.

The Bible Database

The Scripture Table

The content of the Bible SQL Server database is principally the Scripture table. The Scripture table has a composite primary key , which consists of three columns; the BookID, ChapterID, and VerseID columns. The SQL statement

ALTER TABLE Bible..Scripture ADD CONSTRAINT PK_Scripture PRIMARY KEY CLUSTERED 
(
	BookID ASC,
	ChapterID ASC,
	VerseID ASC
)
is for setting the primary key.

There are varchar(MAX) columns which has the text for each Bible version.

The Scripture Table's BookID Column
Because there are sixty-six books in the Bible, the BookID ranges between 1 and 66; starting from Genesis and ending at Revelation. The SQL statement

ALTER TABLE Bible..Scripture ADD CONSTRAINT CK_Scripture_BookID_Range CHECK (BookID BETWEEN 1 AND 66)
will set the range restriction.
The Scripture Table's ChapterID Column
The ChapterID ranges between 1 and 150; the SQL statement

SELECT MAX(ChapterID) FROM Bible..Scripture
is for determining the upper limit. The SQL statement

ALTER TABLE Bible..Scripture WITH CHECK ADD CONSTRAINT CK_Scripture_ChapterID_Range CHECK  (([ChapterID]>=(1) AND [ChapterID]<=(150)))
will set the range restriction.
The Scripture Table's VerseID Column
The VerseID ranges between 1 and 176; the SQL statement

SELECT MAX(VerseID) FROM Bible..Scripture
is for determining the upper limit. The SQL statement

ALTER TABLE Bible..Scripture WITH CHECK ADD CONSTRAINT CK_Scripture_VerseID_Range CHECK  (([VerseID]>=(1) AND [VerseID]<=(176)))
will set the range restriction.

SELECT        	TOP (1) BookID, ChapterID, VerseID, AmericanStandardBible, BibleInBasicEnglish, DarbyEnglishBible, KingJamesVersion, WebsterBible, WorldEnglishBible, YoungLiteralTranslation, ChapterIDSequence, VerseIDSequence, 
                AccordingToManyIHaveSpokenID, Testament, BookTitle, ScriptureReference, ChapterIDSequencePercent, VerseIDSequencePercent, BibleReference, BookGroup, BookAuthor
FROM            Scripture_View
ORDER BY VerseID DESC
Will say the longest verse occurs in the 19th book of the Bible, Psalms, and its 119th chapter; 597th chapter of the Bible, 16075th verse of the Bible.
The Scripture Table's KingJamesVersion Column

The author would have considered placing an index on the KingJamesVersion column, but the author found out during his research that the verses in the KingJamesVersion are not unique nor distinct, and indexes are not applicable to where like query conditions with leading wildcards.

The Scripture View's Testament Column
The SQL statement

(case when BookID <=(39) then 'Old' else 'New' end)
will set this computed column. The Testament column serves as a filter, such as, in the BibleWord.html.
The Scripture View's BookTitle Column
The SQL statement

dbo.udf_BookTitle(BookID)
It is for determining this computed column. As expected, there is a correlation between the BookID column, and its corresponding BookTitle column; it progresses from Genesis to Revelation. Because SQL does not support arrays, the author chose to write an SQL CLR C# function for determining the BookTitle when passed the BookID. Although C# supports Design by contract assertions, the author only checks BookID range validity, and returns NULL, if the argument does not fall within this range. The author could throw exceptions, but the author does not know the side effects nor the full ramifications. Instead of writing and determining the book title using C#, an alternative is to use a database table. A table with two columns, BookID and BookTitle, will store and make extractable the sixty-six books. For example, the first book of the New Testament, the 40th book, spelling is Matthew or Mathew, double tt versus (VS) single t. An improvement on the current implementation is to use soundex to
The Scripture Table's ScriptureReference Column
The SQL statement

dbo.udf_ScriptureReference(BookID, ChapterID, VerseID)
Will calculate the conjecture of the BookTitle, ChapterID, and VerseID. Since this is a computed column, therefore, the author is not able to set its Entity Integrity; if it were not the SQL statement
ALTER TABLE Bible..Scripture ADD CONSTRAINT uc_Scripture_ScriptureReference UNIQUE (ScriptureReference)
Will set its entity integrity. The distinction between raw data versus computed columns is performance and space.
The Scripture Table's ChapterIDSequence Column
When loading data, the author decides the ChapterIDSequence column, and increments it when the BookID and ChapterID, change during loading. The ChapterIDSequence ranges between 1 and 1189, starting in Genesis 1 and ending at Revelation 22. The SQL statement

SELECT BookID, ChapterID FROM Bible..Scripture GROUP BY BookID, ChapterID ORDER BY BookID, ChapterID
will decide the greatest value for ChapterIDSequence. An alternative SQL statement

select count(
distinct
	cast(BookID as varchar(6))
	+ ' '
	+ cast(ChapterID as varchar(6))
)
FROM	Bible..Scripture
Another SQL statement

; with cte
(
	  BookID
	, ChapterID
)
as
(
	select distinct BookID, ChapterID
	FROM	Bible..Scripture
)
select cnt = count(*)
from   cte
The SQL statement

ALTER TABLE Bible..Scripture ADD CONSTRAINT CK_Scripture_ChapterIDSequence_Range CHECK (ChapterIDSequence BETWEEN 1 AND 1189)
will check the range correctness. Although it is good to know the ChapterIDSequence, but it is primarily used to decide the boundaries for scripture reference queries.
The Scripture Table's VerseIDSequence Column
When loading data, the author calculates the VerseIDSequence column, and increments it, every time, the BookID, ChapterID, and VerseID changes during the data load. There are some Bible books that have only one chapter, such as, Obadiah, Philemon, 2 John, 3 John, Jude; therefore, the author is careful when the choice is made to increment and update the VerseIDSequence column. The SQL statement

SELECT BookTitle FROM Bible..Scripture GROUP BY BookID, BookTitle HAVING MAX(ChapterID) = 1 ORDER BY BookID
is for listing these one chapter, Bible books. The VerseIDSequence ranges between 1 and 31102; starting from Genesis 1:1, and ending at Revelation 22:21. The SQL statement

SELECT COUNT(*) FROM Bible..Scripture
will decide the greatest value for VerseIDSequence, the total number of rows, records, in the Bible..Scripture table. The SQL statement

ALTER TABLE Bible..Scripture ADD CONSTRAINT  CK_Scripture_VerseIDSequence_Range CHECK (VerseIDSequence BETWEEN 1 AND 31102)
will do the data integrity. As said earlier, although it is good to know the VerseIDSequence, but it is primarily used to decide the boundaries for scripture reference queries. The identity functionality which auto-increments, before inserting each row is useful, for ensuring this candidate primary key, abides by the entity integrity constraint; however, The SQL statement

ALTER TABLE Bible..Scripture
ADD CONSTRAINT AK_Scripture_VerseIDSequence UNIQUE (VerseIDSequence)   
is supplementary.
The Scripture_View BibleReference Column
The SQL statement

((right('00'+CONVERT([varchar](2),[BookID],(0)),(2))+right('000'+CONVERT([varchar](3),[ChapterID],(0)),(3)))+right('000'+CONVERT([varchar](3),[VerseID],(0)),(3)))
will combine the BookID, ChapterID, and VerseID. This is a convention for referring to Bible rows, by a unique identifier, which consists of the BookID, ChapterID, and VerseID. The leading zeros are placeholders for blocks of IDs, such as, BookID which will have two digits, ChapterID which will have three digits, and VerseID which will also have three digits. It is easier, faster, and more compact to restrict and order by numbers rather than text. Listed below, is the result set, for this SQL statement.

SELECT ScriptureReference, BibleReference
FROM Bible..Scripture_View
WHERE BookID = 43 AND ChapterID = 1 AND VerseID = 1
ScriptureReferenceBibleReference
John 1:143001001

There is a conversion page BibleReference.html. Please note, that the author has not developed this further, it is just an introduction and speculation, which others may wish to adopt.

Most of the applications, extract information, and query the Scripture table. If the user chooses to, he may choose to load another Bible version, into the Scripture table and the application will still work as usual, and there will be no need to make changes to the application; thereby, achieving Separation of concerns (SoC).

The Exact Table

The Exact table's, primary task, is to tell, on the words that are in the Bible. Its information set include each word's first and last scripture reference occurrence(s), and count of occurrence(s). If the word, occurs only once, then the last occurrence is set to null. The incentive for writing the exact module comes from Dave Hunt, who will talk of each word's specifics, and Chuck Missler who noted that the first occurrence of the word, love is in Genesis 22:2. The exact table, is a holding area, for staging information; it could be argued that there is no need, to have this table, because it sources its information from the Scripture table, and it is available using Language Integrated Query. The reasoning of the author is that the Scripture table is static data, and it does not need processing, each time, there is a request. Speed and lower work load are the advantages of the approach of the author; its disadvantage is that the exact table needs re-population, when there is a shift to another Bible version, which the author does not project, at this time. If there is a need, to support another Bible version, then the Exact table loading procedure needs expansion to aid, this flexibility. Word Occurrences is dynamic, and it supports the other versions of the Bible.

The Exact result for the author's initials, KAA, is Karkaa, meaning floor (Joshua 15:3).

The Exact Table's ExactID Column
The ExactID is an identity column, meaning the database, SQL Server, auto-increments its value, before insertion. There are 12891 unique words, in the Bible..Exact table. The SQL statement

SELECT MAX(ExactID) FROM Bible..Exact
is for determining the highest value. The SQL statement

SELECT COUNT(BibleWord) FROM Bible..Exact
is for determining the word count. The SQL statement

ALTER TABLE Bible..Exact ADD CONSTRAINT  CK_Exact_ExactID_Range CHECK (ExactID BETWEEN 1 AND 12891)
is for the range restriction. For storage reason, the author has chosen, not to have a unique index, on this candidate primary key; in-spite, of it being a query item. Future implementation, may issue the SQL statement

CREATE UNIQUE INDEX AK_Exact_ExactID ON Bible..Exact(ExactID)

SELECT SUM(FrequencyOfOccurrence) FROM Bible..Exact
is 789631; this is the count of the words in the KJV Bible.
The Exact Table's BibleWord Column
These are the words that occur in the Bible, in the order of their occurrences. The author sets the primary key, the constraint, by issuing the SQL statement

ALTER TABLE dbo.Exact ADD CONSTRAINT PK_Exact PRIMARY KEY CLUSTERED (BibleWord ASC)
The Exact Table's FirstOccurrenceScriptureReference Column
This is the scripture reference where the word first occurs in the Bible. The author may set-up the relationship by issuing the SQL statement

ALTER TABLE dbo.Exact WITH CHECK ADD CONSTRAINT FK_Exact_Scripture
FOREIGN KEY(FirstOccurrenceScriptureReference)
REFERENCES dbo.Scripture (ScriptureReference)
Please note, that as discussed earlier, the author cannot have, a unique constraint, on the Bible..Scripture.ScriptureReference column, since this is a computed column; the author can not keep up the relationship, at this time.
The Exact Table's LastOccurrenceScriptureReference Column

This is the reference to the scripture where the word last occurs in the Bible; if there is only one occurrence, the value of this entry is null. As with the FirstOccurrence column, the referential integrity rule applies.

The Exact Table's Difference Column

This is to measure the word's longevity; the difference in VerseIDSequence between when it first and last appeared.

The Exact Table's Occurrence Column

This is the pervasiveness of the word, how often is the word used in the Bible?

The WordEngineering Database

The WordEngineering SQL Server database, mainly consists, of four tables - HisWord, Remember, APass, ActToGod.

The HisWord Table

The HisWord table is what the author heard from the source. The entries in the HisWord table are exact and representable in alphanumeric format (Numbers 12:6-8). In following, the Bible's New Testament convention, where there are translations of Hebrew words to English which is being interpreted, (Matthew 1:23, Mark 5:41, Mark 15:22, Mark 15:34, John 1:38, John 1:41, Acts 4:36); so also, there are translations of Yoruba words to English.

There have been cases when the author cannot spell and fully comprehend what he heard. In such cases, and not dispose of the records, the author will partly enter what he heard. This impedance mismatch between what the speaker said and what the listener heard, rarely occurs with English words. But it is likely, in the author's native language, Yoruba, which exploits word combinations and phrases. The alphabets differ slightly between the English and Yoruba languages; Yoruba contains diacritic alphabets. The author requires a Yoruba dictionary and translator; a recent success is with the http://translate.google.com web page.

The HisWord table's most important column, as the name suggests, is the word column, which is either English or Yoruba; or a mixture of both languages. The author will yield to the Holy Spirit in translating Yoruba words to English. From previous experience, this translation is not always the most right or relevant, and different words may contain the diacritic alphabets; therefore, introduce various meanings (1 Corinthians 12:30, 1 Corinthians 14). To account for the discrepancy in translation, the author sought help from the LORD:
  1. 2015-11-02T22:55:00 And, the merge, is the money, convert.
  2. 2015-11-03T02:17:00 The specifics, a language.

The word column is a potential natural primary key, since duplicates are rare. When redundancies do occur, we may append the sequence to the word, to generate a unique word. We do this manually, but an insert trigger, will offer automation, and will cut the risk of primary key violation, which leads to gaps in the identity column and, loss of data.

The HisWord's table, commentary column, contains implicit information. This communication is most likely non-verbal, and it is information such as creatures standing or moving towards particular locations or engaging in other visible activities.

As such, from the creation account, on the first day, there is a commandment, and there may be an action/response. The commandment is in the word column God created light ( Genesis 1:3, 5 ). The action is in the commentary column; God separated the light from the darkness (Genesis 1:1-2, 4).

Microsoft SQL Server generates sequential numbers for the HisWordID identity column. The goodness of this technique is that it is a candidate primary key, data loss is trackable, and it provides a sort key. The HisWordID column may serve as the primary and/or foreign key, the backbone of the Referential Integrity Constraint.

The Dated column is of the DateTime type. If an insert statement does not explicitly specify a value for the dated column, then it defaults to the current date and time of the (UTC-08:00) Pacific Time (US & Canada) time zone. There is a preference for the Coordinated Universal Time (UTC) format.

A relational constraint limit to a single foreign key? The author will choose either the most vivid or rare?

HisWord_view

The HisWord_view composes of the computed columns deducted from analyzing the Word. The two most significant computations are the AlphabetSequenceIndex, and the reliant AlphabetSequenceIndexScriptureReference, respectively. The author derives the AlphabetSequenceIndex from the word by adding the place of the alphabets in the alphabet set. In the ASCII table, the lower case alphabets are between 97 and 122, and the upper case alphabets are between 65 and 90. The lower and upper case alphabets have the same places. The AlphabetSequenceIndexScriptureReference is the books, chapters, verses separation in the scripture. The author will consider the chapter and verse place, forward and backward. Use the AlphabetSequence.html to calculate the computed values identified above. The AlphabetSequence is like Gematria, Mispar Hechrachi method. Titles of God.

The Remember Table

The Remember table tries to correlate the period between a prophecy and its fulfillment. The terminus a quo DatedFrom is when the prophecy begins, and it marks the the date of issue or establishing of the prophecy. The terminus ad quem DatedUntil is when a prophecy partially or entirely comes to pass. (Koinonia House). DateDifference.aspx is for calculating the difference between terminus a quo, versus terminus ad quem; the results are in days; biblical years, months, days; the Common Era. The inspiration for adding the Common Era comes from wikipedia.org by Jimmy Wales.

To determine the HisWord and Remember entries? The author chooses to separate the particular and prompted inputs ( Luke 4:19 ).

APass

First, inside and last dates.

ActToGod

This is subjective work; the author applys intelligence to find patterns and resemblances in the Bible.

List of resources
Name Universal Resource Link (URL) Commentary
github.com/KenAdeniji github.com/KenAdeniji Source control. http://kenadeniji.github.io/Github GitHub date joined?
Microsoft SQL Server http://en.wikipedia.org/wiki/Microsoft_SQL_Server The author has been using relational databases since 1988.
Microsoft Visual Studio http://en.wikipedia.org/wiki/Visual_Studio The author transitioned from using the Microsoft Visual Studio integrated development environment (IDE), because the command-line Microsoft Visual C# Compiler, csc.exe, suffices, and incompatibility software source files between versions during migrations. This same... could be noticed between HTML versions... prior to HTML5. These are our children... these are us.
Microsoft Windows Operating Systems http://en.wikipedia.org/wiki/Microsoft_Windows The author has been using Microsoft Disk Operating System (DOS) since 1984.
Notepad++ text and source code editor by Don Ho http://en.wikipedia.org/wiki/Notepad%2B%2B The author transitioned from using Notepad, because of tabbed editing, and formatting code.
W3 Nu Html Checker validator.w3.org/nu
www.JesusInTheLamb.com www.JesusInTheLamb.com Domain name for the website of the author. Alternative kenadeniji.wordpress.com
google.com
  • Jobs near me. I found out about this keyword through Google Suggest.
  • King James Version (KJV). I found out about this keyword through Google Suggest.
  • Drawing code as house. Sergey Brin and I were inside a classroom. Sergey Brin sat to the right, east, at the back, and I sat to the left, west. Sergey Brin was writing code, drawing a house. I asked Sergey Brin what a billionaire was doing writing code to draw a house? I went to the north-east, prostrated, and talked to an African descent male. There were children in the middle center of the room extending eastward. Rockridge station 5660 College Avenue, Oakland, California (CA) 94618.
  • At the intersection of Siward Drive and Creekwood Drive, south-east house. 4820 Siward Drive, Fremont, California (CA) 94555.
    It is not God works... it is does He work with your circumstances?
    Scene 1: On Siward Drive I was walking eastward, and at the intersection of Siward Drive and Creekwood Drive, south-east house. 4820 Siward Drive, Fremont, California (CA) 94555. I saw 2 males who were standing beside cars. I approached them believing they were Germans, but they turned out to be Hindi. Scene 2: My twin sibling and I went out to eat fish at an Asian restaurant. When we were about to depart, the restaurant's male workers to the north mixed up our take-away food order, 10:30 label identifiers (Genesis 37:9-11). Scene 3: I thought of Sergei Brin when I was with some Asian males, to the east, inside a Sport Utility Vehicle (SUV) with a vehicle license plate with a label like Tirut or Tarut. The Jews could kill me as their preservation or solution. Interpret: Hindi make-up 1/5th of the world population... attrition due to unbelief.
    At the intersection of Siward Drive and Creekwood Drive, south-east house. 4820 Siward Drive, Fremont, California (CA) 94555.
    Who is relevant... as a occasion?
    At Charter Square, Albertsons Lucky, and Dulhan Grocery. The focus has been... HR children.
Scales & Measurements
Type of Scale Commentary Example of Scale
Nominal Scales The numbers may serve as tags or labels which are quantitative with no values.
  • Introduced on July 1, 1963, the ZIP Code system (an acronym for Zone Improvement Plan) traditionally contained five digits. In 1983, an extended code was introduced named ZIP+4, these postfix a hyphen and four additional digits for more specific addressing. The author does not validate the Zip Code, since it is not a world standard. Our view of the world attains us.
  • Telephone number
Categorical Scales Dewey Decimal Classification used in libraries
Absolute Scales An absolute scale is a count of individual, distinct items in the set.
  • This may be the physical count of word occurrences in the Bible.
  • The count of books that are in the Bible groups. For example, there are 5 books by Moses, and 4 Gospel books.
  • The SQL COUNT() function returns the number of rows that matches a specified criterion.
  • The Microsoft SQL Server variable @@ROWCOUNT returns the affected rows from any statement, even if it's not DML or a SELECT query.
Ordinal Scales An ordinal scale puts the attribute in a linear order. There are no operations or computations done with it.
  • In an ordered list HTML element, the list items are sequentially arranged.
  • An identity column is a numeric column in a table that is automatically populated with an integer value each time a row is inserted.
  • The SQL ROW_NUMBER() function is a temporary value calculated when the query is run. To persist numbers in a table, see IDENTITY Property and SEQUENCE.
  • The @counter-style CSS at-rule lets you extend predefined list styles and define your own counter styles that are not part of the predefined set of styles. The @counter-style rule contains descriptors defining how the counter value is converted into a string representation.
Rank Scales They have a linear ordering, and an origin. Having an origin prevent some of the transitivity problems.
  • Military ranks
  • Mohs scale for hardness (geology) of minerals
  • Scofield scale for the strength of peppers
  • Completely Automated Public Turing Test to tell Computers and Humans Apart (CAPTCHA) is a type of challenge–response turing test used in computing to determine whether the user is human in order to deter bot attacks and spam.
The Contact table contains a title column. SQL offers a group by, and having clause. Strength of password? Soundex?
Interval Scales An interval scale is based on a standardized unit or interval. Another property of these scales is that they have no natural origin. Date difference, UNIX epoch?
Ratio Scales These scales have a base unit, natural origin and meaningful operations. We also allow the creation of compound units with ratio and interval scales. They are called ratio scales because the units of measure are expressed as multiples or fractions of some base unit.
  • HTML input range
  • CSS percentage
(Joe Celko, 2025-03-07).

Relational Database Hierarchy

  1. Catalog: Is a collection of databases, for example, Bible, WordEngineering, URI.
  2. Schema: Is a collection of objects, which may include tables, views, indexes, stored procedures, triggers.
  3. Table: Is 2-dimensional with horizontal rows and vertical columns.
  4. Column: It is a physical actualized attribute.
Functional Dependencies
Determinant Functionally Dependent Implementation
Bible.Scripture.BookID Bible.Scripture_View.BookTitle Bible.udf_BibleBookIDTitle()
Bible.Scripture.BookID, Bible.Scripture.ChapterID, Bible.Scripture.VerseID Bible.Scripture_View.ScriptureReference Bible.udf_ScriptureReference()
Determination is achieved through computed columns.
(Allen G. Taylor, 2024).

Index Query Type

Query Type Commentary Example Structured Query Language (SQL)
Point query It will return only 1 record, and it is restricted by an equality condition on the primary key or unique index. Useful for searching for a particular verse.
	SELECT *
	FROM Bible..Scripture_View
	WHERE VerseIDSequence = 1
	
Multipoint query It may return more than 1 record, as there may be multiple records. It is restricted by an equality condition on part of a potential composite key. Useful for searching for a particular chapter or book.
	SELECT *
	FROM Bible..Scripture_View
	WHERE ChapterIDSequence = 1
	
Range query It returns a set of records whose values are within an interval or half interval. If it is restricted by both lower and upper bounds, then there is an interval. It is a half interval, if it specifies only one bound. Useful for searching for consecutive verses, chapters or books.
	SELECT *
	FROM Bible..Scripture_View
	WHERE VerseIDSequence BETWEEN 1 AND 10
	;
	SELECT *
	FROM Bible..Scripture_View
	WHERE VerseIDSequence <= 5
	
Prefix match query The set is the match of an attribute. The author is unfamiliar with any use-case where only the first part of the wildcard is searched. The first part of the scripture reference is similar. For the BibleWord searches, the author uses like for match queries.
SELECT *
FROM Bible..Scripture_View
WHERE KingJamesVersion LIKE
(
	SELECT TOP 1 KingJamesVersion
	FROM Bible..Scripture_View
	GROUP BY KingJamesVersion
	ORDER BY COUNT(KingJamesVersion) DESC
)
	
Extremal query It returns either the minimum or maximum extreme. Statistics
SELECT *
FROM Bible..Scripture_View
WHERE VerseIDSequence =
(
	SELECT MAX( VerseIDSequence )
	FROM Bible..Scripture_View
)
	
Ordering query The records returned are sorted. The results of the author are normally in ascending order.
SELECT TOP 10 *
FROM Bible..Scripture_View
ORDER BY VerseIDSequence DESC
	
Grouping query The records returned are grouped. Rarely does the author group rows by issuing the group by clause.
SELECT BookGroup, COUNT(BookGroup ) BookGroupVersesCount
FROM Bible..Scripture_View
GROUP BY BookGroup
ORDER BY BookGroup
	
Equi-join query The records are retrieved from multiple sources. The author uses views for table joins.
(Allen G. Taylor, 2024).

Designing Software Architectures: A Practical Approach Making Design Decisions

  1. Use Facts
  2. Check Assumptions
    • This whole thing started with keeping a work reference.
    • Even though Yoruba is the native language of the author, he still and invariably relies on translate.google.com.
    • The author depends on a typing assistant.
  3. Explore Contexts
    Information re-use was the driving force of this software engineering. The author sought to learn programming and retain knowledge.
  4. Anticipate Risks
    The undesirable outcome and their probability of re-occurrence will include:
    • Data loss or corruption because of issuing the database modification command and lack of timely archiving
    • Hardware, software, or network failure
    • Vendor withdrawal of support
      Microsoft:
      • Introduced .NET core and Model-view-controller (MVC).
      • Inability to restore deprecated Microsoft SQL Server backup versions.
      • Command-line reverse-engineering of database script does not conform with the newly released data types.
  5. Assign Priorities
    The author prefers to first build and implement his strengths and specialties in the back-end (database and process logic), prior to designing the creative user interface.
  6. Define Time Horizon
    What period has God used?
    • 1988, military census age: I Am taking you on a journey.
    • 1997, priesthood age: I have brought something against you, but I Am with you.
    • 2007, generation timespan: This masturbation will bring water.
  7. Generate Multiple Solution Options
    How versatile am I... at amending others? I have to relay my perception to technology providers.
  8. Design Around Constraints
    Relational databases offer the ability to set constraints.
    • Data type
    • Nullable
    • Primary key and unique index
    • Foreign key
  9. Weigh the Pros and Cons
    • Data import...data input: Initially, the author created an XML file and imported it into database tables via a C# program application. When this process malfunctioned, the author suspended his work. The author resumed work by doing data input via Microsoft SQL Server Management Studio grids. This diversion did not require database changes, achieving separation of concerns.
    • The use of non-supported beautifying css is responsive web design.

(Humberto Cervantes, Rick Kazman June 2, 2024).

Hitachi Modern Data Infrastructure Dynamics Drowning in Data: A Guide to Surviving the Data-Driven Decade Ahead

(Hitachi 2023).

Database Performance

(Craig Mullins, 2023-12-18)

Database Management System (DBMS)

There are 2 types of DBMS. These are:

SQL Usage

Database Information

Statement Commentary
sp_databases The sole work of the author, the WordEngineering database size, is currently 33351360 bytes.
sp_server_info The database version is Microsoft SQL Server 2025 - 17.0.1050.2
sp_spaceused The WordEngineering database currently uses 32569.69 MB.
sp_statistics HisWord The cardinality of the HisWord table is 121880.
xp_fixeddrives Returns a list of physical hard drives and the amount of free space on each one.
xp_msver Returns version information about SQL Server.

SQL Statement

Statement Commentary
Select The select statement for data retrieval is the most popular statement. Most select applies to Bible..Scripture_View. Using the select statement is safe, but it may impact performance. An alternate replication target repository may serve queries.
Insert, Update, Delete The insert, update and delete statements are for data maintenance.

Where Clause Operators

Operator Commentary
=, <>, !=, <, <=, !<, >, >= !> The operators listed will check for a single value. The operators that consist of !, will check for non-matches. In most cases, rarely is this in use. !< or/and !>. This is the first time...he is becoming aware...of these expressions. This is the first time...he is becoming aware...of these operators. Querying for a date or number will search for particular types.
BETWEEN This is a range check that accepts a beginning and ending value. It is not highly used.
NULL No value
IN A comma-delimited list of valid options within parenthesis.
LIKE Wildcard filtering
(Ben Forta, 2017)

Database Scaling

Database Exclusivity

Row Limit

Title Commentary
TOP Set a limit of the number of rows returned or a percentage of the rows from the source.
SET ROWCOUNT The database will retrieve all the rows, but if there are excessive rows it will later limit to required rows.

Where Clause

Title Commentary
Like wildcard Preceding or following restriction '%%'
Check for NULL IS NULL versus (VS) IS NOT NULL
Between range check Lower and upper limits
Logical comparison <, >, =, <=, >=, <>
Table join superceeds the previous column key equal to FROM table join primary and foreign key

Select Clause

The select clause may explictly include a column list. Pre-compiled statements that implictly cater for all the source columns, may not be up-to-date on the column-list.

Group By Clause

The group by statement is not for detail listing, except when it is used to regress to the distinct clause. Group by supports statistics, such as, count, sum, min, max, avg.

Having By Clause

The having clause augments the group by clause. It places restriction on the group(s) returned.

Insert Statement

Inserts give room to omit the default columns. The Identity Insert statement also grants explicit entry of its identity column.

Nullable Column

Information unknown is useful for forwarding processing, until and if the information is added. Outer Join stands for this purpose.

View

Enhances tables by compacting and/or extending the information set.

Constraint

Primary and foreign keys, unique indexes and check constraints.

Data Cleansing

The author prescribes the steps below to begin database set-up and usage

  1. Acquire a database management system (DBMS). Various varieties of DBMS are available. The user may download a DBMS, get a compact disc, or select from the cloud.
  2. Install a DBMS.
  3. Decide on a user interface for managing the database. For Microsoft SQL Server, the choices include the SQLCmd console utility or the SQL Server Management Studio or Azure Data Studio.
  4. Create database. Microsoft SQL Server supports multiple instances and databases.
  5. The data definition language (DDL) includes the commands to create, alter, or delete tables, views, primary and foreign keys, indexes, constraints and defaults.
  6. The data manipulation language (DML) are commands to insert, update, and delete the database rows and columns, with the option to use the where clause.
  7. The SQL Server maintenance plan is for database housekeeping, for example, backup, restore, and re-arrangement.
  8. Stored-procedures, triggers, and functions are programmable logic.

Indexing

The author manually indexes according to the following progression:
(Search engine indexing)

Structured Query Language (SQL)

Set theory

The set we will mostly deal with is the HisWord table. Is in order of occurrence.

Predicate logic

The choice of SQL Server impose? datatype limits.

(Itzik Ben-Gan, 2023-07-03).

GitHub

The Author Uses the Git Code Repository
Key Value Commentary
Universal Resource Identifier (URI) github.com/KenAdeniji This is the home page for storing the repositories.
Date Created 2013-04-27 This is the date of creating the github.com account.
Version git version 2.29.2.windows.3 The git --version command offers the release detail. The author is not sufficiently knowledgeable on tracking the version update.
Configuration Profile git config --list The commands below will set the profile: git config --global user.name "your-name" git config --global user.email "your-email"
GitHub.com WordEngineering repository clone
  1. git clone https://github.com/KenAdeniji/WordEngineering
  2. git remote -v
  3. git remote set-url origin git@github.com:KenAdeniji/WordEngineering.git
  4. git remote -v
Change Tracking git status This will decide the differences between your local copy and the version control code repository.
Add Updates git add The git add . command will add all the updates, or the user may add particular directories and files.

Accessibility

JavaScript Optimizing native JavaScript

  1. Excessive number of objects: Each web page mainly contains the minimalistic page_load() and query_submit() methods. Some web pages which use web services to retrieve information from the database also include http://github.com/KenAdeniji/WordEngineering/blob/main/IIS/WordEngineering/WordUnion/9432.js which contains 1 object for data render methods, and two dimension arrays for select options. A JSON is the result set... returned from the database.
  2. Unnecessary date manipulation: http://github.com/KenAdeniji/WordEngineering/blob/main/IIS/WordEngineering/WordUnion/9432.js does 2 types of date calculations. These are the:
  3. Excessive error checking: The author does not do error checking, preferring to catch exceptions, for example in AJAX requests. http://github.com/KenAdeniji/WordEngineering/blob/main/IIS/WordEngineering/WordUnion/9432.js
    
    fetchRender: async function
    (
    	fetchUri,
    	fetchRequest,
    	callback,
    	uiDisplay,
    	rowColumn
    )
    {
    	const PostData = {
    		method: "POST",
    		headers: {
    			"Accept": "application/json",
    			"Content-Type": "application/json; charset=utf-8"
    		},
    		dataType: "json",
    		credentials: "include"
    	}
    	PostData.body = JSON.stringify(fetchRequest);
    	try {
    		const response = await fetch
    		(
    			fetchUri,
    			PostData
    		)
    		.then(response => {
    			return response.json();
    		})
    		.then(responseJSON => {
    			var dataSet = JSON.parse(responseJSON.d);
    			callback(dataSet, uiDisplay, rowColumn);
    		})	
    		} catch (e) {
    		uiDisplay.innerHTML = e;
    	};
    }
    
(Robert C. Etheredge, 2017)

Programming

The Author Programs in the Following Tiers and Languages
Tier Language Commentary
Front-End Browser HyperText Markup Language (HTML), Javascript, Cascading Style Sheet (CSS) The front-end code may run on a desktop, laptop, or mobile telephone that offers a user interface (UI). The task is to accept the user query and to display the result. Initially, as a novice programmer, the author wrote specific code for each user request; later, the author rests on generic code which will handle multiple variety of requests. This is high-level programming, and the skill-set entry level is minimal. The author also believes that the users should not require any formal training to use his work. Customization is achievable by varying the request options, such as entry form selections, query arguments, or data attributes.
Middle-Tier Application C#, Embedded-SQL For backward compatibility, the author does not envision moving away from his legacy code investment in Microsoft. The only shift is positioning code away from database inconsistencies in back-end residency. To code, compile, debug, deploy, the experience of the author is with Microsoft Visual Studio and command-line tools.
Server-Side Backend Standard Query Language (SQL) The author most recent experience is with the Sybase and Microsoft Transact-SQL assortment. Now a days, to be compatible and after experimentation; the author rarely uses Standard Query Language - Common Language Runtime (SQL-CLR). The author does database data entry, maintenance, development by using the Microsoft SQL Server Management Studio.

JavaScript Basics: Data Types

Functions and Methods

Conditions

Arrays and Loops

HyperText Markup Language (HTML) Document

(Microsoft)

Data Science

What is data?

The data that the author fundamentally operates on is the word from God. The initial and primary data is textual, but now the author places importance on dates and numbers.

What should you do with a number? Even though the Hebrew language is AlphaNumeric, the numbers in the Bible are in words ( Leviticus 19:26 ). When the author receives a number, he records it in the HisWord's table, Word column, as a numeral.

  1. The author extracts knowledge from data; by finding meaning to the word.
  2. The author uses scientific methods, such as counting the number of occurrences, determining the first and last occurrences, and excluding the parts of speech.
  3. The actionable insights take, so far, is to computerize the work.
  4. The vast majority of the work is structured data. Unstructured data does not fit into the background of the author.
  5. The application domain is Bible studies; how relevant is the Bible to our work?

Practicing Data Science

  1. Empirical, find implication from the Bible?
  2. Theoretical, to determine a better way to doing work?
  3. Computational, is human labor replaceable?
  4. Data-Driven, constraints help us to sanitize data. Default values reduces task, are less error prone, brings arrangement.

Where to get Data

  1. The Bible is our primary source of data.
  2. The author records information sources. This is either a person or media?

What you can do with Data

  1. Data Acquisition: The Bible is available on the Microsoft Access database.
  2. Data Storage: The author imports this tabular data into the Microsoft SQL Server relational database.
  3. Data Processing: The SQL Select statement is the means of retrieving data from the database. This is not always a monolithic fashion; since there are various ways of composing the queries.
  4. Visualization / Human Insights:
    • The raw data is viewable on the Microsoft SQL Server Management Studio.
    • The web service, .asmx, file, which is accessible from the browser, offers the opportunity to fill-in the query and see the JSON result.
    • The .html presents the result in a human readable format.

Defining Data

  1. Quantitative Data: This makes itself subjective to numeric computation. AlphabetSequence is an attempt to give value to words.
  2. Qualitative Data: These are rarely measurable and are personal interpretation.

A brief introduction to Statistics and Probability

At the beginning of the study, the author made a presumption that words are unique. Later the author found out that there are duplicate Bible verses.

(Microsoft)

Data

Structured and Unstructured

Structured data is alphanumeric put in row-column. Unstructured data is either text, image, audio, or video. This research is mainly structured data.

Standard

The author imports complete, not NULL nor empty data, such as the Bible and the dictionaries.

The author achieves data validity by constraining and restricting inputs. Since this is not a commercial work, Key Performance Indicators (KPIs) are not vital.

The author references and is not tampering with authoritative Bible work; this helps to make sure correctness - accuracy, consistency, integrity.

Timeliness is effectual in the single user data entry table, HisWord.

Unified Modeling Language (UML)

Class

The information which the author documents in this section of the paper; is the Data Declaration Language (DDL) and Data Dictionary, which is available at GitHub.com SQLServerDataDefinitionLanguageDDL Repository The Data Manipulation Language (DML) is too large to fit into the GitHub.com repository, and it is intellectual property. For the people that have access to the database, this private information is available by generating the database script.

Contact is a primary entity, and it identifies the people and organizations that the author has a relationship with. These affiliations are family, friends, business, or public service links. Also recordable are their street, e-mail, web addresses, and telephone numbers. The author stores the various information exchanges with these people. A known date of birth, is for notification of the subject's birthday and relative age. To keep up with the privacy and sensitivity of this personal information, the author is not sharing this highly confidential data.

The relationship between a contact and its related information is one-to-many; that is a contact may have multiple addresses. The other 2 types of relationships are one-to-one, and many-to-many.

A URI is a link to a web resource that will add to the audience's knowledge. The author notes the address and the date, when the author became aware of this information. The content at an address is either textual, audio, video, or image? For URIs, the author rarely explicitly specifies the entire http protocol and directory post-fix, /. An incomplete address will not validate as an input url type. The author only records the Wikipedia address' at the place of reference since it is easy to associate the title with the Wikipedia address.

Exists or does not exists? The transact-sql exists clause is useful for checking the existence of an object and if so, drop the object. This is applicable prior to re-creating the object. Please note that the metadata information is lost and the create or alter statement supercedes this approach. The exists clause is also useful in queries for determining the existence of a resultset.

These classes are important asset for the anniversary triggers; in the Remember entries.

Database and Application Server Source Files

The author chose a multi-tier architecture for building the application. The database layer is made-up of tables, views, stored procedures, functions. The database tables are easily storable and movable to other storage media. The SQL Server's data definition language (DDL), now supports DateTime2, and its date range extend between January 1, 1 CE through December 31, 9999 CE. Some dates in Wikipedia mention these dates. The HisWord_view contains computed columns, which depend on entries in the HisWord table. The author extracts database information by building query statements.
The application layer is the bridge between the user interface layer and the database layer. The application layer compiles into a single Dynamic-link library (DLL), called InformationInTransit.dll. The application layer consists of four namespaces, namely, InformationInTransit.DataAccess, InformationInTransit.ProcessCode, InformationInTransit.ProcessLogic, InformationInTransit.UserInterface. What the author builds on the server; is accessible to all the clients. What is the lifetime of this code, and what neutrality does it condone? The author started out with dBASE II. The lines of code for the application layer are in the C# and embedded SQL.

Client Browser Source Files

The .HTML files will work in all browsers; that support AJAX. Most of the interactive web pages are reliant on JavaScript to work, mainly because they use Ajax to interact with the server. Each .HTML file, performs specific task, and may have a corresponding back-end associate, web service. The unobtrusive JavaScript file 9432.js contains re-usable code that is not .HTML files specific. The .HTML files originally contained the .CSS specifications; however, the author now places styling information in a single external file, 9432.css. This will reduce the sizes of the .HTML files, and it helps to achieve a consistent user interface.

The work of the author is interactive, and there are links to questions and answers pages. Most of the input entries are textual, but some are numeric, datetime, select options. The answers are mostly in tabular format.

(Vaibhav Verdhan).
A HTML document contains:
(Elizabeth Castro).

Cascading Style Sheets (CSS)

(Jonathan Snook).

Web Services

There is standardization on the first .NET web services architecture, .ASMX.
(FrederikBulthoff, 2019) In most cases, there is a one-to-one mapping between the .HTML, .ASMX, .CS files, and the database relational table, Bible..Scripture. For simplicity and clearage of use, the .HTML and .ASMX files, support one operation. GetAPage.html is the workhorse for word utterances. GetAPage.html will send AJAX requests to multiple .ASMX files and operations. GetAPage.html is a cumulation of separate .HTML files. All the web services files support the SOAP request format and return JSON. jQuery accepts the POST, HTTP verb. The author stringified the data he passes to the web service in the body of the message. Errors are unforeseen, in the rare case, the author logs errors on the back-end, and display quantitative message. Security is lacking; this is permissible; since the author only queries information.

The web service code, .asmx, file is not necessary, does not have a place, when there is no server database access ( Numbers 19:2, 2 Chronicles 15:3, John 15:25, Romans 2:12, Romans 3:21, Romans 3:28, Romans 7:8, Romans 7:9, 1 Corinthians 9:21, Hebrews 9:22 ).

The Web Service Description Language (WSDL) is available, for example, by specifying the URI, AlphabetSequenceWebService.asmx?WSDL To generate a proxy code, issue the following command; wsdl.exe /language:CS /namespace:InformationInTransit.ProcessLogic /out:"AlphabetSequenceWebServiceProxy.cs" http://localhost/WordEngineering/WordUnion/AlphabetSequenceWebService.asmx?WSDL The Web Services Discovery Utility (disco) command: disco.exe "http://e-comfort.ephraimtech.com/WordEngineering/WordUnion/AlphabetSequenceWebService.disco" will generate the companion files; AlphabetSequenceWebService.disco, AlphabetSequenceWebService.wsdl, and results.discomap

A lecture of our beginning. (Hafida Na ̈ım, 2016) The business rule is storable and processable in C#, (.cs), source files. The dynamic link library, (.dll), is callable from everywhere. GetAPage.html computes AlphabetSequence from a simple logic, which is easily representable everywhere. The AlphabetSequenceIndexScriptureReference is retrievable from the Bible, using non-complex SQL query. The BibleWord and HisWord reference, requires substantive query. The Bible dictionary returns dataset from the local database. The author can not make a business decision, to go to a web service, to retrieve what is locally resideable.

Database Size

The usp_DatabaseLogSize stored procedure is for determining the size of the databases data files; and it is available at T-SQL to find Data,Log,Size and Other Useful information -SQL 2000/2005/2008/R2.

Database Size
Name Data Files Data MB Log Files Log MB Total Size MB
Bible 5 304 1 82 386
BibleDictionary 5 38 1 17 55
WordEngineering 5 138 1 1816 1954

Database Standard

Database Design

  1. The relational model is for storing information in tables.
  2. The author normalizes data using Object-relational mapping.
  3. All the databases are OLTP (Online Transactional Processing), not OLAP (Online analytical processing).
  4. Avoid deadlock occurrences by not permitting user database updates.
  5. All the transactions follow similar routes and sequences, and the author practices granularity with the locks.
  6. Database updates are through stored procedures, which recognize and avoid the potential of integrity violation.

Database Security

  1. The secretive web.config file contains the database access information.
  2. The web.config file does not explicitly mention the user login name nor password.
  3. Give access rights to roles, not to specific login identities nor user names.

Database Data Types

  1. Choose matching data types between the database and application layers.
  2. Only pick varchar(max) and nvarchar(max) as the data type, when it is essential to store large data.
  3. Prefer the decimal type; when recording the amount in currency rather than using the float type.

Nullable Type

  1. Consider defaulting textual data to empty string; instead of NULL.

Indexes

  1. Database changes lags with indexes.
  2. The field sequence in indexes should follow the frequency of usage.
  3. When using a composite index, place a clustered non-unique index on the major column.

Naming Conventions

  1. Overall, consistency encourages lowercase keywords. Keywords in lowercase are mandatory in case-sensitive programming languages like C# and JavaScript, but not in SQL.
  2. Use Pascal casing for naming literals, such as, tables, columns, stored procedures and functions.
  3. Use Camel casing for naming parameters and local variables.
(ABB Asea Brown Boveri)

Performance

The web page components practice of the author, include:
  1. Keep the count of web page components to a minimum
  2. Specialize input entries by using the most simple and basic component
  3. Reduce bloating by limiting the use of framework and library
(Stoyan Stefanov)

Performance Suggestion

  1. The most consistent id="resultSet" is usually for AJAX. The self-descriptive tags that do not influence the result normally do not specify IDs, this is left to the browser's decision.
  2. Browsers place restrictions on the number of concurrent connections to a particular domain and the overall parallel connections. Consider spreading out the resources to multiple domains.
  3. The author standardized on the .png image format because there are few colors.
  4. In the year 2008, when the author tried to move away from html table layout styling, the rendering was anaemic.
The Cascading Style Sheets (CSS) performance suggestions include:
  1. Since, by default, CSS is a render-blocking resource, the author should take advantage of the critical rendering path with media types and media queries.
  2. All the programming .html files refer to the common 9432.css file, except this ubiquitous 2015-10-23DoctoralDissertation.html documentation file which includes css.
The JavaScript performance suggestions include:
  1. Make use of browser cacheable content delivery networks (CDNs). For example, http://code.jquery.com/jquery-latest.js
(Lara Callender Hogan)

High Performance Browser Networking

For Internet connections, the contributing factors include:
  1. Propagation delay - The consideration is the speed of light in the medium of transport. On the Internet the speed varies according to the medium which may be (DSL, cable, fiber) in order of performance. The speed of light, which was presumably constant, but now, may be declining. The author chooses the most accessible route. Typically, working within the confines of a building. This research excludes other participants. The environment is transplantable for other uses. The route and environment impose limitations on the local host. The traceroute command on the Linux operating system, or the similar tracert or pathping commands on the Windows operating system, will give travel speed. The author will look into the last-mile tendencies of the Internet Service Providers (ISP) in the area. The receive window (rwnd) of the server should be adequate, since the users do not upload videos nor images.
  2. Transmission delay - The time to input the packet into the link, which is determined by the length of the packet and the data rate of the link. On the author's behalf, the Bible book ID is transmitted to the client and convertible to the title by JavaScript. Formatting is done by the client.
  3. Processing delay - The duration of processing the header, detect bit-level errors, and determine the other end. In an Intranet environment, this is done locally.
  4. Queuing delay - The processing wait time is dependent on the browser supporting multiple page tabs, and other applicatons using the network?
Most of the work of the author is available at the following locations, in the order of accessibility:
  1. The current web page, such as, 2015-10-23DoctoralDissertation.html file
  2. The general Cascading Style Sheet, 9432.css file
  3. The general JavaScript file, 9432.js file
  4. The specific Web Service file, such as, ScriptureReferenceWebService.asmx file
  5. The dynamic link library file, InformationInTransit.dll file
  6. The database
The reason for noting this observation is that the Domain Name System (DNS) lookup time is low; since the author uses relative directory addressing as much as possible and only uses root addressing for calling web services. The .html and .asmx files are in numerous directories, because GitHub.com directories have content count limitations.
Images:
  1. The author does not use background-image nor list-style-image
  2. The thesis only contains images for database and object modeling
  3. The author does not use CSS sprite; since it requires additional storage space
  4. The author does not use Data URIs
  5. The author does not support nor take advantage of Expires Headers
  6. This research excludes compression and minification; because the file sizes are low and technology conformity
(Ilya Grigorik)
Web Performance 101 JavaScript:
  1. The author will not consider minification. Because he cannot justify compressed file duplicate mix-up. A single compressed file is less readable and maintainable. An automated build and deployment process may suffice.
  2. DOM chatiness? The author currently builds the entire table, and he sets the innerhtml of the div. For faster visibility, the author may build a table by first setting its header, and appending rows.
  3. The author should take advantage of the async script parameter. Because the actions of the scripts are invoked after the page load.
  4. Code splitting with import serves well for web components and rare tasks.
Web Performance 101 Cascading Style Sheets (CSS):
  1. Critical CSS is in the style sections of HTML files.
Web Performance 101 content delivery network (CDN):
  1. The author is deprecating the use of the jquery library which was solely used for AJAX, in preference to the fetch statement. This removes single point of failure (SPOF).
  2. The author only uses the latest version and a unique uri for each library available on CDN.
(Ivan Akulov)

Code Statistics

Al Danial's Cloc

				  36 text files.
				classified 36 files
				  36 unique files.                              
				   0 files ignored.

				github.com/AlDanial/cloc v 1.84  T=1.00 s (36.0 files/s, 2947.0 lines/s)
				-------------------------------------------------------------------------------
				Language                     files          blank        comment           code
				-------------------------------------------------------------------------------
				C#                              36            300            362           2285
				-------------------------------------------------------------------------------
				SUM:                            36            300            362           2285
				-------------------------------------------------------------------------------
				 414 text files.
				classified 414 files
				Duplicate file check 414 files (398 known unique)
				Unique:      100 files                                          
				Unique:      200 files                                          
				Unique:      300 files                                          
				 414 unique files.                              
				Counting:  100
				Counting:  200
				Counting:  300
				Counting:  400
				   2 files ignored.

				github.com/AlDanial/cloc v 1.84  T=5.00 s (82.8 files/s, 10288.0 lines/s)
				-------------------------------------------------------------------------------
				Language                     files          blank        comment           code
				-------------------------------------------------------------------------------
				C#                             414           5858           5760          39822
				-------------------------------------------------------------------------------
				SUM:                           414           5858           5760          39822
				-------------------------------------------------------------------------------
				   1 text file.
				   1 unique file.                              
				   0 files ignored.

				github.com/AlDanial/cloc v 1.84  T=0.50 s (2.0 files/s, 3372.0 lines/s)
				-------------------------------------------------------------------------------
				Language                     files          blank        comment           code
				-------------------------------------------------------------------------------
				JavaScript                       1            220            189           1277
				-------------------------------------------------------------------------------		
			

Backup and Off-site Storage

The author archives the database and source files to the local computers, Google, Microsoft drives, after changes. The author uses GitHub.com version control.

Development Time

The development time is separable into the time it takes to program, compile, test, deploy. The stored procedure, C#, ASMX, HTML files are build-able in one day, in most use-case.

Reproducible

The deliverable of the author is transferable to other environments to reach similar conclusions.

Database Deployment

The author suggests the following alternative methods for deploying the databases:
  1. Restore
  2. Attach
  3. Snapshot
  4. SQL Server Data Definition Language (DDL)

Surrogate Keys

The author takes advantage of potential natural primary keys; otherwise, the author uses surrogate keys. A surrogate key may be an identity or GUID type column. URIs are examples of natural primary keys.
(Joseph Sack, 2008)

Application Programming Interface (API)

  • The common url scheme, endpoint, that the author prefers for security reasons is https://e-comfort.ephraimtech.com/WordEngineering
  • The Top Level Domain (TLD) is the same for both the website and the API, thereby allowing for sharing of cookies.
  • Content Located at the Root: The practice of the author is to place the website and their companion API files in the same directories, as they are joinable. The author will not uniquely treat API files. The author makes a case for directory browsing, and there is a special help documentation file.
  • Microsoft released ASP.NET MVC on December 10, 2007. http://stackoverflow.com/questions/41906110/designing-rest-api-endpoints-path-params-vs-query-params
  • Out of the Create, Read, Update, and Delete (CRUD) 4 operations, the API only supports the HTTP read, SQL select statement.
  • Filtering Resources: SQL offers a column list, where, top, limit, and order by clauses for matching data.
  • Body Formats: The load penalty in XML overweighs the newness of the JSON transport medium.
  • HTTP Status Codes: jQuery satisfactorily handles the success or error of an asynchronous operation.
  • Expected Body Content: Each API may currently return either a dataset, datatable, or a top level JSON object. The URI database is maintainable via a Patch request type to update a particular record's subset of fields/columns.
  • Versioning: The progress includes:
    • Migration to computed columns
    • Normalization
    • Naming Conventions, SQL for example, is generally case agnostic
(Consumer-Centric API Design)

Data Structures and Algorithm Analysis

The exact-match query is to search for a single Bible book, chapter, or verse. In the case of a verse, the top 1 clause is appropriate to efficiently return a single record. The range query is to search for information within a boundary.

The Remember table's ResultOutputFirst bit column is a rare Boolean datatype. It is for documentation purposes and it says the FromUntil period is known and it is used to determine either the FromDated or UntilDated column.

An identity column is a specialization of the integer data type, in that the database issues the next sequence. Most of the tables make use of the identity column as a surrogate primary key.

The aggregate or composite type attempts to store each particular type in its own table, when this is not optimum then normalization calls for several tables distribution joined within one view. The contact record is a single logical datatype spread to multiple physical implementations.

When the author hears a word, what does he do with it? He dates the word, he expresses it grammatically, and he finds a place for it in his memory. For a later date, the author reminds himself.

Problems, Algorithms, and Programs

Problem

When we hear the word, how do we endeavor in Him?

Function, Input, and Output

The input is the word as the only parameter. The output will find meaning in the word of God. The response of the computer is within the range of the result set.

Sets and Relations

The alphabets and words make-up the author's work. The composition of the words is indefinite.

Asymptotic Algorithm Analysis

The computer serves the author in due time. The size of the users' input, the number of users, and the complexity of their requests will weigh on the system.

This is the approximation measurement of how long it should normally take to determine the AlphabetSequenceIndex. The prediction is the length of the word multiplied by the average period taken to determine the place of each alphabet. The growth rate is that the processing time increases, as the size of the input grows. There is linear growth, since the growth rate is constant.

Best, Worst, and Average Cases

There is no variation in time for determining the AlphabetSequenceIndex and AlphabetSequenceIndexScriptureReference. The size of the word will influence AlphabetSequenceIndex, but this should not be noticeable. When parsing and retrieving scripture reference and Bible word, there may be size and time differences.

Calculating the Running Time for a Program

The author uses a for loop to calculate the AlphabetSequenceIndex.

var alphabetSequenceIndex = 0;
word = word.ToUpper();
var asciiA = 65;
for 
(
	var index = 0, lengthSize = word.length;
	index <= lengthSize;
	++index
)
{
	if (Isalpha(word[index]))
	{
		alphabetSequenceIndex += (int)word[index] - asciiA + 1;
	}
}	
				
The cost of executing the for loop is Θ(word.lengthSize)

Lists

One of the few occasions that the author uses a list is when building the Exact table. The author creates a list of words and stores this transient information in memory. The author checks the existence of each word in the list. When it is a new word, the author appends it to the bottom of the list. Otherwise, the author increments its occurrence. At the completion of parsing the words, the author stores the list in a database table. Creating the exact table is a one-time operation, and it takes a couple of hours to complete.

The author is comfortable and familiar with using datasets and datatables for work areas. The author uses JSON as a transport medium.

(Clifford A. Shaffer)

A generic grouping of concepts and their representation

Module Unit
GetAPage.html retrieveAlphabetSequence()
AlphabetSequenceWebService.asmx Query(word)
AlphabetSequence.cs ID(word)
ScriptureReference(int alphabetSequenceIndex).
DataCommand.cs DatabaseCommand()
WordEngineeringSchema.sql WordEngineering.dbo.udf_AlphabetSequenceIndexScriptureReference(ID)
(Joost Visser)

GetAPage.html Program Flow

The event handlers are the first code the system executes. These are the page load, submit click, item change events. If this is a page load event, and it is not a postback, and the query string has a word argument, then the processing of the word occurs. If this is a postback, then it is the user's data entry that the system processes. The term processing means the browser submits the word to the back-end asynchronous web services and renders each result.

International Standard ISO/IEC 25010. Systems and Software Engineering -- Systems and software Quality Requirements and Evaluation (SQuaRE) -- System and Software Quality Models. First Edition, 2011-03-01.

Software quality is demonstrable in eight characteristics: maintainability, functional suitability, performance efficiency, compatibility, usability, reliability, security, and portability.

Maintainability

Corrective Maintenance

This is error correction.

Adaptive Maintenance

Transition from building console to web applications.

Perfective Maintenance

The author now considers partial and lookback scripture references. Such as, when there is no book title, then this default to the earlier book title.

Choosing the right .NET Framework Data Providers. The author standardized on ODBC; the other choices are OLE DB, or SQLClient.

Preventive Maintenance

Servicing the system to avoid larger mishaps.

Metric Quality Profiles

Unit Size Quality Profiles
Module Unit Lines of Code
GetAPage.html retrieveAlphabetSequence() 40
AlphabetSequenceWebService.asmx Query(word) 10
AlphabetSequence.cs ID(word) 50
ScriptureReference(int alphabetSequenceIndex). 10
DataCommand.cs DatabaseCommand() 90
SQL Server WordEngineering.dbo.udf_AlphabetSequenceIndexScriptureReference(ID) 105
Sum 325

Determining the AlphabetSequence takes 325 lines of code, which starts and callbacks 40 lines of AJAX code and concludes with 200 lines of database interaction. A unit of code should not exceed 15 lines.

All the web services (.asmx) files return JSON by default; the AlphabetSequenceWebService.asmx file, Query method, returns a hand crafted JSON which has a numeric AlphabetSequenceIndex and a string AlphabetSequenceIndexScriptureReference.

Limit the number of branch points per unit to 4

The C# compiler will translate code to an intermediate language (IL). This code runs Just In Time (JIT), according to the condition clauses and operators.

In the case of dynamic SQL, re-compiling imposes cost.

The Twelve-Factor App

  1. Codebase: The WordEngineering application is storable in the GitHub.com version control with a one-to-one mapping between the codebase and the application. There are multiple but separate websites that access the InformationInTransit.dll. The author builds the InformationInTransit.dll in the developer's working directory, and deploys the InformationInTransit.dll in each production's website bin directory. The steps for storing files in GitHub.com are:
    1. git status
    2. git add
    3. git commit
    4. git push
  2. Dependencies: The web.config file identifies the .net library versions that the environment should contain. The third-party supporting libraries are in the software bundle.
  3. Config: The web.config file contains the database connection strings; web services user specific credentials. The system adminstrator at external locations may customize these information for there specific use.
  4. Backing services: These are external independent resources, such as the database, SMTP.
  5. Build, release, run: These are the stages that a code goes through. Code compilation is deferrable for scripting, as opposed to compilable languages. Ever since the advent of the Java programming language, Just-In-Time (JIT) execution has been the norm.
  6. Processes: The author's earlier applications were stand-alone console applications that are run by the .NET Framework, later examples are the ASP.NET web pages and services. These applications run in a single thread, except they share static variables. The SQL Server encompasses services which are stoppable to do data files backup.
  7. Port binding: Web servers traditionally run on port 80, and SQL Server runs on the changeable port 1433. Javascript's Node and Python's Flask run on diversified ports.
  8. Concurrency: The author isolate his applications from the particulars of the base scaling concurrency choice.
  9. Disposability: The author's take on expendable work includes the following:
    • Pure functions
    • On-demand compilation of web pages and services
    • Adjustable time-out setting for the database and web request threads
    • The .NET Framework minute work, such as, the singleton design pattern, and static method calling and variable(s) initialization
  10. Development/production parity: By first finalizing non repeatitive work, the author can now focus on specialization activities.
    • The time gap: These include placing the common work in a central environment. Superseding the waterfall methodology with the more recent process, Agile and Scrum.
    • The personnel gap: Dev/ops expertise
    • The tools gap: The author prefers the stable infrastructure to the fly-by-night trends. Testing on the multiple operating systems and the various programming languages reflects the author's wish for compatibility. Prior to advent of the Internet, communication did not support a worldwide trend; therefore, the need for distributing scaling, that is remote applications depending on the scarce resources.
  11. Logs: The author logs exceptions, that is, viewable in the Event Viewer. The author displays error messages to the user, the .NET Framework determines the detail, and the localhost address offers in-depth perculiarities.
  12. Adminstration processes: These are one-off tasks that the environment demands of the knowledge worker. The tools are available everywhere for achieving the goal. Prior to graphical user interface (GUI), these are command-line responsibilities.
(The Twelve-Factor App)

Who, what, when, where, why?

Who

The author gives credence to the information source. Whenever it is possible, the author identifies the speaker. If the source is attributable to him, the author rarely explicitly identifies himself.

What

The primary contribution of the author is the word. The author draws upon the word of God and tries to derive meaning.

When

God gives most of His information in a dream, vision or face-to-face.

How do people place date? On each day of the week ( Genesis 1-2 )? Seniority comes first ( John 1:15, John 1:27, John 1:30 ).

Where

The author refers to the physical location or scenery of participation.

Why

The endeavor of the author is to share the word.

Artificial Intelligence

Deep Learning

Utterances are storable in the Word column of the HisWord table. An expressible event is storable in the Commentary column. The information relay is the basis for more computation in the HisWord_View and Remember_View tables.

Machine Learning

Our entirety chiefly pertains to Him.

Multilayer Perceptron (MLP)

DateDifference.html is browser computation, built on JavaScript. The overall function calls particular functions for determining the days difference in the Biblical and Gregorian Calendar.

DateDifference.aspx is a server-side C# ASP.NET web form.

The Remember's table computed columns are Transact-SQL and SQL-CLR functions.

Our computation is separable to back-end and forward-end code residence; SQL-CLR provides the opportunity to have functionality callable from both parts.

Code re-use sounds good, but it is dependent on many factors.

Feature

He addressed time. Each information the author measures is a feature that the author appraises. The features are the words spoken and the events seen.

Factors of Variation

These are out of context attributes that influence the outcome. Outside the context of managing. Their influence is not determinable.

Depth of the Computational Graph

The author does ASCII code alphabet place summations. There is just not one result, but a set of alternatives; the user may select the most right. For example, AlphabetSequence, produces an index and a scripture reference. The depth in the case of AlphabetSequence is two, with the first result, index, acting as an entry to the second result, scripture reference. The index is an arithmetic calculation, addition; the second result, scripture reference, is a composition algorithm that includes determining the beginning and end span, for the chapter and verse.

Depth of the Probabilistic Modeling Graph

This checks the path to our succession, the thread between concepts. Earlier and recent entries are comparable. The earlier Bible versions serve as a resource for the later versions of the Bible.

Probability

Formerly, the HisWord's table primary key is its Word column, and in SQL Server the maximum size of a unique key is 900 bytes; therefore, the limit of its distinct entries is 900 ^ (2 ^ 8) = 900 ^ 256 = 1.932334983228891510545406872202e+756.

Degree of Belief

In GetAPage.html the author will consider the word(s) AlphabetSequenceIndex and AlphabetSequenceIndexScriptureReference. The AlphabetSequenceIndex and AlphabetSequenceIndexScriptureReference correlate. Each word is a feature, however, hidden and has a contributing influence on the result.

In the BibleWord section, the author will look at each word, in the context of the sentence, and see if it is in the Bible, as a phrase or word combination.

In the BibleDictionary section, the author will explain the meaning of each word. The degree of belief is most certain; since we display each word found in the Bible dictionaries.

Frequentist Probability

In GetAPage.html the same input will produce the same result; because the database is consistent. When the user enters a new word, this trains the system.

WordEngineering started out as the author trying to use the Bible to decipher God's word; however, to do growth, personalization, customization, appeal to more audience. Our task is to see them, say, I done ( John 19:30 ) . Specifications...is done.

Bayesian Probability

Making specific, a generalization; given one result set, can the author make a general result? Does it stand the test of a general audience? Does a sample, qualify for the total?

Random_variable

The AlphabetSequenceIndex may range between 1 and (8000 * 26), 1...208000; 8000 being the largest length of a SQL Server VARCHAR datatype column, and the count of alphabets being 26. This is a discrete set; since it is finite.

Probability Mass Functions

Each sentence will give the same result, and this value is a weighted value of the result set; please note that vowels are probably more popular than consonants, and parts of speech have different frequencies of occurrences.

(Ian Goodfellow, 2016)

Statistics Terms

Key Terms for Data Types

Continuous

The Dated column is a valid DateTime, and generally, it is ongoing, rarely does the author backdate.

Discrete

The identity columns and AlphabetSequenceIndex are integer values; that fall into a small unique set.

Categorical

The AlphabetSequenceIndexScriptureReference is of the scripture reference type, and it is a string.

Binary

The Testament column is either Old or New.

Ordinal

The identity columns are all ordinal, following an ascending order.

Key Terms for Rectangular Data

Data frame

The data storage is a relational database; other options include spreadsheet, comma separated value (CSV), eXtensible mark-up language (XML), JavaScript Object Notation (JSON) file format.

Feature

The most important predictor columns are the Word, Dated, and ContactID.

Outcome

The dependent columns include the AlphabetSequenceIndex, AlphabetSequenceIndexScriptureReference and FromUntil date difference.

Records

A row in a spreadsheet is comparable to a database table record.

(Bruce et al. 2017).

Software Engineering

Programmer's Workbench (PWB)

This technology will make all the before and current versions of the code accessible, re-viewable, and testable.
All the words that the author hears while sleeping are recordable and the author has never had any tendency to alter this utterance from the LORD. When the author is awake and he says something, out of his own volition and pre-meditation, he has massaged this information, but now he rarely does so. The words in the past and future event dates are useful for remembrance entries. As the author technically matures, he automates manual work.

The dreams are re-collect-able, and recallable ( Numbers 12:6-8 ).

I have made what I have spoken, ready

Web Design Fundamental

Business Model

The Bible fits man's perception. The author adapts to what he learns.

Project Management

The author is querying the Bible database. The first step of work is to store the Biblical text in an electronic medium. The second step of work is to create an application layer that will access this information in a non-proprietary format. The on-going work is to present as relevant today.

Information Architecture

How will this scriptural text bring new originality? What events of today, follow the text?

Page Design

What He brings to us, is a form of Him.

Content Authoring

How query means more (Isaiah 43:22)?

Linking Strategy

This is what I have done; this is what you will do. What did we understand as His part, what did we understand as our future? To reflect, My correlate. In an anchor, if there is no href attribute or its empty; then the browser should link to the default search engine as its destination and pass its innerText. Alternatively, when the user right clicks on a browser hyperlink, there may be a suggestion option for the search engine to re-direct to a specific web page or to list URIs as in a browser search. Supplementary information for a href attribute is meta-data and whois.com.

(Jakob Nielsen, 2000)

Web

We will make advancement over Tim Berners-Lee earlier idea of a unified web:
  1. Cascading Style Sheets (CSS) will offer customization of what the user views by the use of, for example, Media Queries.
  2. Single Page Application (SPA) will circumvent the unit of navigation.
  3. Uniform Resource Identifier (URI) is supportable by other means of specifying information, such as Global Positioning System (GPS) Geo-Location.
  4. Clients such as browsers store information on cookies, local and session storage.
(Jakob Nielsen, 2000).

Hypertext

The author presents this dissertation in a hypertext format. The table of content is to the left and it contains focusing anchors and internal links, to the rest of the document which is to the right. The references section contains broadening links to external documents, which are available on the web. The web applications do not contain internal links. Same Origin are for retrieving scripture reference, Bible word; Cross-Origin Resource Sharing (CORS) are for requesting information from external URIs.

(Department of Computer Science at the University of Cape Town).

Characteristic

Resilient

GetAPage The Bible is separable into parts; these are books, chapters, verses. Dividing a life, according to purpose (Matthew 1:17). 14 Biblical Generations = 14 * 40 * 360 = 201600.

DateDifference.aspx The .NET Framework, C# and SQL Server support the Common Era; the date ranges between 0001-01-01 and 9999-12-31. The date difference will display correctly for the time interval - days, Biblical Calendar, and all the dates after the introduction of the Gregorian Calendar.

Declarative

SQL, Linq, CSS are declarative languages, but JavaScript is a functional language.

Contextual

Enhancements to JavaScript, such as const and let influence hoisting. So does script literal, strict mode, class.

The C# class container model and the optional namespace alias content the author.

Cascading Style Sheets (CSS) is modular, and its rules trickle down.

Continuous

Placing the App_Offline.htm file in the virtual directory of the web application will shut-down the application, unload the application domain from the server, and stop processing any new incoming requests for the application.

A single batch file, with a single command line, builds the only .dll, InformationInTransit.dll
csc /out:InformationInTransit.dll /target:library /recurse:*.cs /reference:System.DirectoryServices.AccountManagement.dll,"bin\Debug\HtmlAgilityPack.dll","bin\Debug\iTextSharp.dll","bin\Debug\MongoDB.Bson.dll","bin\Debug\MongoDB.Driver.dll","bin\Debug\MongoDB.Driver.Core.dll","bin\Debug\Newtonsoft.Json.dll","C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\WPF\PresentationFramework.dll","bin\Debug\System.Speech.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.ConnectionInfo.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Smo.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Dmf.Adapters.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Dmf.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.DmfSqlClrWrapper.dll","C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Management.Sdk.Sfc.dll",Microsoft.VisualBasic.dll /nowarn:162,168,219,618,649 /unsafe
After testing, InformationInTransit.dll is deployable to the WordEngineering's virtual directory, bin sub-directory. This transfer is via the xcopy command or the Microsoft Windows Explorer user interface (UI).

When the content of a server-side file with an .aspx or .asmx extension changes, the ASP.NET framework automatically re-compiles for serving future requests.

jQuery by John Resig is for making Ajax calls to the server. The more recent fetch command is also useful in later cases. jQuery helps to load the latest copy of the author's JavaScript repository 9432.js; since browser caching occurs for JavaScript files for a length of time.

The single .css file 9432.css is callable at the bottom of each .html file's head node; JavaScript statements are in the last lines of the .html files. This means that the browser knows how to show the HTML elements before reaching their origination, and the browser's JavaScript engine will not reference a HTML node before the declaration of its definition.

Set a Database to Single-user Mode

		ALTER DATABASE WordEngineering
		SET SINGLE_USER
		WITH ROLLBACK IMMEDIATE;
		GO
		ALTER DATABASE WordEngineering
		SET READ_ONLY;
		GO
		ALTER DATABASE WordEngineering
		SET MULTI_USER;		
			

If the research of the author is a team effort; the additional expense, time and effort, in staged deployments, is justifiable; such as development, test, production phases.

The author will place non-Microsoft DLLs in the virtual directory bin sub-directory, and the author will refer to Microsoft DLLs in the web.config file.

The web.config is generally consistent across deployment, the only variable is the database server name, and when the application and database server exists on the same machine, the connectionStrings may use Data Source=(local);Initial Catalog=master;Integrated Security=SSPI. This means that the author will explictly specify the database, object owner, and system object name. The Application pool will take care of the security. There are no environment variables, in use, at this time. The HTML files, when calling web services, will specify the full virtual directory path, but when appending css and JavaScript files, relative directories will suffice, full path directory and filename is unnecessary and an overkill.

The author standardized on Microsoft SQL Server as the relational database of choice. There are several alternatives in the market. All database interaction goes through one access point, DataCommand.cs, only this single file needs re-work if there is a database variety change.

When running a unit of code, for the first time, it will initialize the static variables. The ScriptureReference.html will issue a unique quote-of-the-day, every day; and a random quote, every time. The author program uses the release version of jQuery, which is the most up-to-date. The web services, such as, Sefaria.org, should not need code-revisit. The code in the third-party libraries, such as, Newtonsoft.Json.dll, is consistent, and should rarely need re-deployment.

The application is mostly stateless except for the database read.

Internet Information Server (IIS) HyperText Transfer Protocol (HTTP) by default runs on port 80, like other web servers, but this is modifiable.

Using the current architecture, the author takes care of concurrency and deadlocks; because database writes rarely occur and are short, reads are tolerant.

The threads are simple and conclusive; therefore, there are small start-up and short-down periods.

There is unity between the development and production team, environment, and time frame. The same knowledge worker can write, deploy, and run code.

The author has experience, reporting web server logs, using WebTrends. The author relies on Event Viewer for logging and monitoring exceptions. The SQL Server Management Studio offers the Error Log, for viewing the database activities.

The SQL Server Maintenance Plan is for scheduling full database and transaction log backup, periodically.

To reduce database load, the author considers the selection operation - where clause, distinct and top; projection operation - specify the column list, and not use the universal *, for all columns. Rarely does the author join tables, minimizing the work and resultset, in a set-level language.

(DB2 Developer's Guide).

HTML5

Semantic Elements

The author makes heavy use of the table semantic element for rendering tabular information. The author uses the input element and specifies either the text, number or date type attribute. The author tries the canvas and video elements for proof-of-concept.

Non-Semantic Elements

The div and span elements are for rendering block and in-line information. The author uses the div as a container for the ubiquitous result set; which may contain a single or multiple tables. The span is a space for a non-block display.

Communication of God

Biblically

What did the Jews used numbers for, as mentioned in the Bible?

How are names issued Biblically?

The word is the author's file naming convention.

What did He decide to join in?
Word Scripture Reference
Levitical Priesthood Luke 1
Davidic Covenant Luke 1:32
But thou, Bethlehem Ephratah, though thou be little among the thousands of Judah, yet out of thee shall he come forth unto me that is to be ruler in Israel; whose goings forth have been from of old, from everlasting. Micah 5:2
Out of Egypt have I called my son. Hosea 11:1, Matthew 2:15
Galilee of the Gentiles Matthew 4:15
Father's house John 14:2
What is time in Him?
Word Scripture Reference
Forgiveness versus (VS) judgment Matthew 8:17, Isaiah 53:4
Fruitful versus (VS) barren 1 Samuel 2:5
Bless versus (VS) curse Genesis 12:3, Genesis 27:12, Genesis 27:29, Numbers 22:6, Numbers 22:12, Numbers 23:11, Numbers 23:25, Numbers 24:9-Numbers 24:10 , Deuteronomy 11:26, Deuteronomy 11:29, Deuteronomy 23:5, Deuteronomy 29:19, Deuteronomy 30:1, Deuteronomy 30:19, Joshua 8:34, Judges 17:2, Nehemiah 10:29, Nehemiah 13:2, Psalms 37:22, Psalms 62:4, Psalms 109:17, Psalms 109:28, Proverbs 3:33, Proverbs 11:26, Proverbs 27:14, Proverbs 30:11, Jeremiah 20:14, Zechariah 8:13, Malachi 2:2, Matthew 5:44, Luke 6:28, Romans 12:14, James 3:9
Naked versus (VS) adorned Revelation 21:2
How does He sum Himself?
Word Count Scripture Reference
What did He want of Himself? God and the Lamb Genesis 1:16, Revelation 21:23, 1 John 3:2
Sabbatical rest 7 Genesis 2:2-3
A help for Adam: Eve 2 become 1 Genesis 2:18-25
Esau and Jacob 2 nations are in your womb Genesis 25:23
10 plagues in Egypt...Passover 10th...14th day Passover Exodus 12
Temple Resurrection 46 years was Solomon's Temple in building and Jesus Christ will resurrect in 3 days John 2:20
2023-08-26T20:00:00
For the 2nd day consequetively I am wearing a green Fruit of the Loom t-shirt. Best trademark. 50% cotton. 50% polyester. Exclusive of decoration. Made in Honduras. XL/EG/TG. Black Adidas track trouser with 3 white stripes on each side.
At the intersection of Mallard Common 4750 and Woodduck Common 4740, South East. The garage door of Mahdu is opened. Probably Hindi male in dark blue shirt drives southward. You have said, everything you need to say.
On Decoy Terrace between Mallard Common and Siward Drive, South Center. I thought of Vivian Siu and her demand for me to wear better clothing. At the intersection of Decoy Terrace and Siward Drive, South East. God asked, Why? Do you like Me?
To create one for who?
Type Commentary Scripture Reference
Spirit Image...Truth John 4:24
Word Prophecy...Fulfillment John 1:1
2023-10-09T11:55:00 How-to do time? To work on time?
  1. Once data is input...it must be read? Subsequent work may include proof-reading, archiving and housekeeping.
2022-10-06T05:19:00
Where does He bring us to a place?
Word Commentary Scripture Reference
Where I have only lived in former British colonies, namely Nigeria, the United States of America (USA), and Australia. Genesis 13:14
When
  • Departure: On Sunday 1999-01-17 I flew out of Sydney.
  • Arrival: On Monday 1999-01-18 I re-located to California, Martin Luther King's day.
JAL JAPAN AIRLINES 1999-01-17 SYDNEY TOKYO 1999-01-17T10-30 1999-01-17T18:05 JL 772 M SUN KINGSFORDSMITH TERMINAL 1 NARITA TERMINAL 2 AIRCRAFT 747 NON STOP 9:35 DURATION. JAL JAPAN AIRLINES 1999-01-18 TOKYO SAN FRANCISCO 1999-01-18 1999-01-18T09:55 JL 2 M MON NARITA TERMINAL 2 INTL TERMINAL 1 AIRCRAFT 744 NON STOP 8:55 DURATION.
Genesis 17:1
How How beyond our age? Genesis 25:23
2023-10-05T10:13:00
A rest
Word Commentary Scripture Reference
Jesus Christ Son of God Hebrews 5:8
Tithes Levi Hebrews 7
2023-10-04T11:52:00
Particular use?
Word Commentary Scripture Reference
Man Image of God, help, seed of the woman, possession, prince, tribe Genesis 2:5
Place Jerusalem 2 Kings 21:4
2023-08-29T12:02:00
No land ties
Birth name Title Physical place Spiritual place Scripture Reference
Jesus King of the Jews Bethlehem, Egypt Jerusalem Matthew 2:1
Moses Prince of Egypt Egypt High mountain Exodus 2:10
2023-08-27T08:17:00
Why exclude the future?
Actor Word Scripture Reference
Cain Offering Genesis 4:1-17
Our type can relate a few? Who are you, therefore, about? I cannot grow as the same?
Word Jacob Jesus Christ
Covenant Abrahamic Messianic
Sacrifice Isaac Jesus Christ
Patriach Abraham, Isaac, Jacob Jesus Christ
People Israelite, Jew Christian
Fear Isaac God
Saul versus (VS) David Will love accept?
Word Commentary Scripture Reference
Spirit of God 1 Samuel 10:6, 1 Samuel 10:10, 1 Samuel 11:6, 1 Samuel 16:13, 1 Samuel 16:14, 1 Samuel 16:15, 1 Samuel 16:16, 1 Samuel 16:23, 1 Samuel 18:10, 1 Samuel 19:9, 1 Samuel 19:20, 1 Samuel 19:23, 1 Samuel 28:3, 1 Samuel 28:7, 1 Samuel 28:8, 1 Samuel 28:9, 1 Samuel 30:12, 2 Samuel 23:2, 1 Chronicles 10:13
Contribution to the Gospel The Book of Psalms 2 Samuel 22:1, 2 Samuel 23:1, Psalms
Successor Jonathan versus (VS) David 1 Samuel 20:30
Genealogy 14 generations Matthew 1:17
Kingdom established 1 Samuel 13:13-14, 1 Samuel 15:28, 1 Samuel 20:31, 1 Samuel 24:20, 1 Samuel 28:17, 2 Samuel 5:12-25
Anoint 1 Samuel 2:35, 1 Samuel 9:16, 1 Samuel 10:1, 1 Samuel 12:3, 1 Samuel 12:5, 1 Samuel 15:1, 1 Samuel 15:17, 1 Samuel 16:3, 1 Samuel 16:6, 1 Samuel 16:12, 1 Samuel 16:13, 1 Samuel 24:6, 1 Samuel 24:10, 1 Samuel 26:9, 1 Samuel 26:11, 1 Samuel 26:16, 1 Samuel 26:23, 2 Samuel 1:14, 2 Samuel 1:16, 2 Samuel 1:21, 2 Samuel 2:4, 2 Samuel 2:7, 2 Samuel 3:39, 2 Samuel 5:3, 2 Samuel 5:17, 2 Samuel 12:7, 2 Samuel 12:20, 2 Samuel 14:2, 2 Samuel 19:10, 2 Samuel 19:21, 2 Samuel 22:51, 2 Samuel 23:1, 1 Kings 1:34, 1 Kings 1:39, 1 Kings 1:45, 1 Kings 5:1, 1 Kings 19:15, 1 Kings 19:16, 2 Kings 9:3, 2 Kings 9:6, 2 Kings 9:12, 2 Kings 11:12, 2 Kings 23:30, 1 Chronicles 11:3, 1 Chronicles 14:8, 1 Chronicles 16:22, 1 Chronicles 29:22, 2 Chronicles 6:42, 2 Chronicles 22:7, 2 Chronicles 23:11, 2 Chronicles 28:15, Psalms 2:2, Psalms 18:50, Psalms 20:6, Psalms 23:5, Psalms 28:8, Psalms 45:7, Psalms 84:9, Psalms 89:20, Psalms 89:38, Psalms 89:51, Psalms 92:10, Psalms 105:15, Psalms 132:10, Psalms 132:17
Popular Saul has slain his thousands, and David his ten thousands. 1 Samuel 18:7-8
Notorius Gibeonites 2 Samuel 21
Ally Michal, Jonathan 1 Samuel 19:17, 1 Samuel 20
Water 1 Samuel 12:17, 2 Samuel 5:20
What will relate as I grow? 841 occurrences of king David in the Old Testament.
Word Commentary Scripture Reference
Genealogy Abraham, David, Jesus Christ Matthew 1:17
Reign for a generation Moses, Saul, David, Solomon Deuteronomy 29:5, Judges 3:11, Judges 8:28, 1 Samuel 4:18, 2 Samuel 5:4, 1 Kings 2:11, 1 Kings 11:42, 2 Kings 12:1, 1 Chronicles 29:27, 2 Chronicles 9:30, 2 Chronicles 24:1
Biography David, Jesus Christ 1 Chronicles 29:29, Ruth 4:17, Ruth 4:22, Psalms 40:7, Hebrews 10:7, Matthew 5:18, Psalms, 1 Samuel, 2 Samuel, 1 Chronicles, 2 Chronicles
Davidic covenant Psalms 89:3, Isaiah 55:3, Jeremiah 33:21
What regularity of changes?
Event Frequency Scripture Reference
Creation Daily, Sabbathical rest Genesis 1, Genesis 2:1-3
Times of the Jews versus (VS) times of the Gentiles 490 years Luke 21:24, Jeremiah 25:11-12, Jeremiah 29:10, Daniel 9:2, Zechariah 7:5
First resurrection 1000 years Revelation 20:5-6
How will you wait on time as the period itself? Callable unit. At Arthur Andersen/Warner Music, Electronic Data Systems (EDS)/Westpac Bank and Macquarie Bank, he did not know when to go. When we look at the Bible, when does it start a new use-case by explicitly mentioning the beginning period of the occasion?
Procedure, function or method call Commentary
Pascal language A procedure does not return a value, whereas a function does.
C# language
Method call Commentary
Instance method call Calling a method of a class instance
Static method call Calling a static method of a class
Extension method call Calling an instance method that was added to a class
Asynchronous method call Calling a method and not waiting for the completion of the task
Base method call Calling an inherited method which may have an override clause
Method overloading Calling a method that exhibits the signature
Operator overloading Concatenation is an example of the string addition operator, +, overloading. StringBuilder is preferred.
Constructor method To create and initialize a class instance.
Constructor static method To implictly rely on the execution of a one-off method the first time the class is referenced. This is useful for initializing static variables and building a class collection.
Steer
Type Commentary
Wake-up orientation database table This information is currently being interpreted textually. An image, and even more so, a video of the changes in position and direction when sleeping will offer better insight. For the visually implied, the less bandwidth-intensive text may still be satisfactory.
Non-Alphabetic AlphabetSequence may not be appropriate for people that use glyphs or sign languages.
Structured query language (SQL) The proposed changes which will offer query customization?
  • The author transitioned from a multi-column query to a single-line query which has a tendency to return more results because it is not particular. Context fine-tuning is a suggestion.
  • With search-engine queries, the author proposes a query-language. This potentially affords better resultset granularity restriction, arrangement option, and maturity of use compensation.

Data Science A Hands-On Introduction

This research largely deals with structured data that is put into a relational database. The word is easily associable with a table. The dated column is when the word occurs. The scripture reference column is the guide to the Bible. The columns contain numerical and categorical data. The numbers are the sequence and date columns. The categories are textual and these include the URI, location and scenery columns.

Humans are familiar with the recording of information into tables. The DatesComputation.html is the first time that the author uses pairing data.

How does the work of the author accompany the Bible?

The Terminology of Machine Learning in Relation to AlphabetSequence
TermMeaning
Training dataset or training setThe recording of the word in the database.
Example (or data point, data instance, sample)Each database row or record.
Predict Label (or target)The corresponding Bible text.
Linearity assumptionThe features alphabet places.
WeightSince the word is the only feature, it is the only influence.
BiasA starting value.
(Dive into Deep Learning)

Object Oriented Programming - GetAPage.html

A type of us; is a kind of us? GetAPage.html is Bible specific.

Parent Scripts and Objects

GetAPage.html contains the HTML5 directive, head, and body sections. The head section contains the title and meta tags for search-engine optimization (SEO). The 3 languages that make up a web page are in the following ascending order: CSS, HTML, JavaScript.

HTML is an element's nodes. There are only single instances of the input and submit elements. There are multiple div containers for the result sets. Although HTML supports attributes, the ID attribute is the author's only general declaration.

Both CSS and JavaScript act on HTML tags. JavaScript and CSS render the contents of HTML.

There are minute uses of global variables. The author discourages this, because of encapsulation and debugging traceability and granularity.

Naming Conventions

JavaScript relaxes variable declarations. Variables do not need explicit declaration, and these declarations are redefinable. In spite of this, the author is judicious about variables. The data- attribute is user customizable.

(LOOPE Lingo Object Oriented Programming Environment)
The author acknowledges positive bias in his work. Sometimes the author collaborates with what is said to him. The author may add reinforcement to his word. The author values the population average over the sampling average. For example, the Bible is complete, but the work of the author is on-going.
(Andrew Kelleher).
Causation versus (VS) Correlation? Let the involvement of a personal self; resemble the involvement of a useful self.
(Adam Kelleher).
Bias? Being the other?
(Adam Kelleher).

Search engine optimization (SEO)

Elements

It is only recently that the author has become aware of HTML composition.
Element Commentary
Title tag The maximum length of the title tag is 60 characters and it is shown on the browser's title bar or page's tab.
Meta Description tag This may be upto 155 characters and it indicates the page's content.
Meta tags The other meta names include keywords, robots and author.
Heading tags H1...H6 with H1 being the most important.
Textual content Search engines predominantly optimize for text. Other media are larger in size and duration. When did He promise generational growth ( Psalms 22:30, Genesis 3:15, Genesis 12:7, Genesis 13:15, Genesis 15:13, Genesis 15:18, Genesis 17:8, Genesis 24:7, Genesis 26:3-4, Isaiah 53:10 )?
Alt attribute on the img tag Visually impaired people have difficulty comprehending images.
Fully qualified links Relative links meet the author's requirement, since is hostable on external sites.
Sitemaps (both XML and HTML) A sitemap documents the files and their relationships.
(Bruce Clay).

Literature Review

Reading improvement? The literature review and bibliography sections are scanty and brief. The justification of the author is that in the Internet age the references and content are available on-line, and putting into words other people's work is not the author's core strength. When the author recounts non-original thoughts, the author mentions this.

Results and Discussion

The information in the Bible, written, thousands of years ago, is true and applicable, today; the words heard by the author is consistent and it correlates with the Biblical theme. It was Me. I was telling you.

This research does not limit itself to a particular Bible subject nor word. But, rather it illustrates the response of the author to the word of God. What artifact can the author produce; in compliance with the word of God? Is the training of the author beneficiary or lacking? Biblical priesthood training and profession; begins at the ages of 25 and 30, respectively.
What does God choose as subject ( John 15:15 )?

The author is working on variations of AlphabetSequence: These are not suitable for general use. These are man's exposition of God's word. These are positional.
Biblical generation - 40 Biblical years
  1. 2007...2008 Common Era - the author is 40 years old: the author mentions time.
  2. 2021...2024 Common Era - the biological mother of the author is 80 years old: the word recorded by the author is time relevance specific.
  3. Actor... role commencement date?

  1. AlphabetSequence is the title of the algorithm which calculates chapters and verses placed forward and backward in the Bible.

Is AlphabetSequence prophetic?

  1. Will the word and commentary match the AlphabetSequenceIndexScriptureReference?
  2. Will the date match historical events?
  3. You are using... the Bible... is it supportive?
  4. Words prepare for activity.

Passover: 2026-04-02. 2027-04-22.
Feast of Unleavened Bread: 2026-04-03. 2027-04-23.

  1. Old Testament: Knew, birth, sacrifice, death, worship ( Genesis 4 )
  2. New Testament: Worship, circumcision, baptism ( Matthew 11:11 )

I gave testimony to my biological mother about dreaming her, and Pastor Bert Bain chastised Brian, a Caucasian churchman elder who was married to Fatu, an Islander nurse. I remembered the circumcision of Abraham's only son, Isaac, as an explanation for Akedah.
Mary's Bakery. 34370 Fremont Boulevard. Fremont, California (CA) 94555.
A confider who is in need.

  1. Abraham (Genesis 18:17)

Be

  1. The 7 "I Am" of Jesus
    1. The bread of life ( John 6:35 )
    2. The light of the world ( John 8:12 )
    3. The door ( John 10:7 )
    4. The good shepherd ( John 10:11, John 10:14 )
    5. The resurrection and the life ( John 11:25 )
    6. The way the truth and the life ( John 14:6 )
    7. Pastor Andrew Huang. John 15. The "I Am" of Jesus. I Am the true vine, and My father is the husbandman. Remain in Me. Abide in Me. If you remain in Jesus, you can not help, but bear fruit. Scripture reading: If My words, remain in you. Prayer: Ask what ever you wish. Obey: Obey what the bible says, as the Holy Spirit leads you. Expository ( John 15:1 )

  2. My twin sibling cooked, and he served me pounded yam translated to iyan in the Yoruba language, okra translated to ila in the Yoruba language, and stew.
    My twin sibling also offered me a 99 Ranch Market food voucher, light green worth $2, redeemable for purchases in the hot stove, and the in-house bakery.
    The word came as I brushed and I gaggled my teeth in the upstairs, north-center, bathroom.
    Begin as Me, and you will end as Me ( Matthew 2:1-2, Micah 5:2, John 3:3, John 3:5 ).
    Andrew Leon Meeko of Family Life, Campus Crusade for Christ preached at Christian Layman Church.
    2004-07-18...2026-04-05=7931 days (22 biblical years, 11 days) (21 years, 8 months, 2 weeks, 3 days)
  3. The institutor of a new covenant versus (VS) The mediator of a new covenant ( Hebrews 9:15 )
  4. And about the ninth hour Jesus cried with a loud voice, saying, Eli, Eli, lama sabachthani? that is to say, My God, my God, why hast thou forsaken me ( Matthew 27:46, Psalms 22:1 )?
    My Father versus (VS) My God.
  5. Paschal Lamb ( John 13:3, John 1:29, 1 Corinthians 5:7 )
    Scene 1: We were inside a room, and either in the center-west or north-center, we discovered some missiles belonging to a party were stolen by a third party. I was distrusted by this theft. Scene 2: Uncle Demola, who was standing in the south-center, confessed that he had taken some agricultural farming produce, which were probably leaves, flowers or seeds prior to their harvest for their safety ( Genesis 3:20-24, Genesis 4:16 ).
    Stay the course dream of Chuck Missler. 2014-08-18...2026-04-05=4248 days (11 biblical years, 9 biblical months, 18 days) (11 years, 7 months, 2 weeks, 4 days) ( James 3:4 ).

Client/Server... World Wide Web (WWW)