Posts

Showing posts with the label Oracle

5 HBase Vs. RDBMS Top Functional Differences

Image
Here're the differences between RDBMS and HBase. HBase in the Big data context has a lot of benefits over RDBMS. The listed differences below make it understandable why HBASE is popular in Hadoop (or Bigdata) platform.  5 HBase Vs. RDBMS Top Functional Differences Here're the differences unlock now. Random Accessing HBase handles a large amount of data that is store in a distributed manner in the column-oriented format while RDBMS is systematic storage of a database that cannot support a random manner for accessing the database. Database Rules RDBMS strictly follows Codd's 12 rules with fixed schemas and row-oriented manner of database and also follows ACID properties. HBase follows BASE properties and implements complex queries. Secondary indexes, complex inner and outer joins, count, sum, sort, group, and data of page and table can easily be accessible by RDBMS. Storage From small to medium storage application there is the use of RDBMS that provides the solution with MyS

4 Top built-in functions in SQL with Examples

Image
You can find there are four different types of functions in SQL. All these functions are built-in functions. You no need to create these functions, and these come with your SQL. I am discussing today the  SQL functions List . SQL functions DATE-TIME functions Numeric functions Char functions Null-related functions 1. DATE-TIME functions These functions are useful to get DATE and Time. Also, you can covert the DATE and TIME to Char. These are TO_CHAR, CURRENT_DATE, and CURRENT_TIME. 2. Numeric Functions These functions you can use for numeric calculations. Those are TRUNC, SIGN, ROUND, ABS. 3. Char Functions To handle string related tasks you can use CHAR functions. The CHAR functions are like SUBSTR, CONCAT, LENGTH. 4. NULL related functions To handle null values you can use different functions. Those are COALESCE, NVL, NULLIF This post covered all your answers for the SQL functions list, SQL built-in functions in Oracle, and SQL functions in any DBMS.

Hyperion: How to Learn as Alternative for Mainframe

Image
Oracle Hyperion is a reporting tool. Its applications are Capital management, Asset planning, Workforce planning and more. Photo Credit: Srini Books to Read on Hyperion The Oracle Hyperion Financial Reporting 11 covers all basics to learn financial reporting using Hyperion tool. The popular contents are Explore Grids and the Point of View Create Functions and Formulas Master Conditional Formatting and Conditional Suppression Create Dynamic Books and Batches Import Reporting Content into MS Office with Oracle Smart View

Oracle flash storage system top features to read today

Image
Oracle flash storage is faster than other storage systems. This post tells why flash storage you need and the special features of flash storage from oracle. Customers today are facing a triad of issues requiring higher performance from their storage systems such as More server and application virtualization, Faster servers and scale-out applications and Latency-sensitive applications. Flash storage is seen as the solution to these issues because it delivers the desired higher performance.  But does all of your data need flash media?  What if there were “a smart and self-optimizing” storage system that automatically moves data across different media depending not only on frequency of usage, but also on the application’s performance requirements, media cost, and business value? Introducing Oracle FS1 Flash Storage System. How is Oracle FS1 Flash Storage System Different? Oracle FS1 intelligently delivers flash performance when you need it and reduces costs by moving data

Oracle Hyperion Reporting Basic Tutorial

Image
Interactive Reporting is an extremely robust and powerful business intelligence tool providing ad-hoc querying, data analysis, dashboards, and other reporting capabilities. Oracle Hyperion Financial Management Business analysts access the software through the EPM Workspace, a central location for viewing and managing content across all of the Hyperion products. The product is extremely flexible and provides analysts with the ability to quickly analyze data and produce deliverables. The software provides a consistent platform for managing content, where documents can be customized, saved, and shared across an organization. What is BQY When working with Interactive Reporting, it is hard to escape the term BQY. BQY or BrioQuery, is the extension given to all Interactive Reporting document files. Developers create BQY files using the Workspace, Interactive Reporting Web Client, or Interactive Reporting Studio—a developer tool used to create and manage BQY documents outside