Examples Of Online Transaction Processing

Submitted By edgarloblas
Words: 1401
Pages: 6
Open Document
INTRO:
•Online transaction processing (OLTP) gathering and processing information and updating existing information to reflect the processed information
—Supports operational processing
—Sales orders, accounts receivable, etc
—Supported by operational databases & DBMSs

•Online analytical processing (OLAP) manipulation of information to support decision making
—Helps build business intelligence
—Supported by data warehouses and data-mining tools RELATIONAL DATABASE MODEL:
žDatabase – collection of information that you organize and access according to the logical structure of the information
žRelational database – series of logically related two-dimensional tables or files for storing information
—Relation = table = file
—Most popular database model
DATABASE- CREATED WITH LOGICAL STRUCTURES
žData dictionary – contains the logical structure for the information in a database
žPrimary key – field (or group of fields) that uniquely describes each record
žForeign key – primary key of one file that appears in another file

žIntegrity constraints – rules that help ensure the quality of information
žData dictionary, for example, defines type of information – numeric, date, and so on
žForeign keys – must be found as primary keys in another file
—E.G., a Customer Number in the Order Table must also be present in the Customer Table
Database management system (DBMS) helps you specify the logical requirements for a database and access and use the information in a database

5 CONCEPTS OF DBMS
1.DBMS engine
2.Data definition subsystem
3.Data manipulation subsystem
4.Application generation subsystem
5.Data administration subsystem

DBMS ENGINE:
•DBMS engine – accepts logical requests from other DBMS subsystems, converts them into the physical equivalents, and access the database and data dictionary on a storage device
•Physical view – how information is physically arranged, stored, and accessed on a storage device
•Logical view – how you need to arrange and access information to meet your needs

DATA DEFINITION SUBSYSTEM
žData definition subsystem – helps you create and maintain the data dictionary and structure of the files in a database
žThe data dictionary helps you define…
—Field names
—Data types (numeric, etc)
—Form (do you need an area code)
—Default value
—Is an entry required, etc

DATA MANIPULATION SUBSYSTEM:
žData manipulation subsystem – helps you add, change, and delete information in a database and query it to find valuable information
žMost often your primary interface
žIncludes views, report generators, query-by-example tools, and structured query language

VIEW
žView – allows you to see the contents of a database file, make changes, and query it to find information

REPORT GENERATOR
žReport generator – helps you quickly define formats of reports and what information you want to see in a report

QUERY-BY-EXAMPLE TOO
žQBE tool – helps you graphically design the answer to a question

STRUCTURED QUERY LANGUAGE
žSQL – standardized fourth-generation query language found in most DBMSs
žSentence-structure equivalent to QBE
žMostly used by IT professionals

APPLICATION GENERATION SUBSYSTEM
žApplication generation subsystem – contains facilities to help you develop transaction-intensive applications
žMainly used by IT professionals

DATA ADMINISTRATION SUBSYTEM
•Data administration subsystem – helps you manage the overall database environment by providing facilities for…
—Backup and recovery
—Security management
—Query optimization
—Reorganization
—Concurrency control
—Change management
žBackup and recovery – for backing up information and restarting (recovering) from a failure
—Backup – copy of information on a computer
—Recovery – process of reinstalling the backup information in the even the information was lost
žSecurity management – for CRUD access – create, read, update, and delete
Show More

Related Documents: Examples Of Online Transaction Processing

Essay about Vocabulary and Grade Assignment

2013 (9th Grade Assignment) Standards: LACC.910.RL.2.4 LACC.910.RI.2.4 Focus lesson of the day: Authors Purpose Main Idea Reading 180/ Townsend book (blue) Agenda: 1) Review HW 2) Review vocabulary worksheet 3) Complete check your understanding pg. 75-77 (1-10) 4) Complete check your understanding pg. 77-79 (1-10) 5) Read 180 book pg. 20-21. Take the word challenge (1-10) 10th Grade Assignment Read Townsend book 1. Vocabulary in context pg. 21-25 2. Read 26 1-10 3.…

Words 994 - Pages 4

Study Guide for Economics Essay example

