Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

INFOSYS 323 > Chapter 7 > Flashcards

Chapter 7 Flashcards

1
Q

What’s the first level of the Three-Level Database Model?

A

Level 1:
External, conceptual or local level
- Various “user views” of corporate data
- Each application program has own view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the second level of the Three-Level Database model?

A

Level 2:
Logical or enterprise data level
- “Technical” (human) view of all corporate data
- Controlled by database administration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the third level of the Three-Level Database model?

A

Level 3:
Physical or storage level
- Specifies the way data is physically stored
- For use by database administrators

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the first level of the Four Data model?

A
  1. Hierarchical Model
    - structured so that each element is subordinate to another in a district hierarchical manner
    E.g. Parent-Child relationship
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the 2nd Data Model of the Four Data models?

A
  1. Network Model
    - allows each data item to have more than one parent
    - relationships stated by pointers stored with the data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the 3rd Data Model of the Four Data models?

A
  1. Relational Model

Data stored in tables (intuitive for users)

  • key unique identifiers
  • “tuple-calculus” operations (commands such as select, join, match etc)
  • Data normalisation (optimisation)
  • not as efficient as hierarchical but more flexible
    - Database technology of choice e.g. SQL MS Access
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the 4th Data Model of the Four Data models?

A 
4. Object-Oriented Database Model 
Extension of concept of data to objects
- piece of data 
- methods that can perform work on data
- attributes to describe the data 
- relationships between objects

Objects can be used to store any type of data

  • e.g. Spreadsheet, video clip, photograph etc
  • object database

Object-Oriented models retain traditional DBMS features including:

  • end user tools
  • high level query languages
  • concurrency control
  • recovery
  • ability to handle huge amounts of data

Addition of to major concepts

  • object management
  • knowledge management

Object-Oriented models outperform relational systems for certain types of database manipulation
- scientific and engineering applications

Corporations are slow to adopt due to legacy systems

Tenets of objects have increasingly become important in world of computing
- e.g. Web services because XML modules utilise object principles

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the role of the Data Admin?

A

Administers the database and software that manages them to provide accurate and timely information to users

Determine what data is being used outside of originating organisational unit boundaries
- Definition and format must be standardised
- Data dictionary used as main tool
- Data elements definition, schema, database structures,
Usernames, roles and privileges.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Give 5 point job description of a Database Administrator.

A
  1. Analyse data so that the organisation has the data that it needs and that data are managed in the most cost effective way.
  2. Help integrate DBMS with applications software
  3. Oversee and monitor DBMS development through in-house teams or outside contractors
  4. Monitor and administer DBMS security
    - authorisation, backup, auditing recovery
  5. Work with the CIO and system administrator to configure hardware and software for optimal deployment of DBMS.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Explain the concept of Managing information?

A

Once enterprises get their data into shape, that data can more easily be turned into information

Information is power

Managing information is a critical activity

  • Technology = infrastructure
  • Asset = information that runs on that infrastructure.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the Four Types of Information?

A
  1. Internal record based info
  2. Internal document based info
  3. External record based info
  4. External document based info
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is internal record based information?

A

It was the original focus of IS organisations because it is the type of information that computer applications generate and manage easily.

Typical corporate authority:
Information systems department

Information sources:

  • translation processing
  • organisational units

Technologies used

  • DBMS
  • Data dictionaries
  • Enterprise data analysis techniques
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is internal document based information?

A

Document based information deals with ideas, thoughts and opinions

Typical corporate authority

  • Administrative
    • Vice President
  • Word processing canter
  • Records management

Information source

  • Corporate
    - memos, letters, reports, forms and emails

Technologies used

  • word processing
  • micrographics
  • reprographics
  • ext retrieval products
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are external record based information?

A

Typical corporate authority

  • end users
  • corporate planning
  • financial analysis
  • marketing

Information sources
- public database

Technologies used

  • Internet based services
  • public networks
  • Analysis packages
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are external document based information?

A

Typical corporate authority
- Corporate library

Information sources

  • Public literature
  • News services
  • Catalogs and indexes
  • Subscriptions
  • Purchased reports
  • Internet e.g. Wikipedia
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the five steps in a data warehousing project?

A
  1. Define the business uses of the data
  2. Create the data model for the warehouse
  3. Cleanse the data
  4. Select the user tools
  5. Monitor usage and system performance
17
Q

List some key elements of a Data Warehouse.

A

Data warehouse stores data used to make decisions

  • obtained periodically from transaction databases
  • snapshot of situation at specific time
  • different from operational databases

