BUSINESS LOGIC

• Business logic


  Series of computer algorithms containing guidelines for creating, storing, and processing data in a company's internal software or server
• Database


  Categorized sets of data stored on a computer's hard drive, often using specialized software
• Workflow


  Steps required to complete an action using data, allowing employees to perform specific procedures
• Trigger


  Code in a workflow that generates after one event, for example, clicking on a person's name in payroll software might trigger their payment information to appear on the screen
• Business logic ensures daily tasks involving multiple categories of data can remain operational and efficient
• Technicians can input business logic into programs to define steps for tasks like entering credit card information and generating accurate receipts
• Employees only need to perform inputted steps on programs to alter data rather than reading the data itself
• Purpose of business logic

  • Data Consistency
  • Participant control
  • Modification check
• Data consistency


  Data entered according to business logic guidelines matches other information in a database, ensuring workflows can be accomplished and information viewed easily
• Participant control


  Database determines which employees see certain lines of data according to business logic guidelines
• Data flow determines how a database processes and filters information when a user performs an action
• Data flow


  Defines cause-and-effect relationships between lines of data and accounts for different ways a user can perform an action
• Data flow


  • Outlines steps required for a person to log in to a website, including username information, a password, and an additional security question
• Data validation maintains accurate and high-quality data
• Data validation


  Describes a careful process of maintaining accurate and high-quality data
• Data validation


  Creates a testing procedure within a database program to ensure correct data input
• Data validation


  • Determines correct spelling and format of street address data
• Data type check


  • Inspects if an inputted line of data reflects a correct classification, like text versus numerical data
• Range check


  • Observes if number data fits within a pre-determined scope of numbers and integers, like 10 to 100
• Length check


  • Reviews whether the inputted data has the correct amount of information, including whether it's too long for a certain bracket
• Data order check


  • Determines if the inputted data reflects a logical order, like a package delivery date recorded after a customer ordered the time it carries
• Database transaction


  Describes procedures for changing data from one state to another
• Database transaction


  Allows adjustment of large quantities of data accurately, affecting multiple areas of a company's daily operations
• Database transaction


  • Bank employee transferring money from one account to another using data banking software.
• Atomicity


  Property describing how a person changes multiple sections of data with one action while accounting for all aspects of that data
• Isolation


  • Data used during a transaction is invisible to some users until the transaction is completed
• Isolation


  Property ensuring that data used during a transaction is not accessible to other users until the transaction is entirely completed
• Durability


  • Data effects are permanent after a transaction is completed
• Durability


  Property describing how the data effects are permanent after a transaction is completed, even if a database malfunctions
• Consistency


  Property ensuring that data remains consistent and accurate before and after a transaction
• ACID stands for Atomicity, Consistency, Isolation, Durability
• Data transformation


  Rules for changing a section of data's format or structure
• Data calculation


  Combining numerical data to create an amount for multiple applications
• Data notification


  Windows that appear when a person accesses certain data or performs a workflow to provide information or alerts