Data Softech Inc.

2y ago
12 Views
2 Downloads
2.00 MB
60 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Tripp Mcmullen
Transcription

Sept. 21th, 2006Data Softech Inc.The Complete Database Solution ProviderORACLE 10g A’A’s : AWR, ADDM, ASH, ASM.Inderpal S. JohalPrincipal Consultant

Agenda AWR- Automatic Workload Repository ASH- Active Session History ADDM- Automatic database Diagnostic Monitor ADVISORY ASMM- Automatic Shared Memory Management ASM- Automatic Storage Management Q&APR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .2

Pre-Requisite for Self Tuning FeaturesSTATISTICS LEVELBASICTurn off allSelf-tuning FeaturesPR NewswireTYPICALALLDefault &RecommendedMore Stats for ManualSQL diagnosticsOracle 10g A’A’s : AWR, ADDM, ASH, ASM .3

Self Tuning FeaturesSELECT statistics name, activation levelFROMv statistics levelORDER BY 2;PGA AdviceShared Pool AdviceActive Session HistoryUndo Advisor, Alerts and Fast Ramp upStreams Pool AdviceBuffer Cache AdviceTimed OS StatisticsPlan Execution StatisticsPR ALLALLOracle 10g A’A’s : AWR, ADDM, ASH, ASM .4

AWR – Automatic Workload sDBAV SCHEMAWORKLOADREPOSITORYADDMEMAdvisorySQL*PlusAuto SQLTuningrd Party Tool3rd.Internal ClientsPR Newswire.External ClientsOracle 10g A’A’s : AWR, ADDM, ASH, ASM .5

AWR – In Memory StatisticsIn-Memory StatisticsASHAWRSTATISTICSSGAIn-MemoryStatisticsV BASE STATISTICS – Stats collected in MemoryV SEGMENT STATISTICSV SYS TIME MODELObject Statistics showing access & UsageShowing time spend by ActivitiesV SYSSTATSYSTEM StatisticsV OSSTATOS Statistics showing CPU and MemoryV ACTIVE SESSION HISTORY – Recent Session ActivitiesPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .6

ASH – Active Session HistoryV SESSION V SESSION WAITV ACTIVE SESSION HISTORYMMNLEverySecondSession ActivityWait EventObjectIn-MemoryStatisticsASHAWRStatisticsDBA HIST ACTIVE SESS HISTORYWRH ACTIVE SESSION HISTORYWhen Buffer66% FullCircularBuffer1 sec sample1 sec sample1 sec sample1 sec sample1 sec sampleMMNLWRMMONEvery60 Min.SCHEMAWORKLOADREPOSITORY- Only Records ACTIVE Sessions means NON-IDLE Sessions- Rolling buffer and previous information is overwritten when required- Writes 1 out of 10 Samples to AWRPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .7

ASH – SamplingWait 1Active Session 2Wait 21sActive Session 3Wait 3Active Session 4Wait 4Wait 51sWait 6Wait 7Wait 8 .Active Session 1ASHSession 1 – Wait 1Session 1 – Wait 4Session 1 – Wait 7.Session 2 – Wait 1.V ACTIVE SESSION HISTORYPR NewswireActive Session 5INACTIVESESSIONSOracle 10g A’A’s : AWR, ADDM, ASH, ASM .8

ASH Buffers factsASH Buffer Size- SGAMin 1M and Max 30MMax( Min ( No. of CPU * 2 M, 5% of SHARED POOL SIZE, 2% ofSGA TARGET) ,1M)Hidden parameter “ ASH SIZE” Please Don’t change itASH Buffers Data is flushed to AWR when buffers are 66% filled by MMNL processHidden parameter “ ASH EFLUSH TRIGGER” Please Don’t change it-ASH Buffers are filled with 1 Sec Samples from Active Session-state informationHidden parameter “ ASH SAMPLING INTERVAL” Please Don’t change itHidden parameter “ ASH SAMPLE ALL” Please Don’t change itPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .9