greater than marginal cost ($45), but as close to equality as possible. Total profit will be $270 ($480–$210). (b) The demand for the firm’s product will decrease until price equals average cost and total profits are zero. [text: E pp. 488-490; MI pp. 230-232] 8. In the first graph below, illustrate the cost curves and demand conditions for a monopolistically competitive firm making short-run profits. In the second graph, illustrate what those conditions are most likely to be in the long…

Words 7370 - Pages 30

Review Questions For Chap 2 1 Essay example

2) A boat can move at 30 km/h in still water. How long will it take to move 12 km upstream in a river flowing 6.0 km/h? A) 20 min B) 22 min C) 24 min D) 30 min 3) 55 mi/h is how many m/s? (1 mi = 1609 m.) A) 25 m/s B) 49 m/s C) 90 m/s…

Words 971 - Pages 4

1 4 Essay

example, in a typical firm, line departments include production and marketing. In a line organisation authority follows the chain of command. Figure 1.2 Home depot has approximately 180 employees per store and almost 371,000 (2015) just in United States. The Canadian operation consists of 180 stores and employs over 35,000 people in Canada. Home Depot Canada has stores in all ten Canadian provinces and serves territorial Nunavut, Northwest Territories, and Yukon through electronic means…

Words 849 - Pages 4

The Media’s Affect on the Mental Health of African Americans Essay

Dr. Jeff Menize’s book, Dumbin’ Down: Reflections on The Mis-Education of the Negro goes into depth of Carter G. Woodson’s theories, of Whites’ influence on the education of African American, with a modern perspective. Dumbin’ Down presents the reader with an understanding of Woodson’s theories by applying them to the world and to the classroom setting. Within this this essay, I will explain the effects of the media’s portrayal of Black women, and lasting impressions on the race as a whole. I will…

Words 953 - Pages 4

Hotel industry of Bridgeport Essay

Directory 1. Introduction on Bridgeport‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥3 2. Introduction on the Venue‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥4 3. Introduction on the Meal‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥9 4. Transportation‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥14 5. Works Cited‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥‥16 Hosting Conference in the Bridgeport, Connecticut 1. Introduction on Bridgeport Bridgeport, in the Connecticut, is the most populous city. It is located in Fairfield County Pequannock River and Long Island. The city in the 2010 U.S. Census is…

Words 2483 - Pages 10

Leech Research Paper

A tall and lean swimmer known for her elegant technique, Leech started swimming as a child to build strength after a series of eating disorders in her infancy. She quickly rose to prominence after breaking a string of age group records. In 1955, she became the youngest swimmer to win an Australian title, claiming victory in the 110 yd (100 m) at the age of 13. She twice broke the Australian record in the 100–yard freestyle in late 1955, thereby positioning herself as a leading contender for Olympic…

Words 3759 - Pages 16

Moons in Solar System Essay

solar system. It has a metallic core with a radius between 350 and 650 km that takes up about 20% of it's mass. "The lithosphere of Io,composed of basalt and sulfur deposited by Io's extensive volcanism, is at least 12 km (7 mi) thick, but is likely to be less than 40 km (25 mi) thick."(wikipedia) The atmosphere of Io is extremely thin and composed of sulfur dioxide, sulfur monoxide, sodium chloride and atomic sulfur and oxygen. Titan Titan is the largest…

Words 1070 - Pages 5

Medical Case Management Case

Swamy (family physician) Address: 4065 E. Cook, Rd. Grand Blanc, MI 48439 Phone: 810-695-2500 Last office visit: as needed Next office visit: as needed Name: Dr. Drayer Orthopedic Surgeon Address: 1515 Lake Lansing, Lansing, MI 48912 Phone: 517-371-3407 Last office visit: 12/8/17 Next office visit: 1/10/18 MEDICATIONS Mr. Mossman reports taking the following medication before his…

Words 998 - Pages 4

Statistic Practice Question Paper

program mi ng tech niqu es calle d net w or k flo w p roblems. 2) T ransportation mo dels m ay be use d w hen a fir m is tr y i ng to d eci de w here to locate a ne w facilit y. 3) A t y p ical transportation p roblem m a y ask the q uestion, " H o w man y of X shou l d be shi p ped to point E from so u rce A ?" 4) In fin d i ng the m axi m u m q u antit y that can be sh i p p ed on the least costl y rou te usi ng the step p in g- stone m etho d, one exa mi nes the close d path of p lus an d mi n us…

Words 6162 - Pages 25