Databases in the Organization I Term Paper

Total Length: 1073 words ( 4 double-spaced pages)

Total Sources: 3

Page 1 of 4

Today Selectica's logic for managing Microsoft SQL Server is also built into the IBM WebSphere product, making my company's level of integration all the more reliable and scalable. With pricing in SQL Server and the many processes of order management dependent on a variety of oracle databases, and our content management system based in Documentum/EMC our company is concerned about having too many databases to support over the long-term. Despite the fact that special pricing requests can specifically be managed electronically, giving our company a competitive advantage, there needs to be greater levels of system integration to allow for higher performance of this specific process (Columbus, 2003)

As a result, the CIO has talked of moving to a Services-Oriented Architecture (SOA) and creating a database standard to minimize potential performance, compatibility and integration issues in the future. The SOA initiative in our company is looking at Oracle Fusion, Microsoft.Net and SAP's NetWeaver architectures. While it is doubtful our company will move to just one database standard, an SOA platform will give us more flexibility in how we define process workflows in order management for example, which is an area that our company is grappling with today in terms of getting greater performance.
While our company does have many different databases, today they are coordinated through having them all align to specific business processes first.

Recommendations for improvement

The following are three suggested improvements to the database strategies and architecture our company uses today:

Work to bring pricing into the Oracle database to make order management more efficient. Today the Oracle databases need to get their pricing data through adapters and connectors to SQL Server, and this is slowing down pricing strategy work. Using Selectica for pricing optimization however is working well.

Work to create more product taxonomies in the Oracle database to begin standardizing the production of custom products today. As more and more custom orders are generated through the sales force, consider creating specific taxonomies for the most popular ones and making them mainstream products. This is supported by research into both product configuration and the need for database integration throughout distribution-channel facing systems (AMR Research, 2003; Columbus, 2003)

Piloting an SOA platform for greater integration of content management, pricing, supply chain and order management systems is necessary to benchmark the performance possible using this new approach to aligning systems processes to business goals......

Show More ⇣


     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Databases In The Organization I" (2007, September 03) Retrieved May 18, 2024, from
https://www.aceyourpaper.com/essays/databases-organization-35984

Latest MLA Format (8th edition)

Copy Reference
"Databases In The Organization I" 03 September 2007. Web.18 May. 2024. <
https://www.aceyourpaper.com/essays/databases-organization-35984>

Latest Chicago Format (16th edition)

Copy Reference
"Databases In The Organization I", 03 September 2007, Accessed.18 May. 2024,
https://www.aceyourpaper.com/essays/databases-organization-35984