关于hana环境下，升级、bw、abap若干问题
1. 基于HANA数据库 ERP中，ABAP开发与传统的有哪些区别？迁移或升级后，其工作量有多少？
2. 基于HANA数据库BW中，建模与传统建模有哪些区别？如果已经在传统的BW中做了建模，迁移或升级到HANA之后，这些模型是否需要重新创建？工作量有多大？
3. 对于HANA与传统ABAP、BW开发或建模的性能对比。
4. HANA实施后，在运维中ABAP开发和建模需要注意哪些？
2. 基于HANA数据库BW中，建模与传统建模有哪些区别？如果已经在传统的BW中做了建模，迁移或升级到HANA之后，这些模型是否需要重新创建？工作量有多大？
3. 对于HANA与传统ABAP、BW开发或建模的性能对比。
4. HANA实施后，在运维中ABAP开发和建模需要注意哪些？
附件：
SAP hana FAQs.pdf (252.3 KB)
6同行回答
FYI, Question 2. When the Application Server ABAP is using SAP HANA as primary database, what changes andwhat doesn’t?
Answer - The main server architecture, operations concepts and development infrastructure of the AS ABAP
remain the same when using SAP HANA as primary database. In particular, SAP HANA is used as a
full-fletched relational database which is optimized for transactional (OLTP) and analytical (OLAP)
processing. Even though the used data (tables/columns) is loaded into main memory, the data is
also available on disk allowing e.g. full backup and recovery.
On the other hand, SAP HANA offers unprecedented opportunities for extension and innovation such
using integrated data mining and predictive analysis for gaining new business insights. These can be
used based on existing and new data models (like provided via SAP HANA Live ) e.g. for operational
reporting scenarios and smart business applications.
3. Is it required to rewrite existing custom ABAP developments on SAP HANA?
No, existing ABAP code using standard database access via Open SQL runs on SAP HANA without
modifications. However, there are some considerations for custom ABAP developments which are
recommended to be taken into account during a transition to SAP HANA. Please see this document
for a summary of the available tools, services and best practices. In addition, there are opportunities
for accelerating and extending existing developments with SAP HANA.
DEVELOPER
4. I am an ABAP developer. Can I still use my ABAP programming skills on SAP HANA?
ABAP remains a key language as many SAP business applications and custom developments are
written in ABAP. Specifically, with ABAP 7.4 there are numerous improvements to the ABAP
language, which allow writing streamlined ABAP code and benefitting from SAP HANA. In addition,
SQL and SQLScript play an important role for expressing data intensive logic and fully leveraging the
SAP HANA platform from ABAP.
5. The SAP HANA In-Memory technology uses a columnar based storage with an insert-only
approach. Do I have to adapt existing ABAP developments for this?
No, this works under the hood with immediate performance and data compression benefits. In
particular, there is no need to classify ABAP data so that it is stored In-Memory, and the ABAP
statements INSERT/UPDATE/DELETE should still be used based on the desired business
semantics. But it is also possible to exploit the SAP HA收起
Answer - The main server architecture, operations concepts and development infrastructure of the AS ABAP
remain the same when using SAP HANA as primary database. In particular, SAP HANA is used as a
full-fletched relational database which is optimized for transactional (OLTP) and analytical (OLAP)
processing. Even though the used data (tables/columns) is loaded into main memory, the data is
also available on disk allowing e.g. full backup and recovery.
On the other hand, SAP HANA offers unprecedented opportunities for extension and innovation such
using integrated data mining and predictive analysis for gaining new business insights. These can be
used based on existing and new data models (like provided via SAP HANA Live ) e.g. for operational
reporting scenarios and smart business applications.
3. Is it required to rewrite existing custom ABAP developments on SAP HANA?
No, existing ABAP code using standard database access via Open SQL runs on SAP HANA without
modifications. However, there are some considerations for custom ABAP developments which are
recommended to be taken into account during a transition to SAP HANA. Please see this document
for a summary of the available tools, services and best practices. In addition, there are opportunities
for accelerating and extending existing developments with SAP HANA.
DEVELOPER
4. I am an ABAP developer. Can I still use my ABAP programming skills on SAP HANA?
ABAP remains a key language as many SAP business applications and custom developments are
written in ABAP. Specifically, with ABAP 7.4 there are numerous improvements to the ABAP
language, which allow writing streamlined ABAP code and benefitting from SAP HANA. In addition,
SQL and SQLScript play an important role for expressing data intensive logic and fully leveraging the
SAP HANA platform from ABAP.
5. The SAP HANA In-Memory technology uses a columnar based storage with an insert-only
approach. Do I have to adapt existing ABAP developments for this?
No, this works under the hood with immediate performance and data compression benefits. In
particular, there is no need to classify ABAP data so that it is stored In-Memory, and the ABAP
statements INSERT/UPDATE/DELETE should still be used based on the desired business
semantics. But it is also possible to exploit the SAP HA收起
浏览1236
| Sorry, I have to use my poor English since the answer is too long. You can use Google to translate or post question again. Larry, please correct me if I am wrong. 1. 基于HANA数据库 ERP中，ABAP开发与传统的有哪些区别？迁移或升级后，其工作量有多少？ >> SAP keep optimizing the ABAP programs and DB tables structure so it can utilize new HANA function. SAP starting in 2012 to migrate some programs/codes to HANA running style (in-memory computing) so there are big performance improve. The program optimizing is SAP on-going project. Migration from SAP Suite or BI to HANA normally take 3-6 months for 3-5 people (basis + abap + function). You can to first upgrade your SAP system to NW 7.3 to be able to migrate to HANA. 2. 基于HANA数据库BW中，建模与传统建模有哪些区别？如果已经在传统的BW中做了建模，迁移或升级到HANA之后，这些模型是否需要重新创建？工作量有多大？ >> You asked the right question. Most of companies in US did migrate BI/BW system to HAHA first. The traditional BW cube and temp tables/cluster tables are most likely no longer needed. That's the key function for HANA, in memory computing, NO MORE waiting for loading to cube or temp table. 3. 对于HANA与传统ABAP、BW开发或建模的性能对比。 >> There is no compete. Depends on the H/W, Program and Data size. It might speed up 100 times. 4. HANA实施后，在运维中ABAP开发和建模需要注意哪些？ >> It's the same question like first question. Always try to migrate you OLD triditional R3/NW programming style to new HANA coding so you can skip indexing, searching, loading waiting time. |
浏览1223
BW ON HANA其实就是换了个数据库牌子和型号， 就应用层来讲没有变化，原来怎么建模还怎么建模收起
浏览1169