Customer data is most common type of data housed
- corporate use transcends reporting internal data to business intelligence today

Metadata
- data for the data. Data explaining what the data is

Quality data
- cleansing of date to adhere to metadata standards

Datamart

  • subset of data pulled from the warehouse for a specific set of users.
  • for faster search time and lower costs

Data warehouses are seen as strategic assets that can yield business intelligence
- customer behaviour, product mixes etc…

Getting corporate data into shape is a key prerequisite
E.g. Reconciling data from legacy system.

18
Q

Explain what document management means?

A

Vice President of administration traditionally responsible for the management of internal document base information.

  • Paper still plays an important role in most enterprises
  • Need to move seamlessly between digital and print

Electronic document management (EDM) uses new technologies for document management to produce significant impacts

  • business process redesign
  • quality improvement
19
Q

What are some document snapshots of some set of information?

A
  • incorporating many complex information types
  • exist in multiple places across a network
  • depend on other documents for information
  • change on the fly as subordinate documents are updated
  • have complex data types such as full motion video and voice annotations
  • be accessed and modified by many people simultaneously.
20
Q

Describe EDM: Improving the Publishing process.

A

Traditional parcels has inefficiencies

  • infrequent long print runs require storing documents which become obsolete in between runs
  • 60% of the total cost of transporting the documents is in storage and transportation

EDM enables major restructuring of publishing and distribution process of print documents

  • electronic storage
  • mass distribution and print when needed

EDM minimises obsolescence, physical warehouse costs and delivery times.

21
Q

Outline the difference between traditional publishing process and the reengineered publishing process.

A

Traditional publishing process
Electronic creation and composition –> offset lithography –> warehouse –> transportation

Reengineered publishing process
Electronic creation and composition –> electronic storage and management –> communication –> electronic printing and finishing

22
Q

What is an EDM?

A

It is an electronic document management system that uses new technologies that manage information resources that don’t fit easily into traditional databases.

Addressing organising and managing conceptual, descriptive and ambiguous multimedia content.

23
Q

Describe EDM: Supporting communication among people and groups.

A

The value of documents is that they transfer information across time and space
- Internet can help but people often still rely in printed documents

EDM can be used to facilitate such communications amount people and groups
- tapiola case study illustrates how.

24
Q

Describe EDM: Supporting organisational processes

A

Documents still the vehicle for accomplishing most organisational processes.

Using technology to support processes generates significant business value

  • reducing physical space for storage
  • faster routing / delivery of documents
  • easier to manage and track work flow and load

Two trends in organisations have increased the importance of workflow

  1. Quality management
  2. Business process reengineering

Use of technology to improve management process

  • decision support
  • problem solving
  • control
25
Q

Describe Content Management.

A

Corporate intranets (web content) now replace print documents
- necessary to support scale of e-business operations
- automation of content
- computer readable and interchangeable format
E.g. XML
- content is no longer static but interactive

To create management strategy, companies need to understand the three phases of content.

26
Q

What are the three phases of content?

A
  1. Managing content creation and acquisition
  2. Content administration and safeguarding
  3. Content deployment and presentation
27
Q

Explain Managing content creation and acquisition.

A

Focus in creating content quality

  • content can be purchased from external specialists
    - syndicated content

Decentralised organisational structure for content creation and maintenance to content-expert employees is best approach

  • central direction for dispersed experts however required
  • standardised organisation wide formats to integrate content into overall workflow also needed.
28
Q

Explain 2. Content administration and safeguarding.

A

Efficiency is key in this phase

Content management tools can be used to identify types of content and the business rules that apply to each type

Content administration should be centralised

  • organisational workflow
    - how content fits into overall organisation process
  • content approval e.g. Foreign language translation
29
Q

Explain 3. Content deployment and presentation in content management.

A

Effectiveness is the emphasis in this phase - maximise effect of web content presentation

  • attract visitors and gain desired outcomes
    - easy site navigation, pertinent and accurate information

This phase is crucial to the success of e-commerce effort and so web site design should start here

Most web sites today require certain features to attract and retain visitors

  • personalisation
  • localisation
30
Q

Explain: Selecting web content management tools.

A

Wide range of COTS (commercial off the shelf) available today

Some important selection criteria

  • digital asset management
  • information rights management
  • ability to handle full rand of digital content types
  • versioning
  • workflow and approval routing
  • web publishing platforms

INFOSYS 323 (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions