Create
Learn
Share

Chapter 5

rename
imissyou419's version from 2017-03-02 17:47

Section

Question Answer
Contentsomething of value that can be considered an asset;
closely related to intellectual property;
varies by industry (i.e. in advertising -> pictures, commercials, text used to promote ideas about products; in publishing -> words; in banking -> account info)
before computers had to create physical content;
managing content is important for businesses
Intellectual propertya form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography
Challenge today for contentnot collecting but distributing and presenting the content;
indexing or cataloguing the right info, processing it, storing it, getting it to right person
DBMScentral to management of content data; effectively and efficiently store & process data
CMSPresentation of content; organize documents, seek out docs & organize access
Spreadsheet vs databaseSpreadsheet - keep list of single concept (records simple list of student grades);
Database - keep lists that involve multiple themes (records student grades, email, office visits)
What are the components of a database application system?user, database application (forms, reports, queries, application, programs), DBMS , database (tables, relationships, metadata)
DBMSprograms that creates, process, administers database;
usually licensed from vendors (Microsoft: Access, SQL; Oracle: oracle; IBM: DB2; Opensource: MySQL)
Database vs DBMSDatabase - collecting of tables, relationships, metadata;
DBMS - software program
DBMS createstables, relationships in databases
DBMS processapplications use DBMS to read data, insert data, modify data, delete data
DBMS administrationSecurity levels (access to database), backup, improve performance, removal of data no longer needed
Database applicationcollecting - forms, reports, queries, application programs that process data (database may have one or more applications, each application may have one or more users)
Forms, reports, queries are good forstandard functions
Application programs (non-standard functions)process logic specific to business need;
enables database processing over the internet (intermediary between web server & database,
responds to events such as when a user presses a submit botton; reads, inserts, modifies and deletes database data)
Multi-user processing problemlost-update problem, to prevent have locking used to coordinate activities of multiple users
Enterprise DBMS- process organizational & workgroup data;
- large database;
- support many many users;
- examples: DB2, SQL server, Oracle
Personal DBMS- designed for smaller, simpler database applications;
- supporters fewer than 100 users;
- examples: access, dBase, FoxPro, Paradox, R:base
Database securityPermissions:
- role-based access
- user-based access
- context-based access

Authorization
- column access control
- row access control
- type of access (read or read/write)
Big DataIBM estimates that 90% of the data now stored in computers did not exist 2 years ago
Collectively, generate new data at rate of 2.5 quintillion bytes per day (fill disk drive of 20,000 new PCs every week)
Much of this data can be of value, but earlier approaches to organizing and analyzing data won't work with big data
Big Data 3 characteristicsVolume: a lot of data,
Velocity: must be analyzed quickly,
Variety: incl. structured data, unstructured data, audio, video, etc
Big Data 2 challenges and 1 solutionstorage and analysis

1 solution: Hadoop
Creating database- consultant creates data model (based on interview with users)
- data model reviewed and approved
- database tables constructed (primary & foreign key selected based on interviews)
- MS access database created, relationships indicated, forms & reports constructed
memorize

Recent badges