| Title | Date Added | Company | |
|---|---|---|---|
![]() |
On BULK COLLECT | 2008-03-01 | Oracle |
| The most important thing to remember when one learns about and start to take advantage of features such as BULK COLLECT is that there is no free lunch. There is almost always a trade-off to be made somewhere. The tradeoff with BULK COLLECT, like so many other performance-enhancing features, is "Run faster but consume more memory." Specifically, memory for collections is stored in the Program Global Area (PGA), not the System Global Area (SGA). SGA memory is shared by all sessions connected to Oracle Database, but PGA memory is allocated for each session. | |||
![]() |
Declarative Data Filtering | 2008-03-01 | Oracle |
| In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema.
Tags: Application Development |
|||
![]() |
Solutions Provider Increases Productivity by 20 Per Cent With New Development Tools | 2008-03-01 | Microsoft |
| To enhance productivity and product quality, Microsoft Gold Certified Partner SMART wanted to upgrade the technologies on which its workforce management solutions were based. By redeveloping its eHuman Logistics solutions on the Visual Studio 2008 development system and Microsoft .NET Framework 3.5, the business is taking advantage of new development tools and enhancements to increase productivity by up to 20 per cent, accelerate time to market, and significantly reduce system bugs.
Tags: .NET, Windows Server 2008 |
|||
![]() |
Eurogroup Ensures Stable and Secure Network Interaction Across 34,000 Member Enterprises | 2008-03-01 | Oracle |
| Eurogroup was established in 1999 to provide small- and medium-sized enterprises with credit and corporate consulting services. Eurogroup wanted to have only one database for Eurofidi and Eurcons and reduce time for financing authorization. The challenge was to provide an IT platform capable of tight integration with other legacy systems and guarantee stability and flexibility of the IT infrastructure. Eurogroup ensured the stability and security of Eurogroup's data infrastructure with Oracle Database as well as enabled successful interaction between Eurogroup and 34,000 member enterprises served by a network of 26 offices in eight different regions.
Tags: Database Applications, Data Recovery - Security |
|||
![]() |
eServGlobal Boosts Growth Potential and Cuts Development Costs With Embedded Database | 2008-03-01 | Oracle |
| eServGlobal (LSE: ESG & ASX: ESV) invents smart communication and payment solutions to help telecommunications service providers operating on all-generation networks to grow new revenues, reduce churn, and lower costs. eServGlobal wanted to embed unbreakable database and middleware technologies into solutions to develop advanced, robust, real-time end-user facing services with uncompromising flexibility and reliability and avoid the cost and risk of developing proprietary software. The challenge was to minimize development costs and speed solution time to market and respond rapidly to dynamic market changes and enable service providers to evolve seamlessly to new network architectures. eServGlobal selected Oracle's turnkey, carrier-class database and data management solutions on which to develop real-time, mission-critical solutions and leveraged Oracle Real Application Clusters to ensure tolerance, performance, and scalability.
Tags: Database Applications |
|||
![]() |
Anhui Telecom Improves Processing Performance of Online Charging System by an Increase of 150 Times | 2008-03-01 | Oracle |
| Anhui Telecom Company Limited is a wholly-owned subsidiary of China Telecom, the largest fixed service telecommunications provider in China. Anhui Telecom wanted to implement an online charging system that incorporates the company's 3G operations and eliminate processing issues that were affecting the performance of the system. The challenge was to ensure a smooth implementation to avoid business impacts and simplify database management tasks to minimize costs. Anhui Telecom deployed Oracle TimesTen In-Memory Database to underpin the online charging system, ensuring powerful, reliable data processing capacity and gained an integrated, whole-of-business billing system that supports more than 10 million customers.
Tags: Database Applications |
|||
![]() |
Infomercati Modernizes and Automates Business Processes to Increase Operational Efficiency | 2008-03-01 | Oracle |
| Infomercati is an obligatory association established in Italy under a 1996 law requiring creation and management of an information system for wholesale food and agriculture markets. Infomercati wanted to deploy a single tool for recording the prices of food and agricultural products, such as produce, fish, flowers, and meat and catalogue the prices recorded in order to compare price lists and permit statistical analysis. The challenge was to ensure rapid information availability outside of the association. Infomercati created the Infomercati SIMA system to centrally store data - including quantity, cost by product and zone, and the number of transactions per market - for all products sold on Italy's food and agriculture markets as well as implemented the Oracle platform for development of a Web-based open standard solution.
Tags: Application Development |
|||
![]() |
Delivering Affordable Information Management Functionality: Oracle Database Standard Edition One | 2008-02-26 | Oracle |
| Databases have become key in enabling businesses to efficiently manage their data assets and to effectively use information to better understand their businesses. This document considers the question of what is needed for small and medium-sized businesses (SMBs) to successfully implement and maintain database applications,
considering limitations of budget, time, and expertise. It considers such issues as ease of installation, ease of use, reliability, and manageability of relational database management systems (RDBMSs). It also explores how Oracle has delivered such capabilities with Oracle Database Standard Edition One.
Tags: Database Applications |
|||
![]() |
Poseidon Makes Obtaining Reports More Efficient With Business Intelligence | 2008-02-01 | Oracle |
| Bostads AB Poseidon wanted to improve the analysis tool in order to be able to compile flexible, quality-assured financial reports and create the opportunity to compile reports which combine information from different source systems. The challenge was to replace resource-hungry manual routines for information processing with automated processes and meet requirements for reporting to the parent company and authorities. Bostads AB Poseidon implemented Oracle Warehouse Builder to create a database which obtains, processes, and quality-assures information from different source systems and introduced Oracle Business Intelligence Suite Enterprise Edition to make information accessible to users in the form of flexible reports and analyses.
Tags: Business Intelligence - Data Warehousing |
|||
![]() |
Agistix, Inc. Provides Additional Layer of Security to Online Transactions Without Sacrificing Performance | 2008-02-01 | Oracle |
| Agistix, Inc. is the leading provider of on-demand, carrier-neutral global logistics management solutions that enable companies to gain visibility and control of their global shipment process. Agistix, Inc. wanted to implement a solution with the ability to provide an additional layer of security to protect customer shipping data without impeding the user experience. The challenge was to minimize the impact of the security solution deployment on engineering resources and the company's network infrastructure. The company deployed Oracle Adaptive Access Manager to create a solution that provides strong security without having a negative impact on application performance or usability. It also increased security with the capability to verify multiple factors - such as the user's computer, location, and online behavior - to confirm user identity.
Tags: Network Security, Security Management |
Careers at Accenture
Immediate job opportunities at Accenture – Apply Now!
Webcast: Maximizing Data Protection with Disk-Based Backup
Register to attend this webcast and learn why data protection is critical to your business.
Compare your IT salary
Sign-up for free download of IT salary benchmark report 2008.