Global Unique Identifier | Glossary

Definition:

A GUID (global unique identifier) is a term used by Microsoft for a number that its programming generates to create a unique identity for an entity like a Word document. GUIDs are wide utilized in Microsoft products to identify interfaces, duplicate sets, records, and alternative objects. different types of objects have different types of GUIDs – for example, a Microsoft Access database uses a 16-byte field to determine a unique identifier for replication.

Further Reading:

Book: Patterns of Enterprise Application Architecture by Martin Fowler .  

 

Stored Procedure | Glossary

Definition:

A stored procedure is a routine available to connected relational database system applications. Stored procedures should be referred to as or invoked, as they are sets of SQL and programming commands that perform very specific functions. Most major relational database systems (e.g., SQL Server, Oracle, MySQL, Postgres and others) provide support for stored procedures.

Further Reading:

Book: Patterns of Enterprise Application Architecture by Martin Fowler .