ASH Buffers facts-Oneout of 10 ASH sampled Record of each Session is pushed to AWRSGAHidden parameter “ ASH DISK FILTER RATIO 10” Please Don’t change it-ASH can be disabled by the following methodsHidden parameter “ ASH ENABLE FALSE”Use STATISTICS LEVEL BASIC- Please Don’t change it Recommended optionCheck the Size in your DatabaseSELECT * FROM v sgastat WHERE name 'ASH buffers';PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .10

ASH – Automatic Shell HistoryASH ReportSGAin Text or HTML format using ORACLE HOME/rdbms/admin/ashrpt.sql -- Report for Specified Duration ORACLE HOME/rdbms/admin/ashrpti.sql -- Report for Specified duration andfor Specified DB and InstanceASH Report- Top Events- Load Profile- Top SQL- Top Sessions- Top Objects/Files/Latches- Activity Over Time-You can Dump ASH content to FileSQL oradebug setmypidSQL oradebug dump ashdump 5PR Newswire-- This will dump last 5 minute contentOracle 10g A’A’s : AWR, ADDM, ASH, ASM .11

AWR – In Memory StatisticsIn-Memory StatisticsASHAWRSTATISTICSSGAIn-MemoryStatisticsV BASE STATISTICS – Stats collected in MemoryV SEGMENT STATISTICSV SYS TIME MODELObject Statistics showing access & UsageShowing time spend by ActivitiesV SYSSTATSYSTEM StatisticsV OSSTATOS Statistics showing CPU and MemoryV ACTIVE SESSION HISTORY – Recent Session ActivitiesPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .12

Base Statistics and MetricsBase StatisticsIt is raw data collected in Oracle Database-E.g Number of any Waits or Physical Read since system startupMetricsIt is the statistics derived from Base Statistics---E.g Number of any specific waits or Physical Read in last one hourOracle support Metrics for following statisticsSystemSessionsFilesWait eventsMMON periodically updates the Metrics data from correspondingBase StatisticsPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .13

Metrics ViewsMETRICS GENERALINFORMATIONV METRICNAMEV METRICGROUPV METRICV METRIC HISTORYDBA HIST METRIC NAMESYSTEMMETRICSV SYSMETRICV SYSMETRIC HISTORYV SYSMETRIC SUMMARYDBA HIST SYSMETRIC HISTORYDBA HIST SYSMETRIC SUMMARYSESSIONSMETRICSV SESSMETRICDBA HIST SESSMETRIC HISTORYFILESMETRICSV FILEMETRICV FILEMETRIC HISTORYDBA HIST FILEMETRIC HISTORYWAIT EVENTSMETRICSV EVENTMETRICV WAITCLASSMETRICV WAITCLASSMETRIC HISTORYPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .14

Benefit of MetricsSnapshotSnapshotQuery Metrics ViewsCompute the DifferencesDBAOLDPR NewswireNEWOracle 10g A’A’s : AWR, ADDM, ASH, ASM .15

AWR – Automatic Workload RepositoryBgndFgndSGAIn-MemoryStatisticsMMONDBAV WORKLOADREPOSITORYWORKLOADREPOSITORYEMSQL*Plusrd Party Tool3rd.External ClientsPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .16

AWR – Workload RepositorySYSAUX TablespaceMMONWR SCHEMA9:00 am10:00 am11:00 am12:00 am1:00 pm2:00 pmSGAIn-MemoryStatisticsEvery 60Minutes3:00 pm4:00 pm5:00 pmSnapshot 1Snapshot 2Snapshot 3Snapshot 4Snapshot 5Snapshot 6SevendaysSnapshot 7Snapshot 8Snapshot 9WORKLOAD REPOSITORYPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .17

AWR – Workload Repositorydbms workload repository.modify snapshot settings( interval 60,retention 43200);--30 days 43200SELECT snap interval, retention FROM dba hist wr control;PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .18

