Category Archives: Uncategorized

Join the DBA training in Pune to make your career in DBA

In today’s E-world, DBA makes ways to store the data in an organized way and manage everything digitally.

Oracle DBA will definitely hold importance as long as databases are there. But we need to keep developing ourself and be updated with the newest technology. If you have the ability to note down the data properly and strategise your work or data in a better way, then you are the best to become a database administrator.

There are many new evolving technologies in DBA like Oracle RAC, Oracle Exadata, Golden Gate, ADM, Oracle Cloud etc. These are new places that promise growth on which you can make money. These technologies are relatively new and experienced professionals are less, which helps create many job opportunities.

Know your field of interest and start developing your skillset for a promising career in the field of DBA.

DBA training in Pune is always there for you to provide the placement as a DBA professional and we at CRB Tech have the best training facilities. We will provide you the 100% placement guaranteed.

Thus, DBA training would be the best option for you to make your career in this field .

What can be the better place than CRB Tech for DBA training in Pune?

DBA institute in Pune will help in you in understanding the basic concepts of DBA related ideas and thus improve your skills in PL/SQL queries.

CRB Tech is the best institution for DBA in Pune.

There are many institutes which offer training out of which CRB Tech stands apart and is always the best because of its 100% guaranteed placements and sophisticated training.

Reason for the best training in CRB Tech:

This has a variety of features that ensure that is the best option from among other DBA programs performed at other DBA training institutions in Pune. These are as follows:

1. You will definitely be a job holder:

We provide a very high intensive training and we also provide lots of interview calls and we make sure that you get placed before or at the end of the training or even after the training and not all the institutes provide such guarantees.

2. What is our placement record?

Our candidates are successfully placed in IBM, Max secure, Mind gate, saturn Infotech and if you refer the statistics of the number of students placed it is 100%

3. Ocean of job opportunities

We have lots of connections with various MNCs and we will provide you life time support to build your career.

4.LOI (Letter of intent):

LOI is offered by the hiring company at the starting itself and it stands for Letter Of Intent and after getting that, you will get the job at the end of the training or even before the training ends.

5. Foreign Language training:

German language training will help you while getting a job overseas in a country like Germany.

6.Interview calls:

We provide unlimited interview calls until the candidate gets placed and even after he/she gets placed he/she can still seek help from us for better job offers. So dont hesitate to join the DBA training in Pune.

7.Company environment

We provide corporate oriented infrastructure and it is in such a way that the candidates in the training will actually be working on the real time projects. Thus it will be useful for the candidate once he/she get placed. We also provide sophisticated lab facilities with all the latest DBA related software installed.

8.Prime Focus on market based training:

The main focus over here is dependent on the current industry related environment. So we provide such training in your training days. So that it will be easier for you to join the DBA jobs.

9.Emphasis on technical knowledge:

To be a successful DBA, you should be well aware of all the technical stuffs and the various concepts of SQL programming and our DBA training institutes have very good faculties who teach you all the technical concepts

Duration and payment assistance:

The duration of the training at our DBA institution in Pune is for

4 months.

The DBA sessions in Pune run for 7-8 hours on Monday to Friday.

Talking about the financial options:

Loan options:

Loan and installment choices are made available for expenses of charges.

Credit Card:

Students can opt the option of EMI transaction on their bank cards.

Cash payment:

Fees can also be paid in cash choices.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

AWS Lambda

There are lots of people who are still not aware of the importance of Lambda and its purpose. In a new era of application development, it could assist in a new era of application development and cloud-based hosting. It might also out number one of Amazon’s core cloud services: Amazon machines.

  • Explain Lambda?

Your code can run without managing servers or provisioning with the help of AWS Lambda. The Lambda product page is stated by AWS. An event-driven computing platform is the other purpose of Lambda; when initiated by an event, Lambda actually runs and executes the code that is loaded into the system.

Every time an image is uploaded to the Amazon Simple Storage Service (S3) there will be an automatic resize of the image with the help of Lambda function, for instance. The Lambda function is triggered by the event with the file being uploaded to S3. The function of resizing the image is executed by the Lambda.

Customers only respond to the service when functions are executed. AWS is paid by the Seattle Times when an image has been resized.

Even in analytics, Lambda can be helpful and an online order is kept on Zillow with an entry into the Amazon DynamoDB NoSQL database. A Lambda function is triggered by the entry into the database triggers to load the order information present in the Amazon Redshift which is actually a data warehouse. Above the data stored in Redshift, analytics programs can actually run on.

The developer wants to target at first with a specific category of usage on including the functionality of their application and they are not aware or tensed about scaling up and down (infrastructure). Developers are well answered by Lambda who are seeking for such a particular target.

Lambda has their own versions with respect to Amazon competitors.Functions are present in Google and a platform named Microsoft and OpenWhisk termed after IBM is released currently with Azure Functions.

In the cloud, it is a trendy new platform but Amazon is celebrated as the first to market when it unveiled Lambda as it’s re: Invent conference in 2014.

Lambda is used internally by Amazon. For AWS’s, Lambda is the compute platform for the Internet of Things service and the Amazon Echo. Events of Amazon CloudWatch permits the users to automatically trigger a group of an Amazon Elastic Compute Cloud (EC2) virtual machine instance while it has failed.

Maybe the most fascinating about Lambda is that it could be a problem to one of Amazon’s famous service: EC2 is the virtual machine service. On Lambda functions, developers can construct apps rather than spinning up EC2 Vms.

  • AWS Lambda Limitations

For running continuous applications, serverless architecture is not that effective for containers or EC 2 which are appropriate. Lambda function deployment package size is another significant limit which is almost 50 MB and the non-persistent scratch area present for the function to use 500 MB.

AWS Lambda Cold start is the significant issue for consideration and it takes few of the time for Lambda function to handle a request at first as it has to initiate a new instance of the function.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.


Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

Data Democratization

The concept of digital information over here is data democratization that must be easily comprehended by a layman especially for making decisions. In the global economy, data democratization is considered as a bigger benefit in the global economy and are appealing because the decisions are mostly data-driven.

Only corporations and corporate data can make use of the broad access. There are lots of articles on data democratization for rapidly moving the statements permission to a narrower focus on company start-ups.

This actually explains a limited scope for data democratization with limited scope inside the public domain and is apt only for the private sector organizations.

Currently, we are projecting widening of the data democratization via the rise of user-friendly public data which offers content via programs like OpenNASA for NASA’s open data, code, and APIS for tracking the public data usage and citizen data scientists.

  • Barriers to Data Democratization

The reason behind by most of the organizations are open to democratizing their data presently is for current barriers which removed or significantly decreased. Let us see a few of them:

  • Data Silos: Currently there has been an enhancement in the present years the splitting of data silos in the company actually exists. To those executives who actually need to handle the business and data specialists the data must be the only accessibility with the executives who were actually meant to obtain and check the data and then feedback to the management. If you ponder about abstracting the complete use of the data then it requires being used by all. On the contrary, if only one business can use it then it will act as a block for your organization.
  • Fear: There is a continuous fear of handling the data when it’s actually used by lots of people. A bigger group access is permitted by the data for security concerns. It is not just limited to how the people would use and explain the data was prevalent and blocked in the previous adoption.
  • Data Democratization Possible Due to Tech and Tools

There is a huge people who can test and develop lots business action from data that is important for gaining a competing platform at your business and see the big picture and in other occasions could help in its existence. Here are few tech solutions for making the data democratization possible:

  • Virtualization: For an application, the data virtualization makes it possible for an application to remove and change the data without the knowledge of technical details.
  • Data federation software: The metadata is compiled by this software from lots of data sources into a virtual database for analyzing it.
  • Cloud Storage: There has been an instrumentation of adoption for cloud storage in splitting the data silos for making a central repository for data.

Self-service BI applications: Non-technical users are offered with the tools for making the data analysis simpler than it can be understood.

  • Pros of Conservative democratization

High-quality insights are produced by dedicated resources which generally employ bigger scrutiny of making recommendations often analyzing a problem with various data sets and advanced modeling.

Over potentially risky data there is a tighter control with confidential records, profiles, and information for offering the organization a distinct competitive or reputational advantage.

Data stewardship happens due to the subject matter expertise.

In the team, the business value is easily exhibited.

Less time is spent by the stakeholders for churning by analyzing the data and more time is required for testing the theories and implementing the optimizations.

  • Consequences of being Conservative:

The ability is lacked by the organizations with lower insights to ask the business questions for affecting the positive change.

On prioritization and conversations, the execution of analysis actually relies on creating fiction.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

Microsoft Azure Stack

The release of Microsoft’s Azure Stack version will be significant for networking and data center pros from one simple excuse: It provides customers for a way to provide famous and known cloud platform without giving away the data which is sensitive into a multi-tenant environment.

With the help of Microsoft, Azure Stack is a software that has been assessed for running on a group of partners who are known for looking and feeling similar to Azure public cloud. Apart from that a common management platform between the public and private cloud is significant for another reason as well which is the biggest public cloud contest of Microsoft.

The first of the three major IaaS vendors is Microsoft, Google Cloud Platform and Amazon Web Services for offering a hybrid cloud comprising of on-premises software or hardware bundle that runs in the same software management tool.

In 2015, after the plans of Azure Stack was declared, for the purpose of ordering, Microsoft this week declared the offering with shipping expectation by this fall.

  • Use cases

In the Microsoft Portfolio, this is regarded as Gartner VP and Distinguished Analyst Lydia Leong as it is not right for every customer. In the dynamics of the IaaS market, there is no fundamental game changer in this dynamics. For compelling the Microsoft-centric organizations to use Azure by Microsoft centric organizations.

The customers will be beneficial by long who want to use Azure but there are reasons for data sensitivity, regulations or location of data to prevent them from using the public cloud.

They are not ready for a public cloud if the customer has sensitive data and they will deploy Azure Stack behind their firewall process data for relatively interacting in a simple way with applications and data in the public cloud.

An edge of the Azure public cloud is none other than Azure Stack. For instance, The ship will not be conflicted by the Carnival Cruise Lines which is regarded as the former user of the Azure Stack. As a private cloud Azure Stack can be used in the center of the ocean and in the port the Azure public cloud will be uploaded with data from the ship for the purpose of processing.

An app which is shifting to the public cloud has a limiting factor, but rather the data app requires it. The customers can extract data from the cloud with the help of Azure Stack and it permits the users for running an Azure front-end for accessing sensitive back-end data.

  • What’s Inside Azure Stack

There are basically two components of Azure Stack and they are the basis for infrastructure that the customers want to buy from one of the Microsoft’s certified partners and software that is certified by Microsoft.

IaaS functions which are basic is included in the software for making up the cloud like storage, virtual machines, and virtual networking. There are few platform-as-a-service (PaaS) in the Azure Stack application development features like the Azure Container Service and Mircosoft’s Azure Functions computing software along with SQL Server and MySQL support. For user authorization, it comes along with Azure Active Directory.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.


Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr


A portion of was at the least known as Amazon Web Services (AWS). In the nine-year history of Amazon, this year was the first time which unveiled its revenue figures and the numbers were quite shocking. 1.5 billion dollars were bought by AWS which grew up to 1.8 billion and 2 billion dollars in the third quarter. Explain AWS and its profit and success for Amazon

  • Explain AWS?

There are different cloud computing products and services made in AWS. Storage, servers, remote computing, networking, mobile development, email, and security are the divisions of highly profitable Amazon division. There are two main products of AWS: EC2, and S3, Amazon’s storage system. In the computing world, AWS is very big and present and is now 10 times the size of the competitor.

There are 12 global regions of AWS which has lots of available zones which are located in servers. Here are few serviced regions which are divided for allowing the users to get geographical limits on the services and they also offer the diversifying locations in data that is held.

  • Cost Savings

Earlier there were self-made power plants built for factory requiring the electricity after the factories received the electricity from a public utility there is a requirement for buying the electricity the costlier electric plants which are private has been subsided. The companies are moved away by AWS from physical computing technology on the cloud.

Mostly the companies seeking big amounts of storage must need the physical build for storage space and handle it. It is quite costly for storing on a cloud for a big amount of storage space that is possible for the company to grow into. Too less storage that is constructed or bought would be dangerous if a business is taken off and is costly if it didn’t work.

This is the same thing which implies for the computing power. Surge traffic experiences from the companies would lead to buying loads of power for sustaining the business during high times.

What is actually in use is what the company actually wants. For building a storage system there was no requirement of upfront and they need to estimate the usage. Their requirement is used by the AWS customers and their costs are scaled on an automatic basis.

  • Scalable and Adaptable

As the cost of AWS is modified it depends on the customer’s usage, small businesses and start-ups for seeing the obvious benefits with the help of Amazon for their computing needs. For building a business, AWS is awesome from the bottom as it offers the tools required for companies to start up with the cloud. From the companies that are existing are offered by Amazon for low-cost migration services that your existing infrastructure can be moved seamlessly to AWS.

As there is a growth in the company, the AWS offers resources for help in expansion and the business model permits for flexible usage and the customers will never require the speed time thinking about whether or not they require to reexamine the computing usage. Apart from budgetary reasons the companies could actually set and forget all the computing needs.

  • Security and Reliability

When compared to a company hosting, AWS is quite secure. AWS has lots of data centers in the world and continuously checked and strictly maintained. A disaster striking is ensured because of the diversification of one region does not lead to the loss of data in the long run globally. Just consider if Netflix has all the personnel files their content and data that is saved on the site during a disaster. It would be silly.

Moreover, if the natural disaster occurs and destroys everything then it is better to localize the data in an easy location where lots of people can realistically obtain access. The data centers are hidden from locating them and following the access only on the essential basis. The data centers and the data present are safe from intrusions and the Amazon’s experience in cloud services, potential attacks and outages can be quickly identified and easily rectified throughout the day. For a small company, the same cannot be said and is handled by a single IT guy working out of a large office.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

Overview of Rackspace

A big and a triumph hosting provider called as Rackspace have their share of data center problems in the ancient days and have lots of happy customers now. Hyperscale providers have one of them called as Rackspace along with Microsoft, Google, and Facebook. It is a familiar fact that Rackspace is not the biggest and AWS is. There are lots of data centers which handles the army of engineers, operators, and sysadmins for the customers around the globe.

  • The Rackspace Edge

In the cloud computing world all the big players offer quick access, utility-style bills, and customer self-service. The cloud club membership is qualified by those and not the differentiators. Explain the benefits Rackspace has to provide and are different from other big players.

The benefits offered are quite clear among the Rackspace people and they have a strong marketing department for making sure of the message that appears across loud and clear.

  • Fanatical Support

The fanatical support angle is pushed by the Rackspace and you cannot move the mouse on website inside a chat window pop up prompting you can explain tot heir support staff. Humans constructed the computer systems which are most complicated machines. If the organizations are left in the dark then the systems just fall away and there is nothing which stirs the organization with fear.

Fanatical support is registered the Rackspace and there are little variants like trademarks and considering it the main pillar of the complete business.

  • OpenStack

The OpenStack cloud management platform project has been thrown away by Rackspace. HP, Rackspace, and NASA are some of the kingplayers apps inside the data centers. An open source project with OpenStack development is leading to a new business ecosystem forming around it. A new business ecosystem is the lead of the development of OpenStack project. In its ancient days, it was regarded as a baby project and it has good talent to develop. They save a lot of time for the coders.

  • Interoperability

There is no venturing of the relationship is ensured by interoperability and there will not be an easier way to escape. For chopping and changing between cloud providers, interoperability is the ability of it.

In terms of marketing, the FUD has been mostly used. IBM was advertising in the 1990s and the exclusive power of AIX OS is Sun marketed in Java and is also called as a write once and run anywhere.

Mostly interoperability is the best and the cloud computing is still a baby offering stable interfaces to build on and there are lots of change occurring. Lots of interoperability is possible due to OpenStack and it helps in the information required to get the job done in the public domain instead of company secrets.

  • Here Are Few Things It Will Allow:

-Data between cloud storage offerers are transferred automatically and seamlessly.

-Across cloud computing providers, spread the workload.

