摘要(英) |
This study investigates the impact of implementing Oracle Exadata, a database hardware and software integrated solution, on the business operations and performance of a case company. The research adopts a case study approach, involving the researcher′s active involvement in data collection and analysis through personal engagement, reference to Oracle′s official website and technical documentation, and examination of the case company′s Oracle Exadata implementation project documents. The findings aim to provide valuable insights and recommendations for IT personnel within organizations who are evaluating database environment design or considering the adoption of integrated database appliances.
The case study starts by elucidating the reasons behind the case company′s decision to implement Oracle Exadata. Next, the planning and challenges during the implementation process is explained. Finally, the resulting changes and benefits on the case company after the successful implementation of Oracle Exadata is summarized.
The results demonstrate that the integration of the database appliance significantly enhance data access performance, optimize storage resources, provide a more stable database service environment, and reduce IT personnel maintenance efforts through cloud-based deployment and monitoring. Future research could explore the possibilities of migrating enterprise databases to the cloud. |
參考文獻 |
中文文獻:
周海濤、李永賢、張衡(譯)(2009)。個案研究設計與方法。台灣,台北:五南。(原著者:Yin, R. K. 2008. Case study research design and methods.)
網路文獻:
Amazon(2023)。「什麼是 NoSQL?」。取自:https://aws.amazon.com/tw/nosql/。存取日期:2023年5月3日。
Luke M.F(2016). Five Key Features of Oracle Exadata(2016). Retrieved May 19, 2023, from https://www.linkedin.com/pulse/five-key-features-oracle-exadata-lukasz-feldman
MBA智庫(2015)。「資料庫管理員」。取自:https://wiki.mbalib.com/zh-tw/数据库管理员。存取日期:2023年5月3日。
Mongo(2023a). NoSQL vs. SQL Databases. Retrieved May 3, 2023, from https://www.mongodb.com/nosql-explained/nosql-vs-sql
Mongo(2023b). Database Architecture Introduction. Retrieved May 10, 2023, from https://www.mongodb.com/basics/database-architecture
Oracle(2020a). rac-19c-architecture. Retrieved April 28, 2023, from https://www.oracle.com/webfolder/technetwork/tutorials/architecture-diagrams/19/rac/pdf/rac-19c-architecture.pdf
Oracle(2020b). The New Generation Oracle RAC. Retrieved May 19, 2023, from https://www.oracle.com/technetwork/database/options/clustering/overview/new-generation-oracle-rac-5975370.pdf
Oracle(2023a)。「什麼是資料庫?」。取自:https://www.oracle.com/tw/database/what-is-database/。存取日期:2023年4月19日。
Oracle(2023b)。「什麼是關聯式資料庫 (RDBMS)?」。取自:https://www.oracle.com/tw/database/what-is-a-relational-database/。存取日期:2023年4月19日。
Oracle(2023c). A Day in the Life of an Oracle Database Administrator: dba Roles and Responsibilities. Retrieved May 3, 2023, from https://education.oracle.com/fr/day-in-the-life-of-an-oracle-dba
Oracle(2023d). Celebrating a decade of innovation with Oracle Exadata. Retrieved May 4, 2023, from https://www.oracle.com/webfolder/s/assets/infographics/10-years-of-exadata/index.html
Oracle(2023e). Enterprise Manager Cloud Control Introduction. Retrieved May 19, 2023, from https://docs.oracle.com/cd/E63000_01/EMCON/overview.htm#EMCON109
Oracle(2023f). Introduction to Oracle Data Guard. Retrieved May 19, 2023, from https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/introduction-to-oracle-data-guard-concepts.html
Oracle(2023g). Oracle Exadata Database Machine Technical Architecture. Retrieved May 22, 2023, from https://docs.oracle.com/en/engineered-systems/exadata-database-machine/edbid/
Oracle(2023h). Oracle Platinum Services. Retrieved May 19, 2023, from https://www.oracle.com/assets/oracle-platinum-services-ds-1653256.pdf
Oracle(2023j). RAC One Node. Retrieved May 19, 2023, from https://www.oracle.com/tw/database/technologies/rac/racone.html
Oracle(2023k). SQL Language Reference. Retrieved May 7, 2023, from https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/index.html
Statista(2022). Volume of data/information created, captured, copied, and consumed worldwide from 2010 to 2020, with forecasts from 2021 to 2025. Retrieved May 1, 2023, from https://www.statista.com/statistics/871513/worldwide-data-created/
Study(2021). Case Study Design: Examples, Steps, Advantages & Disadvantages. Retrieved May 4, 2023, from https://study.com/learn/lesson/case-study-design.html
TechTarget(2023). Information Age. Retrieved June 6, 2023, from https://www.techtarget.com/searchcio/definition/Information-Age
Wiki(2022)。「ABC分析法」。取自:https://zh.wikipedia.org/zh-tw/ABC分析法。存取日期:2023年6月27日。
Wiki(2023). Centralized database. Retrieved May 6, 2023, from https://en.wikipedia.org/wiki/Centralized_database
Wiki(2023a). Data warehouse appliance. Retrieved May 6, 2023, from https://en.wikipedia.org/wiki/Data_warehouse_appliance
今周刊(2018)。「航空業靠大資料優化服務」。取自:https://www.businesstoday.com.tw/article/category/80393/post/201806140061/。存取日期:2023年5月1日。
知識力(2021)。「什麼是分散式資料庫?有哪些好處?」。取自:https://www.stockfeel.com.tw/什麼是分散式資料庫?有哪些好處?/。存取日期:2023年5月13日。
洪鉦哲(2021)。「台灣中小型企業數位轉型的評量與診斷-定位、評估與起始」。取自:https://mymkc.com/article/content/23523。存取日期:2023年5月1日。
鄭永祥(2017)。「工業4.0時代來臨:工業4.0在交通上的應用」。取自:https://scitechvista.nat.gov.tw/Article/c000003/detail?ID=4cc4c9c4-8f63-4073-8e8c-266643257637。存取日期:2023年5月1日。
鄭欣如(2020)。「NoSQL入門介紹及主要類型資料庫說明」。取自:https://www.tpisoftware.com/tpu/articleDetails/2016。存取日期:2023年05月30日。 |