Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

MT-OSRS_Office

No description
by

karthees k

on 2 July 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of MT-OSRS_Office

Kartheeswaran Kalidass
18.Jun.2013

Reporting Solution For Order Management System:
An Open Source Approach

Thank you
Choose a Open source reporting framework
Shortlisted OS reporting frameworks:
Questions?
References
1. http://www.kompetenzzentrum-kastellaun.de/images/visual_reporting.jpg
2. http://booksbyjason.files.wordpress.com/2011/08/checklist.gif
3. http://siliconangle.com/files/2012/04/pentaho.jpg
4. http://assessmentglobal.com/wp-content/uploads/2012/06/Spagobi_2.jpg
5. http://community.jaspersoft.com/sites/default/files/styles/project_icon/public/projects/icons/js_reports-server_rg2_0.png
6. https://ayla.hs-heilbronn.de/~student/images/hslogo.gif
7. http://upload.wikimedia.org/wikipedia/de/thumb/7/7f/Deutsche_Telekom-Logo.svg/800px-Deutsche_Telekom-Logo.svg.png
8. Cruz, D., Wieland, T. and Ziegler, A. (2006), Evaluation criteria for free/open source software products based on project analysis. Softw. Process: Improve. Pract., 11: 107–122. doi: 10.1002/spip.257
9. http://onproductmanagement.net/wp-content/uploads/2010/10/why-us.jpg
10. http://www.software.ac.uk/software-evaluation-guide
http://www.oss-watch.ac.uk/resources/tips
Jasper Reports Server
Chosen framework is ...
Evaluation Criteria:
Transform XML data into relational structure:

Parsing

JAXB
Approach 1: HyperJAXB

Approach 2: JAXB with JPA

Approach 3: JAXB, JPA with Eclipse Dali
Approach 1: HyperJAXB
Approach 2: JAXB with JPA
Approach 3: JAXB,JPA with Eclipse Dali
OMS: Single stop for all order requests / status.
Need for new reporting system:
Order Phone
Tariff change
Change
address
Prototype
Challenges:
[6]
[7]
OMS - High level block diagram
[5]
[6]
[7]
[8]
1. Functional
(Coverage of required functionalities, ...)
2. Technical
(Target Platforms Supported, Reliability, Security...)
(Community Exists,Sufficient Support Available, ...)
3. Organizational
4. Legal
Economical
(Licensing , No Patent Infringements, ...)
1..n requests
(Well Reputed Companies are Involved, Climate in Discussion Forums, ...)
Political
Advantages:
Criteria to shortlist:
Is support(community) available?

Features available

Ongoing activities (bug fixes, road map, last version released date)

Is documentation available?

Is support(commercial) available?
(Less development effort, Productivity increase)
(relational persistence for JAXB objects)
[2]
Advantages
Disadvantages:
Poor control over database entities and high migration effort, Low maintainability
Drawbacks in existing system.
Optimizing sales campaigns
Sales monitoring
Performance monitoring
On-time reports for
No distributed web infrastructure
Performance overhead using same DB
Static reports by e-mail
Time consuming (xQuery on large number of xml data)
No on-time reports
Also, Business users to create own reports
High level block diagram of developed prototype
More automated
Disadvantages
Better control over database
Poor control over database entities and high migration effort, Low maintainability
DB structure and xml schema are loosely coupled,
Full control over database,
Higher maintainability
Short-list 3 OS reporting frameworks.
Evaluate (criteria and tutorial based )
Choose one
[10]
Prepare data for the reporting schema
Transform xml data into relational format
Evaluate different approaches to transform - prototyping
Choose one
(With SpagoBI and Approach3)
1. Matured server infrastructure

2. User friendly worksheets

3. Highly extensible (Jasper, BIRT, BO etc)
Highlights:
"Cruz, D., Wieland, T. and Ziegler, A. (2006), Evaluation criteria for free/open source software products based on project analysis. Softw. Process"
Is support(community) available?
Features available?
Ongoing activities (bug fixes, road map)
Is documentation available?
Introduction
(Order Management System)
1. XML
schema
->(
JAXB
)-> Java class->(
JPA
)-> map to relational database tables

2. XML
data
-> (
JAXB
)-> Java object -> (
JPA
) -> store in tables
Highlights:
[3]
[4]
[5]
[4]
[2]
[9]
[1]
70.95
53.45
45.85
scores
Full transcript