-From one platform, take your custom code and run it on another and there is no    need for an expensive migration project or support contract.

  • Infrastructure Test Drive

If my organization’s needs are met with few cloud provider then it is not possible to be upfront. A good knowledgeable decision cannot be made and it is one way to find out for sure. Just join Rackspace and run up a few test services and find out feels.

In the IT world, the test-driving infrastructure is not possible and it is not going to convince IBM for driving a truck with various computers and software and install prospective software and install prospective customer play.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.


Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

Best Useful Cloud Databases That You Need To Know

  • EnterpriseDB

PostgreSQL databases are the open source software and are targetted by EnterpriseDB but its actual to claim the fame of the capacity to work with Oracle database applications. There is a possibility by the organizations for using the applications written in on-premise Oracle databases via EnterpriseDB and it runs in cloud with Amazon Web Services and HP. There are scheduled backups and binary replication too.

  • Garantia Data

For running open source Redis and Memcached in-memory and Garantia offers a gateway service for its users. With the help of Garantia’s software, the automatic configuration of the open source data platforms assists the developer’s scale nodes for creating clusters and architect.

  • Google Cloud SQL

Two major products are the basis for Google’s cloud database service: Google Cloud SQL which is explained by Google as a MySQL-like fully relational database infrastructure, and Google BigQuery, an analysis tool to run the queries on big data sets stored in the cloud.

  • Microsoft Azure

SQL server technology is used by the Microsoft for offering a relational database for permitting the customers to access an SQL database on its cloud or SQL server instances for virtual machines. Hybrid databases are emphasized by the Microsoft for combining the data both on a customer’s premise and Azure cloud via SQL Data Sync.

  • MongoLab

There are various database platforms for choosing the NoSQL World like MongoDB. For accessing MongoDB its users are given permission on lots of major cloud providers along with AWS, Joyent, and Azure. MongoDB also combines with lots of platform as a Service (PaaS) tools at the application tier. Dedicated or shared environments are used for MongoLab to run and the shared one is quite costly.

  • Rackspace

In a cloud or a managed hosted database, Rackspace offers cloud databases for its product. The container-based virtualization is the emphasizes for Rackspace because of its cloud databases as it permits the higher performance of the database service when thought about the run on virtualized infrastructure. A SAN storage network is incorporated into the cloud databases and it depends on an OpenStack platform. Currently, a NoSQL database is declared by the Rackspace in the cloud from provider Cloudant.

  • SAP

The SAP is an enterprise software giant for playing the cloud with HANA which is a platform constructed on an in-memory technology. The company is complemented by the cloud database from HANA complements other on-premise database tools along with Sybase and is present in Amazon Web Services cloud. There are other non-database apps too for HANA along with the business management tools and application development.

  • StormDB

In the cloud, there is various database that runs in the fully distributed relational database for machine virtualization. For better performance, the StormDB officials claim the leads and are simply managed due as they don’t have to choose the size of the virtual machine and their database to run on. Although it is run on bare metal, the customers share the clusters of servers via StormDB and it promises the isolation among customer databases.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.


Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

NuoDB A Cloud Database

  • NuoDB

A client or a cloud relational database technology also called as NuoDB is SQL compliant and it has been called NewSQL. In the cloud, it has a distributed object architecture that it can work with. The term emergent architecture is the term used by NuoDB for their database and it implies that a new server is included for scaling up the database and it runs faster. Amongst lots of processors, the NuoDB database distributes the tasks for avoiding bottlenecks of data. A peer to peer messaging is used and it is ACID compliant.

A tiered approach is used by the database and it comprises of various redundant tiers of transaction engines (TE) and storage managers (SM). The data predictably can be approached by its assistance in the cloud. There are lots of NuoDB domains with various redundant Tes and Sms for running on the similar platform. There are various types of NuoDB working on various platforms like Mac OS, Windows, Solaris, x86, and JoyentCloud.

  • Uses of NuoDB

  1. Mobile Applications

There are lots of times various mobile apps are downloaded. For scaling out various requirements of the cloud-based mobile app due to the web service provider’s meter which runs at most of the time. Elastic scalability is provided by NuoDB at lots of transactions per second with less administration.

  1. Web-Scale Applications

Developers must get to know better beforehand about their applications release. It is possible for another major app better than Facebook. All the elastic-scale out is given to them by NuodB and they might mostly require integrated safety and awareness of SQL/ACID.

  1. Multi-Tenant Solutions

For hosting lots of databases there is a requirement for Internet Service Providers which is efficient while keeping all the customer’s database isolated from each other. True multi-tenancy is offered by NuoDB at cheap cost and has been deployed on lots of servers.

  1. Saas Solutions

There are lots of providers of SaaS and ISVs that are successful and have sharded, tuned and replicated making sure of high performance and zero downtime. There is no need for sharding, replication or various performance works in NuoDB.

  • Disadvantage of SQL over NuoDB?

SQL is regarded as a relation-based data model in the world of data and it mostly means for retrieving and changing the data. This is mostly used and has clauses, predicates, expressions, and queries in an SQL data management system for making it famous and user-friendly. This transactional data provides tough limitations like:

When Big Amount of Data is Used

  • For multi-table data graph, mostly incorrect SQLs are developed

  • Lots of your storage is occupied and therefore data repetition happens.

  • There is no possibility to use DML operations.

  • The view seems to be inactive because of the lack of a table.

  • There is no feature of elasticity present over here.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr

Google’s Cloud Spanner

The beat launch of Cloud Spanner was declared today by Google and it is a new globally distributed database service for the purpose of mission applications. There are other cloud-based database services that are joined by Cloud Spannerlike Cloud SQL, Bigtable and the Cloud Datastore but with the main difference of providing developers the best relational databases and NoSQL databases and it is transactional with easier scalability. Cloud Spanner is another solution for developers who are striking the limits of cultural relational databases like PostgreSQL or MySQL.

Google usage of this version internally is the reason behind the name Cloud Spanner and a paper was published in the year 2012. In the year 2007, Google started working on Spanner just to search for an alternative to MySQL which ran lots of company products.

Spanner is the basis for various application of Google like Google Photos and many Google’s mission-critical applications. This same database service is made by Google to be available to outside developers with Cloud Spanner.

All the developers are to be assisted to take the knowledge in composing SQL-based applications and permit them to take that to a new database service that uses the SQL syntax and provides ACID transactions and apart from that there are other benefits of modern NoSQL database combined with the scalability kind and global network that Google needs to run its products.

  • Spanner is not a complaint of MySQL or ANSI SQL and there is no such plan

Moving workloads from MySQL is the target for Google’s Spanner and is the biggest interest and use case. Most of them felt bad about the lack of MySQL support both in the present and in the Spanner roadmap. There is a need for more pressure from MySQL to migrate or move a workload and for ensuring a performant implementation.

  • Full RDBMS functionalities are not offered by Cloud Spanner similar to referential integrity.

A parent or child relationship is needed by the Spanner when designing your data model to define at the table level. It is said that in other places this is by choice. There is no referential integrity performed on an automatic basis if you do not define tables as interleaved. If you later believe that you change the table into a child then you are going to have a drop or recreate the table.

  • The online schema does not offer cloud spanner for changing the keys.

Drop and replace of the table will be present in you and this happens when you need to change the PK of your table. This implies that you need to pause your workload and it means to take a downtime. And you need to understand why you want to change the table’s PL? In bold or all caps and red the spanner documentation is highlighted.

  • Index choosing is difficult when cloud spanning comes into the picture and it recommends using FORCE_INDEX directives in your code.

SQL operation is done from SQL to Google’s APIs and the efforts of the application programmer will have to be supported by data architects and they are people who are aware of both design around the limits of Spanner along with neglecting Spanner-specific anti-patterns which reduce performance.

This implies changing Pks to hashes and taking away auto-increment and correctly assigning parent/child data relationships as interleaved tables and interleaving needed indexes along with design time.

Join DBA Course to learn more about other technologies and tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr


  • Define SAP ERP

For the purpose of making enterprise resource planning (ERP), a German multinational software company is used which is called as SAP. For managing business operations, organizations permit ERP software and usually means to suit modular applications for collecting and integrating data from various aspects of the business. For Erp software, there is only one provider called SAP. There are other providers like Microsoft, Oracle, Epicor, and Infor Orbis.

For the purpose of enterprise management, here is a basic overview of SAP’s modules implementation methods and here it stands against the competitors.

  • SAP’s Enterprise Resource Planning Modules

When neatly integrated ERP software comes into the picture, SAP becomes the prime leader and there are lots of departmental applications work symphonically. SAP offers industry-specific add-on solutions is beyond its basic models. There are lots of modules present in the SAP ERP and the main categories are:

  • Accounting:

Finance (FI)

Investment Management (IM)

Project Systems (PS)

Controlling (CO)

Financial Supply Chain Management (FSCM)

  • Logistics

Material Management (MM)

Sales and Distribution (SD)

Logistics Execution (LO)

Warehouse Management (WM)

Plant Maintenance (PM)

Quality Management (QM)

Production planning (PP)

Environment, Health, and Safety (EH&S)

  • Human Resources

Organization Management (HR-OM)

Payroll (HR-PY)

Training and Event Management (HR-TE)

Learning Solutions (HR-LSO)

Compensation (HR-CM)

Enterprise Compensation (HR-ECM)

Benefits (HR-BN)

Recruitment (HR-PB)

Loan (HR-LN)

Advance Business Application Programming (HR-ABAP)

  • Technology

Cross-Application (CA), includes classification systems and workflow

Basic Components (BC or BASIS)

Programming (ABAP)

Security and Authorizations

  • Other Modules (requiring separate installation)

Business Warehouse (BW)

Business Intelligence (BI)

International Demonstration and Education System (IDES)

Customer Relationship Management (CRM)

Master Data Management (MDM)

Supplier Relationship Management (SRM)

Exchange Infrastructure (XI)

Process Integration (PI)

Global Trade Services (GTS)

Strategic Enterprise Management (SEM)

Corporate Finance Management (CFM)

There are some modules in Finance and Investment Management and can be classified as Receivable or Accounts payable, Investment Support or Investment Orders. There are industry requirements and business operations for finding the modules actually needed. Sales and Distribution, finance, controlling, Human Resources, Material Management are few of the most significant sub-modules in SAP. Organizational needs are the basis for a client to buy the modules requirement. For instance, an SD, FI and MM modules can be bought by a client only without buying HR and CO modules.

  • SAP History

Five-ex employees of IBM developed SAP and it was developed in the year 1972 and is a small software company in Germany with just one client. Systems, Applications, and Products is the full form of SAP. The ultimate goal of its founders is to process the data when a user actually needs it, instead of overnight batches with reference to the earlier software. IBM’s punch-card data storage was changed to make their first product and it stores data on a mechanical basis and needed overnight processing. Imperial Chemical Industries German branch is the client of SAP and for them, they developed a real time payroll and punch-card system in the year 1972.

R/2 was the actual version of SAP’s ERP and named for its real-time architecture and two servers. After sometime it was name was changed to R/3 for three servers called as production server, application server and database server. The latest version of SAP was released in the year 2006, ECC6.0 and in the year 2013 an Enhancement Package (EHP7) was unveiled.

All department of organizations is handled by the ERP system called as SAP. An organizations’ Finance, Human Resource, Controlling, Research and many other departments are handled by SAP. A special industry-specific solution is present in SAP for almost various industries like Pharmaceuticals, manufacturing, Security, Insurance, Treas, Finance, etc.

There are lots of significant modules like SAP, SD, FICO, and HR. Finance and controlling respectively are controlled by Fi and CO. HR controls Human Resource departments and sales are controlled by SD. MM, SD, PS and HR modules are connected with FICO which is a base module.

Join DBA Course to learn more about other Database and Analytics Tools.

Stay connected to CRB Tech for more technical optimization and other updates and information.

Don't be shellfish...Digg thisBuffer this pageEmail this to someoneShare on FacebookShare on Google+Pin on PinterestShare on StumbleUponShare on LinkedInTweet about this on TwitterPrint this pageShare on RedditShare on Tumblr