Accounting Information Systems - Postgresql Term Paper

PAGES
8
WORDS
2140
Cite

Application Development and Interface Customization for Accounting & Finance

The core aspects of this area of analysis are supported for embedded SQL, support for standard and embedded interfaces, support for XML and Web integration technologies. Many enterprises program their own native SQL applications for analyzing and reporting their financial results. The use of embedded SQL in financial accounting and analysis has become commonplace as mobile-based platforms have become more commonplace throughout the senior management teams of corporations (McCombs, Sharifi, 73). Support for standard and embedded interfaces has also grown exponentially with the rising interest in using Apple iPads as devices for quickly checking accounting and financial reports as well. Finally support for Web and XMLK-based technologies is also driven by enterprise's needs to create highly customized accounting and financial analysis applications. All of these aspects of an accounting and financial system put increased demands on the database architectures used to support them. Comparing PostgresSQL and Oracle 11i on each of these attributes shows that the latter is superior on each attribute with the exception of creating mobile device interfaces in real-time, and support for Web-based interfaces across multiple could-based platforms (Kong, Li, Feng, et.al.). Open source platforms have a slight edge on this attribute given the open innovation nature of the platform and the continued investment in these technologies by Linux distribution partners.

Reliability and Pricing as an Accounting and Finance Platform

While both PostgresSQL and Oracle 11i support ACID compliance (Duggan, et. al.), Oracle 11i has more support for fault tolerance and recovery from logic errors in handling financial reporting and analysis. Oracle has shown to be more effective in managing variations in transaction workloads as well (?avka, Miki?, Sari?, et.al.). Reliability of each database has also been tested through a variety of benchmarks including use in cloud configurations and Oracle has proven to be more reliable due to the fault recovery support in the structure of their databases (Kong, Li, Feng, et.al.). For the CFO this is critically important because it can...

...

"Database Security-Concepts, Approaches, and Challenges. " IEEE Transactions on Dependable and Secure Computing 2.1 (2005): 2
Jeanette Burriesci. "Recipe for revenue" Intelligent Enterprise 31 Aug. 2001:

avka, M., M. Miki? And D. Sari?. "Application Cluster Environment for Business Processes." MIPRO 2011-34th International Convention on Information and Communication Technology, Electronics and Microelectronics - Proceedings. SCOPUS. 8 Nov. 201

Duggan, J., et al. "Performance Prediction for Concurrent Database Workloads." Proceedings of the ACM SIGMOD International Conference on Management of Data.

Chantola Kit, Toshiyuki Amagasa, Hiroyuki Kitagawa, (2009) "Algorithms for structure-based grouping in XML-OLAP," International Journal of Web Information Systems, Vol. 5 Issue: 2, pp.122 -- 150

Kong, S., Y. Li and L. Feng. "Flexible Control of Performance and Expenses for Database Applications in a Cloud Environment." CLOSER 2011 - Proceedings of the 1st International Conference on Cloud Computing and Services Science.

Gary B. McCombs, and Mohsen Sharifi. "Design and implementation of an ERP oracle financials course. " The Journal of Computer Information Systems 43.2 (2002): 71-75.

Wai Yin Mok. "Designing nesting structures of user-defined types in object-relational databases. " Information and Software Technology 49.9/10 (2007): 1017.

Salomie, T. -L, et al. "Database Engines on Multicores, Why Parallelize when You can Distribute?" EuroSys'11 - Proceedings of the EuroSys 2011 Conference.

X Zhou, PE Chaudhry, Z Zhu, and F. Li. "Development of a financial management system in a CIMS environment. " International Journal of Production Research 43.12 (2005): 2603

Sources Used in Documents:

References

Elisa Bertino, and Ravi Sandhu. "Database Security-Concepts, Approaches, and Challenges. " IEEE Transactions on Dependable and Secure Computing 2.1 (2005): 2

Jeanette Burriesci. "Recipe for revenue" Intelligent Enterprise 31 Aug. 2001:

avka, M., M. Miki? And D. Sari?. "Application Cluster Environment for Business Processes." MIPRO 2011-34th International Convention on Information and Communication Technology, Electronics and Microelectronics - Proceedings. SCOPUS. 8 Nov. 201

Duggan, J., et al. "Performance Prediction for Concurrent Database Workloads." Proceedings of the ACM SIGMOD International Conference on Management of Data.


Cite this Document:

"Accounting Information Systems - Postgresql" (2011, November 08) Retrieved April 19, 2024, from
https://www.paperdue.com/essay/accounting-information-systems-postgresql-47261

"Accounting Information Systems - Postgresql" 08 November 2011. Web.19 April. 2024. <
https://www.paperdue.com/essay/accounting-information-systems-postgresql-47261>

"Accounting Information Systems - Postgresql", 08 November 2011, Accessed.19 April. 2024,
https://www.paperdue.com/essay/accounting-information-systems-postgresql-47261

Related Documents

Accounting Information Systems The Influence of External Factors On Routine ERP Usage The most mission-critical accounting information systems coordinate Accounts Payable (AP) and Accounts Receivable (AR), in addition to orchestrating the many activities of an enterprise across its value chain. The long-term quality of information provided by any accounting information system is predicated on how well the procedures, processes and workflows have been designed to support the value chain structure over the long-term

Accounting Information Systems have emerged as very famous components of modern businesses mainly because they offer beneficial and timely information to management in addition to being cost-effective. Generally, these systems are helpful in book account payables, cash transactions, receivables, and every other accounting function in an orderly manner. The need for an effective accounting information system in an organization is attributed to the huge volume of data handled by accounting

Accounting Information System: Role of Relevance and Reliability in the Conceptual Framework The development any system, whether manual or automated, requires a conceptual framework that serves as the foundation for the establishment of requirements, policies, standards and procedures. From the conceptual framework, the various applications can be developed and when these proved to be effective and efficient, best practices are established and become the model for other systems to follow. Developing an

This model could then be customized for the needs of the different companies. Sankaran and AlHashim (2006) make a compelling case regarding the need for harmonized accounting standards and practices. In addition to the globalized economy, they also rightly point to the benefits of such harmonization for corporations - including a greater ability to keep track of expenses and a better way of reconciling different accounting practices in its branches

This would immediately flag the loans going outside their own bank and also provide greater insights into how customers were using funds over time. Another approach is to incent auditors to find fraud and embezzlement and make it widely known in the bank that anyone finding illegal practices would receive a reward up to 20% of the error found. Auditors, who are traditionally not paid that much, would work

In the event of a recall or price protection program on any product, given the rudimentary nature of how Kudler's is managing their systems, they would not be able to react quickly. Instead the reaction would be manual and very slow, and costly to complete. There are the systemic or basic threats the company would face. If the company chose to use SaaS-based applications there is the high dependency