Databases In The Organization I Term Paper

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.

...

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.

Sources Used in Documents:

References

AMR Research (2003) - Configuration is the Heart of Customer Fulfillment for Complex Product Manufacturers. AMR Research Report. Monday March 31, 2003. Retrieved from the Internet on September 3, 2007 at http://lwcresearch.com/filesfordownloads/ConfigurationIstheHeartofCustomerFulfillmentforComplexProductManufacturers.pdf

Askegar and Columbus (2002) - Channel Management Best Practices: It's All About Orders. AMR Research Report. Monday September 9, 2002. Retrieved from the Internet on September 3, 2007:

http://lwcresearch.com/filesfordownloads/SqueezetheRevenueOutofSPRs.pdf

Columbus (2003) - Squeeze the revenue out of your Special Pricing Requests. AMR Research Alert. Tuesday November 11, 2003. Retrieved from the Internet on September 3, 2007:
http://lwcresearch.com/filesfordownloads/SqueezetheRevenueOutofSPRs.pdf
http://lwcresearch.com/filesfordownloads/SellSideECommerceMarketIsAllAboutIntegration.pdf


Cite this Document:

"Databases In The Organization I" (2007, September 03) Retrieved April 26, 2024, from
https://www.paperdue.com/essay/databases-in-the-organization-i-35984

"Databases In The Organization I" 03 September 2007. Web.26 April. 2024. <
https://www.paperdue.com/essay/databases-in-the-organization-i-35984>

"Databases In The Organization I", 03 September 2007, Accessed.26 April. 2024,
https://www.paperdue.com/essay/databases-in-the-organization-i-35984

Related Documents

Database Data Warehousing Design Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and

Organizational Analysis of Google Google is a high-tech organization with appealing rates of growth beneficial to shareholders. Inherent with its development, Google faces notable challenges. This study will focus on the situation facing the company besides exploring the competition it faces from rival firms in the industry. This study also provides positive and feasible recommendations for the leaders of the organization to consider. Besides the issues facing the company, the outstanding

Organizational Problem Example of an Organizational Problem An Analysis of a Failed IT Project at the Los Angeles Unified School District Case Overview In January of 2007, the Los Angeles Unified School District began using a new ninety five million dollar IT enterprise system built by SAP with Deloitte Consulting managing the project (Bowers, 2009). The system was built because the entire existing infrastructure was outdated and consisted of a variety of different software

Database Modeling and Normalization Entity Relationship Model (ERM) Diagram is a data model used to describe the database in an abstract method. The relational database stores data in table. The entity in the database could point to several entries. For example, employee is an entity in the relationship database, and a diagram used to create the entity in the database is called entity-relationship diagrams or ER diagrams. (Silberschatz, Korth, 2006). Objective of

Organizational Cultures: Annotated Bibliography and Summary Annotated Bibliography Aronson, Z. And Patanakul, P. 2012. "Managing a group of multiple projects: do culture and leader's competencies matter?" Journal of the Knowledge Economy, 3(2): pp. Web. Retrieved from: LexisNexis Database. [Accessed on 21 May This article focuses significantly on how team culture within an organization is a pivotal factor that contributes to a team being able to successfully complete a project. A focus is made on

Database Presentation
PAGES 5 WORDS 1460

Database Presentation The objective of this study is to present a new database to be implemented in the clinical setting to increase quality and safety of patient care. The database at focus in this work in writing is that of the Targeted Therapy Database (TTD) in a Cancer unit in a hospital. The work of Mocellin, et al. (2010) relates that the "efficacy of current anticancer treatments is far from satisfactory and