AWR – RAC Workload RepositoryMMONCoordinatorSYSAUX TablespaceSGAWR SCHEMAIn-MemoryStatistics9:00 am10:00 am11:00 am12:00 am1:00 pm2:00 pmSGA3:00 pm4:00 pmIn-MemoryStatistics5:00 pmSnapshot 1Snapshot 2Snapshot 3Snapshot 4Snapshot 5Snapshot 6Snapshot 7Snapshot 8Snapshot 9WORKLOAD REPOSITORYMMONPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .19

AWR – WR SchemaWR SchemaMETADATATablesWRM xxDBA HIST xxAdvisoryTablesWRI xxDBA HIST xxHistoricalStatisticsTablesWRH xxPR NewswirePartitionedTables by day7 daysDBA HIST xxOracle 10g A’A’s : AWR, ADDM, ASH, ASM .20

AWR- ReportsDifferent types of AWR reportawrrpt.sql-AWR Workload Reportawrddrpt.sql-Side by Side AWR comparisionawrinfo.sql-AWR Information like current Usage andData Distributionawrload.sql-Load AWR Dump from one DB to anotherawrsqrpt.sql-Create AWR report for specific SQLstatementPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .21

ADDMAutomatic Database Diagnostic MonitorAWRSNAPSHOTSGAIn-MemoryStatisticsMMON60 MinADDMResultsADDMDBAProactive MonitoringReactive MonitoringPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .22

ADDM1.Snapshot iADDMSnapshot i 12.3.PR NewswireReport and Advise on- High Load SQL and PL/SQL statements- System Resources like CPU bottleneck- Space Management- Storage Management- Backup and Recovery ManagementCreate on-demand report using scriptNamed addmrpt.sql present in ORACLE HOME/rdbms/admin directoryUse EM for analysisOracle 10g A’A’s : AWR, ADDM, ASH, ASM .23

ADDM It is also called Advisor for the Database InstanceIt helps in identifying the problem and their causesIt also provides recommendation for each problemIt can potentially call all other 10g new advisorsIn Short ADDM main objective is1. Reduce Bottlenecks2. Improve PerformanceAWRPGA AdvisorSQL PR NewswireADDMBuffer CacheShared PoolSegment AdvisorUndo AdvisorOracle 10g A’A’s : AWR, ADDM, ASH, ASM .24

ADDMPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .25

Oracle 10g AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .26

Oracle 10g AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .27

Advisor – SQL Tuning AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .28

Advisor – SQL Tuning AdvisorDBAADDM10gSQL TuningAdvisorRecommend Missing StatsStats AnalysisSQL ProfilingPR Newswire10g R2Create & Recommend SQL ProfileAccess Path AnalysisRecommend New IndexesCall SQL Access AdvisorSQL Structure AnalysisAdvise by Rewriting the QueryOracle 10g A’A’s : AWR, ADDM, ASH, ASM .29

Advisor – SQL Access AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .30

Advisor – SQL Access AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .31

Advisor – SQL Access AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .32

Memory Advisor - ASMMAutomatic Shared Memory ManagementPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .33

Advisor – ASMMSGA 20GDB Buffer CacheShared PoolJava PoolLarge PoolSGA TARGET 20GSGA MAX SIZE 20GRedolog BufferSTATISTICS LEVEL TYPICALFixed SGALOG BUFFERDB KEEP CACHE SIZEStreams PoolDB RECYCLE CACHE SIZEAuto TunedDB nK CACHE SIZEManually Tuned Parameters Set STATISTICS LEVEL TYPICAL ALL to use ASMMSet SGA TARGET 0 [Default 0 means ASMM is disabled] DB CACHE SIZE/SHARED POOL SIZE/JAVA POOL SIZE/LARGE POOL SIZE/STREAMS POOL SIZE 0when SGA TARGET is set to non Zero value If you specify any value to above Auto Tuned variable in initialization parameter file,they will become Lower bound valuee.g. if SGA TARGET 20G and SHARED POOL SIZE 5G, then SHARED POOL never shrink below 5G ASMM uses new Background process MMAN [Memory Manager]MMAN coordinates the sizing of Memory componentsPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .34

