透過您的圖書館登入
IP:3.231.217.209
  • 期刊

資料庫複寫支援協同商務與協同作業效能評估

The Performance Evaluation of Selling Collaboration Use Database Replication

摘要


本論文是以資料庫複寫支援協同商務,大量資料可迅速有效分享,資料可立即同步,也可分享多媒體資料,更不需要複雜的介面程式來做解譯的工作,資料內容與格式完全統一,而且資料庫的使用,有使用者認證與授權的保護,資料相當安全不易被竄改竊取,非常適合協同商務的操作,與數位媒體的協同設計之需要。本研究並針對協同商務中,行銷/銷售協同作業、規劃/預測協同作業兩項協同商務,以資料庫複寫爲技術的核心達成資料共享,奠定一個有效的執行平台,爲資料分享提出安全有效率的解決方法,並以企業營運總部運籌管理電子化的設計理念,提出配銷應用運籌管理的應用範例,並建立企業營運總部與經銷商資料同步的相關技術,獲得不錯的執行績效,此項技術可加以無限擴展支援企業營運總部運籌管理電子化的所有要求。我們整合複寫、資料倉儲、OLAP、多維度分析、無線設備微型資料庫同步技術,建構企業營運總部運籌管理的基礎架構,在無線網路的環境下,以多樣化的多維度資料分析介面,提供高階管理者決策支援的資訊系統。論文中並對各種不同型式的資料庫複寫,以不同的資料筆數詳細記錄其執行效能,收集的數據可提供資料庫複寫規劃考量時做參考,是評估資料庫複寫效率重要的依據。

並列摘要


In this paper, we design and implement a database replication for providing collaborative commerce. According to the challenge of globalization, the enterprise must expand their operation model and enterprise flow from individual entity to strategic alliance and partners. The Collaborative Commerce (CC) provides a virtual platform for strategy modeling and allows collaboration on product design, marketing, logistical, service and information sharing among different members. Based on the database replication model, we develop a B2B process integration prototype system which shows that the business process model is feasible and suggests a possible solution for real-time and efficient B2B electronic commerce. The research is to develop a collaborative environment based on the database replication. This paper discusses our experiences in developing a database replication infrastructure for creating and operating collaborative mobile commerce framework. For the purpose of the Collaborative Commerce is to solve Enterprise in the globalization competition and the shortening of product life cycle. They must use Information Technology to integrate their and partner's resources and information exchange to respond consumer request. The result shows that database replication will enhance partner dependence and interaction in partner coordination, also enhance their performance. The demand of wireless information access for the more mobile workers is increasingly in an enterprise. However, the current enterprise information systems were not designed to support the information access of mobile users. Therefore, they are unable to satisfy the needs of mobile users and the information presentation requirements in mobile devices. Integrating the wireless technology, mobile devices, and enterprise information systems to support the communication, coordination and collaboration of mobile users is very important. Microsoft SQL Server 2000 replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases for consistency. Using replication, we can distribute data to different locations, to remote or mobile users over a local area network, using a dial-up connection, and over the Internet. Replication also allows we to enhance application performance, physically separate data based on how it is used (for example, to separate online transaction processing (OLTP) and decision support systems), or distribute database processing across multiple servers. Replication offers various benefits depending on the type of replication and the options we choose, but the common benefit of SQL Server 2000 replication is the availability of data when and where it is needed. Other benefits include: (1) Allowing multiple sites to keep copies of the same data. This is useful when multiple sites need to read the same data or need separate servers for reporting applications. (2) Separating OLTP applications from read-intensive applications such as online analytical processing (OLAP) databases, data marts, or data warehouses. (3) Allowing greater autonomy. Users can work with copies of data while disconnected and then propagate changes they make to other databases when they are connected. (4) Scale out of data to be browsed, such as browsing data using Web-based applications. (5) Increasing aggregate read performance. (6) Bringing data closer to individuals or groups.

被引用紀錄


盧福雄(2012)。使用資料複寫與觸發程序技術整合企業資訊系統之研究-以某企業為例〔碩士論文,朝陽科技大學〕。華藝線上圖書館。https://www.airitilibrary.com/Article/Detail?DocID=U0078-1511201214172541

延伸閱讀