Saturday, 13 July 2013

Latest Technology in IT


Latest technology in IT:
Oracle:                                                                     

  The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files ("datafiles").Tablespaces can contain various types of memory segments, such as Data Segments, Index Segments, etc. Segments in turn comprise one or more extents. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage. Newer versions of the database can also include a partitioning feature: this allows the partitioning of tables based on different set of keys. Specific partitions can then be easily added or dropped to help manage large data sets. Partitioning is useful for very large tables. 
The Sub department of Oracle is, 
ü SQL
ü PLSQL               
ü FORMS AND REPORT     
ü ORACLE DBA
ü ORACLE 10G RAC
ü SQL TUNING   
ü PERFORMANCE TUNING
ü ORACLE APPS TECHNICAL

IBM WEBSPHERE:                                           
                             IBM WebSphere MQ facilitates application integration by passing messages between applications and Web services. It is used on more than 35 hardware platforms and for point-to-point messaging from Java™, C, C++ and COBOL applications.Most large organizations today have an inheritance of IT systems from various manufacturers, which often makes it difficult to share communications and data across systems. Many of these organizations also need to communicate and share data electronically with suppliers and customers–who might have other disparate systems. It would be handy to have a message handling tool that could receive from one type of system and send to another type.Where data held on different databases on different systems must be kept synchronized, little is available in the way of protocols to coordinate updates and deletions and so on. Mixed environments are difficult to keep aligned; complex programming is often required to integrate them. Message queues, and the software that manages them, such as IBM WebSphere MQ for z/OS, enable program-to-program communication.

Hyperion:                                                
Hyperion Planning is a flexible Web and Microsoft Office based planning application that supports enterprise wide planning, budgeting, and forecasting. Oracle Hyperion Planning provides a rich planning and modeling framework that supports driver based planning to help connect operational assumptions to financial outcomes. It supports a hierarchical planning process that encompasses both corporate finance and the lines of business within an enterprise. With Oracle Hyperion Planning, you can meet your immediate financial planning, budgeting and forecasting needs while enabling a platform for future cross-functional expansion and automated process integration.

TERADATA:                                                         
                             Teradata Corporation is an American computer company that sells database software for data warehouses and analytic applications, including Big Data. Its products are meant to consolidate data from different sources and make the data available for analysis. Teradata RDBMS is a complete relational database management system. The system is based on off-the-shelf Symmetric Multiprocessing (SMP) technology combined with a communication network connecting the SMP systems to form a Massively Parallel Processing (MMP) system. BYNET is a hardware inter-processor network to link SMP nodes. All processors in a same SMP node are connected by a virtual BYNET.

INFORMATICA:                                                 
                             It is a type of data mining. Informatica's product portfolio focused on Data Integration: Application Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Enterprise Data Integration, Master Data Management, Messaging; currently at version 9.5.

OBIEE:                                                              
Oracle Business Intelligence Foundation Suite (OBIEE+ and Essbase) is a complete, open, and architecturally unified business intelligencesystem for the enterprise that delivers abilities for reporting, ad hoc query and analysis, online analytical processing (OLAP), dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, enterprise resource planning (ERP) and customer relationship management (CRM) applications, mobile devices, and Microsoft Office applications.
Sometimes OBIEE is used interchangeably with Oracle Business Intelligence Applications (OBIA), which is a pre-built BI and data warehousing system built on the OBIEE technology stack, however OBIEE is the platform whereas OBIA is an application that uses the platform. The OBI EE Plus integrates the components of the toolset to include a service-oriented architecture, data access services, an analytic and calculation infrastructure, metadata management services, a semantic business model, a security model and user preferences, and administration tools.

 DATASTAGE:                                       
IBM InfoSphere DataStage integrates data across multiple systems using a high performance parallel framework, and it supports extended metadata management and enterprise connectivity. The scalable platform provides more flexible integration of all types of data, including big data at rest (Hadoop-based) or in motion (stream-based), on distributed and mainframe platforms. 

HADOOP:                                     
                     Apache Hadoop is an open-source software framework that supports data-intensive distributed applications, licensed under the Apache v2 license. It supports the running of applications on large clusters of commodity hardware. Hadoop was derived from Google's MapReduce and Google File System (GFS) papers. The Hadoop framework transparently provides both reliability and data motion to applications. Hadoop implements a computational paradigm namedMapReduce,[2] where the application is divided into many small fragments of work, each of which may be executed or re-executed on any node in the cluster. In addition, it provides a distributed file system that stores data on the compute nodes, providing very high aggregate bandwidth across the cluster. Both map/reduce and the distributed file system are designed so that node failures are automatically handled by the framework.[3] It enables applications to work with thousands of computation-independent computers and petabytes of data. The entire Apache Hadoop “platform” is now commonly considered to consist of the Hadoop kernel, MapReduce and Hadoop Distributed File System (HDFS), as well as a number of related projects – including Apache Hive, Apache HBase, and others.