The Red Team

voltaireblingΔιαχείριση Δεδομένων

20 Νοε 2013 (πριν από 3 χρόνια και 6 μήνες)

84 εμφανίσεις

The Red Team


Software programs



Used for data storage



Possible to run queries



Capable of simple retrieval


Subject
-
oriented


information about specific
subject


Integrated


data gathered from multiple sources


Non
-
volatile


inputted information will not
change


Time
-
variant


information can be identified by
time period


Accessible


easily accessible by users


Process
-
Oriented


delivering information and
maintained


Operational systems
and flat files on the
input side


Metadata, summary
data, and raw data
within warehouse


Users analyze,
report, and mine the
data


Done with understanding and care


Informational Requirements


Gather and Analyze


Identify significant features


Breakdown into components


Map component parts


Must be done right at first; recreation could be
difficult



Warehouse architecture is developed, then the
first increment


First increment will cause changes; operation
will cause changes


Once first increment is created:


Start with one subject and target group


Add areas, groups, capabilities based on
requirements


Improvements are made from previous increments
and warehouse operation


User requirement reanalyzed after increment


Extract


Extract data from source



Transform


Change data to warehouse
characteristics



Load


Load data into software



Find and use data quickly and efficiently


Helps to organize and present data in different
ways


One article says it helps in:


Customer relationship management


Financial analysis


Credit card management


Health service debt management


Banking


Insurance


Knowledge Discovery


In medical field used to detect ADE in different
medical conditions


Analytical


Libraries use to merge existing data into warehouse
for analyzing


PI Process Book


Developed by
OSIsoft


Allows for retrieval of pertinent data


Can display real
-
time data and mine historical data


Benefits:


Immediate insight and increased
manageablility


Meaningful and relevant information of metadata


Increased process control and unlimited availability


Compatible with Microsoft Office


SAP Business Information Warehouse


Allows analysis of data from multiple databases


Contains data extractors, analyzers, report tools, and
business processes


Primarily used in leadership situations


Also used as inventory control and planning system


Benefits:


Saves all pertinent data and saves accordingly


Can give inventory analysis and historical trends


Typically set up with terabytes


Fluctuates with package


Can also be a price per user or price per
processor


Price per user seems to be more advantageous
than terabyte pricing


Data warehousing are software programs for
storing and retrieving data


Six main characteristics of data warehousing


Used in business for multiple reasons


There are tools for data warehousing


Different pricing systems


Overall, good for medium and large companies



Reed,
Micheal
. "Intranet Journal: Feature: Finding Your Way Around E
-
commerce."
Intranet Journal
-

Intranet Design, Development, Content Management, Collaboration Tools,
Microsoft SharePoint, Wikis, Lotus Notes
-

Intranet Journal
. Technology Evaluation.com.
Web. 18 Nov. 2011.
<http://www.intranetjournal.com/features/datawarehousing.html>.


Dambrine
,
Thibault
. "Data Warehouse: Primary Concepts." (2009). Toronto Users Group
for Power Systems, Mar. 2009. Web. 18 Nov. 2011.
<http://www.tylogix.com/Articles/Data_Wareouse_Primary_Concepts.pdf>.


"Data Warehousing Guide."
Oracle
. 2002. Web. 18 Nov. 2011.
<http://download.oracle.com/docs/cd/B10500_01/server.920/a96520.pdf>.


Mento
, Barbara, and Brendan
Rapple
. "Data Mining and Data Warehousing."
Data
Mining and Data Warehousing
. Washington, D.C.: Association of Research Libraries,
Office of Leadership and Management Services, 2003. 9
-
13. Web.


Olson, David L. "Data Mining in Business Services."
Service Business

1.3 (2007): 181
-
93.
Web Journal.


Paladin, D. (2011).
Sap business warehouse
. Retrieved from

http://www.squidoo.com/BW


OSIsoft
. (2010).
Pi
processbook
. Retrieved from
http://www.osisoft.com/software
-
support/products/PI_ProcessBook.aspx


http://www.dbms2.com/2010/10/15/pricing
-
of
-
data
-
warehouse
-
appliances/

ftp://ftp.software.ibm.com/software//data/sw
-
library/infosphere/whitepapers/Bottom
-
line
-
Advantages
-
InfoSphere
-
Warehouse
-
Terabyte
-
Pricing.pdf