Advisor – ASMMPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .35

Advisor – ASMMPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .36

Advisor – Segment AdvisorPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .37

What is ASM ASM stands for Automatic Storage Management It is Oracle Cluster File System and Volume Manager Designed for Oracle Database Related Files Provide Storage management capabilities like striping aswell as mirroringData filesLog filesArchived filesControl FilesNot Certified forTrace FilesORACLE HOMEVoting DiskOCR FilesAlert LogPassword FileBinary File (BFILE)Temp FileSPfileDG fileFlashback LogsDatapump FileDataGuardChange Tracking FilePR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .38

Benefits of Automatic Storage Management Provide efficient management of storage No need for buggy OCFS or expensive 3rd party CFS Provide integrated Cluster File system and Volumemanagement capabilitiesTraditional Volume e systemsAutomaticStorageManagementDisk PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .39

Benefits of Automatic Storage Management Provide efficient management of storage Provide integrated Cluster File system and Volumemanagement capabilities No need for buggy OCFS or expensive 3rd Party CFS Provide Software Mirroring on top of vendor supplied SAN[2 or 3 Mirrors]Triple MirroringPR NewswireDouble MirroringOracle 10g A’A’s : AWR, ADDM, ASH, ASM .No Mirroring40

Benefits of Automatic Storage Management Provide efficient management of storage Provide integrated Cluster File system and Volumemanagement capabilities No need for buggy OCFS or expensive 3rd Party CFS Provide Software Mirroring on top of vendor supplied SAN[2 or 3 Mirrors] Automatic online re-organization of disk space for any newaddition/removal of storage capacityDisk GroupPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .41

Pre-Requisite for ASM Need CSS daemon for creating an ASM instance ps –ef grep css1. In RAC, it is done by Oracle Custerware2. In Single Instance environment, you have to run ORACLE HOME/bin/localconfig addTo reconfigure the CSS daemon to run from the new Oracle home:# ORACLE HOME/bin/localconfig reset ORACLE HOME Need Additional at least 100M of memory for ASM instancePR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .42

ASM ArchitectureNode 1DB InstancePMONSMONRBALLGWRDBWRASMBGroup Services ASM1-- DG1 ASM1 -- DG2LGWRDBWRFGARB0 ARBaNode 2OCSSDSMONPMONGMONRBALASM Instance ASM1ASM Disk ASM DiskASM Disk ASM DiskDG1 – Disk GroupDG2 – Disk GroupPR NewswireOCSSDDB InstanceGroup Services ASM2-- DG1 ASM2 -- DG2 ASM2 -- DG3ARB0 WRFGFGASM Instance ASM2DB InstanceASMBPMONSMONRBALLGWRDBWRASM Disk ASM Disk ASM DiskDG3 – Disk GroupOracle 10g A’A’s : AWR, ADDM, ASH, ASM .43

ASM Components ASM Instance ASM Disk Disk Group Failure Group ASM FilesPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .44

ASM Components – ASM Instance10g has two types of Instance INSTANCE TYPE asm INSTANCE TYPE rdbms [Default]ASM InstanceDB InstanceFeature of ASM instance Do not mount the database but manage metadata required tomake ASM files available for DB instances sqlplus /nologSQL connect / as sysdbaConnected to an Idle instanceSQL startupASM instance startedTotal System Global AreaFixed SizeVariable SizeASM CacheASM diskgroups mountedPR Newswire79691776 bytes1247396 bytes53278556 bytes25165824 bytesOracle 10g A’A’s : AWR, ADDM, ASH, ASM .45

ASM Components – ASM Instance10g has two types of Instance INSTANCE TYPE asm INSTANCE TYPE rdbms [Default]ASM InstanceDB InstanceFeature of ASM instance Do not mount the database but manage metadata required tomake ASM files available for DB instances DB Instance access ASM files directly and contact ASM instanceonly for the layout of ASM files Contains no physical files like log files / control files or data files Requires only the init.ora file for startup Instance Name is ASM or ASM1.n [RAC]PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .46

