Verified Document

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.

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

Columbus (2002) - the Sell-Side E-Commerce Market: It's All About Integration. AMR Research Report. Monday April 1, 2002. Retrieved from the Internet on September 3, 2007:

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

Sources used in this document:
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:
Copy Bibliography Citation

Related Documents

Databases and Data Management Every Day, Nurses
Words: 1498 Length: 4 Document Type: Essay

Databases and Data Management Every day, nurses health care practitioners challenged managing large quantities data information. Unless data information translated knowledge, meaningful . Databases data management techniques, designed effectively, present health care organizations Epic database is designed for large health care organizations. The database captures data related to patient care in a health care organization. The database facilitates patient registration, treatment scheduling, lab test results, radiology information, and billing. The database is

Databases Are Essential to the
Words: 960 Length: 3 Document Type: Term Paper

I will have access to this database so that I can correctly and quickly inform clients or vendors about the status of their products. The products inventory database should include item/SKU number; date of acquisition; quantity in stock; item description; number of pending orders from clients; number of pending orders from vendors; cost; selling price; and weight, for the purposes of shipping and receiving. If we maintain the products

Databases Benefits and Limitations of
Words: 355 Length: 1 Document Type: Term Paper

These personal productivity systems also tend to be islands of customer data that need to be integrated into larger customer information systems to be effective (Zahay, 2008). Enterprise-class DBMS are capable of integrating to broader process workflows due to their underlying technical design. In addition, these DBMS are often used for more advanced customer strategies including data mining, business analytics of customer bases, and the development of long-term loyalty

Databases Some of the Many
Words: 1158 Length: 4 Document Type: Term Paper

Microsoft supports distributed component objects via distributed COM (DCOM). DCOM use remote procedure calls to organize data between processes and computers so that components appear to have the same word size, bit orientation, and address space. DCOM is a direct competitor to CORBA, discussed next. V. Common Object Request Broker Architecture (CORBA) CORBA is OMG's open, vendor-independent architecture and infrastructure that computer applications use to work together over networks (CORBA Basics). Using

Databases in the Workplace
Words: 799 Length: 3 Document Type: Term Paper

Databases in the Work Place We are in the information age and the effective management of data is paramount in almost all aspects of our life. All businesses today thrive on the availability of vast pool of data pertaining to their domain and thus databases constitute an indispensable aspect of all businesses. Having access to a huge database and the intelligent interpretation of the data therein holds the key to business

Organizational Quality Improvement Focus Area
Words: 1268 Length: 4 Document Type: Research Paper

In this regard, it is vitally important that leadership communicate effectively with staff, with particular focus on the fact that quality improvement in patient databases means improved quality in health care. This is good not only for patients, but also for the reputation of the Center, and by association for the staff working with patients as well. In order to further increase the effectiveness of the PDCA model, the Hospital

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now