Forwarded from Deleted Account
For which projects did use NoSQL databases and for what kind of problems?
It is hardly possible to name a project for which a NoSQL database would be useless, except for a blog or a home page. As the main use cases for NoSQL stores I would mention the following tasks:
● collecting and analyzing large volumes of data
● scaling large historical databases
● building interactive applications for which performance and fast response time to users’ actions are crucial
The major “drawback” of NoSQL architecture is the absence of ACID engine that provides a verification of transaction. It means that financial operations or user registration should be better performed by RDBMS like Oracle or MS SQL. However, absence of ACID allows for significant acceleration and decentralization of NoSQL databases which are their major advantages. The bottom line, non-relational databases are much faster in general, and they pay for it with a fraction of their reliability. Is it a good tradeoff? Depends on the task.
It is hardly possible to name a project for which a NoSQL database would be useless, except for a blog or a home page. As the main use cases for NoSQL stores I would mention the following tasks:
● collecting and analyzing large volumes of data
● scaling large historical databases
● building interactive applications for which performance and fast response time to users’ actions are crucial
The major “drawback” of NoSQL architecture is the absence of ACID engine that provides a verification of transaction. It means that financial operations or user registration should be better performed by RDBMS like Oracle or MS SQL. However, absence of ACID allows for significant acceleration and decentralization of NoSQL databases which are their major advantages. The bottom line, non-relational databases are much faster in general, and they pay for it with a fraction of their reliability. Is it a good tradeoff? Depends on the task.
Forwarded from Deleted Account
Data Warehouse vs Big “Data Lake”. What are the similarities and what are the differences?
Even though Big “Data Lake” is a metaphor, I do not really like it.
This name highlights that it is something limited, isolated from other systems. I would better call this concept a “Big Data Ocean”, because the data added to the system can interact with the surrounding systems. In my opinion, data warehouses are a bit outdated. At the earlier stage, such systems enabled companies to aggregate a lot of data in one central storage and arrange this data. All this was done with the acceptable speed. Now there are a lot of cheap storage solutions, so we can keep enormous volumes of data and process it much faster than with data warehouses.
The possibility to store large volumes of data is a common feature of data warehouses and a Big “Data Lake”. With a flexible architectures and broad capabilities for data analysis and discovery, a Big “Data Lake” provides a wider range of business opportunities. A modern company should adjust to changes very fast. The structure that was good yesterday may become a limitation today.
Even though Big “Data Lake” is a metaphor, I do not really like it.
This name highlights that it is something limited, isolated from other systems. I would better call this concept a “Big Data Ocean”, because the data added to the system can interact with the surrounding systems. In my opinion, data warehouses are a bit outdated. At the earlier stage, such systems enabled companies to aggregate a lot of data in one central storage and arrange this data. All this was done with the acceptable speed. Now there are a lot of cheap storage solutions, so we can keep enormous volumes of data and process it much faster than with data warehouses.
The possibility to store large volumes of data is a common feature of data warehouses and a Big “Data Lake”. With a flexible architectures and broad capabilities for data analysis and discovery, a Big “Data Lake” provides a wider range of business opportunities. A modern company should adjust to changes very fast. The structure that was good yesterday may become a limitation today.
Forwarded from Sayeh Faramarzii
هوش کسب و کار، عنصر فراموش شده در استراتژی CRM
اگر شما از شرکت هایی هستید که بر روی مدیریت ارتباط با مشتری (CRM) سرمایه گذاری کرده اید، حتماً دارای خدمات، برنامه های کاربردی و اطلاعات یکپارچه ای برای توانمندسازی رفتار مشتری-محور در سازمان هستید .
اگر جزو 65 تا 80 درصد از شرکت هایی هستید که معتقدید سرمایه گذاری شما بر روی CRM انتظارات شما را براورده نساخته است، بخش کلیدی راه حل را از دست داده اید : «یک فرایند هوش کسب و کار»
💥 فرایندی که موجب تغییرات اساسی شود .
پیچیدگی و تعداد تصمیم های کسب و کار به طور روز افزون در حال افزایش است . مشتریان امروزه انتظارات سطح بالاتری از سازمان دارند و در عین حال با چالش های فنی و کاری بیشتری در ارتباط گیری با سازمان شما مواجه می شوند.
در این میان، 🎯 رویکردهای تحلیلی (Analytics) و هوش کسب و کار نقش تعیین کننده ای در استراتژی های جامع سازمان ایفا خواهند کرد.
اگر شما از شرکت هایی هستید که بر روی مدیریت ارتباط با مشتری (CRM) سرمایه گذاری کرده اید، حتماً دارای خدمات، برنامه های کاربردی و اطلاعات یکپارچه ای برای توانمندسازی رفتار مشتری-محور در سازمان هستید .
اگر جزو 65 تا 80 درصد از شرکت هایی هستید که معتقدید سرمایه گذاری شما بر روی CRM انتظارات شما را براورده نساخته است، بخش کلیدی راه حل را از دست داده اید : «یک فرایند هوش کسب و کار»
💥 فرایندی که موجب تغییرات اساسی شود .
پیچیدگی و تعداد تصمیم های کسب و کار به طور روز افزون در حال افزایش است . مشتریان امروزه انتظارات سطح بالاتری از سازمان دارند و در عین حال با چالش های فنی و کاری بیشتری در ارتباط گیری با سازمان شما مواجه می شوند.
در این میان، 🎯 رویکردهای تحلیلی (Analytics) و هوش کسب و کار نقش تعیین کننده ای در استراتژی های جامع سازمان ایفا خواهند کرد.
Forwarded from Deleted Account
Does my ODI infrastructure require an Oracle database?
No, the ODI modular repositories (Master + and one of multiple Work repositories) can be installed on any database engine that supports ANSI ISO 89 syntax such as Oracle, Microsoft SQL Server, Sybase AS Enterprise, IBM DB2 UDB, IBM DB2/40.
No, the ODI modular repositories (Master + and one of multiple Work repositories) can be installed on any database engine that supports ANSI ISO 89 syntax such as Oracle, Microsoft SQL Server, Sybase AS Enterprise, IBM DB2 UDB, IBM DB2/40.
Forwarded from Deleted Account
Does ODI support web services?
Yes, ODI is ‘SOA’ enabled and its web services can be used in 3 ways:
The Oracle Data Integrator Public Web Service, that lets you execute a scenario (a published package) from a web service call
Data Services, which provide a web service over an ODI data store (i.e. a table, view or other data source registered in ODI)
The ODIInvokeWebService tool that you can add to a package to request a response from a web service
Yes, ODI is ‘SOA’ enabled and its web services can be used in 3 ways:
The Oracle Data Integrator Public Web Service, that lets you execute a scenario (a published package) from a web service call
Data Services, which provide a web service over an ODI data store (i.e. a table, view or other data source registered in ODI)
The ODIInvokeWebService tool that you can add to a package to request a response from a web service
Forwarded from Deleted Account
Is ODI Used by Oracle in their products?
Yes there are many Oracle products that utilise ODI, but here are just a few:
Oracle Application Integration Architecture (AIA)
Oracle Agile products
Oracle Hyperion Financial Management
Oracle Hyperion Planning
Oracle Fusion Governance, Risk & Compliance
Oracle Business Activity Monitoring
Oracle BI Applications also uses ODI as its core ETL tool in place of Informatica , but only for one release of OBIA and when using a certain source system.
Yes there are many Oracle products that utilise ODI, but here are just a few:
Oracle Application Integration Architecture (AIA)
Oracle Agile products
Oracle Hyperion Financial Management
Oracle Hyperion Planning
Oracle Fusion Governance, Risk & Compliance
Oracle Business Activity Monitoring
Oracle BI Applications also uses ODI as its core ETL tool in place of Informatica , but only for one release of OBIA and when using a certain source system.
Forwarded from Deleted Account
How will you bring in files from remote locations?
We will invoke the Service knowledge module in ODI,this will help us to accesses data thought a web service.
We will invoke the Service knowledge module in ODI,this will help us to accesses data thought a web service.
Forwarded from Deleted Account
What are the prime responsibilities of Data Integration Administrator?
Scheduling and executing the batch jobs.
Configuring, starting and stopping the real-time services
Adapters configuration and managing them.
Repository usage, Job Server configuration.
Access Server configuration.
Batch job publishing.
Real-time services publishing through web services.
Scheduling and executing the batch jobs.
Configuring, starting and stopping the real-time services
Adapters configuration and managing them.
Repository usage, Job Server configuration.
Access Server configuration.
Batch job publishing.
Real-time services publishing through web services.
Oracle Database 12c DBA Handbook.pdf
17.5 MB
@BIMining 12C کتاب اوراکل