ASM Components – ASM InstanceDatabase Configuration AssistantManual using SQLOracle Universal InstallerSQL startup pfile init ASM.oraPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .47

ASM Components ASM Instance ASM Disk Disk Group Failure Group ASM FilesPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .48

ASM Components – ASM Disks It is first task in ASM environment to discover and add Disks to ASMmanagementasm diskstring ‘/dev/dsk/sdc4’,’/dev/dsk/sdd’ In 10g Rel 2, Disk names are unique within Disk Group while in Rel 1 itis unique within ASM instance.SQL CREATE DISKGROUP data dg1 EXTERNAL REDUNDANCY DISK‘/dev/dsk/sdc4’,’/dev/dsk/sdd4’;SQL SELECT name FROM v asm disk;NameDATA DG1 0000DATA DG1 0001PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .49

ASM Components – ASM DisksFOREIGNCANDIDATEPROVISIONEDMeans Disk is of Oracle Object but can only be added to disk groupwith FORCE keywordMeans Disk is available to be added to any disk groupSame as CANDIDATE except that Disk is configured using ASMLIBFORMERMeans Disk was formerly part of some disk groupMEMBERMeans Disk is already part of existing disk groupPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .50

ASM Components – ASM Disk Groups CreationDatabaseConfigurationAssistantManual using SQLSQL CREATE DISKGROUP data dg1EXTERNAL REDUNDANCYdisk racleUniversalInstallerPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .51

Tablespace and Disk GroupSQL CREATE TABLESPACE indy data DATAFILE ' DATA DG1' size 100M ;Set the parameter DB CREATE FILE DEST to DATA DG1Examples: For the SID DEVDB1SQL CREATE TABLESPACE indy test tblspc DATAFILE SIZE 100M ; DATA DG1/DEVDB1/datafile/indy test tblspc.299.121212129SQL CREATE TABLESPACE TEST100 DATAFILE ' DATADG1' size 100M ; DATA DG1/DEVDB1/datafile/indy test tblspc.300.121212129SQL CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE' DATADG1/DEVDB1/datafile/temp2.tst' size 100M ; DATA DG1/DEVDB1/datafile/temp1.tstPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .52

ASMCMD – Command Line nd export ORACLE SID ASM asmcmdASMCMD ls -ltrStateTypeRebal Unbal NameMOUNTED EXTERN NNDG DATA/PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .53

File System to ASM Migration Using EM Using DBMS FILE TRANSFER Using RMAN Manually Using XMLDBPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .54

Moving from File System to ASM - EMPR Newswire It uses RMAN for themovement Job is scheduled usingDBMS SCHEDULEROracle 10g A’A’s : AWR, ADDM, ASH, ASM .55

DBMS FILE TRANSFER and ASMFile System to ASM10g R2DBMS FILE TRANSFERFile SystemASM DiskASM to File System10g R2ASM DiskDBMS FILE TRANSFERFile SystemDBMS FILE TRANSFERASM DiskASM to ASMASM DiskCOPY FILE GET FILE PUT FILE Note :Read Local File and copy it to new location on local systemContact Remote DB to read Remote file and copy it to Local systemRead Local File and contact Remote DB to copy it to remote systemThis operation can be performed directly without having to convert the datafileIt will only be used for Database files like Datafile, tempfiles,controlfiles etcPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .56

DBMS FILE TRANSFER ExampleSQL CREATE DIRECTORY NonASM AS '/export/home/oracle/data' ;Directory created.SQL CREATE DIRECTORY ASM D AS as ' DATAD G1/DEVPROF' ;Directory created.SQL begin2 DBMS FILE TRANSFER.COPY FILE(3source directory object ‘ASM D',4source file name 'spfiledevprof.ora' ,5destination directory object ‘NonASM' ,6destination file name 'spfileDEV.ora');7 end ;8 /PL/SQL procedure successfully completed.PR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .57

File System to ASM Migration Using EM Using DBMS FILE TRANSFER Using RMAN Manually Using XMLDBPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .58

QUESTIONSANSWERS

I can be reached atindy.johal@prnewswire.comfor any questionsTHANKSPR NewswireOracle 10g A’A’s : AWR, ADDM, ASH, ASM .60

PR Newswire Oracle 10g A ’s : AWR, ADDM, ASH, ASM . 21 Different types of AWR report awrrpt.sql - AWR Workload Report awrddrpt.sql - Side by Side AWR comparision awrinfo.sql - AWR Information like current Usage and Data Distribution awrload.sql - Load AWR Dump from one DB to another awrsqrpt.sql - Crea

Related Documents:

ESurvey Civil Tools - Price List A Bunch of Efficient Drafting, Analysis and Design Solutions Bringing Survey Community ESurveying Softech Together (USD) Product Perpetual License Sl. No 1 2 Quick Section 3 4 Parcel 5 6 Terms and Conditions Section within CAD package 24,000 Road Network 24,000 Land Division

dunkin-lewis, inc. horton archery llc 536 dunkin-lewis, inc. lucky craft, inc. 1336 dunkin-lewis, inc. plano inc. fall line 525 dunkin-lewis, inc. plano molding company 1342 dunkin-lewis, inc. tour star products llc 1340 dunkin-lewis, inc. windham weaponry 126 dunkin-lewis, inc. umarex usa 539 dunkin-lewis, inc. walther 130 dunkin-lewis, inc .

RingCentral Inc 27% 4.4 Pinterest Inc 24% 4.1 Zillow Group Inc 23% 6.5 NVIDIA Corp 23% 9.4 Teladoc Health Inc 22% 8.3 Uber Technologies Inc 21% 5.1 ServiceNow Inc 21% 15.9 Meta Platforms Inc 19% 4.1 Intuitive Surgical Inc 17% 14.2 Illumina Inc 17% 8.6 Alphabet Inc 16% 6.6 Microsoft Corp 16% 11.9 Amazon.com Inc 15% 7.0 Charles Schwab Corp/The 14 .

Core-Mark Holding Company, Inc. Coupa Software, Inc. Covenant Transportation Group, Inc. Cowen Inc. Criteo Crocs, Inc. Crown Crafts, Inc. CSW Industrials, Inc. CTI Industries Corporation CUI Global, Inc. CytomX Therapeutics, Inc. Dael Victoria Reyes Trust Data I/O Corporation Denny's Corporation Destination XL Group, Inc.

Title: ER/Studio Data Architect 8.5.3 Evaluation Guide, 2nd Edition Author: Embarcadero Technologies, Inc. Keywords: CA ERwin data model software Data Modeler data modeler tools data modelers data modeling data modeling software data modeling tool data modeling tools data modeling with erwin data modelings data modeller data modelling software data modelling tool data modelling

Quality Software Services Inc. QuinetiQ Group PLC (QQ) Raytheon Co. (RTN) SAIC Corp. (SAIC) SAP (SAP) Serco Inc. (SRP) SGT Inc. Sprint Corp. (S) Textron Inc. (TXT) UNICOM Government University of Texas Ventech Solutions Inc. Verizon Communications Inc. (VZ) ViaSat Inc. (VSAT) WM Robots World Wide Technology Inc. Xtec Inc. Air Force Army

neric Data Modeling and Data Model Patterns in order to build data models for crime data which allows complete and consistent integration of crime data in Data Warehouses. Keywords-Relational Data Modeling; Data Warehouse; Generic Data Modeling; Police Data, Data Model Pattern existing data sets as well as new kinds of data I. INTRODUCTION The research about Business Intelligence and Data

Financial accounting provides the rules and structure for the conveyance of financial information about businesses (and other organizations). At any point in time, some businesses are poised to prosper while others teeter on the verge of failure. Many people are seriously interested in evaluating the degree of success achieved by a particular organization as well as its . Saylor URL: http .